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

87 COLUMNS | 5 INDEXES | Print definition?920 | 46 | F46130 TABLE

46: Warehouse Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F46130R3875Putaway ReservationsTransaction Files46: Warehouse ManagementBusiness Data
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 R3KCOO, R3DOCO, R3DCTO, R3LNID, R3SFXO, R3SEQ, R3MCU, R3AN8, R3ITM, R3LITM, R3AITM, R3LOCN, R3LOTN, R3DRQJ, R3UORG, R3UOM, R3UOM1, R3TQTY, R3UML1, R3UGL1, R3EUL1, R3PPL1, R3TQL1, R3EQL1, R3HPL1, R3WPL1, R3DPL1, R3CPL1, R3EPL1, R3UML2, R3UGL2, R3EUL2, R3QPL2, R3PPL2, R3TQL2, R3EQL2, R3HPL2, R3WPL2, R3DPL2, R3CPL2, R3EPL2, R3UML3, R3UGL3, R3EUL3, R3QPL3, R3PPL3, R3TQL3, R3EQL3, R3HPL3, R3WPL3, R3DPL3, R3CPL3, R3EPL3, R3UML4, R3UGL4, R3EUL4, R3QPL4, R3PPL4, R3TQL4, R3EQL4, R3HPL4, R3WPL4, R3DPL4, R3CPL4, R3EPL4, R3UML5, R3UGL5, R3EUL5, R3QPL5, R3TQL5, R3EQL5, R3HPL5, R3WPL5, R3DPL5, R3CPL5, R3EPL5, R3RCUB, R3VUMD, R3RWET, R3UWUM, R3EKEY, R3PSTB, R3USER, R3PID, R3JOBN, R3UPMJ, R3TDAY FROM F46130

TOP920 | 46 | F46130 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1R3KCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
2R3DOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
3R3DCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
4R3LNIDLine NumberNumericGeneric Edit63 Allow NULL? 
5R3SFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
6R3SEQSequence NumberNumericGeneric Edit60 Allow NULL? 
7R3MCUBusiness UnitStringGeneric Edit120 Allow NULL? 
8R3AN8Address NumberNumericGeneric Edit80 Allow NULL? 
9R3ITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
10R3LITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
11R3AITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
12R3LOCNLocationStringGeneric Edit200 Allow NULL? 
13R3LOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
14R3DRQJDate - RequestedDateGeneric Edit60
15R3UORGUnits - Order/Transaction QuantityNumericGeneric Edit150 Allow NULL? 
16R3UOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
17R3UOM1Unit of Measure - PrimaryStringUDC (00 UM)20 Allow NULL? 
18R3TQTYQuantity -TotalNumericGeneric Edit150 Allow NULL? 
19R3UML1Unit of Measure - Level 1StringUDC (00 UM)20 Allow NULL? 
20R3UGL1Group - Unit of Measure (Level 1)StringGeneric Edit20 Allow NULL? 
21R3EUL1U/M Usage - Level 1CharacterUDC (H46 EU)10 Allow NULL? 
22R3PPL1Quantity per - Level 1 (primary U/M)NumericGeneric Edit150 Allow NULL? 
23R3TQL1Quantity - Total Level 1NumericGeneric Edit150 Allow NULL? 
24R3EQL1Container Code - Level 1StringUDC (46 EQ)50 Allow NULL? 
25R3HPL1Height per - Level 1NumericGeneric Edit152 Allow NULL? 
26R3WPL1Width per - Level 1NumericGeneric Edit152 Allow NULL? 
27R3DPL1Depth per - Level 1NumericGeneric Edit152 Allow NULL? 
28R3CPL1Cubic Dimensions per - Level 1NumericGeneric Edit152 Allow NULL? 
29R3EPL1Weight per - Level 1NumericGeneric Edit152 Allow NULL? 
30R3UML2Unit of Measure - Level 2StringUDC (00 UM)20 Allow NULL? 
31R3UGL2Group - Unit of Measure (Level 2)StringGeneric Edit20 Allow NULL? 
32R3EUL2U/M Usage - Level 2CharacterUDC (H46 EU)10 Allow NULL? 
33R3QPL2Quantity per - Level 2NumericGeneric Edit150 Allow NULL? 
34R3PPL2Quantity per - Level 2 (primary U/M)NumericGeneric Edit150 Allow NULL? 
35R3TQL2Quantity - Total Level 2NumericGeneric Edit150 Allow NULL? 
36R3EQL2Container Code - Level 2StringUDC (46 EQ)50 Allow NULL? 
37R3HPL2Height per - Level 2NumericGeneric Edit152 Allow NULL? 
38R3WPL2Width per - Level 2NumericGeneric Edit152 Allow NULL? 
39R3DPL2Depth per - Level 2NumericGeneric Edit152 Allow NULL? 
40R3CPL2Cubic Dimensions per - Level 2NumericGeneric Edit152 Allow NULL? 
41R3EPL2Weight per - Level 2NumericGeneric Edit152 Allow NULL? 
42R3UML3Unit of Measure - Level 3StringUDC (00 UM)20 Allow NULL? 
43R3UGL3Group - Unit of Measure (Level 3)StringGeneric Edit20 Allow NULL? 
44R3EUL3U/M Usage - Level 3CharacterUDC (H46 EU)10 Allow NULL? 
45R3QPL3Quantity per - Level 3NumericGeneric Edit150 Allow NULL? 
46R3PPL3Quantity per - Level 3 (primary U/M)NumericGeneric Edit150 Allow NULL? 
47R3TQL3Quantity - Total Level 3NumericGeneric Edit150 Allow NULL? 
48R3EQL3Container Code - Level 3StringUDC (46 EQ)50 Allow NULL? 
49R3HPL3Height per - Level 3NumericGeneric Edit152 Allow NULL? 
50R3WPL3Width per - Level 3NumericGeneric Edit152 Allow NULL? 
51R3DPL3Depth per - Level 3NumericGeneric Edit152 Allow NULL? 
52R3CPL3Cubic Dimensions per - Level 3NumericGeneric Edit152 Allow NULL? 
53R3EPL3Weight per - Level 3NumericGeneric Edit152 Allow NULL? 
54R3UML4Unit of Measure - Level 4StringUDC (00 UM)20 Allow NULL? 
55R3UGL4Group - Unit of Measure (Level 4)StringGeneric Edit20 Allow NULL? 
56R3EUL4U/M Usage - Level 4CharacterUDC (H46 EU)10 Allow NULL? 
57R3QPL4Quantity per - Level 4NumericGeneric Edit150 Allow NULL? 
58R3PPL4Quantity per - Level 4 (primary U/M)NumericGeneric Edit150 Allow NULL? 
59R3TQL4Quantity - Total Level 4NumericGeneric Edit150 Allow NULL? 
60R3EQL4Container Code - Level 4StringUDC (46 EQ)50 Allow NULL? 
61R3HPL4Height per - Level 4NumericGeneric Edit152 Allow NULL? 
62R3WPL4Width per - Level 4NumericGeneric Edit152 Allow NULL? 
63R3DPL4Depth per - Level 4NumericGeneric Edit152 Allow NULL? 
64R3CPL4Cubic Dimensions per - Level 4NumericGeneric Edit152 Allow NULL? 
65R3EPL4Weight per - Level 4NumericGeneric Edit152 Allow NULL? 
66R3UML5Unit of Measure - Level 5StringUDC (00 UM)20 Allow NULL? 
67R3UGL5Group - Unit of Measure (Level 5)StringGeneric Edit20 Allow NULL? 
68R3EUL5U/M Usage - Level 5CharacterUDC (H46 EU)10 Allow NULL? 
69R3QPL5Quantity per - Level 5NumericGeneric Edit150 Allow NULL? 
70R3TQL5Quantity - Total Level 5NumericGeneric Edit150 Allow NULL? 
71R3EQL5Container Code - Level 5StringUDC (46 EQ)50 Allow NULL? 
72R3HPL5Height per - Level 5NumericGeneric Edit152 Allow NULL? 
73R3WPL5Width per - Level 5NumericGeneric Edit152 Allow NULL? 
74R3DPL5Depth per - Level 5NumericGeneric Edit152 Allow NULL? 
75R3CPL5Cubic Dimensions per - Level 5NumericGeneric Edit152 Allow NULL? 
76R3EPL5Weight per - Level 5NumericGeneric Edit152 Allow NULL? 
77R3RCUBCubic Dimensions - ReservedNumericGeneric Edit152 Allow NULL? 
78R3VUMDUnit of Measure - Volume DisplayStringUDC (00 UM)20 Allow NULL? 
79R3RWETAmount - Reserved WeightNumericGeneric Edit152 Allow NULL? 
80R3UWUMUnit of Measure - WeightStringUDC (00 UM)20 Allow NULL? 
81R3EKEYError Message KeyStringGeneric Edit40 Allow NULL? 
82R3PSTBStatus - Task / TripStringUDC (46 PS)30 Allow NULL? 
83R3USERUser IDStringGeneric Edit100 Allow NULL? 
84R3PIDProgram IDStringGeneric Edit100 Allow NULL? 
85R3JOBNWork Station IDStringGeneric Edit100 Allow NULL? 
86R3UPMJDate - UpdatedDateGeneric Edit60
87R3TDAYTime of DayNumericGeneric Edit60 Allow NULL? 

TOP920 | 46 | F46130 INDEXES

NumberDescription
1Doco Dcto Kcoo Lnid Seq (Primary/Unique)
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4LNIDLine NumberAscending
5SEQSequence NumberAscending
2Mcu Locn Itm Pstb
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2LOCNLocationAscending
3ITMItem Number - ShortAscending
4PSTBStatus - Task / TripAscending
3Doco Dcto Kcoo Lnid Pstb Seq
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4LNIDLine NumberAscending
5PSTBStatus - Task / TripAscending
6SEQSequence NumberAscending
4Mcu Itm UOM Pstb
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2ITMItem Number - ShortAscending
3UOMUnit of Measure as InputAscending
4PSTBStatus - Task / TripAscending
5Doco Dcto Kcoo Lnid Locn
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4LNIDLine NumberAscending
5LOCNLocationAscending