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

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F4311PDPurchase Order Detail File
8F03B11RPCustomer Ledger
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
6F0006MCBusiness Unit Master
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

179 COLUMNS | 12 INDEXES | Print definition?920 | 52 | F5201 TABLE

52: Contract Billing
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F5201G417912Contract MasterMaster Files52: Contract BillingBusiness Data
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, G4GCSE, G4CLNU, G4CLTT, G4CLKO, G4FCCM, G4BURTC, G4CCFLG, G4BURTAC, G4ACFLG, G4BURTI, G4ICFLG, G4BURTR, G4RCFLG, G4TOCC, G4TOCS, G4PRCO, G4OWOR, G4POPF, G4POPT, G4EPOP, G4POTA, G4AWCOST, G4AWFE, G4AWAFE, G4FUNDC, G4FUNF, G4FUNAF, G4RICO, G4RIFE, G4RIAWF, G4RETMX, G4POTAF, G4AWCOSTF, G4AWFEF, G4AWAFEF, G4FUNDCF, G4FUNFF, G4FUNAFF, G4RICOF, G4RIFEF, G4RIAWFF, G4RETMXF, G4BILLST, G4BILLMET, G4BILLFRE, G4BILLLIM, G4BILLGRP, G4BILLOVT, G4REVST, G4REVMET, G4REVLIM, G4CAB1, G4CAB2, G4CAB3, G4CAB4, G4CAB5, G4CAB6, G4CAB7, G4CAB8, G4CAB9, G4CAB10, G4CAB11, G4CAB12, G4CAB13, G4CAB14, G4CAB15, G4CLCA, G4SUBLAB, G4ALLEV, G4ALDES, G4ACRNCF, G4ACRNAF, G4GOVPR, G4LOER, G4THRS, G4VARP, G4SECOA, G4DABA, G4CASCO, G4TINACO, G4FDCL, G4QCOPR, G4KEYP, G4VTGR, G4AI06, G4AI07, G4AI08, G4AI09, G4AI10, G4AI16, G4AI17, G4AI18, G4AI19, G4AI20, G4USD5, G4USD6, G4USD7, G4USD8, G4USD9 FROM F5201

TOP920 | 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? 
81G4GCSEAdvanced Contract Sequence No.NumericGeneric Edit60 Allow NULL? 
82G4CLNUContract Level NumberNumericGeneric Edit80 Allow NULL? 
83G4CLTTContract Level TypeStringUDC (00 DT)20 Allow NULL? 
84G4CLKOContract Level CompanyStringGeneric Edit50 Allow NULL? 
85G4FCCMFacilities Capital Cost Of MoneyCharacterGeneric Edit10 Allow NULL? 
86G4BURTC Burden Rate Type-CostStringUDC (48S RT)50 Allow NULL? 
87G4CCFLGCost Ceiling FlagCharacterGeneric Edit10 Allow NULL? 
88G4BURTAC Burden Rate Type-Alternate CostStringUDC (48S RT)50 Allow NULL? 
89G4ACFLGAlternate Cost Ceiling FlagCharacterGeneric Edit10 Allow NULL? 
90G4BURTI Burden Rate Type-InvoiceStringUDC (48S RT)50 Allow NULL? 
91G4ICFLGInvoice Ceiling FlagCharacterGeneric Edit10 Allow NULL? 
92G4BURTR Burden Rate Type-RevenueStringUDC (48S RT)50 Allow NULL? 
93G4RCFLGRevenue Ceiling FlagCharacterGeneric Edit10 Allow NULL? 
94G4TOCCType of Contract (Client Type)StringUDC (52G CT)40 Allow NULL? 
95G4TOCSType of Contract (Client/Sub)StringUDC (52G CS)40 Allow NULL? 
96G4PRCOPrime Contract NumberStringGeneric Edit300 Allow NULL? 
97G4OWOROwning OrganizationStringGeneric Edit120 Allow NULL? 
98G4POPFDate - Period of Performance FromDateGeneric Edit60
99G4POPTDate - Period of Performance ToDateGeneric Edit60
100G4EPOPEnforce Period of PerformanceCharacterGeneric Edit10 Allow NULL? 
101G4POTAAmount - PotentialNumericGeneric Edit152 Allow NULL? 
102G4AWCOSTAmount - Awarded CostNumericGeneric Edit152 Allow NULL? 
103G4AWFEAmount - Awarded FeeNumericGeneric Edit152 Allow NULL? 
104G4AWAFEAmount - Awarded Award FeeNumericGeneric Edit152 Allow NULL? 
105G4FUNDCAmount - Funded CostNumericGeneric Edit152 Allow NULL? 
106G4FUNFAmount - Funded FeeNumericGeneric Edit152 Allow NULL? 
107G4FUNAFAmount - Funded Award FeeNumericGeneric Edit152 Allow NULL? 
108G4RICOAmount - Risk CostNumericGeneric Edit152 Allow NULL? 
109G4RIFEAmount - Risk FeeNumericGeneric Edit152 Allow NULL? 
110G4RIAWFAmount - Risk Award FeeNumericGeneric Edit152 Allow NULL? 
111G4RETMXAmount - Retainage MaximumNumericGeneric Edit152 Allow NULL? 
112G4POTAFAmount - Potential ForeignNumericGeneric Edit152 Allow NULL? 
113G4AWCOSTFAmount - Awarded Cost ForeignNumericGeneric Edit152 Allow NULL? 
114G4AWFEFAmount - Awarded Fee ForeignNumericGeneric Edit152 Allow NULL? 
115G4AWAFEFAmount - Awarded Award Fee ForeignNumericGeneric Edit152 Allow NULL? 
116G4FUNDCFAmount - Funded Cost ForeignNumericGeneric Edit152 Allow NULL? 
117G4FUNFFAmount - Funded Fee ForeignNumericGeneric Edit152 Allow NULL? 
118G4FUNAFFAmount - Funded Award Fee ForeignNumericGeneric Edit152 Allow NULL? 
119G4RICOFAmount - Risk Cost ForeignNumericGeneric Edit152 Allow NULL? 
120G4RIFEFAmount - Risk Fee ForeignNumericGeneric Edit152 Allow NULL? 
121G4RIAWFFAmount - Risk Award Fee ForeignNumericGeneric Edit152 Allow NULL? 
122G4RETMXFAmount - Retainage Maximum ForeignNumericGeneric Edit152 Allow NULL? 
123G4BILLSTBilling StatusCharacterUDC (52G BS)10 Allow NULL? 
124G4BILLMETBilling MethodCharacterUDC (52G BM)10 Allow NULL? 
125G4BILLFREBilling Frequency CodeStringUDC (52G BF)30 Allow NULL? 
126G4BILLLIMBilling LimitCharacterUDC (52G LM)10 Allow NULL? 
127G4BILLGRPBilling Group CodeStringUDC (52G BG)30 Allow NULL? 
128G4BILLOVTBill OvertimeCharacterGeneric Edit10 Allow NULL? 
129G4REVSTRevenue StatusCharacterUDC (52G RS)10 Allow NULL? 
130G4REVMETRevenue MethodCharacterUDC (52G RM)10 Allow NULL? 
131G4REVLIMRevenue LimitCharacterUDC (52G LM)10 Allow NULL? 
132G4CAB1Purchasing Contracting OfficerNumericGeneric Edit80 Allow NULL? 
133G4CAB2Accounting Contracting OfficerNumericGeneric Edit80 Allow NULL? 
134G4CAB3Contract Technical ManagerNumericGeneric Edit80 Allow NULL? 
135G4CAB4Admin OfficeNumericGeneric Edit80 Allow NULL? 
136G4CAB5Assignment OfficeNumericGeneric Edit80 Allow NULL? 
137G4CAB6Project Manager 1NumericGeneric Edit80 Allow NULL? 
138G4CAB7Project Manager 2NumericGeneric Edit80 Allow NULL? 
139G4CAB8Project Manager 3NumericGeneric Edit80 Allow NULL? 
140G4CAB9BillerNumericGeneric Edit80 Allow NULL? 
141G4CAB10Contract AdminNumericGeneric Edit80 Allow NULL? 
142G4CAB11Invoice ContactNumericGeneric Edit80 Allow NULL? 
143G4CAB12Contract User Defined Address 12NumericGeneric Edit80 Allow NULL? 
144G4CAB13Contract User Defined Address 13NumericGeneric Edit80 Allow NULL? 
145G4CAB14Contract User Defined Address 14NumericGeneric Edit80 Allow NULL? 
146G4CAB15Contract User Defined Address 15NumericGeneric Edit80 Allow NULL? 
147G4CLCAContract Labor CategoriesCharacterGeneric Edit10 Allow NULL? 
148G4SUBLABSubcontract As LaborCharacterGeneric Edit10 Allow NULL? 
149G4ALLEVAllocation Level FlagCharacterUDC (52G AL)10 Allow NULL? 
150G4ALDESAllocation Destination JobStringGeneric Edit120 Allow NULL? 
151G4ACRNCFACRN Method-Cost/FeeCharacterUDC (52G AM)10 Allow NULL? 
152G4ACRNAFACRN Method-Award FeeCharacterUDC (52G AM)10 Allow NULL? 
153G4GOVPRGovernment Priority RatingStringGeneric Edit100 Allow NULL? 
154G4LOERLevel of Effort RequiredCharacterGeneric Edit10 Allow NULL? 
155G4THRSLOE Target HoursNumericGeneric Edit92 Allow NULL? 
156G4VARPVariance PercentNumericGeneric Edit72 Allow NULL? 
157G4SECOAService Contract ActCharacterGeneric Edit10 Allow NULL? 
158G4DABADavis BaconCharacterGeneric Edit10 Allow NULL? 
159G4CASCOCAS CoveredCharacterGeneric Edit10 Allow NULL? 
160G4TINACOTINA CoveredCharacterGeneric Edit10 Allow NULL? 
161G4FDCLFlow Down Clauses ApplyCharacterGeneric Edit10 Allow NULL? 
162G4QCOPRQuick Close-out ProvisionCharacterGeneric Edit10 Allow NULL? 
163G4KEYPKey PersonnelCharacterGeneric Edit10 Allow NULL? 
164G4VTGRVendor Type Goals RequiredCharacterGeneric Edit10 Allow NULL? 
165G4AI06Contract Category Code 6StringUDC (52 06)30 Allow NULL? 
166G4AI07Contract Category Code 7StringUDC (52 07)30 Allow NULL? 
167G4AI08Contract Category Code 8StringUDC (52 08)30 Allow NULL? 
168G4AI09Contract Category Code 9StringUDC (52 09)30 Allow NULL? 
169G4AI10Contract Category Code 10StringUDC (52 10)30 Allow NULL? 
170G4AI16Contract Category Code 16StringUDC (52G 16)100 Allow NULL? 
171G4AI17Contract Category Code 17StringUDC (52G 17)100 Allow NULL? 
172G4AI18Contract Category Code 18StringUDC (52G 18)100 Allow NULL? 
173G4AI19Contract Category Code 19StringUDC (52G 19)100 Allow NULL? 
174G4AI20Contract Category Code 20StringUDC (52G 20)100 Allow NULL? 
175G4USD5User Date 5DateGeneric Edit60
176G4USD6User Date 6DateGeneric Edit60
177G4USD7User Date 7DateGeneric Edit60
178G4USD8User Date 8DateGeneric Edit60
179G4USD9User Date 9DateGeneric Edit60

TOP920 | 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
13ContractLevel Type
ElementAliasDescriptionSequence
1CLNUContract Level NumberAscending
2CLTTContract Level TypeAscending
14Contract Type Status Cnt Lvl +
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3DSContract StatusAscending
4CLNUContract Level NumberAscending
5CLTTContract Level TypeAscending
15Description
ElementAliasDescriptionSequence
1DL01DescriptionAscending