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

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F03B11RPCustomer Ledger
8F4311PDPurchase Order Detail File
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

99 COLUMNS | 15 INDEXES | Print definition?812 | 46 | F4600 TABLE

46: Warehouse Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F4600R19915Warehouse RequestsTransaction 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 R1TYFL, R1OCDE, R1RQBT, R1RQSQ, R1KCOO, R1DOCO, R1DCTO, R1LNID, R1NLIN, R1SFXO, R1AN8, R1SHAN, R1MCU, R1ITM, R1LITM, R1AITM, R1OGRP, R1OVRQ, R1MERG, R1RLIT, R1KTLN, R1CPNT, R1RKIT, R1KTP, R1QTRQ, R1UOM, R1LDFS, R1FLOC, R1FLOT, R1STNF, R1LPNUF, R1LDTS, R1TLOC, R1TLOT, R1STNT, R1LPNUT, R1FRMP, R1THRP, R1FRGD, R1THGD, R1EXDP, R1LNTY, R1SRP1, R1SRP2, R1SRP3, R1SRP4, R1SRP5, R1PRIO, R1ROUT, R1STOP, R1ZON, R1CARS, R1BACK, R1APTS, R1COMM, R1DSC1, R1DSC2, R1INMG, R1VR01, R1PALC, R1MORD, R1LCOD, R1PACK, R1RPCK, R1PSTB, R1RCDJ, R1TRDJ, R1PDDJ, R1DRQJ, R1ZIP, R1CPNB, R1CNFR, R1RESX, R1PTYN, R1TREX, R1DTCR, R1TMCR, R1URCD, R1URDT, R1URAT, R1URAB, R1URRF, R1USER, R1PID, R1JOBN, R1UPMJ, R1TDAY, R1UKID, R1VR03, R1SHPN, R1LDNM, R1VMCU, R1SBCK, R1EDCK, R1CMDM, R1BBCK, R1PSJOBNO, R1JOBSQ, R1DELBATCH FROM F4600

TOP812 | 46 | F4600 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1R1TYFLCode - WarehouseCharacterGeneric Edit10 Allow NULL? 
2R1OCDECode - OriginStringGeneric Edit20 Allow NULL? 
3R1RQBTBatch Number - RequestsNumericGeneric Edit80 Allow NULL? 
4R1RQSQSequence Number - RequestNumericGeneric Edit73 Allow NULL? 
5R1KCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
6R1DOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
7R1DCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
8R1LNIDLine NumberNumericGeneric Edit63 Allow NULL? 
9R1NLINNumber of LinesNumericGeneric Edit50 Allow NULL? 
10R1SFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
11R1AN8Address NumberNumericUDC80 Allow NULL? 
12R1SHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
13R1MCUBusiness UnitStringGeneric Edit120 Allow NULL? 
14R1ITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
15R1LITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
16R1AITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
17R1OGRPOrder GroupStringUDC (46 DT)40 Allow NULL? 
18R1OVRQOverride Request (Y/N)CharacterGeneric Edit10 Allow NULL? 
19R1MERGTop Off (Y/N)CharacterGeneric Edit10 Allow NULL? 
20R1RLITItem Number - Related (Kit)StringGeneric Edit80 Allow NULL? 
21R1KTLNKit Master Line NumberNumericGeneric Edit63 Allow NULL? 
22R1CPNTComponent Line NumberNumericGeneric Edit41 Allow NULL? 
23R1RKITRelated Kit ComponentNumericGeneric Edit80 Allow NULL? 
24R1KTPNumber of Component Per ParentNumericGeneric Edit152 Allow NULL? 
25R1QTRQQuantity - Requested in primary U/MNumericGeneric Edit152 Allow NULL? 
26R1UOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
27R1LDFSSequence Number - Location Detail (From)NumericGeneric Edit80 Allow NULL? 
28R1FLOCLocation - FromStringGeneric Edit200 Allow NULL? 
29R1FLOTLot - FromStringGeneric Edit300 Allow NULL? 
30R1STNFStorage Unit Number - FromNumericGeneric Edit80 Allow NULL? 
31R1LPNUFFrom License Plate NumberStringGeneric Edit400 Allow NULL? 
32R1LDTSSequence Number - Location Detail (To)NumericGeneric Edit80 Allow NULL? 
33R1TLOCLocation - ToStringGeneric Edit200 Allow NULL? 
34R1TLOTLot - ToStringGeneric Edit300 Allow NULL? 
35R1STNTStorage Unit Number - ToNumericGeneric Edit80 Allow NULL? 
36R1LPNUTToLicense Plate NumberStringGeneric Edit400 Allow NULL? 
37R1FRMPFrom PotencyNumericGeneric Edit73 Allow NULL? 
38R1THRPThru PotencyNumericGeneric Edit73 Allow NULL? 
39R1FRGDFrom GradeStringUDC (40 LG)30 Allow NULL? 
40R1THGDThru GradeStringUDC (40 LG)30 Allow NULL? 
41R1EXDPDays Before ExpirationNumericGeneric Edit50 Allow NULL? 
42R1LNTYLine TypeStringGeneric Edit20 Allow NULL? 
43R1SRP1Sales Rpt 01 - Product FamilyStringUDC (41 S1)30 Allow NULL? 
44R1SRP2Sales Rpt 02 - Family SectionStringUDC (41 S2)30 Allow NULL? 
45R1SRP3Sales Category Code 3StringUDC (41 S3)30 Allow NULL? 
46R1SRP4Sales Category Code 4StringUDC (41 S4)30 Allow NULL? 
47R1SRP5Sales Category Code 5StringUDC (41 S5)30 Allow NULL? 
48R1PRIOPriority - ProcessingCharacterUDC (H40 PR)10 Allow NULL? 
49R1ROUTRoute CodeStringUDC (42 RT)30 Allow NULL? 
50R1STOPStop CodeStringUDC (42 SP)30 Allow NULL? 
51R1ZONZone NumberStringUDC (40 ZN)30 Allow NULL? 
52R1CARSCarrier NumberNumericGeneric Edit80 Allow NULL? 
53R1BACKBackorders Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
54R1APTSPartial Line Shipments Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
55R1COMMCommitted (H/S)CharacterUDC (H42 CP)10 Allow NULL? 
56R1DSC1DescriptionStringGeneric Edit300 Allow NULL? 
57R1DSC2Description - Line 2StringGeneric Edit300 Allow NULL? 
58R1INMGPrint MessageStringUDC (40 PM)100 Allow NULL? 
59R1VR01ReferenceStringGeneric Edit250 Allow NULL? 
60R1PALCPallet ControlCharacterGeneric Edit10 Allow NULL? 
61R1MORDMerge Orders (Y/N)CharacterGeneric Edit10 Allow NULL? 
62R1LCODCode - Location Tax StatusStringUDC (46 LT)20 Allow NULL? 
63R1PACKCode - PackingStringUDC (46 PK)40 Allow NULL? 
64R1RPCKRepack (Y/N)CharacterGeneric Edit10 Allow NULL? 
65R1PSTBStatus - Task / TripStringUDC (46 PS)30 Allow NULL? 
66R1RCDJDate - ReceivedDateGeneric Edit60
67R1TRDJDate - Order/TransactionDateGeneric Edit60
68R1PDDJDate - Scheduled PickDateGeneric Edit60
69R1DRQJDate - RequestedDateGeneric Edit60
70R1ZIPZip Code - Sold to Postal CodeStringGeneric Edit120 Allow NULL? 
71R1CPNBComponent Line Number BOMNumericGeneric Edit82 Allow NULL? 
72R1CNFRAutomatically Confirm (Y/N)CharacterGeneric Edit10 Allow NULL? 
73R1RESXReservations UsedCharacterGeneric Edit10 Allow NULL? 
74R1PTYNOverride Location (Y/N)CharacterGeneric Edit10 Allow NULL? 
75R1TREXExplanation - TransactionStringGeneric Edit300 Allow NULL? 
76R1DTCRDate - Created (Julian)DateGeneric Edit60
77R1TMCRTime - CreatedNumericGeneric Edit60 Allow NULL? 
78R1URCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
79R1URDTUser Reserved DateDateGeneric Edit60
80R1URATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
81R1URABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
82R1URRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
83R1USERUser IDStringGeneric Edit100 Allow NULL? 
84R1PIDProgram IDStringGeneric Edit100 Allow NULL? 
85R1JOBNWork Station IDStringGeneric Edit100 Allow NULL? 
86R1UPMJDate - UpdatedDateGeneric Edit60
87R1TDAYTime of DayNumericGeneric Edit60 Allow NULL? 
88R1UKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
89R1VR03ReferenceStringGeneric Edit250 Allow NULL? 
90R1SHPNShipment NumberNumericGeneric Edit80 Allow NULL? 
91R1LDNMLoad NumberNumericGeneric Edit80 Allow NULL? 
92R1VMCUDepot - TripStringGeneric Edit120 Allow NULL? 
93R1SBCKCheck Sell By DateCharacterGeneric Edit10 Allow NULL? 
94R1EDCKCheck Expiration DateCharacterGeneric Edit10 Allow NULL? 
95R1CMDMCommitment Date MethodCharacterUDC (H40 CD)10 Allow NULL? 
96R1BBCKCheck Best Before DateCharacterGeneric Edit10 Allow NULL? 
97R1PSJOBNOProduction Sequencing Job NumberStringGeneric Edit150 Allow NULL? 
98R1JOBSQJob Sequence NumberStringGeneric Edit150 Allow NULL? 
99R1DELBATCHDelivery Batch NumberStringGeneric Edit60 Allow NULL? 

TOP812 | 46 | F4600 INDEXES

NumberDescription
1Batch#_Request (Primary/Unique)
ElementAliasDescriptionSequence
1RQBTBatch Number - RequestsAscending
2RQSQSequence Number - RequestAscending
2Doc_DocType
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4LNIDLine NumberAscending
5NLINNumber of LinesAscending
3Doc#_DocType_Status
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4LNIDLine NumberAscending
5PSTBStatus - Task / TripAscending
5Wh_CC_Btch#_Seq
ElementAliasDescriptionSequence
1TYFLCode - WarehouseAscending
2MCUBusiness UnitAscending
3RQBTBatch Number - RequestsAscending
4RQSQSequence Number - RequestAscending
6Wh_CC_Status_Btch#_Seq
ElementAliasDescriptionSequence
1TYFLCode - WarehouseAscending
2MCUBusiness UnitAscending
3PSTBStatus - Task / TripAscending
4RQBTBatch Number - RequestsAscending
5RQSQSequence Number - RequestAscending
7Wh_Itm_Status_Btch#_Seq
ElementAliasDescriptionSequence
1TYFLCode - WarehouseAscending
2ITMItem Number - ShortAscending
3PSTBStatus - Task / TripAscending
4RQBTBatch Number - RequestsAscending
5RQSQSequence Number - RequestAscending
8Wh_Btch#_Seq
ElementAliasDescriptionSequence
1TYFLCode - WarehouseAscending
2RQBTBatch Number - RequestsAscending
3RQSQSequence Number - RequestAscending
9Wh_Itm_Btch#_Seq
ElementAliasDescriptionSequence
1RQSQSequence Number - RequestAscending
2TYFLCode - WarehouseAscending
3ITMItem Number - ShortAscending
4RQBTBatch Number - RequestsAscending
10Wh_Status_Btch#_Seq
ElementAliasDescriptionSequence
1TYFLCode - WarehouseAscending
2PSTBStatus - Task / TripAscending
3RQBTBatch Number - RequestsAscending
4RQSQSequence Number - RequestAscending
12Tyfl Ocde Mcu Itm Floc Flot Ps
ElementAliasDescriptionSequence
1TYFLCode - WarehouseAscending
2OCDECode - OriginAscending
3MCUBusiness UnitAscending
4ITMItem Number - ShortAscending
5FLOCLocation - FromAscending
6FLOTLot - FromAscending
7PSTBStatus - Task / TripAscending
8DOCODocument (Order No Invoice etc.)Ascending
13Mcu_Itm_Floc_Flot
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2ITMItem Number - ShortAscending
3FLOCLocation - FromAscending
4FLOTLot - FromAscending
14Mcu_Itm_Tloc_Tlot
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2ITMItem Number - ShortAscending
3TLOCLocation - ToAscending
4TLOTLot - ToAscending
15FromLicensePlate
ElementAliasDescriptionSequence
1STNFStorage Unit Number - FromAscending
16FromLP
ElementAliasDescriptionSequence
1LPNUFFrom License Plate NumberAscending
17Chk Existing LP Req
ElementAliasDescriptionSequence
1LPNUFFrom License Plate NumberAscending
2MCUBusiness UnitAscending
3PSTBStatus - Task / TripAscending