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

138 COLUMNS | 1 INDEXES | Print definition?920 | 54R | F54R10 TABLE

54R: Rental Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F54R10CH1381Rental Contract HeaderFiles54R: 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 CHDOCO, CHDCTO, CHKCOO, CHMCU, CHCO, CHRKCO, CHRORN, CHRCTO, CHAN8, CHSHAN, CHDVAN, CHPA8, CHPBAN, CHITAN, CHFTAN, CH54RREF1, CH54RREF2, CHBLFC, CH54RCNTST, CH54RCTJ, CH54RCTT, CH54RCSD, CH54RCST, CH54RCDD, CH54RCDT, CH54RCDAD, CH54RCDAT, CH54RCID, CH54RCIT, CH54RCPED, CH54RCPET, CH54RCAED, CH54RCAET, CH54RCBSD, CH54RCBST, CH54RCBED, CH54RCBET, CHDLIJ, CHVR01, CHVR02, CHVR03, CHDEL1, CHDEL2, CH54RARSVD, CH54RCRD, CH54RCRT, CH54RCRCD, CH54RCRCT, CH54RMSTRC, CHPTC, CHRYIN, CHASN, CHPRGP, CHTRDC, CHEXR1, CHTXA1, CHTXCT, CHHOLD, CHNTR, CHCARS, CHMOT, CHCOT, CHROUT, CHSTOP, CHZON, CHCNID, CHFRTH, CHAFT, CHCACT, CHCEXP, CHCRRM, CHCRCD, CHCRR, CHBCRC, CHERDT, CHBILLCRCD, CHORBY, CHTKBY, CHUPMJ, CHENTJ, CHUSER, CHPID, CHUPMT, CHJOBN, CHMKEY, CHTORG, CHURCD, CHURDT, CHURAT, CHURAB, CHURRF, CHTENT, CH54RIT, CH54RIP, CH54RXRFV, CH54RRTO, CH54RUSRD1, CH54RUSRD2, CH54RUSRD3, CH54RUSRT1, CH54RUSRT2, CH54RUSRT3, CH54RUSNB1, CH54RUSNB2, CH54RUSNB3, CH54RTEMPL, CH54RDBILL, CH54RLEASE, CH54RLSTY, CHRP01, CHRP02, CHRP03, CHRP04, CHRP05, CHRP06, CHRP07, CHRP08, CHRP09, CHRP10, CHRP11, CHRP12, CHRP13, CHRP14, CHRP15, CHRP16, CHRP17, CHRP18, CHRP19, CHRP20, CH54RSALE1, CH54RSALE2, CH54RAUTN, CH54RLNGP, CH54RRQSB, CH54RDEF01, CH54RDEF02, CH54RDEF03, CH54RBCRR FROM F54R10

TOP920 | 54R | F54R10 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1CHDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
2CHDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
3CHKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
4CHMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
5CHCOCompanyStringGeneric Edit50 Allow NULL? 
6CHRKCOCompany - Key (Related Order)StringGeneric Edit50 Allow NULL? 
7CHRORNRelated PO/SO/WO NumberStringGeneric Edit80 Allow NULL? 
8CHRCTORelated PO/SO/WO Order TypeStringUDC (00 DT)20 Allow NULL? 
9CHAN8Address NumberNumericGeneric Edit80 Allow NULL? 
10CHSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
11CHDVANAddress Number - Deliver ToNumericGeneric Edit80 Allow NULL? 
12CHPA8Address Number - ParentNumericGeneric Edit80 Allow NULL? 
13CHPBANAddress Number - Paid ByNumericGeneric Edit80 Allow NULL? 
14CHITANAddress Number - Invoiced ToNumericGeneric Edit80 Allow NULL? 
15CHFTANAddress Number - Forwarded ToNumericGeneric Edit80 Allow NULL? 
16CH54RREF1Reference 1StringGeneric Edit500 Allow NULL? 
17CH54RREF2Reference 2StringGeneric Edit500 Allow NULL? 
18CHBLFCBilling Frequency CodeCharacterUDC10 Allow NULL? 
19CH54RCNTSTContract StatusStringUDC (54R CS)30 Allow NULL? 
20CH54RCTJDate - TransactionDateGeneric Edit60
21CH54RCTTTime - TransactionNumericGeneric Edit60 Allow NULL? 
22CH54RCSDDate - StartDateGeneric Edit60
23CH54RCSTTime - StartNumericGeneric Edit60 Allow NULL? 
24CH54RCDDDate - DeliveryDateGeneric Edit60
25CH54RCDTTime - DeliveryNumericGeneric Edit60 Allow NULL? 
26CH54RCDADDate - Delivery ActualDateGeneric Edit60
27CH54RCDATTime - Delivery ActualNumericGeneric Edit60 Allow NULL? 
28CH54RCIDDate - InstallDateGeneric Edit60
29CH54RCITTime - InstallNumericGeneric Edit60 Allow NULL? 
30CH54RCPEDDate - Projected EndDateGeneric Edit60
31CH54RCPETTime - Projected EndNumericGeneric Edit60 Allow NULL? 
32CH54RCAEDDate - Actual EndDateGeneric Edit60
33CH54RCAETTime - Actual EndNumericGeneric Edit60 Allow NULL? 
34CH54RCBSDDate - Billing StartDateGeneric Edit60
35CH54RCBSTTime - Billing StartNumericGeneric Edit60 Allow NULL? 
36CH54RCBEDDate - Billing EndDateGeneric Edit60
37CH54RCBETTime - Billing EndNumericGeneric Edit60 Allow NULL? 
38CHDLIJDate - Last Invoice (Julian)DateGeneric Edit60
39CHVR01ReferenceStringGeneric Edit250 Allow NULL? 
40CHVR02Reference 2StringGeneric Edit250 Allow NULL? 
41CHVR03ReferenceStringGeneric Edit250 Allow NULL? 
42CHDEL1Delivery Instructions Line 1StringGeneric Edit300 Allow NULL? 
43CHDEL2Delivery Instructions Line 2StringGeneric Edit300 Allow NULL? 
44CH54RARSVDReservation ContractCharacterGeneric Edit10 Allow NULL? 
45CH54RCRDDate - ReservationDateGeneric Edit60
46CH54RCRTTime - ReservationNumericGeneric Edit60 Allow NULL? 
47CH54RCRCDDate - Reservation CancellationDateGeneric Edit60
48CH54RCRCTTime - Reservation CancellationNumericGeneric Edit60 Allow NULL? 
49CH54RMSTRCContract MessageStringUDC (40 PM)100 Allow NULL? 
50CHPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
51CHRYINPayment InstrumentCharacterUDC (00 PY)10 Allow NULL? 
52CHASNPrice and Adjustment ScheduleStringUDC (40 AS)80 Allow NULL? 
53CHPRGPPricing GroupStringUDC (40 PC)80 Allow NULL? 
54CHTRDCDiscount - TradeNumericGeneric Edit73 Allow NULL? 
55CHEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
56CHTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
57CHTXCTCertificate Tax ExemptionStringGeneric Edit200 Allow NULL? 
58CHHOLDHold Orders CodeStringUDC (42 HC)20 Allow NULL? 
59CHNTRNature of TransactionStringUDC (00 NT)20 Allow NULL? 
60CHCARSCarrier NumberNumericGeneric Edit80 Allow NULL? 
61CHMOTMode of TransportStringUDC (00 TM)30 Allow NULL? 
62CHCOTConditions of TransportStringUDC (00 TC)30 Allow NULL? 
63CHROUTRoute CodeStringUDC (42 RT)30 Allow NULL? 
64CHSTOPStop CodeStringUDC (42 SP)30 Allow NULL? 
65CHZONZone NumberStringUDC (40 ZN)30 Allow NULL? 
66CHCNIDContainer I.D.StringGeneric Edit200 Allow NULL? 
67CHFRTHFreight Handling CodeStringUDC (42 FR)30 Allow NULL? 
68CHAFTApply Freight - Y/NCharacterGeneric Edit10 Allow NULL? 
69CHCACTAccount Number - Credit/BankStringGeneric Edit250 Allow NULL? 
70CHCEXPDate - Expired (Julian)DateGeneric Edit60
71CHCRRMCurrency Mode-Foreign or Domestic EntryCharacterUDC (H00 CY)10 Allow NULL? 
72CHCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
73CHCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
74CHBCRCCurrency Code - BaseStringGeneric Edit30 Allow NULL? 
75CHERDTDate - Exchange RateDateGeneric Edit60
76CHBILLCRCDBilled Currency CodeStringGeneric Edit30 Allow NULL? 
77CHORBYOrdered ByStringGeneric Edit100 Allow NULL? 
78CHTKBYOrder Taken ByStringGeneric Edit100 Allow NULL? 
79CHUPMJDate - UpdatedDateGeneric Edit60
80CHENTJDate - EnteredDateGeneric Edit60
81CHUSERUser IDStringGeneric Edit100 Allow NULL? 
82CHPIDProgram IDStringGeneric Edit100 Allow NULL? 
83CHUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
84CHJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
85CHMKEYMachine KeyStringGeneric Edit150 Allow NULL? 
86CHTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
87CHURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
88CHURDTUser Reserved DateDateGeneric Edit60
89CHURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
90CHURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
91CHURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
92CHTENTTime EnteredNumericGeneric Edit60 Allow NULL? 
93CH54RITInsurance TypeStringUDC (54R IT)20 Allow NULL? 
94CH54RIPInsurance PolicyStringGeneric Edit300 Allow NULL? 
95CH54RXRFVExchange Rate - Fixed Or VariableCharacterGeneric Edit10 Allow NULL? 
96CH54RRTORent To OwnCharacterGeneric Edit10 Allow NULL? 
97CH54RUSRD1Date - User Defined 1DateGeneric Edit60
98CH54RUSRD2Date - User Defined 2DateGeneric Edit60
99CH54RUSRD3Date - User Defined 3DateGeneric Edit60
100CH54RUSRT1Time - User Defined 1NumericGeneric Edit60 Allow NULL? 
101CH54RUSRT2Time - User Defined 2NumericGeneric Edit60 Allow NULL? 
102CH54RUSRT3Time - User Defined 3NumericGeneric Edit60 Allow NULL? 
103CH54RUSNB1Number - User Defined 1NumericGeneric Edit80 Allow NULL? 
104CH54RUSNB2Number - User Defined 2NumericGeneric Edit80 Allow NULL? 
105CH54RUSNB3Number - User Defined 3NumericGeneric Edit80 Allow NULL? 
106CH54RTEMPLTemplate ContractCharacterGeneric Edit10 Allow NULL? 
107CH54RDBILLDetail BillingCharacterGeneric Edit10 Allow NULL? 
108CH54RLEASELease FlagCharacterGeneric Edit10 Allow NULL? 
109CH54RLSTYLease TypeStringUDC (54R LT)20 Allow NULL? 
110CHRP01DivisionStringUDC (00 01)30 Allow NULL? 
111CHRP02RegionStringUDC (00 02)30 Allow NULL? 
112CHRP03GroupStringUDC (00 03)30 Allow NULL? 
113CHRP04Branch OfficeStringUDC (00 04)30 Allow NULL? 
114CHRP05Department TypeStringUDC (00 05)30 Allow NULL? 
115CHRP06Person ResponsibleStringUDC (00 06)30 Allow NULL? 
116CHRP07Line of BusinessStringUDC (00 07)30 Allow NULL? 
117CHRP08Category Code - Business Unit 08StringUDC (00 08)30 Allow NULL? 
118CHRP09Category Code - Business Unit 09StringUDC (00 09)30 Allow NULL? 
119CHRP10Category Code - Business Unit 10StringUDC (00 10)30 Allow NULL? 
120CHRP11Category Code - Business Unit 11StringUDC (00 11)30 Allow NULL? 
121CHRP12Category Code - Business Unit 12StringUDC (00 12)30 Allow NULL? 
122CHRP13Category Code - Business Unit 13StringUDC (00 13)30 Allow NULL? 
123CHRP14Category Code - Business Unit 14StringUDC (00 14)30 Allow NULL? 
124CHRP15Category Code - Business Unit 15StringUDC (00 15)30 Allow NULL? 
125CHRP16Category Code - Business Unit 16StringUDC (00 16)30 Allow NULL? 
126CHRP17Category Code - Business Unit 17StringUDC (00 17)30 Allow NULL? 
127CHRP18Category Code - Business Unit 18StringUDC (00 18)30 Allow NULL? 
128CHRP19Category Code - Business Unit 19StringUDC (00 19)30 Allow NULL? 
129CHRP20Category Code - Business Unit 20StringUDC (00 20)30 Allow NULL? 
130CH54RSALE1Contract Salesman 1NumericGeneric Edit80 Allow NULL? 
131CH54RSALE2Contract Salesman 2NumericGeneric Edit80 Allow NULL? 
132CH54RAUTNAuthorization NumberStringGeneric Edit100 Allow NULL? 
133CH54RLNGPLanguageStringUDC (01 LP)20 Allow NULL? 
134CH54RRQSBRequested Billing DayNumericGeneric Edit20 Allow NULL? 
135CH54RDEF01User Defined Carrier Number FlagCharacterGeneric Edit10 Allow NULL? 
136CH54RDEF02User Defined Mode of Transportation FlagCharacterGeneric Edit10 Allow NULL? 
137CH54RDEF03User Defined Freight Handling Code FlagCharacterGeneric Edit10 Allow NULL? 
138CH54RBCRRBilling Exchange RateNumericGeneric Edit150 Allow NULL? 

TOP920 | 54R | F54R10 INDEXES

NumberDescription
1Primary Key (Primary/Unique)
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending