	Table	Prefix	Description
1	F4211	SD	Sales Order Detail File
2	F0101	AB	Address Book Master
3	F4101	IM	Item Master
4	F0911	GL	Account Ledger
5	F4311	PD	Purchase Order Detail File
6	F9671	SD	Software Update Detail Table
7	F4102	IB	Item Branch File
8	F0411	RP	Accounts Payable Ledger
9	F0006	MC	Business Unit Master
10	F41021	LI	Item Location File

	Table	Prefix	Description
1	F0011W	IC	F0011W - WF - Batch To Detail
2	F76AUI46	WF	CERG A/R -Work File - ARG - 03B - 76A
3	F4211	SD	Sales Order Detail File
4	F4101	IM	Item Master
5	F0101	AB	Address Book Master
6	F0911	GL	Account Ledger
7	F4102	IB	Item Branch File
8	F03B11	RP	Customer Ledger
9	F4111	IL	Item Ledger File
10	F4311	PD	Purchase Order Detail File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0006	MC	Business Unit Master
5	F0411	RP	Accounts Payable Ledger
6	F4211	SD	Sales Order Detail File
7	F42119	SD	Sales Order History File
8	F03012	AI	Customer Master by Line of Business
9	F0902	GB	Account Balances
10	F4801	WA	Work Order Master File

120 COLUMNS | 5 INDEXES | 812 | 00 | F0006 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
00: Foundation Environment
1	812	F0006	MC	120	5	Business Unit Master	Master Files	00: Foundation Environment	AS400 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

TOP 812 | 00 | F0006 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	MCMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
2	MCSTYL	Business Unit Type	String	UDC (00 MC)	2	0	Allow NULL?
3	MCDC	Description - Compressed	String	Generic Edit	40	0	Allow NULL?
4	MCLDM	Level of Detail - Business Unit	Character	UDC (H00 LD)	1	0	Allow NULL?
5	MCCO	Company	String	Generic Edit	5	0	Allow NULL?
6	MCAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
7	MCAN8O	Address Number - Job A/R	Numeric	Generic Edit	8	0	Allow NULL?
8	MCCNTY	County	String	UDC (00 CT)	3	0	Allow NULL?
9	MCADDS	State	String	UDC (00 S)	3	0	Allow NULL?
10	MCFMOD	Model Accounts and Consolidation Flag	Character	UDC (H09 MD)	1	0	Allow NULL?
11	MCDL01	Description	String	Generic Edit	30	0	Allow NULL?
12	MCDL02	Description 02	String	Generic Edit	30	0	Allow NULL?
13	MCDL03	Description 03	String	Generic Edit	30	0	Allow NULL?
14	MCDL04	Description 02	String	Generic Edit	30	0	Allow NULL?
15	MCRP01	Division	String	UDC (00 01)	3	0	Allow NULL?
16	MCRP02	Region	String	UDC (00 02)	3	0	Allow NULL?
17	MCRP03	Group	String	UDC (00 03)	3	0	Allow NULL?
18	MCRP04	Branch Office	String	UDC (00 04)	3	0	Allow NULL?
19	MCRP05	Department Type	String	UDC (00 05)	3	0	Allow NULL?
20	MCRP06	Person Responsible	String	UDC (00 06)	3	0	Allow NULL?
21	MCRP07	Line of Business	String	UDC (00 07)	3	0	Allow NULL?
22	MCRP08	Category Code - Business Unit 08	String	UDC (00 08)	3	0	Allow NULL?
23	MCRP09	Category Code - Business Unit 09	String	UDC (00 09)	3	0	Allow NULL?
24	MCRP10	Category Code - Business Unit 10	String	UDC (00 10)	3	0	Allow NULL?
25	MCRP11	Category Code - Business Unit 11	String	UDC (00 11)	3	0	Allow NULL?
26	MCRP12	Category Code - Business Unit 12	String	UDC (00 12)	3	0	Allow NULL?
27	MCRP13	Category Code - Business Unit 13	String	UDC (00 13)	3	0	Allow NULL?
28	MCRP14	Category Code - Business Unit 14	String	UDC (00 14)	3	0	Allow NULL?
29	MCRP15	Category Code - Business Unit 15	String	UDC (00 15)	3	0	Allow NULL?
30	MCRP16	Category Code - Business Unit 16	String	UDC (00 16)	3	0	Allow NULL?
31	MCRP17	Category Code - Business Unit 17	String	UDC (00 17)	3	0	Allow NULL?
32	MCRP18	Category Code - Business Unit 18	String	UDC (00 18)	3	0	Allow NULL?
33	MCRP19	Category Code - Business Unit 19	String	UDC (00 19)	3	0	Allow NULL?
34	MCRP20	Category Code - Business Unit 20	String	UDC (00 20)	3	0	Allow NULL?
35	MCRP21	Category Code - Business Unit 21	String	UDC (00 21)	10	0	Allow NULL?
36	MCRP22	Category Code - Business Unit 22	String	UDC (00 22)	10	0	Allow NULL?
37	MCRP23	Category Code - Business Unit 23	String	UDC (00 23)	10	0	Allow NULL?
38	MCRP24	Category Code - Business Unit 24	String	UDC (00 24)	10	0	Allow NULL?
39	MCRP25	Category Code - Business Unit 25	String	UDC (00 25)	10	0	Allow NULL?
40	MCRP26	Category Code - Business Unit 26	String	UDC (00 26)	10	0	Allow NULL?
41	MCRP27	Category Code - Business Unit 27	String	UDC (00 27)	10	0	Allow NULL?
42	MCRP28	Category Code - Business Unit 28	String	UDC (00 28)	10	0	Allow NULL?
43	MCRP29	Category Code - Business Unit 29	String	UDC (00 29)	10	0	Allow NULL?
44	MCRP30	Category Code - Business Unit 30	String	UDC (00 30)	10	0	Allow NULL?
45	MCTA	Tax Area	String	UDC	10	0	Allow NULL?
46	MCTXJS	Tax Entity	Numeric	Generic Edit	8	0	Allow NULL?
47	MCTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
48	MCEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
49	MCTC01	Tax/Deduction Codes 01	String	Generic Edit	4	0	Allow NULL?
50	MCTC02	Tax/Deduction Codes 02	String	Generic Edit	4	0	Allow NULL?
51	MCTC03	Tax/Deduction Codes 03	String	Generic Edit	4	0	Allow NULL?
52	MCTC04	Tax/Deduction Codes 04	String	Generic Edit	4	0	Allow NULL?
53	MCTC05	Tax/Deduction Codes 05	String	Generic Edit	4	0	Allow NULL?
54	MCTC06	Tax/Deduction Codes 06	String	Generic Edit	4	0	Allow NULL?
55	MCTC07	Tax/Deduction Codes 07	String	Generic Edit	4	0	Allow NULL?
56	MCTC08	Tax/Deduction Codes 08	String	Generic Edit	4	0	Allow NULL?
57	MCTC09	Tax/Deduction Codes 09	String	Generic Edit	4	0	Allow NULL?
58	MCTC10	Tax/Deduction Codes 10	String	Generic Edit	4	0	Allow NULL?
59	MCND01	Tax Distributable/Non-Distr. Code 01	Character	UDC (H00 ND)	1	0	Allow NULL?
60	MCND02	Tax Distributable/Non-Distr. Code 02	Character	UDC (H00 ND)	1	0	Allow NULL?
61	MCND03	Tax Distributable/Non-Distr. Code 03	Character	UDC (H00 ND)	1	0	Allow NULL?
62	MCND04	Tax Distributable/Non-Distr. Code 04	Character	UDC (H00 ND)	1	0	Allow NULL?
63	MCND05	Tax Distributable/Non-Distr. Code 05	Character	UDC (H00 ND)	1	0	Allow NULL?
64	MCND06	Tax Distributable/Non-Distr. Code 06	Character	UDC (H00 ND)	1	0	Allow NULL?
65	MCND07	Tax Distributable/Non-Distr. Code 07	Character	UDC (H00 ND)	1	0	Allow NULL?
66	MCND08	Tax Distributable/Non-Distr. Code 08	Character	UDC (H00 ND)	1	0	Allow NULL?
67	MCND09	Tax Distributable/Non-Distr. Code 09	Character	UDC (H00 ND)	1	0	Allow NULL?
68	MCND10	Tax Distributable/Non-Distr. Code 10	Character	UDC (H00 ND)	1	0	Allow NULL?
69	MCCC01	Tax or Deduction Compute Status Code 01	Character	Generic Edit	1	0	Allow NULL?
70	MCCC02	Tax or Deduction Compute Status Code 02	Character	Generic Edit	1	0	Allow NULL?
71	MCCC03	Tax or Deduction Compute Status Code 03	Character	Generic Edit	1	0	Allow NULL?
72	MCCC04	Tax or Deduction Compute Status Code 04	Character	Generic Edit	1	0	Allow NULL?
73	MCCC05	Tax or Deduction Compute Status Code 05	Character	Generic Edit	1	0	Allow NULL?
74	MCCC06	Tax or Deduction Compute Status Code 06	Character	Generic Edit	1	0	Allow NULL?
75	MCCC07	Tax or Deduction Compute Status Code 07	Character	Generic Edit	1	0	Allow NULL?
76	MCCC08	Tax or Deduction Compute Status Code 08	Character	Generic Edit	1	0	Allow NULL?
77	MCCC09	Tax or Deduction Compute Status Code 09	Character	Generic Edit	1	0	Allow NULL?
78	MCCC10	Tax or Deduction Compute Status Code 10	Character	Generic Edit	1	0	Allow NULL?
79	MCPECC	Posting Edit - Business Unit	Character	UDC (00 PF)	1	0	Allow NULL?
80	MCALS	Allocation Summarization Method	Character	UDC (H00 AL)	1	0	Allow NULL?
81	MCISS	Invoice/Stmt Summarization Method	Character	UDC (H00 IS)	1	0	Allow NULL?
82	MCGLBA	G/L Bank Account	String	Generic Edit	8	0	Allow NULL?
83	MCALCL	Allocation Level	String	Generic Edit	2	0	Allow NULL?
84	MCLMTH	Labor Distribution Method	Character	UDC (07 LT)	1	0	Allow NULL?
85	MCLF	Labor Distribution Multiplier	Numeric	Generic Edit	5	4	Allow NULL?
86	MCOBJ1	Object Account - Labor Account	String	Generic Edit	6	0	Allow NULL?
87	MCOBJ2	Object Account - Premium Account	String	Generic Edit	6	0	Allow NULL?
88	MCOBJ3	Object Account - Burden	String	Generic Edit	6	0	Allow NULL?
89	MCSUB1	Subsidiary - Burden Cost Code	String	Generic Edit	8	0	Allow NULL?
90	MCTOU	Units - Total	Numeric	Generic Edit	15	2	Allow NULL?
91	MCSBLI	Subledger Inactive Code	Character	UDC (00 SI)	1	0	Allow NULL?
92	MCANPA	Supervisor	Numeric	Generic Edit	8	0	Allow NULL?
93	MCCT	Contract Type	String	UDC (51 CT)	4	0	Allow NULL?
94	MCCERT	Certified Job	Character	UDC (H00 CE)	1	0	Allow NULL?
95	MCMCUS	Business Unit - Subsequent	String	Generic Edit	12	0	Allow NULL?
96	MCBTYP	Billing Type - Business Unit	Character	Generic Edit	1	0	Allow NULL?
97	MCPC	Percent Complete	Numeric	Generic Edit	5	0	Allow NULL?
98	MCPCA	Percent Complete - Aggregate Detail	Numeric	Generic Edit	5	2	Allow NULL?
99	MCPCC	Amount - Cost to Complete (obsolete)	Numeric	Generic Edit	15	2	Allow NULL?
100	MCINTA	Interest Computation Code - A/R	String	Generic Edit	4	0	Allow NULL?
101	MCINTL	Interest Comp - Late Revenue	String	Generic Edit	4	0	Allow NULL?
102	MCD1J	Date - Planned Start	Date	Generic Edit	6	0
103	MCD2J	Date - Actual Start	Date	Generic Edit	6	0
104	MCD3J	Date - Planned Complete	Date	Generic Edit	6	0
105	MCD4J	Date - Actual Complete	Date	Generic Edit	6	0
106	MCD5J	Date - Other 5	Date	Generic Edit	6	0
107	MCD6J	Date - Other 6	Date	Generic Edit	6	0
108	MCFPDJ	Date - Final Payment (Julian)	Date	Generic Edit	6	0
109	MCCAC	Amount - Cost at Completion	Numeric	Generic Edit	15	2	Allow NULL?
110	MCPAC	Amount - Profit at Completion	Numeric	Generic Edit	15	2	Allow NULL?
111	MCEEO	Equal Employment Opportunity	Character	UDC (H00 EE)	1	0	Allow NULL?
112	MCERC	Equipment Rate Code	String	UDC (00 RC)	2	0	Allow NULL?
113	MCUSER	User ID	String	Generic Edit	10	0	Allow NULL?
114	MCPID	Program ID	String	Generic Edit	10	0	Allow NULL?
115	MCUPMJ	Date - Updated	Date	Generic Edit	6	0
116	MCJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
117	MCUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
118	MCBPTP	Branch Type	String	Generic Edit	15	0	Allow NULL?
119	MCAPSB	APS Business Unit	Character	Generic Edit	1	0	Allow NULL?
120	MCTSBU	Target Business Unit	String	Generic Edit	12	0	Allow NULL?

TOP 812 | 00 | F0006 INDEXES

Number

Description

Cost Center (Primary/Unique)

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending

Company

Element	Alias	Description	Sequence
1	CO	Company	Ascending

Type Company

Element	Alias	Description	Sequence
1	STYL	Business Unit Type	Ascending
2	CO	Company	Ascending

Type Model

Element	Alias	Description	Sequence
1	STYL	Business Unit Type	Ascending
2	FMOD	Model Accounts and Consolidation Flag	Ascending

Address Number

Element	Alias	Description	Sequence
1	AN8	Address Number	Descending

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

120 COLUMNS | 5 INDEXES | 812 | 00 | F0006 TABLE

TOP 812 | 00 | F0006 COLUMNS

TOP 812 | 00 | F0006 INDEXES

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

120 COLUMNS | 5 INDEXES | 812 | 00 | F0006 TABLE

TOP812 | 00 | F0006 COLUMNS

TOP812 | 00 | F0006 INDEXES

TOP 812 | 00 | F0006 COLUMNS

TOP 812 | 00 | F0006 INDEXES