	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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

108 columns | 920 | ACR

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0911	Account Ledger	132	GL	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP03: Accounts Receivable
2	F0311	Accounts Receivable Ledger	34	RP	ACR	Amount - Currency	Numeric	Generic Edit	15	2
3	F0312	A/R Batch Cash Application	31	RU	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP03B: Enhanced Accounts Receivable
4	F03B11	Customer Ledger	36	RP	ACR	Amount - Currency	Numeric	Generic Edit	15	2
5	F03B112	Invoice Revisions	38	RW	ACR	Amount - Currency	Numeric	Generic Edit	15	2
6	F03B112P	Invoice Revisions Purge File	38	RW	ACR	Amount - Currency	Numeric	Generic Edit	15	2
7	F03B117	Revenue Recognition GL Info	52	RL	ACR	Amount - Currency	Numeric	Generic Edit	15	2
8	F03B119	Revenue Recognition GL Info Audit	50	RN	ACR	Amount - Currency	Numeric	Generic Edit	15	2
9	F03B11P	Customer Ledger Purge File	36	RP	ACR	Amount - Currency	Numeric	Generic Edit	15	2
10	F03B11SW	Customer Ledger Summary Work Table	9	CS	ACR	Amount - Currency	Numeric	Generic Edit	15	2
11	F03B11Z1	Batch Invoices	53	VJ	ACR	Amount - Currency	Numeric	Generic Edit	15	2
12	F03B11Z2	F03B11 Interoperability Table	49	SY	ACR	Amount - Currency	Numeric	Generic Edit	15	2
13	F03B21	A/R Notification History Detail	62	ZS	ACR	Amount - Currency	Numeric	Generic Edit	15	2
14	F03B465	A/R Netting Workfile	28	RO	ACR	Amount - Currency	Numeric	Generic Edit	15	2
15	F03B575	Auto Debit Invoice Select and Build	45	RD	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP04: Accounts Payable
16	F0411	Accounts Payable Ledger	36	RP	ACR	Amount - Currency	Numeric	Generic Edit	15	2
17	F0411A	WF - 'As Of' Accounts Payable Ledger	36	RP	ACR	Amount - Currency	Numeric	Generic Edit	15	2
18	F0411P	Purge - Accounts Payable Ledger	36	RP	ACR	Amount - Currency	Numeric	Generic Edit	15	2
19	F0411SW	Supplier Ledger Summary Work Table	9	SS	ACR	Amount - Currency	Numeric	Generic Edit	15	2
20	F0411Z1	Voucher Transactions - Batch Upload	54	VL	ACR	Amount - Currency	Numeric	Generic Edit	15	2
21	F0411Z3	F0411 Interoperability Table	59	SZ	ACR	Amount - Currency	Numeric	Generic Edit	15	2
22	F04573	A/P Payment Processing - Detail	16	KI	ACR	Amount - Currency	Numeric	Generic Edit	15	2
23	F09UI005	Tax Offsets User Index	28	GL	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP05T: Time Entry
24	F063951	Payroll Journal (Compressed) File	38	GL	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP07: Payroll
25	F05290	WF - Payroll Journal (Detail)	39	JR	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP09: General Accounting
26	F0911P	Purge - Account Ledger	132	GL	ACR	Amount - Currency	Numeric	Generic Edit	15	2
27	F0911R	WF - Account Ledger Reconciliation	75	GL	ACR	Amount - Currency	Numeric	Generic Edit	15	2
28	F0911Z1	Journal Entry Transactions - Batch File	123	VN	ACR	Amount - Currency	Numeric	Generic Edit	15	2
29	F0911Z4	F0911 Interoperability Table	122	SZ	ACR	Amount - Currency	Numeric	Generic Edit	15	2
30	F0917	Bank Statement Detail	12	GD	ACR	Amount - Currency	Numeric	Generic Edit	15	2
31	F09UI007	Match Bank Tape to Recon File - ONE WORLD ONLY	19	GL	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP15: Real Estate Management
32	F15012B	Tenant E.P. Class Master	90	NS	ACR	Amount - Currency	Numeric	Generic Edit	15	2
33	F15016	Tenant Escalation Master	49	NU	ACR	Amount - Currency	Numeric	Generic Edit	15	2
34	F15016B	Tenant Escalation Master	52	NU	ACR	Amount - Currency	Numeric	Generic Edit	15	2
35	F1502	Recurring Billings Master	44	NF	ACR	Amount - Currency	Numeric	Generic Edit	15	2
36	F1502B	Recurring Billings Master	44	NF	ACR	Amount - Currency	Numeric	Generic Edit	15	2
37	F1502WB	Estimated EP Recurring Billings	47	N4	ACR	Amount - Currency	Numeric	Generic Edit	15	2
38	F1511	Tenant/Lease Billings Detail	45	NJ	ACR	Amount - Currency	Numeric	Generic Edit	15	2
39	F1511B	Lease Billings Master	45	NJ	ACR	Amount - Currency	Numeric	Generic Edit	15	2
40	F1511H	Tenant/Lease Billings Detail History	45	N#	ACR	Amount - Currency	Numeric	Generic Edit	15	2
41	F1511HB	Lease Billings History	45	NC	ACR	Amount - Currency	Numeric	Generic Edit	15	2
42	F151991	G/L Transaction A/R Application Work File	16	NB	ACR	Amount - Currency	Numeric	Generic Edit	15	2
43	F1538B	EP Billing Register	119	NZ	ACR	Amount - Currency	Numeric	Generic Edit	15	2
44	F1540B	Sales Report Control	48	NR	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP17C: Call Management
45	F1755	Case Master	105	ZA	ACR	Amount - Currency	Numeric	Generic Edit	15	2
46	F1760	Time Entry	28	ZB	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP42: Sales Management
47	F42800G1	Sales Update G Batch Detail Workfile	42	DG	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP43: Procurement
48	F4314Z	Voucher Match Selection File	54	PN	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP47: Electronic Commerce
49	F470161	EDI Purchase Order Additional Header - Outbound	52	S3	ACR	Amount - Currency	Numeric	Generic Edit	15	2
50	F47042	EDI Invoice Detail - Inbound	73	SZ	ACR	Amount - Currency	Numeric	Generic Edit	15	2
51	F47044	EDI Invoice Summary - Inbound	38	SW	ACR	Amount - Currency	Numeric	Generic Edit	15	2
52	F470461	EDI Invoice Additional Header - Outbound	53	S3	ACR	Amount - Currency	Numeric	Generic Edit	15	2
53	F47057	EDI Payment Order Remittance Advice - Outbound	63	D3	ACR	Amount - Currency	Numeric	Generic Edit	15	2
54	F47057W	EDI Payment Order Remittance Advice - Work	63	D3	ACR	Amount - Currency	Numeric	Generic Edit	15	2
55	F471061	EDI Response to RFQ Additional Header - Outbound	53	S3	ACR	Amount - Currency	Numeric	Generic Edit	15	2
56	F47114	EDI Lockbox/Payment Detail - Payment	21	Z4	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP48S: Service Billing
57	F4812	Billing Detail Workfile	198	WD	ACR	Amount - Currency	Numeric	Generic Edit	15	2
58	F4812H	Billing Workfile History	199	WD	ACR	Amount - Currency	Numeric	Generic Edit	15	2
59	F4812HS	Billing Workfile History Purged Save	199	WD	ACR	Amount - Currency	Numeric	Generic Edit	15	2
60	F4822	Invoice Summary Work File	43	W4	ACR	Amount - Currency	Numeric	Generic Edit	15	2
61	F4823	Voucher Summary	39	W0	ACR	Amount - Currency	Numeric	Generic Edit	15	2
62	F48S910	Billing Detail Journal Workfile	31	W2	ACR	Amount - Currency	Numeric	Generic Edit	15	2
63	F48S911	Summarized Journal Workfile	31	W3	ACR	Amount - Currency	Numeric	Generic Edit	15	2
64	F48SUI01	Billing Detail Print Workfile	195	WD	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP52G: Proj & Gov Contract Accounting
65	F4822H	Invoice Summary History	43	IH	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP74: EMEA Localization
66	F74412	Customer / Supplier Balance Worktable (A/P and A/R)	20	RP	ACR	Amount - Currency	Numeric	Generic Edit	15	2
67	F74900	Foreign Receivables and Payables - EMEA	43	RP	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP74P: Poland
68	F74P03BW	A/R Trial Balance - POL - 03B - 74P	13	P3	ACR	Amount - Currency	Numeric	Generic Edit	15	2
69	F74P04W	A/P Trial Balance Work Table - POL - 04 - 74P	13	P2	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP74R: Russia
70	F74R0018	Russian Tax File - 74R	19	TD	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP74U: United Kingdom Localizations
71	F74U0420	SPC - Application Master - UK - 43	54	SE	ACR	Amount - Currency	Numeric	Generic Edit	15	2
72	F74U0425	SPC - Certificate Master - UK - 43	56	SF	ACR	Amount - Currency	Numeric	Generic Edit	15	2
73	F74U25BT	Interest Tag Table - 15	11	PK	ACR	Amount - Currency	Numeric	Generic Edit	15	2
74	F74U4316	SPC - Purchase Order Line Additional Information - UK - 43	17	SC	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP74W: Sweden
75	F74W203	Debit Advice Invoice File - 74W	8	K3	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP75C: China
76	F75C010W	AP & AR XML Workfile - China -75C	20	AA	ACR	Amount - Currency	Numeric	Generic Edit	15	2
77	F75C014	AP/AR Balances - China	10	BA	ACR	Amount - Currency	Numeric	Generic Edit	15	2
78	F75C015	Cash Flow Data - China	26	CF	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP75I: India
79	F75I101	TDS Certificate Work Maintenance	55	QB	ACR	Amount - Currency	Numeric	Generic Edit	15	2
80	F75I4074	Price Adj Ledger Tag File - 03B	14	AL	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP76A: Argentina
81	F760473A	PCG Detail Information Tag Table - ARG - 04 - 76A	10	E5	ACR	Amount - Currency	Numeric	Generic Edit	15	2
82	F76A0440	Check details RG 1547 - ARG - 04 - 76A	10	CD	ACR	Amount - Currency	Numeric	Generic Edit	15	2
83	F76A08	Credit Invoice Payments - ARG - 04 - 76A	10	CF	ACR	Amount - Currency	Numeric	Generic Edit	15	2
84	F76A09	Invoice Total - ARG - 03B - 76A	16	TT	ACR	Amount - Currency	Numeric	Generic Edit	15	2
85	F76A09P	Invoice Total Purge - ARG - 03B - 76A	16	TT	ACR	Amount - Currency	Numeric	Generic Edit	15	2
86	F76A21	Credit Invoice Header - F76A21 - ARG - 3B - 76A	15	IH	ACR	Amount - Currency	Numeric	Generic Edit	15	2
87	F76A21P	Credit Invoice Header Purge - ARG - 03B - 76A	15	IH	ACR	Amount - Currency	Numeric	Generic Edit	15	2
88	F76A22	Credit Invoice Detail - F76A22 - ARG - 03B - 76A	10	ID	ACR	Amount - Currency	Numeric	Generic Edit	15	2
89	F76A22P	Credit Invoice Detail Purge - ARG - 03B - 76A	10	ID	ACR	Amount - Currency	Numeric	Generic Edit	15	2
90	F76A24	Credit Invoice Information - Accounts Payable - ARG - - 76A	17	IE	ACR	Amount - Currency	Numeric	Generic Edit	15	2
91	F76A81	A/P Payment Control Group File - ARG - 04 - 76A	7	C5	ACR	Amount - Currency	Numeric	Generic Edit	15	2
92	F76A82	A/P Payment Control Group File - ARG - 04 - 76A	6	C6	ACR	Amount - Currency	Numeric	Generic Edit	15	2
93	F76A8500	Tag File F03B14 - ARG - 03B - 76A	15	TF	ACR	Amount - Currency	Numeric	Generic Edit	15	2
94	F76A8510	Tag File F76A60 - ARG - 03B - 76A	5	TF	ACR	Amount - Currency	Numeric	Generic Edit	15	2
95	F76A85Z1	Tag File F76A60 Batch Entry - ARG - 03B - 76A	10	BE	ACR	Amount - Currency	Numeric	Generic Edit	15	2
96	F76AUI81	Draft - Invoices Work File - ARG - 03B - 76A	9	WF	ACR	Amount - Currency	Numeric	Generic Edit	15	2
97	F76AUI83	Draft - Application Drafts - Invoices Work File - ARG - 76A	10	WF	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP76B: Brazil
98	F76B473T	F04573 Brazilian Temp WH File - BR - 04	18	W3	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP76C: Colombia
99	F76C031A	A/R Customer ledger As Of - F76C031A - COL - 04	35	RP	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP76M: Mexico
100	F76M413	Manual Payment Header Additional Details - MEX - 04	10	MW	ACR	Amount - Currency	Numeric	Generic Edit	15	2
101	F76M572	A/P Header Withholding Summary Details - MEX - 04	8	WS	ACR	Amount - Currency	Numeric	Generic Edit	15	2
102	F76M573	PCG Detail Withholding Amounts - MEX - 04	12	WD	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP76P: Peru
103	F76P473T	F04573 Tag File - PER - 04 - 76P	10	K3	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP89: Conversion Programs
104	F05290T	Needed for upgrade from Xe to B9	3	JR	ACR	Amount - Currency	Numeric	Generic Edit	15	2
105	F06116T	Needed for upgrade from Xe to B9	7	YT	ACR	Amount - Currency	Numeric	Generic Edit	15	2
106	F06116TZ	Needed for upgrade from Xe to B9	8	VL	ACR	Amount - Currency	Numeric	Generic Edit	15	2
107	F0618T	Needed for upgrade from Xe to B9	7	YT	ACR	Amount - Currency	Numeric	Generic Edit	15	2
108	F063951T	Needed for upgrade from Xe to B9	3	GL	ACR	Amount - Currency	Numeric	Generic Edit	15	2

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

108 columns | 920 | ACR