	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

152 COLUMNS | 7 INDEXES | 920 | 00 | F0006 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
00: Foundation Environment
1	920	F0006	MC	152	7	Business Unit Master	Master Files	09: General Accounting	Business 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 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, MCRP31, MCRP32, MCRP33, MCRP34, MCRP35, MCRP36, MCRP37, MCRP38, MCRP39, MCRP40, MCRP41, MCRP42, MCRP43, MCRP44, MCRP45, MCRP46, MCRP47, MCRP48, MCRP49, MCRP50, MCAN8GCA1, MCAN8GCA2, MCAN8GCA3, MCAN8GCA4, MCAN8GCA5, MCRMCU1, MCDOCO, MCPCTN, MCCLNU, MCBUCA, MCADJENT, MCUAFL FROM F0006

TOP 920 | 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	Generic Edit	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 04	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?
121	MCRP31	Category Code - Business Unit 31	String	UDC (00 31)	10	0	Allow NULL?
122	MCRP32	Category Code - Business Unit 32	String	UDC (00 32)	10	0	Allow NULL?
123	MCRP33	Category Code - Business Unit 33	String	UDC (00 33)	10	0	Allow NULL?
124	MCRP34	Category Code - Business Unit 34	String	UDC (00 34)	10	0	Allow NULL?
125	MCRP35	Category Code - Business Unit 35	String	UDC (00 35)	10	0	Allow NULL?
126	MCRP36	Category Code - Business Unit 36	String	UDC (00 36)	10	0	Allow NULL?
127	MCRP37	Category Code - Business Unit 37	String	UDC (00 37)	10	0	Allow NULL?
128	MCRP38	Category Code - Business Unit 38	String	UDC (00 38)	10	0	Allow NULL?
129	MCRP39	Category Code - Business Unit 39	String	UDC (00 39)	10	0	Allow NULL?
130	MCRP40	Category Code - Business Unit 40	String	UDC (00 40)	10	0	Allow NULL?
131	MCRP41	Category Code - Business Unit 41	String	UDC (00 41)	10	0	Allow NULL?
132	MCRP42	Category Code - Business Unit 42	String	UDC (00 42)	10	0	Allow NULL?
133	MCRP43	Category Code - Business Unit 43	String	UDC (00 43)	10	0	Allow NULL?
134	MCRP44	Category Code - Business Unit 44	String	UDC (00 44)	10	0	Allow NULL?
135	MCRP45	Category Code - Business Unit 45	String	UDC (00 45)	10	0	Allow NULL?
136	MCRP46	Category Code - Business Unit 46	String	UDC (00 46)	10	0	Allow NULL?
137	MCRP47	Category Code - Business Unit 47	String	UDC (00 47)	10	0	Allow NULL?
138	MCRP48	Category Code - Business Unit 48	String	UDC (00 48)	10	0	Allow NULL?
139	MCRP49	Category Code - Business Unit 49	String	UDC (00 49)	10	0	Allow NULL?
140	MCRP50	Category Code - Business Unit 50	String	UDC (00 50)	10	0	Allow NULL?
141	MCAN8GCA1	Address Number1	Numeric	Generic Edit	8	0	Allow NULL?
142	MCAN8GCA2	Address Number2	Numeric	Generic Edit	8	0	Allow NULL?
143	MCAN8GCA3	Address Number3	Numeric	Generic Edit	8	0	Allow NULL?
144	MCAN8GCA4	Address Number4	Numeric	Generic Edit	8	0	Allow NULL?
145	MCAN8GCA5	Address Number5	Numeric	Generic Edit	8	0	Allow NULL?
146	MCRMCU1	Related Business Unit	String	Generic Edit	12	0	Allow NULL?
147	MCDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
148	MCPCTN	Parent Contract Number	Numeric	Generic Edit	8	0	Allow NULL?
149	MCCLNU	Contract Level Number	Numeric	Generic Edit	8	0	Allow NULL?
150	MCBUCA	Burden Category	String	UDC (48S BC)	5	0	Allow NULL?
151	MCADJENT	Adjustment Entry	Character	Generic Edit	1	0	Allow NULL?
152	MCUAFL	FAR UnAllowable Flag	Character	Generic Edit	1	0	Allow NULL?

TOP 920 | 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

Cntrct Inv Funding

Element	Alias	Description	Sequence
1	CLNU	Contract Level Number	Ascending
2	PCTN	Parent Contract Number	Ascending
3	DOCO	Document (Order No Invoice etc.)	Ascending

Description

Element	Alias	Description	Sequence
1	DL01	Description	Ascending

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

152 COLUMNS | 7 INDEXES | 920 | 00 | F0006 TABLE

TOP 920 | 00 | F0006 COLUMNS

TOP 920 | 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

152 COLUMNS | 7 INDEXES | 920 | 00 | F0006 TABLE

TOP920 | 00 | F0006 COLUMNS

TOP920 | 00 | F0006 INDEXES

TOP 920 | 00 | F0006 COLUMNS

TOP 920 | 00 | F0006 INDEXES