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

149 COLUMNS | 1 INDEXES | Print definition?920 | 41F | FCW64 TABLE

41F: Apparel Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920FCW64WX1491WO Receipts Matrix Entry 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, WXUSER, WXC9MLNU, WXC9LANC, WXC9ITMP, WXC9STRC, WXC9LVNO, WXC9LVL0, WXC9LVL1, WXC9LVL2, WXC9LVL3, WXC9LVL4, WXC9LVL5, WXC9LVL6, WXC9LVL7, WXC9LVL8, WXC9LVL9, WXC9PLNM, WXKCOO, WXPARS, 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, WXC9UORG1, WXC9UORG2, WXC9UORG3, WXC9UORG4, WXC9UORG5, WXC9UORG6, WXC9UORG7, WXC9UORG8, WXC9UORG9, WXC9UORG10, WXC9UORG11, WXC9UORG12, WXC9UORG13, WXC9UORG14, WXC9UORG15, WXC9UORG16, WXC9UORG17, WXC9UORG18, WXC9UORG19, WXC9UORG20, WXC9UORG21, WXC9UORG22, WXC9UORG23, WXC9UORG24, WXC9UORG25, WXC9UORG26, WXC9UORG27, WXC9UORG28, WXC9UORG29, WXC9UORG30, 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, WXC9SOCN1, WXC9SOCN2, WXC9SOCN3, WXC9SOCN4, WXC9SOCN5, WXC9SOCN6, WXC9SOCN7, WXC9SOCN8, WXC9SOCN9, WXC9SOCN10, WXC9SOCN11, WXC9SOCN12, WXC9SOCN13, WXC9SOCN14, WXC9SOCN15, WXC9SOCN16, WXC9SOCN17, WXC9SOCN18, WXC9SOCN19, WXC9SOCN20, WXC9SOCN21, WXC9SOCN22, WXC9SOCN23, WXC9SOCN24, WXC9SOCN25, WXC9SOCN26, WXC9SOCN27, WXC9SOCN28, WXC9SOCN29, WXC9SOCN30, WXLTTR, WXDRQJ, WXNXTR, WXC9FILE FROM FCW64

TOP920 | 41F | FCW64 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1WXJOBSJob NumberNumericGeneric Edit80 Allow NULL? 
2WXUSERUser IDStringGeneric Edit100 Allow NULL? 
3WXC9MLNUMatrix Line NumberNumericGeneric Edit80 Allow NULL? 
4WXC9LANCMaster Work OrderNumericGeneric Edit80 Allow NULL? 
5WXC9ITMPItem NumberShort - ParentNumericGeneric Edit80 Allow NULL? 
6WXC9STRCStructureStringUDC (41F IS)30 Allow NULL? 
7WXC9LVNOLevel NoNumericGeneric Edit20 Allow NULL? 
8WXC9LVL0Level 0StringGeneric Edit250 Allow NULL? 
9WXC9LVL1Level 1StringGeneric Edit60 Allow NULL? 
10WXC9LVL2Level 2StringGeneric Edit60 Allow NULL? 
11WXC9LVL3Level 3StringGeneric Edit60 Allow NULL? 
12WXC9LVL4Level 4StringGeneric Edit60 Allow NULL? 
13WXC9LVL5Level 5StringGeneric Edit60 Allow NULL? 
14WXC9LVL6Level 6StringGeneric Edit60 Allow NULL? 
15WXC9LVL7Level 7StringGeneric Edit60 Allow NULL? 
16WXC9LVL8Level 8StringGeneric Edit60 Allow NULL? 
17WXC9LVL9Level 9StringGeneric Edit60 Allow NULL? 
18WXC9PLNMParent Level NameStringGeneric Edit500 Allow NULL? 
19WXKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
20WXPARSNumber - Parent WO NumberStringGeneric Edit80 Allow NULL? 
21WXDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
22WXDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
23WXMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
24WXLOCNLocationStringGeneric Edit200 Allow NULL? 
25WXLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
56WXC9ITMX1Item Number - Short (Matrix 1)NumericGeneric Edit80 Allow NULL? 
57WXC9ITMX2Item Number - Short (Matrix 2)NumericGeneric Edit80 Allow NULL? 
58WXC9ITMX3Item Number - Short (Matrix 3)NumericGeneric Edit80 Allow NULL? 
59WXC9ITMX4Item Number - Short (Matrix 4)NumericGeneric Edit80 Allow NULL? 
60WXC9ITMX5Item Number - Short (Matrix 5)NumericGeneric Edit80 Allow NULL? 
61WXC9ITMX6Item Number - Short (Matrix 6)NumericGeneric Edit80 Allow NULL? 
62WXC9ITMX7Item Number - Short (Matrix 7)NumericGeneric Edit80 Allow NULL? 
63WXC9ITMX8Item Number - Short (Matrix 8)NumericGeneric Edit80 Allow NULL? 
64WXC9ITMX9Item Number - Short (Matrix 9)NumericGeneric Edit80 Allow NULL? 
65WXC9ITMX10Item Number - Short (Matrix 10)NumericGeneric Edit80 Allow NULL? 
66WXC9ITMX11Item Number - Short (Matrix 11)NumericGeneric Edit80 Allow NULL? 
67WXC9ITMX12Item Number - Short (Matrix 12)NumericGeneric Edit80 Allow NULL? 
68WXC9ITMX13Item Number - Short (Matrix 13)NumericGeneric Edit80 Allow NULL? 
69WXC9ITMX14Item Number - Short (Matrix 14)NumericGeneric Edit80 Allow NULL? 
70WXC9ITMX15Item Number - Short (Matrix 15)NumericGeneric Edit80 Allow NULL? 
71WXC9ITMX16Item Number - Short (Matrix 16)NumericGeneric Edit80 Allow NULL? 
72WXC9ITMX17Item Number - Short (Matrix 17)NumericGeneric Edit80 Allow NULL? 
73WXC9ITMX18Item Number - Short (Matrix 18)NumericGeneric Edit80 Allow NULL? 
74WXC9ITMX19Item Number - Short (Matrix 19)NumericGeneric Edit80 Allow NULL? 
75WXC9ITMX20Item Number - Short (Matrix 20)NumericGeneric Edit80 Allow NULL? 
76WXC9ITMX21Item Number - Short (Matrix 21)NumericGeneric Edit80 Allow NULL? 
77WXC9ITMX22Item Number - Short (Matrix 22)NumericGeneric Edit80 Allow NULL? 
78WXC9ITMX23Item Number - Short (Matrix 23)NumericGeneric Edit80 Allow NULL? 
79WXC9ITMX24Item Number - Short (Matrix 24)NumericGeneric Edit80 Allow NULL? 
80WXC9ITMX25Item Number - Short (Matrix 25)NumericGeneric Edit80 Allow NULL? 
81WXC9ITMX26Item Number - Short (Matrix 26)NumericGeneric Edit80 Allow NULL? 
82WXC9ITMX27Item Number - Short (Matrix 27)NumericGeneric Edit80 Allow NULL? 
83WXC9ITMX28Item Number - Short (Matrix 28)NumericGeneric Edit80 Allow NULL? 
84WXC9ITMX29Item Number - Short (Matrix 29)NumericGeneric Edit80 Allow NULL? 
85WXC9ITMX30Item Number - Short (Matrix 30)NumericGeneric Edit80 Allow NULL? 
86WXC9UORG1Quantity Order 1NumericGeneric Edit150 Allow NULL? 
87WXC9UORG2Quantity Order 2NumericGeneric Edit150 Allow NULL? 
88WXC9UORG3Quantity Order 3NumericGeneric Edit150 Allow NULL? 
89WXC9UORG4Quantity Order 4NumericGeneric Edit150 Allow NULL? 
90WXC9UORG5Quantity Order 5NumericGeneric Edit150 Allow NULL? 
91WXC9UORG6Quantity Order 6NumericGeneric Edit150 Allow NULL? 
92WXC9UORG7Quantity Order 7NumericGeneric Edit150 Allow NULL? 
93WXC9UORG8Quantity Order 8NumericGeneric Edit150 Allow NULL? 
94WXC9UORG9Quantity Order 9NumericGeneric Edit150 Allow NULL? 
95WXC9UORG10Quantity Order 10NumericGeneric Edit150 Allow NULL? 
96WXC9UORG11Quantity Order 11NumericGeneric Edit150 Allow NULL? 
97WXC9UORG12Quantity Order 12NumericGeneric Edit150 Allow NULL? 
98WXC9UORG13Quantity Order 13NumericGeneric Edit150 Allow NULL? 
99WXC9UORG14Quantity Order 14NumericGeneric Edit150 Allow NULL? 
100WXC9UORG15Quantity Order 15NumericGeneric Edit150 Allow NULL? 
101WXC9UORG16Quantity Order 16NumericGeneric Edit150 Allow NULL? 
102WXC9UORG17Quantity Order 17NumericGeneric Edit150 Allow NULL? 
103WXC9UORG18Quantity Order 18NumericGeneric Edit150 Allow NULL? 
104WXC9UORG19Quantity Order 19NumericGeneric Edit150 Allow NULL? 
105WXC9UORG20Quantity Order 20NumericGeneric Edit150 Allow NULL? 
106WXC9UORG21Quantity Order 21NumericGeneric Edit150 Allow NULL? 
107WXC9UORG22Quantity Order 22NumericGeneric Edit150 Allow NULL? 
108WXC9UORG23Quantity Order 23NumericGeneric Edit150 Allow NULL? 
109WXC9UORG24Quantity Order 24NumericGeneric Edit150 Allow NULL? 
110WXC9UORG25Quantity Order 25NumericGeneric Edit150 Allow NULL? 
111WXC9UORG26Quantity Order 26NumericGeneric Edit150 Allow NULL? 
112WXC9UORG27Quantity Order 27NumericGeneric Edit150 Allow NULL? 
113WXC9UORG28Quantity Order 28NumericGeneric Edit150 Allow NULL? 
114WXC9UORG29Quantity Order 29NumericGeneric Edit150 Allow NULL? 
115WXC9UORG30Quantity Order 30NumericGeneric Edit150 Allow NULL? 
116WXC9QTY1Quantity 1NumericGeneric Edit150 Allow NULL? 
117WXC9QTY2Quantity 2NumericGeneric Edit150 Allow NULL? 
118WXC9QTY3Quantity 3NumericGeneric Edit150 Allow NULL? 
119WXC9QTY4Quantity 4NumericGeneric Edit150 Allow NULL? 
120WXC9QTY5Quantity 5NumericGeneric Edit150 Allow NULL? 
121WXC9QTY6Quantity 6NumericGeneric Edit150 Allow NULL? 
122WXC9QTY7Quantity 7NumericGeneric Edit150 Allow NULL? 
123WXC9QTY8Quantity 8NumericGeneric Edit150 Allow NULL? 
124WXC9QTY9Quantity 9NumericGeneric Edit150 Allow NULL? 
125WXC9QTY10Quantity 10NumericGeneric Edit150 Allow NULL? 
126WXC9QTY11Quantity 11NumericGeneric Edit150 Allow NULL? 
127WXC9QTY12Quantity 12NumericGeneric Edit150 Allow NULL? 
128WXC9QTY13Quantity 13NumericGeneric Edit150 Allow NULL? 
129WXC9QTY14Quantity 14NumericGeneric Edit150 Allow NULL? 
130WXC9QTY15Quantity 15NumericGeneric Edit150 Allow NULL? 
131WXC9QTY16Quantity 16NumericGeneric Edit150 Allow NULL? 
132WXC9QTY17Quantity 17NumericGeneric Edit150 Allow NULL? 
133WXC9QTY18Quantity 18NumericGeneric Edit150 Allow NULL? 
134WXC9QTY19Quantity 19NumericGeneric Edit150 Allow NULL? 
135WXC9QTY20Quantity 20NumericGeneric Edit150 Allow NULL? 
136WXC9QTY21Quantity 21NumericGeneric Edit150 Allow NULL? 
137WXC9QTY22Quantity 22NumericGeneric Edit150 Allow NULL? 
138WXC9QTY23Quantity 23NumericGeneric Edit150 Allow NULL? 
139WXC9QTY24Quantity 24NumericGeneric Edit150 Allow NULL? 
140WXC9QTY25Quantity 25NumericGeneric Edit150 Allow NULL? 
141WXC9QTY26Quantity 26NumericGeneric Edit150 Allow NULL? 
142WXC9QTY27Quantity 27NumericGeneric Edit150 Allow NULL? 
143WXC9QTY28Quantity 28NumericGeneric Edit150 Allow NULL? 
144WXC9QTY29Quantity 29NumericGeneric Edit150 Allow NULL? 
145WXC9QTY30Quantity 30NumericGeneric Edit150 Allow NULL? 
146WXC9SOCN1Quantity Scrapped 1NumericGeneric Edit150 Allow NULL? 
147WXC9SOCN2Quantity Scrapped 2NumericGeneric Edit150 Allow NULL? 
148WXC9SOCN3Quantity Scrapped 3NumericGeneric Edit150 Allow NULL? 
149WXC9SOCN4Quantity Scrapped 4NumericGeneric Edit150 Allow NULL? 
150WXC9SOCN5Quantity Scrapped 5NumericGeneric Edit150 Allow NULL? 
151WXC9SOCN6Quantity Scrapped 6NumericGeneric Edit150 Allow NULL? 
152WXC9SOCN7Quantity Scrapped 7NumericGeneric Edit150 Allow NULL? 
153WXC9SOCN8Quantity Scrapped 8NumericGeneric Edit150 Allow NULL? 
154WXC9SOCN9Quantity Scrapped 9NumericGeneric Edit150 Allow NULL? 
155WXC9SOCN10Quantity Scrapped 10NumericGeneric Edit150 Allow NULL? 
156WXC9SOCN11Quantity Scrapped 11NumericGeneric Edit150 Allow NULL? 
157WXC9SOCN12Quantity Scrapped 12NumericGeneric Edit150 Allow NULL? 
158WXC9SOCN13Quantity Scrapped 13NumericGeneric Edit150 Allow NULL? 
159WXC9SOCN14Quantity Scrapped 14NumericGeneric Edit150 Allow NULL? 
160WXC9SOCN15Quantity Scrapped 15NumericGeneric Edit150 Allow NULL? 
161WXC9SOCN16Quantity Scrapped 16NumericGeneric Edit150 Allow NULL? 
162WXC9SOCN17Quantity Scrapped 17NumericGeneric Edit150 Allow NULL? 
163WXC9SOCN18Quantity Scrapped 18NumericGeneric Edit150 Allow NULL? 
164WXC9SOCN19Quantity Scrapped 19NumericGeneric Edit150 Allow NULL? 
165WXC9SOCN20Quantity Scrapped 20NumericGeneric Edit150 Allow NULL? 
166WXC9SOCN21Quantity Scrapped 21NumericGeneric Edit150 Allow NULL? 
167WXC9SOCN22Quantity Scrapped 22NumericGeneric Edit150 Allow NULL? 
168WXC9SOCN23Quantity Scrapped 23NumericGeneric Edit150 Allow NULL? 
169WXC9SOCN24Quantity Scrapped 24NumericGeneric Edit150 Allow NULL? 
170WXC9SOCN25Quantity Scrapped 25NumericGeneric Edit150 Allow NULL? 
171WXC9SOCN26Quantity Scrapped 26NumericGeneric Edit150 Allow NULL? 
172WXC9SOCN27Quantity Scrapped 27NumericGeneric Edit150 Allow NULL? 
173WXC9SOCN28Quantity Scrapped 28NumericGeneric Edit150 Allow NULL? 
174WXC9SOCN29Quantity Scrapped 29NumericGeneric Edit150 Allow NULL? 
175WXC9SOCN30Quantity Scrapped 30NumericGeneric Edit150 Allow NULL? 
176WXLTTRStatus Code - LastStringUDC (40 AT)30 Allow NULL? 
177WXDRQJDate - RequestedDateGeneric Edit60
178WXNXTRStatus Code - NextStringUDC (40 AT)30 Allow NULL? 
179WXC9FILEFileStringGeneric Edit100 Allow NULL? 

TOP920 | 41F | FCW64 INDEXES

NumberDescription
1Primary (Primary/Unique)
ElementAliasDescriptionSequence
1JOBSJob NumberAscending
2USERUser IDAscending
3C9LANCMaster Work OrderAscending
4C9MLNUMatrix Line NumberAscending