JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides | 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
3F0911GLAccount Ledger
4F4101IMItem Master
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
10F07831YBEmployee State/Local Control Table

812: Top 10 requests

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

120 COLUMNS | 5 INDEXES | Print definition?812 | 00 | F0006 TABLE

00: Foundation Environment
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F0006MC1205Business Unit MasterMaster Files00: Foundation EnvironmentAS400 Coexistence Tables
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 MCMCU, MCSTYL, MCDC, MCLDM, MCCO, MCAN8, MCAN8O, MCCNTY, MCADDS, MCFMOD, MCDL01, MCDL02, MCDL03, MCDL04, MCRP01, MCRP02, MCRP03, MCRP04, MCRP05, MCRP06, MCRP07, MCRP08, MCRP09, MCRP10, MCRP11, MCRP12, MCRP13, MCRP14, MCRP15, MCRP16, MCRP17, MCRP18, MCRP19, MCRP20, MCRP21, MCRP22, MCRP23, MCRP24, MCRP25, MCRP26, MCRP27, MCRP28, MCRP29, MCRP30, MCTA, MCTXJS, MCTXA1, MCEXR1, MCTC01, MCTC02, MCTC03, MCTC04, MCTC05, MCTC06, MCTC07, MCTC08, MCTC09, MCTC10, MCND01, MCND02, MCND03, MCND04, MCND05, MCND06, MCND07, MCND08, MCND09, MCND10, MCCC01, MCCC02, MCCC03, MCCC04, MCCC05, MCCC06, MCCC07, MCCC08, MCCC09, MCCC10, MCPECC, MCALS, MCISS, MCGLBA, MCALCL, MCLMTH, MCLF, MCOBJ1, MCOBJ2, MCOBJ3, MCSUB1, MCTOU, MCSBLI, MCANPA, MCCT, MCCERT, MCMCUS, MCBTYP, MCPC, MCPCA, MCPCC, MCINTA, MCINTL, MCD1J, MCD2J, MCD3J, MCD4J, MCD5J, MCD6J, MCFPDJ, MCCAC, MCPAC, MCEEO, MCERC, MCUSER, MCPID, MCUPMJ, MCJOBN, MCUPMT, MCBPTP, MCAPSB, MCTSBU FROM F0006

TOP812 | 00 | F0006 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1MCMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
2MCSTYLBusiness Unit TypeStringUDC (00 MC)20 Allow NULL? 
3MCDCDescription - CompressedStringGeneric Edit400 Allow NULL? 
4MCLDMLevel of Detail - Business UnitCharacterUDC (H00 LD)10 Allow NULL? 
5MCCOCompanyStringGeneric Edit50 Allow NULL? 
6MCAN8Address NumberNumericUDC80 Allow NULL? 
7MCAN8OAddress Number - Job A/RNumericGeneric Edit80 Allow NULL? 
8MCCNTYCountyStringUDC (00 CT)30 Allow NULL? 
9MCADDSStateStringUDC (00 S)30 Allow NULL? 
10MCFMODModel Accounts and Consolidation FlagCharacterUDC (H09 MD)10 Allow NULL? 
11MCDL01DescriptionStringGeneric Edit300 Allow NULL? 
12MCDL02Description 02StringGeneric Edit300 Allow NULL? 
13MCDL03Description 03StringGeneric Edit300 Allow NULL? 
14MCDL04Description 02StringGeneric Edit300 Allow NULL? 
15MCRP01DivisionStringUDC (00 01)30 Allow NULL? 
16MCRP02RegionStringUDC (00 02)30 Allow NULL? 
17MCRP03GroupStringUDC (00 03)30 Allow NULL? 
18MCRP04Branch OfficeStringUDC (00 04)30 Allow NULL? 
19MCRP05Department TypeStringUDC (00 05)30 Allow NULL? 
20MCRP06Person ResponsibleStringUDC (00 06)30 Allow NULL? 
21MCRP07Line of BusinessStringUDC (00 07)30 Allow NULL? 
22MCRP08Category Code - Business Unit 08StringUDC (00 08)30 Allow NULL? 
23MCRP09Category Code - Business Unit 09StringUDC (00 09)30 Allow NULL? 
24MCRP10Category Code - Business Unit 10StringUDC (00 10)30 Allow NULL? 
25MCRP11Category Code - Business Unit 11StringUDC (00 11)30 Allow NULL? 
26MCRP12Category Code - Business Unit 12StringUDC (00 12)30 Allow NULL? 
27MCRP13Category Code - Business Unit 13StringUDC (00 13)30 Allow NULL? 
28MCRP14Category Code - Business Unit 14StringUDC (00 14)30 Allow NULL? 
29MCRP15Category Code - Business Unit 15StringUDC (00 15)30 Allow NULL? 
30MCRP16Category Code - Business Unit 16StringUDC (00 16)30 Allow NULL? 
31MCRP17Category Code - Business Unit 17StringUDC (00 17)30 Allow NULL? 
32MCRP18Category Code - Business Unit 18StringUDC (00 18)30 Allow NULL? 
33MCRP19Category Code - Business Unit 19StringUDC (00 19)30 Allow NULL? 
34MCRP20Category Code - Business Unit 20StringUDC (00 20)30 Allow NULL? 
35MCRP21Category Code - Business Unit 21StringUDC (00 21)100 Allow NULL? 
36MCRP22Category Code - Business Unit 22StringUDC (00 22)100 Allow NULL? 
37MCRP23Category Code - Business Unit 23StringUDC (00 23)100 Allow NULL? 
38MCRP24Category Code - Business Unit 24StringUDC (00 24)100 Allow NULL? 
39MCRP25Category Code - Business Unit 25StringUDC (00 25)100 Allow NULL? 
40MCRP26Category Code - Business Unit 26StringUDC (00 26)100 Allow NULL? 
41MCRP27Category Code - Business Unit 27StringUDC (00 27)100 Allow NULL? 
42MCRP28Category Code - Business Unit 28StringUDC (00 28)100 Allow NULL? 
43MCRP29Category Code - Business Unit 29StringUDC (00 29)100 Allow NULL? 
44MCRP30Category Code - Business Unit 30StringUDC (00 30)100 Allow NULL? 
45MCTATax AreaStringUDC100 Allow NULL? 
46MCTXJSTax EntityNumericGeneric Edit80 Allow NULL? 
47MCTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
48MCEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
49MCTC01Tax/Deduction Codes 01StringGeneric Edit40 Allow NULL? 
50MCTC02Tax/Deduction Codes 02StringGeneric Edit40 Allow NULL? 
51MCTC03Tax/Deduction Codes 03StringGeneric Edit40 Allow NULL? 
52MCTC04Tax/Deduction Codes 04StringGeneric Edit40 Allow NULL? 
53MCTC05Tax/Deduction Codes 05StringGeneric Edit40 Allow NULL? 
54MCTC06Tax/Deduction Codes 06StringGeneric Edit40 Allow NULL? 
55MCTC07Tax/Deduction Codes 07StringGeneric Edit40 Allow NULL? 
56MCTC08Tax/Deduction Codes 08StringGeneric Edit40 Allow NULL? 
57MCTC09Tax/Deduction Codes 09StringGeneric Edit40 Allow NULL? 
58MCTC10Tax/Deduction Codes 10StringGeneric Edit40 Allow NULL? 
59MCND01Tax Distributable/Non-Distr. Code 01CharacterUDC (H00 ND)10 Allow NULL? 
60MCND02Tax Distributable/Non-Distr. Code 02CharacterUDC (H00 ND)10 Allow NULL? 
61MCND03Tax Distributable/Non-Distr. Code 03CharacterUDC (H00 ND)10 Allow NULL? 
62MCND04Tax Distributable/Non-Distr. Code 04CharacterUDC (H00 ND)10 Allow NULL? 
63MCND05Tax Distributable/Non-Distr. Code 05CharacterUDC (H00 ND)10 Allow NULL? 
64MCND06Tax Distributable/Non-Distr. Code 06CharacterUDC (H00 ND)10 Allow NULL? 
65MCND07Tax Distributable/Non-Distr. Code 07CharacterUDC (H00 ND)10 Allow NULL? 
66MCND08Tax Distributable/Non-Distr. Code 08CharacterUDC (H00 ND)10 Allow NULL? 
67MCND09Tax Distributable/Non-Distr. Code 09CharacterUDC (H00 ND)10 Allow NULL? 
68MCND10Tax Distributable/Non-Distr. Code 10CharacterUDC (H00 ND)10 Allow NULL? 
69MCCC01Tax or Deduction Compute Status Code 01CharacterGeneric Edit10 Allow NULL? 
70MCCC02Tax or Deduction Compute Status Code 02CharacterGeneric Edit10 Allow NULL? 
71MCCC03Tax or Deduction Compute Status Code 03CharacterGeneric Edit10 Allow NULL? 
72MCCC04Tax or Deduction Compute Status Code 04CharacterGeneric Edit10 Allow NULL? 
73MCCC05Tax or Deduction Compute Status Code 05CharacterGeneric Edit10 Allow NULL? 
74MCCC06Tax or Deduction Compute Status Code 06CharacterGeneric Edit10 Allow NULL? 
75MCCC07Tax or Deduction Compute Status Code 07CharacterGeneric Edit10 Allow NULL? 
76MCCC08Tax or Deduction Compute Status Code 08CharacterGeneric Edit10 Allow NULL? 
77MCCC09Tax or Deduction Compute Status Code 09CharacterGeneric Edit10 Allow NULL? 
78MCCC10Tax or Deduction Compute Status Code 10CharacterGeneric Edit10 Allow NULL? 
79MCPECCPosting Edit - Business UnitCharacterUDC (00 PF)10 Allow NULL? 
80MCALSAllocation Summarization MethodCharacterUDC (H00 AL)10 Allow NULL? 
81MCISSInvoice/Stmt Summarization MethodCharacterUDC (H00 IS)10 Allow NULL? 
82MCGLBAG/L Bank AccountStringGeneric Edit80 Allow NULL? 
83MCALCLAllocation LevelStringGeneric Edit20 Allow NULL? 
84MCLMTHLabor Distribution MethodCharacterUDC (07 LT)10 Allow NULL? 
85MCLFLabor Distribution MultiplierNumericGeneric Edit54 Allow NULL? 
86MCOBJ1Object Account - Labor AccountStringGeneric Edit60 Allow NULL? 
87MCOBJ2Object Account - Premium AccountStringGeneric Edit60 Allow NULL? 
88MCOBJ3Object Account - BurdenStringGeneric Edit60 Allow NULL? 
89MCSUB1Subsidiary - Burden Cost CodeStringGeneric Edit80 Allow NULL? 
90MCTOUUnits - TotalNumericGeneric Edit152 Allow NULL? 
91MCSBLISubledger Inactive CodeCharacterUDC (00 SI)10 Allow NULL? 
92MCANPASupervisorNumericGeneric Edit80 Allow NULL? 
93MCCTContract TypeStringUDC (51 CT)40 Allow NULL? 
94MCCERTCertified JobCharacterUDC (H00 CE)10 Allow NULL? 
95MCMCUSBusiness Unit - SubsequentStringGeneric Edit120 Allow NULL? 
96MCBTYPBilling Type - Business UnitCharacterGeneric Edit10 Allow NULL? 
97MCPCPercent CompleteNumericGeneric Edit50 Allow NULL? 
98MCPCAPercent Complete - Aggregate DetailNumericGeneric Edit52 Allow NULL? 
99MCPCCAmount - Cost to Complete (obsolete)NumericGeneric Edit152 Allow NULL? 
100MCINTAInterest Computation Code - A/RStringGeneric Edit40 Allow NULL? 
101MCINTLInterest Comp - Late RevenueStringGeneric Edit40 Allow NULL? 
102MCD1JDate - Planned StartDateGeneric Edit60
103MCD2JDate - Actual StartDateGeneric Edit60
104MCD3JDate - Planned CompleteDateGeneric Edit60
105MCD4JDate - Actual CompleteDateGeneric Edit60
106MCD5JDate - Other 5DateGeneric Edit60
107MCD6JDate - Other 6DateGeneric Edit60
108MCFPDJDate - Final Payment (Julian)DateGeneric Edit60
109MCCACAmount - Cost at CompletionNumericGeneric Edit152 Allow NULL? 
110MCPACAmount - Profit at CompletionNumericGeneric Edit152 Allow NULL? 
111MCEEOEqual Employment OpportunityCharacterUDC (H00 EE)10 Allow NULL? 
112MCERCEquipment Rate CodeStringUDC (00 RC)20 Allow NULL? 
113MCUSERUser IDStringGeneric Edit100 Allow NULL? 
114MCPIDProgram IDStringGeneric Edit100 Allow NULL? 
115MCUPMJDate - UpdatedDateGeneric Edit60
116MCJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
117MCUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
118MCBPTPBranch TypeStringGeneric Edit150 Allow NULL? 
119MCAPSBAPS Business UnitCharacterGeneric Edit10 Allow NULL? 
120MCTSBUTarget Business UnitStringGeneric Edit120 Allow NULL? 

TOP812 | 00 | F0006 INDEXES

NumberDescription
1Cost Center (Primary/Unique)
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2Company
ElementAliasDescriptionSequence
1COCompanyAscending
4Type Company
ElementAliasDescriptionSequence
1STYLBusiness Unit TypeAscending
2COCompanyAscending
5Type Model
ElementAliasDescriptionSequence
1STYLBusiness Unit TypeAscending
2FMODModel Accounts and Consolidation FlagAscending
6Address Number
ElementAliasDescriptionSequence
1AN8Address NumberDescending