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

62 COLUMNS | 1 INDEXES | Print definition?920 | 41F | FCW22 TABLE

41F: Apparel Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920FCW22WL621Lot Master 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 WLITM, WLEV01, WLLOTN, WLMCU, WLLOCN, WLLDSC, WLLOTS, WLVEND, WLKCOO, WLDOCO, WLDCTO, WLRLOT, WLLOTP, WLLOTG, WLMMEJ, WLSERN, WLUA01, WLUA02, WLUA03, WLUA04, WLUA05, WLUA06, WLUB01, WLUB02, WLUB03, WLUB04, WLUB05, WLUB06, WLUSER, WLPID, WLUPMJ, WLTDAY, WLJOBN, WLLRP1, WLLRP2, WLLRP3, WLLRP4, WLLRP5, WLLRP6, WLLRP7, WLLRP8, WLLRP9, WLLRP0, WLLOT1, WLLOT2, WLLOT3, WLBBDJ, WLBODJ, WLDLEJ, WLOHDJ, WLSBDJ, WLU1DJ, WLU2DJ, WLU3DJ, WLU4DJ, WLU5DJ, WLCHDF, WLWPDF, WLDOC1, WLLOTR, WLLOTC, WLORIG FROM FCW22

TOP920 | 41F | FCW22 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1WLITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
2WLEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10 Allow NULL? 
3WLLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
4WLMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
5WLLOCNLocationStringGeneric Edit200 Allow NULL? 
6WLLDSCDescription - LotStringGeneric Edit300 Allow NULL? 
7WLLOTSLot Status CodeCharacterUDC (41 L)10 Allow NULL? 
8WLVENDPrimary / Last Supplier NumberNumericGeneric Edit80 Allow NULL? 
9WLKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
10WLDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
11WLDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
12WLRLOTSupplier Lot NumberStringGeneric Edit300 Allow NULL? 
13WLLOTPLot PotencyNumericGeneric Edit153 Allow NULL? 
14WLLOTGLot GradeStringUDC (40 LG)30 Allow NULL? 
15WLMMEJDate - Lot ExpirationDateGeneric Edit60
16WLSERNSerial Number - LotStringGeneric Edit300 Allow NULL? 
17WLUA01Date - User Defined Date 01DateGeneric Edit60
18WLUA02Date - User Defined Date 02DateGeneric Edit60
19WLUA03Date - User Defined Date 03DateGeneric Edit60
20WLUA04Date - User Defined Date 04DateGeneric Edit60
21WLUA05Date - User Defined Date 05DateGeneric Edit60
22WLUA06Date - User Defined Date 06DateGeneric Edit60
23WLUB01Quantity - User Defined Quantity 01NumericGeneric Edit150 Allow NULL? 
24WLUB02Quantity - User Defined Quantity 02NumericGeneric Edit150 Allow NULL? 
25WLUB03Quantity - User Defined Quantity 03NumericGeneric Edit150 Allow NULL? 
26WLUB04Quantity - User Defined Quantity 04NumericGeneric Edit150 Allow NULL? 
27WLUB05Quantity - User Defined Quantity 05NumericGeneric Edit150 Allow NULL? 
28WLUB06Quantity - User Defined Quantity 06NumericGeneric Edit150 Allow NULL? 
29WLUSERUser IDStringGeneric Edit100 Allow NULL? 
30WLPIDProgram IDStringGeneric Edit100 Allow NULL? 
31WLUPMJDate - UpdatedDateGeneric Edit60
32WLTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
33WLJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
34WLLRP1Lot Category Code 1StringUDC (41 L1)30 Allow NULL? 
35WLLRP2Lot Category Code 2StringUDC (41 L2)30 Allow NULL? 
36WLLRP3Lot Category Code 3StringUDC (41 L3)30 Allow NULL? 
37WLLRP4Lot Category Code 4StringUDC (41 L4)30 Allow NULL? 
38WLLRP5Lot Category Code 5StringUDC (41 L5)30 Allow NULL? 
39WLLRP6Lot Category Code 6StringUDC (41 L6)30 Allow NULL? 
40WLLRP7Lot Category Code 7StringUDC (41 L7)30 Allow NULL? 
41WLLRP8Lot Category Code 8StringUDC (41 L8)30 Allow NULL? 
42WLLRP9Lot Category Code 9StringUDC (41 L9)30 Allow NULL? 
43WLLRP0Lot Category Code 10StringUDC (41 L0)30 Allow NULL? 
44WLLOT1Memo Lot 1StringGeneric Edit300 Allow NULL? 
45WLLOT2Memo Lot 2StringGeneric Edit300 Allow NULL? 
46WLLOT3Memo Lot 3StringGeneric Edit300 Allow NULL? 
47WLBBDJBest Before DateDateGeneric Edit60
48WLBODJBased On DateDateGeneric Edit60
49WLDLEJLot Effectivity DateDateGeneric Edit60
50WLOHDJOn Hand DateDateGeneric Edit60
51WLSBDJSell By DateDateGeneric Edit60
52WLU1DJUser Lot Date 1DateGeneric Edit60
53WLU2DJUser Lot Date 2DateGeneric Edit60
54WLU3DJUser Lot Date 3DateGeneric Edit60
55WLU4DJUser Lot Date 4DateGeneric Edit60
56WLU5DJUser Lot Date 5DateGeneric Edit60
57WLCHDFCritical Hold FlagCharacterGeneric Edit10 Allow NULL? 
58WLWPDFWork Flow Pending FlagCharacterGeneric Edit10 Allow NULL? 
59WLDOC1Document (Order # Invoice etc.)NumericGeneric Edit80 Allow NULL? 
60WLLOTRLot ReusableCharacterGeneric Edit10 Allow NULL? 
61WLLOTCLot Status Code ExpandedStringGeneric Edit30 Allow NULL? 
62WLORIGCountry of OriginStringUDC (00 CN)30 Allow NULL? 

TOP920 | 41F | FCW22 INDEXES

NumberDescription
1ITM/EV01/LOTN/MCU/LOCN (Primary/Unique)
ElementAliasDescriptionSequence
1ITMItem Number - ShortAscending
2EV01J.D. EnterpriseOne Event Point 01Ascending
3LOTNLot/Serial NumberAscending
4MCUBusiness UnitAscending
5LOCNLocationAscending