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
3F4101IMItem Master
4F0911GLAccount Ledger
5F4311PDPurchase Order Detail File
6F4102IBItem Branch File
7F0411RPAccounts Payable Ledger
8F41021LIItem Location File
9F03012AICustomer Master by Line of Business
10F0006MCBusiness Unit Master

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F4311PDPurchase Order Detail File
8F03B11RPCustomer Ledger
9F0411RPAccounts Payable Ledger
10F4111ILItem Ledger File

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

158 COLUMNS | 1 INDEXES | Print definition?812 | 46 | F4611PU TABLE

46: Warehouse Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F4611PUR21581Warehouse Suggestions - PurgedPurge Files46: Warehouse ManagementNo
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, 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, R2DTE, R2TICU, R2SCHUSER, R2SHPN, R2LDNM, R2CPNB, R2VMCU, R2PSJOBNO, R2JOBSQ, R2DELBATCH FROM F4611PU

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

TOP812 | 46 | F4611PU INDEXES

NumberDescription
1BatchNoSugg SeqNoSugg (Primary/Unique)
ElementAliasDescriptionSequence
1SGBTBatch Number - SuggestionsAscending
2SGSQSequence Number - SuggestionAscending