JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.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
6F4102IBItem Branch File
7F0411RPAccounts Payable Ledger
8F41021LIItem Location File
9F03012AICustomer Master by Line of Business
10F0006MCBusiness Unit Master

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F4311PDPurchase Order Detail File
8F03B11RPCustomer Ledger
9F0411RPAccounts Payable Ledger
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F0411RPAccounts Payable Ledger
4F4311PDPurchase Order Detail File
5F4211SDSales Order Detail File
6F42119SDSales Order History File
7F0006MCBusiness Unit Master
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

175 COLUMNS | 3 INDEXES | Print definition?920 | 51X | F51X10 TABLE

51X: In-Memory Project Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F51X10EX1753Project Advisor Console WorktableWork Files51X: 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 EXUSER, EXJOBS, EX51XRTY, EX51XTC, EX51XTCD, EXMCU, EX51XCT1, EX51XCT2, EX51XSEQ, EX51XSQT, EXCO, EXMCUS, EXDL01, EXAID, EXCRCD, EX51XZBA, EX51XHA, EX51XC01, EX51XC02, EX51XC03, EX51XC04, EX51XC05, EX51XC06, EX51XC07, EX51XC08, EX51XC09, EX51XC10, EX51XC11, EX51XC12, EX51XC13, EX51XC14, EX51XC15, EX51XC16, EX51XC17, EX51XC18, EX51XC19, EX51XC20, EX51XC21, EX51XC22, EX51XC23, EX51XC24, EX51XC25, EX51XC26, EX51XC27, EX51XC28, EX51XC29, EX51XC30, EX51XC31, EX51XC32, EX51XC33, EX51XC34, EX51XC35, EX51XC36, EX51XC37, EX51XC38, EX51XC39, EX51XC40, EXSTYL, EXPECC, EXDOCO, EXPCTN, EXCLNU, EXADDS, EXAN8O, EXAN8GCA1, EXAN8GCA2, EXAN8GCA3, EXAN8GCA4, EXAN8GCA5, EXANPA, EXCT, EXD1J, EXD2J, EXD3J, EXD4J, EXD5J, EXD6J, EXRP01, EXRP02, EXRP03, EXRP04, EXRP05, EXRP06, EXRP07, EXRP08, EXRP09, EXRP10, EXRP11, EXRP12, EXRP13, EXRP14, EXRP15, EXRP16, EXRP17, EXRP18, EXRP19, EXRP20, EXRP21, EXRP22, EXRP23, EXRP24, EXRP25, EXRP26, EXRP27, EXRP28, EXRP29, EXRP30, EXRP31, EXRP32, EXRP33, EXRP34, EXRP35, EXRP36, EXRP37, EXRP38, EXRP39, EXRP40, EXRP41, EXRP42, EXRP43, EXRP44, EXRP45, EXRP46, EXRP47, EXRP48, EXRP49, EXRP50, EX51XACD, EXLDA, EXPEC, EXUM, EXSUBA, EXR001, EXR002, EXR003, EXR004, EXR005, EXR006, EXR007, EXR008, EXR009, EXR010, EXR011, EXR012, EXR013, EXR014, EXR015, EXR016, EXR017, EXR018, EXR019, EXR020, EXR021, EXR022, EXR023, EXR024, EXR025, EXR026, EXR027, EXR028, EXR029, EXR030, EXR031, EXR032, EXR033, EXR034, EXR035, EXR036, EXR037, EXR038, EXR039, EXR040, EXR041, EXR042, EXR043 FROM F51X10

TOP920 | 51X | F51X10 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1EXUSERUser IDStringGeneric Edit100 Allow NULL? 
2EXJOBSJob NumberNumericGeneric Edit80 Allow NULL? 
3EX51XRTYPAC Record TypeCharacterGeneric Edit10 Allow NULL? 
4EX51XTCPAC Total CodeStringGeneric Edit120 Allow NULL? 
5EX51XTCDPAC Total Code DescriptionStringGeneric Edit300 Allow NULL? 
6EXMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
7EX51XCT1Cost Code OR Cost Type 1StringGeneric Edit80 Allow NULL? 
8EX51XCT2Cost Code OR Cost Type 2StringGeneric Edit80 Allow NULL? 
9EX51XSEQPAC SequenceNumericGeneric Edit150 Allow NULL? 
10EX51XSQTPAC Sequence TypeCharacterGeneric Edit10 Allow NULL? 
11EXCOCompanyStringGeneric Edit50 Allow NULL? 
12EXMCUSBusiness Unit - SubsequentStringGeneric Edit120 Allow NULL? 
13EXDL01DescriptionStringGeneric Edit300 Allow NULL? 
14EXAIDAccount IDStringGeneric Edit80 Allow NULL? 
15EXCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
16EX51XZBAZero Balance Account FlagCharacterGeneric Edit10 Allow NULL? 
17EX51XHAHeader Account FlagCharacterGeneric Edit10 Allow NULL? 
18EX51XC01PMC Amount Column 01NumericGeneric Edit150 Allow NULL? 
19EX51XC02PMC Amount Column 02NumericGeneric Edit150 Allow NULL? 
20EX51XC03PMC Amount Column 03NumericGeneric Edit150 Allow NULL? 
21EX51XC04PMC Amount Column 04NumericGeneric Edit150 Allow NULL? 
22EX51XC05PMC Amount Column 05NumericGeneric Edit150 Allow NULL? 
23EX51XC06PMC Amount Column 06NumericGeneric Edit150 Allow NULL? 
24EX51XC07PMC Amount Column 07NumericGeneric Edit150 Allow NULL? 
25EX51XC08PMC Amount Column 08NumericGeneric Edit150 Allow NULL? 
26EX51XC09PMC Amount Column 09NumericGeneric Edit150 Allow NULL? 
27EX51XC10PMC Amount Column 10NumericGeneric Edit150 Allow NULL? 
28EX51XC11PMC Amount Column 11NumericGeneric Edit150 Allow NULL? 
29EX51XC12PMC Amount Column 12NumericGeneric Edit150 Allow NULL? 
30EX51XC13PMC Amount Column 13NumericGeneric Edit150 Allow NULL? 
31EX51XC14PMC Amount Column 14NumericGeneric Edit150 Allow NULL? 
32EX51XC15PMC Amount Column 15NumericGeneric Edit150 Allow NULL? 
33EX51XC16PMC Amount Column 16NumericGeneric Edit150 Allow NULL? 
34EX51XC17PMC Amount Column 17NumericGeneric Edit150 Allow NULL? 
35EX51XC18PMC Amount Column 18NumericGeneric Edit150 Allow NULL? 
36EX51XC19PMC Amount Column 19NumericGeneric Edit150 Allow NULL? 
37EX51XC20PMC Amount Column 20NumericGeneric Edit150 Allow NULL? 
38EX51XC21PMC Amount Column 21NumericGeneric Edit150 Allow NULL? 
39EX51XC22PMC Amount Column 22NumericGeneric Edit150 Allow NULL? 
40EX51XC23PMC Amount Column 23NumericGeneric Edit150 Allow NULL? 
41EX51XC24PMC Amount Column 24NumericGeneric Edit150 Allow NULL? 
42EX51XC25PMC Amount Column 25NumericGeneric Edit150 Allow NULL? 
43EX51XC26PMC Amount Column 26NumericGeneric Edit150 Allow NULL? 
44EX51XC27PMC Amount Column 27NumericGeneric Edit150 Allow NULL? 
45EX51XC28PMC Amount Column 28NumericGeneric Edit150 Allow NULL? 
46EX51XC29PMC Amount Column 29NumericGeneric Edit150 Allow NULL? 
47EX51XC30PMC Amount Column 30NumericGeneric Edit150 Allow NULL? 
48EX51XC31PMC Amount Column 31NumericGeneric Edit150 Allow NULL? 
49EX51XC32PMC Amount Column 32NumericGeneric Edit150 Allow NULL? 
50EX51XC33PMC Amount Column 33NumericGeneric Edit150 Allow NULL? 
51EX51XC34PMC Amount Column 34NumericGeneric Edit150 Allow NULL? 
52EX51XC35PMC Amount Column 35NumericGeneric Edit150 Allow NULL? 
53EX51XC36PMC Amount Column 36NumericGeneric Edit150 Allow NULL? 
54EX51XC37PMC Amount Column 37NumericGeneric Edit150 Allow NULL? 
55EX51XC38PMC Amount Column 38NumericGeneric Edit150 Allow NULL? 
56EX51XC39PMC Amount Column 39NumericGeneric Edit150 Allow NULL? 
57EX51XC40PMC Amount Column 40NumericGeneric Edit150 Allow NULL? 
58EXSTYLBusiness Unit TypeStringUDC (00 MC)20 Allow NULL? 
59EXPECCPosting Edit - Business UnitCharacterUDC (00 PF)10 Allow NULL? 
60EXDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
61EXPCTNParent Contract NumberNumericGeneric Edit80 Allow NULL? 
62EXCLNUContract Level NumberNumericGeneric Edit80 Allow NULL? 
63EXADDSStateStringUDC (00 S)30 Allow NULL? 
64EXAN8OAddress Number - Job A/RNumericGeneric Edit80 Allow NULL? 
65EXAN8GCA1Address Number1NumericGeneric Edit80 Allow NULL? 
66EXAN8GCA2Address Number2NumericGeneric Edit80 Allow NULL? 
67EXAN8GCA3Address Number3NumericGeneric Edit80 Allow NULL? 
68EXAN8GCA4Address Number4NumericGeneric Edit80 Allow NULL? 
69EXAN8GCA5Address Number5NumericGeneric Edit80 Allow NULL? 
70EXANPASupervisorNumericGeneric Edit80 Allow NULL? 
71EXCTContract TypeStringUDC (51 CT)40 Allow NULL? 
72EXD1JDate - Planned StartDateGeneric Edit60
73EXD2JDate - Actual StartDateGeneric Edit60
74EXD3JDate - Planned CompleteDateGeneric Edit60
75EXD4JDate - Actual CompleteDateGeneric Edit60
76EXD5JDate - Other 5DateGeneric Edit60
77EXD6JDate - Other 6DateGeneric Edit60
78EXRP01DivisionStringUDC (00 01)30 Allow NULL? 
79EXRP02RegionStringUDC (00 02)30 Allow NULL? 
80EXRP03GroupStringUDC (00 03)30 Allow NULL? 
81EXRP04Branch OfficeStringUDC (00 04)30 Allow NULL? 
82EXRP05Department TypeStringUDC (00 05)30 Allow NULL? 
83EXRP06Person ResponsibleStringUDC (00 06)30 Allow NULL? 
84EXRP07Line of BusinessStringUDC (00 07)30 Allow NULL? 
85EXRP08Category Code - Business Unit 08StringUDC (00 08)30 Allow NULL? 
86EXRP09Category Code - Business Unit 09StringUDC (00 09)30 Allow NULL? 
87EXRP10Category Code - Business Unit 10StringUDC (00 10)30 Allow NULL? 
88EXRP11Category Code - Business Unit 11StringUDC (00 11)30 Allow NULL? 
89EXRP12Category Code - Business Unit 12StringUDC (00 12)30 Allow NULL? 
90EXRP13Category Code - Business Unit 13StringUDC (00 13)30 Allow NULL? 
91EXRP14Category Code - Business Unit 14StringUDC (00 14)30 Allow NULL? 
92EXRP15Category Code - Business Unit 15StringUDC (00 15)30 Allow NULL? 
93EXRP16Category Code - Business Unit 16StringUDC (00 16)30 Allow NULL? 
94EXRP17Category Code - Business Unit 17StringUDC (00 17)30 Allow NULL? 
95EXRP18Category Code - Business Unit 18StringUDC (00 18)30 Allow NULL? 
96EXRP19Category Code - Business Unit 19StringUDC (00 19)30 Allow NULL? 
97EXRP20Category Code - Business Unit 20StringUDC (00 20)30 Allow NULL? 
98EXRP21Category Code - Business Unit 21StringUDC (00 21)100 Allow NULL? 
99EXRP22Category Code - Business Unit 22StringUDC (00 22)100 Allow NULL? 
100EXRP23Category Code - Business Unit 23StringUDC (00 23)100 Allow NULL? 
101EXRP24Category Code - Business Unit 24StringUDC (00 24)100 Allow NULL? 
102EXRP25Category Code - Business Unit 25StringUDC (00 25)100 Allow NULL? 
103EXRP26Category Code - Business Unit 26StringUDC (00 26)100 Allow NULL? 
104EXRP27Category Code - Business Unit 27StringUDC (00 27)100 Allow NULL? 
105EXRP28Category Code - Business Unit 28StringUDC (00 28)100 Allow NULL? 
106EXRP29Category Code - Business Unit 29StringUDC (00 29)100 Allow NULL? 
107EXRP30Category Code - Business Unit 30StringUDC (00 30)100 Allow NULL? 
108EXRP31Category Code - Business Unit 31StringUDC (00 31)100 Allow NULL? 
109EXRP32Category Code - Business Unit 32StringUDC (00 32)100 Allow NULL? 
110EXRP33Category Code - Business Unit 33StringUDC (00 33)100 Allow NULL? 
111EXRP34Category Code - Business Unit 34StringUDC (00 34)100 Allow NULL? 
112EXRP35Category Code - Business Unit 35StringUDC (00 35)100 Allow NULL? 
113EXRP36Category Code - Business Unit 36StringUDC (00 36)100 Allow NULL? 
114EXRP37Category Code - Business Unit 37StringUDC (00 37)100 Allow NULL? 
115EXRP38Category Code - Business Unit 38StringUDC (00 38)100 Allow NULL? 
116EXRP39Category Code - Business Unit 39StringUDC (00 39)100 Allow NULL? 
117EXRP40Category Code - Business Unit 40StringUDC (00 40)100 Allow NULL? 
118EXRP41Category Code - Business Unit 41StringUDC (00 41)100 Allow NULL? 
119EXRP42Category Code - Business Unit 42StringUDC (00 42)100 Allow NULL? 
120EXRP43Category Code - Business Unit 43StringUDC (00 43)100 Allow NULL? 
121EXRP44Category Code - Business Unit 44StringUDC (00 44)100 Allow NULL? 
122EXRP45Category Code - Business Unit 45StringUDC (00 45)100 Allow NULL? 
123EXRP46Category Code - Business Unit 46StringUDC (00 46)100 Allow NULL? 
124EXRP47Category Code - Business Unit 47StringUDC (00 47)100 Allow NULL? 
125EXRP48Category Code - Business Unit 48StringUDC (00 48)100 Allow NULL? 
126EXRP49Category Code - Business Unit 49StringUDC (00 49)100 Allow NULL? 
127EXRP50Category Code - Business Unit 50StringUDC (00 50)100 Allow NULL? 
128EX51XACDPAC Account DescriptionStringGeneric Edit300 Allow NULL? 
129EXLDAAccount Level of DetailCharacterGeneric Edit10 Allow NULL? 
130EXPECPosting EditCharacterUDC (H00 PE)10 Allow NULL? 
131EXUMUnit of MeasureStringUDC (00 UM)20 Allow NULL? 
132EXSUBASubsidiary - AlternateStringGeneric Edit80 Allow NULL? 
133EXR001Category Code - G/L1StringUDC (09 01)30 Allow NULL? 
134EXR002Category Code - G/L2StringUDC (09 02)30 Allow NULL? 
135EXR003Category Code - G/L3StringUDC (09 03)30 Allow NULL? 
136EXR004Category Code - G/L4StringUDC (09 04)30 Allow NULL? 
137EXR005Category Code - G/L5StringUDC (09 05)30 Allow NULL? 
138EXR006Category Code - G/L6StringUDC (09 06)30 Allow NULL? 
139EXR007Category Code - G/L7StringUDC (09 07)30 Allow NULL? 
140EXR008Category Code - G/L8StringUDC (09 08)30 Allow NULL? 
141EXR009Category Code - G/L9StringUDC (09 09)30 Allow NULL? 
142EXR010Category Code - G/L10StringUDC (09 10)30 Allow NULL? 
143EXR011Category Code - G/L11StringUDC (09 11)30 Allow NULL? 
144EXR012Category Code - G/L12StringUDC (09 12)30 Allow NULL? 
145EXR013Category Code - G/L13StringUDC (09 13)30 Allow NULL? 
146EXR014Category Code - G/L14StringUDC (09 14)30 Allow NULL? 
147EXR015Category Code - G/L15StringUDC (09 15)30 Allow NULL? 
148EXR016Category Code - G/L16StringUDC (09 16)30 Allow NULL? 
149EXR017Category Code - G/L17StringUDC (09 17)30 Allow NULL? 
150EXR018Category Code - G/L18StringUDC (09 18)30 Allow NULL? 
151EXR019Category Code - G/L19StringUDC (09 19)30 Allow NULL? 
152EXR020Category Code - G/L20StringUDC (09 20)30 Allow NULL? 
153EXR021Category Code - G/L 021StringUDC (09 21)100 Allow NULL? 
154EXR022Category Code - G/L 022StringUDC (09 22)100 Allow NULL? 
155EXR023Category Code - G/L 023StringUDC (09 23)100 Allow NULL? 
156EXR024Category Code - G/L 024StringUDC (09 24)100 Allow NULL? 
157EXR025Category Code - G/L 025StringUDC (09 25)100 Allow NULL? 
158EXR026Category Code - G/L 026StringUDC (09 26)100 Allow NULL? 
159EXR027Category Code - G/L 027StringUDC (09 27)100 Allow NULL? 
160EXR028Category Code - G/L 028StringUDC (09 28)100 Allow NULL? 
161EXR029Category Code - G/L 029StringUDC (09 29)100 Allow NULL? 
162EXR030Category Code - G/L 030StringUDC (09 30)100 Allow NULL? 
163EXR031Category Code - G/L 031StringUDC (09 31)100 Allow NULL? 
164EXR032Category Code - G/L 032StringUDC (09 32)100 Allow NULL? 
165EXR033Category Code - G/L 033StringUDC (09 33)100 Allow NULL? 
166EXR034Category Code - G/L 034StringUDC (09 34)100 Allow NULL? 
167EXR035Category Code - G/L 035StringUDC (09 35)100 Allow NULL? 
168EXR036Category Code - G/L 036StringUDC (09 36)100 Allow NULL? 
169EXR037Category Code - G/L 037StringUDC (09 37)100 Allow NULL? 
170EXR038Category Code - G/L 038StringUDC (09 38)100 Allow NULL? 
171EXR039Category Code - G/L 039StringUDC (09 39)100 Allow NULL? 
172EXR040Category Code - G/L 040StringUDC (09 40)100 Allow NULL? 
173EXR041Category Code - G/L 041StringUDC (09 41)100 Allow NULL? 
174EXR042Category Code - G/L 042StringUDC (09 42)100 Allow NULL? 
175EXR043Category Code - G/L 043StringUDC (09 43)100 Allow NULL? 

TOP920 | 51X | F51X10 INDEXES

NumberDescription
1User Job + (Primary/Unique)
ElementAliasDescriptionSequence
1USERUser IDAscending
2JOBSJob NumberAscending
351XRTYPAC Record TypeAscending
451XTCPAC Total CodeAscending
5MCUBusiness UnitAscending
651XCT1Cost Code OR Cost Type 1Ascending
751XCT2Cost Code OR Cost Type 2Ascending
2User Job Record Type +
ElementAliasDescriptionSequence
1USERUser IDAscending
2JOBSJob NumberAscending
351XRTYPAC Record TypeAscending
4MCUBusiness UnitAscending
3User Job MCU
ElementAliasDescriptionSequence
1USERUser IDAscending
2JOBSJob NumberAscending
3MCUBusiness UnitAscending