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

159 COLUMNS | 14 INDEXES | Print definition?812 | 46 | F4611 TABLE

46: Warehouse Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F4611R215914Warehouse SuggestionsTransaction Files46: Warehouse ManagementAS400 Coexistence Tables
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 R2TYFL, R2OCDE, R2RQBT, R2RQSQ, R2SGBT, R2SGSQ, R2PWAV, R2PTSK, R2TRIP, R2MCU, R2KCOO, R2DOCO, R2DCTO, R2LNID, R2NLIN, R2SFXO, R2CLID, R2ITM, R2LITM, R2AITM, R2UML1, R2TQL1, R2EQL1, R2UML2, R2QPL2, R2TQL2, R2EQL2, R2UML3, R2QPL3, R2TQL3, R2EQL3, R2UML4, R2QPL4, R2TQL4, R2EQL4, R2CPNB, R2UML5, R2QPL5, R2TQL5, R2EQL5, R2UOM1, R2TQTY, R2CUBE, R2VUMD, R2WEIT, R2UWUM, R2LDFS, R2FLOC, R2FLOT, R2STNF, R2LDTS, R2TLOC, R2TLOT, R2STNT, R2LOTP, R2LOTG, R2MERG, R2EQTY, R2CRMT, R2BACK, R2APTS, R2COMM, R2ITCM, R2DSC1, R2DSC2, R2INMG, R2VR01, R2PALC, R2MORD, R2RLIT, R2KTLN, R2CPNT, R2RKIT, R2KTP, R2KTBL, R2PTPH, R2ZIP, R2SRP1, R2SRP2, R2SRP3, R2SRP4, R2SRP5, R2PRP6, R2PRP7, R2PRP8, R2PRP9, R2MPUT, R2PUTP, R2SEQ, R2RCDJ, R2TRDJ, R2DRQJ, R2PDDJ, R2PACK, R2RPCK, R2EKEY, R2CODR, R2PSTB, R2RESX, R2PZON, R2KZON, R2ZONR, R2AISL, R2BIN, R2LA03, R2LA04, R2LA05, R2LA06, R2LA07, R2LA08, R2LA09, R2LA10, R2WSQP, R2WSQQ, R2WSQR, R2MMTH, R2AN8, R2SHAN, R2LNTY, R2PRIO, R2CARS, R2ROUT, R2STOP, R2ZON, R2CTNF, R2VSUG, R2PHAS, R2RSBT, R2RSSQ, R2IUSE, R2TREX, R2DTCR, R2TMCR, R2DTPT, R2TMPT, R2TRPR, R2URCD, R2URDT, R2URAT, R2URAB, R2URRF, R2RCDS, R2USER, R2PID, R2JOBN, R2UPMJ, R2TDAY, R2UKID, R2CKID, R2VR03, R2SHPN, R2LDNM, R2VMCU, R2PLPNU, R2LPNUF, R2LPNUT, R2PSJOBNO, R2JOBSQ, R2DELBATCH FROM F4611

TOP812 | 46 | F4611 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1R2TYFLCode - WarehouseCharacterGeneric Edit10 Allow NULL? 
2R2OCDECode - OriginStringGeneric Edit20 Allow NULL? 
3R2RQBTBatch Number - RequestsNumericGeneric Edit80 Allow NULL? 
4R2RQSQSequence Number - RequestNumericGeneric Edit73 Allow NULL? 
5R2SGBTBatch Number - SuggestionsNumericGeneric Edit80 Allow NULL? 
6R2SGSQSequence Number - SuggestionNumericGeneric Edit73 Allow NULL? 
7R2PWAVNumber - WaveNumericGeneric Edit80 Allow NULL? 
8R2PTSKNumber - Warehouse TaskNumericGeneric Edit80 Allow NULL? 
9R2TRIPNumber - TripNumericGeneric Edit73 Allow NULL? 
10R2MCUBusiness UnitStringGeneric Edit120 Allow NULL? 
11R2KCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
12R2DOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
13R2DCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
14R2LNIDLine NumberNumericGeneric Edit63 Allow NULL? 
15R2NLINNumber of LinesNumericGeneric Edit50 Allow NULL? 
16R2SFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
17R2CLIDConfirmed Line NumberNumericGeneric Edit63 Allow NULL? 
18R2ITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
19R2LITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
20R2AITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
21R2UML1Unit of Measure - Level 1StringUDC (00 UM)20 Allow NULL? 
22R2TQL1Quantity - Total Level 1NumericGeneric Edit152 Allow NULL? 
23R2EQL1Container Code - Level 1StringUDC (46 EQ)50 Allow NULL? 
24R2UML2Unit of Measure - Level 2StringUDC (00 UM)20 Allow NULL? 
25R2QPL2Quantity per - Level 2NumericGeneric Edit152 Allow NULL? 
26R2TQL2Quantity - Total Level 2NumericGeneric Edit152 Allow NULL? 
27R2EQL2Container Code - Level 2StringUDC (46 EQ)50 Allow NULL? 
28R2UML3Unit of Measure - Level 3StringUDC (00 UM)20 Allow NULL? 
29R2QPL3Quantity per - Level 3NumericGeneric Edit152 Allow NULL? 
30R2TQL3Quantity - Total Level 3NumericGeneric Edit152 Allow NULL? 
31R2EQL3Container Code - Level 3StringUDC (46 EQ)50 Allow NULL? 
32R2UML4Unit of Measure - Level 4StringUDC (00 UM)20 Allow NULL? 
33R2QPL4Quantity per - Level 4NumericGeneric Edit152 Allow NULL? 
34R2TQL4Quantity - Total Level 4NumericGeneric Edit152 Allow NULL? 
35R2EQL4Container Code - Level 4StringUDC (46 EQ)50 Allow NULL? 
36R2CPNBComponent Line Number BOMNumericGeneric Edit82 Allow NULL? 
37R2UML5Unit of Measure - Level 5StringUDC (00 UM)20 Allow NULL? 
38R2QPL5Quantity per - Level 5NumericGeneric Edit152 Allow NULL? 
39R2TQL5Quantity - Total Level 5NumericGeneric Edit152 Allow NULL? 
40R2EQL5Container Code - Level 5StringUDC (46 EQ)50 Allow NULL? 
41R2UOM1Unit of Measure - PrimaryStringUDC (00 UM)20 Allow NULL? 
42R2TQTYQuantity -TotalNumericGeneric Edit152 Allow NULL? 
43R2CUBEAmount - Used CubesNumericGeneric Edit152 Allow NULL? 
44R2VUMDUnit of Measure - Volume DisplayStringUDC (00 UM)20 Allow NULL? 
45R2WEITAmount - Used WeightNumericGeneric Edit152 Allow NULL? 
46R2UWUMUnit of Measure - WeightStringUDC (00 UM)20 Allow NULL? 
47R2LDFSSequence Number - Location Detail (From)NumericGeneric Edit80 Allow NULL? 
48R2FLOCLocation - FromStringGeneric Edit200 Allow NULL? 
49R2FLOTLot - FromStringGeneric Edit300 Allow NULL? 
50R2STNFStorage Unit Number - FromNumericGeneric Edit80 Allow NULL? 
51R2LDTSSequence Number - Location Detail (To)NumericGeneric Edit80 Allow NULL? 
52R2TLOCLocation - ToStringGeneric Edit200 Allow NULL? 
53R2TLOTLot - ToStringGeneric Edit300 Allow NULL? 
54R2STNTStorage Unit Number - ToNumericGeneric Edit80 Allow NULL? 
55R2LOTPLot PotencyNumericGeneric Edit153 Allow NULL? 
56R2LOTGLot GradeStringUDC (40 LG)30 Allow NULL? 
57R2MERGTop Off (Y/N)CharacterGeneric Edit10 Allow NULL? 
58R2EQTYContainer CodeStringUDC (46 EQ)50 Allow NULL? 
59R2CRMTCarton Recommendation MethodCharacterUDC (H46 CR)10 Allow NULL? 
60R2BACKBackorders Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
61R2APTSPartial Line Shipments Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
62R2COMMCommitted (H/S)CharacterUDC (H42 CP)10 Allow NULL? 
63R2ITCMIn Transit Committed (Y/N)CharacterGeneric Edit10 Allow NULL? 
64R2DSC1DescriptionStringGeneric Edit300 Allow NULL? 
65R2DSC2Description - Line 2StringGeneric Edit300 Allow NULL? 
66R2INMGPrint MessageStringUDC (40 PM)100 Allow NULL? 
67R2VR01ReferenceStringGeneric Edit250 Allow NULL? 
68R2PALCPallet ControlCharacterGeneric Edit10 Allow NULL? 
69R2MORDMerge Orders (Y/N)CharacterGeneric Edit10 Allow NULL? 
70R2RLITItem Number - Related (Kit)StringGeneric Edit80 Allow NULL? 
71R2KTLNKit Master Line NumberNumericGeneric Edit63 Allow NULL? 
72R2CPNTComponent Line NumberNumericGeneric Edit41 Allow NULL? 
73R2RKITRelated Kit ComponentNumericGeneric Edit80 Allow NULL? 
74R2KTPNumber of Component Per ParentNumericGeneric Edit152 Allow NULL? 
75R2KTBLKit Balanced (Y/N)CharacterGeneric Edit10 Allow NULL? 
76R2PTPH1 or 2 Phase PutawayCharacterUDC (H46 PT)10 Allow NULL? 
77R2ZIPZip Code - Sold to Postal CodeStringGeneric Edit120 Allow NULL? 
78R2SRP1Sales Rpt 01 - Product FamilyStringUDC (41 S1)30 Allow NULL? 
79R2SRP2Sales Rpt 02 - Family SectionStringUDC (41 S2)30 Allow NULL? 
80R2SRP3Sales Category Code 3StringUDC (41 S3)30 Allow NULL? 
81R2SRP4Sales Category Code 4StringUDC (41 S4)30 Allow NULL? 
82R2SRP5Sales Category Code 5StringUDC (41 S5)30 Allow NULL? 
83R2PRP6Group - Item DimensionStringUDC (41 01)60 Allow NULL? 
84R2PRP7Group - Warehouse Process 1StringUDC (41 02)60 Allow NULL? 
85R2PRP8Group - Warehouse Process 2StringUDC (41 02)60 Allow NULL? 
86R2PRP9Group - Warehouse Process 3StringUDC (41 02)60 Allow NULL? 
87R2MPUTTable - Putaway InstructionsStringUDC (46 IT)60 Allow NULL? 
88R2PUTPProcess ModeCharacterUDC (46 PC)10 Allow NULL? 
89R2SEQSequence NumberNumericGeneric Edit60 Allow NULL? 
90R2RCDJDate - ReceivedDateGeneric Edit60
91R2TRDJDate - Order/TransactionDateGeneric Edit60
92R2DRQJDate - RequestedDateGeneric Edit60
93R2PDDJDate - Scheduled PickDateGeneric Edit60
94R2PACKCode - PackingStringUDC (46 PK)40 Allow NULL? 
95R2RPCKRepack (Y/N)CharacterGeneric Edit10 Allow NULL? 
96R2EKEYError Message KeyStringGeneric Edit40 Allow NULL? 
97R2CODRReason CodeStringUDC (42 RC)30 Allow NULL? 
98R2PSTBStatus - Task / TripStringUDC (46 PS)30 Allow NULL? 
99R2RESXReservations UsedCharacterGeneric Edit10 Allow NULL? 
100R2PZONZone - PutawayStringUDC (46 ZN)60 Allow NULL? 
101R2KZONZone - PickingStringUDC (46 ZN)60 Allow NULL? 
102R2ZONRZone - ReplenishmentStringUDC (46 ZN)60 Allow NULL? 
103R2AISLAisleStringGeneric Edit80 Allow NULL? 
104R2BINBinStringGeneric Edit80 Allow NULL? 
105R2LA03Category Code - Location 03StringGeneric Edit40 Allow NULL? 
106R2LA04Category Code - Location 04StringGeneric Edit40 Allow NULL? 
107R2LA05Category Code - Location 05StringGeneric Edit40 Allow NULL? 
108R2LA06Category Code - Location 06StringGeneric Edit40 Allow NULL? 
109R2LA07Category Code - Location 07StringGeneric Edit40 Allow NULL? 
110R2LA08Category Code - Location 08StringGeneric Edit40 Allow NULL? 
111R2LA09Category Code - Location 09StringGeneric Edit40 Allow NULL? 
112R2LA10Category Code - Location 10StringGeneric Edit40 Allow NULL? 
113R2WSQPSequence Code - PutawayNumericGeneric Edit50 Allow NULL? 
114R2WSQQSequence Code - PickingNumericGeneric Edit50 Allow NULL? 
115R2WSQRSequence Code - ReplenishmentNumericGeneric Edit50 Allow NULL? 
116R2MMTHMove Method CodeStringGeneric Edit40 Allow NULL? 
117R2AN8Address NumberNumericUDC80 Allow NULL? 
118R2SHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
119R2LNTYLine TypeStringGeneric Edit20 Allow NULL? 
120R2PRIOPriority - ProcessingCharacterUDC (H40 PR)10 Allow NULL? 
121R2CARSCarrier NumberNumericGeneric Edit80 Allow NULL? 
122R2ROUTRoute CodeStringUDC (42 RT)30 Allow NULL? 
123R2STOPStop CodeStringUDC (42 SP)30 Allow NULL? 
124R2ZONZone NumberStringUDC (40 ZN)30 Allow NULL? 
125R2CTNFCarton Recommendation (Y/N)CharacterGeneric Edit10 Allow NULL? 
126R2VSUGVariance Suggestion (Y/N)CharacterGeneric Edit10 Allow NULL? 
127R2PHASPhaseCharacterUDC (H46 PH)10 Allow NULL? 
128R2RSBTBatch Number - Related SuggestionNumericGeneric Edit80 Allow NULL? 
129R2RSSQBatch Number - Related SuggestionNumericGeneric Edit73 Allow NULL? 
130R2IUSERecord in Use (Y/N)CharacterGeneric Edit10 Allow NULL? 
131R2TREXExplanation - TransactionStringGeneric Edit300 Allow NULL? 
132R2DTCRDate - Created (Julian)DateGeneric Edit60
133R2TMCRTime - CreatedNumericGeneric Edit60 Allow NULL? 
134R2DTPTDate - Printed (Julian)DateGeneric Edit60
135R2TMPTTime - PrintedNumericGeneric Edit60 Allow NULL? 
136R2TRPRPriority - TripNumericGeneric Edit50 Allow NULL? 
137R2URCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
138R2URDTUser Reserved DateDateGeneric Edit60
139R2URATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
140R2URABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
141R2URRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
142R2RCDSStatus - RecordCharacterGeneric Edit10 Allow NULL? 
143R2USERUser IDStringGeneric Edit100 Allow NULL? 
144R2PIDProgram IDStringGeneric Edit100 Allow NULL? 
145R2JOBNWork Station IDStringGeneric Edit100 Allow NULL? 
146R2UPMJDate - UpdatedDateGeneric Edit60
147R2TDAYTime of DayNumericGeneric Edit60 Allow NULL? 
148R2UKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
149R2CKIDConfirmed Unique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
150R2VR03ReferenceStringGeneric Edit250 Allow NULL? 
151R2SHPNShipment NumberNumericGeneric Edit80 Allow NULL? 
152R2LDNMLoad NumberNumericGeneric Edit80 Allow NULL? 
153R2VMCUDepot - TripStringGeneric Edit120 Allow NULL? 
154R2PLPNUParent License Plate NumberStringGeneric Edit400 Allow NULL? 
155R2LPNUFFrom License Plate NumberStringGeneric Edit400 Allow NULL? 
156R2LPNUTToLicense Plate NumberStringGeneric Edit400 Allow NULL? 
157R2PSJOBNOProduction Sequencing Job NumberStringGeneric Edit150 Allow NULL? 
158R2JOBSQJob Sequence NumberStringGeneric Edit150 Allow NULL? 
159R2DELBATCHDelivery Batch NumberStringGeneric Edit60 Allow NULL? 

TOP812 | 46 | F4611 INDEXES

NumberDescription
1BatchNoSugg SeqNoSugg (Primary/Unique)
ElementAliasDescriptionSequence
1SGBTBatch Number - SuggestionsAscending
2SGSQSequence Number - SuggestionAscending
2Tyfl Ocde Mcu Itm Pstb
ElementAliasDescriptionSequence
1TYFLCode - WarehouseAscending
2OCDECode - OriginAscending
3MCUBusiness UnitAscending
4ITMItem Number - ShortAscending
5PSTBStatus - Task / TripAscending
4Batch#_Request
ElementAliasDescriptionSequence
1RQBTBatch Number - RequestsAscending
2RQSQSequence Number - RequestAscending
7Tyfl_Doco_Dcto_Kcoo_Clid
ElementAliasDescriptionSequence
1TYFLCode - WarehouseAscending
2DOCODocument (Order No Invoice etc.)Ascending
3DCTOOrder TypeAscending
4KCOOOrder Company (Order Number)Ascending
5CLIDConfirmed Line NumberAscending
8Tyfl_Doco_Dcto_Kcoo_Lnid
ElementAliasDescriptionSequence
1TYFLCode - WarehouseAscending
2DOCODocument (Order No Invoice etc.)Ascending
3DCTOOrder TypeAscending
4KCOOOrder Company (Order Number)Ascending
5LNIDLine NumberAscending
6NLINNumber of LinesAscending
7SFXOOrder SuffixAscending
8PTSKNumber - Warehouse TaskAscending
9TRIPNumber - TripAscending
9Tyfl_Pstb_Ptsk_Trip
ElementAliasDescriptionSequence
1TYFLCode - WarehouseAscending
2PSTBStatus - Task / TripAscending
3PTSKNumber - Warehouse TaskAscending
4TRIPNumber - TripAscending
10Tyfl Ocde Mcu Itm Floc Flot Ps
ElementAliasDescriptionSequence
1TYFLCode - WarehouseAscending
2OCDECode - OriginAscending
3MCUBusiness UnitAscending
4ITMItem Number - ShortAscending
5FLOCLocation - FromAscending
6FLOTLot - FromAscending
7PSTBStatus - Task / TripAscending
11Ukid Flot Clid
ElementAliasDescriptionSequence
1UKIDUnique Key ID (Internal)Ascending
2FLOTLot - FromAscending
3CKIDConfirmed Unique Key ID (Internal)Ascending
12Mcu_Itm_Floc_Flot
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2ITMItem Number - ShortAscending
3FLOCLocation - FromAscending
4FLOTLot - FromAscending
13Mcu_Itm_Tloc_Tlot
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2ITMItem Number - ShortAscending
3TLOCLocation - ToAscending
4TLOTLot - ToAscending
14Ptsk_Trip
ElementAliasDescriptionSequence
1PTSKNumber - Warehouse TaskAscending
2TRIPNumber - TripAscending
15Sgbt_Ptsk_Trip
ElementAliasDescriptionSequence
1SGBTBatch Number - SuggestionsAscending
2PTSKNumber - Warehouse TaskAscending
3TRIPNumber - TripAscending
16Shpn_Tyfl
ElementAliasDescriptionSequence
1SHPNShipment NumberAscending
2TYFLCode - WarehouseAscending
17Shpn_psjobno_jobsq
ElementAliasDescriptionSequence
1SHPNShipment NumberAscending
2PSJOBNOProduction Sequencing Job NumberAscending
3JOBSQJob Sequence NumberAscending