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

74 COLUMNS | 2 INDEXES | Print definition?812 | 43C | F43C01 TABLE

43C: Contracts
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F43C01CH742Contract HeaderFiles43C: 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 CHCNTRTID, CHCNTRTTYP, CHCNTRTNM, CHCNTRTCD, CHCNTRTSTS, CHCNTRAMT, CHMCU, CHCNTRTENT, CHCNTRCRDC, CHPTC, CHCNTRTMGR, CHCNTRTPT, CHCNTRTDF, CHOWNERSP, CHCNTRTSD, CHCNTRTED, CHRNWTYPE, CHRNWEDTE, CHCNTRD, CHRNWTRM, CHRNWUOM, CHCMDCDE, CHGEOCST, CHCNTRTCOM, CHCNTRAB01, CHCNTRAB02, CHCNTRAB03, CHCNTRAB04, CHCNTRAB05, CHCNTRAB06, CHCNTRAB07, CHCNTRAB08, CHCNTRAB09, CHCNTRAB10, CHCNTRAB11, CHCNTRAB12, CHCNTRT01, CHCNTRT02, CHCNTRT03, CHCNTRT04, CHCNTRT05, CHCNTRT06, CHCNTRT07, CHCNTRT08, CHCNTRT09, CHCNTRT10, CHCNTRT11, CHCNTRT12, CHCNTRT13, CHCNTRT14, CHCNTRT15, CHCNTRTDT1, CHCNTRTDT2, CHCNTRTDT3, CHCNTRTDT4, CHCNTRTDT5, CHCNTRTDT6, CHCNTRPT01, CHCNTRPT02, CHCNTRPT03, CHCNTRPT04, CHCNTRPT05, CHCNTRPT06, CHURCD, CHURDT, CHURAT, CHURAB, CHURRF, CHTORG, CHUSER, CHPID, CHJOBN, CHUUPMJ, CHCNTRTBYR FROM F43C01

TOP812 | 43C | F43C01 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1CHCNTRTIDContract IDNumericGeneric Edit80 Allow NULL? 
2CHCNTRTTYPContract TypeStringGeneric Edit (43C CT)100 Allow NULL? 
3CHCNTRTNMContract NameStringGeneric Edit300 Allow NULL? 
4CHCNTRTCDContract CodeStringGeneric Edit120 Allow NULL? 
5CHCNTRTSTSContract StatusStringUDC (43C CS)30 Allow NULL? 
6CHCNTRAMTContract AmountNumericGeneric Edit152 Allow NULL? 
7CHMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
8CHCNTRTENTContracting EntityNumericGeneric Edit80 Allow NULL? 
9CHCNTRCRDCContract Currency CodeStringGeneric Edit30 Allow NULL? 
10CHPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
11CHCNTRTMGRConract ManagerNumericGeneric Edit80 Allow NULL? 
12CHCNTRTPTPrice TypeStringUDC (43C PT)30 Allow NULL? 
13CHCNTRTDFDelivery FormStringUDC (43C DF)30 Allow NULL? 
14CHOWNERSPOwnershipStringUDC (43C OS)30 Allow NULL? 
15CHCNTRTSDStart DateJDE UTimeGeneric Edit110
16CHCNTRTEDEnd DateJDE UTimeGeneric Edit110
17CHRNWTYPERenew TypeStringUDC (43C RT)30 Allow NULL? 
18CHRNWEDTERenewable End DateJDE UTimeGeneric Edit110
19CHCNTRDReview DateJDE UTimeGeneric Edit110
20CHRNWTRMRenew TermNumericGeneric Edit60 Allow NULL? 
21CHRNWUOMRenew PeriodStringUDC (43C RU)30 Allow NULL? 
22CHCMDCDECommodity CodeStringGeneric Edit150 Allow NULL? 
23CHGEOCSTGeographic IDStringUDC (40G GI)30 Allow NULL? 
24CHCNTRTCOMContract CommentStringGeneric Edit2550 Allow NULL? 
25CHCNTRAB01Contract Address Book Number 01NumericGeneric Edit80 Allow NULL? 
26CHCNTRAB02Contract Address Book Number 02NumericGeneric Edit80 Allow NULL? 
27CHCNTRAB03Contract Address Book Number 03NumericGeneric Edit80 Allow NULL? 
28CHCNTRAB04Contract Address Book Number 04NumericGeneric Edit80 Allow NULL? 
29CHCNTRAB05Contract Address Book Number 05NumericGeneric Edit80 Allow NULL? 
30CHCNTRAB06Contract Address Book Number 06NumericGeneric Edit80 Allow NULL? 
31CHCNTRAB07Contract Address Book Number 07NumericGeneric Edit80 Allow NULL? 
32CHCNTRAB08Contract Address Book Number 08NumericGeneric Edit80 Allow NULL? 
33CHCNTRAB09Contract Address Book Number 09NumericGeneric Edit80 Allow NULL? 
34CHCNTRAB10Contract Address Book Number 10NumericGeneric Edit80 Allow NULL? 
35CHCNTRAB11Contract Address Book Number 11NumericGeneric Edit80 Allow NULL? 
36CHCNTRAB12Contract Address Book Number 12NumericGeneric Edit80 Allow NULL? 
37CHCNTRT01Contract Code 01StringUDC (43C 01)30 Allow NULL? 
38CHCNTRT02Contract Code 02StringGeneric Edit (43C 02)30 Allow NULL? 
39CHCNTRT03Contract Code 03StringGeneric Edit (43C 03)30 Allow NULL? 
40CHCNTRT04Contract Code 04StringUDC (43C 04)30 Allow NULL? 
41CHCNTRT05Contract Code 05StringUDC (43C 05)30 Allow NULL? 
42CHCNTRT06Contract Code 06StringUDC (43C 06)80 Allow NULL? 
43CHCNTRT07Contract Code 07StringUDC (43C 07)80 Allow NULL? 
44CHCNTRT08Contract Code 08StringUDC (43C 08)80 Allow NULL? 
45CHCNTRT09Contract Code 09StringUDC (43C 09)80 Allow NULL? 
46CHCNTRT10Contract Code 10StringUDC (43C 10)80 Allow NULL? 
47CHCNTRT11Contract Code 11StringUDC (43C 11)100 Allow NULL? 
48CHCNTRT12Contract Code 12StringUDC (43C 12)100 Allow NULL? 
49CHCNTRT13Contract Code 13StringUDC (43C 13)100 Allow NULL? 
50CHCNTRT14Contract Code 14StringUDC (43C 14)100 Allow NULL? 
51CHCNTRT15Contract Code 15StringUDC (43C 15)100 Allow NULL? 
52CHCNTRTDT1Contract Date 01DateGeneric Edit60
53CHCNTRTDT2Contract Date 02DateGeneric Edit60
54CHCNTRTDT3Contract Date 03DateGeneric Edit60
55CHCNTRTDT4Contract Date 04DateGeneric Edit60
56CHCNTRTDT5Contract Date 05DateGeneric Edit60
57CHCNTRTDT6Contract Date 06DateGeneric Edit60
58CHCNTRPT01Contract Property 01CharacterGeneric Edit10 Allow NULL? 
59CHCNTRPT02Contract Property 02CharacterGeneric Edit10 Allow NULL? 
60CHCNTRPT03Contract Property 03CharacterGeneric Edit10 Allow NULL? 
61CHCNTRPT04Contract Property 04CharacterGeneric Edit10 Allow NULL? 
62CHCNTRPT05Contract Property 05CharacterGeneric Edit10 Allow NULL? 
63CHCNTRPT06Contract Property 06CharacterGeneric Edit10 Allow NULL? 
64CHURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
65CHURDTUser Reserved DateDateGeneric Edit60
66CHURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
67CHURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
68CHURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
69CHTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
70CHUSERUser IDStringGeneric Edit100 Allow NULL? 
71CHPIDProgram IDStringGeneric Edit100 Allow NULL? 
72CHJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
73CHUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
74CHCNTRTBYRContract BuyerNumericGeneric Edit80 Allow NULL? 

TOP812 | 43C | F43C01 INDEXES

NumberDescription
1Contract_ID (Primary/Unique)
ElementAliasDescriptionSequence
1CNTRTIDContract IDAscending
2Contract_Code (Unique)
ElementAliasDescriptionSequence
1CNTRTCDContract CodeAscending