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
3F9671SDSoftware Update Detail Table
4F4101IMItem Master
5F0911GLAccount Ledger
6F4311PDPurchase Order Detail File
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F41021LIItem Location File
10F03012AICustomer Master by Line of Business

910: Top 10 requests

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

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

121 COLUMNS | 1 INDEXES | Print definition?920 | 41F | FCW20 TABLE

41F: Apparel Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920FCW20WX1211Matrix Work FileFiles41F: 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 WXJOBS, WXC9MLNU, WXC9MOSA, WXC9ITMP, WXC9STRC, WXC9LVNO, WXC9LVL0, WXC9LVL1, WXC9LVL2, WXC9LVL3, WXC9LVL4, WXC9LVL5, WXC9LVL6, WXC9LVL7, WXC9LVL8, WXC9LVL9, WXKCOO, WXDOCO, WXDCTO, WXMCU, WXLOCN, WXLOTN, WXC9ITMX1, WXC9ITMX2, WXC9ITMX3, WXC9ITMX4, WXC9ITMX5, WXC9ITMX6, WXC9ITMX7, WXC9ITMX8, WXC9ITMX9, WXC9ITMX10, WXC9ITMX11, WXC9ITMX12, WXC9ITMX13, WXC9ITMX14, WXC9ITMX15, WXC9ITMX16, WXC9ITMX17, WXC9ITMX18, WXC9ITMX19, WXC9ITMX20, WXC9ITMX21, WXC9ITMX22, WXC9ITMX23, WXC9ITMX24, WXC9ITMX25, WXC9ITMX26, WXC9ITMX27, WXC9ITMX28, WXC9ITMX29, WXC9ITMX30, WXC9LN1, WXC9LN2, WXC9LN3, WXC9LN4, WXC9LN5, WXC9LN6, WXC9LN7, WXC9LN8, WXC9LN9, WXC9LN10, WXC9LN11, WXC9LN12, WXC9LN13, WXC9LN14, WXC9LN15, WXC9LN16, WXC9LN17, WXC9LN18, WXC9LN19, WXC9LN20, WXC9LN21, WXC9LN22, WXC9LN23, WXC9LN24, WXC9LN25, WXC9LN26, WXC9LN27, WXC9LN28, WXC9LN29, WXC9LN30, WXC9QTY1, WXC9QTY2, WXC9QTY3, WXC9QTY4, WXC9QTY5, WXC9QTY6, WXC9QTY7, WXC9QTY8, WXC9QTY9, WXC9QTY10, WXC9QTY11, WXC9QTY12, WXC9QTY13, WXC9QTY14, WXC9QTY15, WXC9QTY16, WXC9QTY17, WXC9QTY18, WXC9QTY19, WXC9QTY20, WXC9QTY21, WXC9QTY22, WXC9QTY23, WXC9QTY24, WXC9QTY25, WXC9QTY26, WXC9QTY27, WXC9QTY28, WXC9QTY29, WXC9QTY30, WXLTTR, WXDRQJ, WXNXTR, WXC9FILE, WXUSER, WXPID, WXJOBN, WXUPMJ, WXTDAY FROM FCW20

TOP920 | 41F | FCW20 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1WXJOBSJob NumberNumericGeneric Edit80 Allow NULL? 
2WXC9MLNUMatrix Line NumberNumericGeneric Edit80 Allow NULL? 
3WXC9MOSACollection ModelStringGeneric Edit100 Allow NULL? 
4WXC9ITMPItem NumberShort - ParentNumericGeneric Edit80 Allow NULL? 
5WXC9STRCStructureStringUDC (41F IS)30 Allow NULL? 
6WXC9LVNOLevel NoNumericGeneric Edit20 Allow NULL? 
7WXC9LVL0Level 0StringGeneric Edit250 Allow NULL? 
8WXC9LVL1Level 1StringGeneric Edit60 Allow NULL? 
9WXC9LVL2Level 2StringGeneric Edit60 Allow NULL? 
10WXC9LVL3Level 3StringGeneric Edit60 Allow NULL? 
11WXC9LVL4Level 4StringGeneric Edit60 Allow NULL? 
12WXC9LVL5Level 5StringGeneric Edit60 Allow NULL? 
13WXC9LVL6Level 6StringGeneric Edit60 Allow NULL? 
14WXC9LVL7Level 7StringGeneric Edit60 Allow NULL? 
15WXC9LVL8Level 8StringGeneric Edit60 Allow NULL? 
16WXC9LVL9Level 9StringGeneric Edit60 Allow NULL? 
17WXKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
18WXDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
19WXDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
20WXMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
21WXLOCNLocationStringGeneric Edit200 Allow NULL? 
22WXLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
23WXC9ITMX1Item Number - Short (Matrix 1)NumericGeneric Edit80 Allow NULL? 
24WXC9ITMX2Item Number - Short (Matrix 2)NumericGeneric Edit80 Allow NULL? 
25WXC9ITMX3Item Number - Short (Matrix 3)NumericGeneric Edit80 Allow NULL? 
26WXC9ITMX4Item Number - Short (Matrix 4)NumericGeneric Edit80 Allow NULL? 
27WXC9ITMX5Item Number - Short (Matrix 5)NumericGeneric Edit80 Allow NULL? 
28WXC9ITMX6Item Number - Short (Matrix 6)NumericGeneric Edit80 Allow NULL? 
29WXC9ITMX7Item Number - Short (Matrix 7)NumericGeneric Edit80 Allow NULL? 
30WXC9ITMX8Item Number - Short (Matrix 8)NumericGeneric Edit80 Allow NULL? 
31WXC9ITMX9Item Number - Short (Matrix 9)NumericGeneric Edit80 Allow NULL? 
32WXC9ITMX10Item Number - Short (Matrix 10)NumericGeneric Edit80 Allow NULL? 
33WXC9ITMX11Item Number - Short (Matrix 11)NumericGeneric Edit80 Allow NULL? 
34WXC9ITMX12Item Number - Short (Matrix 12)NumericGeneric Edit80 Allow NULL? 
35WXC9ITMX13Item Number - Short (Matrix 13)NumericGeneric Edit80 Allow NULL? 
36WXC9ITMX14Item Number - Short (Matrix 14)NumericGeneric Edit80 Allow NULL? 
37WXC9ITMX15Item Number - Short (Matrix 15)NumericGeneric Edit80 Allow NULL? 
38WXC9ITMX16Item Number - Short (Matrix 16)NumericGeneric Edit80 Allow NULL? 
39WXC9ITMX17Item Number - Short (Matrix 17)NumericGeneric Edit80 Allow NULL? 
40WXC9ITMX18Item Number - Short (Matrix 18)NumericGeneric Edit80 Allow NULL? 
41WXC9ITMX19Item Number - Short (Matrix 19)NumericGeneric Edit80 Allow NULL? 
42WXC9ITMX20Item Number - Short (Matrix 20)NumericGeneric Edit80 Allow NULL? 
43WXC9ITMX21Item Number - Short (Matrix 21)NumericGeneric Edit80 Allow NULL? 
44WXC9ITMX22Item Number - Short (Matrix 22)NumericGeneric Edit80 Allow NULL? 
45WXC9ITMX23Item Number - Short (Matrix 23)NumericGeneric Edit80 Allow NULL? 
46WXC9ITMX24Item Number - Short (Matrix 24)NumericGeneric Edit80 Allow NULL? 
47WXC9ITMX25Item Number - Short (Matrix 25)NumericGeneric Edit80 Allow NULL? 
48WXC9ITMX26Item Number - Short (Matrix 26)NumericGeneric Edit80 Allow NULL? 
49WXC9ITMX27Item Number - Short (Matrix 27)NumericGeneric Edit80 Allow NULL? 
50WXC9ITMX28Item Number - Short (Matrix 28)NumericGeneric Edit80 Allow NULL? 
51WXC9ITMX29Item Number - Short (Matrix 29)NumericGeneric Edit80 Allow NULL? 
52WXC9ITMX30Item Number - Short (Matrix 30)NumericGeneric Edit80 Allow NULL? 
53WXC9LN1Line Number 1NumericGeneric Edit63 Allow NULL? 
54WXC9LN2Line Number 2NumericGeneric Edit63 Allow NULL? 
55WXC9LN3Line Number 3NumericGeneric Edit63 Allow NULL? 
56WXC9LN4Line Number 4NumericGeneric Edit63 Allow NULL? 
57WXC9LN5Line Number 5NumericGeneric Edit63 Allow NULL? 
58WXC9LN6Line Number 6NumericGeneric Edit63 Allow NULL? 
59WXC9LN7Line Number 7NumericGeneric Edit63 Allow NULL? 
60WXC9LN8Line Number 8NumericGeneric Edit63 Allow NULL? 
61WXC9LN9Line Number 9NumericGeneric Edit63 Allow NULL? 
62WXC9LN10Line Number 10NumericGeneric Edit63 Allow NULL? 
63WXC9LN11Line Number 11NumericGeneric Edit63 Allow NULL? 
64WXC9LN12Line Number 12NumericGeneric Edit63 Allow NULL? 
65WXC9LN13Line Number 13NumericGeneric Edit63 Allow NULL? 
66WXC9LN14Line Number 14NumericGeneric Edit63 Allow NULL? 
67WXC9LN15Line Number 15NumericGeneric Edit63 Allow NULL? 
68WXC9LN16Line Number 16NumericGeneric Edit63 Allow NULL? 
69WXC9LN17Line Number 17NumericGeneric Edit63 Allow NULL? 
70WXC9LN18Line Number 18NumericGeneric Edit63 Allow NULL? 
71WXC9LN19Line Number 19NumericGeneric Edit63 Allow NULL? 
72WXC9LN20Line Number 20NumericGeneric Edit63 Allow NULL? 
73WXC9LN21Line Number 21NumericGeneric Edit63 Allow NULL? 
74WXC9LN22Line Number 22NumericGeneric Edit63 Allow NULL? 
75WXC9LN23Line Number 23NumericGeneric Edit63 Allow NULL? 
76WXC9LN24Line Number 24NumericGeneric Edit63 Allow NULL? 
77WXC9LN25Line Number 25NumericGeneric Edit63 Allow NULL? 
78WXC9LN26Line Number 26NumericGeneric Edit63 Allow NULL? 
79WXC9LN27Line Number 27NumericGeneric Edit63 Allow NULL? 
80WXC9LN28Line Number 28NumericGeneric Edit63 Allow NULL? 
81WXC9LN29Line Number 29NumericGeneric Edit63 Allow NULL? 
82WXC9LN30Line Number 30NumericGeneric Edit63 Allow NULL? 
83WXC9QTY1Quantity 1NumericGeneric Edit150 Allow NULL? 
84WXC9QTY2Quantity 2NumericGeneric Edit150 Allow NULL? 
85WXC9QTY3Quantity 3NumericGeneric Edit150 Allow NULL? 
86WXC9QTY4Quantity 4NumericGeneric Edit150 Allow NULL? 
87WXC9QTY5Quantity 5NumericGeneric Edit150 Allow NULL? 
88WXC9QTY6Quantity 6NumericGeneric Edit150 Allow NULL? 
89WXC9QTY7Quantity 7NumericGeneric Edit150 Allow NULL? 
90WXC9QTY8Quantity 8NumericGeneric Edit150 Allow NULL? 
91WXC9QTY9Quantity 9NumericGeneric Edit150 Allow NULL? 
92WXC9QTY10Quantity 10NumericGeneric Edit150 Allow NULL? 
93WXC9QTY11Quantity 11NumericGeneric Edit150 Allow NULL? 
94WXC9QTY12Quantity 12NumericGeneric Edit150 Allow NULL? 
95WXC9QTY13Quantity 13NumericGeneric Edit150 Allow NULL? 
96WXC9QTY14Quantity 14NumericGeneric Edit150 Allow NULL? 
97WXC9QTY15Quantity 15NumericGeneric Edit150 Allow NULL? 
98WXC9QTY16Quantity 16NumericGeneric Edit150 Allow NULL? 
99WXC9QTY17Quantity 17NumericGeneric Edit150 Allow NULL? 
100WXC9QTY18Quantity 18NumericGeneric Edit150 Allow NULL? 
101WXC9QTY19Quantity 19NumericGeneric Edit150 Allow NULL? 
102WXC9QTY20Quantity 20NumericGeneric Edit150 Allow NULL? 
103WXC9QTY21Quantity 21NumericGeneric Edit150 Allow NULL? 
104WXC9QTY22Quantity 22NumericGeneric Edit150 Allow NULL? 
105WXC9QTY23Quantity 23NumericGeneric Edit150 Allow NULL? 
106WXC9QTY24Quantity 24NumericGeneric Edit150 Allow NULL? 
107WXC9QTY25Quantity 25NumericGeneric Edit150 Allow NULL? 
108WXC9QTY26Quantity 26NumericGeneric Edit150 Allow NULL? 
109WXC9QTY27Quantity 27NumericGeneric Edit150 Allow NULL? 
110WXC9QTY28Quantity 28NumericGeneric Edit150 Allow NULL? 
111WXC9QTY29Quantity 29NumericGeneric Edit150 Allow NULL? 
112WXC9QTY30Quantity 30NumericGeneric Edit150 Allow NULL? 
113WXLTTRStatus Code - LastStringUDC (40 AT)30 Allow NULL? 
114WXDRQJDate - RequestedDateGeneric Edit60
115WXNXTRStatus Code - NextStringUDC (40 AT)30 Allow NULL? 
116WXC9FILEFileStringGeneric Edit100 Allow NULL? 
117WXUSERUser IDStringGeneric Edit100 Allow NULL? 
118WXPIDProgram IDStringGeneric Edit100 Allow NULL? 
119WXJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
120WXUPMJDate - UpdatedDateGeneric Edit60
121WXTDAYTime of DayNumericGeneric Edit60 Allow NULL? 

TOP920 | 41F | FCW20 INDEXES

NumberDescription
1Primary (Primary/Unique)
ElementAliasDescriptionSequence
1JOBSJob NumberAscending
2C9MOSACollection ModelAscending
3C9MLNUMatrix Line NumberAscending