	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

418 columns | 812 | DL01

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0006	Business Unit Master	11	MC	DL01	Description	String	Generic Edit	30	0
2	F0006D	Business Unit Alternate Description Master	3	LJ	DL01	Description	String	Generic Edit	30	0
3	F0006S	Date Effective Business Unit Master	13	MC	DL01	Description	String	Generic Edit	30	0
4	F0006Z1	Cost Center Unedited Transaction Table	24	SZ	DL01	Description	String	Generic Edit	30	0
5	F00091	Supplemental Database Data Types	6	T2	DL01	Description	String	Generic Edit	30	0
6	F0012	Automatic Accounting Instructions Master	6	KG	DL01	Description	String	Generic Edit	30	0
7	F0012D	AAI Alternate Description Master	4	LJ	DL01	Description	String	Generic Edit	30	0
8	F0013	Currency Codes	2	CV	DL01	Description	String	Generic Edit	30	0
9	F00142	Due Date Rules	2	L4	DL01	Description	String	Generic Edit	30	0
10	F0019	Generic Message/Rate Types	3	CG	DL01	Description	String	Generic Edit	30	0
11	F00191	Generic Message/Rates	4	CE	DL01	Description	String	Generic Edit	30	0
12	F0025	Ledger Type Master File	2	LH	DL01	Description	String	Generic Edit	30	0
13	F0030	Bank Transit Number Master File	5	AY	DL01	Description	String	Generic Edit	30	0
14	F004201	Prepayment Transaction Table	33	PT	DL01	Description	String	Generic Edit	30	0
15	F00690	Cost Center Types of Data	3	M1	DL01	Description	String	Generic Edit	30	0
16	F007101	Text Processor Header	4	TA	DL01	Description	String	Generic Edit	30	0
17	F1501	Tenant/Lease Master	5	NE	DL01	Description	String	Generic Edit	30	0
18	F15019	Billing Frequency Master	2	NL	DL01	Description	String	Generic Edit	30	0
19	F4096	Sales Flex Accounting	10	FA	DL01	Description	String	Generic Edit	30	0
20	F4303	Log Master	6	PK	DL01	Description	String	Generic Edit	30	0
21	F4303M	Log Models	4	PM	DL01	Description	String	Generic Edit	30	0
22	F5192	Inquiry Columns	3	JC	DL01	Description	String	Generic Edit	30	0
23	F5192D	Supplier Analysis Alternate Language Description	4	JC	DL01	Description	String	Generic Edit	30	0
24	F5193	Inquiry Formats	3	JD	DL01	Description	String	Generic Edit	30	0
25	F5194	Inquiry Paths	3	JE	DL01	Description	String	Generic Edit	30	0
26	F5301	Change Request Master Table	3	DI	DL01	Description	String	Generic Edit	30	0
TOP01: Address Book
27	F01090	Suplemental Data Base - CORE	4	A1	DL01	Description	String	Generic Edit	30	0
TOP03B: Enhanced Accounts Receivable
28	F03B30	Activity Type Master	2	ZI	DL01	Description	String	Generic Edit	30	0
29	F03B42	Deductions Activity Master	2	RD	DL01	Description	String	Generic Edit	30	0
30	F03B50	Receipt Application Algorithm Execution Lists	3	RE	DL01	Description	String	Generic Edit	30	0
TOP04: Accounts Payable
31	F0415	A/P Payments - Check Sequencing	2	KJ	DL01	Description	String	Generic Edit	30	0
32	F04572	A/P Payment Processing - Summary File	24	KK	DL01	Description	String	Generic Edit	30	0
TOP05: Time Accounting and HRM Base
33	F05005	Generic UBE File	5	GF	DL01	Description	String	Generic Edit	30	0
34	F05103	Scale Master	4	AM	DL01	Description	String	Generic Edit	30	0
35	F05104	Competency Master	4	CM	DL01	Description	String	Generic Edit	30	0
36	F05112	Skills/Resources	5	ST	DL01	Description	String	Generic Edit	30	0
37	F05118	Aggregate Competencies	4	AC	DL01	Description	String	Generic Edit	30	0
38	F05119	Competency Levels	4	CL	DL01	Description	String	Generic Edit	30	0
39	F05122	Action Plan	3	AP	DL01	Description	String	Generic Edit	30	0
40	F054101	Employee Personal Profile Information History Table	48	EH	DL01	Description	String	Generic Edit	30	0
41	F054101W	Employee Personal Profile Information Work Table	49	EP	DL01	Description	String	Generic Edit	30	0
42	F0626	Wage Attachment Control File	10	JG	DL01	Description	String	Generic Edit	30	0
TOP05A: OW HR & PR Foundation
43	F060116W	EE Master Request File	225	YA	DL01	Description	String	Generic Edit	30	0
44	F08011	Job Evaluation - Compensable Factors Table	4	JV	DL01	Description	String	Generic Edit	30	0
45	F08096	HR Generic Table Headings	2	H$	DL01	Description	String	Generic Edit	30	0
46	F08396	Key Employee Heading	3	HX	DL01	Description	String	Generic Edit	30	0
47	F08591	Accrued Benefit Formulas	2	H5	DL01	Description	String	Generic Edit	30	0
TOP05T: Time Entry
48	F06904	Automatic Accounting Instructions	16	Y#	DL01	Description	String	Generic Edit	30	0
49	F06916	Piecework Item Master	2	JJ	DL01	Description	String	Generic Edit	30	0
TOP07: Payroll
50	F06136A	Tax Summary (Additional)	15	YZ	DL01	Description	String	Generic Edit	30	0
51	F06166A	Tax Ledger (Additional)	22	YV	DL01	Description	String	Generic Edit	30	0
52	F069026	Payroll Generic Tables	13	Y2	DL01	Description	String	Generic Edit	30	0
53	F07186	Stub Information History Table	5	Y8	DL01	Description	String	Generic Edit	30	0
54	F07352	Stub Information File	5	Y2	DL01	Description	String	Generic Edit	30	0
55	F07354	Report Setup File	5	Y4	DL01	Description	String	Generic Edit	30	0
56	F07355	Pre-Payroll Error File	6	Y5	DL01	Description	String	Generic Edit	30	0
57	F07390	Year-End Rollover Workfile	2	RO	DL01	Description	String	Generic Edit	30	0
58	F074001	New Hire Reporting Workfile - OneWorld Only	42	NH	DL01	Description	String	Generic Edit	30	0
59	F074001R	New Hire Report Setup - OneWorld Only	4	NH	DL01	Description	String	Generic Edit	30	0
60	F07500	Geocoder Report Setup	3	GC	DL01	Description	String	Generic Edit	30	0
61	F07823	Year-End Report Table	7	YF	DL01	Description	String	Generic Edit	30	0
62	F078504	Vertex Geo Code to ADP Code	3	VA	DL01	Description	String	Generic Edit	30	0
63	F078506	ADP Company Code to JDE Company Code	2	YJ	DL01	Description	String	Generic Edit	30	0
64	F8907422	New Hire Detail File - Massachusetts (22)	9	MA	DL01	Description	String	Generic Edit	30	0
65	F8907428	New Hire Detail File - Nebraska(28)	4	NE	DL01	Description	String	Generic Edit	30	0
66	F8907444	New Hire Detail File Transfer - Texas (44)	2	TX	DL01	Description	String	Generic Edit	30	0
TOP08: Human Resources
67	F0800602	Job Competency Master	2	JC	DL01	Description	String	Generic Edit	30	0
68	F08090	HRM Supplemental Data Types	5	JX	DL01	Description	String	Generic Edit	30	0
69	F082002	Grade/Step Progression Header File	2	YV	DL01	Description	String	Generic Edit	30	0
70	F083301	Benefit Statement	2	BS	DL01	Description	String	Generic Edit	30	0
71	F083305	Mail Merge Header/Detail	24	MM	DL01	Description	String	Generic Edit	30	0
72	F08391	User Program Parameters	16	B0	DL01	Description	String	Generic Edit	30	0
73	F085520	Available Plans and Plan Options by Employee History Table	4	PH	DL01	Description	String	Generic Edit	30	0
74	F085520W	Available Plans and Plan Options by Employee Work Table	4	AP	DL01	Description	String	Generic Edit	30	0
75	F085530W	Employee Current/Pending Elections Work Table	4	CP	DL01	Description	String	Generic Edit	30	0
TOP08A: eRecruit
76	F08471	Job Posting Competencies	4	PC	DL01	Description	String	Generic Edit	30	0
TOP08AD: ADP Integration
77	F051372	ADP Employee Job Master Information	10	AD	DL01	Description	String	Generic Edit	30	0
78	F05138	ADP - Pay Cycle Review Control	2	PC	DL01	Description	String	Generic Edit	30	0
TOP08B: Benefits Administration
79	F083202	Plan Additional Options	3	B5	DL01	Description	String	Generic Edit	30	0
80	F08320D	Plan Master Tag Table	13	PD	DL01	Description	String	Generic Edit	30	0
81	F08320WF	Available Plans and Plan Options by Employee Work Table	4	BV	DL01	Description	String	Generic Edit	30	0
82	F08320X	Plan Name Conversion	2	PX	DL01	Description	String	Generic Edit	30	0
83	F08330WF	Employee Current/Pending Elections Work Table	4	BR	DL01	Description	String	Generic Edit	30	0
84	F08380WF	Batch Enrollment Work File	10	BE	DL01	Description	String	Generic Edit	30	0
85	F08381WF	Recalculate Plan Option Costs	8	RC	DL01	Description	String	Generic Edit	30	0
86	F08390	Eligibility	2	B9	DL01	Description	String	Generic Edit	30	0
87	F08395	Enrollment Date Terms	2	B8	DL01	Description	String	Generic Edit	30	0
88	F08593	Retirement Rule Definition	2	H7	DL01	Description	String	Generic Edit	30	0
TOP08H: Health and Safety
89	F086401	Injury/Illness Report Header Information	3	RH	DL01	Description	String	Generic Edit	30	0
TOP08LM: HCM Learning Management Integr
90	F0805	External System Roles	3	ER	DL01	Description	String	Generic Edit	30	0
TOP08P: Position Control
91	F08001	Job information	4	JM	DL01	Description	String	Generic Edit	30	0
92	F08101	Position Master	4	HP	DL01	Description	String	Generic Edit	30	0
93	F08101P	Purge - Position Master	4	HP	DL01	Description	String	Generic Edit	30	0
TOP08R: Recruitment Management - (Appl. Track. & Req.)
94	F08102	Requisition Information	4	HN	DL01	Description	String	Generic Edit	30	0
TOP08U: OW HR US
95	F08361	Plan Control Group - NDT	2	NA	DL01	Description	String	Generic Edit	30	0
96	F08365	NDT - Criteria Heading	4	HX	DL01	Description	String	Generic Edit	30	0
97	F08994	COBRA Payment History	14	H1	DL01	Description	String	Generic Edit	30	0
98	F08995	COBRA Notification History	9	H2	DL01	Description	String	Generic Edit	30	0
TOP08W: Wage and Salary
99	F08201	Salary Review Workfile	2	HR	DL01	Description	String	Generic Edit	30	0
100	F08820	Increase Guideline Master Table	4	YT	DL01	Description	String	Generic Edit	30	0
101	F08830WF	Compensation Root Work Table	28	YN	DL01	Description	String	Generic Edit	30	0
TOP09: General Accounting
102	F0050A	Structure Definition File	2	MA	DL01	Description	String	Generic Edit	30	0
103	F0901	Account Master	7	GM	DL01	Description	String	Generic Edit	30	0
104	F0901D	Account Master - Alternate Description	2	LK	DL01	Description	String	Generic Edit	30	0
105	F0907	Chart of Accounts Format	4	GY	DL01	Description	String	Generic Edit	30	0
106	F0909	Chart of Accounts - Reference File	3	AC	DL01	Description	String	Generic Edit	30	0
107	F092181	Online Consolidation Detail File	7	LR	DL01	Description	String	Generic Edit	30	0
108	F09523	Cash Forecast Reporting Structures	6	FS	DL01	Description	String	Generic Edit	30	0
109	F09626	Auto Reconciliation Rules Setup	3	GR	DL01	Description	String	Generic Edit	30	0
110	F09627	Auto Reconciliation Group Setup	2	GG	DL01	Description	String	Generic Edit	30	0
111	F09UI009	Trial Balance Generic Work File - OneWorld ONLY	7	GB	DL01	Description	String	Generic Edit	30	0
112	F09UI016	Account Balance Compare Exceptions	15	GW	DL01	Description	String	Generic Edit	30	0
113	F09UI017	Cash Forecast Detail	16	FW	DL01	Description	String	Generic Edit	30	0
TOP09E: Expense Reimbursment
114	F09E108	Policy Edit Rules	2	PR	DL01	Description	String	Generic Edit	30	0
115	F09E114	Exchange Rate Identifiers	3	ER	DL01	Description	String	Generic Edit	30	0
116	F20104	Expense Report Group Profiles	2	GP	DL01	Description	String	Generic Edit	30	0
TOP10: Financial Reporting
117	F0050B	Business Unit Structure Build File	2	MA	DL01	Description	String	Generic Edit	30	0
118	F10005	User Defined Code Control File	4	GO	DL01	Description	String	Generic Edit	30	0
119	F1002	Multi-Site Consolidation Transfer File	10	GQ	DL01	Description	String	Generic Edit	30	0
120	F1002Z1	Unedited MSC Interoperability Table	19	SZ	DL01	Description	String	Generic Edit	30	0
121	F100901	Level of Detail	2	FR	DL01	Description	String	Generic Edit	30	0
122	F10430	Multi-Site Consolidation - Account Structure	7	CF	DL01	Description	String	Generic Edit	30	0
123	F10430A	Account Structure Definition	2	CG	DL01	Description	String	Generic Edit	30	0
124	F10471	Elimination Rules (OW)	13	ER	DL01	Description	String	Generic Edit	30	0
125	F10909	Object/Subsidiary Control Table	4	G1	DL01	Description	String	Generic Edit	30	0
126	F10UI001	Account Structure Build Workfile	8	CF	DL01	Description	String	Generic Edit	30	0
127	F10UI002	Dynamically Created Business Units	6	BU	DL01	Description	String	Generic Edit	30	0
128	F10UI003	Dynamically Created Accounts	7	AC	DL01	Description	String	Generic Edit	30	0
129	F10UI006	MSC - F1002 Elimination Work File	9	GE	DL01	Description	String	Generic Edit	30	0
130	F10UI007	Business Unit Structure Search Form Work Table	2	MC	DL01	Description	String	Generic Edit	30	0
TOP12: Fixed Assets
131	F1201	Asset Master File	13	FA	DL01	Description	String	Generic Edit	30	0
132	F1201D	Asset Master - Alternate Description	3	LJ	DL01	Description	String	Generic Edit	30	0
133	F1201P	Asset Master Purge Table	13	FA	DL01	Description	String	Generic Edit	30	0
134	F1201Z1	Unedited Asset Master Transactions	26	FA	DL01	Description	String	Generic Edit	30	0
135	F1208	Units of Production Schedule Master File	3	FP	DL01	Description	String	Generic Edit	30	0
136	F12090	Asset Mgt Supplemental Database Types	3	F2	DL01	Description	String	Generic Edit	30	0
137	F12854	Depreciation Period Spread Rules	2	LZ	DL01	Description	String	Generic Edit	30	0
138	F12911ER	Post G/L to FA Exceptions Work File	12	GL	DL01	Description	String	Generic Edit	30	0
TOP13: Plant/Equipment Management
139	F13411	PM Projections	17	RX	DL01	Description	String	Generic Edit	30	0
140	F3111IGS	WO Parts for IGS Integration	6	IG	DL01	Description	String	Generic Edit	30	0
TOP13C: Condition-Base Maintenance
141	F1310	Condition-Based Alerts	13	CA	DL01	Description	String	Generic Edit	30	0
142	F1310Z1	Unedited Condition-Based Alerts	27	CB	DL01	Description	String	Generic Edit	30	0
TOP13E: Equipment Cost Analysis
143	F1380	Equipment Analysis Groups	4	EA	DL01	Description	String	Generic Edit	30	0
TOP14: Modeling - Planning & Budgeting
144	F1401	Budget Patterns	2	BP	DL01	Description	String	Generic Edit	30	0
145	F1403	Forecast Basis	4	BD	DL01	Description	String	Generic Edit	30	0
146	F1404	Forecast Results - Header	4	BY	DL01	Description	String	Generic Edit	30	0
147	F14041	Forecast Results - Detail	4	BZ	DL01	Description	String	Generic Edit	30	0
148	F1406	Forecast Growth Patterns	2	FB	DL01	Description	String	Generic Edit	30	0
TOP15: Property Management
149	F15012	Tenant E.P. Class Master	6	NS	DL01	Description	String	Generic Edit	30	0
150	F150120	Tenant Exclusion Header	2	NW	DL01	Description	String	Generic Edit	30	0
151	F150120D	Tenant Exclusion - Alternate Description	3	NW	DL01	Description	String	Generic Edit	30	0
152	F150122	Share Factor Denominator Header	2	NY	DL01	Description	String	Generic Edit	30	0
153	F150122D	Share Factor Denominator - Alternate Description	3	NY	DL01	Description	String	Generic Edit	30	0
154	F15012B	Tenant E.P. Class Master	6	NS	DL01	Description	String	Generic Edit	30	0
155	F15015	Minimum rent/recoveries Master	6	NQ	DL01	Description	String	Generic Edit	30	0
156	F15015B	Min/Max Rents And Recoveries Master	15	NQ	DL01	Description	String	Generic Edit	30	0
157	F15019D	Billing Frequency - Alternate Description	3	NL	DL01	Description	String	Generic Edit	30	0
158	F1501B	Lease Master Header File	7	NE	DL01	Description	String	Generic Edit	30	0
159	F1501BD	Lease Master Header - Alternate Description	4	NE	DL01	Description	String	Generic Edit	30	0
160	F1503	Log Standards Master	9	NB	DL01	Description	String	Generic Edit	30	0
161	F1506	Floor Master File	5	OP	DL01	Description	String	Generic Edit	30	0
162	F1506D	Floor Master - Alternate Description	6	OP	DL01	Description	String	Generic Edit	30	0
163	F1507	Unit Master File	5	NH	DL01	Description	String	Generic Edit	30	0
164	F1507D	Unit Master - Alternate Description	4	NH	DL01	Description	String	Generic Edit	30	0
165	F1511	Tenant/Lease Billings Detail	11	NJ	DL01	Description	String	Generic Edit	30	0
166	F15110B	Expense Participation Class Account	9	OB	DL01	Description	String	Generic Edit	30	0
167	F1511B	Tenant/Lease Billings Detail Master	11	NJ	DL01	Description	String	Generic Edit	30	0
168	F1511H	Tenant/Lease Billings Detail History	11	N#	DL01	Description	String	Generic Edit	30	0
169	F1511HB	Tenant/Lease Billings Detail History	11	NC	DL01	Description	String	Generic Edit	30	0
170	F1512	Billing Code Extension	3	NA	DL01	Description	String	Generic Edit	30	0
171	F1512D	Billing Code Extension - Alternate Description	4	NA	DL01	Description	String	Generic Edit	30	0
172	F1514	Area Master	7	NW	DL01	Description	String	Generic Edit	30	0
173	F1514D	Area Master - Alternate Description	9	NW	DL01	Description	String	Generic Edit	30	0
174	F1521	Log Detail Master	8	NB	DL01	Description	String	Generic Edit	30	0
175	F1521D	Log Detail Master - Alternate Description	3	NB	DL01	Description	String	Generic Edit	30	0
176	F1523	Log Standard Master	5	OG	DL01	Description	String	Generic Edit	30	0
177	F1523D	Log Standards Master - Alternate Description	3	OG	DL01	Description	String	Generic Edit	30	0
178	F1531	Expense Participation Class Adjustment	6	OM	DL01	Description	String	Generic Edit	30	0
179	F1531D	Expense Participation Class Adj. - Alternate Description	4	OM	DL01	Description	String	Generic Edit	30	0
180	F1538	WF - Expence Participation Register	57	NZ	DL01	Description	String	Generic Edit	30	0
181	F1538B	EP Billing Register Work File	59	NZ	DL01	Description	String	Generic Edit	30	0
182	F1540	Sales Report Control File	20	NR	DL01	Description	String	Generic Edit	30	0
183	F1540B	Sales Report Control File	29	NR	DL01	Description	String	Generic Edit	30	0
184	F1544	Sales Analysis Control File	2	OB	DL01	Description	String	Generic Edit	30	0
185	F1544B	Sales Analysis Control File	2	OB	DL01	Description	String	Generic Edit	30	0
186	F1544BD	Sales Analysis Control - Alternate Description	3	OB	DL01	Description	String	Generic Edit	30	0
187	F1550	Escalation Index Master	4	NV	DL01	Description	String	Generic Edit	30	0
188	F157011	Lease Option Type Header	2	NA	DL01	Description	String	Generic Edit	30	0
189	F157011D	Lease Option Type Header - Alternate Description	3	NA	DL01	Description	String	Generic Edit	30	0
190	F15702	Legal Clause Space Detail	9	NF	DL01	Description	String	Generic Edit	30	0
191	F15702D	Legal Clause Space Detail - Alternate Description	6	NF	DL01	Description	String	Generic Edit	30	0
192	F159071	Market/Potential/Renewal Rent Master	10	NY	DL01	Description	String	Generic Edit	30	0
193	F159071D	Market/Potential/Renewal Rent Master - Alternate Description	6	NY	DL01	Description	String	Generic Edit	30	0
TOP15L: Adv Real Estate Forecasting
194	F15L1001	AREF Building Constants Models	2	BM	DL01	Description	String	Generic Edit	30	0
195	F15L106	AREF Recurring Bill Code Rules Header	4	RB	DL01	Description	String	Generic Edit	30	0
196	F15L107	AREF Recycle Assumption Rules	4	EF	DL01	Description	String	Generic Edit	30	0
197	F15L110	AREF Account Status	34	AS	DL01	Description	String	Generic Edit	30	0
198	F15L111	AREF Account Status Detail	21	AD	DL01	Description	String	Generic Edit	30	0
199	F15L38	AREF EP Billing Register	57	NZ	DL01	Description	String	Generic Edit	30	0
TOP16: Profit Management (EPS)
200	F1603	Cost Analyzer View Structure	2	CV	DL01	Description	String	Generic Edit	30	0
201	F1610	Cost Calculation Definitions	2	CD	DL01	Description	String	Generic Edit	30	0
202	F1620	Cost Object Types	2	CT	DL01	Description	String	Generic Edit	30	0
203	F1630	Driver Definitions	2	CD	DL01	Description	String	Generic Edit	30	0
204	F1640	Activity Master File	2	AM	DL01	Description	String	Generic Edit	30	0
205	F1642	Rate Master Header File	10	RH	DL01	Description	String	Generic Edit	30	0
206	F16UI001	Enabled Tables by Application work file	5	CA	DL01	Description	String	Generic Edit	30	0
TOP17: Customer Service Management
207	F1720	Contract Header	12	CH	DL01	Description	String	Generic Edit	30	0
208	F1721	Contract Detail	11	CD	DL01	Description	String	Generic Edit	30	0
209	F1724	Service Contract Coverage	2	CT	DL01	Description	String	Generic Edit	30	0
210	F1729	Service Contract Service Package	2	SP	DL01	Description	String	Generic Edit	30	0
211	F4801Z2	Warranty Claim/Supplier Recovery processing	30	WS	DL01	Description	String	Generic Edit	30	0
TOP17C: Call Management
212	F1755	Customer Call Master	132	ZA	DL01	Description	String	Generic Edit	30	0
213	F1757	Task Master	10	ZA	DL01	Description	String	Generic Edit	30	0
TOP30: Product Data Management
214	F3017	Kanban Size Calculation Definition	2	KS	DL01	Description	String	Generic Edit	30	0
215	F3018	Kanban Size Calculation Parameters	3	KP	DL01	Description	String	Generic Edit	30	0
TOP31: Shop Floor Control
216	F31UI802	Accumulate Amounts by Account	11	WG	DL01	Description	String	Generic Edit	30	0
217	F31UI803	Work File for Summarizing Journal Entries	11	SG	DL01	Description	String	Generic Edit	30	0
218	F4801S	Purge - Work Order Master file	11	WA	DL01	Description	String	Generic Edit	30	0
219	F4801Z1	Outbound Work Order Header	30	SY	DL01	Description	String	Generic Edit	30	0
TOP31B: Blend Management
220	F31B01	Winery Master	3	WI	DL01	Description	String	Generic Edit	30	0
221	F31B07AG	EUR Accounting Groups	2	AG	DL01	Description	String	Generic Edit	30	0
222	F31B115W	Trial Blend Input Lot Workfile	102	LW	DL01	Description	String	Generic Edit	30	0
223	F31B21	Cost Groups Header	2	CG	DL01	Description	String	Generic Edit	30	0
224	F31B32	Wine Status	2	WS	DL01	Description	String	Generic Edit	30	0
225	F31B50	Blend ID Definition	7	BD	DL01	Description	String	Generic Edit	30	0
TOP31P: Engineer To Order
226	F31P10	Project Quote Header	7	PQ	DL01	Description	String	Generic Edit	30	0
227	F31P11	Project Quote Detail	7	QP	DL01	Description	String	Generic Edit	30	0
228	F31PUI01	Scheduling Error Report	5	SE	DL01	Description	String	Generic Edit	30	0
TOP32: Configuration Management
229	F32UI002	External Data Item Work File	5	WY	DL01	Description	String	Generic Edit	30	0
TOP34A: Advanced Planning & Scheduling
230	F34A110	Work Center Resource Table	4	N0	DL01	Description	String	Generic Edit	30	0
231	F34A120	Routing Master Resource Table	24	N0	DL01	Description	String	Generic Edit	30	0
232	F34A30	Order Status Definition Table	3	N0	DL01	Description	String	Generic Edit	30	0
233	F34A80	Resource Master Table	1	N0	DL01	Description	String	Generic Edit	30	0
TOP38: Agreement Management
234	F38010	Agreement Master	3	DN	DL01	Description	String	Generic Edit	30	0
TOP40: Inventory/OP Base
235	F40051	Return Material Authorization	8	RD	DL01	Description	String	Generic Edit	30	0
236	F4090	Distribution/Manufacturing - AAI Record Type	2	MK	DL01	Description	String	Generic Edit	30	0
237	F4092	Group Code Key Definition Table	3	GP	DL01	Description	String	Generic Edit	30	0
238	F40UI00T	Tax Work File	14	PN	DL01	Description	String	Generic Edit	30	0
239	F41015	Item Duplication Work File	4	BA	DL01	Description	String	Generic Edit	30	0
240	F41500	Tank Master File	3	PP	DL01	Description	String	Generic Edit	30	0
TOP40G: Grower Management
241	F40G003	Harvest Period Patterns	6	HP	DL01	Description	String	Generic Edit	30	0
TOP40S: Supply Chain Self Service
242	F4947SW	Self-Service Shipment Tracking Work File	6	SW	DL01	Description	String	Generic Edit	30	0
TOP41: Inventory Management
243	F4101H	Item Hierarchy (Web)	5	IH	DL01	Description	String	Generic Edit	30	0
244	F41090	Item Supplemental Data Types	4	T1	DL01	Description	String	Generic Edit	30	0
TOP41B: Bulk Stock Management
245	F41506	Meter Master	5	PM	DL01	Description	String	Generic Edit	30	0
246	F41509	Four-Point Analysis Maintenance File	8	PG	DL01	Description	String	Generic Edit	30	0
TOP43: Procurement
247	F40910	Commitment Integrity Report Work File	14	P#	DL01	Description	String	Generic Edit	30	0
248	F43008	Approval Levels	3	AP	DL01	Description	String	Generic Edit	30	0
249	F4305	Log Master	12	PL	DL01	Description	String	Generic Edit	30	0
250	F43092Z1	Receipt Routing Unedited Transaction Table	52	SZ	DL01	Description	String	Generic Edit	30	0
251	F4316	Purchase Order Multiple Account File	11	P3	DL01	Description	String	Generic Edit	30	0
252	F4340	Purchase Rebate Master File	4	RD	DL01	Description	String	Generic Edit	30	0
TOP43E: Requisition Self Service
253	F43E16	Requisition Multiple Account File	12	P3	DL01	Description	String	Generic Edit	30	0
TOP44H: Homebuilder Management
254	F4450	Lot Proceed Header (World)	37	JD	DL01	Description	String	Generic Edit	30	0
255	F4451	Lot Proceed Detail (World)	11	JF	DL01	Description	String	Generic Edit	30	0
256	F4452	Plan Master (World)	3	JA	DL01	Description	String	Generic Edit	30	0
257	F4453	Lot Master (World)	9	JB	DL01	Description	String	Generic Edit	30	0
258	F4454	Vendor Assignment (World)	3	JG	DL01	Description	String	Generic Edit	30	0
259	F4456	Lot Proceed Entry (World)	37	JI	DL01	Description	String	Generic Edit	30	0
260	F4457	Takeoff File (World)	17	JJ	DL01	Description	String	Generic Edit	30	0
261	F4458	Takeoff (World)	17	JK	DL01	Description	String	Generic Edit	30	0
262	F4461	Option Master (World)	17	JN	DL01	Description	String	Generic Edit	30	0
263	F44H101	Community Phase Master	5	CM	DL01	Description	String	Generic Edit	30	0
264	F44H101Z	HB Community Master Unedited Transaction File	18	SZ	DL01	Description	String	Generic Edit	30	0
265	F44H301	Plan Master	12	PM	DL01	Description	String	Generic Edit	30	0
266	F44H401	Option Master	7	OC	DL01	Description	String	Generic Edit	30	0
267	F44H4011	Option by Community	8	OC	DL01	Description	String	Generic Edit	30	0
268	F44H401W	Option Master Work File	8	OW	DL01	Description	String	Generic Edit	30	0
269	F44H602	Takeoff Master File	19	TO	DL01	Description	String	Generic Edit	30	0
270	F44H602H	Takeoff History File	20	TH	DL01	Description	String	Generic Edit	30	0
271	F44H790	Construction Milestones	5	HM	DL01	Description	String	Generic Edit	30	0
TOP45: Advanced Pricing
272	F4550	Basket Master Header	2	BH	DL01	Description	String	Generic Edit	30	0
TOP47: Electronic Commerce
273	F470473	EDI Invoice Detail Charges	14	S7	DL01	Description	String	Generic Edit	30	0
274	F470561	EDI Payment Order Bank N and A - Outbound	35	D2	DL01	Description	String	Generic Edit	30	0
275	F470561W	EDI Payment Order Bank N and A - Work	35	D2	DL01	Description	String	Generic Edit	30	0
276	F470562	EDI Payment Order Vendor N and A - Outbound	35	D4	DL01	Description	String	Generic Edit	30	0
277	F470562W	EDI Payment Order Vendor N and A - Work	35	D4	DL01	Description	String	Generic Edit	30	0
278	F470563	EDI Payment Order Payee N and A - Outbound	35	D5	DL01	Description	String	Generic Edit	30	0
279	F470563W	EDI Payment Order Payee N and A - Work	35	D5	DL01	Description	String	Generic Edit	30	0
TOP48: Work Order Processing
280	F48002	Work Order Record Types File	2	WF	DL01	Description	String	Generic Edit	30	0
281	F4801	Work Order Master File	11	WA	DL01	Description	String	Generic Edit	30	0
282	F48090	WO Supplemental Data Types	4	W7	DL01	Description	String	Generic Edit	30	0
283	F48UI001	X4801 Master Business Function Workfile	14	WA	DL01	Description	String	Generic Edit	30	0
TOP48S: Service Billing
284	F4848	Sequence/Summarization Data Item Table	3	SQ	DL01	Description	String	Generic Edit	30	0
285	F4860	Component Table Master	2	AF	DL01	Description	String	Generic Edit	30	0
286	F48S58	Invoice Print Version Cross Reference Table	6	F7	DL01	Description	String	Generic Edit	30	0
287	F48S80	Segment Definition	4	SD	DL01	Description	String	Generic Edit	30	0
288	F48S83	Pool Definition	6	PD	DL01	Description	String	Generic Edit	30	0
289	F48S95	Billing AAI Information	20	WV	DL01	Description	String	Generic Edit	30	0
TOP49: Transportation Management
290	F49010	Vehicle Master (Conversion from World File)	4	VM	DL01	Description	String	Generic Edit	30	0
291	F49025	Connected Vehicles (Conversion from World File)	6	CV	DL01	Description	String	Generic Edit	30	0
292	F4930	Vehicle Master	3	VM	DL01	Description	String	Generic Edit	30	0
293	F4931	Vehicle Type	2	VG	DL01	Description	String	Generic Edit	30	0
294	F4935	Connected Vehicle Header	4	VH	DL01	Description	String	Generic Edit	30	0
295	F49595	Document Print - Document Summary	13	DK	DL01	Description	String	Generic Edit	30	0
296	F49695	Document Register	11	DR	DL01	Description	String	Generic Edit	30	0
TOP51: Job Costing
297	F5109	Chart Type Master	4	GJ	DL01	Description	String	Generic Edit	30	0
298	F51092	Multiple Cost Code Setup	6	MC	DL01	Description	String	Generic Edit	30	0
TOP52: Contract Billing
299	F5201	Contract Master File	6	G4	DL01	Description	String	Generic Edit	30	0
300	F5202	Contract Billing Line Detail	7	G6	DL01	Description	String	Generic Edit	30	0
301	F5204	Retainage Rules Information	2	GX	DL01	Description	String	Generic Edit	30	0
302	F52131	Rate Code Definition Information	2	GR	DL01	Description	String	Generic Edit	30	0
303	F5216	Milestone/Progress Billing Information	7	A6	DL01	Description	String	Generic Edit	30	0
TOP53: Change Management
304	F53001	World F53001 Specs	3	DU	DL01	Description	String	Generic Edit	30	0
305	F53005	Job Specific UDC's Master Table	4	D1	DL01	Description	String	Generic Edit	30	0
306	F5301B	Change Request Master Table	4	DI	DL01	Description	String	Generic Edit	30	0
307	F5301BZ1	Change Request Master Table Workfile	8	DI	DL01	Description	String	Generic Edit	30	0
308	F5302	F5302 World Specs	7	DK	DL01	Description	String	Generic Edit	30	0
309	F53101	Change Request Detail Status Update Table	3	DU	DL01	Description	String	Generic Edit	30	0
310	F5311	Change Request Details Table	7	DK	DL01	Description	String	Generic Edit	30	0
311	F5311Z1	Change Request Details Table Workfile	9	DK	DL01	Description	String	Generic Edit	30	0
312	F5314	Planned Change Order Master Table	4	D2	DL01	Description	String	Generic Edit	30	0
313	F5315	Change Order Master Table	4	D3	DL01	Description	String	Generic Edit	30	0
TOP55: Reserved for Clients
314	F74H1050	Invoicing Workfile Header - New	16	IH	DL01	Description	String	Generic Edit	30	0
315	F74H1052	Tax Summary Work Table - New	9	TS	DL01	Description	String	Generic Edit	30	0
316	F74H1056	Invoicing Additional References	3	AR	DL01	Description	String	Generic Edit	30	0
317	F74T205	Checks Collected	10	CC	DL01	Description	String	Generic Edit	30	0
318	F74TL004	Trial Balance Temp File	8	TB	DL01	Description	String	Generic Edit	30	0
319	F74T531	Customer Ledger Tranaction File	15	CT	DL01	Description	String	Generic Edit	30	0
320	F74T532	Supplier Ledger Transaction File	15	SL	DL01	Description	String	Generic Edit	30	0
321	F74T550	General Ledger Work File - Turkish	10	DK	DL01	Description	String	Generic Edit	30	0
322	F74T100	Check Additional Table	3	CA	DL01	Description	String	Generic Edit	30	0
TOP74: EMEA Localization
323	F7400002	Legal Document Types - COMM - 00	2	LD	DL01	Description	String	Generic Edit	30	0
324	F7400004	Legal Document Issue Places - COMM - 00	2	IP	DL01	Description	String	Generic Edit	30	0
325	F74030	Bank ID - Italy	12	BA	DL01	Description	String	Generic Edit	30	0
326	F74030H	Dutch-Payments Bank Information	6	NL	DL01	Description	String	Generic Edit	30	0
327	F74092	IVA Balances History - Italy	5	HB	DL01	Description	String	Generic Edit	30	0
328	F740931	IVA Summary Report Header File - Work File-Italy	2	HD	DL01	Description	String	Generic Edit	30	0
329	F7420034	Price Adjustment (Print Info) - COMM - 42	8	PI	DL01	Description	String	Generic Edit	30	0
330	F7430021	Print Templates Definition for Legal Documents - COMM - 03B	2	DT	DL01	Description	String	Generic Edit	30	0
331	F744102	Intrastat Commodity Code Additional Information	3	IB	DL01	Description	String	Generic Edit	30	0
332	F74UI91	WF - Account Detail - EMEA - 74	10	AD	DL01	Description	String	Generic Edit	30	0
TOP74H: Hungary
333	F74H1002	VAT Table Build Header	2	VB	DL01	Description	String	Generic Edit	30	0
334	F74H1003	VAT Final Declaration Header	2	VB	DL01	Description	String	Generic Edit	30	0
TOP74U: United Kingdom Localizations
335	F74U03BT	Lease Master Alternative UOM Tag File - 15	10	PF	DL01	Description	String	Generic Edit	30	0
336	F74U4051	Header - CIS Monthly Return - UK - 04	3	HM	DL01	Description	String	Generic Edit	30	0
TOP75J: Japan - Reporting System Only
337	F75J04SA	Hankin Hante Split Amounts - 04	3	J4	DL01	Description	String	Generic Edit	30	0
TOP75T: Taiwan
338	F75T008	GUI/VAT Tax Type Mapping - 75T	4	TM	DL01	Description	String	Generic Edit	30	0
339	F75T012	GUI/VAT GL Account Mapping - 75T	5	GL	DL01	Description	String	Generic Edit	30	0
TOP76A: Argentina
340	F76A0209	Header and Footer Invoice/ShipmentNote History WF - ARG - 76A	14	HF	DL01	Description	String	Generic Edit	30	0
341	F76A020P	Header/Footer Inv./ShipmentNote History WF Purge - AR - 76A	14	HF	DL01	Description	String	Generic Edit	30	0
342	F76A0219	Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A	27	DL	DL01	Description	String	Generic Edit	30	0
343	F76A021P	Detail Lines Inv./ShipmentNote History WF Purge - ARG - 76A	27	DL	DL01	Description	String	Generic Edit	30	0
344	F76A22	Credit Invoice Detail - F76A22 - ARG - 03B - 76A	13	ID	DL01	Description	String	Generic Edit	30	0
345	F76A22P	Credit Invoice Detail Purge - ARG - 03B - 76A	13	ID	DL01	Description	String	Generic Edit	30	0
346	F76A7101	Batch for Remittance - ARG - 03B - 76A	4	TA	DL01	Description	String	Generic Edit	30	0
347	F76A82	A/P Payment Control Group File - ARG - 04 - 76A	19	C6	DL01	Description	String	Generic Edit	30	0
348	F76AUI20	Header and Footer Invoice/ShipmentNote Workfile - ARG - - 00	14	HF	DL01	Description	String	Generic Edit	30	0
349	F76AUI21	Detail Lines Invoice/ShipmentNote Workfile - ARG - 00 - 00	27	DL	DL01	Description	String	Generic Edit	30	0
350	F76AUI22	WF - Legal Reports Errors - ARG - 00	10	WF	DL01	Description	String	Generic Edit	30	0
351	F76AUI82	Draft - Drafts Work File - ARG - 03B - 03B	19	WF	DL01	Description	String	Generic Edit	30	0
TOP76B: Brazil - Reporting System Only
352	F76B006	IN86-Work Table for Business Unit - 09	4	BB	DL01	Description	String	Generic Edit	30	0
353	F76B0401	Tax Code - 04	3	CT	DL01	Description	String	Generic Edit	30	0
354	F76B471	Dynamic Formater Layouts - 03B	2	DL	DL01	Description	String	Generic Edit	30	0
355	F76B476	Dynamic Formater Bank Attributes Cross Reference - 03B	6	BX	DL01	Description	String	Generic Edit	30	0
356	F76B8200	IN86-Work Table for Fixed Assets - 12	4	FA	DL01	Description	String	Generic Edit	30	0
357	F76B901	IN86- Work Table for Account Master - 09	11	BA	DL01	Description	String	Generic Edit	30	0
TOP76C: Colombia
358	F76CI1	Tax Parameters - COL - 76C	7	PI	DL01	Description	String	Generic Edit	30	0
359	F76CI2	Economic Activity - COL - 76C	6	AE	DL01	Description	String	Generic Edit	30	0
360	F76CUI01	Account Master - Work File - COL - 76C	8	GM	DL01	Description	String	Generic Edit	30	0
361	F76CUI03	Account Cat. Code - Work File - COL - 76C	8	GM	DL01	Description	String	Generic Edit	30	0
TOP76E: Ecuador
362	F76E4020	Withholding Certificate Information w/ SRI - EC - 04	7	CR	DL01	Description	String	Generic Edit	30	0
TOP76H: Chile
363	F76H005	Legal Document Type - CHI - 00 - 76H	2	LC	DL01	Description	String	Generic Edit	30	0
364	F76H3B30	Print Template Definition for Legal Documents - CHI - - 76H	2	PT	DL01	Description	String	Generic Edit	30	0
365	F76H3B31	Legal Document Header (Print Info) - CHI - 03B - 76H	17	PI	DL01	Description	String	Generic Edit	30	0
366	F76H3B35	Price Adjustment (Print Info) - CHI - 03B - 76H	8	PI	DL01	Description	String	Generic Edit	30	0
367	F76H6001	Actual Cost Process Header - CHI - 41 - 76H	5	PH	DL01	Description	String	Generic Edit	30	0
TOP77: Payroll (Canadian)
368	F77101	Canadian Year-End Print	7	JA	DL01	Description	String	Generic Edit	30	0
369	F77173	ROE Summary History Work File	8	JF	DL01	Description	String	Generic Edit	30	0
TOP87: JDE Internal
370	F87SAR	SAR/Object Cross Reference	2	WS	DL01	Description	String	Generic Edit	30	0
TOP89: Conversion Programs
371	F074001W	SUI/New Hire Client loader for F074001R	4	NH	DL01	Description	String	Generic Edit	30	0
372	F99302	Processing Options Text Table	2	PO	DL01	Description	String	Generic Edit	30	0
373	F993022	Processing Options Error Table	2	PO	DL01	Description	String	Generic Edit	30	0
374	F993023	Translated Processing Options Text Table	2	PO	DL01	Description	String	Generic Edit	30	0
TOP90CB: CRM Sales Force Automation
375	F90CB01D	Lead_Item_Hierarchy Table	4	LI	DL01	Description	String	Generic Edit	30	0
TOPD3N: dcLINK (data collection) - DSI
376	FD3N4950	dcLINK Delivery Confirmation Work File	15	DC	DL01	Description	String	Generic Edit	30	0
TOPH79: CS - Forecasting
377	F7910	Translations Suggestions	1	TS	DL01	Description	String	Generic Edit	30	0
TOPH90: ONEWORLD TOOLS
378	F90701	Interoperability Event Definition	14	ED	DL01	Description	String	Generic Edit	30	0
379	F90701N	Interoperability Event Definition - Net Change	16	ED	DL01	Description	String	Generic Edit	30	0
380	F90702	Interoperability Subscriber Enrollment	10	ES	DL01	Description	String	Generic Edit	30	0
381	F98887	Composer Industry and Geograhpic Locations Xref	4	PC	DL01	Description	String	Generic Edit	30	0
TOPH91: Design Tools
382	F9801NEW	Employee Information - New Version	10	AA	DL01	Description	String	Generic Edit	30	0
383	F9801OLD	Employee Information - Old Version	9	AA	DL01	Description	String	Generic Edit	30	0
384	F98610	Debug Information	4	DB	DL01	Description	String	Generic Edit	30	0
385	F98TMPL	Templates	1	TT	DL01	Description	String	Generic Edit	30	0
TOPH92: Interactive Engine/OL
386	F00942	Object Path Master File	2	EM	DL01	Description	String	Generic Edit	30	0
387	F98231D	OMW Transfer Activity Rule Director - Detail	7	TD	DL01	Description	String	Generic Edit	30	0
388	F98231H	OMW Transfer Activity Rule Director - Header	4	TR	DL01	Description	String	Generic Edit	30	0
389	F9882	Checkout Log Table	6	CL	DL01	Description	String	Generic Edit	30	0
390	F9885	Install Package Header	2	IP	DL01	Description	String	Generic Edit	30	0
391	F9890	Version Master File	2	VF	DL01	Description	String	Generic Edit	30	0
TOPH95: Tech Resources/Applications
392	F0004	User Defined Code Types	3	DT	DL01	Description	String	Generic Edit	30	0
393	F0004D	User Defined Codes - Alternate Language Descriptions	4	DT	DL01	Description	String	Generic Edit	30	0
394	F0005	User Defined Codes	4	DR	DL01	Description	String	Generic Edit	30	0
395	F0005D	User Defined Codes - Alternate Language Descriptions	5	DR	DL01	Description	String	Generic Edit	30	0
396	F0094	Library List Master File	2	LM	DL01	Description	String	Generic Edit	30	0
397	F95201	BSFN Test Harness Files Table	3	BT	DL01	Description	String	Generic Edit	30	0
398	F95310	Table Sharing - Table Group Definition	2	TS	DL01	Description	String	Generic Edit	30	0
399	F95320	Table Sharing - Set-ID Definition	3	TS	DL01	Description	String	Generic Edit	30	0
400	F980021	Cross Reference Field Relationships	6	SJ	DL01	Description	String	Generic Edit	30	0
401	F9880	Environment Master - Needed for JDE.h	3	EM	DL01	Description	String	Generic Edit	30	0
TOPH96: Deployment
402	F00945	Release Master	2	RM	DL01	Description	String	Generic Edit	30	0
403	F96400	Sar grouping file for ESUs	16	SG	DL01	Description	String	Generic Edit	30	0
404	F9650	Machine Master	4	MM	DL01	Description	String	Generic Edit	30	0
405	F9654	Deployment Locations Definition	2	DL	DL01	Description	String	Generic Edit	30	0
406	F9670	Software Update Master Table	5	SU	DL01	Description	String	Generic Edit	30	0
407	F9840	Installation Plan Master Table	2	PM	DL01	Description	String	Generic Edit	30	0
408	F984072	Table and Index Creation Log	14	CL	DL01	Description	String	Generic Edit	30	0
409	F9841	Simple Installation Planner	2	SP	DL01	Description	String	Generic Edit	30	0
410	F9848	Content Update Revision	2	CU	DL01	Description	String	Generic Edit	30	0
411	F98881	Specification Merge Logging File	12	SM	DL01	Description	String	Generic Edit	30	0
TOPH96P: Product Packaging Tools
412	F964001	Control Table groupings file for SU	7	CT	DL01	Description	String	Generic Edit	30	0
TOPH96U: Upgrade
413	F964725	Special Instructions UDC Description	5	SI	DL01	Description	String	Generic Edit	30	0
414	F9649	Language_OMW groupings header	2	LG	DL01	Description	String	Generic Edit	30	0
415	F96491	Language_OMW groupings detail	3	LG	DL01	Description	String	Generic Edit	30	0
416	F96710	Impact Analysis Results	8	RA	DL01	Description	String	Generic Edit	30	0
417	F968901	TC Performance Estimation Header Table	5	EH	DL01	Description	String	Generic Edit	30	0
TOPH99: Product Version Control
418	F9900003	Software Update Object Verification Work Table	7	SU	DL01	Description	String	Generic Edit	30	0

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

418 columns | 812 | DL01