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

52 COLUMNS | 1 INDEXES | Print definition?910 | 74U | F74U0405 TABLE

74U: United Kingdom Localizations
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F74U0405CH521SPC Certificate Holding Table - UK - 43Files74U: United Kingdom Localizations
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 CHDOCO, CHDCTO, CHKCOO, CHUKCENM, CHSFXO, CHLNID, CHUKCEDT, CHDGL, CHDSVJ, CHDDJ, CHUKAPNM, CH74UACR, CHRMK, CHPTC, CHCRCF, CHCRR, CHCRCD, CHCO, CHUKCEAM, CHUKCEQT, CHUKCEPE, CHRTNG, CH74UPRET, CH74UMCDA, CH74UMCDR, CH74UNT, CH74UCVAT, CHAG, CH74UPLAD, CH74UPMAD, CH74ULMSP, CHUKCECA, CHUKCECQ, CHUKCECP, CH74UCR, CH74UMCDCA, CH74UCN, CH74UCCVAT, CH74UCG, CHURCD, CHURAT, CHURAB, CHURDT, CHURRF, CHTXA1, CHEXR1, CH74UCCC5, CHUSER, CHPID, CHJOBN, CHUPMJ, CHUPMT FROM F74U0405

TOP910 | 74U | F74U0405 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1CHDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
2CHDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
3CHKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
4CHUKCENMCertificate NumberNumericGeneric Edit60 Allow NULL? 
5CHSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
6CHLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
7CHUKCEDTCertificate DateDateGeneric Edit60
8CHDGLDate - For G/L (and Voucher)DateGeneric Edit60
9CHDSVJDate - Service/TaxDateGeneric Edit60
10CHDDJDate - Net DueDateGeneric Edit60
11CHUKAPNMApplication NumberNumericGeneric Edit60 Allow NULL? 
12CH74UACRAlternate Certificate ReferenceStringGeneric Edit150 Allow NULL? 
13CHRMKName - RemarkStringGeneric Edit300 Allow NULL? 
14CHPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
15CHCRCFCurrency Code - OriginStringGeneric Edit30 Allow NULL? 
16CHCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
17CHCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
18CHCOCompanyStringGeneric Edit50 Allow NULL? 
19CHUKCEAMCertificate AmountNumericGeneric Edit152 Allow NULL? 
20CHUKCEQTCertificate QuantityNumericGeneric Edit152 Allow NULL? 
21CHUKCEPECertificate PercentageNumericGeneric Edit52 Allow NULL? 
22CHRTNGRetainageNumericGeneric Edit152 Allow NULL? 
23CH74UPRETRetention PercentageNumericGeneric Edit52 Allow NULL? 
24CH74UMCDAMCD AmountNumericGeneric Edit152 Allow NULL? 
25CH74UMCDRMCD RateNumericGeneric Edit52 Allow NULL? 
26CH74UNTNet AmountNumericGeneric Edit152 Allow NULL? 
27CH74UCVATCertified VATNumericGeneric Edit152 Allow NULL? 
28CHAGAmount - GrossNumericGeneric Edit152 Allow NULL? 
29CH74UPLADSPC Period Labour Amount DomesticNumericGeneric Edit152 Allow NULL? 
30CH74UPMADSPC Period Materials Amount DomesticNumericGeneric Edit152 Allow NULL? 
31CH74ULMSPLabour Materials Split PercentageNumericGeneric Edit52 Allow NULL? 
32CHUKCECACertificate Cumulative AmountNumericGeneric Edit152 Allow NULL? 
33CHUKCECQCertificate Cumulative QuantityNumericGeneric Edit152 Allow NULL? 
34CHUKCECPCertificate Cumulative PercentageNumericGeneric Edit52 Allow NULL? 
35CH74UCRCumulative RetentionNumericGeneric Edit152 Allow NULL? 
36CH74UMCDCAMCD Amount CumulativeNumericGeneric Edit152 Allow NULL? 
37CH74UCNCumulative Net AmountNumericGeneric Edit152 Allow NULL? 
38CH74UCCVATCumulative Certified VATNumericGeneric Edit152 Allow NULL? 
39CH74UCGCumulative Gross AmountNumericGeneric Edit152 Allow NULL? 
40CHURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
41CHURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
42CHURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
43CHURDTUser Reserved DateDateGeneric Edit60
44CHURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
45CHTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
46CHEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
47CH74UCCC5Certificate Catagory Code 5NumericGeneric Edit152 Allow NULL? 
48CHUSERUser IDStringGeneric Edit100 Allow NULL? 
49CHPIDProgram IDStringGeneric Edit100 Allow NULL? 
50CHJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
51CHUPMJDate - UpdatedDateGeneric Edit60
52CHUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 

TOP910 | 74U | F74U0405 INDEXES

NumberDescription
1DOCO DCTO KCOO + (Primary/Unique)
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4UKCENMCertificate NumberAscending
5SFXOOrder SuffixAscending
6LNIDLine NumberAscending