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

113 COLUMNS | 1 INDEXES | Print definition?910 | 41F | FCW45 TABLE

41F: Apparel Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910FCW45OL1131Matrix Purchase Order Other LocationFiles41F: Apparel 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 OLJOBS, OLUSER, OLKCOO, OLDOCO, OLDCTO, OLC9MLNU, OLC9ITMP, OLMCU, OLLOCN, OLLOTN, OLRECOPT, OLC9STRC, OLC9LVNO, OLC9LVL0, OLC9LVL1, OLC9LVL2, OLC9LVL3, OLC9LVL4, OLC9LVL5, OLC9LVL6, OLC9LVL7, OLC9LVL8, OLC9LVL9, OLC9ITMX1, OLC9ITMX2, OLC9ITMX3, OLC9ITMX4, OLC9ITMX5, OLC9ITMX6, OLC9ITMX7, OLC9ITMX8, OLC9ITMX9, OLC9ITMX10, OLC9ITMX11, OLC9ITMX12, OLC9ITMX13, OLC9ITMX14, OLC9ITMX15, OLC9ITMX16, OLC9ITMX17, OLC9ITMX18, OLC9ITMX19, OLC9ITMX20, OLC9ITMX21, OLC9ITMX22, OLC9ITMX23, OLC9ITMX24, OLC9ITMX25, OLC9ITMX26, OLC9ITMX27, OLC9ITMX28, OLC9ITMX29, OLC9ITMX30, OLC9LN1, OLC9LN2, OLC9LN3, OLC9LN4, OLC9LN5, OLC9LN6, OLC9LN7, OLC9LN8, OLC9LN9, OLC9LN10, OLC9LN11, OLC9LN12, OLC9LN13, OLC9LN14, OLC9LN15, OLC9LN16, OLC9LN17, OLC9LN18, OLC9LN19, OLC9LN20, OLC9LN21, OLC9LN22, OLC9LN23, OLC9LN24, OLC9LN25, OLC9LN26, OLC9LN27, OLC9LN28, OLC9LN29, OLC9LN30, OLC9QTY1, OLC9QTY2, OLC9QTY3, OLC9QTY4, OLC9QTY5, OLC9QTY6, OLC9QTY7, OLC9QTY8, OLC9QTY9, OLC9QTY10, OLC9QTY11, OLC9QTY12, OLC9QTY13, OLC9QTY14, OLC9QTY15, OLC9QTY16, OLC9QTY17, OLC9QTY18, OLC9QTY19, OLC9QTY20, OLC9QTY21, OLC9QTY22, OLC9QTY23, OLC9QTY24, OLC9QTY25, OLC9QTY26, OLC9QTY27, OLC9QTY28, OLC9QTY29, OLC9QTY30 FROM FCW45

TOP910 | 41F | FCW45 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1OLJOBSJob NumberNumericGeneric Edit80 Allow NULL? 
2OLUSERUser IDStringGeneric Edit100 Allow NULL? 
3OLKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
4OLDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
5OLDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
6OLC9MLNUMatrix Line NumberNumericGeneric Edit80 Allow NULL? 
7OLC9ITMPItem NumberShort - ParentNumericGeneric Edit80 Allow NULL? 
8OLMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
9OLLOCNLocationStringGeneric Edit200 Allow NULL? 
10OLLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
11OLRECOPTReceipts OptionsCharacterUDC (43 PR)10 Allow NULL? 
12OLC9STRCStructureStringUDC (41F IS)30 Allow NULL? 
13OLC9LVNOLevel NoNumericGeneric Edit20 Allow NULL? 
14OLC9LVL0Level 0StringGeneric Edit250 Allow NULL? 
15OLC9LVL1Level 1StringGeneric Edit60 Allow NULL? 
16OLC9LVL2Level 2StringGeneric Edit60 Allow NULL? 
17OLC9LVL3Level 3StringGeneric Edit60 Allow NULL? 
18OLC9LVL4Level 4StringGeneric Edit60 Allow NULL? 
19OLC9LVL5Level 5StringGeneric Edit60 Allow NULL? 
20OLC9LVL6Level 6StringGeneric Edit60 Allow NULL? 
21OLC9LVL7Level 7StringGeneric Edit60 Allow NULL? 
22OLC9LVL8Level 8StringGeneric Edit60 Allow NULL? 
23OLC9LVL9Level 9StringGeneric Edit60 Allow NULL? 
24OLC9ITMX1Item Number - Short (Matrix 1)NumericGeneric Edit80 Allow NULL? 
25OLC9ITMX2Item Number - Short (Matrix 2)NumericGeneric Edit80 Allow NULL? 
26OLC9ITMX3Item Number - Short (Matrix 3)NumericGeneric Edit80 Allow NULL? 
27OLC9ITMX4Item Number - Short (Matrix 4)NumericGeneric Edit80 Allow NULL? 
28OLC9ITMX5Item Number - Short (Matrix 5)NumericGeneric Edit80 Allow NULL? 
29OLC9ITMX6Item Number - Short (Matrix 6)NumericGeneric Edit80 Allow NULL? 
30OLC9ITMX7Item Number - Short (Matrix 7)NumericGeneric Edit80 Allow NULL? 
31OLC9ITMX8Item Number - Short (Matrix 8)NumericGeneric Edit80 Allow NULL? 
32OLC9ITMX9Item Number - Short (Matrix 9)NumericGeneric Edit80 Allow NULL? 
33OLC9ITMX10Item Number - Short (Matrix 10)NumericGeneric Edit80 Allow NULL? 
34OLC9ITMX11Item Number - Short (Matrix 11)NumericGeneric Edit80 Allow NULL? 
35OLC9ITMX12Item Number - Short (Matrix 12)NumericGeneric Edit80 Allow NULL? 
36OLC9ITMX13Item Number - Short (Matrix 13)NumericGeneric Edit80 Allow NULL? 
37OLC9ITMX14Item Number - Short (Matrix 14)NumericGeneric Edit80 Allow NULL? 
38OLC9ITMX15Item Number - Short (Matrix 15)NumericGeneric Edit80 Allow NULL? 
39OLC9ITMX16Item Number - Short (Matrix 16)NumericGeneric Edit80 Allow NULL? 
40OLC9ITMX17Item Number - Short (Matrix 17)NumericGeneric Edit80 Allow NULL? 
41OLC9ITMX18Item Number - Short (Matrix 18)NumericGeneric Edit80 Allow NULL? 
42OLC9ITMX19Item Number - Short (Matrix 19)NumericGeneric Edit80 Allow NULL? 
43OLC9ITMX20Item Number - Short (Matrix 20)NumericGeneric Edit80 Allow NULL? 
44OLC9ITMX21Item Number - Short (Matrix 21)NumericGeneric Edit80 Allow NULL? 
45OLC9ITMX22Item Number - Short (Matrix 22)NumericGeneric Edit80 Allow NULL? 
46OLC9ITMX23Item Number - Short (Matrix 23)NumericGeneric Edit80 Allow NULL? 
47OLC9ITMX24Item Number - Short (Matrix 24)NumericGeneric Edit80 Allow NULL? 
48OLC9ITMX25Item Number - Short (Matrix 25)NumericGeneric Edit80 Allow NULL? 
49OLC9ITMX26Item Number - Short (Matrix 26)NumericGeneric Edit80 Allow NULL? 
50OLC9ITMX27Item Number - Short (Matrix 27)NumericGeneric Edit80 Allow NULL? 
51OLC9ITMX28Item Number - Short (Matrix 28)NumericGeneric Edit80 Allow NULL? 
52OLC9ITMX29Item Number - Short (Matrix 29)NumericGeneric Edit80 Allow NULL? 
53OLC9ITMX30Item Number - Short (Matrix 30)NumericGeneric Edit80 Allow NULL? 
54OLC9LN1Line Number 1NumericGeneric Edit63 Allow NULL? 
55OLC9LN2Line Number 2NumericGeneric Edit63 Allow NULL? 
56OLC9LN3Line Number 3NumericGeneric Edit63 Allow NULL? 
57OLC9LN4Line Number 4NumericGeneric Edit63 Allow NULL? 
58OLC9LN5Line Number 5NumericGeneric Edit63 Allow NULL? 
59OLC9LN6Line Number 6NumericGeneric Edit63 Allow NULL? 
60OLC9LN7Line Number 7NumericGeneric Edit63 Allow NULL? 
61OLC9LN8Line Number 8NumericGeneric Edit63 Allow NULL? 
62OLC9LN9Line Number 9NumericGeneric Edit63 Allow NULL? 
63OLC9LN10Line Number 10NumericGeneric Edit63 Allow NULL? 
64OLC9LN11Line Number 11NumericGeneric Edit63 Allow NULL? 
65OLC9LN12Line Number 12NumericGeneric Edit63 Allow NULL? 
66OLC9LN13Line Number 13NumericGeneric Edit63 Allow NULL? 
67OLC9LN14Line Number 14NumericGeneric Edit63 Allow NULL? 
68OLC9LN15Line Number 15NumericGeneric Edit63 Allow NULL? 
69OLC9LN16Line Number 16NumericGeneric Edit63 Allow NULL? 
70OLC9LN17Line Number 17NumericGeneric Edit63 Allow NULL? 
71OLC9LN18Line Number 18NumericGeneric Edit63 Allow NULL? 
72OLC9LN19Line Number 19NumericGeneric Edit63 Allow NULL? 
73OLC9LN20Line Number 20NumericGeneric Edit63 Allow NULL? 
74OLC9LN21Line Number 21NumericGeneric Edit63 Allow NULL? 
75OLC9LN22Line Number 22NumericGeneric Edit63 Allow NULL? 
76OLC9LN23Line Number 23NumericGeneric Edit63 Allow NULL? 
77OLC9LN24Line Number 24NumericGeneric Edit63 Allow NULL? 
78OLC9LN25Line Number 25NumericGeneric Edit63 Allow NULL? 
79OLC9LN26Line Number 26NumericGeneric Edit63 Allow NULL? 
80OLC9LN27Line Number 27NumericGeneric Edit63 Allow NULL? 
81OLC9LN28Line Number 28NumericGeneric Edit63 Allow NULL? 
82OLC9LN29Line Number 29NumericGeneric Edit63 Allow NULL? 
83OLC9LN30Line Number 30NumericGeneric Edit63 Allow NULL? 
84OLC9QTY1Quantity 1NumericGeneric Edit152 Allow NULL? 
85OLC9QTY2Quantity 2NumericGeneric Edit152 Allow NULL? 
86OLC9QTY3Quantity 3NumericGeneric Edit152 Allow NULL? 
87OLC9QTY4Quantity 4NumericGeneric Edit152 Allow NULL? 
88OLC9QTY5Quantity 5NumericGeneric Edit152 Allow NULL? 
89OLC9QTY6Quantity 6NumericGeneric Edit152 Allow NULL? 
90OLC9QTY7Quantity 7NumericGeneric Edit152 Allow NULL? 
91OLC9QTY8Quantity 8NumericGeneric Edit152 Allow NULL? 
92OLC9QTY9Quantity 9NumericGeneric Edit152 Allow NULL? 
93OLC9QTY10Quantity 10NumericGeneric Edit152 Allow NULL? 
94OLC9QTY11Quantity 11NumericGeneric Edit152 Allow NULL? 
95OLC9QTY12Quantity 12NumericGeneric Edit152 Allow NULL? 
96OLC9QTY13Quantity 13NumericGeneric Edit152 Allow NULL? 
97OLC9QTY14Quantity 14NumericGeneric Edit152 Allow NULL? 
98OLC9QTY15Quantity 15NumericGeneric Edit152 Allow NULL? 
99OLC9QTY16Quantity 16NumericGeneric Edit152 Allow NULL? 
100OLC9QTY17Quantity 17NumericGeneric Edit152 Allow NULL? 
101OLC9QTY18Quantity 18NumericGeneric Edit152 Allow NULL? 
102OLC9QTY19Quantity 19NumericGeneric Edit152 Allow NULL? 
103OLC9QTY20Quantity 20NumericGeneric Edit152 Allow NULL? 
104OLC9QTY21Quantity 21NumericGeneric Edit152 Allow NULL? 
105OLC9QTY22Quantity 22NumericGeneric Edit152 Allow NULL? 
106OLC9QTY23Quantity 23NumericGeneric Edit152 Allow NULL? 
107OLC9QTY24Quantity 24NumericGeneric Edit152 Allow NULL? 
108OLC9QTY25Quantity 25NumericGeneric Edit152 Allow NULL? 
109OLC9QTY26Quantity 26NumericGeneric Edit152 Allow NULL? 
110OLC9QTY27Quantity 27NumericGeneric Edit152 Allow NULL? 
111OLC9QTY28Quantity 28NumericGeneric Edit152 Allow NULL? 
112OLC9QTY29Quantity 29NumericGeneric Edit152 Allow NULL? 
113OLC9QTY30Quantity 30NumericGeneric Edit152 Allow NULL? 

TOP910 | 41F | FCW45 INDEXES

NumberDescription
1Primary (Primary/Unique)
ElementAliasDescriptionSequence
1JOBSJob NumberAscending
2USERUser IDAscending
3KCOOOrder Company (Order Number)Ascending
4DOCODocument (Order No Invoice etc.)Ascending
5DCTOOrder TypeAscending
6C9MLNUMatrix Line NumberAscending
7C9ITMPItem NumberShort - ParentAscending
8MCUBusiness UnitAscending
9LOCNLocationAscending
10LOTNLot/Serial NumberAscending
11RECOPTReceipts OptionsAscending