JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.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
6F9671SDSoftware Update Detail Table
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F0006MCBusiness Unit Master
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F76AUI46WFCERG A/R -Work File - ARG - 03B - 76A
3F4211SDSales Order Detail File
4F4101IMItem Master
5F0101ABAddress Book Master
6F0911GLAccount Ledger
7F4102IBItem Branch File
8F03B11RPCustomer Ledger
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4311PDPurchase Order Detail File
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File

140 COLUMNS | 3 INDEXES | Print definition?920 | 54R | F54R099 TABLE

54R: Rental Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F54R099HL1403Rental Contract Header 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 HLDOCO, HLDCTO, HLKCOO, HLUKID, HL54RLA, HLMCU, HLCO, HLRKCO, HLRORN, HLRCTO, HLAN8, HLSHAN, HLDVAN, HLPA8, HLPBAN, HLITAN, HLFTAN, HL54RREF1, HL54RREF2, HLBLFC, HL54RCNTST, HL54RCTJ, HL54RCTT, HL54RCSD, HL54RCST, HL54RCDD, HL54RCDT, HL54RCDAD, HL54RCDAT, HL54RCID, HL54RCIT, HL54RCPED, HL54RCPET, HL54RCAED, HL54RCAET, HL54RCBSD, HL54RCBST, HL54RCBED, HL54RCBET, HLDLIJ, HLVR01, HLVR02, HLVR03, HLDEL1, HLDEL2, HL54RARSVD, HL54RCRD, HL54RCRT, HL54RCRCD, HL54RCRCT, HL54RMSTRC, HLPTC, HLRYIN, HLASN, HLPRGP, HLTRDC, HLEXR1, HLTXA1, HLTXCT, HLHOLD, HLNTR, HLCARS, HLMOT, HLCOT, HLROUT, HLSTOP, HLZON, HLCNID, HLFRTH, HLAFT, HLCACT, HLCEXP, HLCRRM, HLCRCD, HLCRR, HLBCRC, HLERDT, HLBILLCRCD, HLORBY, HLTKBY, HLUPMJ, HLENTJ, HLUSER, HLPID, HLUPMT, HLJOBN, HLMKEY, HLTORG, HLURCD, HLURDT, HLURAT, HLURAB, HLURRF, HLTENT, HL54RIT, HL54RIP, HL54RXRFV, HL54RRTO, HL54RUSRD1, HL54RUSRD2, HL54RUSRD3, HL54RUSRT1, HL54RUSRT2, HL54RUSRT3, HL54RUSNB1, HL54RUSNB2, HL54RUSNB3, HL54RTEMPL, HL54RDBILL, HL54RLEASE, HL54RLSTY, HLRP01, HLRP02, HLRP03, HLRP04, HLRP05, HLRP06, HLRP07, HLRP08, HLRP09, HLRP10, HLRP11, HLRP12, HLRP13, HLRP14, HLRP15, HLRP16, HLRP17, HLRP18, HLRP19, HLRP20, HL54RSALE1, HL54RSALE2, HL54RAUTN, HL54RLNGP, HL54RRQSB, HL54RDEF01, HL54RDEF02, HL54RDEF03, HL54RBCRR FROM F54R099

TOP920 | 54R | F54R099 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1HLDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
2HLDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
3HLKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
4HLUKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
5HL54RLALedger ActionStringUDC (54R LA)20 Allow NULL? 
6HLMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
7HLCOCompanyStringGeneric Edit50 Allow NULL? 
8HLRKCOCompany - Key (Related Order)StringGeneric Edit50 Allow NULL? 
9HLRORNRelated PO/SO/WO NumberStringGeneric Edit80 Allow NULL? 
10HLRCTORelated PO/SO/WO Order TypeStringUDC (00 DT)20 Allow NULL? 
11HLAN8Address NumberNumericGeneric Edit80 Allow NULL? 
12HLSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
13HLDVANAddress Number - Deliver ToNumericGeneric Edit80 Allow NULL? 
14HLPA8Address Number - ParentNumericGeneric Edit80 Allow NULL? 
15HLPBANAddress Number - Paid ByNumericGeneric Edit80 Allow NULL? 
16HLITANAddress Number - Invoiced ToNumericGeneric Edit80 Allow NULL? 
17HLFTANAddress Number - Forwarded ToNumericGeneric Edit80 Allow NULL? 
18HL54RREF1Reference 1StringGeneric Edit500 Allow NULL? 
19HL54RREF2Reference 2StringGeneric Edit500 Allow NULL? 
20HLBLFCBilling Frequency CodeCharacterUDC10 Allow NULL? 
21HL54RCNTSTContract StatusStringUDC (54R CS)30 Allow NULL? 
22HL54RCTJDate - TransactionDateGeneric Edit60
23HL54RCTTTime - TransactionNumericGeneric Edit60 Allow NULL? 
24HL54RCSDDate - StartDateGeneric Edit60
25HL54RCSTTime - StartNumericGeneric Edit60 Allow NULL? 
26HL54RCDDDate - DeliveryDateGeneric Edit60
27HL54RCDTTime - DeliveryNumericGeneric Edit60 Allow NULL? 
28HL54RCDADDate - Delivery ActualDateGeneric Edit60
29HL54RCDATTime - Delivery ActualNumericGeneric Edit60 Allow NULL? 
30HL54RCIDDate - InstallDateGeneric Edit60
31HL54RCITTime - InstallNumericGeneric Edit60 Allow NULL? 
32HL54RCPEDDate - Projected EndDateGeneric Edit60
33HL54RCPETTime - Projected EndNumericGeneric Edit60 Allow NULL? 
34HL54RCAEDDate - Actual EndDateGeneric Edit60
35HL54RCAETTime - Actual EndNumericGeneric Edit60 Allow NULL? 
36HL54RCBSDDate - Billing StartDateGeneric Edit60
37HL54RCBSTTime - Billing StartNumericGeneric Edit60 Allow NULL? 
38HL54RCBEDDate - Billing EndDateGeneric Edit60
39HL54RCBETTime - Billing EndNumericGeneric Edit60 Allow NULL? 
40HLDLIJDate - Last Invoice (Julian)DateGeneric Edit60
41HLVR01ReferenceStringGeneric Edit250 Allow NULL? 
42HLVR02Reference 2StringGeneric Edit250 Allow NULL? 
43HLVR03ReferenceStringGeneric Edit250 Allow NULL? 
44HLDEL1Delivery Instructions Line 1StringGeneric Edit300 Allow NULL? 
45HLDEL2Delivery Instructions Line 2StringGeneric Edit300 Allow NULL? 
46HL54RARSVDReservation ContractCharacterGeneric Edit10 Allow NULL? 
47HL54RCRDDate - ReservationDateGeneric Edit60
48HL54RCRTTime - ReservationNumericGeneric Edit60 Allow NULL? 
49HL54RCRCDDate - Reservation CancellationDateGeneric Edit60
50HL54RCRCTTime - Reservation CancellationNumericGeneric Edit60 Allow NULL? 
51HL54RMSTRCContract MessageStringUDC (40 PM)100 Allow NULL? 
52HLPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
53HLRYINPayment InstrumentCharacterUDC (00 PY)10 Allow NULL? 
54HLASNPrice and Adjustment ScheduleStringUDC (40 AS)80 Allow NULL? 
55HLPRGPPricing GroupStringUDC (40 PC)80 Allow NULL? 
56HLTRDCDiscount - TradeNumericGeneric Edit73 Allow NULL? 
57HLEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
58HLTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
59HLTXCTCertificate Tax ExemptionStringGeneric Edit200 Allow NULL? 
60HLHOLDHold Orders CodeStringUDC (42 HC)20 Allow NULL? 
61HLNTRNature of TransactionStringUDC (00 NT)20 Allow NULL? 
62HLCARSCarrier NumberNumericGeneric Edit80 Allow NULL? 
63HLMOTMode of TransportStringUDC (00 TM)30 Allow NULL? 
64HLCOTConditions of TransportStringUDC (00 TC)30 Allow NULL? 
65HLROUTRoute CodeStringUDC (42 RT)30 Allow NULL? 
66HLSTOPStop CodeStringUDC (42 SP)30 Allow NULL? 
67HLZONZone NumberStringUDC (40 ZN)30 Allow NULL? 
68HLCNIDContainer I.D.StringGeneric Edit200 Allow NULL? 
69HLFRTHFreight Handling CodeStringUDC (42 FR)30 Allow NULL? 
70HLAFTApply Freight - Y/NCharacterGeneric Edit10 Allow NULL? 
71HLCACTAccount Number - Credit/BankStringGeneric Edit250 Allow NULL? 
72HLCEXPDate - Expired (Julian)DateGeneric Edit60
73HLCRRMCurrency Mode-Foreign or Domestic EntryCharacterUDC (H00 CY)10 Allow NULL? 
74HLCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
75HLCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
76HLBCRCCurrency Code - BaseStringGeneric Edit30 Allow NULL? 
77HLERDTDate - Exchange RateDateGeneric Edit60
78HLBILLCRCDBilled Currency CodeStringGeneric Edit30 Allow NULL? 
79HLORBYOrdered ByStringGeneric Edit100 Allow NULL? 
80HLTKBYOrder Taken ByStringGeneric Edit100 Allow NULL? 
81HLUPMJDate - UpdatedDateGeneric Edit60
82HLENTJDate - EnteredDateGeneric Edit60
83HLUSERUser IDStringGeneric Edit100 Allow NULL? 
84HLPIDProgram IDStringGeneric Edit100 Allow NULL? 
85HLUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
86HLJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
87HLMKEYMachine KeyStringGeneric Edit150 Allow NULL? 
88HLTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
89HLURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
90HLURDTUser Reserved DateDateGeneric Edit60
91HLURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
92HLURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
93HLURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
94HLTENTTime EnteredNumericGeneric Edit60 Allow NULL? 
95HL54RITInsurance TypeStringUDC (54R IT)20 Allow NULL? 
96HL54RIPInsurance PolicyStringGeneric Edit300 Allow NULL? 
97HL54RXRFVExchange Rate - Fixed Or VariableCharacterGeneric Edit10 Allow NULL? 
98HL54RRTORent To OwnCharacterGeneric Edit10 Allow NULL? 
99HL54RUSRD1Date - User Defined 1DateGeneric Edit60
100HL54RUSRD2Date - User Defined 2DateGeneric Edit60
101HL54RUSRD3Date - User Defined 3DateGeneric Edit60
102HL54RUSRT1Time - User Defined 1NumericGeneric Edit60 Allow NULL? 
103HL54RUSRT2Time - User Defined 2NumericGeneric Edit60 Allow NULL? 
104HL54RUSRT3Time - User Defined 3NumericGeneric Edit60 Allow NULL? 
105HL54RUSNB1Number - User Defined 1NumericGeneric Edit80 Allow NULL? 
106HL54RUSNB2Number - User Defined 2NumericGeneric Edit80 Allow NULL? 
107HL54RUSNB3Number - User Defined 3NumericGeneric Edit80 Allow NULL? 
108HL54RTEMPLTemplate ContractCharacterGeneric Edit10 Allow NULL? 
109HL54RDBILLDetail BillingCharacterGeneric Edit10 Allow NULL? 
110HL54RLEASELease FlagCharacterGeneric Edit10 Allow NULL? 
111HL54RLSTYLease TypeStringUDC (54R LT)20 Allow NULL? 
112HLRP01DivisionStringUDC (00 01)30 Allow NULL? 
113HLRP02RegionStringUDC (00 02)30 Allow NULL? 
114HLRP03GroupStringUDC (00 03)30 Allow NULL? 
115HLRP04Branch OfficeStringUDC (00 04)30 Allow NULL? 
116HLRP05Department TypeStringUDC (00 05)30 Allow NULL? 
117HLRP06Person ResponsibleStringUDC (00 06)30 Allow NULL? 
118HLRP07Line of BusinessStringUDC (00 07)30 Allow NULL? 
119HLRP08Category Code - Business Unit 08StringUDC (00 08)30 Allow NULL? 
120HLRP09Category Code - Business Unit 09StringUDC (00 09)30 Allow NULL? 
121HLRP10Category Code - Business Unit 10StringUDC (00 10)30 Allow NULL? 
122HLRP11Category Code - Business Unit 11StringUDC (00 11)30 Allow NULL? 
123HLRP12Category Code - Business Unit 12StringUDC (00 12)30 Allow NULL? 
124HLRP13Category Code - Business Unit 13StringUDC (00 13)30 Allow NULL? 
125HLRP14Category Code - Business Unit 14StringUDC (00 14)30 Allow NULL? 
126HLRP15Category Code - Business Unit 15StringUDC (00 15)30 Allow NULL? 
127HLRP16Category Code - Business Unit 16StringUDC (00 16)30 Allow NULL? 
128HLRP17Category Code - Business Unit 17StringUDC (00 17)30 Allow NULL? 
129HLRP18Category Code - Business Unit 18StringUDC (00 18)30 Allow NULL? 
130HLRP19Category Code - Business Unit 19StringUDC (00 19)30 Allow NULL? 
131HLRP20Category Code - Business Unit 20StringUDC (00 20)30 Allow NULL? 
132HL54RSALE1Contract Salesman 1NumericGeneric Edit80 Allow NULL? 
133HL54RSALE2Contract Salesman 2NumericGeneric Edit80 Allow NULL? 
134HL54RAUTNAuthorization NumberStringGeneric Edit100 Allow NULL? 
135HL54RLNGPLanguageStringUDC (01 LP)20 Allow NULL? 
136HL54RRQSBRequested Billing DayNumericGeneric Edit20 Allow NULL? 
137HL54RDEF01User Defined Carrier Number FlagCharacterGeneric Edit10 Allow NULL? 
138HL54RDEF02User Defined Mode of Transportation FlagCharacterGeneric Edit10 Allow NULL? 
139HL54RDEF03User Defined Freight Handling Code FlagCharacterGeneric Edit10 Allow NULL? 
140HL54RBCRRBilling Exchange RateNumericGeneric Edit150 Allow NULL? 

TOP920 | 54R | F54R099 INDEXES

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