	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

143 columns | 920 | CTID

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0040Z1	Error Message Log Table	1	ZB	CTID	Computer ID	String	Generic Edit	15	0
2	F0041Z1	Transaction Control File	1	ZF	CTID	Computer ID	String	Generic Edit	15	0
3	F00UI391	Generated Document Work Table	1	GW	CTID	Computer ID	String	Generic Edit	15	0
4	F00UI392	Text Substitution Work Table	2	GW	CTID	Computer ID	String	Generic Edit	15	0
5	F00UI393	Bookmark Work Table	1	GW	CTID	Computer ID	String	Generic Edit	15	0
TOP03B: Enhanced Accounts Receivable
6	F03BUI05	Auto Receipts Batch Workfile	1	R5	CTID	Computer ID	String	Generic Edit	15	0
TOP04: Accounts Payable
7	F046UI01	T5018 Tax Workfile	6	CV	CTID	Computer ID	String	Generic Edit	15	0
8	F04UI006	1099 Worktable User Index	6	G1	CTID	Computer ID	String	Generic Edit	15	0
TOP09: General Accounting
9	F0902Z1	Account Balances - Batch File	9	GB	CTID	Computer ID	String	Generic Edit	15	0
10	F09UI008	Global Business Unit Change	1	GM	CTID	Computer ID	String	Generic Edit	15	0
11	F09UI009	Trial Balance Generic Work File - OneWorld ONLY	2	GB	CTID	Computer ID	String	Generic Edit	15	0
TOP15L: Adv Real Estate Forecasting
12	F15L302	AREF Prior Gross Billings	1	PG	CTID	Computer ID	String	Generic Edit	15	0
TOP16: Profit Management (EPS)
13	F16UI001	Enabled Tables by Application work file	1	CA	CTID	Computer ID	String	Generic Edit	15	0
TOP30: Product Data Management
14	F30UI008	Bill of Material Comparison Work File	2	IJ	CTID	Computer ID	String	Generic Edit	15	0
TOP31: Shop Floor Control
15	F31UI002	User Index - Variances	21	IG	CTID	Computer ID	String	Generic Edit	15	0
16	F31UI006	Line Scheduling Workbench - Work File	1	LS	CTID	Computer ID	String	Generic Edit	15	0
17	F31UI427	Labor Variance User Index	2	W1	CTID	Computer ID	String	Generic Edit	15	0
18	F31UI802	Accumulate Amounts by Account	14	WG	CTID	Computer ID	String	Generic Edit	15	0
19	F31UI803	Work File for Summarizing Journal Entries	14	SG	CTID	Computer ID	String	Generic Edit	15	0
20	F31UI804	Exception Report Work FIle	12	WR	CTID	Computer ID	String	Generic Edit	15	0
TOP31B: Blend Management
21	F31B33DC	Dependency Chain Cache Structure	2	DT	CTID	Computer ID	String	Generic Edit	15	0
TOP33: Capacity Planning
22	F33UI001	Shop Floor Control Routing Instructions	24	WL	CTID	Computer ID	String	Generic Edit	15	0
TOP34: Requirements Planning
23	F34UI003	MPS Time Series User Index	60	M8	CTID	Computer ID	String	Generic Edit	15	0
24	F34UI004	MPS Net Change User Index	2	M8	CTID	Computer ID	String	Generic Edit	15	0
25	F34UI005	MRP Orders/Requirements User Index-Process Item	2	F5	CTID	Computer ID	String	Generic Edit	15	0
26	F34UI006	MRP Co/By Product Net Quantity User Index	2	W6	CTID	Computer ID	String	Generic Edit	15	0
TOP35: Enterprise Facility Planning
27	F35UI001	MPS/MRP Planning - Multiple Plant User Index	2	MA	CTID	Computer ID	String	Generic Edit	15	0
TOP40: Inventory/OP Base
28	F30UI001	Component Locators Work File	1	WF	CTID	Computer ID	String	Generic Edit	15	0
29	F30UI002	Bill of Material Structure Analysis Work File	4	IX	CTID	Computer ID	String	Generic Edit	15	0
30	F30UI004	Bill of Material Update Work File	1	WF	CTID	Computer ID	String	Generic Edit	15	0
31	F30UI006	Lot Tracking Work File	1	IL	CTID	Computer ID	String	Generic Edit	15	0
32	F40UI00T	Tax Work File	28	PN	CTID	Computer ID	String	Generic Edit	15	0
33	F40UI17	Allocation Work File	1	ZG	CTID	Computer ID	String	Generic Edit	15	0
34	F40UI74	Price Adjustment History Work File	1	AW	CTID	Computer ID	String	Generic Edit	15	0
35	F40UI801	Generic Error Table	1	ZB	CTID	Computer ID	String	Generic Edit	15	0
TOP40G: Grower Management
36	F40G30S	Assessments / Donations Workfile	3	AD	CTID	Computer ID	String	Generic Edit	15	0
TOP40R: Demand Scheduling
37	F40R12WF	CUM Rollback Workfile	2	CQ	CTID	Computer ID	String	Generic Edit	15	0
38	F40R30WF	Demand Work File	1	DS	CTID	Computer ID	String	Generic Edit	15	0
39	F47UI002	ASN Extract Packaging Work File	1	SP	CTID	Computer ID	String	Generic Edit	15	0
TOP40S: Supply Chain Self Service
40	F4947SW	Self-Service Shipment Tracking Work File	2	SW	CTID	Computer ID	String	Generic Edit	15	0
TOP41: Inventory Management
41	F41021WF	F41021 Transaction Workfile	2	LW	CTID	Computer ID	String	Generic Edit	15	0
42	F41291Z	Landed Cost Cache Table	1	IG	CTID	Computer ID	String	Generic Edit	15	0
43	F41UI001	Inventory Transactions Detail File	1	IT	CTID	Computer ID	String	Generic Edit	15	0
44	F41UI003	ABC Analysis Detail - Work File	1	AA	CTID	Computer ID	String	Generic Edit	15	0
TOP41F: Apparel Management
45	FCW105	Fair Share Sprinkling Rate	7	WF	CTID	Computer ID	String	Generic Edit	15	0
46	FCW31	Proposal Order Line Details	34	LV	CTID	Computer ID	String	Generic Edit	15	0
47	FCW69	Work Order Parts List Issues	10	WP	CTID	Computer ID	String	Generic Edit	15	0
TOP42: Sales Management
48	F40UI16	Preference Print Message Work File	1	DS	CTID	Computer ID	String	Generic Edit	15	0
49	F42565	Invoice Print File	1	IW	CTID	Computer ID	String	Generic Edit	15	0
50	F42A011	Campaigns	41	CA	CTID	Computer ID	String	Generic Edit	15	0
51	F42A012	Opportunity	41	OP	CTID	Computer ID	String	Generic Edit	15	0
52	F42CSS	Customer Self Service Workfile	9	CS	CTID	Computer ID	String	Generic Edit	15	0
53	F42UI005	Sales Commission File	54	SC	CTID	Computer ID	String	Generic Edit	15	0
54	F42UI01	SO Header Cache File (MBF)	1	ZH	CTID	Computer ID	String	Generic Edit	15	0
55	F42UI11	SO Detail Cache File (MBF)	1	ZD	CTID	Computer ID	String	Generic Edit	15	0
56	F42UI11C	Customer Self Service Shopping Cart Workfile	1	SC	CTID	Computer ID	String	Generic Edit	15	0
57	F42UI12	Sales Order Detail Cache 2 (MBF)	1	ZD	CTID	Computer ID	String	Generic Edit	15	0
58	F42UI130	Commitment Work File	3	ZC	CTID	Computer ID	String	Generic Edit	15	0
59	F42UI150	Sales Order Header Commission Information Work File	2	ZH	CTID	Computer ID	String	Generic Edit	15	0
60	F42UI160	Sales Order Detail Commission Information Work File	2	ZD	CTID	Computer ID	String	Generic Edit	15	0
61	F42UI520	Pick Slips Header File	52	S8	CTID	Computer ID	String	Generic Edit	15	0
62	F42UI521	Pick Slips Detail File	135	S9	CTID	Computer ID	String	Generic Edit	15	0
63	F42UI800	Sales Detail Work File - Sales Update	1	SD	CTID	Computer ID	String	Generic Edit	15	0
TOP42B: Sales Order Entry
64	F42UI440	Customer Segment Items - Work File	15	CS	CTID	Computer ID	String	Generic Edit	15	0
TOP42W: Fulfilment Management
65	F4277720	Fulfillment Rules Header	13	AH	CTID	Computer ID	String	Generic Edit	15	0
66	F4277730	Fulfillment Rules Detail	17	AD	CTID	Computer ID	String	Generic Edit	15	0
TOP43: Procurement
67	F40910	Commitment Integrity Report Work File	2	P#	CTID	Computer ID	String	Generic Edit	15	0
68	F4301Z	PO Header Work File	1	PA	CTID	Computer ID	String	Generic Edit	15	0
69	F43092Z	Receipt Routing Work File	1	PV	CTID	Computer ID	String	Generic Edit	15	0
70	F4311Z	Purchase Order Generator File	1	PW	CTID	Computer ID	String	Generic Edit	15	0
71	F43121Z	Receiver workfile	9	PW	CTID	Computer ID	String	Generic Edit	15	0
72	F43147	Freight Distribution Workfile	2	FD	CTID	Computer ID	String	Generic Edit	15	0
73	F4314Z	Voucher Match Selection File	1	PN	CTID	Computer ID	String	Generic Edit	15	0
74	F43632Z	Open Purchase Order by Item Work File	4	OI	CTID	Computer ID	String	Generic Edit	15	0
75	F4371	Suggested Reorder Stock Items	27	PD	CTID	Computer ID	String	Generic Edit	15	0
76	F43UI50C	PO Print Clauses Table	14	WC	CTID	Computer ID	String	Generic Edit	15	0
77	F43UI50D	PO Print Detail Work File	68	PW	CTID	Computer ID	String	Generic Edit	15	0
78	F43UI50H	PO Print Header Work File	63	PA	CTID	Computer ID	String	Generic Edit	15	0
TOP45: Advanced Pricing
79	F4072W	Price Adjustment Detail Work File	37	AD	CTID	Computer ID	String	Generic Edit	15	0
80	F40UI84	Orders Affected by Price Change (Work-file)	6	XR	CTID	Computer ID	String	Generic Edit	15	0
81	F4511W	Pricing Structure View	1	AP	CTID	Computer ID	String	Generic Edit	15	0
82	F45511W	Search Agent Directives Work File	1	SW	CTID	Computer ID	String	Generic Edit	15	0
TOP46R: RFID Outbound
83	F46R010	EPC Segment Definition	16	SD	CTID	Computer ID	String	Generic Edit	15	0
84	F46R020	EPC Manager Master	16	EM	CTID	Computer ID	String	Generic Edit	15	0
TOP47: Electronic Commerce
85	F47003	EDI Discrepancy Report Work File	1	SX	CTID	Computer ID	String	Generic Edit	15	0
86	F47UI001	ASN Extract Work File	1	SZ	CTID	Computer ID	String	Generic Edit	15	0
TOP48: Work Order Processing
87	F48UI001	X4801 Master Business Function Workfile	2	WA	CTID	Computer ID	String	Generic Edit	15	0
TOP49: Transportation Management
88	F49110	Transportation Bill of Lading Workfile	6	BW	CTID	Computer ID	String	Generic Edit	15	0
89	F49111	Carton Detail Shipment Workfile	6	CD	CTID	Computer ID	String	Generic Edit	15	0
90	F49130	Shipment Document Workfile	4	BW	CTID	Computer ID	String	Generic Edit	15	0
91	F49140	SSCC Print Label Workfile	4	BW	CTID	Computer ID	String	Generic Edit	15	0
92	F49141	Packing List Workfile	4	PW	CTID	Computer ID	String	Generic Edit	15	0
TOP74R: Russia
93	F74RUI31	VAT Sales Book Workfile - RUS - 03B	35	W1	CTID	Computer ID	String	Generic Edit	15	0
94	F74RUI41	VAT Purchase Book Workfile - RUS - 04	36	W1	CTID	Computer ID	String	Generic Edit	15	0
95	F74RUI42	VAT Purchase Book Workfile II - RUS - 04	10	W2	CTID	Computer ID	String	Generic Edit	15	0
TOP74W: Sweden
96	F74W210	A/P Automatic Payments Spot Rate - 74W	8	K5	CTID	Computer ID	String	Generic Edit	15	0
TOP74Z: Czech Republic
97	F74ZUI02	Czech VAT Report - CZE - 74Z - Work File	17	CZ	CTID	Computer ID	String	Generic Edit	15	0
TOP75I: India
98	F75I790	Form ST-3 Working Table - IND - 09	2	WT	CTID	Computer ID	String	Generic Edit	15	0
TOP76A: Argentina
99	F76A0209	Header & Footer Invoice/ShipmentNote History WF - ARG - 76A	2	HF	CTID	Computer ID	String	Generic Edit	15	0
100	F76A020P	Header/Footer Inv./ShipmentNote History WF Purge - AR - 76A	2	HF	CTID	Computer ID	String	Generic Edit	15	0
101	F76A0219	Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A	2	DL	CTID	Computer ID	String	Generic Edit	15	0
102	F76A021P	Detail Lines Inv./ShipmentNote History WF Purge - ARG - 76A	2	DL	CTID	Computer ID	String	Generic Edit	15	0
103	F76A20	Credit Invoice Constants - ARG - 03B - 76A	23	IC	CTID	Computer ID	String	Generic Edit	15	0
104	F76A21	Credit Invoice Header - F76A21 - ARG - 3B - 76A	26	IH	CTID	Computer ID	String	Generic Edit	15	0
105	F76A21P	Credit Invoice Header Purge - ARG - 03B - 76A	26	IH	CTID	Computer ID	String	Generic Edit	15	0
106	F76A22	Credit Invoice Detail - F76A22 - ARG - 03B - 76A	20	ID	CTID	Computer ID	String	Generic Edit	15	0
107	F76A22P	Credit Invoice Detail Purge - ARG - 03B - 76A	20	ID	CTID	Computer ID	String	Generic Edit	15	0
108	F76A23	Credit Invoice Withholdings - F76A23 - ARG - 03B - 76A	14	IW	CTID	Computer ID	String	Generic Edit	15	0
109	F76A23P	Credit Invoice Withholdings Purge - ARG - 03B - 76A	14	IW	CTID	Computer ID	String	Generic Edit	15	0
110	F76A24	Credit Invoice Information - Accounts Payable - ARG - - 76A	35	IE	CTID	Computer ID	String	Generic Edit	15	0
111	F76A25	Credit Invoice Tax Area Relationship - ARG - 04 - 76A	13	IF	CTID	Computer ID	String	Generic Edit	15	0
112	F76A26	Credit Invoice Status Rules - ARG - 04 - 76A	14	IG	CTID	Computer ID	String	Generic Edit	15	0
113	F76A8230	Percentages by state / agreement Gross Income - ARG - - 76A	14	C1	CTID	Computer ID	String	Generic Edit	15	0
114	F76A8231	States members by Multilateral Agreement Gross Inc AR - 76A	3	C2	CTID	Computer ID	String	Generic Edit	15	0
115	F76A8500	Tag File F03B14 - ARG - 03B - 76A	38	TF	CTID	Computer ID	String	Generic Edit	15	0
116	F76A8510	Tag File F76A60 - ARG - 03B - 76A	25	TF	CTID	Computer ID	String	Generic Edit	15	0
117	F76A85Z1	Tag File F76A60 Batch Entry - ARG - 03B - 76A	30	BE	CTID	Computer ID	String	Generic Edit	15	0
118	F76AUI18	Taxes - Tax amount by order line - Work File - ARG - - 76A	2	WF	CTID	Computer ID	String	Generic Edit	15	0
119	F76AUI20	Header & Footer Invoice/ShipmentNote Workfile - ARG - - 76A	2	HF	CTID	Computer ID	String	Generic Edit	15	0
120	F76AUI21	Detail Lines Invoice/ShipmentNote Workfile - ARG - 03 - 76A	2	DL	CTID	Computer ID	String	Generic Edit	15	0
121	F76AUI22	WF - Legal Reports Errors - ARG - 03B - 76A	2	WF	CTID	Computer ID	String	Generic Edit	15	0
122	F76AUI23	Taxes - Totals by Tax Code - ARG - 42 - 76A	2	TW	CTID	Computer ID	String	Generic Edit	15	0
123	F76AUI24	Taxes Work File - ARG - 03B - 76A	22	TI	CTID	Computer ID	String	Generic Edit	15	0
124	F76AUI81	Draft - Invoices Work File - ARG - 03B - 76A	42	WF	CTID	Computer ID	String	Generic Edit	15	0
125	F76AUI82	Draft - Drafts Work File - ARG - 03B - 03B	33	WF	CTID	Computer ID	String	Generic Edit	15	0
126	F76AUI83	Draft - Application Drafts - Invoices Work File - ARG - 76A	48	WF	CTID	Computer ID	String	Generic Edit	15	0
127	F76AUI89	Work File to Generate ND/NC Gain/Loss - ARG - 03B - 76A	2	WF	CTID	Computer ID	String	Generic Edit	15	0
128	F76AUI98	Cost Account Work Table - Work in Progress Adjustment - 76A	2	CA	CTID	Computer ID	String	Generic Edit	15	0
TOP76B: Brazil
129	F76B0570	Brazil Elect Rpt Block E Work table - BRA - 00	2	WF	CTID	Computer ID	String	Generic Edit	15	0
130	F76B0735	Ato - Cotepe11 - Block E - Work File	2	WF	CTID	Computer ID	String	Generic Edit	15	0
TOP76C: Colombia
131	F76C311T	A/R Tag File - Recycle Recurring - COL - 03B - 76C	5	RP	CTID	Computer ID	String	Generic Edit	15	0
132	F76CUI04	Tax Detail for Distribution - Work File - COL - 76C	65	TD	CTID	Computer ID	String	Generic Edit	15	0
TOP76E: Ecuador
133	F76E0018	Print Withholding Workfile - EC - 04	2	TD	CTID	Computer ID	String	Generic Edit	15	0
TOP76H: Chile
134	F76HUI31	Document Related Work File - CHI - 42 - 76H	1	DR	CTID	Computer ID	String	Generic Edit	15	0
135	F76HUI32	Workfile for R76H3B40 - CHI - 42 - 76H	1	WF	CTID	Computer ID	String	Generic Edit	15	0
136	F76HUI33	Workfile for R76H3B40 - CHI - 42 - 76H	1	WF	CTID	Computer ID	String	Generic Edit	15	0
137	F76HUI34	Order Related Work File - CHI - 42 - 76H	2	OR	CTID	Computer ID	String	Generic Edit	15	0
138	F76HUI52	Document Selection Work File - CHI - 42 - 76H	1	DR	CTID	Computer ID	String	Generic Edit	15	0
139	F76HUI61	Cache F76H3B1Z EDI Tag File - CHI - 03B - 76H	2	ZT	CTID	Computer ID	String	Generic Edit	15	0
TOP76P: Peru
140	F76PUI45	Workfile VAT Purchasing Ledger - PER - 04 - 76P	1	WF	CTID	Computer ID	String	Generic Edit	15	0
TOP79A: Greenhouse Gas Accounting
141	F79AU11	GHG Ledger Work Table	1	GR	CTID	Computer ID	String	Generic Edit	15	0
142	F79AU21	GHG Ledger Gas Work File	1	GW	CTID	Computer ID	String	Generic Edit	15	0
TOP89: Conversion Programs
143	F32UI002	Needed for upgrade from Xe and below	1	WY	CTID	Computer ID	String	Generic Edit	15	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

143 columns | 920 | CTID