	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

146 columns | 910 | PTC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0014	Payment Terms	1	PN	PTC	Payment Terms Code	String	Generic Edit	3	0
2	F00141	Advanced Payment Terms	1	L3	PTC	Payment Terms Code	String	Generic Edit	3	0
3	F00144	Installment Payment Terms	1	L6	PTC	Payment Terms Code	String	Generic Edit	3	0
4	F004201	Prepayment Transaction Table	48	PT	PTC	Payment Terms Code	String	Generic Edit	3	0
TOP03: Accounts Receivable
5	F0311	Accounts Receivable Ledger	56	RP	PTC	Payment Terms Code	String	Generic Edit	3	0
TOP03B: Enhanced Accounts Receivable
6	F03B11	Customer Ledger	55	RP	PTC	Payment Terms Code	String	Generic Edit	3	0
7	F03B112	Invoice Revisions	47	RW	PTC	Payment Terms Code	String	Generic Edit	3	0
8	F03B112P	Invoice Revisions Purge File	47	RW	PTC	Payment Terms Code	String	Generic Edit	3	0
9	F03B11P	Customer Ledger Purge File	55	RP	PTC	Payment Terms Code	String	Generic Edit	3	0
10	F03B11Z1	Batch Invoices	72	VJ	PTC	Payment Terms Code	String	Generic Edit	3	0
11	F03B11Z2	F03B11 Interoperability Table	68	SY	PTC	Payment Terms Code	String	Generic Edit	3	0
12	F03B20	A/R Notification History	38	ZR	PTC	Payment Terms Code	String	Generic Edit	3	0
13	F03B21	A/R Notification History Detail	22	ZS	PTC	Payment Terms Code	String	Generic Edit	3	0
14	F03B22	A/R Fee Journal History	17	RS	PTC	Payment Terms Code	String	Generic Edit	3	0
15	F03B575	Auto Debit Invoice Select and Build	64	RD	PTC	Payment Terms Code	String	Generic Edit	3	0
TOP04: Accounts Payable
16	F0411	Accounts Payable Ledger	54	RP	PTC	Payment Terms Code	String	Generic Edit	3	0
17	F0411A	WF - As Of Accounts Payable Ledger	54	RP	PTC	Payment Terms Code	String	Generic Edit	3	0
18	F0411P	Purge - Accounts Payable Ledger	54	RP	PTC	Payment Terms Code	String	Generic Edit	3	0
19	F0411Z1	Voucher Transactions - Batch Upload	72	VL	PTC	Payment Terms Code	String	Generic Edit	3	0
20	F0411Z3	F0411 Interoperability Table	77	SZ	PTC	Payment Terms Code	String	Generic Edit	3	0
TOP07: Payroll
21	F06492	Payroll - Accounts Payable Control	7	JC	PTC	Payment Terms Code	String	Generic Edit	3	0
22	F07492	Payroll - Accounts Payable Control File	7	JC	PTC	Payment Terms Code	String	Generic Edit	3	0
TOP15: Property Management
23	F1511	Tenant/Lease Billings Detail	27	NJ	PTC	Payment Terms Code	String	Generic Edit	3	0
24	F1511B	Lease Billings Master	27	NJ	PTC	Payment Terms Code	String	Generic Edit	3	0
25	F1511H	Tenant/Lease Billings Detail History	27	N#	PTC	Payment Terms Code	String	Generic Edit	3	0
26	F1511HB	Lease Billings History	27	NC	PTC	Payment Terms Code	String	Generic Edit	3	0
27	F1525	A/R Fee Interest	34	N0	PTC	Payment Terms Code	String	Generic Edit	3	0
28	F1525B	Fees and Interest	31	NM	PTC	Payment Terms Code	String	Generic Edit	3	0
TOP17: Customer Service Management
29	F1720	Contract Header	31	CH	PTC	Payment Terms Code	String	Generic Edit	3	0
30	F1721	Contract Detail	95	CD	PTC	Payment Terms Code	String	Generic Edit	3	0
TOP17C: Call Management
31	F1755	Case Master	204	ZA	PTC	Payment Terms Code	String	Generic Edit	3	0
32	F1760	Time Entry	83	ZB	PTC	Payment Terms Code	String	Generic Edit	3	0
TOP40: Inventory/OP Base
33	F4001Z	Batch Receiver File - Order Headings	53	SY	PTC	Payment Terms Code	String	Generic Edit	3	0
34	F4011Z	Batch Receiver File - Order Details	103	SZ	PTC	Payment Terms Code	String	Generic Edit	3	0
35	F40301	Preference Profile - Payment Terms	12	PT	PTC	Payment Terms Code	String	Generic Edit	3	0
36	F40301R	Preference Resolution Ledger - Payment Terms	14	PT	PTC	Payment Terms Code	String	Generic Edit	3	0
37	F40338	Preference Profile - Payment Terms (Branch)	14	PT	PTC	Payment Terms Code	String	Generic Edit	3	0
38	F40338R	Preference Resolution Ledger - Payment Terms (Branch)	16	PT	PTC	Payment Terms Code	String	Generic Edit	3	0
39	F4201Z1	Sales Order Header Unedited Transaction File	42	SY	PTC	Payment Terms Code	String	Generic Edit	3	0
40	F4211Z1	Sales Order Detail Unedited Transaction File	100	SZ	PTC	Payment Terms Code	String	Generic Edit	3	0
41	F49211	Sales Order Detail File - Tag File	55	UD	PTC	Payment Terms Code	String	Generic Edit	3	0
42	F49211Z1	Sales Order Detail Tag Unedited Transaction File	68	S1	PTC	Payment Terms Code	String	Generic Edit	3	0
43	F49219	Sales Order Detail - Tag History File	55	UD	PTC	Payment Terms Code	String	Generic Edit	3	0
TOP42: Sales Management
44	F4201	Sales Order Header File	29	SH	PTC	Payment Terms Code	String	Generic Edit	3	0
45	F42019	Sales Order Header History File	29	SH	PTC	Payment Terms Code	String	Generic Edit	3	0
46	F4211	Sales Order Detail File	87	SD	PTC	Payment Terms Code	String	Generic Edit	3	0
47	F42119	Sales Order History File	87	SD	PTC	Payment Terms Code	String	Generic Edit	3	0
48	F42199	S.O. Detail Ledger File	87	SL	PTC	Payment Terms Code	String	Generic Edit	3	0
49	F42565	Invoice Print File	65	IW	PTC	Payment Terms Code	String	Generic Edit	3	0
50	F42UI01	SO Header Cache File (MBF)	34	ZH	PTC	Payment Terms Code	String	Generic Edit	3	0
51	F42UI12	Sales Order Detail Cache 2 (MBF)	26	ZD	PTC	Payment Terms Code	String	Generic Edit	3	0
52	F42UI520	Pick Slips Header File	31	S8	PTC	Payment Terms Code	String	Generic Edit	3	0
53	F42UI521	Pick Slips Detail File	80	S9	PTC	Payment Terms Code	String	Generic Edit	3	0
TOP42B: Sales Order Entry
54	F42420	Audit Log Transaction	61	AL	PTC	Payment Terms Code	String	Generic Edit	3	0
55	F49299	S.O. Detail Tag Ledger File	55	UD	PTC	Payment Terms Code	String	Generic Edit	3	0
TOP43: Procurement
56	F4301	Purchase Order Header	32	PH	PTC	Payment Terms Code	String	Generic Edit	3	0
57	F4301Z	PO Header Work File	36	PA	PTC	Payment Terms Code	String	Generic Edit	3	0
58	F4301Z1	Purchase Order Header Unedited Transaction Table	45	SY	PTC	Payment Terms Code	String	Generic Edit	3	0
59	F43080	Approvals Fields Constants	9	PD	PTC	Payment Terms Code	String	Generic Edit	3	0
60	F4311	Purchase Order Detail File	87	PD	PTC	Payment Terms Code	String	Generic Edit	3	0
61	F4311Z	Purchase Order Generator File	91	PW	PTC	Payment Terms Code	String	Generic Edit	3	0
62	F4311Z1	Purchase Order Detail Unedited Transaction Table	100	SZ	PTC	Payment Terms Code	String	Generic Edit	3	0
63	F43121	Purchase Order Receiver File	33	PR	PTC	Payment Terms Code	String	Generic Edit	3	0
64	F43121Z	Receiver workfile	76	PW	PTC	Payment Terms Code	String	Generic Edit	3	0
65	F43121Z1	Receipts Unedited Transaction Table	50	SZ	PTC	Payment Terms Code	String	Generic Edit	3	0
66	F4314Z	Voucher Match Selection File	132	PN	PTC	Payment Terms Code	String	Generic Edit	3	0
67	F43199	P.O. Detail Ledger File - Flexible Version	87	OL	PTC	Payment Terms Code	String	Generic Edit	3	0
68	F43UI50D	PO Print Detail Work File	55	PW	PTC	Payment Terms Code	String	Generic Edit	3	0
69	F43UI50H	PO Print Header Work File	35	PA	PTC	Payment Terms Code	String	Generic Edit	3	0
TOP43C: Contracts
70	F43C01	Contract Header	10	CH	PTC	Payment Terms Code	String	Generic Edit	3	0
71	F43C10	Contract Block	17	CB	PTC	Payment Terms Code	String	Generic Edit	3	0
72	F43C11	Contract Detail	29	CD	PTC	Payment Terms Code	String	Generic Edit	3	0
73	F43C20	Contract Payee	6	CP	PTC	Payment Terms Code	String	Generic Edit	3	0
TOP43Q: Strategic Sourcing
74	F43Q10	Event Header	13	EH	PTC	Payment Terms Code	String	Generic Edit	3	0
75	F43Q50	Analyze Event Header	25	AV	PTC	Payment Terms Code	String	Generic Edit	3	0
TOP44H: Homebuilder Management
76	F44H601	Bid Header	35	BH	PTC	Payment Terms Code	String	Generic Edit	3	0
77	F44H611	Bid Details	52	BD	PTC	Payment Terms Code	String	Generic Edit	3	0
78	F44H611W	Bid Details Work File	56	BW	PTC	Payment Terms Code	String	Generic Edit	3	0
79	F44H711	Lot Start Workfile	59	SW	PTC	Payment Terms Code	String	Generic Edit	3	0
80	F44H711Z	HB Lot Start Unedited Transaction File	72	SZ	PTC	Payment Terms Code	String	Generic Edit	3	0
81	F44H71W1	Lot Start Generation Workfile	59	GW	PTC	Payment Terms Code	String	Generic Edit	3	0
82	F44H73W1	Lot Start - P.O. / Committment Generation Work File	32	CG	PTC	Payment Terms Code	String	Generic Edit	3	0
TOP45: Advanced Pricing
83	F45520	Price List Header	12	PH	PTC	Payment Terms Code	String	Generic Edit	3	0
TOP47: Electronic Commerce
84	F47011	EDI Purchase Order Header - Inbound	48	SY	PTC	Payment Terms Code	String	Generic Edit	3	0
85	F47012	EDI Purchase Order Detail - Inbound	104	SZ	PTC	Payment Terms Code	String	Generic Edit	3	0
86	F47016	EDI Purchase Order Header - Outbound	47	SY	PTC	Payment Terms Code	String	Generic Edit	3	0
87	F47017	EDI Purchase Order Detail - Outbound	101	SZ	PTC	Payment Terms Code	String	Generic Edit	3	0
88	F47021	EDI P.O. Acknowledgment Header - Inbound	47	SY	PTC	Payment Terms Code	String	Generic Edit	3	0
89	F47022	EDI P.O. Acknowledgment Detail - Inbound	101	SZ	PTC	Payment Terms Code	String	Generic Edit	3	0
90	F47026	EDI P.O. Acknowledgment Header - Outbound	44	SY	PTC	Payment Terms Code	String	Generic Edit	3	0
91	F47027	EDI P.O. Acknowledgment Detail - Outbound	104	SZ	PTC	Payment Terms Code	String	Generic Edit	3	0
92	F47031	EDI Shipping Notice Header - Inbound	42	SY	PTC	Payment Terms Code	String	Generic Edit	3	0
93	F47032	EDI Shipping Notice Detail - Inbound	72	SZ	PTC	Payment Terms Code	String	Generic Edit	3	0
94	F47037	EDI Shipping Notice Detail - Outbound	99	SZ	PTC	Payment Terms Code	String	Generic Edit	3	0
95	F470371	EDI Shipping Notice Detail - Outbound	110	SZ	PTC	Payment Terms Code	String	Generic Edit	3	0
96	F47041	EDI Invoice Header - Inbound	37	SY	PTC	Payment Terms Code	String	Generic Edit	3	0
97	F47042	EDI Invoice Detail - Inbound	83	SZ	PTC	Payment Terms Code	String	Generic Edit	3	0
98	F47046	EDI Invoice Header (Sales) - Outbound	44	SY	PTC	Payment Terms Code	String	Generic Edit	3	0
99	F47047	EDI Invoice Detail (Sales) - Outbound	104	SZ	PTC	Payment Terms Code	String	Generic Edit	3	0
100	F47057	EDI Payment Order Remittance Advice - Outbound	83	D3	PTC	Payment Terms Code	String	Generic Edit	3	0
101	F47057W	EDI Payment Order Remittance Advice - Work	83	D3	PTC	Payment Terms Code	String	Generic Edit	3	0
102	F47071	EDI Receiving Advice Header - Inbound	48	SY	PTC	Payment Terms Code	String	Generic Edit	3	0
103	F47072	EDI Receiving Advice Detail - Inbound	102	SZ	PTC	Payment Terms Code	String	Generic Edit	3	0
104	F47076	EDI Receiving Advice Header - Outbound	48	SY	PTC	Payment Terms Code	String	Generic Edit	3	0
105	F47077	EDI Receiving Advice Detail - Outbound	102	SZ	PTC	Payment Terms Code	String	Generic Edit	3	0
106	F47091	EDI Request for Quote Header - Inbound	48	SY	PTC	Payment Terms Code	String	Generic Edit	3	0
107	F47092	EDI Request for Quote Detail - Inbound	104	SZ	PTC	Payment Terms Code	String	Generic Edit	3	0
108	F47096	EDI Request for Quote Header - Outbound	47	SY	PTC	Payment Terms Code	String	Generic Edit	3	0
109	F47097	EDI Request for Quote Detail - Outbound	101	SZ	PTC	Payment Terms Code	String	Generic Edit	3	0
110	F47101	EDI Response to RFQ Header - Inbound	47	SY	PTC	Payment Terms Code	String	Generic Edit	3	0
111	F47102	EDI Response to RFQ Detail - Inbound	101	SZ	PTC	Payment Terms Code	String	Generic Edit	3	0
112	F47106	EDI Response to RFQ Header - Outbound	44	SY	PTC	Payment Terms Code	String	Generic Edit	3	0
113	F47107	EDI Response to RFQ Detail - Outbound	104	SZ	PTC	Payment Terms Code	String	Generic Edit	3	0
114	F47131	EDI Purchase Order Change Header - Inbound	45	SY	PTC	Payment Terms Code	String	Generic Edit	3	0
115	F47132	EDI Purchase Order Change Detail - Inbound	105	SZ	PTC	Payment Terms Code	String	Generic Edit	3	0
116	F47136	EDI Purchase Order Change Header - Outbound	47	SY	PTC	Payment Terms Code	String	Generic Edit	3	0
117	F47137	EDI Purchase Order Change Detail - Outbound	102	SZ	PTC	Payment Terms Code	String	Generic Edit	3	0
118	F47141	EDI P.O. Change Acknowledgment Header - Inbound	48	SY	PTC	Payment Terms Code	String	Generic Edit	3	0
119	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	103	SZ	PTC	Payment Terms Code	String	Generic Edit	3	0
120	F47146	EDI P.O. Change Acknowledgment Header - Outbound	45	SY	PTC	Payment Terms Code	String	Generic Edit	3	0
121	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	106	SZ	PTC	Payment Terms Code	String	Generic Edit	3	0
122	F47156	EDI Shipping Schedule Header - Outbound	50	SY	PTC	Payment Terms Code	String	Generic Edit	3	0
123	F47157	EDI Shipping Schedule Detail - Outbound	108	SZ	PTC	Payment Terms Code	String	Generic Edit	3	0
TOP48S: Service Billing
124	F4822	Invoice Summary Work File	16	W4	PTC	Payment Terms Code	String	Generic Edit	3	0
125	F4823	Voucher Summary	14	W0	PTC	Payment Terms Code	String	Generic Edit	3	0
TOP52: Contract Billing
126	F5201	Contract Master	40	G4	PTC	Payment Terms Code	String	Generic Edit	3	0
TOP52G: Government Contracting
127	F4822H	Invoice Summary History	16	IH	PTC	Payment Terms Code	String	Generic Edit	3	0
128	F52G01M	Project and Government Contract Modifications	45	CM	PTC	Payment Terms Code	String	Generic Edit	3	0
TOP55: Reserved for Clients
129	F74H1050	Invoicing Workfile Header - New	12	IH	PTC	Payment Terms Code	String	Generic Edit	3	0
TOP70: Multi-National Products - obsolete-do not reuse
130	F702033	Sales Document Line Tag File - COMM - 42	12	D1	PTC	Payment Terms Code	String	Generic Edit	3	0
TOP74: EMEA Localization
131	F7430030	Legal Document Header (Print Info) - COMM - 03B	6	PI	PTC	Payment Terms Code	String	Generic Edit	3	0
132	F74900	Foreign Receivables and Payables - EMEA	62	RP	PTC	Payment Terms Code	String	Generic Edit	3	0
TOP74U: United Kingdom Localizations
133	F74U0405	SPC Certificate Holding Table - UK - 43	14	CH	PTC	Payment Terms Code	String	Generic Edit	3	0
134	F74U0420	SPC - Application Master - UK - 43	35	SE	PTC	Payment Terms Code	String	Generic Edit	3	0
135	F74U0425	SPC - Certificate Master - UK - 43	37	SF	PTC	Payment Terms Code	String	Generic Edit	3	0
TOP75I: India
136	F75I10A	TDS Rate Maintenance File	10	QA	PTC	Payment Terms Code	String	Generic Edit	3	0
137	F75I15A	TDS Document Company Maintenance File	9	QC	PTC	Payment Terms Code	String	Generic Edit	3	0
TOP76A: Argentina
138	F76A21	Credit Invoice Header - F76A21 - ARG - 3B - 76A	17	IH	PTC	Payment Terms Code	String	Generic Edit	3	0
139	F76A21P	Credit Invoice Header Purge - ARG - 03B - 76A	17	IH	PTC	Payment Terms Code	String	Generic Edit	3	0
140	F76AUI51	Credit Invoice - Create PGC Error and Wrn - ARG - 04 - 76A	8	IK	PTC	Payment Terms Code	String	Generic Edit	3	0
TOP76B: Brazil - Reporting System Only
141	F76B0401	Tax Code - 04	18	CT	PTC	Payment Terms Code	String	Generic Edit	3	0
142	F76B406	Taxes Setup by City Code - BR - 04	3	TS	PTC	Payment Terms Code	String	Generic Edit	3	0
143	F76B473T	F04573 Brazilian Temp WH File - BR - 04	26	W3	PTC	Payment Terms Code	String	Generic Edit	3	0
TOP76C: Colombia
144	F76C031A	A/R Customer ledger As Of - F76C031A - COL - 04	54	RP	PTC	Payment Terms Code	String	Generic Edit	3	0
TOP76H: Chile
145	F76H3B31	Legal Document Header (Print Info) - CHI - 03B - 76H	4	PI	PTC	Payment Terms Code	String	Generic Edit	3	0
TOP89: Conversion Programs
146	F43199A	Temp F43199 for ERP 9.0 Upgrade	87	OL	PTC	Payment Terms Code	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

146 columns | 910 | PTC