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
6F0006MCBusiness Unit Master
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

187 COLUMNS | 5 INDEXES | Print definition?920 | 54R | F54R11 TABLE

54R: Rental Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F54R11CD1875Rental Contract DetailFiles54R: 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 CDDOCO, CDDCTO, CDKCOO, CDLNID, CDMCU, CDCO, CDNUMB, CDITM, CDLITM, CDDSC1, CDDSC2, CDQSLD, CD54RQTYO, CD54RQTYS, CD54RQTYW, CD54RQTYJ, CD54RQTYC, CD54RQTYR, CDUOM, CDLOCN, CDLOTN, CDLNTY, CD54RIC, CD54RPM, CDCRMCU, CDEMCU, CDRLIT, CDKTLN, CDCPNT, CDRKIT, CDKTP, CDSRP1, CDSRP2, CDSRP3, CDSRP4, CDSRP5, CDPRP1, CDPRP2, CDPRP3, CDPRP4, CDPRP5, CDACL1, CDACL2, CDACL3, CDACL4, CDACL5, CDAN8, CDDVAN, CDPA8, CDPBAN, CDITAN, CDVR01, CDVR02, CDFTAN, CDSHAN, CD54RCLS, CDENTJ, CDTENT, CD54RCSD, CD54RCST, CD54RCDD, CD54RCDT, CD54RCDAD, CD54RCDAT, CD54RCID, CD54RCIT, CD54RCPED, CD54RCPET, CD54RCAED, CD54RCAET, CD54RCBSD, CD54RCBST, CD54RCBED, CD54RCBET, CDDLIJ, CD54RREF1, CD54RREF2, CD54RARSVD, CD54RCRD, CD54RCRT, CD54RCRCD, CD54RCRCT, CD54RMSTRC, CDPTC, CDRYIN, CDASN, CDPRGP, CDTRDC, CDTAX1, CDEXR1, CDTXCT, CDHOLD, CDNTR, CDCARS, CDMOT, CDCOT, CDROUT, CDSTOP, CDZON, CDCNID, CDFRTH, CDDEL1, CDDEL2, CDAFT, CDCACT, CDCEXP, CDUPRC, CDAPUM, CDPROV, CDERC, CDLPRC, CDUNCS, CDCSTO, CDATUM, CD54RRUNCS, CD54RBOD, CDBCRC, CDCRRM, CDCRCD, CDCRR, CDERDT, CD54RXRFV, CDBILLCRCD, CDFUP, CDFPRC, CDFUC, CD54RRUNCF, CD54RRTO, CD54RUSRD1, CD54RUSRD2, CD54RUSRD3, CD54RUSRT1, CD54RUSRT2, CD54RUSRT3, CD54RUSNB1, CD54RUSNB2, CD54RUSNB3, CDUSER, CDPID, CDUPMJ, CDUPMT, CDJOBN, CDMKEY, CDTORG, CDURCD, CDURDT, CDURAT, CDURAB, CDURRF, CD54RDBILL, CD54RTEMPL, CDTXA1, CD54RLEASE, CD54RLSTY, CDRP01, CDRP02, CDRP03, CDRP04, CDRP05, CDRP06, CDRP07, CDRP08, CDRP09, CDRP10, CDRP11, CDRP12, CDRP13, CDRP14, CDRP15, CDRP16, CDRP17, CDRP18, CDRP19, CDRP20, CD54RSALE1, CD54RSALE2, CD54RLNGP, CD54RAUTN, CD54RIBUM, CDTMCU, CD54RDEF01, CD54RDEF02, CD54RDEF03, CD54RUSRBM, CD54RUSRLT, CD54RTS, CD54RBCRR FROM F54R11

TOP920 | 54R | F54R11 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1CDDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
2CDDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
3CDKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
4CDLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
5CDMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
6CDCOCompanyStringGeneric Edit50 Allow NULL? 
7CDNUMBAsset Item NumberNumericGeneric Edit80 Allow NULL? 
8CDITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
9CDLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
10CDDSC1DescriptionStringGeneric Edit300 Allow NULL? 
11CDDSC2Description - Line 2StringGeneric Edit300 Allow NULL? 
12CDQSLDQuantity SoldNumericGeneric Edit150 Allow NULL? 
13CD54RQTYOQuantity OpenNumericGeneric Edit150 Allow NULL? 
14CD54RQTYSQuantity StockedNumericGeneric Edit150 Allow NULL? 
15CD54RQTYWQuantity ReworkedNumericGeneric Edit150 Allow NULL? 
16CD54RQTYJQuantity RejectedNumericGeneric Edit150 Allow NULL? 
17CD54RQTYCQuantity ScrappedNumericGeneric Edit150 Allow NULL? 
18CD54RQTYRQuantity ReceivedNumericGeneric Edit150 Allow NULL? 
19CDUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
20CDLOCNLocationStringGeneric Edit200 Allow NULL? 
21CDLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
22CDLNTYLine TypeStringGeneric Edit20 Allow NULL? 
23CD54RICInventory CommitmentStringUDC (54R IC)30 Allow NULL? 
24CD54RPMBilling MethodCharacterUDC (54R BM)10 Allow NULL? 
25CDCRMCUReturn BranchStringGeneric Edit120 Allow NULL? 
26CDEMCUBusiness Unit - HeaderStringGeneric Edit120 Allow NULL? 
27CDRLITItem Number - Related (Kit)StringGeneric Edit80 Allow NULL? 
28CDKTLNKit Master Line NumberNumericGeneric Edit63 Allow NULL? 
29CDCPNTComponent Line NumberNumericGeneric Edit41 Allow NULL? 
30CDRKITRelated Kit ComponentNumericGeneric Edit80 Allow NULL? 
31CDKTPNumber of Component Per ParentNumericGeneric Edit150 Allow NULL? 
32CDSRP1Sales Catalog SectionStringUDC (41 S1)30 Allow NULL? 
33CDSRP2Sub SectionStringUDC (41 S2)30 Allow NULL? 
34CDSRP3Sales Category Code 3StringUDC (41 S3)30 Allow NULL? 
35CDSRP4Sales Category Code 4StringUDC (41 S4)30 Allow NULL? 
36CDSRP5Sales Category Code 5StringUDC (41 S5)30 Allow NULL? 
37CDPRP1Commodity ClassStringUDC (41 P1)30 Allow NULL? 
38CDPRP2Commodity Sub ClassStringUDC (41 P2)30 Allow NULL? 
39CDPRP3Supplier Rebate CodeStringUDC (41 P3)30 Allow NULL? 
40CDPRP4Master Planning FamilyStringUDC (41 P4)30 Allow NULL? 
41CDPRP5Purchasing Category Code 5StringUDC (41 P5)30 Allow NULL? 
42CDACL1Major Accounting ClassStringUDC (12 C1)30 Allow NULL? 
43CDACL2Major Equipment ClassStringUDC (12 C2)30 Allow NULL? 
44CDACL3ManufacturerStringUDC (12 C3)30 Allow NULL? 
45CDACL4Model YearStringUDC (12 C4)30 Allow NULL? 
46CDACL5Usage Miles or HoursStringUDC (12 C5)30 Allow NULL? 
47CDAN8Address NumberNumericGeneric Edit80 Allow NULL? 
48CDDVANAddress Number - Deliver ToNumericGeneric Edit80 Allow NULL? 
49CDPA8Address Number - ParentNumericGeneric Edit80 Allow NULL? 
50CDPBANAddress Number - Paid ByNumericGeneric Edit80 Allow NULL? 
51CDITANAddress Number - Invoiced ToNumericGeneric Edit80 Allow NULL? 
52CDVR01ReferenceStringGeneric Edit250 Allow NULL? 
53CDVR02Reference 2StringGeneric Edit250 Allow NULL? 
54CDFTANAddress Number - Forwarded ToNumericGeneric Edit80 Allow NULL? 
55CDSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
56CD54RCLSContract Line StatusStringUDC (54R LS)30 Allow NULL? 
57CDENTJDate - EnteredDateGeneric Edit60
58CDTENTTime EnteredNumericGeneric Edit60 Allow NULL? 
59CD54RCSDDate - StartDateGeneric Edit60
60CD54RCSTTime - StartNumericGeneric Edit60 Allow NULL? 
61CD54RCDDDate - DeliveryDateGeneric Edit60
62CD54RCDTTime - DeliveryNumericGeneric Edit60 Allow NULL? 
63CD54RCDADDate - Delivery ActualDateGeneric Edit60
64CD54RCDATTime - Delivery ActualNumericGeneric Edit60 Allow NULL? 
65CD54RCIDDate - InstallDateGeneric Edit60
66CD54RCITTime - InstallNumericGeneric Edit60 Allow NULL? 
67CD54RCPEDDate - Projected EndDateGeneric Edit60
68CD54RCPETTime - Projected EndNumericGeneric Edit60 Allow NULL? 
69CD54RCAEDDate - Actual EndDateGeneric Edit60
70CD54RCAETTime - Actual EndNumericGeneric Edit60 Allow NULL? 
71CD54RCBSDDate - Billing StartDateGeneric Edit60
72CD54RCBSTTime - Billing StartNumericGeneric Edit60 Allow NULL? 
73CD54RCBEDDate - Billing EndDateGeneric Edit60
74CD54RCBETTime - Billing EndNumericGeneric Edit60 Allow NULL? 
75CDDLIJDate - Last Invoice (Julian)DateGeneric Edit60
76CD54RREF1Reference 1StringGeneric Edit500 Allow NULL? 
77CD54RREF2Reference 2StringGeneric Edit500 Allow NULL? 
78CD54RARSVDReservation ContractCharacterGeneric Edit10 Allow NULL? 
79CD54RCRDDate - ReservationDateGeneric Edit60
80CD54RCRTTime - ReservationNumericGeneric Edit60 Allow NULL? 
81CD54RCRCDDate - Reservation CancellationDateGeneric Edit60
82CD54RCRCTTime - Reservation CancellationNumericGeneric Edit60 Allow NULL? 
83CD54RMSTRCContract MessageStringUDC (40 PM)100 Allow NULL? 
84CDPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
85CDRYINPayment InstrumentCharacterUDC (00 PY)10 Allow NULL? 
86CDASNPrice and Adjustment ScheduleStringUDC (40 AS)80 Allow NULL? 
87CDPRGPPricing GroupStringUDC (40 PC)80 Allow NULL? 
88CDTRDCDiscount - TradeNumericGeneric Edit73 Allow NULL? 
89CDTAX1Sales Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
90CDEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
91CDTXCTCertificate Tax ExemptionStringGeneric Edit200 Allow NULL? 
92CDHOLDHold Orders CodeStringUDC (42 HC)20 Allow NULL? 
93CDNTRNature of TransactionStringUDC (00 NT)20 Allow NULL? 
94CDCARSCarrier NumberNumericGeneric Edit80 Allow NULL? 
95CDMOTMode of TransportStringUDC (00 TM)30 Allow NULL? 
96CDCOTConditions of TransportStringUDC (00 TC)30 Allow NULL? 
97CDROUTRoute CodeStringUDC (42 RT)30 Allow NULL? 
98CDSTOPStop CodeStringUDC (42 SP)30 Allow NULL? 
99CDZONZone NumberStringUDC (40 ZN)30 Allow NULL? 
100CDCNIDContainer I.D.StringGeneric Edit200 Allow NULL? 
101CDFRTHFreight Handling CodeStringUDC (42 FR)30 Allow NULL? 
102CDDEL1Delivery Instructions Line 1StringGeneric Edit300 Allow NULL? 
103CDDEL2Delivery Instructions Line 2StringGeneric Edit300 Allow NULL? 
104CDAFTApply Freight - Y/NCharacterGeneric Edit10 Allow NULL? 
105CDCACTAccount Number - Credit/BankStringGeneric Edit250 Allow NULL? 
106CDCEXPDate - Expired (Julian)DateGeneric Edit60
107CDUPRCAmount - Price per UnitNumericGeneric Edit154 Allow NULL? 
108CDAPUMUnit of Measure - Entered for Unit PriceStringUDC (00 UM)20 Allow NULL? 
109CDPROVPrice Override CodeCharacterGeneric Edit10 Allow NULL? 
110CDERCEquipment Rate CodeStringUDC (00 RC)20 Allow NULL? 
111CDLPRCAmount - List PriceNumericGeneric Edit154 Allow NULL? 
112CDUNCSAmount - Unit CostNumericGeneric Edit154 Allow NULL? 
113CDCSTOCost Override CodeCharacterGeneric Edit10 Allow NULL? 
114CDATUMUnit of Measure - Entered for Unit CostStringGeneric Edit20 Allow NULL? 
115CD54RRUNCSAmount - Rehire Unit CostNumericGeneric Edit152 Allow NULL? 
116CD54RBODBased On DateCharacterGeneric Edit10 Allow NULL? 
117CDBCRCCurrency Code - BaseStringGeneric Edit30 Allow NULL? 
118CDCRRMCurrency Mode-Foreign or Domestic EntryCharacterUDC (H00 CY)10 Allow NULL? 
119CDCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
120CDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
121CDERDTDate - Exchange RateDateGeneric Edit60
122CD54RXRFVExchange Rate - Fixed Or VariableCharacterGeneric Edit10 Allow NULL? 
123CDBILLCRCDBilled Currency CodeStringGeneric Edit30 Allow NULL? 
124CDFUPAmount - Foreign Price per UnitNumericGeneric Edit154 Allow NULL? 
125CDFPRCAmount - List Price per UnitNumericGeneric Edit154 Allow NULL? 
126CDFUCAmount - Foreign Unit CostNumericGeneric Edit154 Allow NULL? 
127CD54RRUNCFForeign Amount - Rehire Unit CostNumericGeneric Edit152 Allow NULL? 
128CD54RRTORent To OwnCharacterGeneric Edit10 Allow NULL? 
129CD54RUSRD1Date - User Defined 1DateGeneric Edit60
130CD54RUSRD2Date - User Defined 2DateGeneric Edit60
131CD54RUSRD3Date - User Defined 3DateGeneric Edit60
132CD54RUSRT1Time - User Defined 1NumericGeneric Edit60 Allow NULL? 
133CD54RUSRT2Time - User Defined 2NumericGeneric Edit60 Allow NULL? 
134CD54RUSRT3Time - User Defined 3NumericGeneric Edit60 Allow NULL? 
135CD54RUSNB1Number - User Defined 1NumericGeneric Edit80 Allow NULL? 
136CD54RUSNB2Number - User Defined 2NumericGeneric Edit80 Allow NULL? 
137CD54RUSNB3Number - User Defined 3NumericGeneric Edit80 Allow NULL? 
138CDUSERUser IDStringGeneric Edit100 Allow NULL? 
139CDPIDProgram IDStringGeneric Edit100 Allow NULL? 
140CDUPMJDate - UpdatedDateGeneric Edit60
141CDUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
142CDJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
143CDMKEYMachine KeyStringGeneric Edit150 Allow NULL? 
144CDTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
145CDURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
146CDURDTUser Reserved DateDateGeneric Edit60
147CDURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
148CDURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
149CDURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
150CD54RDBILLDetail BillingCharacterGeneric Edit10 Allow NULL? 
151CD54RTEMPLTemplate ContractCharacterGeneric Edit10 Allow NULL? 
152CDTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
153CD54RLEASELease FlagCharacterGeneric Edit10 Allow NULL? 
154CD54RLSTYLease TypeStringUDC (54R LT)20 Allow NULL? 
155CDRP01DivisionStringUDC (00 01)30 Allow NULL? 
156CDRP02RegionStringUDC (00 02)30 Allow NULL? 
157CDRP03GroupStringUDC (00 03)30 Allow NULL? 
158CDRP04Branch OfficeStringUDC (00 04)30 Allow NULL? 
159CDRP05Department TypeStringUDC (00 05)30 Allow NULL? 
160CDRP06Person ResponsibleStringUDC (00 06)30 Allow NULL? 
161CDRP07Line of BusinessStringUDC (00 07)30 Allow NULL? 
162CDRP08Category Code - Business Unit 08StringUDC (00 08)30 Allow NULL? 
163CDRP09Category Code - Business Unit 09StringUDC (00 09)30 Allow NULL? 
164CDRP10Category Code - Business Unit 10StringUDC (00 10)30 Allow NULL? 
165CDRP11Category Code - Business Unit 11StringUDC (00 11)30 Allow NULL? 
166CDRP12Category Code - Business Unit 12StringUDC (00 12)30 Allow NULL? 
167CDRP13Category Code - Business Unit 13StringUDC (00 13)30 Allow NULL? 
168CDRP14Category Code - Business Unit 14StringUDC (00 14)30 Allow NULL? 
169CDRP15Category Code - Business Unit 15StringUDC (00 15)30 Allow NULL? 
170CDRP16Category Code - Business Unit 16StringUDC (00 16)30 Allow NULL? 
171CDRP17Category Code - Business Unit 17StringUDC (00 17)30 Allow NULL? 
172CDRP18Category Code - Business Unit 18StringUDC (00 18)30 Allow NULL? 
173CDRP19Category Code - Business Unit 19StringUDC (00 19)30 Allow NULL? 
174CDRP20Category Code - Business Unit 20StringUDC (00 20)30 Allow NULL? 
175CD54RSALE1Contract Salesman 1NumericGeneric Edit80 Allow NULL? 
176CD54RSALE2Contract Salesman 2NumericGeneric Edit80 Allow NULL? 
177CD54RLNGPLanguageStringUDC (01 LP)20 Allow NULL? 
178CD54RAUTNAuthorization NumberStringGeneric Edit100 Allow NULL? 
179CD54RIBUMRental Item Billing UOMStringUDC (54R UM)20 Allow NULL? 
180CDTMCUBusiness Unit - TransferStringGeneric Edit120 Allow NULL? 
181CD54RDEF01User Defined Carrier Number FlagCharacterGeneric Edit10 Allow NULL? 
182CD54RDEF02User Defined Mode of Transportation FlagCharacterGeneric Edit10 Allow NULL? 
183CD54RDEF03User Defined Freight Handling Code FlagCharacterGeneric Edit10 Allow NULL? 
184CD54RUSRBMOverriden Billing MethodCharacterGeneric Edit10 Allow NULL? 
185CD54RUSRLTOverriden Line TypeCharacterGeneric Edit10 Allow NULL? 
186CD54RTSTransfer StatusStringUDC (54R TS)20 Allow NULL? 
187CD54RBCRRBilling Exchange RateNumericGeneric Edit150 Allow NULL? 

TOP920 | 54R | F54R11 INDEXES

NumberDescription
1Primary key (Primary/Unique)
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4LNIDLine NumberAscending
2DOCO DCTO KCOO
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
3DOCO DCTO KCOO 54RIC
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
454RICInventory CommitmentAscending
4DOCO DCTO KCOO 54RIC ++
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
454RICInventory CommitmentAscending
554RCLSContract Line StatusAscending
5DOCO DCTO KCOO 54RCLS
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
454RCLSContract Line StatusAscending