JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.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
2F9671SDSoftware Update Detail Table
3F0101ABAddress Book Master
4F4101IMItem Master
5F0911GLAccount Ledger
6F4311PDPurchase Order Detail File
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F03012AICustomer Master by Line of Business
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F03B11RPCustomer Ledger
8F4311PDPurchase Order Detail File
9F0411RPAccounts Payable Ledger
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F0411RPAccounts Payable Ledger
4F4311PDPurchase Order Detail File
5F4211SDSales Order Detail File
6F42119SDSales Order History File
7F0006MCBusiness Unit Master
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

183 COLUMNS | 1 INDEXES | Print definition?920 | 52G | F52G01M TABLE

52G: Proj & Gov Contract Accounting
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F52G01MCM1831Advanced Contracts ModificationsMaster Files52G: Proj & Gov Contract Accounting
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 CMDOCO, CMDCTO, CMKCOO, CMGCSE, CMMODNU, CMMODREV, CMMODTY, CMMODDT, CMMODDE, CMMODGL, CMDL01, CMDC, CMDL02, CMDL03, CMODCM, CMOCNC, CMAN8O, CMMCIF, CMNTEF, CMRCTL, CMANOB, CMADCM, CMAN8K, CMUSA1, CMUSA2, CMUSA3, CMUSA4, CMUSA5, CMDS, CMCT, CMMCUS, CMJMCU, CMCO, CMPCTN, CMPCTT, CMPCKO, CMRTNR, CMRGLC, CMRTN1, CMEXR1, CMTXA1, CMINVF, CMAIAB, CMCTOV, CMPTC, CMBLWP, CMPYWP, CMBROV, CMFSLV, CMCRCD, CMCRCF, CMCRRM, CMNTEX, CMRNTE, CMERDB, CMLMEX, CMMCIA, CMCSDT, CMCDTE, CMUSD1, CMUSD2, CMUSD3, CMUSD4, CMUSD5, CMUSD6, CMUSD7, CMUSD8, CMUSD9, CMAI01, CMAI02, CMAI03, CMAI04, CMAI05, CMAI06, CMAI07, CMAI08, CMAI09, CMAI10, CMAI11, CMAI12, CMAI13, CMAI14, CMAI15, CMAI16, CMAI17, CMAI18, CMAI19, CMAI20, CMCRR, CMCRRD, CMCTF2, CMCTF3, CMCTF4, CMCTF5, CMBCTK, CMCLNU, CMCLTT, CMCLKO, CMFCCM, CMBURTC, CMCCFLG, CMBURTAC, CMACFLG, CMBURTI, CMICFLG, CMBURTR, CMRCFLG, CMTOCC, CMTOCS, CMPRCO, CMOWOR, CMPOPF, CMPOPT, CMEPOP, CMPOTA, CMAWCOST, CMAWFE, CMAWAFE, CMFUNDC, CMFUNF, CMFUNAF, CMRICO, CMRIFE, CMRIAWF, CMRETMX, CMPOTAF, CMAWCOSTF, CMAWFEF, CMAWAFEF, CMFUNDCF, CMFUNFF, CMFUNAFF, CMRICOF, CMRIFEF, CMRIAWFF, CMRETMXF, CMBILLST, CMBILLMET, CMBILLFRE, CMBILLLIM, CMBILLGRP, CMBILLOVT, CMREVST, CMREVMET, CMREVLIM, CMCAB1, CMCAB2, CMCAB3, CMCAB4, CMCAB5, CMCAB6, CMCAB7, CMCAB8, CMCAB9, CMCAB10, CMCAB11, CMCAB12, CMCAB13, CMCAB14, CMCAB15, CMCLCA, CMSUBLAB, CMALLEV, CMALDES, CMACRNCF, CMACRNAF, CMGOVPR, CMLOER, CMTHRS, CMVARP, CMSECOA, CMDABA, CMCASCO, CMTINACO, CMFDCL, CMQCOPR, CMKEYP, CMVTGR, CMPID, CMMKEY, CMUSER, CMUPMJ, CMUPMT FROM F52G01M

TOP920 | 52G | F52G01M COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1CMDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
2CMDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
3CMKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
4CMGCSEAdvanced Contract Sequence No.NumericGeneric Edit60 Allow NULL? 
5CMMODNUModification NumberStringGeneric Edit100 Allow NULL? 
6CMMODREVModification Revision NumberStringGeneric Edit30 Allow NULL? 
7CMMODTYModification TypeCharacterUDC (52G MT)10 Allow NULL? 
8CMMODDTModification DateDateGeneric Edit60
9CMMODDEModification DescriptionStringGeneric Edit300 Allow NULL? 
10CMMODGLModification GL DateDateGeneric Edit60
11CMDL01DescriptionStringGeneric Edit300 Allow NULL? 
12CMDCDescription - CompressedStringGeneric Edit400 Allow NULL? 
13CMDL02Description 02StringGeneric Edit300 Allow NULL? 
14CMDL03Description 03StringGeneric Edit300 Allow NULL? 
15CMODCMOwner Contract No.StringGeneric Edit250 Allow NULL? 
16CMOCNCOwner Contract No. CompressedStringGeneric Edit200 Allow NULL? 
17CMAN8OAddress Number - Job A/RNumericGeneric Edit80 Allow NULL? 
18CMMCIFMinimum Contract Invoice Amount-ForeignNumericGeneric Edit152 Allow NULL? 
19CMNTEFNot to Exceed Amount-ForeignNumericGeneric Edit152 Allow NULL? 
20CMRCTLRetainage Control FlagCharacterUDC (48S RC)10 Allow NULL? 
21CMANOBAddress Number - Owner BillingNumericGeneric Edit80 Allow NULL? 
22CMADCMArchitect Contract NumberStringGeneric Edit250 Allow NULL? 
23CMAN8KAddress Number - ArchitectNumericGeneric Edit80 Allow NULL? 
24CMUSA1Address Number 1 - UserNumericGeneric Edit80 Allow NULL? 
25CMUSA2Address Number 2 - UserNumericGeneric Edit80 Allow NULL? 
26CMUSA3Address Number 3 - UserNumericGeneric Edit80 Allow NULL? 
27CMUSA4Address Number - Remit ToNumericGeneric Edit80 Allow NULL? 
28CMUSA5Address Number - Send ToNumericGeneric Edit80 Allow NULL? 
29CMDSContract StatusStringUDC (52 CS)20 Allow NULL? 
30CMCTContract TypeStringUDC (51 CT)40 Allow NULL? 
31CMMCUSBusiness Unit - SubsequentStringGeneric Edit120 Allow NULL? 
32CMJMCUBusiness Unit - HostStringGeneric Edit120 Allow NULL? 
33CMCOCompanyStringGeneric Edit50 Allow NULL? 
34CMPCTNParent Contract NumberNumericGeneric Edit80 Allow NULL? 
35CMPCTTParent Contract TypeStringUDC (00 DT)20 Allow NULL? 
36CMPCKOParent Contract Document CompanyStringGeneric Edit50 Allow NULL? 
37CMRTNRRetainage RuleStringGeneric Edit30 Allow NULL? 
38CMRGLCRetention G/L OffsetStringGeneric Edit40 Allow NULL? 
39CMRTN1Retainage Rule - Stored MaterialStringGeneric Edit30 Allow NULL? 
40CMEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
41CMTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
42CMINVFInvoice Format CodeStringGeneric Edit100 Allow NULL? 
43CMAIABAIA Billing Form - Y/NCharacterUDC (H50 AI)10 Allow NULL? 
44CMCTOVContract Override RuleCharacterUDC (H50 CV)10 Allow NULL? 
45CMPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
46CMBLWPBill When PaidCharacterUDC (52 BP)10 Allow NULL? 
47CMPYWPPay When PaidCharacterGeneric Edit10 Allow NULL? 
48CMBROVBurden Override RuleCharacterUDC (H50 BR)10 Allow NULL? 
49CMFSLVFee Summarization LevelCharacterUDC (H50 FS)10 Allow NULL? 
50CMCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
51CMCRCFCurrency Code - OriginStringGeneric Edit30 Allow NULL? 
52CMCRRMCurrency Mode-Foreign or Domestic EntryCharacterUDC (H00 CY)10 Allow NULL? 
53CMNTEXNot to Exceed AmountNumericGeneric Edit152 Allow NULL? 
54CMRNTENot to Exceed Amount - RestatedNumericGeneric Edit152 Allow NULL? 
55CMERDBDate - Exchange Rate Date BasisCharacterGeneric Edit10 Allow NULL? 
56CMLMEXLimit Exceeded FlagCharacterGeneric Edit10 Allow NULL? 
57CMMCIAMinimum Contract Invoice AmountNumericGeneric Edit152 Allow NULL? 
58CMCSDTContract Start DateDateGeneric Edit60
59CMCDTEContract Completion DateDateGeneric Edit60
60CMUSD1User Date 1DateGeneric Edit60
61CMUSD2User Date 2DateGeneric Edit60
62CMUSD3User Date 3DateGeneric Edit60
63CMUSD4User Date 4DateGeneric Edit60
64CMUSD5User Date 5DateGeneric Edit60
65CMUSD6User Date 6DateGeneric Edit60
66CMUSD7User Date 7DateGeneric Edit60
67CMUSD8User Date 8DateGeneric Edit60
68CMUSD9User Date 9DateGeneric Edit60
69CMAI01Contract Category Code 1StringUDC (52 01)30 Allow NULL? 
70CMAI02Contract Category Code 2StringUDC (52 02)30 Allow NULL? 
71CMAI03Contract Category Code 3StringUDC (52 03)30 Allow NULL? 
72CMAI04Contract Category Code 4StringUDC (52 04)30 Allow NULL? 
73CMAI05Contract Category Code 5StringUDC (52 05)30 Allow NULL? 
74CMAI06Contract Category Code 6StringUDC (52 06)30 Allow NULL? 
75CMAI07Contract Category Code 7StringUDC (52 07)30 Allow NULL? 
76CMAI08Contract Category Code 8StringUDC (52 08)30 Allow NULL? 
77CMAI09Contract Category Code 9StringUDC (52 09)30 Allow NULL? 
78CMAI10Contract Category Code 10StringUDC (52 10)30 Allow NULL? 
79CMAI11Contract Category Code 11StringUDC (52 11)100 Allow NULL? 
80CMAI12Contract Category Code 12StringUDC (52 12)100 Allow NULL? 
81CMAI13Contract Category Code 13StringUDC (52 13)100 Allow NULL? 
82CMAI14Contract Category Code 14StringUDC (52 14)100 Allow NULL? 
83CMAI15Contract Category Code 15StringUDC (52 15)100 Allow NULL? 
84CMAI16Contract Category Code 16StringUDC (52G 16)100 Allow NULL? 
85CMAI17Contract Category Code 17StringUDC (52G 17)100 Allow NULL? 
86CMAI18Contract Category Code 18StringUDC (52G 18)100 Allow NULL? 
87CMAI19Contract Category Code 19StringUDC (52G 19)100 Allow NULL? 
88CMAI20Contract Category Code 20StringUDC (52G 20)100 Allow NULL? 
89CMCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
90CMCRRDCurrency Conversion Rate - DivisorNumericGeneric Edit150 Allow NULL? 
91CMCTF2Control Flag 2CharacterGeneric Edit10 Allow NULL? 
92CMCTF3Progress Cross Reference FlagCharacterUDC (52 PX)10 Allow NULL? 
93CMCTF4Control Flag 4CharacterGeneric Edit10 Allow NULL? 
94CMCTF5Not To Exceed RuleCharacterUDC (52 NT)10 Allow NULL? 
95CMBCTKBatch Control KeyStringGeneric Edit100 Allow NULL? 
96CMCLNUContract Level NumberNumericGeneric Edit80 Allow NULL? 
97CMCLTTContract Level TypeStringUDC (00 DT)20 Allow NULL? 
98CMCLKOContract Level CompanyStringGeneric Edit50 Allow NULL? 
99CMFCCMFacilities Capital Cost Of MoneyCharacterGeneric Edit10 Allow NULL? 
100CMBURTC Burden Rate Type-CostStringUDC (48S RT)50 Allow NULL? 
101CMCCFLGCost Ceiling FlagCharacterGeneric Edit10 Allow NULL? 
102CMBURTAC Burden Rate Type-Alternate CostStringUDC (48S RT)50 Allow NULL? 
103CMACFLGAlternate Cost Ceiling FlagCharacterGeneric Edit10 Allow NULL? 
104CMBURTI Burden Rate Type-InvoiceStringUDC (48S RT)50 Allow NULL? 
105CMICFLGInvoice Ceiling FlagCharacterGeneric Edit10 Allow NULL? 
106CMBURTR Burden Rate Type-RevenueStringUDC (48S RT)50 Allow NULL? 
107CMRCFLGRevenue Ceiling FlagCharacterGeneric Edit10 Allow NULL? 
108CMTOCCType of Contract (Client Type)StringUDC (52G CT)40 Allow NULL? 
109CMTOCSType of Contract (Client/Sub)StringUDC (52G CS)40 Allow NULL? 
110CMPRCOPrime Contract NumberStringGeneric Edit300 Allow NULL? 
111CMOWOROwning OrganizationStringGeneric Edit120 Allow NULL? 
112CMPOPFDate - Period of Performance FromDateGeneric Edit60
113CMPOPTDate - Period of Performance ToDateGeneric Edit60
114CMEPOPEnforce Period of PerformanceCharacterGeneric Edit10 Allow NULL? 
115CMPOTAAmount - PotentialNumericGeneric Edit152 Allow NULL? 
116CMAWCOSTAmount - Awarded CostNumericGeneric Edit152 Allow NULL? 
117CMAWFEAmount - Awarded FeeNumericGeneric Edit152 Allow NULL? 
118CMAWAFEAmount - Awarded Award FeeNumericGeneric Edit152 Allow NULL? 
119CMFUNDCAmount - Funded CostNumericGeneric Edit152 Allow NULL? 
120CMFUNFAmount - Funded FeeNumericGeneric Edit152 Allow NULL? 
121CMFUNAFAmount - Funded Award FeeNumericGeneric Edit152 Allow NULL? 
122CMRICOAmount - Risk CostNumericGeneric Edit152 Allow NULL? 
123CMRIFEAmount - Risk FeeNumericGeneric Edit152 Allow NULL? 
124CMRIAWFAmount - Risk Award FeeNumericGeneric Edit152 Allow NULL? 
125CMRETMXAmount - Retainage MaximumNumericGeneric Edit152 Allow NULL? 
126CMPOTAFAmount - Potential ForeignNumericGeneric Edit152 Allow NULL? 
127CMAWCOSTFAmount - Awarded Cost ForeignNumericGeneric Edit152 Allow NULL? 
128CMAWFEFAmount - Awarded Fee ForeignNumericGeneric Edit152 Allow NULL? 
129CMAWAFEFAmount - Awarded Award Fee ForeignNumericGeneric Edit152 Allow NULL? 
130CMFUNDCFAmount - Funded Cost ForeignNumericGeneric Edit152 Allow NULL? 
131CMFUNFFAmount - Funded Fee ForeignNumericGeneric Edit152 Allow NULL? 
132CMFUNAFFAmount - Funded Award Fee ForeignNumericGeneric Edit152 Allow NULL? 
133CMRICOFAmount - Risk Cost ForeignNumericGeneric Edit152 Allow NULL? 
134CMRIFEFAmount - Risk Fee ForeignNumericGeneric Edit152 Allow NULL? 
135CMRIAWFFAmount - Risk Award Fee ForeignNumericGeneric Edit152 Allow NULL? 
136CMRETMXFAmount - Retainage Maximum ForeignNumericGeneric Edit152 Allow NULL? 
137CMBILLSTBilling StatusCharacterUDC (52G BS)10 Allow NULL? 
138CMBILLMETBilling MethodCharacterUDC (52G BM)10 Allow NULL? 
139CMBILLFREBilling Frequency CodeStringUDC (52G BF)30 Allow NULL? 
140CMBILLLIMBilling LimitCharacterUDC (52G LM)10 Allow NULL? 
141CMBILLGRPBilling Group CodeStringUDC (52G BG)30 Allow NULL? 
142CMBILLOVTBill OvertimeCharacterGeneric Edit10 Allow NULL? 
143CMREVSTRevenue StatusCharacterUDC (52G RS)10 Allow NULL? 
144CMREVMETRevenue MethodCharacterUDC (52G RM)10 Allow NULL? 
145CMREVLIMRevenue LimitCharacterUDC (52G LM)10 Allow NULL? 
146CMCAB1Purchasing Contracting OfficerNumericGeneric Edit80 Allow NULL? 
147CMCAB2Accounting Contracting OfficerNumericGeneric Edit80 Allow NULL? 
148CMCAB3Contract Technical ManagerNumericGeneric Edit80 Allow NULL? 
149CMCAB4Admin OfficeNumericGeneric Edit80 Allow NULL? 
150CMCAB5Assignment OfficeNumericGeneric Edit80 Allow NULL? 
151CMCAB6Project Manager 1NumericGeneric Edit80 Allow NULL? 
152CMCAB7Project Manager 2NumericGeneric Edit80 Allow NULL? 
153CMCAB8Project Manager 3NumericGeneric Edit80 Allow NULL? 
154CMCAB9BillerNumericGeneric Edit80 Allow NULL? 
155CMCAB10Contract AdminNumericGeneric Edit80 Allow NULL? 
156CMCAB11Invoice ContactNumericGeneric Edit80 Allow NULL? 
157CMCAB12Contract User Defined Address 12NumericGeneric Edit80 Allow NULL? 
158CMCAB13Contract User Defined Address 13NumericGeneric Edit80 Allow NULL? 
159CMCAB14Contract User Defined Address 14NumericGeneric Edit80 Allow NULL? 
160CMCAB15Contract User Defined Address 15NumericGeneric Edit80 Allow NULL? 
161CMCLCAContract Labor CategoriesCharacterGeneric Edit10 Allow NULL? 
162CMSUBLABSubcontract As LaborCharacterGeneric Edit10 Allow NULL? 
163CMALLEVAllocation Level FlagCharacterUDC (52G AL)10 Allow NULL? 
164CMALDESAllocation Destination JobStringGeneric Edit120 Allow NULL? 
165CMACRNCFACRN Method-Cost/FeeCharacterUDC (52G AM)10 Allow NULL? 
166CMACRNAFACRN Method-Award FeeCharacterUDC (52G AM)10 Allow NULL? 
167CMGOVPRGovernment Priority RatingStringGeneric Edit100 Allow NULL? 
168CMLOERLevel of Effort RequiredCharacterGeneric Edit10 Allow NULL? 
169CMTHRSLOE Target HoursNumericGeneric Edit92 Allow NULL? 
170CMVARPVariance PercentNumericGeneric Edit72 Allow NULL? 
171CMSECOAService Contract ActCharacterGeneric Edit10 Allow NULL? 
172CMDABADavis BaconCharacterGeneric Edit10 Allow NULL? 
173CMCASCOCAS CoveredCharacterGeneric Edit10 Allow NULL? 
174CMTINACOTINA CoveredCharacterGeneric Edit10 Allow NULL? 
175CMFDCLFlow Down Clauses ApplyCharacterGeneric Edit10 Allow NULL? 
176CMQCOPRQuick Close-out ProvisionCharacterGeneric Edit10 Allow NULL? 
177CMKEYPKey PersonnelCharacterGeneric Edit10 Allow NULL? 
178CMVTGRVendor Type Goals RequiredCharacterGeneric Edit10 Allow NULL? 
179CMPIDProgram IDStringGeneric Edit100 Allow NULL? 
180CMMKEYMachine KeyStringGeneric Edit150 Allow NULL? 
181CMUSERUser IDStringGeneric Edit100 Allow NULL? 
182CMUPMJDate - UpdatedDateGeneric Edit60
183CMUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 

TOP920 | 52G | F52G01M INDEXES

NumberDescription
1Contract No Type + (Primary/Unique)
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4GCSEAdvanced Contract Sequence No.Ascending