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
9F4111ILItem Ledger File
10F4311PDPurchase Order Detail File

812: Top 10 requests

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

125 COLUMNS | 1 INDEXES | Print definition?910 | 43C | F43C010 TABLE

43C: Contracts
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F43C010HP1251Contract Header ProfileFiles43C: Contracts
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 HPCTRPRID, HPCTRPRDES, HPUCNTRTYP, HPCNTRTTYP, HPUCNTSTS, HPCNTRTSTS, HPUCNTENT, HPCNTRTENT, HPUCNTMGR, HPCNTRTMGR, HPUCNTPT, HPCNTRTPT, HPUCNTDF, HPCNTRTDF, HPUOWNER, HPOWNERSP, HPUCNTRTSD, HPCNTRTSD, HPUCNTRTED, HPCNTRTED, HPURNWTYP, HPRNWTYPE, HPURNWED, HPRNWEDTE, HPUCNTRD, HPCNTRD, HPURNWTRM, HPRNWTRM, HPURNWUOM, HPRNWUOM, HPUCNTCC, HPCMDCDE, HPUCNTBYR, HPCNTRTBYR, HPCLSID, HPCUPDLVL, HPUCNTAB01, HPCNTRAB01, HPUCNTAB02, HPCNTRAB02, HPUCNTAB03, HPCNTRAB03, HPUCNTAB04, HPCNTRAB04, HPUCNTAB05, HPCNTRAB05, HPUCNTAB06, HPCNTRAB06, HPUCNTAB07, HPCNTRAB07, HPUCNTAB08, HPCNTRAB08, HPUCNTAB09, HPCNTRAB09, HPUCNTAB10, HPCNTRAB10, HPUCNTAB11, HPCNTRAB11, HPUCNTAB12, HPCNTRAB12, HPUCNTCD01, HPCNTRT01, HPUCNTCD02, HPCNTRT02, HPUCNTCD03, HPUCNTCD04, HPCNTRT03, HPCNTRT04, HPUCNTCD05, HPCNTRT05, HPUCNTCD06, HPCNTRT06, HPUCNTCD07, HPCNTRT07, HPUCNTCD08, HPCNTRT08, HPUCNTCD09, HPCNTRT09, HPUCNTCD10, HPCNTRT10, HPUCNTCD11, HPCNTRT11, HPUCNTCD12, HPCNTRT12, HPUCNTCD13, HPCNTRT13, HPUCNTCD14, HPCNTRT14, HPUCNTCD15, HPCNTRT15, HPUCNTDT1, HPCNTRTDT1, HPUCNTDT2, HPCNTRTDT2, HPUCNTDT3, HPCNTRTDT3, HPUCNTDT4, HPCNTRTDT4, HPUCNTDT5, HPCNTRTDT5, HPUCNTDT6, HPCNTRTDT6, HPUCNTP1, HPCNTRPT01, HPUCNTP2, HPCNTRPT02, HPUCNTP3, HPCNTRPT03, HPUCNTP4, HPCNTRPT04, HPUCNTP5, HPCNTRPT05, HPUCNTP6, HPCNTRPT06, HPURCD, HPURDT, HPURAT, HPURAB, HPURRF, HPTORG, HPUSER, HPPID, HPJOBN, HPUUPMJ, HPCNTPTCB FROM F43C010

TOP910 | 43C | F43C010 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1HPCTRPRIDContract Header Profile IDNumericGeneric Edit80 Allow NULL? 
2HPCTRPRDESContract Header Profile DescriptionStringGeneric Edit400 Allow NULL? 
3HPUCNTRTYPUpdate Contract TypeCharacterGeneric Edit10 Allow NULL? 
4HPCNTRTTYPContract TypeStringGeneric Edit (43C CT)100 Allow NULL? 
5HPUCNTSTSUpdate Contract StatusCharacterGeneric Edit10 Allow NULL? 
6HPCNTRTSTSContract StatusStringUDC (43C CS)30 Allow NULL? 
7HPUCNTENTUpdate Contracting EntityCharacterGeneric Edit10 Allow NULL? 
8HPCNTRTENTContracting EntityNumericGeneric Edit80 Allow NULL? 
9HPUCNTMGRUpdate Contract ManagerCharacterGeneric Edit10 Allow NULL? 
10HPCNTRTMGRConract ManagerNumericGeneric Edit80 Allow NULL? 
11HPUCNTPTUpdate Price TypeCharacterGeneric Edit10 Allow NULL? 
12HPCNTRTPTPrice TypeStringUDC (43C PT)30 Allow NULL? 
13HPUCNTDFUpdate Contract Delivery FormCharacterGeneric Edit10 Allow NULL? 
14HPCNTRTDFDelivery FormStringUDC (43C DF)30 Allow NULL? 
15HPUOWNERUpdate Contract OwnershipCharacterGeneric Edit10 Allow NULL? 
16HPOWNERSPOwnershipStringUDC (43C OS)30 Allow NULL? 
17HPUCNTRTSDUpdate Contract Start DateCharacterGeneric Edit10 Allow NULL? 
18HPCNTRTSDStart DateJDE UTimeGeneric Edit110
19HPUCNTRTEDUpdate Contract End DateCharacterGeneric Edit10 Allow NULL? 
20HPCNTRTEDEnd DateJDE UTimeGeneric Edit110
21HPURNWTYPUpdate Contract Renew TypeCharacterGeneric Edit10 Allow NULL? 
22HPRNWTYPERenew TypeStringUDC (43C RT)30 Allow NULL? 
23HPURNWEDUpdate Renewable End DateCharacterGeneric Edit10 Allow NULL? 
24HPRNWEDTERenewable End DateJDE UTimeGeneric Edit110
25HPUCNTRDUpdate Contract Review DateCharacterGeneric Edit10 Allow NULL? 
26HPCNTRDReview DateJDE UTimeGeneric Edit110
27HPURNWTRMUpdate Contract Renew TermCharacterGeneric Edit10 Allow NULL? 
28HPRNWTRMRenew TermNumericGeneric Edit60 Allow NULL? 
29HPURNWUOMUpdate Contract Renew PeriodCharacterGeneric Edit10 Allow NULL? 
30HPRNWUOMRenew PeriodStringUDC (43C RU)30 Allow NULL? 
31HPUCNTCCUpdate Commodity CodeCharacterGeneric Edit10 Allow NULL? 
32HPCMDCDECommodity CodeStringGeneric Edit150 Allow NULL? 
33HPUCNTBYRUpdate Contract BuyerCharacterGeneric Edit10 Allow NULL? 
34HPCNTRTBYRContract BuyerNumericGeneric Edit80 Allow NULL? 
35HPCLSIDContract Clause Profile IDNumericGeneric Edit80 Allow NULL? 
36HPCUPDLVLContract Mass Update LevelCharacterGeneric Edit10 Allow NULL? 
37HPUCNTAB01Update Address Book 01CharacterGeneric Edit10 Allow NULL? 
38HPCNTRAB01Contract Address Book Number 01NumericGeneric Edit80 Allow NULL? 
39HPUCNTAB02Update Address Book 02CharacterGeneric Edit10 Allow NULL? 
40HPCNTRAB02Contract Address Book Number 02NumericGeneric Edit80 Allow NULL? 
41HPUCNTAB03Update Address Book 03CharacterGeneric Edit10 Allow NULL? 
42HPCNTRAB03Contract Address Book Number 03NumericGeneric Edit80 Allow NULL? 
43HPUCNTAB04Update Address Book 04CharacterGeneric Edit10 Allow NULL? 
44HPCNTRAB04Contract Address Book Number 04NumericGeneric Edit80 Allow NULL? 
45HPUCNTAB05Update Address Book 05CharacterGeneric Edit10 Allow NULL? 
46HPCNTRAB05Contract Address Book Number 05NumericGeneric Edit80 Allow NULL? 
47HPUCNTAB06Update Address Book 06CharacterGeneric Edit10 Allow NULL? 
48HPCNTRAB06Contract Address Book Number 06NumericGeneric Edit80 Allow NULL? 
49HPUCNTAB07Update Address Book 07CharacterGeneric Edit10 Allow NULL? 
50HPCNTRAB07Contract Address Book Number 07NumericGeneric Edit80 Allow NULL? 
51HPUCNTAB08Update Address Book 08CharacterGeneric Edit10 Allow NULL? 
52HPCNTRAB08Contract Address Book Number 08NumericGeneric Edit80 Allow NULL? 
53HPUCNTAB09Update Address Book 09CharacterGeneric Edit10 Allow NULL? 
54HPCNTRAB09Contract Address Book Number 09NumericGeneric Edit80 Allow NULL? 
55HPUCNTAB10Update Address Book 10CharacterGeneric Edit10 Allow NULL? 
56HPCNTRAB10Contract Address Book Number 10NumericGeneric Edit80 Allow NULL? 
57HPUCNTAB11Update Address Book 11CharacterGeneric Edit10 Allow NULL? 
58HPCNTRAB11Contract Address Book Number 11NumericGeneric Edit80 Allow NULL? 
59HPUCNTAB12Update Address Book 12CharacterGeneric Edit10 Allow NULL? 
60HPCNTRAB12Contract Address Book Number 12NumericGeneric Edit80 Allow NULL? 
61HPUCNTCD01Update Contract Code 01CharacterGeneric Edit10 Allow NULL? 
62HPCNTRT01Contract Code 01StringUDC (43C 01)30 Allow NULL? 
63HPUCNTCD02Update Contract Code 02CharacterGeneric Edit10 Allow NULL? 
64HPCNTRT02Contract Code 02StringUDC (43C 02)30 Allow NULL? 
65HPUCNTCD03Update Contract Code 03CharacterGeneric Edit10 Allow NULL? 
66HPUCNTCD04Update Contract Code 04CharacterGeneric Edit10 Allow NULL? 
67HPCNTRT03Contract Code 03StringUDC (43C 03)30 Allow NULL? 
68HPCNTRT04Contract Code 04StringUDC (43C 04)30 Allow NULL? 
69HPUCNTCD05Update Contract Code 05CharacterGeneric Edit10 Allow NULL? 
70HPCNTRT05Contract Code 05StringUDC (43C 05)30 Allow NULL? 
71HPUCNTCD06Update Contract Code 06CharacterGeneric Edit10 Allow NULL? 
72HPCNTRT06Contract Code 06StringUDC (43C 06)80 Allow NULL? 
73HPUCNTCD07Update Contract Code 07CharacterGeneric Edit10 Allow NULL? 
74HPCNTRT07Contract Code 07StringUDC (43C 07)80 Allow NULL? 
75HPUCNTCD08Update Contract Code 08CharacterGeneric Edit10 Allow NULL? 
76HPCNTRT08Contract Code 08StringUDC (43C 08)80 Allow NULL? 
77HPUCNTCD09Update Contract Code 09CharacterGeneric Edit10 Allow NULL? 
78HPCNTRT09Contract Code 09StringUDC (43C 09)80 Allow NULL? 
79HPUCNTCD10Update Contract Code 10CharacterGeneric Edit10 Allow NULL? 
80HPCNTRT10Contract Code 10StringUDC (43C 10)80 Allow NULL? 
81HPUCNTCD11Update Contract Code 11CharacterGeneric Edit10 Allow NULL? 
82HPCNTRT11Contract Code 11StringUDC (43C 11)100 Allow NULL? 
83HPUCNTCD12Update Contract Code 12CharacterGeneric Edit10 Allow NULL? 
84HPCNTRT12Contract Code 12StringUDC (43C 12)100 Allow NULL? 
85HPUCNTCD13Update Contract Code 13CharacterGeneric Edit10 Allow NULL? 
86HPCNTRT13Contract Code 13StringUDC (43C 13)100 Allow NULL? 
87HPUCNTCD14Update Contract Code 14CharacterGeneric Edit10 Allow NULL? 
88HPCNTRT14Contract Code 14StringUDC (43C 14)100 Allow NULL? 
89HPUCNTCD15Update Contract Code 15CharacterGeneric Edit10 Allow NULL? 
90HPCNTRT15Contract Code 15StringUDC (43C 15)100 Allow NULL? 
91HPUCNTDT1Update Contract Date 1CharacterGeneric Edit10 Allow NULL? 
92HPCNTRTDT1Contract Date 01DateGeneric Edit60
93HPUCNTDT2Update Contract Date 2CharacterGeneric Edit10 Allow NULL? 
94HPCNTRTDT2Contract Date 02DateGeneric Edit60
95HPUCNTDT3Update Contract Date 3CharacterGeneric Edit10 Allow NULL? 
96HPCNTRTDT3Contract Date 03DateGeneric Edit60
97HPUCNTDT4Update Contract Date 4CharacterGeneric Edit10 Allow NULL? 
98HPCNTRTDT4Contract Date 04DateGeneric Edit60
99HPUCNTDT5Update Contract Date 5CharacterGeneric Edit10 Allow NULL? 
100HPCNTRTDT5Contract Date 05DateGeneric Edit60
101HPUCNTDT6Update Contract Date 6CharacterGeneric Edit10 Allow NULL? 
102HPCNTRTDT6Contract Date 06DateGeneric Edit60
103HPUCNTP1Update Contract Property 1CharacterGeneric Edit10 Allow NULL? 
104HPCNTRPT01Contract Property 01CharacterGeneric Edit10 Allow NULL? 
105HPUCNTP2Update Contract Property 2CharacterGeneric Edit10 Allow NULL? 
106HPCNTRPT02Contract Property 02CharacterGeneric Edit10 Allow NULL? 
107HPUCNTP3Update Contract Property 3CharacterGeneric Edit10 Allow NULL? 
108HPCNTRPT03Contract Property 03CharacterGeneric Edit10 Allow NULL? 
109HPUCNTP4Update Contract Property 4CharacterGeneric Edit10 Allow NULL? 
110HPCNTRPT04Contract Property 04CharacterGeneric Edit10 Allow NULL? 
111HPUCNTP5Update Contract Property 5CharacterGeneric Edit10 Allow NULL? 
112HPCNTRPT05Contract Property 05CharacterGeneric Edit10 Allow NULL? 
113HPUCNTP6Update Contract Property 6CharacterGeneric Edit10 Allow NULL? 
114HPCNTRPT06Contract Property 06CharacterGeneric Edit10 Allow NULL? 
115HPURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
116HPURDTUser Reserved DateDateGeneric Edit60
117HPURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
118HPURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
119HPURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
120HPTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
121HPUSERUser IDStringGeneric Edit100 Allow NULL? 
122HPPIDProgram IDStringGeneric Edit100 Allow NULL? 
123HPJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
124HPUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
125HPCNTPTCBPrice TypeCharacterGeneric Edit10 Allow NULL? 

TOP910 | 43C | F43C010 INDEXES

NumberDescription
1ContractHeaderProfileID (Primary/Unique)
ElementAliasDescriptionSequence
1CTRPRIDContract Header Profile IDAscending