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

90 COLUMNS | 17 INDEXES | Print definition?920 | 46 | F4602 TABLE

46: Warehouse Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F4602IF9017Location Detail InformationBalance 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 IFITM, IFMCU, IFLOCN, IFLOTN, IFLDSQ, IFSTUN, IFUML1, IFUGL1, IFEUL1, IFPPL1, IFTQL1, IFEQL1, IFHPL1, IFWPL1, IFDPL1, IFCPL1, IFEPL1, IFUML2, IFUGL2, IFEUL2, IFQPL2, IFPPL2, IFTQL2, IFEQL2, IFHPL2, IFWPL2, IFDPL2, IFCPL2, IFEPL2, IFUML3, IFUGL3, IFEUL3, IFQPL3, IFPPL3, IFTQL3, IFEQL3, IFHPL3, IFWPL3, IFDPL3, IFCPL3, IFEPL3, IFUML4, IFUGL4, IFEUL4, IFQPL4, IFPPL4, IFTQL4, IFEQL4, IFHPL4, IFWPL4, IFDPL4, IFCPL4, IFEPL4, IFUML5, IFUGL5, IFEUL5, IFQPL5, IFTQL5, IFEQL5, IFHPL5, IFWPL5, IFDPL5, IFCPL5, IFEPL5, IFUOM1, IFTQTY, IFHCOM, IFQTRI, IFQTRO, IFCUBE, IFRCUB, IFVUMD, IFWEIT, IFRWET, IFUWUM, IFRCDJ, IFMMEJ, IFDOCO, IFDCTO, IFKCOO, IFLNID, IFSFXO, IFNLIN, IFUSER, IFPID, IFJOBN, IFUPMJ, IFTDAY, IFUOM2, IFDQTY FROM F4602

TOP920 | 46 | F4602 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1IFITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
2IFMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
3IFLOCNLocationStringGeneric Edit200 Allow NULL? 
4IFLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
5IFLDSQSequence Number - Location DetailNumericGeneric Edit80 Allow NULL? 
6IFSTUNStorage Unit NumberNumericGeneric Edit80 Allow NULL? 
7IFUML1Unit of Measure - Level 1StringUDC (00 UM)20 Allow NULL? 
8IFUGL1Group - Unit of Measure (Level 1)StringGeneric Edit20 Allow NULL? 
9IFEUL1U/M Usage - Level 1CharacterUDC (H46 EU)10 Allow NULL? 
10IFPPL1Quantity per - Level 1 (primary U/M)NumericGeneric Edit150 Allow NULL? 
11IFTQL1Quantity - Total Level 1NumericGeneric Edit150 Allow NULL? 
12IFEQL1Container Code - Level 1StringUDC (46 EQ)50 Allow NULL? 
13IFHPL1Height per - Level 1NumericGeneric Edit152 Allow NULL? 
14IFWPL1Width per - Level 1NumericGeneric Edit152 Allow NULL? 
15IFDPL1Depth per - Level 1NumericGeneric Edit152 Allow NULL? 
16IFCPL1Cubic Dimensions per - Level 1NumericGeneric Edit152 Allow NULL? 
17IFEPL1Weight per - Level 1NumericGeneric Edit152 Allow NULL? 
18IFUML2Unit of Measure - Level 2StringUDC (00 UM)20 Allow NULL? 
19IFUGL2Group - Unit of Measure (Level 2)StringGeneric Edit20 Allow NULL? 
20IFEUL2U/M Usage - Level 2CharacterUDC (H46 EU)10 Allow NULL? 
21IFQPL2Quantity per - Level 2NumericGeneric Edit150 Allow NULL? 
22IFPPL2Quantity per - Level 2 (primary U/M)NumericGeneric Edit150 Allow NULL? 
23IFTQL2Quantity - Total Level 2NumericGeneric Edit150 Allow NULL? 
24IFEQL2Container Code - Level 2StringUDC (46 EQ)50 Allow NULL? 
25IFHPL2Height per - Level 2NumericGeneric Edit152 Allow NULL? 
26IFWPL2Width per - Level 2NumericGeneric Edit152 Allow NULL? 
27IFDPL2Depth per - Level 2NumericGeneric Edit152 Allow NULL? 
28IFCPL2Cubic Dimensions per - Level 2NumericGeneric Edit152 Allow NULL? 
29IFEPL2Weight per - Level 2NumericGeneric Edit152 Allow NULL? 
30IFUML3Unit of Measure - Level 3StringUDC (00 UM)20 Allow NULL? 
31IFUGL3Group - Unit of Measure (Level 3)StringGeneric Edit20 Allow NULL? 
32IFEUL3U/M Usage - Level 3CharacterUDC (H46 EU)10 Allow NULL? 
33IFQPL3Quantity per - Level 3NumericGeneric Edit150 Allow NULL? 
34IFPPL3Quantity per - Level 3 (primary U/M)NumericGeneric Edit150 Allow NULL? 
35IFTQL3Quantity - Total Level 3NumericGeneric Edit150 Allow NULL? 
36IFEQL3Container Code - Level 3StringUDC (46 EQ)50 Allow NULL? 
37IFHPL3Height per - Level 3NumericGeneric Edit152 Allow NULL? 
38IFWPL3Width per - Level 3NumericGeneric Edit152 Allow NULL? 
39IFDPL3Depth per - Level 3NumericGeneric Edit152 Allow NULL? 
40IFCPL3Cubic Dimensions per - Level 3NumericGeneric Edit152 Allow NULL? 
41IFEPL3Weight per - Level 3NumericGeneric Edit152 Allow NULL? 
42IFUML4Unit of Measure - Level 4StringUDC (00 UM)20 Allow NULL? 
43IFUGL4Group - Unit of Measure (Level 4)StringGeneric Edit20 Allow NULL? 
44IFEUL4U/M Usage - Level 4CharacterUDC (H46 EU)10 Allow NULL? 
45IFQPL4Quantity per - Level 4NumericGeneric Edit150 Allow NULL? 
46IFPPL4Quantity per - Level 4 (primary U/M)NumericGeneric Edit150 Allow NULL? 
47IFTQL4Quantity - Total Level 4NumericGeneric Edit150 Allow NULL? 
48IFEQL4Container Code - Level 4StringUDC (46 EQ)50 Allow NULL? 
49IFHPL4Height per - Level 4NumericGeneric Edit152 Allow NULL? 
50IFWPL4Width per - Level 4NumericGeneric Edit152 Allow NULL? 
51IFDPL4Depth per - Level 4NumericGeneric Edit152 Allow NULL? 
52IFCPL4Cubic Dimensions per - Level 4NumericGeneric Edit152 Allow NULL? 
53IFEPL4Weight per - Level 4NumericGeneric Edit152 Allow NULL? 
54IFUML5Unit of Measure - Level 5StringUDC (00 UM)20 Allow NULL? 
55IFUGL5Group - Unit of Measure (Level 5)StringGeneric Edit20 Allow NULL? 
56IFEUL5U/M Usage - Level 5CharacterUDC (H46 EU)10 Allow NULL? 
57IFQPL5Quantity per - Level 5NumericGeneric Edit150 Allow NULL? 
58IFTQL5Quantity - Total Level 5NumericGeneric Edit150 Allow NULL? 
59IFEQL5Container Code - Level 5StringUDC (46 EQ)50 Allow NULL? 
60IFHPL5Height per - Level 5NumericGeneric Edit152 Allow NULL? 
61IFWPL5Width per - Level 5NumericGeneric Edit152 Allow NULL? 
62IFDPL5Depth per - Level 5NumericGeneric Edit152 Allow NULL? 
63IFCPL5Cubic Dimensions per - Level 5NumericGeneric Edit152 Allow NULL? 
64IFEPL5Weight per - Level 5NumericGeneric Edit152 Allow NULL? 
65IFUOM1Unit of Measure - PrimaryStringUDC (00 UM)20 Allow NULL? 
66IFTQTYQuantity -TotalNumericGeneric Edit150 Allow NULL? 
67IFHCOMQuantity - Hard CommittedNumericGeneric Edit150 Allow NULL? 
68IFQTRIQuantity Inbound - WarehouseNumericGeneric Edit150 Allow NULL? 
69IFQTROQuantity Outbound - WarehouseNumericGeneric Edit150 Allow NULL? 
70IFCUBEAmount - Used CubesNumericGeneric Edit152 Allow NULL? 
71IFRCUBCubic Dimensions - ReservedNumericGeneric Edit152 Allow NULL? 
72IFVUMDUnit of Measure - Volume DisplayStringUDC (00 UM)20 Allow NULL? 
73IFWEITAmount - Used WeightNumericGeneric Edit152 Allow NULL? 
74IFRWETAmount - Reserved WeightNumericGeneric Edit152 Allow NULL? 
75IFUWUMUnit of Measure - WeightStringUDC (00 UM)20 Allow NULL? 
76IFRCDJDate - ReceivedDateGeneric Edit60
77IFMMEJDate - Lot ExpirationDateGeneric Edit60
78IFDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
79IFDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
80IFKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
81IFLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
82IFSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
83IFNLINNumber of LinesNumericGeneric Edit50 Allow NULL? 
84IFUSERUser IDStringGeneric Edit100 Allow NULL? 
85IFPIDProgram IDStringGeneric Edit100 Allow NULL? 
86IFJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
87IFUPMJDate - UpdatedDateGeneric Edit60
88IFTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
89IFUOM2Unit of Measure - SecondaryStringUDC (00 UM)20 Allow NULL? 
90IFDQTYDual QuantityNumericGeneric Edit150 Allow NULL? 

TOP920 | 46 | F4602 INDEXES

NumberDescription
1Item Branch Locn Lot Seq (Primary/Unique)
ElementAliasDescriptionSequence
1ITMItem Number - ShortAscending
2MCUBusiness UnitAscending
3LOCNLocationAscending
4LOTNLot/Serial NumberAscending
5LDSQSequence Number - Location DetailAscending
2Branch Item Locn Lot UML1
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2ITMItem Number - ShortAscending
3LOCNLocationAscending
4LOTNLot/Serial NumberAscending
5UML1Unit of Measure - Level 1Ascending
3Branch Item Locn Lot UGL1
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2ITMItem Number - ShortAscending
3LOCNLocationAscending
4LOTNLot/Serial NumberAscending
5UGL1Group - Unit of Measure (Level 1)Ascending
4Item Branch UML1 PPL1
ElementAliasDescriptionSequence
1ITMItem Number - ShortAscending
2MCUBusiness UnitAscending
3UML1Unit of Measure - Level 1Ascending
4PPL1Quantity per - Level 1 (primary U/M)Ascending
5Item Branch UML2 PPL2
ElementAliasDescriptionSequence
1ITMItem Number - ShortAscending
2MCUBusiness UnitAscending
3UML2Unit of Measure - Level 2Ascending
4PPL2Quantity per - Level 2 (primary U/M)Ascending
6Item Branch UML3 PPL3
ElementAliasDescriptionSequence
1ITMItem Number - ShortAscending
2MCUBusiness UnitAscending
3UML3Unit of Measure - Level 3Ascending
4PPL3Quantity per - Level 3 (primary U/M)Ascending
7Item Branch UML4 PPL4
ElementAliasDescriptionSequence
1ITMItem Number - ShortAscending
2MCUBusiness UnitAscending
3UML4Unit of Measure - Level 4Ascending
4PPL4Quantity per - Level 4 (primary U/M)Ascending
8Item Branch UML5
ElementAliasDescriptionSequence
1ITMItem Number - ShortAscending
2MCUBusiness UnitAscending
3UML5Unit of Measure - Level 5Ascending
9Item Branch UGL1
ElementAliasDescriptionSequence
1ITMItem Number - ShortAscending
2MCUBusiness UnitAscending
3UGL1Group - Unit of Measure (Level 1)Ascending
10Item Branch UGL2
ElementAliasDescriptionSequence
1ITMItem Number - ShortAscending
2MCUBusiness UnitAscending
3UGL2Group - Unit of Measure (Level 2)Ascending
11Item Branch UGL3
ElementAliasDescriptionSequence
1ITMItem Number - ShortAscending
2MCUBusiness UnitAscending
3UGL3Group - Unit of Measure (Level 3)Ascending
12Item Branch UGL4
ElementAliasDescriptionSequence
1ITMItem Number - ShortAscending
2MCUBusiness UnitAscending
3UGL4Group - Unit of Measure (Level 4)Ascending
13Item Branch UGL5
ElementAliasDescriptionSequence
1ITMItem Number - ShortAscending
2MCUBusiness UnitAscending
3UGL5Group - Unit of Measure (Level 5)Ascending
14License Plate
ElementAliasDescriptionSequence
1STUNStorage Unit NumberAscending
15Branch Locn Item UML1 EQL1
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2LOCNLocationAscending
3ITMItem Number - ShortAscending
4UML1Unit of Measure - Level 1Ascending
5EQL1Container Code - Level 1Ascending
16DOCO DCTO KCOO SFXO LNID NLIN
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4SFXOOrder SuffixAscending
5LNIDLine NumberAscending
6NLINNumber of LinesAscending
17Branch Item STUN Locn Lot
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2ITMItem Number - ShortAscending
3STUNStorage Unit NumberAscending
4LOCNLocationAscending
5LOTNLot/Serial NumberAscending