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

172 COLUMNS | 1 INDEXES | Print definition?920 | 43C | F43C100 TABLE

43C: Contracts
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F43C100BP1721Contract Block 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 BPCBPRID, BPCBPRDES, BPUCNTPT, BPCNTRTPT, BPUCNTDF, BPCNTRTDF, BPUCNTRTSD, BPCNTRTSD, BPUCNTRTED, BPCNTRTED, BPURNWTYP, BPRNWTYPE, BPURNWED, BPRNWEDTE, BPURNWTRM, BPRNWTRM, BPURNWUOM, BPRNWUOM, BPUCNTCC, BPCMDCDE, BPUCQTY, BPCNTRTQTY, BPUTUOM, BPUOM, BPUDISOR, BPQCONTROL, BPUMINQTY, BPMINQTY, BPUMAXQTY, BPMAXQTY, BPUPUOM, BPUOM3, BPUCNTRTPL, BPPRLEVL, BPUCPG, BPCNTRPRG, BPUPRICOVR, BPPRICEOVR, BPUPOCOM, BPOVRCOMM, BPUMINPRC, BPMINPRICE, BPUMAXPRC, BPMAXPRICE, BPUMP, BPMEMPRICE, BPUMPL, BPPRICELVL, BPUPRCADJ, BPASN, BPCLSID, BPCUPDLVL, BPUCNTAB01, BPCNTRAB01, BPUCNTAB02, BPCNTRAB02, BPUCNTAB03, BPCNTRAB03, BPUCNTAB04, BPCNTRAB04, BPUCNTAB05, BPCNTRAB05, BPUCNTAB06, BPCNTRAB06, BPUCNTAB07, BPCNTRAB07, BPUCNTAB08, BPCNTRAB08, BPUCNTAB09, BPCNTRAB09, BPUCNTAB10, BPCNTRAB10, BPUCNTAB11, BPCNTRAB11, BPUCNTAB12, BPCNTRAB12, BPUCNTCD01, BPCNTRT01, BPUCNTCD02, BPCNTRT02, BPUCNTCD03, BPUCNTCD04, BPCNTRT03, BPCNTRT04, BPUCNTCD05, BPCNTRT05, BPUCNTCD06, BPCNTRT06, BPUCNTCD07, BPCNTRT07, BPUCNTCD08, BPCNTRT08, BPUCNTCD09, BPCNTRT09, BPUCNTCD10, BPCNTRT10, BPUCNTCD11, BPCNTRT11, BPUCNTCD12, BPCNTRT12, BPUCNTCD13, BPCNTRT13, BPUCNTCD14, BPCNTRT14, BPUCNTCD15, BPCNTRT15, BPUCNTDT1, BPCNTRTDT1, BPUCNTDT2, BPCNTRTDT2, BPUCNTDT3, BPCNTRTDT3, BPUCNTDT4, BPCNTRTDT4, BPUCNTDT5, BPCNTRTDT5, BPUCNTDT6, BPCNTRTDT6, BPUCNTP1, BPCNTRPT01, BPUCNTP2, BPCNTRPT02, BPUCNTP3, BPCNTRPT03, BPUCNTP4, BPCNTRPT04, BPUCNTP5, BPCNTRPT05, BPUCNTP6, BPCNTRPT06, BPURCD, BPURDT, BPURAT, BPURAB, BPURRF, BPTORG, BPUSER, BPPID, BPJOBN, BPUUPMJ, BPCNTPTCB, BPCNTCOCB, BPCNTDFCB, BPCNTMNPCB, BPCNTMPCB, BPCNTMPLCB, BPCNTMQCB, BPCNTMXPCB, BPCNTOPCB, BPCNTPACB, BPCNTPGCB, BPCNTPUCB, BPCNTTUCB, BPCNTXQCB, BPCNTPLCB, BPCNTPCCB, BPCNTCQCB, BPPOPPOOL, BPGEQTYP, BPGEQPCT, BPPOPASN, BPPOPPTC, BPUPOOL, BPUEQTYP, BPUEQPCT, BPUPOPASN, BPUPOPPTC, BPPOOLCB, BPGEQTYPCB, BPGEQPCTCB, BPPOPASNCB, BPPOPPTCCB FROM F43C100

TOP920 | 43C | F43C100 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1BPCBPRIDContract Block Profile IDNumericGeneric Edit80 Allow NULL? 
2BPCBPRDESContract Block Profile DescriptionStringGeneric Edit400 Allow NULL? 
3BPUCNTPTUpdate Price TypeCharacterGeneric Edit10 Allow NULL? 
4BPCNTRTPTPrice TypeStringUDC (43C PT)30 Allow NULL? 
5BPUCNTDFUpdate Contract Delivery FormCharacterGeneric Edit10 Allow NULL? 
6BPCNTRTDFDelivery FormStringUDC (43C DF)30 Allow NULL? 
7BPUCNTRTSDUpdate Contract Start DateCharacterGeneric Edit10 Allow NULL? 
8BPCNTRTSDStart DateJDE UTimeGeneric Edit110
9BPUCNTRTEDUpdate Contract End DateCharacterGeneric Edit10 Allow NULL? 
10BPCNTRTEDEnd DateJDE UTimeGeneric Edit110
11BPURNWTYPUpdate Contract Renew TypeCharacterGeneric Edit10 Allow NULL? 
12BPRNWTYPERenew TypeStringUDC (43C RT)30 Allow NULL? 
13BPURNWEDUpdate Renewable End DateCharacterGeneric Edit10 Allow NULL? 
14BPRNWEDTERenewable End DateJDE UTimeGeneric Edit110
15BPURNWTRMUpdate Contract Renew TermCharacterGeneric Edit10 Allow NULL? 
16BPRNWTRMRenew TermNumericGeneric Edit60 Allow NULL? 
17BPURNWUOMUpdate Contract Renew PeriodCharacterGeneric Edit10 Allow NULL? 
18BPRNWUOMRenew PeriodStringUDC (43C RU)30 Allow NULL? 
19BPUCNTCCUpdate Commodity CodeCharacterGeneric Edit10 Allow NULL? 
20BPCMDCDECommodity CodeStringGeneric Edit150 Allow NULL? 
21BPUCQTYUpdate Contract QuantityCharacterGeneric Edit10 Allow NULL? 
22BPCNTRTQTYContracted QuantityNumericGeneric Edit150 Allow NULL? 
23BPUTUOMUpdate Transaction UOMCharacterGeneric Edit10 Allow NULL? 
24BPUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
25BPUDISORUpdate Disallow Over ReceiptCharacterGeneric Edit10 Allow NULL? 
26BPQCONTROLDisallow Over ReceiptCharacterGeneric Edit10 Allow NULL? 
27BPUMINQTYUpdate Minimum QuantityCharacterGeneric Edit10 Allow NULL? 
28BPMINQTYMinimum QuantityNumericGeneric Edit150 Allow NULL? 
29BPUMAXQTYUpdate Maximum QuantityCharacterGeneric Edit10 Allow NULL? 
30BPMAXQTYMaximum QuantityNumericGeneric Edit150 Allow NULL? 
31BPUPUOMUpdate Purchasing UOMCharacterGeneric Edit10 Allow NULL? 
32BPUOM3Unit of Measure - PurchasingStringUDC (00 UM)20 Allow NULL? 
33BPUCNTRTPLUpdate Contract Price LevelCharacterGeneric Edit10 Allow NULL? 
34BPPRLEVLPrice LevelStringUDC (45 PL)100 Allow NULL? 
35BPUCPGUpdate Contract Price GroupCharacterGeneric Edit10 Allow NULL? 
36BPCNTRPRGPrice GroupStringUDC (43C PG)80 Allow NULL? 
37BPUPRICOVRUpdate Contract Price OverrideCharacterGeneric Edit10 Allow NULL? 
38BPPRICEOVRPrice OverrideNumericGeneric Edit154 Allow NULL? 
39BPUPOCOMUpdate Price Override CommentCharacterGeneric Edit10 Allow NULL? 
40BPOVRCOMMPrice Override CommentStringGeneric Edit300 Allow NULL? 
41BPUMINPRCUpdate Minimum PriceCharacterGeneric Edit10 Allow NULL? 
42BPMINPRICEMinimum PriceNumericGeneric Edit154 Allow NULL? 
43BPUMAXPRCUpdate Maximum PriceCharacterGeneric Edit10 Allow NULL? 
44BPMAXPRICEMaximum PriceNumericGeneric Edit154 Allow NULL? 
45BPUMPUpdate Memo PriceCharacterGeneric Edit10 Allow NULL? 
46BPMEMPRICEMemo PriceNumericGeneric Edit154 Allow NULL? 
47BPUMPLUpdate Memo Price LevelCharacterGeneric Edit10 Allow NULL? 
48BPPRICELVLMemo Price LevelStringUDC (45 PL)100 Allow NULL? 
49BPUPRCADJUpdate Price Adjustment ScheduleCharacterGeneric Edit10 Allow NULL? 
50BPASNPrice and Adjustment ScheduleStringUDC (40 AS)80 Allow NULL? 
51BPCLSIDContract Clause Profile IDNumericGeneric Edit80 Allow NULL? 
52BPCUPDLVLContract Mass Update LevelCharacterGeneric Edit10 Allow NULL? 
53BPUCNTAB01Update Address Book 01CharacterGeneric Edit10 Allow NULL? 
54BPCNTRAB01Contract Address Book Number 01NumericGeneric Edit80 Allow NULL? 
55BPUCNTAB02Update Address Book 02CharacterGeneric Edit10 Allow NULL? 
56BPCNTRAB02Contract Address Book Number 02NumericGeneric Edit80 Allow NULL? 
57BPUCNTAB03Update Address Book 03CharacterGeneric Edit10 Allow NULL? 
58BPCNTRAB03Contract Address Book Number 03NumericGeneric Edit80 Allow NULL? 
59BPUCNTAB04Update Address Book 04CharacterGeneric Edit10 Allow NULL? 
60BPCNTRAB04Contract Address Book Number 04NumericGeneric Edit80 Allow NULL? 
61BPUCNTAB05Update Address Book 05CharacterGeneric Edit10 Allow NULL? 
62BPCNTRAB05Contract Address Book Number 05NumericGeneric Edit80 Allow NULL? 
63BPUCNTAB06Update Address Book 06CharacterGeneric Edit10 Allow NULL? 
64BPCNTRAB06Contract Address Book Number 06NumericGeneric Edit80 Allow NULL? 
65BPUCNTAB07Update Address Book 07CharacterGeneric Edit10 Allow NULL? 
66BPCNTRAB07Contract Address Book Number 07NumericGeneric Edit80 Allow NULL? 
67BPUCNTAB08Update Address Book 08CharacterGeneric Edit10 Allow NULL? 
68BPCNTRAB08Contract Address Book Number 08NumericGeneric Edit80 Allow NULL? 
69BPUCNTAB09Update Address Book 09CharacterGeneric Edit10 Allow NULL? 
70BPCNTRAB09Contract Address Book Number 09NumericGeneric Edit80 Allow NULL? 
71BPUCNTAB10Update Address Book 10CharacterGeneric Edit10 Allow NULL? 
72BPCNTRAB10Contract Address Book Number 10NumericGeneric Edit80 Allow NULL? 
73BPUCNTAB11Update Address Book 11CharacterGeneric Edit10 Allow NULL? 
74BPCNTRAB11Contract Address Book Number 11NumericGeneric Edit80 Allow NULL? 
75BPUCNTAB12Update Address Book 12CharacterGeneric Edit10 Allow NULL? 
76BPCNTRAB12Contract Address Book Number 12NumericGeneric Edit80 Allow NULL? 
77BPUCNTCD01Update Contract Code 01CharacterGeneric Edit10 Allow NULL? 
78BPCNTRT01Contract Code 01StringUDC (43C 01)30 Allow NULL? 
79BPUCNTCD02Update Contract Code 02CharacterGeneric Edit10 Allow NULL? 
80BPCNTRT02Contract Code 02StringUDC (43C 02)30 Allow NULL? 
81BPUCNTCD03Update Contract Code 03CharacterGeneric Edit10 Allow NULL? 
82BPUCNTCD04Update Contract Code 04CharacterGeneric Edit10 Allow NULL? 
83BPCNTRT03Contract Code 03StringUDC (43C 03)30 Allow NULL? 
84BPCNTRT04Contract Code 04StringUDC (43C 04)30 Allow NULL? 
85BPUCNTCD05Update Contract Code 05CharacterGeneric Edit10 Allow NULL? 
86BPCNTRT05Contract Code 05StringUDC (43C 05)30 Allow NULL? 
87BPUCNTCD06Update Contract Code 06CharacterGeneric Edit10 Allow NULL? 
88BPCNTRT06Contract Code 06StringUDC (43C 06)80 Allow NULL? 
89BPUCNTCD07Update Contract Code 07CharacterGeneric Edit10 Allow NULL? 
90BPCNTRT07Contract Code 07StringUDC (43C 07)80 Allow NULL? 
91BPUCNTCD08Update Contract Code 08CharacterGeneric Edit10 Allow NULL? 
92BPCNTRT08Contract Code 08StringUDC (43C 08)80 Allow NULL? 
93BPUCNTCD09Update Contract Code 09CharacterGeneric Edit10 Allow NULL? 
94BPCNTRT09Contract Code 09StringUDC (43C 09)80 Allow NULL? 
95BPUCNTCD10Update Contract Code 10CharacterGeneric Edit10 Allow NULL? 
96BPCNTRT10Contract Code 10StringUDC (43C 10)80 Allow NULL? 
97BPUCNTCD11Update Contract Code 11CharacterGeneric Edit10 Allow NULL? 
98BPCNTRT11Contract Code 11StringUDC (43C 11)100 Allow NULL? 
99BPUCNTCD12Update Contract Code 12CharacterGeneric Edit10 Allow NULL? 
100BPCNTRT12Contract Code 12StringUDC (43C 12)100 Allow NULL? 
101BPUCNTCD13Update Contract Code 13CharacterGeneric Edit10 Allow NULL? 
102BPCNTRT13Contract Code 13StringUDC (43C 13)100 Allow NULL? 
103BPUCNTCD14Update Contract Code 14CharacterGeneric Edit10 Allow NULL? 
104BPCNTRT14Contract Code 14StringUDC (43C 14)100 Allow NULL? 
105BPUCNTCD15Update Contract Code 15CharacterGeneric Edit10 Allow NULL? 
106BPCNTRT15Contract Code 15StringUDC (43C 15)100 Allow NULL? 
107BPUCNTDT1Update Contract Date 1CharacterGeneric Edit10 Allow NULL? 
108BPCNTRTDT1Contract Date 01DateGeneric Edit60
109BPUCNTDT2Update Contract Date 2CharacterGeneric Edit10 Allow NULL? 
110BPCNTRTDT2Contract Date 02DateGeneric Edit60
111BPUCNTDT3Update Contract Date 3CharacterGeneric Edit10 Allow NULL? 
112BPCNTRTDT3Contract Date 03DateGeneric Edit60
113BPUCNTDT4Update Contract Date 4CharacterGeneric Edit10 Allow NULL? 
114BPCNTRTDT4Contract Date 04DateGeneric Edit60
115BPUCNTDT5Update Contract Date 5CharacterGeneric Edit10 Allow NULL? 
116BPCNTRTDT5Contract Date 05DateGeneric Edit60
117BPUCNTDT6Update Contract Date 6CharacterGeneric Edit10 Allow NULL? 
118BPCNTRTDT6Contract Date 06DateGeneric Edit60
119BPUCNTP1Update Contract Property 1CharacterGeneric Edit10 Allow NULL? 
120BPCNTRPT01Contract Property 01CharacterGeneric Edit10 Allow NULL? 
121BPUCNTP2Update Contract Property 2CharacterGeneric Edit10 Allow NULL? 
122BPCNTRPT02Contract Property 02CharacterGeneric Edit10 Allow NULL? 
123BPUCNTP3Update Contract Property 3CharacterGeneric Edit10 Allow NULL? 
124BPCNTRPT03Contract Property 03CharacterGeneric Edit10 Allow NULL? 
125BPUCNTP4Update Contract Property 4CharacterGeneric Edit10 Allow NULL? 
126BPCNTRPT04Contract Property 04CharacterGeneric Edit10 Allow NULL? 
127BPUCNTP5Update Contract Property 5CharacterGeneric Edit10 Allow NULL? 
128BPCNTRPT05Contract Property 05CharacterGeneric Edit10 Allow NULL? 
129BPUCNTP6Update Contract Property 6CharacterGeneric Edit10 Allow NULL? 
130BPCNTRPT06Contract Property 06CharacterGeneric Edit10 Allow NULL? 
131BPURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
132BPURDTUser Reserved DateDateGeneric Edit60
133BPURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
134BPURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
135BPURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
136BPTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
137BPUSERUser IDStringGeneric Edit100 Allow NULL? 
138BPPIDProgram IDStringGeneric Edit100 Allow NULL? 
139BPJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
140BPUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
141BPCNTPTCBPrice TypeCharacterGeneric Edit10 Allow NULL? 
142BPCNTCOCBCommodityCharacterGeneric Edit10 Allow NULL? 
143BPCNTDFCBDelivery FormCharacterGeneric Edit10 Allow NULL? 
144BPCNTMNPCBMin PriceCharacterGeneric Edit10 Allow NULL? 
145BPCNTMPCBMemo PriceCharacterGeneric Edit10 Allow NULL? 
146BPCNTMPLCBMemo Price LevelCharacterGeneric Edit10 Allow NULL? 
147BPCNTMQCBMin QuantityCharacterGeneric Edit10 Allow NULL? 
148BPCNTMXPCBMax PriceCharacterGeneric Edit10 Allow NULL? 
149BPCNTOPCBOverride PriceCharacterGeneric Edit10 Allow NULL? 
150BPCNTPACBPricingCharacterGeneric Edit10 Allow NULL? 
151BPCNTPGCBPrice GroupCharacterGeneric Edit10 Allow NULL? 
152BPCNTPUCBPricing UOMCharacterGeneric Edit10 Allow NULL? 
153BPCNTTUCBTransaction UOMCharacterGeneric Edit10 Allow NULL? 
154BPCNTXQCBMax QuantityCharacterGeneric Edit10 Allow NULL? 
155BPCNTPLCBPrice LevelCharacterGeneric Edit10 Allow NULL? 
156BPCNTPCCBPricing CommentCharacterGeneric Edit10 Allow NULL? 
157BPCNTCQCBContracted QuantityCharacterGeneric Edit10 Allow NULL? 
158BPPOPPOOLPay On Proceeds PoolStringUDC (43C PP)80 Allow NULL? 
159BPGEQTYPGrower Equity TypeStringUDC (43C ET)80 Allow NULL? 
160BPGEQPCTGrower Equity PercentNumericGeneric Edit96 Allow NULL? 
161BPPOPASNPay On Proceeds Pricing ScheduleStringUDC (40 AS)80 Allow NULL? 
162BPPOPPTCPay On Proceeds Payment TermsStringGeneric Edit30 Allow NULL? 
163BPUPOOLUpdate POP PoolCharacterGeneric Edit10 Allow NULL? 
164BPUEQTYPUpdate Equity TypeCharacterGeneric Edit10 Allow NULL? 
165BPUEQPCTUpdate Equity PercentCharacterGeneric Edit10 Allow NULL? 
166BPUPOPASNUpdate POP Pricing ScheduleCharacterGeneric Edit10 Allow NULL? 
167BPUPOPPTCUpdate Pay On Proceeds Pay TermsCharacterGeneric Edit10 Allow NULL? 
168BPPOOLCBPay On Proceeds PoolCharacterGeneric Edit10 Allow NULL? 
169BPGEQTYPCBGrower Equity TypeCharacterGeneric Edit10 Allow NULL? 
170BPGEQPCTCBGrower Equity PercentCharacterGeneric Edit10 Allow NULL? 
171BPPOPASNCBPay On Proceeds Pricing ScheduleCharacterGeneric Edit10 Allow NULL? 
172BPPOPPTCCBPay On Proceeds Payment TermsCharacterGeneric Edit10 Allow NULL? 

TOP920 | 43C | F43C100 INDEXES

NumberDescription
1ContractBlockProfileID (Primary/Unique)
ElementAliasDescriptionSequence
1CBPRIDContract Block Profile IDAscending