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

80 COLUMNS | 9 INDEXES | Print definition?812 | 52 | F5201 TABLE

52: Contract Billing
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F5201G4809Contract Master FileMaster Files52: Contract BillingNo
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 G4DOCO, G4DCTO, G4KCOO, G4ICU, G4ICUJ, G4DL01, G4DC, G4DL02, G4DL03, G4ODCM, G4OCNC, G4AN8O, G4MCIF, G4NTEF, G4RCTL, G4ANOB, G4ADCM, G4AN8K, G4USA3, G4USA4, G4USA1, G4USA2, G4USA5, G4DS, G4CT, G4MCUS, G4JMCU, G4CO, G4PCTN, G4PCTT, G4PCKO, G4RTNR, G4RGLC, G4RTN1, G4EXR1, G4TXA1, G4INVF, G4AIAB, G4CTOV, G4PTC, G4BLWP, G4PYWP, G4BROV, G4FSLV, G4CRCD, G4CRCF, G4CRRM, G4NTEX, G4RNTE, G4ERDB, G4LMEX, G4MCIA, G4CSDT, G4CDTE, G4USD1, G4USD2, G4USD3, G4USD4, G4AI01, G4AI02, G4AI03, G4AI04, G4AI05, G4AI11, G4AI12, G4AI13, G4AI14, G4AI15, G4CRR, G4CRRD, G4CTF2, G4CTF3, G4CTF4, G4CTF5, G4BCTK, G4PID, G4JOBN, G4USER, G4MUPM, G4UPMT FROM F5201

TOP812 | 52 | F5201 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1G4DOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
2G4DCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
3G4KCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
4G4ICUBatch NumberNumericGeneric Edit80 Allow NULL? 
5G4ICUJBatch Number - RevenueNumericGeneric Edit80 Allow NULL? 
6G4DL01DescriptionStringGeneric Edit300 Allow NULL? 
7G4DCDescription - CompressedStringGeneric Edit400 Allow NULL? 
8G4DL02Description 02StringGeneric Edit300 Allow NULL? 
9G4DL03Description 03StringGeneric Edit300 Allow NULL? 
10G4ODCMOwner Contract No.StringGeneric Edit250 Allow NULL? 
11G4OCNCOwner Contract No. CompressedStringGeneric Edit200 Allow NULL? 
12G4AN8OAddress Number - Job A/RNumericGeneric Edit80 Allow NULL? 
13G4MCIFMinimum Contract Invoice Amount-ForeignNumericGeneric Edit152 Allow NULL? 
14G4NTEFNot to Exceed Amount-ForeignNumericGeneric Edit152 Allow NULL? 
15G4RCTLRetainage Control FlagCharacterUDC (48S RC)10 Allow NULL? 
16G4ANOBAddress Number - Owner BillingNumericGeneric Edit80 Allow NULL? 
17G4ADCMArchitect Contract NumberStringGeneric Edit250 Allow NULL? 
18G4AN8KAddress Number - ArchitectNumericGeneric Edit80 Allow NULL? 
19G4USA3Address Number 3 - UserNumericGeneric Edit80 Allow NULL? 
20G4USA4Address Number - Remit ToNumericGeneric Edit80 Allow NULL? 
21G4USA1Address Number 1 - UserNumericGeneric Edit80 Allow NULL? 
22G4USA2Address Number 2 - UserNumericGeneric Edit80 Allow NULL? 
23G4USA5Address Number - Send ToNumericGeneric Edit80 Allow NULL? 
24G4DSContract StatusStringUDC (52 CS)20 Allow NULL? 
25G4CTContract TypeStringUDC (51 CT)40 Allow NULL? 
26G4MCUSBusiness Unit - SubsequentStringGeneric Edit120 Allow NULL? 
27G4JMCUBusiness Unit - HostStringGeneric Edit120 Allow NULL? 
28G4COCompanyStringGeneric Edit50 Allow NULL? 
29G4PCTNParent Contract NumberNumericGeneric Edit80 Allow NULL? 
30G4PCTTParent Contract TypeStringUDC (00 DT)20 Allow NULL? 
31G4PCKOParent Contract Document CompanyStringGeneric Edit50 Allow NULL? 
32G4RTNRRetainage RuleStringGeneric Edit30 Allow NULL? 
33G4RGLCRetention G/L OffsetStringGeneric Edit40 Allow NULL? 
34G4RTN1Retainage Rule - Stored MaterialStringGeneric Edit30 Allow NULL? 
35G4EXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
36G4TXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
37G4INVFInvoice Format CodeStringGeneric Edit100 Allow NULL? 
38G4AIABAIA Billing Form - Y/NCharacterUDC (H50 AI)10 Allow NULL? 
39G4CTOVContract Override RuleCharacterUDC (H50 CV)10 Allow NULL? 
40G4PTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
41G4BLWPBill When PaidCharacterUDC (52 BP)10 Allow NULL? 
42G4PYWPPay When PaidCharacterGeneric Edit10 Allow NULL? 
43G4BROVBurden Override RuleCharacterUDC (H50 BR)10 Allow NULL? 
44G4FSLVFee Summarization LevelCharacterUDC (H50 FS)10 Allow NULL? 
45G4CRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
46G4CRCFCurrency Code - OriginStringGeneric Edit30 Allow NULL? 
47G4CRRMCurrency Mode-Foreign or Domestic EntryCharacterUDC (H00 CY)10 Allow NULL? 
48G4NTEXNot to Exceed AmountNumericGeneric Edit152 Allow NULL? 
49G4RNTENot to Exceed Amount - RestatedNumericGeneric Edit152 Allow NULL? 
50G4ERDBDate - Exchange Rate Date BasisCharacterGeneric Edit10 Allow NULL? 
51G4LMEXLimit Exceeded FlagCharacterGeneric Edit10 Allow NULL? 
52G4MCIAMinimum Contract Invoice AmountNumericGeneric Edit152 Allow NULL? 
53G4CSDTContract Start DateDateGeneric Edit60
54G4CDTEContract Completion DateDateGeneric Edit60
55G4USD1User Date 1DateGeneric Edit60
56G4USD2User Date 2DateGeneric Edit60
57G4USD3User Date 3DateGeneric Edit60
58G4USD4User Date 4DateGeneric Edit60
59G4AI01Contract Category Code 1StringUDC (52 01)30 Allow NULL? 
60G4AI02Contract Category Code 2StringUDC (52 02)30 Allow NULL? 
61G4AI03Contract Category Code 3StringUDC (52 03)30 Allow NULL? 
62G4AI04Contract Category Code 4StringUDC (52 04)30 Allow NULL? 
63G4AI05Contract Category Code 5StringUDC (52 05)30 Allow NULL? 
64G4AI11Contract Category Code 11StringUDC (52 11)100 Allow NULL? 
65G4AI12Contract Category Code 12StringUDC (52 12)100 Allow NULL? 
66G4AI13Contract Category Code 13StringUDC (52 13)100 Allow NULL? 
67G4AI14Contract Category Code 14StringUDC (52 14)100 Allow NULL? 
68G4AI15Contract Category Code 15StringUDC (52 15)100 Allow NULL? 
69G4CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
70G4CRRDCurrency Conversion Rate - DivisorNumericGeneric Edit150 Allow NULL? 
71G4CTF2Control Flag 2CharacterGeneric Edit10 Allow NULL? 
72G4CTF3Progress Cross Reference FlagCharacterUDC (52 PX)10 Allow NULL? 
73G4CTF4Control Flag 4CharacterGeneric Edit10 Allow NULL? 
74G4CTF5Not To Exceed RuleCharacterUDC (52 NT)10 Allow NULL? 
75G4BCTKBatch Control KeyStringGeneric Edit100 Allow NULL? 
76G4PIDProgram IDStringGeneric Edit100 Allow NULL? 
77G4JOBNWork Station IDStringGeneric Edit100 Allow NULL? 
78G4USERUser IDStringGeneric Edit100 Allow NULL? 
79G4MUPMDate - UpdatedDateGeneric Edit60
80G4UPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 

TOP812 | 52 | F5201 INDEXES

NumberDescription
1ContractNumber Type Company (Primary/Unique)
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
2AddressNumber OrderNumber +
ElementAliasDescriptionSequence
1AN8OAddress Number - Job A/RAscending
2DOCODocument (Order No Invoice etc.)Ascending
3DCTOOrder TypeAscending
4KCOOOrder Company (Order Number)Ascending
3CostCenter OrderNumber +
ElementAliasDescriptionSequence
1MCUSBusiness Unit - SubsequentAscending
2DOCODocument (Order No Invoice etc.)Ascending
3DCTOOrder TypeAscending
4KCOOOrder Company (Order Number)Ascending
5DescCompressed OrderNumber +
ElementAliasDescriptionSequence
1DCDescription - CompressedAscending
2DOCODocument (Order No Invoice etc.)Ascending
3DCTOOrder TypeAscending
4KCOOOrder Company (Order Number)Ascending
6OwnerContract Order Number +
ElementAliasDescriptionSequence
1OCNCOwner Contract No. CompressedAscending
2DOCODocument (Order No Invoice etc.)Ascending
3DCTOOrder TypeAscending
4KCOOOrder Company (Order Number)Ascending
8ContractType OrderNumber +
ElementAliasDescriptionSequence
1CTContract TypeAscending
2DOCODocument (Order No Invoice etc.)Ascending
3DCTOOrder TypeAscending
4KCOOOrder Company (Order Number)Ascending
9ContractStatus OrderNumber +
ElementAliasDescriptionSequence
1DSContract StatusAscending
2DOCODocument (Order No Invoice etc.)Ascending
3DCTOOrder TypeAscending
4KCOOOrder Company (Order Number)Ascending
10ParentContNumber ParentContTyp
ElementAliasDescriptionSequence
1PCTNParent Contract NumberAscending
2PCTTParent Contract TypeAscending
12ContractNumber Type
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending