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

189 COLUMNS | 3 INDEXES | Print definition?920 | 54R | F54R199 TABLE

54R: Rental Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F54R199DL1893Rental Contract Detail LedgerFiles54R: Rental Management
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 DLDOCO, DLDCTO, DLKCOO, DLLNID, DLUKID, DL54RLA, DLMCU, DLCO, DLNUMB, DLITM, DLLITM, DLDSC1, DLDSC2, DLQSLD, DLUOM, DLLOCN, DLLOTN, DLLNTY, DL54RIC, DL54RPM, DLCRMCU, DLEMCU, DLRLIT, DLKTLN, DLCPNT, DLRKIT, DLKTP, DLSRP1, DLSRP2, DLSRP3, DLSRP4, DLSRP5, DLPRP1, DLPRP2, DLPRP3, DLPRP4, DLPRP5, DLACL1, DLACL2, DLACL3, DLACL4, DLACL5, DLAN8, DLDVAN, DLPA8, DLPBAN, DLITAN, DLVR01, DLVR02, DLFTAN, DLSHAN, DL54RCLS, DLENTJ, DLTENT, DL54RCSD, DL54RCST, DL54RCDD, DL54RCDT, DL54RCDAD, DL54RCDAT, DL54RCID, DL54RCIT, DL54RCPED, DL54RCPET, DL54RCAED, DL54RCAET, DL54RCBSD, DL54RCBST, DL54RCBED, DL54RCBET, DLDLIJ, DL54RREF1, DL54RREF2, DL54RARSVD, DL54RCRD, DL54RCRT, DL54RCRCD, DL54RCRCT, DL54RMSTRC, DLPTC, DLRYIN, DLASN, DLPRGP, DLTRDC, DLTAX1, DLEXR1, DLTXCT, DLHOLD, DLNTR, DLCARS, DLMOT, DLCOT, DLROUT, DLSTOP, DLZON, DLCNID, DLFRTH, DLDEL1, DLDEL2, DLAFT, DLCACT, DLCEXP, DLUPRC, DLAPUM, DLPROV, DLERC, DLLPRC, DLUNCS, DLCSTO, DLATUM, DL54RRUNCS, DL54RBOD, DLBCRC, DLCRRM, DLCRCD, DLCRR, DLERDT, DL54RXRFV, DLBILLCRCD, DLFUP, DLFPRC, DLFUC, DL54RRUNCF, DL54RRTO, DL54RUSRD1, DL54RUSRD2, DL54RUSRD3, DL54RUSRT1, DL54RUSRT2, DL54RUSRT3, DL54RUSNB1, DL54RUSNB2, DL54RUSNB3, DLUSER, DLPID, DLUPMJ, DLUPMT, DLJOBN, DLMKEY, DLTORG, DLURCD, DLURDT, DLURAT, DLURAB, DLURRF, DL54RDBILL, DL54RTEMPL, DLTXA1, DL54RLEASE, DL54RLSTY, DLRP01, DLRP02, DLRP03, DLRP04, DLRP05, DLRP06, DLRP07, DLRP08, DLRP09, DLRP10, DLRP11, DLRP12, DLRP13, DLRP14, DLRP15, DLRP16, DLRP17, DLRP18, DLRP19, DLRP20, DL54RSALE1, DL54RSALE2, DL54RLNGP, DL54RAUTN, DL54RIBUM, DLTMCU, DL54RDEF01, DL54RDEF02, DL54RDEF03, DL54RUSRBM, DL54RUSRLT, DL54RTS, DL54RQTYC, DL54RQTYO, DL54RQTYS, DL54RQTYW, DL54RQTYJ, DL54RQTYR, DL54RBCRR FROM F54R199

TOP920 | 54R | F54R199 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1DLDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
2DLDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
3DLKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
4DLLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
5DLUKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
6DL54RLALedger ActionStringUDC (54R LA)20 Allow NULL? 
7DLMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
8DLCOCompanyStringGeneric Edit50 Allow NULL? 
9DLNUMBAsset Item NumberNumericGeneric Edit80 Allow NULL? 
10DLITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
11DLLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
12DLDSC1DescriptionStringGeneric Edit300 Allow NULL? 
13DLDSC2Description - Line 2StringGeneric Edit300 Allow NULL? 
14DLQSLDQuantity SoldNumericGeneric Edit150 Allow NULL? 
15DLUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
16DLLOCNLocationStringGeneric Edit200 Allow NULL? 
17DLLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
18DLLNTYLine TypeStringGeneric Edit20 Allow NULL? 
19DL54RICInventory CommitmentStringUDC (54R IC)30 Allow NULL? 
20DL54RPMBilling MethodCharacterUDC (54R BM)10 Allow NULL? 
21DLCRMCUReturn BranchStringGeneric Edit120 Allow NULL? 
22DLEMCUBusiness Unit - HeaderStringGeneric Edit120 Allow NULL? 
23DLRLITItem Number - Related (Kit)StringGeneric Edit80 Allow NULL? 
24DLKTLNKit Master Line NumberNumericGeneric Edit63 Allow NULL? 
25DLCPNTComponent Line NumberNumericGeneric Edit41 Allow NULL? 
26DLRKITRelated Kit ComponentNumericGeneric Edit80 Allow NULL? 
27DLKTPNumber of Component Per ParentNumericGeneric Edit150 Allow NULL? 
28DLSRP1Sales Catalog SectionStringUDC (41 S1)30 Allow NULL? 
29DLSRP2Sub SectionStringUDC (41 S2)30 Allow NULL? 
30DLSRP3Sales Category Code 3StringUDC (41 S3)30 Allow NULL? 
31DLSRP4Sales Category Code 4StringUDC (41 S4)30 Allow NULL? 
32DLSRP5Sales Category Code 5StringUDC (41 S5)30 Allow NULL? 
33DLPRP1Commodity ClassStringUDC (41 P1)30 Allow NULL? 
34DLPRP2Commodity Sub ClassStringUDC (41 P2)30 Allow NULL? 
35DLPRP3Supplier Rebate CodeStringUDC (41 P3)30 Allow NULL? 
36DLPRP4Master Planning FamilyStringUDC (41 P4)30 Allow NULL? 
37DLPRP5Purchasing Category Code 5StringUDC (41 P5)30 Allow NULL? 
38DLACL1Major Accounting ClassStringUDC (12 C1)30 Allow NULL? 
39DLACL2Major Equipment ClassStringUDC (12 C2)30 Allow NULL? 
40DLACL3ManufacturerStringUDC (12 C3)30 Allow NULL? 
41DLACL4Model YearStringUDC (12 C4)30 Allow NULL? 
42DLACL5Usage Miles or HoursStringUDC (12 C5)30 Allow NULL? 
43DLAN8Address NumberNumericGeneric Edit80 Allow NULL? 
44DLDVANAddress Number - Deliver ToNumericGeneric Edit80 Allow NULL? 
45DLPA8Address Number - ParentNumericGeneric Edit80 Allow NULL? 
46DLPBANAddress Number - Paid ByNumericGeneric Edit80 Allow NULL? 
47DLITANAddress Number - Invoiced ToNumericGeneric Edit80 Allow NULL? 
48DLVR01ReferenceStringGeneric Edit250 Allow NULL? 
49DLVR02Reference 2StringGeneric Edit250 Allow NULL? 
50DLFTANAddress Number - Forwarded ToNumericGeneric Edit80 Allow NULL? 
51DLSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
52DL54RCLSContract Line StatusStringUDC (54R LS)30 Allow NULL? 
53DLENTJDate - EnteredDateGeneric Edit60
54DLTENTTime EnteredNumericGeneric Edit60 Allow NULL? 
55DL54RCSDDate - StartDateGeneric Edit60
56DL54RCSTTime - StartNumericGeneric Edit60 Allow NULL? 
57DL54RCDDDate - DeliveryDateGeneric Edit60
58DL54RCDTTime - DeliveryNumericGeneric Edit60 Allow NULL? 
59DL54RCDADDate - Delivery ActualDateGeneric Edit60
60DL54RCDATTime - Delivery ActualNumericGeneric Edit60 Allow NULL? 
61DL54RCIDDate - InstallDateGeneric Edit60
62DL54RCITTime - InstallNumericGeneric Edit60 Allow NULL? 
63DL54RCPEDDate - Projected EndDateGeneric Edit60
64DL54RCPETTime - Projected EndNumericGeneric Edit60 Allow NULL? 
65DL54RCAEDDate - Actual EndDateGeneric Edit60
66DL54RCAETTime - Actual EndNumericGeneric Edit60 Allow NULL? 
67DL54RCBSDDate - Billing StartDateGeneric Edit60
68DL54RCBSTTime - Billing StartNumericGeneric Edit60 Allow NULL? 
69DL54RCBEDDate - Billing EndDateGeneric Edit60
70DL54RCBETTime - Billing EndNumericGeneric Edit60 Allow NULL? 
71DLDLIJDate - Last Invoice (Julian)DateGeneric Edit60
72DL54RREF1Reference 1StringGeneric Edit500 Allow NULL? 
73DL54RREF2Reference 2StringGeneric Edit500 Allow NULL? 
74DL54RARSVDReservation ContractCharacterGeneric Edit10 Allow NULL? 
75DL54RCRDDate - ReservationDateGeneric Edit60
76DL54RCRTTime - ReservationNumericGeneric Edit60 Allow NULL? 
77DL54RCRCDDate - Reservation CancellationDateGeneric Edit60
78DL54RCRCTTime - Reservation CancellationNumericGeneric Edit60 Allow NULL? 
79DL54RMSTRCContract MessageStringUDC (40 PM)100 Allow NULL? 
80DLPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
81DLRYINPayment InstrumentCharacterUDC (00 PY)10 Allow NULL? 
82DLASNPrice and Adjustment ScheduleStringUDC (40 AS)80 Allow NULL? 
83DLPRGPPricing GroupStringUDC (40 PC)80 Allow NULL? 
84DLTRDCDiscount - TradeNumericGeneric Edit73 Allow NULL? 
85DLTAX1Sales Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
86DLEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
87DLTXCTCertificate Tax ExemptionStringGeneric Edit200 Allow NULL? 
88DLHOLDHold Orders CodeStringUDC (42 HC)20 Allow NULL? 
89DLNTRNature of TransactionStringUDC (00 NT)20 Allow NULL? 
90DLCARSCarrier NumberNumericGeneric Edit80 Allow NULL? 
91DLMOTMode of TransportStringUDC (00 TM)30 Allow NULL? 
92DLCOTConditions of TransportStringUDC (00 TC)30 Allow NULL? 
93DLROUTRoute CodeStringUDC (42 RT)30 Allow NULL? 
94DLSTOPStop CodeStringUDC (42 SP)30 Allow NULL? 
95DLZONZone NumberStringUDC (40 ZN)30 Allow NULL? 
96DLCNIDContainer I.D.StringGeneric Edit200 Allow NULL? 
97DLFRTHFreight Handling CodeStringUDC (42 FR)30 Allow NULL? 
98DLDEL1Delivery Instructions Line 1StringGeneric Edit300 Allow NULL? 
99DLDEL2Delivery Instructions Line 2StringGeneric Edit300 Allow NULL? 
100DLAFTApply Freight - Y/NCharacterGeneric Edit10 Allow NULL? 
101DLCACTAccount Number - Credit/BankStringGeneric Edit250 Allow NULL? 
102DLCEXPDate - Expired (Julian)DateGeneric Edit60
103DLUPRCAmount - Price per UnitNumericGeneric Edit154 Allow NULL? 
104DLAPUMUnit of Measure - Entered for Unit PriceStringUDC (00 UM)20 Allow NULL? 
105DLPROVPrice Override CodeCharacterGeneric Edit10 Allow NULL? 
106DLERCEquipment Rate CodeStringUDC (00 RC)20 Allow NULL? 
107DLLPRCAmount - List PriceNumericGeneric Edit154 Allow NULL? 
108DLUNCSAmount - Unit CostNumericGeneric Edit154 Allow NULL? 
109DLCSTOCost Override CodeCharacterGeneric Edit10 Allow NULL? 
110DLATUMUnit of Measure - Entered for Unit CostStringGeneric Edit20 Allow NULL? 
111DL54RRUNCSAmount - Rehire Unit CostNumericGeneric Edit152 Allow NULL? 
112DL54RBODBased On DateCharacterGeneric Edit10 Allow NULL? 
113DLBCRCCurrency Code - BaseStringGeneric Edit30 Allow NULL? 
114DLCRRMCurrency Mode-Foreign or Domestic EntryCharacterUDC (H00 CY)10 Allow NULL? 
115DLCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
116DLCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
117DLERDTDate - Exchange RateDateGeneric Edit60
118DL54RXRFVExchange Rate - Fixed Or VariableCharacterGeneric Edit10 Allow NULL? 
119DLBILLCRCDBilled Currency CodeStringGeneric Edit30 Allow NULL? 
120DLFUPAmount - Foreign Price per UnitNumericGeneric Edit154 Allow NULL? 
121DLFPRCAmount - List Price per UnitNumericGeneric Edit154 Allow NULL? 
122DLFUCAmount - Foreign Unit CostNumericGeneric Edit154 Allow NULL? 
123DL54RRUNCFForeign Amount - Rehire Unit CostNumericGeneric Edit152 Allow NULL? 
124DL54RRTORent To OwnCharacterGeneric Edit10 Allow NULL? 
125DL54RUSRD1Date - User Defined 1DateGeneric Edit60
126DL54RUSRD2Date - User Defined 2DateGeneric Edit60
127DL54RUSRD3Date - User Defined 3DateGeneric Edit60
128DL54RUSRT1Time - User Defined 1NumericGeneric Edit60 Allow NULL? 
129DL54RUSRT2Time - User Defined 2NumericGeneric Edit60 Allow NULL? 
130DL54RUSRT3Time - User Defined 3NumericGeneric Edit60 Allow NULL? 
131DL54RUSNB1Number - User Defined 1NumericGeneric Edit80 Allow NULL? 
132DL54RUSNB2Number - User Defined 2NumericGeneric Edit80 Allow NULL? 
133DL54RUSNB3Number - User Defined 3NumericGeneric Edit80 Allow NULL? 
134DLUSERUser IDStringGeneric Edit100 Allow NULL? 
135DLPIDProgram IDStringGeneric Edit100 Allow NULL? 
136DLUPMJDate - UpdatedDateGeneric Edit60
137DLUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
138DLJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
139DLMKEYMachine KeyStringGeneric Edit150 Allow NULL? 
140DLTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
141DLURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
142DLURDTUser Reserved DateDateGeneric Edit60
143DLURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
144DLURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
145DLURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
146DL54RDBILLDetail BillingCharacterGeneric Edit10 Allow NULL? 
147DL54RTEMPLTemplate ContractCharacterGeneric Edit10 Allow NULL? 
148DLTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
149DL54RLEASELease FlagCharacterGeneric Edit10 Allow NULL? 
150DL54RLSTYLease TypeStringUDC (54R LT)20 Allow NULL? 
151DLRP01DivisionStringUDC (00 01)30 Allow NULL? 
152DLRP02RegionStringUDC (00 02)30 Allow NULL? 
153DLRP03GroupStringUDC (00 03)30 Allow NULL? 
154DLRP04Branch OfficeStringUDC (00 04)30 Allow NULL? 
155DLRP05Department TypeStringUDC (00 05)30 Allow NULL? 
156DLRP06Person ResponsibleStringUDC (00 06)30 Allow NULL? 
157DLRP07Line of BusinessStringUDC (00 07)30 Allow NULL? 
158DLRP08Category Code - Business Unit 08StringUDC (00 08)30 Allow NULL? 
159DLRP09Category Code - Business Unit 09StringUDC (00 09)30 Allow NULL? 
160DLRP10Category Code - Business Unit 10StringUDC (00 10)30 Allow NULL? 
161DLRP11Category Code - Business Unit 11StringUDC (00 11)30 Allow NULL? 
162DLRP12Category Code - Business Unit 12StringUDC (00 12)30 Allow NULL? 
163DLRP13Category Code - Business Unit 13StringUDC (00 13)30 Allow NULL? 
164DLRP14Category Code - Business Unit 14StringUDC (00 14)30 Allow NULL? 
165DLRP15Category Code - Business Unit 15StringUDC (00 15)30 Allow NULL? 
166DLRP16Category Code - Business Unit 16StringUDC (00 16)30 Allow NULL? 
167DLRP17Category Code - Business Unit 17StringUDC (00 17)30 Allow NULL? 
168DLRP18Category Code - Business Unit 18StringUDC (00 18)30 Allow NULL? 
169DLRP19Category Code - Business Unit 19StringUDC (00 19)30 Allow NULL? 
170DLRP20Category Code - Business Unit 20StringUDC (00 20)30 Allow NULL? 
171DL54RSALE1Contract Salesman 1NumericGeneric Edit80 Allow NULL? 
172DL54RSALE2Contract Salesman 2NumericGeneric Edit80 Allow NULL? 
173DL54RLNGPLanguageStringUDC (01 LP)20 Allow NULL? 
174DL54RAUTNAuthorization NumberStringGeneric Edit100 Allow NULL? 
175DL54RIBUMRental Item Billing UOMStringUDC (54R UM)20 Allow NULL? 
176DLTMCUBusiness Unit - TransferStringGeneric Edit120 Allow NULL? 
177DL54RDEF01User Defined Carrier Number FlagCharacterGeneric Edit10 Allow NULL? 
178DL54RDEF02User Defined Mode of Transportation FlagCharacterGeneric Edit10 Allow NULL? 
179DL54RDEF03User Defined Freight Handling Code FlagCharacterGeneric Edit10 Allow NULL? 
180DL54RUSRBMOverriden Billing MethodCharacterGeneric Edit10 Allow NULL? 
181DL54RUSRLTOverriden Line TypeCharacterGeneric Edit10 Allow NULL? 
182DL54RTSTransfer StatusStringUDC (54R TS)20 Allow NULL? 
183DL54RQTYCQuantity ScrappedNumericGeneric Edit150 Allow NULL? 
184DL54RQTYOQuantity OpenNumericGeneric Edit150 Allow NULL? 
185DL54RQTYSQuantity StockedNumericGeneric Edit150 Allow NULL? 
186DL54RQTYWQuantity ReworkedNumericGeneric Edit150 Allow NULL? 
187DL54RQTYJQuantity RejectedNumericGeneric Edit150 Allow NULL? 
188DL54RQTYRQuantity ReceivedNumericGeneric Edit150 Allow NULL? 
189DL54RBCRRBilling Exchange RateNumericGeneric Edit150 Allow NULL? 

TOP920 | 54R | F54R199 INDEXES

NumberDescription
1Primary key (Primary/Unique)
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4LNIDLine NumberAscending
5UKIDUnique Key ID (Internal)Ascending
2DOCO DCTO KCOO LNID
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4LNIDLine NumberAscending
3Key UKID Descending
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4LNIDLine NumberAscending
5UKIDUnique Key ID (Internal)Descending