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

139 COLUMNS | 1 INDEXES | Print definition?920 | 43C | F43C110 TABLE

43C: Contracts
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F43C110DP1391Contract Harvest 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 DPCHPRID, DPCHPRDES, DPUCNTPT, DPCNTRTPT, DPUCNTDF, DPCNTRTDF, DPUCNTCC, DPCMDCDE, DPUCQTY, DPCNTRTQTY, DPUTUOM, DPUOM, DPUDISOR, DPQCONTROL, DPUMINQTY, DPMINQTY, DPUMAXQTY, DPMAXQTY, DPUPUOM, DPUOM3, DPUPRCAPP, DPPRICEAPP, DPUCNTRTPL, DPPRLEVL, DPUCPG, DPCNTRPRG, DPUPRICOVR, DPPRICEOVR, DPUPOCOM, DPOVRCOMM, DPUMINPRC, DPMINPRICE, DPUMAXPRC, DPMAXPRICE, DPUMP, DPMEMPRICE, DPUMPL, DPPRICELVL, DPUPRCADJ, DPASN, DPCLSID, DPUCNTAB01, DPCNTRAB01, DPUCNTAB02, DPCNTRAB02, DPUCNTAB03, DPCNTRAB03, DPUCNTAB04, DPCNTRAB04, DPUCNTAB05, DPCNTRAB05, DPUCNTAB06, DPCNTRAB06, DPUCNTAB07, DPCNTRAB07, DPUCNTAB08, DPCNTRAB08, DPUCNTAB09, DPCNTRAB09, DPUCNTAB10, DPCNTRAB10, DPUCNTAB11, DPCNTRAB11, DPUCNTAB12, DPCNTRAB12, DPUCNTCD01, DPCNTRT01, DPUCNTCD02, DPCNTRT02, DPUCNTCD03, DPUCNTCD04, DPCNTRT03, DPCNTRT04, DPUCNTCD05, DPCNTRT05, DPUCNTCD06, DPCNTRT06, DPUCNTCD07, DPCNTRT07, DPUCNTCD08, DPCNTRT08, DPUCNTCD09, DPCNTRT09, DPUCNTCD10, DPCNTRT10, DPUCNTCD11, DPCNTRT11, DPUCNTCD12, DPCNTRT12, DPUCNTCD13, DPCNTRT13, DPUCNTCD14, DPCNTRT14, DPUCNTCD15, DPCNTRT15, DPUCNTDT1, DPCNTRTDT1, DPUCNTDT2, DPCNTRTDT2, DPUCNTDT3, DPCNTRTDT3, DPUCNTDT4, DPCNTRTDT4, DPUCNTDT5, DPCNTRTDT5, DPUCNTDT6, DPCNTRTDT6, DPUCNTP1, DPCNTRPT01, DPUCNTP2, DPCNTRPT02, DPUCNTP3, DPCNTRPT03, DPUCNTP4, DPCNTRPT04, DPUCNTP5, DPCNTRPT05, DPUCNTP6, DPCNTRPT06, DPURCD, DPURDT, DPURAT, DPURAB, DPURRF, DPTORG, DPUSER, DPPID, DPJOBN, DPUUPMJ, DPPOPPOOL, DPGEQTYP, DPGEQPCT, DPPOPASN, DPPOPPTC, DPUPOOL, DPUEQTYP, DPUEQPCT, DPUPOPASN, DPUPOPPTC FROM F43C110

TOP920 | 43C | F43C110 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1DPCHPRIDContract Harvest Profile IDNumericGeneric Edit80 Allow NULL? 
2DPCHPRDESContract Harvest Profile DescriptionStringGeneric Edit400 Allow NULL? 
3DPUCNTPTUpdate Price TypeCharacterGeneric Edit10 Allow NULL? 
4DPCNTRTPTPrice TypeStringUDC (43C PT)30 Allow NULL? 
5DPUCNTDFUpdate Contract Delivery FormCharacterGeneric Edit10 Allow NULL? 
6DPCNTRTDFDelivery FormStringUDC (43C DF)30 Allow NULL? 
7DPUCNTCCUpdate Commodity CodeCharacterGeneric Edit10 Allow NULL? 
8DPCMDCDECommodity CodeStringGeneric Edit150 Allow NULL? 
9DPUCQTYUpdate Contract QuantityCharacterGeneric Edit10 Allow NULL? 
10DPCNTRTQTYContracted QuantityNumericGeneric Edit150 Allow NULL? 
11DPUTUOMUpdate Transaction UOMCharacterGeneric Edit10 Allow NULL? 
12DPUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
13DPUDISORUpdate Disallow Over ReceiptCharacterGeneric Edit10 Allow NULL? 
14DPQCONTROLDisallow Over ReceiptCharacterGeneric Edit10 Allow NULL? 
15DPUMINQTYUpdate Minimum QuantityCharacterGeneric Edit10 Allow NULL? 
16DPMINQTYMinimum QuantityNumericGeneric Edit150 Allow NULL? 
17DPUMAXQTYUpdate Maximum QuantityCharacterGeneric Edit10 Allow NULL? 
18DPMAXQTYMaximum QuantityNumericGeneric Edit150 Allow NULL? 
19DPUPUOMUpdate Purchasing UOMCharacterGeneric Edit10 Allow NULL? 
20DPUOM3Unit of Measure - PurchasingStringUDC (00 UM)20 Allow NULL? 
21DPUPRCAPPUpdate Price ApprovedCharacterGeneric Edit10 Allow NULL? 
22DPPRICEAPPPrice ApprovedCharacterGeneric Edit10 Allow NULL? 
23DPUCNTRTPLUpdate Contract Price LevelCharacterGeneric Edit10 Allow NULL? 
24DPPRLEVLPrice LevelStringUDC (45 PL)100 Allow NULL? 
25DPUCPGUpdate Contract Price GroupCharacterGeneric Edit10 Allow NULL? 
26DPCNTRPRGPrice GroupStringUDC (43C PG)80 Allow NULL? 
27DPUPRICOVRUpdate Contract Price OverrideCharacterGeneric Edit10 Allow NULL? 
28DPPRICEOVRPrice OverrideNumericGeneric Edit154 Allow NULL? 
29DPUPOCOMUpdate Price Override CommentCharacterGeneric Edit10 Allow NULL? 
30DPOVRCOMMPrice Override CommentStringGeneric Edit300 Allow NULL? 
31DPUMINPRCUpdate Minimum PriceCharacterGeneric Edit10 Allow NULL? 
32DPMINPRICEMinimum PriceNumericGeneric Edit154 Allow NULL? 
33DPUMAXPRCUpdate Maximum PriceCharacterGeneric Edit10 Allow NULL? 
34DPMAXPRICEMaximum PriceNumericGeneric Edit154 Allow NULL? 
35DPUMPUpdate Memo PriceCharacterGeneric Edit10 Allow NULL? 
36DPMEMPRICEMemo PriceNumericGeneric Edit154 Allow NULL? 
37DPUMPLUpdate Memo Price LevelCharacterGeneric Edit10 Allow NULL? 
38DPPRICELVLMemo Price LevelStringUDC (45 PL)100 Allow NULL? 
39DPUPRCADJUpdate Price Adjustment ScheduleCharacterGeneric Edit10 Allow NULL? 
40DPASNPrice and Adjustment ScheduleStringUDC (40 AS)80 Allow NULL? 
41DPCLSIDContract Clause Profile IDNumericGeneric Edit80 Allow NULL? 
42DPUCNTAB01Update Address Book 01CharacterGeneric Edit10 Allow NULL? 
43DPCNTRAB01Contract Address Book Number 01NumericGeneric Edit80 Allow NULL? 
44DPUCNTAB02Update Address Book 02CharacterGeneric Edit10 Allow NULL? 
45DPCNTRAB02Contract Address Book Number 02NumericGeneric Edit80 Allow NULL? 
46DPUCNTAB03Update Address Book 03CharacterGeneric Edit10 Allow NULL? 
47DPCNTRAB03Contract Address Book Number 03NumericGeneric Edit80 Allow NULL? 
48DPUCNTAB04Update Address Book 04CharacterGeneric Edit10 Allow NULL? 
49DPCNTRAB04Contract Address Book Number 04NumericGeneric Edit80 Allow NULL? 
50DPUCNTAB05Update Address Book 05CharacterGeneric Edit10 Allow NULL? 
51DPCNTRAB05Contract Address Book Number 05NumericGeneric Edit80 Allow NULL? 
52DPUCNTAB06Update Address Book 06CharacterGeneric Edit10 Allow NULL? 
53DPCNTRAB06Contract Address Book Number 06NumericGeneric Edit80 Allow NULL? 
54DPUCNTAB07Update Address Book 07CharacterGeneric Edit10 Allow NULL? 
55DPCNTRAB07Contract Address Book Number 07NumericGeneric Edit80 Allow NULL? 
56DPUCNTAB08Update Address Book 08CharacterGeneric Edit10 Allow NULL? 
57DPCNTRAB08Contract Address Book Number 08NumericGeneric Edit80 Allow NULL? 
58DPUCNTAB09Update Address Book 09CharacterGeneric Edit10 Allow NULL? 
59DPCNTRAB09Contract Address Book Number 09NumericGeneric Edit80 Allow NULL? 
60DPUCNTAB10Update Address Book 10CharacterGeneric Edit10 Allow NULL? 
61DPCNTRAB10Contract Address Book Number 10NumericGeneric Edit80 Allow NULL? 
62DPUCNTAB11Update Address Book 11CharacterGeneric Edit10 Allow NULL? 
63DPCNTRAB11Contract Address Book Number 11NumericGeneric Edit80 Allow NULL? 
64DPUCNTAB12Update Address Book 12CharacterGeneric Edit10 Allow NULL? 
65DPCNTRAB12Contract Address Book Number 12NumericGeneric Edit80 Allow NULL? 
66DPUCNTCD01Update Contract Code 01CharacterGeneric Edit10 Allow NULL? 
67DPCNTRT01Contract Code 01StringUDC (43C 01)30 Allow NULL? 
68DPUCNTCD02Update Contract Code 02CharacterGeneric Edit10 Allow NULL? 
69DPCNTRT02Contract Code 02StringUDC (43C 02)30 Allow NULL? 
70DPUCNTCD03Update Contract Code 03CharacterGeneric Edit10 Allow NULL? 
71DPUCNTCD04Update Contract Code 04CharacterGeneric Edit10 Allow NULL? 
72DPCNTRT03Contract Code 03StringUDC (43C 03)30 Allow NULL? 
73DPCNTRT04Contract Code 04StringUDC (43C 04)30 Allow NULL? 
74DPUCNTCD05Update Contract Code 05CharacterGeneric Edit10 Allow NULL? 
75DPCNTRT05Contract Code 05StringUDC (43C 05)30 Allow NULL? 
76DPUCNTCD06Update Contract Code 06CharacterGeneric Edit10 Allow NULL? 
77DPCNTRT06Contract Code 06StringUDC (43C 06)80 Allow NULL? 
78DPUCNTCD07Update Contract Code 07CharacterGeneric Edit10 Allow NULL? 
79DPCNTRT07Contract Code 07StringUDC (43C 07)80 Allow NULL? 
80DPUCNTCD08Update Contract Code 08CharacterGeneric Edit10 Allow NULL? 
81DPCNTRT08Contract Code 08StringUDC (43C 08)80 Allow NULL? 
82DPUCNTCD09Update Contract Code 09CharacterGeneric Edit10 Allow NULL? 
83DPCNTRT09Contract Code 09StringUDC (43C 09)80 Allow NULL? 
84DPUCNTCD10Update Contract Code 10CharacterGeneric Edit10 Allow NULL? 
85DPCNTRT10Contract Code 10StringUDC (43C 10)80 Allow NULL? 
86DPUCNTCD11Update Contract Code 11CharacterGeneric Edit10 Allow NULL? 
87DPCNTRT11Contract Code 11StringUDC (43C 11)100 Allow NULL? 
88DPUCNTCD12Update Contract Code 12CharacterGeneric Edit10 Allow NULL? 
89DPCNTRT12Contract Code 12StringUDC (43C 12)100 Allow NULL? 
90DPUCNTCD13Update Contract Code 13CharacterGeneric Edit10 Allow NULL? 
91DPCNTRT13Contract Code 13StringUDC (43C 13)100 Allow NULL? 
92DPUCNTCD14Update Contract Code 14CharacterGeneric Edit10 Allow NULL? 
93DPCNTRT14Contract Code 14StringUDC (43C 14)100 Allow NULL? 
94DPUCNTCD15Update Contract Code 15CharacterGeneric Edit10 Allow NULL? 
95DPCNTRT15Contract Code 15StringUDC (43C 15)100 Allow NULL? 
96DPUCNTDT1Update Contract Date 1CharacterGeneric Edit10 Allow NULL? 
97DPCNTRTDT1Contract Date 01DateGeneric Edit60
98DPUCNTDT2Update Contract Date 2CharacterGeneric Edit10 Allow NULL? 
99DPCNTRTDT2Contract Date 02DateGeneric Edit60
100DPUCNTDT3Update Contract Date 3CharacterGeneric Edit10 Allow NULL? 
101DPCNTRTDT3Contract Date 03DateGeneric Edit60
102DPUCNTDT4Update Contract Date 4CharacterGeneric Edit10 Allow NULL? 
103DPCNTRTDT4Contract Date 04DateGeneric Edit60
104DPUCNTDT5Update Contract Date 5CharacterGeneric Edit10 Allow NULL? 
105DPCNTRTDT5Contract Date 05DateGeneric Edit60
106DPUCNTDT6Update Contract Date 6CharacterGeneric Edit10 Allow NULL? 
107DPCNTRTDT6Contract Date 06DateGeneric Edit60
108DPUCNTP1Update Contract Property 1CharacterGeneric Edit10 Allow NULL? 
109DPCNTRPT01Contract Property 01CharacterGeneric Edit10 Allow NULL? 
110DPUCNTP2Update Contract Property 2CharacterGeneric Edit10 Allow NULL? 
111DPCNTRPT02Contract Property 02CharacterGeneric Edit10 Allow NULL? 
112DPUCNTP3Update Contract Property 3CharacterGeneric Edit10 Allow NULL? 
113DPCNTRPT03Contract Property 03CharacterGeneric Edit10 Allow NULL? 
114DPUCNTP4Update Contract Property 4CharacterGeneric Edit10 Allow NULL? 
115DPCNTRPT04Contract Property 04CharacterGeneric Edit10 Allow NULL? 
116DPUCNTP5Update Contract Property 5CharacterGeneric Edit10 Allow NULL? 
117DPCNTRPT05Contract Property 05CharacterGeneric Edit10 Allow NULL? 
118DPUCNTP6Update Contract Property 6CharacterGeneric Edit10 Allow NULL? 
119DPCNTRPT06Contract Property 06CharacterGeneric Edit10 Allow NULL? 
120DPURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
121DPURDTUser Reserved DateDateGeneric Edit60
122DPURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
123DPURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
124DPURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
125DPTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
126DPUSERUser IDStringGeneric Edit100 Allow NULL? 
127DPPIDProgram IDStringGeneric Edit100 Allow NULL? 
128DPJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
129DPUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
130DPPOPPOOLPay On Proceeds PoolStringUDC (43C PP)80 Allow NULL? 
131DPGEQTYPGrower Equity TypeStringUDC (43C ET)80 Allow NULL? 
132DPGEQPCTGrower Equity PercentNumericGeneric Edit96 Allow NULL? 
133DPPOPASNPay On Proceeds Pricing ScheduleStringUDC (40 AS)80 Allow NULL? 
134DPPOPPTCPay On Proceeds Payment TermsStringGeneric Edit30 Allow NULL? 
135DPUPOOLUpdate POP PoolCharacterGeneric Edit10 Allow NULL? 
136DPUEQTYPUpdate Equity TypeCharacterGeneric Edit10 Allow NULL? 
137DPUEQPCTUpdate Equity PercentCharacterGeneric Edit10 Allow NULL? 
138DPUPOPASNUpdate POP Pricing ScheduleCharacterGeneric Edit10 Allow NULL? 
139DPUPOPPTCUpdate Pay On Proceeds Pay TermsCharacterGeneric Edit10 Allow NULL? 

TOP920 | 43C | F43C110 INDEXES

NumberDescription
1ContractBlockProfileID (Primary/Unique)
ElementAliasDescriptionSequence
1CHPRIDContract Harvest Profile IDAscending