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

82 COLUMNS | 3 INDEXES | Print definition?812 | 43C | F43C11 TABLE

43C: Contracts
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F43C11CD823Contract DetailFiles43C: 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 CDCNTRTID, CDCNTRTDID, CDBLUID, CDMCU, CDITM, CDLITM, CDAITM, CDCNTRTSD, CDCNTRTED, CDRNWSTE, CDCNTRTDF, CDCMDCDE, CDCNTRTQTY, CDUOM, CDQCONTROL, CDMINQTY, CDMAXQTY, CDPRICEAPP, CDCNTRTPT, CDUOM3, CDPRLEVL, CDCNTRPRG, CDPRICEOVR, CDOVRCOMM, CDMINPRICE, CDMAXPRICE, CDMEMPRICE, CDPRICELVL, CDPTC, CDASN, CDWVID, CDELADV, CDFLPD, CDCNTRAB01, CDCNTRAB02, CDCNTRAB03, CDCNTRAB04, CDCNTRAB05, CDCNTRAB06, CDCNTRAB07, CDCNTRAB08, CDCNTRAB09, CDCNTRAB10, CDCNTRAB11, CDCNTRAB12, CDCNTRT01, CDCNTRT02, CDCNTRT03, CDCNTRT04, CDCNTRT05, CDCNTRT06, CDCNTRT07, CDCNTRT08, CDCNTRT09, CDCNTRT10, CDCNTRT11, CDCNTRT12, CDCNTRT13, CDCNTRT14, CDCNTRT15, CDCNTRTDT1, CDCNTRTDT2, CDCNTRTDT3, CDCNTRTDT4, CDCNTRTDT5, CDCNTRTDT6, CDCNTRPT01, CDCNTRPT02, CDCNTRPT03, CDCNTRPT04, CDCNTRPT05, CDCNTRPT06, CDURCD, CDURDT, CDURAT, CDURAB, CDURRF, CDTORG, CDUSER, CDPID, CDJOBN, CDUUPMJ FROM F43C11

TOP812 | 43C | F43C11 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1CDCNTRTIDContract IDNumericGeneric Edit80 Allow NULL? 
2CDCNTRTDIDContract Detail IDNumericGeneric Edit150 Allow NULL? 
3CDBLUIDBlock IdentifierNumericGeneric Edit80 Allow NULL? 
4CDMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
5CDITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
6CDLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
7CDAITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
8CDCNTRTSDStart DateJDE UTimeGeneric Edit110
9CDCNTRTEDEnd DateJDE UTimeGeneric Edit110
10CDRNWSTERenew StateStringUDC (43C RS)30 Allow NULL? 
11CDCNTRTDFDelivery FormStringUDC (43C DF)30 Allow NULL? 
12CDCMDCDECommodity CodeStringGeneric Edit150 Allow NULL? 
13CDCNTRTQTYContracted QuantityNumericGeneric Edit150 Allow NULL? 
14CDUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
15CDQCONTROLDisallow Over ReceiptCharacterGeneric Edit10 Allow NULL? 
16CDMINQTYMinimum QuantityNumericGeneric Edit150 Allow NULL? 
17CDMAXQTYMaximum QuantityNumericGeneric Edit150 Allow NULL? 
18CDPRICEAPPPrice ApprovedCharacterGeneric Edit10 Allow NULL? 
19CDCNTRTPTPrice TypeStringUDC (43C PT)30 Allow NULL? 
20CDUOM3Unit of Measure - PurchasingStringUDC (00 UM)20 Allow NULL? 
21CDPRLEVLPrice LevelStringUDC (45 PL)100 Allow NULL? 
22CDCNTRPRGPrice GroupStringUDC (43C PG)80 Allow NULL? 
23CDPRICEOVRPrice OverrideNumericGeneric Edit154 Allow NULL? 
24CDOVRCOMMPrice Override CommentStringGeneric Edit300 Allow NULL? 
25CDMINPRICEMinimum PriceNumericGeneric Edit154 Allow NULL? 
26CDMAXPRICEMaximum PriceNumericGeneric Edit154 Allow NULL? 
27CDMEMPRICEMemo PriceNumericGeneric Edit154 Allow NULL? 
28CDPRICELVLMemo Price LevelStringUDC (45 PL)100 Allow NULL? 
29CDPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
30CDASNPrice and Adjustment ScheduleStringUDC (40 AS)80 Allow NULL? 
31CDWVIDVessel IDNumericGeneric Edit80 Allow NULL? 
32CDELADVEligible For AdvanceCharacterGeneric Edit10 Allow NULL? 
33CDFLPDFully PaidCharacterGeneric Edit10 Allow NULL? 
34CDCNTRAB01Contract Address Book Number 01NumericGeneric Edit80 Allow NULL? 
35CDCNTRAB02Contract Address Book Number 02NumericGeneric Edit80 Allow NULL? 
36CDCNTRAB03Contract Address Book Number 03NumericGeneric Edit80 Allow NULL? 
37CDCNTRAB04Contract Address Book Number 04NumericGeneric Edit80 Allow NULL? 
38CDCNTRAB05Contract Address Book Number 05NumericGeneric Edit80 Allow NULL? 
39CDCNTRAB06Contract Address Book Number 06NumericGeneric Edit80 Allow NULL? 
40CDCNTRAB07Contract Address Book Number 07NumericGeneric Edit80 Allow NULL? 
41CDCNTRAB08Contract Address Book Number 08NumericGeneric Edit80 Allow NULL? 
42CDCNTRAB09Contract Address Book Number 09NumericGeneric Edit80 Allow NULL? 
43CDCNTRAB10Contract Address Book Number 10NumericGeneric Edit80 Allow NULL? 
44CDCNTRAB11Contract Address Book Number 11NumericGeneric Edit80 Allow NULL? 
45CDCNTRAB12Contract Address Book Number 12NumericGeneric Edit80 Allow NULL? 
46CDCNTRT01Contract Code 01StringUDC (43C 01)30 Allow NULL? 
47CDCNTRT02Contract Code 02StringGeneric Edit (43C 02)30 Allow NULL? 
48CDCNTRT03Contract Code 03StringGeneric Edit (43C 03)30 Allow NULL? 
49CDCNTRT04Contract Code 04StringUDC (43C 04)30 Allow NULL? 
50CDCNTRT05Contract Code 05StringUDC (43C 05)30 Allow NULL? 
51CDCNTRT06Contract Code 06StringUDC (43C 06)80 Allow NULL? 
52CDCNTRT07Contract Code 07StringUDC (43C 07)80 Allow NULL? 
53CDCNTRT08Contract Code 08StringUDC (43C 08)80 Allow NULL? 
54CDCNTRT09Contract Code 09StringUDC (43C 09)80 Allow NULL? 
55CDCNTRT10Contract Code 10StringUDC (43C 10)80 Allow NULL? 
56CDCNTRT11Contract Code 11StringUDC (43C 11)100 Allow NULL? 
57CDCNTRT12Contract Code 12StringUDC (43C 12)100 Allow NULL? 
58CDCNTRT13Contract Code 13StringUDC (43C 13)100 Allow NULL? 
59CDCNTRT14Contract Code 14StringUDC (43C 14)100 Allow NULL? 
60CDCNTRT15Contract Code 15StringUDC (43C 15)100 Allow NULL? 
61CDCNTRTDT1Contract Date 01DateGeneric Edit60
62CDCNTRTDT2Contract Date 02DateGeneric Edit60
63CDCNTRTDT3Contract Date 03DateGeneric Edit60
64CDCNTRTDT4Contract Date 04DateGeneric Edit60
65CDCNTRTDT5Contract Date 05DateGeneric Edit60
66CDCNTRTDT6Contract Date 06DateGeneric Edit60
67CDCNTRPT01Contract Property 01CharacterGeneric Edit10 Allow NULL? 
68CDCNTRPT02Contract Property 02CharacterGeneric Edit10 Allow NULL? 
69CDCNTRPT03Contract Property 03CharacterGeneric Edit10 Allow NULL? 
70CDCNTRPT04Contract Property 04CharacterGeneric Edit10 Allow NULL? 
71CDCNTRPT05Contract Property 05CharacterGeneric Edit10 Allow NULL? 
72CDCNTRPT06Contract Property 06CharacterGeneric Edit10 Allow NULL? 
73CDURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
74CDURDTUser Reserved DateDateGeneric Edit60
75CDURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
76CDURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
77CDURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
78CDTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
79CDUSERUser IDStringGeneric Edit100 Allow NULL? 
80CDPIDProgram IDStringGeneric Edit100 Allow NULL? 
81CDJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
82CDUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110

TOP812 | 43C | F43C11 INDEXES

NumberDescription
1ContractID Contract DetailID (Primary/Unique)
ElementAliasDescriptionSequence
1CNTRTIDContract IDAscending
2CNTRTDIDContract Detail IDAscending
2ContractID BlockID
ElementAliasDescriptionSequence
1BLUIDBlock IdentifierAscending
2CNTRTIDContract IDAscending
3HarvestID
ElementAliasDescriptionSequence
1WVIDVessel IDAscending