JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

Implementation Guides | 920 VMs | Schema:
920 910 812
System  Table 
Column 
Searchbeta 

JDE Ref icon of database logic symbolJDE TABLESv3Made in Britain

SAPTables.Net - the webs number one SAP Tables Definition reference

920: Top 10 requests

TablePrefixDescription
1F4211SDSales Order Detail File
2F0101ABAddress Book Master
3F4101IMItem Master
4F0911GLAccount Ledger
5F4311PDPurchase Order Detail File
6F9671SDSoftware Update Detail Table
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F0006MCBusiness Unit Master
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F76AUI46WFCERG A/R -Work File - ARG - 03B - 76A
3F4211SDSales Order Detail File
4F4101IMItem Master
5F0101ABAddress Book Master
6F0911GLAccount Ledger
7F4102IBItem Branch File
8F03B11RPCustomer Ledger
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4311PDPurchase Order Detail File
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File

60 COLUMNS | 1 INDEXES | Print definition?920 | 51X | F51X90 TABLE

51X: In-Memory Project Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F51X90X1601Column Definition TableFiles51X: In-Memory Project Management
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

SELECT X151XCOLN, X1DL01, X151XCLT, X151XCLH, X1LT, X151XHUN, X151XBDG, X151XBILL, X151XDP, X151XUOA, X151XBF, X151XFMLA, X151XFS1, X151XFS2, X151XFS3, X151XFS4, X151XFS5, X151XFS6, X151XFS7, X151XFS8, X151XFS9, X151XFS10, X151XFF1, X151XFF2, X151XFF3, X151XFF4, X151XFF5, X151XFF6, X151XFF7, X151XFF8, X151XFF9, X151XFT1, X151XFT2, X151XFT3, X151XFT4, X151XFT5, X151XFT6, X151XFT7, X151XFT8, X151XFT9, X151XFT10, X1MLTP, X1DITM, X1DCML, X1EC, X1USER, X1PID, X1JOBN, X1UPMJ, X1UPMT, X151XTM, X151XAIC, X151XDDO, X151XABC, X151XAT1, X151XAT2, X151XAT3, X151XARN, X151XAOP, X151XTCC FROM F51X90

TOP920 | 51X | F51X90 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1X151XCOLNColumn NameStringGeneric Edit60 Allow NULL? 
2X1DL01DescriptionStringGeneric Edit300 Allow NULL? 
3X151XCLTColumn TypeCharacterUDC (51X CT)10 Allow NULL? 
4X151XCLHColumn HeadingStringGeneric Edit400 Allow NULL? 
5X1LTLedger TypesStringUDC (09 LT)20 Allow NULL? 
6X151XHUNHeader Units FlagCharacterGeneric Edit10 Allow NULL? 
7X151XBDGBudget FlagCharacterUDC (51X BF)10 Allow NULL? 
8X151XBILLBilling AmountStringUDC (51X BA)20 Allow NULL? 
9X151XDPDays PriorNumericGeneric Edit20 Allow NULL? 
10X151XUOAUnits FlagCharacterCheck Box10 Allow NULL? 
11X151XBFBilling FlagCharacterGeneric Edit10 Allow NULL? 
12X151XFMLAFormulaStringGeneric Edit800 Allow NULL? 
13X151XFS1Segment 1StringGeneric Edit60 Allow NULL? 
14X151XFS2Segment 2StringGeneric Edit60 Allow NULL? 
15X151XFS3Segment 3StringGeneric Edit60 Allow NULL? 
16X151XFS4Segment 4StringGeneric Edit60 Allow NULL? 
17X151XFS5Segment 5StringGeneric Edit60 Allow NULL? 
18X151XFS6Segment 6StringGeneric Edit60 Allow NULL? 
19X151XFS7Segment 7StringGeneric Edit60 Allow NULL? 
20X151XFS8Segment 8StringGeneric Edit60 Allow NULL? 
21X151XFS9Segment 9StringGeneric Edit60 Allow NULL? 
22X151XFS10Segment 10StringGeneric Edit60 Allow NULL? 
23X151XFF1Formula Factor 1CharacterUDC (51X FF)10 Allow NULL? 
24X151XFF2Formula Factor 2CharacterUDC (51X FF)10 Allow NULL? 
25X151XFF3Formula Factor 3CharacterUDC (51X FF)10 Allow NULL? 
26X151XFF4Formula Factor 4CharacterUDC (51X FF)10 Allow NULL? 
27X151XFF5Formula Factor 5CharacterUDC (51X FF)10 Allow NULL? 
28X151XFF6Formula Factor 6CharacterUDC (51X FF)10 Allow NULL? 
29X151XFF7Formula Factor 7CharacterUDC (51X FF)10 Allow NULL? 
30X151XFF8Formula Factor 8CharacterUDC (51X FF)10 Allow NULL? 
31X151XFF9Formula Factor 9CharacterUDC (51X FF)10 Allow NULL? 
32X151XFT1Numeric Factor 1CharacterCheck Box10 Allow NULL? 
33X151XFT2Numeric Factor 2CharacterCheck Box10 Allow NULL? 
34X151XFT3Numeric Factor 3CharacterCheck Box10 Allow NULL? 
35X151XFT4Numeric Factor 4CharacterCheck Box10 Allow NULL? 
36X151XFT5Numeric Factor 5CharacterGeneric Edit10 Allow NULL? 
37X151XFT6Numeric Factor 6CharacterCheck Box10 Allow NULL? 
38X151XFT7Numeric Factor 7CharacterCheck Box10 Allow NULL? 
39X151XFT8Numeric Factor 8CharacterCheck Box10 Allow NULL? 
40X151XFT9Numeric Factor 9CharacterCheck Box10 Allow NULL? 
41X151XFT10Numeric Factor 10CharacterCheck Box10 Allow NULL? 
42X1MLTPMultiplier - ScalingNumericGeneric Edit95 Allow NULL? 
43X1DITMData Item - GlossaryStringGeneric Edit100 Allow NULL? 
44X1DCMLDecimal PositionsNumericGeneric Edit10 Allow NULL? 
45X1ECEdit CodeCharacterUDC (98 EC)10 Allow NULL? 
46X1USERUser IDStringGeneric Edit100 Allow NULL? 
47X1PIDProgram IDStringGeneric Edit100 Allow NULL? 
48X1JOBNWork Station IDStringGeneric Edit100 Allow NULL? 
49X1UPMJDate - UpdatedDateGeneric Edit60
50X1UPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
51X151XTMTotaling MethodCharacterUDC (51X TM)10 Allow NULL? 
52X151XAICAs if CurrencyCharacterCheck Box10 Allow NULL? 
53X151XDDODisplay Decimal OverrideCharacterGeneric Edit10 Allow NULL? 
54X151XABCAlert Basis ColumnStringGeneric Edit60 Allow NULL? 
55X151XAT1Level 1 ThresholdNumericGeneric Edit152 Allow NULL? 
56X151XAT2Level 2 ThresholdNumericGeneric Edit152 Allow NULL? 
57X151XAT3Level 3 ThresholdNumericGeneric Edit152 Allow NULL? 
58X151XARNAccount Range NameStringGeneric Edit60 Allow NULL? 
59X151XAOPAlert OperatorCharacterUDC (51X OP)10 Allow NULL? 
60X151XTCCThreshold Currency CodeStringGeneric Edit30 Allow NULL? 

TOP920 | 51X | F51X90 INDEXES

NumberDescription
1Column Name (Primary/Unique)
ElementAliasDescriptionSequence
151XCOLNColumn NameAscending