	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

160 columns | 920 | BCRC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0018R	Tax Reconciliation Repository	16	ED	BCRC	Currency Code - Base	String	Generic Edit	3	0
2	F0911	Account Ledger	124	GL	BCRC	Currency Code - Base	String	Generic Edit	3	0
TOP03B: Enhanced Accounts Receivable
3	F03B11	Customer Ledger	31	RP	BCRC	Currency Code - Base	String	Generic Edit	3	0
4	F03B112	Invoice Revisions	33	RW	BCRC	Currency Code - Base	String	Generic Edit	3	0
5	F03B112P	Invoice Revisions Purge File	33	RW	BCRC	Currency Code - Base	String	Generic Edit	3	0
6	F03B117	Revenue Recognition GL Info	59	RL	BCRC	Currency Code - Base	String	Generic Edit	3	0
7	F03B119	Revenue Recognition GL Info Audit	57	RN	BCRC	Currency Code - Base	String	Generic Edit	3	0
8	F03B11P	Customer Ledger Purge File	31	RP	BCRC	Currency Code - Base	String	Generic Edit	3	0
9	F03B11SW	Customer Ledger Summary Work Table	6	CS	BCRC	Currency Code - Base	String	Generic Edit	3	0
10	F03B11Z2	F03B11 Interoperability Table	44	SY	BCRC	Currency Code - Base	String	Generic Edit	3	0
11	F03B13	Receipts Header	24	RY	BCRC	Currency Code - Base	String	Generic Edit	3	0
12	F03B13P	Receipts Header Purge File	24	RY	BCRC	Currency Code - Base	String	Generic Edit	3	0
13	F03B13Z2	F03B13 Interoperability Table	37	SY	BCRC	Currency Code - Base	String	Generic Edit	3	0
14	F03B14	Receipts Detail	31	RZ	BCRC	Currency Code - Base	String	Generic Edit	3	0
15	F03B14P	Receipts Detail Purge File	31	RZ	BCRC	Currency Code - Base	String	Generic Edit	3	0
16	F03B14Z2	F03B14 Interoperability Table	44	SZ	BCRC	Currency Code - Base	String	Generic Edit	3	0
17	F03B21	A/R Notification History Detail	19	ZS	BCRC	Currency Code - Base	String	Generic Edit	3	0
18	F03B22	A/R Fee Journal History	13	RS	BCRC	Currency Code - Base	String	Generic Edit	3	0
19	F03B23	A/R Fee Journal History Detail	12	RT	BCRC	Currency Code - Base	String	Generic Edit	3	0
20	F03B40	A/R Deduction Management	28	RB	BCRC	Currency Code - Base	String	Generic Edit	3	0
21	F03B41	A/R Deduction Activity	11	RC	BCRC	Currency Code - Base	String	Generic Edit	3	0
22	F03B575	Auto Debit Invoice Select and Build	34	RD	BCRC	Currency Code - Base	String	Generic Edit	3	0
23	F03B672	Draft Remittance	27	RD	BCRC	Currency Code - Base	String	Generic Edit	3	0
TOP04: Accounts Payable
24	F0411	Accounts Payable Ledger	113	RP	BCRC	Currency Code - Base	String	Generic Edit	3	0
25	F0411A	WF - 'As Of' Accounts Payable Ledger	113	RP	BCRC	Currency Code - Base	String	Generic Edit	3	0
26	F0411P	Purge - Accounts Payable Ledger	113	RP	BCRC	Currency Code - Base	String	Generic Edit	3	0
27	F0411SW	Supplier Ledger Summary Work Table	6	SS	BCRC	Currency Code - Base	String	Generic Edit	3	0
28	F0411Z1	Voucher Transactions - Batch Upload	160	VL	BCRC	Currency Code - Base	String	Generic Edit	3	0
29	F0411Z3	F0411 Interoperability Table	167	SZ	BCRC	Currency Code - Base	String	Generic Edit	3	0
30	F0414	Accounts Payable Matching Document Detail	36	RN	BCRC	Currency Code - Base	String	Generic Edit	3	0
31	F0414A	WF - 'As Of' Accounts Payable Payment Detail	38	RN	BCRC	Currency Code - Base	String	Generic Edit	3	0
32	F0414P	Purge - Accounts Payable Matching Document Detail	36	RN	BCRC	Currency Code - Base	String	Generic Edit	3	0
33	F0414Z1	F0414 Interoperability Table	56	SZ	BCRC	Currency Code - Base	String	Generic Edit	3	0
34	F04573	A/P Payment Processing - Detail	46	KI	BCRC	Currency Code - Base	String	Generic Edit	3	0
35	F09UI005	Tax Offsets User Index	42	GL	BCRC	Currency Code - Base	String	Generic Edit	3	0
TOP09: General Accounting
36	F0911P	Purge - Account Ledger	124	GL	BCRC	Currency Code - Base	String	Generic Edit	3	0
37	F0911R	WF - Account Ledger Reconciliation	59	GL	BCRC	Currency Code - Base	String	Generic Edit	3	0
38	F0911Z1	Journal Entry Transactions - Batch File	175	VN	BCRC	Currency Code - Base	String	Generic Edit	3	0
39	F0911Z4	F0911 Interoperability Table	155	SZ	BCRC	Currency Code - Base	String	Generic Edit	3	0
40	F09521	Cash Type Rules	12	FR	BCRC	Currency Code - Base	String	Generic Edit	3	0
41	F09522	Cash Forecast Data	5	FD	BCRC	Currency Code - Base	String	Generic Edit	3	0
42	F09UI017	Cash Forecast Detail	9	FW	BCRC	Currency Code - Base	String	Generic Edit	3	0
TOP15: Real Estate Management
43	F151991	G/L Transaction A/R Application Work File	20	NB	BCRC	Currency Code - Base	String	Generic Edit	3	0
44	F15199W	G/L Transaction Summarization Work File	12	NB	BCRC	Currency Code - Base	String	Generic Edit	3	0
45	F1540B	Sales Report Control	46	NR	BCRC	Currency Code - Base	String	Generic Edit	3	0
46	F1542	Projected Sales	42	OJ	BCRC	Currency Code - Base	String	Generic Edit	3	0
TOP15L: Adv Real Estate Forecasting
47	F15L301	AREF Projected Sales	43	PS	BCRC	Currency Code - Base	String	Generic Edit	3	0
TOP40: Inventory/OP Base
48	F4001Z	Batch Receiver File - Order Headings	136	SY	BCRC	Currency Code - Base	String	Generic Edit	3	0
49	F4201Z1	Sales Order Header Unedited Transaction File	124	SY	BCRC	Currency Code - Base	String	Generic Edit	3	0
50	F4211Z1	Sales Order Detail Unedited Transaction File	245	SZ	BCRC	Currency Code - Base	String	Generic Edit	3	0
51	F43800	Summary Voucher Match	18	PR	BCRC	Currency Code - Base	String	Generic Edit	3	0
TOP42: Sales Management
52	F4201	Sales Order Header File	112	SH	BCRC	Currency Code - Base	String	Generic Edit	3	0
53	F42019	Sales Order Header History File	112	SH	BCRC	Currency Code - Base	String	Generic Edit	3	0
54	F4211	Sales Order Detail File	232	SD	BCRC	Currency Code - Base	String	Generic Edit	3	0
55	F42119	Sales Order History File	232	SD	BCRC	Currency Code - Base	String	Generic Edit	3	0
56	F42199	S.O. Detail Ledger File	232	SL	BCRC	Currency Code - Base	String	Generic Edit	3	0
57	F42UI01	SO Header Cache File (MBF)	150	ZH	BCRC	Currency Code - Base	String	Generic Edit	3	0
58	F42UI12	Sales Order Detail Cache 2 (MBF)	88	ZD	BCRC	Currency Code - Base	String	Generic Edit	3	0
59	F47027T	Tag for F47027 - EDI P.O. Acknowledgment Detail - Outbound	2	UZ	BCRC	Currency Code - Base	String	Generic Edit	3	0
60	F47047T	Tag for F47047- EDI Invoice Detail (Sales) - Outbound	2	UZ	BCRC	Currency Code - Base	String	Generic Edit	3	0
61	F47107T	Tag for F47107- EDI Response to RFQ Detail - Outbound	2	UZ	BCRC	Currency Code - Base	String	Generic Edit	3	0
62	F47147T	Tag F47147 - EDI P.O. Change Acknowledgment Detail-Outbound	2	UZ	BCRC	Currency Code - Base	String	Generic Edit	3	0
TOP42B: Sales Order Entry
63	F4011ZT	Batch Receiver File - Order Details Tag	25	UZ	BCRC	Currency Code - Base	String	Generic Edit	3	0
64	F47012T	EDI Purchase Order Detail Tag - Inbound	25	UZ	BCRC	Currency Code - Base	String	Generic Edit	3	0
65	F47092T	EDI Request for Quote Detail Tag - Inbound	25	UZ	BCRC	Currency Code - Base	String	Generic Edit	3	0
66	F47132T	EDI Purchase Order Change Detail Tag - Inbound	25	UZ	BCRC	Currency Code - Base	String	Generic Edit	3	0
TOP42I: Outbound Inventory Management
67	F42I015	Outbound Inventory Agreement Transaction File	46	OI	BCRC	Currency Code - Base	String	Generic Edit	3	0
TOP43: Procurement
68	F4301	Purchase Order Header	88	PH	BCRC	Currency Code - Base	String	Generic Edit	3	0
69	F4301Z1	Purchase Order Header Unedited Transaction Table	105	SY	BCRC	Currency Code - Base	String	Generic Edit	3	0
70	F4311	Purchase Order Detail File	206	PD	BCRC	Currency Code - Base	String	Generic Edit	3	0
71	F4311Z1	Purchase Order Detail Unedited Transaction Table	226	SZ	BCRC	Currency Code - Base	String	Generic Edit	3	0
72	F43121	Purchase Order Receiver File	106	PR	BCRC	Currency Code - Base	String	Generic Edit	3	0
73	F43121Z	Receiver workfile	164	PW	BCRC	Currency Code - Base	String	Generic Edit	3	0
74	F43121Z1	Receipts Unedited Transaction Table	196	SZ	BCRC	Currency Code - Base	String	Generic Edit	3	0
75	F43199	P.O. Detail Ledger File - Flexible Version	207	OL	BCRC	Currency Code - Base	String	Generic Edit	3	0
76	F4322	Purchasing Tolerance Rules	14	PZ	BCRC	Currency Code - Base	String	Generic Edit	3	0
TOP45: Advanced Pricing
77	F4576	Ship and Debit Claims	28	AC	BCRC	Currency Code - Base	String	Generic Edit	3	0
78	F4576TMP	Ship and Debit Claims- Temp Table	28	AC	BCRC	Currency Code - Base	String	Generic Edit	3	0
79	F4576Z1	Ship and Debit Claims Unedited Transaction Table	41	Z1	BCRC	Currency Code - Base	String	Generic Edit	3	0
TOP47: Electronic Commerce
80	F47011	EDI Purchase Order Header - Inbound	124	SY	BCRC	Currency Code - Base	String	Generic Edit	3	0
81	F47016	EDI Purchase Order Header - Outbound	108	SY	BCRC	Currency Code - Base	String	Generic Edit	3	0
82	F47017	EDI Purchase Order Detail - Outbound	217	SZ	BCRC	Currency Code - Base	String	Generic Edit	3	0
83	F47021	EDI P.O. Acknowledgment Header - Inbound	108	SY	BCRC	Currency Code - Base	String	Generic Edit	3	0
84	F47022	EDI P.O. Acknowledgment Detail - Inbound	217	SZ	BCRC	Currency Code - Base	String	Generic Edit	3	0
85	F47026	EDI P.O. Acknowledgment Header - Outbound	117	SY	BCRC	Currency Code - Base	String	Generic Edit	3	0
86	F47031	EDI Shipping Notice Header - Inbound	102	SY	BCRC	Currency Code - Base	String	Generic Edit	3	0
87	F47032T	EDI Shipping Notice Detail- Inbound Tag	4	SZ	BCRC	Currency Code - Base	String	Generic Edit	3	0
88	F47036	EDI Shipping Notice Header - Outbound	40	SY	BCRC	Currency Code - Base	String	Generic Edit	3	0
89	F470371	EDI Shipping Notice Detail - Outbound	99	SZ	BCRC	Currency Code - Base	String	Generic Edit	3	0
90	F47046	EDI Invoice Header (Sales) - Outbound	105	SY	BCRC	Currency Code - Base	String	Generic Edit	3	0
91	F47071	EDI Receiving Advice Header - Inbound	101	SY	BCRC	Currency Code - Base	String	Generic Edit	3	0
92	F47072	EDI Receiving Advice Detail - Inbound	205	SZ	BCRC	Currency Code - Base	String	Generic Edit	3	0
93	F47076	EDI Receiving Advice Header - Outbound	101	SY	BCRC	Currency Code - Base	String	Generic Edit	3	0
94	F47077	EDI Receiving Advice Detail - Outbound	205	SZ	BCRC	Currency Code - Base	String	Generic Edit	3	0
95	F47091	EDI Request for Quote Header - Inbound	124	SY	BCRC	Currency Code - Base	String	Generic Edit	3	0
96	F47096	EDI Request for Quote Header - Outbound	109	SY	BCRC	Currency Code - Base	String	Generic Edit	3	0
97	F47097	EDI Request for Quote Detail - Outbound	217	SZ	BCRC	Currency Code - Base	String	Generic Edit	3	0
98	F47101	EDI Response to RFQ Header - Inbound	109	SY	BCRC	Currency Code - Base	String	Generic Edit	3	0
99	F47102	EDI Response to RFQ Detail - Inbound	217	SZ	BCRC	Currency Code - Base	String	Generic Edit	3	0
100	F47106	EDI Response to RFQ Header - Outbound	121	SY	BCRC	Currency Code - Base	String	Generic Edit	3	0
101	F47131	EDI Purchase Order Change Header - Inbound	121	SY	BCRC	Currency Code - Base	String	Generic Edit	3	0
102	F47136	EDI Purchase Order Change Header - Outbound	108	SY	BCRC	Currency Code - Base	String	Generic Edit	3	0
103	F47141	EDI P.O. Change Acknowledgment Header - Inbound	109	SY	BCRC	Currency Code - Base	String	Generic Edit	3	0
104	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	219	SZ	BCRC	Currency Code - Base	String	Generic Edit	3	0
105	F47146	EDI P.O. Change Acknowledgment Header - Outbound	122	SY	BCRC	Currency Code - Base	String	Generic Edit	3	0
106	F47156	EDI Shipping Schedule Header - Outbound	86	SY	BCRC	Currency Code - Base	String	Generic Edit	3	0
107	F47157	EDI Shipping Schedule Detail - Outbound	88	SZ	BCRC	Currency Code - Base	String	Generic Edit	3	0
TOP51X: In-Memory Project Management
108	F51X0911	Account Ledger Worktable	11	AL	BCRC	Currency Code - Base	String	Generic Edit	3	0
TOP54R: Rental Management
109	F54R099	Rental Contract Header Ledger	76	HL	BCRC	Currency Code - Base	String	Generic Edit	3	0
110	F54R10	Rental Contract Header	74	CH	BCRC	Currency Code - Base	String	Generic Edit	3	0
111	F54R11	Rental Contract Detail	117	CD	BCRC	Currency Code - Base	String	Generic Edit	3	0
112	F54R199	Rental Contract Detail Ledger	113	DL	BCRC	Currency Code - Base	String	Generic Edit	3	0
TOP70: Multi-National Products
113	F7001100	Localizations Additional Fields AB - 01	54	LA	BCRC	Currency Code - Base	String	Generic Edit	3	0
114	F7003B11	Localizations Additional Fields Customer Ledger - 01	57	LA	BCRC	Currency Code - Base	String	Generic Edit	3	0
115	F700411	Localizations Additional Fields Accounts Payable Ledger - 04	58	LA	BCRC	Currency Code - Base	String	Generic Edit	3	0
116	F702018	Taxes by Sales Order Line - COMM - 42	13	TA	BCRC	Currency Code - Base	String	Generic Edit	3	0
117	F704001	Payment WH Info TEMP - COMM - 04	51	PT	BCRC	Currency Code - Base	String	Generic Edit	3	0
118	F704002	Payment WH Info - COMM - 04	50	PF	BCRC	Currency Code - Base	String	Generic Edit	3	0
119	F704002P	Payment WH Info Purge - COMM - 04	50	PF	BCRC	Currency Code - Base	String	Generic Edit	3	0
120	F704003	Payment Done - Accum - COMM - 04	14	PD	BCRC	Currency Code - Base	String	Generic Edit	3	0
121	F704008	Localizations Additional Fields Tax Area - 04	53	LA	BCRC	Currency Code - Base	String	Generic Edit	3	0
122	F704101A	Localizations Additional Fields Item Master - 01	54	LA	BCRC	Currency Code - Base	String	Generic Edit	3	0
123	F704201	Localizations Additional Fields Sales Order - 01	56	LA	BCRC	Currency Code - Base	String	Generic Edit	3	0
TOP74: EMEA Localization
124	F74093	Worktable for Printing IVA Summary - Italy	67	HC	BCRC	Currency Code - Base	String	Generic Edit	3	0
125	F74900	Foreign Receivables and Payables - EMEA	38	RP	BCRC	Currency Code - Base	String	Generic Edit	3	0
TOP74H: Hungary
126	F74H910	JE VAT Differences - HUN - 09	18	VD	BCRC	Currency Code - Base	String	Generic Edit	3	0
TOP74R: Russia
127	F74R311	Prepayment Detail Tax File - RUS - 03B	20	DE	BCRC	Currency Code - Base	String	Generic Edit	3	0
TOP74S: Spain
128	F74S79	Model 347 - Record Type 2 - Spain Tag File	10	TQ	BCRC	Currency Code - Base	String	Generic Edit	3	0
TOP75C: China
129	F75C010W	AP & AR XML Workfile - China -75C	13	AA	BCRC	Currency Code - Base	String	Generic Edit	3	0
130	F75C014	AP/AR Balances - China	8	BA	BCRC	Currency Code - Base	String	Generic Edit	3	0
TOP75I: India
131	F75I611	TCS Prepayment Transaction File - IND-03B	28	TT	BCRC	Currency Code - Base	String	Generic Edit	3	0
132	F75I732	Service Tax A/R File Additional Info - IND - 03B	10	ST	BCRC	Currency Code - Base	String	Generic Edit	3	0
133	F75I742	Service Tax A/P File Additional Info - IND - 04	11	ST	BCRC	Currency Code - Base	String	Generic Edit	3	0
TOP75T: Taiwan
134	F75T004	GUI/VAT Transaction Header - 75T	19	TH	BCRC	Currency Code - Base	String	Generic Edit	3	0
135	F75T0049	GUI/VAT Transaction Header History - 75T	19	TH	BCRC	Currency Code - Base	String	Generic Edit	3	0
136	F75T004P	GUI/VAT Transaction Header POS - 75T	18	TH	BCRC	Currency Code - Base	String	Generic Edit	3	0
137	F75T004Z	GUI/VAT Transaction Header - Work - 75T	17	ZH	BCRC	Currency Code - Base	String	Generic Edit	3	0
138	F75T005	GUI/VAT Transaction Detail - 75T	15	TD	BCRC	Currency Code - Base	String	Generic Edit	3	0
139	F75T0059	GUI/VAT Transaction Detail History - 75T	15	TD	BCRC	Currency Code - Base	String	Generic Edit	3	0
140	F75T005P	GUI/VAT Transaction Detail POS - 75T	15	TD	BCRC	Currency Code - Base	String	Generic Edit	3	0
141	F75T005T	GUI/VAT Transaction Detail Temp - 75T	15	TD	BCRC	Currency Code - Base	String	Generic Edit	3	0
142	F75T005Z	GUI/VAT Transaction Detail - Work - 75T	22	ZD	BCRC	Currency Code - Base	String	Generic Edit	3	0
TOP76A: Argentina
143	F76A40	Withholding Certificates Legal Number - 76A	13	WC	BCRC	Currency Code - Base	String	Generic Edit	3	0
144	F76A55	Withholding Certificates Legal Number History Files - 76A	8	HW	BCRC	Currency Code - Base	String	Generic Edit	3	0
145	F76AUI82	Draft - Drafts Work File - ARG - 03B - 03B	40	WF	BCRC	Currency Code - Base	String	Generic Edit	3	0
146	F76AUI83	Draft - Application Drafts - Invoices Work File - ARG - 76A	18	WF	BCRC	Currency Code - Base	String	Generic Edit	3	0
TOP76B: Brazil
147	F76B401	DIRF WorkTable - BRA - 76B	8	DI	BCRC	Currency Code - Base	String	Generic Edit	3	0
TOP76C: Colombia
148	F76C031A	A/R Customer ledger As Of - F76C031A - COL - 04	31	RP	BCRC	Currency Code - Base	String	Generic Edit	3	0
149	F76C034A	A/R Check Detail file As Of - COL - 03B	29	RZ	BCRC	Currency Code - Base	String	Generic Edit	3	0
TOP76M: Mexico
150	F76M0314	Receipt Detail Tag File - Mexico	19	MA	BCRC	Currency Code - Base	String	Generic Edit	3	0
151	F76M0414	F0414 - Payment Detail Tag File - Mexico	19	RT	BCRC	Currency Code - Base	String	Generic Edit	3	0
152	F76M311	AR Soft Rounding VAT - Mexico	11	MB	BCRC	Currency Code - Base	String	Generic Edit	3	0
153	F76M411	Soft Rounding VAT Calculation	10	RS	BCRC	Currency Code - Base	String	Generic Edit	3	0
154	F76M930	AR VAT on Gain/loss MEX - 76M	22	AP	BCRC	Currency Code - Base	String	Generic Edit	3	0
155	F76M940	AP VAT on Gain/loss - MEX - 76M	13	AP	BCRC	Currency Code - Base	String	Generic Edit	3	0
156	F76M990	GL VAT on Gain/loss MEX - 76M	28	GL	BCRC	Currency Code - Base	String	Generic Edit	3	0
TOP79A: Greenhouse Gas Accounting
157	F79A11	GHG Ledger	51	GR	BCRC	Currency Code - Base	String	Generic Edit	3	0
158	F79A11Z1	GHG Ledger - Batch File	59	GL	BCRC	Currency Code - Base	String	Generic Edit	3	0
159	F79A12	GHG Ledger Audit	52	GR	BCRC	Currency Code - Base	String	Generic Edit	3	0
160	F79AU11	GHG Ledger Work Table	55	GR	BCRC	Currency Code - Base	String	Generic Edit	3	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

160 columns | 920 | BCRC