	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

107 tables812 | 47

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
47: Electronic Commerce
1	812	F47002	SV	5	1	Flat File Cross-Reference Table	Constants Files	47: Electronic Commerce	AS400 Coexistence Tables
2	812	F47003	SX	18	1	EDI Discrepancy Report Work File	Regular Work Files	47: Electronic Commerce	AS400 Coexistence Tables
3	812	F47011	SY	165	1	EDI Purchase Order Header - Inbound	Batch Input Files	42B: Sales Order Entry	AS400 Coexistence Tables
4	812	F4701150	PH	9	1	EDI Purchase Order Header Commission Inbound	Files	42B: Sales Order Entry
5	812	F47012	SZ	252	1	EDI Purchase Order Detail - Inbound	Batch Input Files	42B: Sales Order Entry	AS400 Coexistence Tables
6	812	F4701260	PD	11	1	EDI Purchase Order Detail Commission Inbound	Files	42B: Sales Order Entry
7	812	F47013	SP	47	1	EDI Purchase Order Detail (SDQ) - Inbound	Batch Input Files	42B: Sales Order Entry	AS400 Coexistence Tables
8	812	F47016	SY	111	1	EDI Purchase Order Header - Outbound	Batch Input Files	43: Procurement	AS400 Coexistence Tables
9	812	F470161	S3	76	1	EDI Purchase Order Additional Header - Outbound	Batch Input Files	43: Procurement	AS400 Coexistence Tables
10	812	F47017	SZ	221	1	EDI Purchase Order Detail - Outbound	Batch Input Files	43: Procurement	AS400 Coexistence Tables
11	812	F470171	S4	57	1	EDI Purchase Order Additional Detail - Outbound	Batch Input Files	43: Procurement	AS400 Coexistence Tables
12	812	F47021	SY	110	1	EDI P.O. Acknowledgment Header - Inbound	Batch Input Files	43: Procurement	AS400 Coexistence Tables
13	812	F47022	SZ	221	1	EDI P.O. Acknowledgment Detail - Inbound	Batch Input Files	43: Procurement	AS400 Coexistence Tables
14	812	F47026	SY	143	1	EDI P.O. Acknowledgment Header - Outbound	Batch Input Files	42: Sales Management	AS400 Coexistence Tables
15	812	F47027	SZ	252	1	EDI P.O. Acknowledgment Detail - Outbound	Batch Input Files	42: Sales Management	AS400 Coexistence Tables
16	812	F47031	SY	105	1	EDI Shipping Notice Header - Inbound	Batch Input Files	43: Procurement	AS400 Coexistence Tables
17	812	F47032	SZ	175	1	EDI Shipping Notice Detail - Inbound	Batch Input Files	43: Procurement	AS400 Coexistence Tables
18	812	F47032T	SZ	31	1	EDI Shipping Notice Detail- Inbound Tag	Batch Input Files	43A: Purchase Order Receipt/Routing	Business Data
19	812	F47036	SY	81	2	EDI Shipping Notice Header - Outbound	Batch Input Files	49: Transportation Management	AS400 Coexistence Tables
20	812	F47037	SZ	213	1	EDI Shipping Notice Detail - Outbound	Batch Input Files	42: Sales Management	AS400 Coexistence Tables
21	812	F470371	SZ	252	4	EDI Shipping Notice Detail - Outbound	Batch Input Files	49: Transportation Management	No
22	812	F470372	AI	79	3	EDI ASN Demand Scheduling Detail	Files	47: Electronic Commerce
23	812	F470373	AG	66	2	EDI ASN Shipping	Files	47: Electronic Commerce
24	812	F470374	AM	39	1	EDI ASN Demand Addresses	Files	47: Electronic Commerce
25	812	F470375	AK	47	1	EDI ASN Packaging Detail	Files	47: Electronic Commerce
26	812	F47041	SY	65	1	EDI Invoice Header - Inbound	Batch Input Files	43: Procurement	AS400 Coexistence Tables
27	812	F47042	SZ	104	1	EDI Invoice Detail - Inbound	Batch Input Files	43: Procurement	AS400 Coexistence Tables
28	812	F47044	SW	55	1	EDI Invoice Summary - Inbound	Batch Input Files	43: Procurement	AS400 Coexistence Tables
29	812	F47046	SY	148	3	EDI Invoice Header (Sales) - Outbound	Batch Input Files	42: Sales Management	AS400 Coexistence Tables
30	812	F470461	S3	66	2	EDI Invoice Additional Header - Outbound	Batch Input Files	42: Sales Management	AS400 Coexistence Tables
31	812	F470462	S5	54	1	EDI Invoice Expanded Header (Sales)	Files	42: Sales Management
32	812	F47047	SZ	252	2	EDI Invoice Detail (Sales) - Outbound	Batch Input Files	42: Sales Management	AS400 Coexistence Tables
33	812	F470471	S4	49	1	EDI Invoice Additional Detail - Outbound	Batch Input Files	42: Sales Management	AS400 Coexistence Tables
34	812	F470472	S6	83	1	EDI Invoice Expanded Detail (Sales)	Files	42: Sales Management
35	812	F470473	S7	51	1	EDI Invoice Detail Charges	Files	42: Sales Management
36	812	F47056	D1	70	1	EDI Payment Order Header - Outbound	Batch Input Files	04: Accounts Payable	AS400 Coexistence Tables
37	812	F470561	D2	44	1	EDI Payment Order Bank N and A - Outbound	Batch Input Files	04: Accounts Payable	AS400 Coexistence Tables
38	812	F470561W	D2	44	1	EDI Payment Order Bank N and A - Work	Regular Work Files	04: Accounts Payable	AS400 Coexistence Tables
39	812	F470562	D4	44	1	EDI Payment Order Vendor N and A - Outbound	Batch Input Files	04: Accounts Payable	AS400 Coexistence Tables
40	812	F470562W	D4	44	1	EDI Payment Order Vendor N and A - Work	Regular Work Files	04: Accounts Payable	AS400 Coexistence Tables
41	812	F470563	D5	44	1	EDI Payment Order Payee N and A - Outbound	Batch Input Files	04: Accounts Payable	AS400 Coexistence Tables
42	812	F470563W	D5	44	1	EDI Payment Order Payee N and A - Work	Regular Work Files	04: Accounts Payable	AS400 Coexistence Tables
43	812	F47056W	D1	70	1	EDI Payment Order Header - Work	Regular Work Files	04: Accounts Payable	AS400 Coexistence Tables
44	812	F47057	D3	121	1	EDI Payment Order Remittance Advice - Outbound	Batch Input Files	04: Accounts Payable	AS400 Coexistence Tables
45	812	F47057W	D3	121	1	EDI Payment Order Remittance Advice - Work	Regular Work Files	04: Accounts Payable	AS400 Coexistence Tables
46	812	F4706	ZA	33	2	EDI Order Address Information	Transaction Files	47: Electronic Commerce	AS400 Coexistence Tables
47	812	F47061	MJ	41	1	EDI Planning Schedule Header - Inbound	Batch Input Files	34: Requirements Planning	AS400 Coexistence Tables
48	812	F47062	MY	38	1	EDI Planning Schedule Detail - Inbound	Batch Input Files	34: Requirements Planning	AS400 Coexistence Tables
49	812	F47066	MJ	41	1	EDI Planning Schedule Header - Outbound	Batch Input Files	34: Requirements Planning	AS400 Coexistence Tables
50	812	F47067	MY	38	1	EDI Planning Schedule Detail - Outbound	Batch Input Files	34: Requirements Planning	AS400 Coexistence Tables
51	812	F47071	SY	111	1	EDI Receiving Advice Header - Inbound	Batch Input Files	43: Procurement	AS400 Coexistence Tables
52	812	F47072	SZ	253	1	EDI Receiving Advice Detail - Inbound	Batch Input Files	43: Procurement	AS400 Coexistence Tables
53	812	F47076	SY	110	1	EDI Receiving Advice Header - Outbound	Batch Input Files	43: Procurement	AS400 Coexistence Tables
54	812	F47077	SZ	239	1	EDI Receiving Advice Detail - Outbound	Batch Input Files	43: Procurement	AS400 Coexistence Tables
55	812	F47081	FV	42	1	EDI Price Sales Catalog Header - Inbound	Batch Input Files	43: Procurement	Business Data
56	812	F47082	FY	87	1	EDI Price Sales Catalog Detail - Inbound	Batch Input Files	43: Procurement	Business Data
57	812	F47091	SY	140	1	EDI Request for Quote Header - Inbound	Batch Input Files	42B: Sales Order Entry	AS400 Coexistence Tables
58	812	F4709150	QH	9	1	EDI Request for Quote Header Commission - Inbound	Files	42B: Sales Order Entry
59	812	F47092	SZ	252	1	EDI Request for Quote Detail - Inbound	Batch Input Files	42B: Sales Order Entry	AS400 Coexistence Tables
60	812	F4709260	QD	11	1	EDI Request for Quote Detail Commission - Inbound	Files	42B: Sales Order Entry
61	812	F47093	SP	47	1	EDI Request for Quote Detail (SDQ) - Inbound	Batch Input Files	42B: Sales Order Entry	AS400 Coexistence Tables
62	812	F47096	SY	109	1	EDI Request for Quote Header - Outbound	Batch Input Files	43: Procurement	AS400 Coexistence Tables
63	812	F47097	SZ	221	1	EDI Request for Quote Detail - Outbound	Batch Input Files	43: Procurement	AS400 Coexistence Tables
64	812	F47098	SZ	22	1	EDI RFQ Detail Quantity - Outbound	Batch Input Files	43: Procurement	Business Data
65	812	F47101	SY	111	1	EDI Response to RFQ Header - Inbound	Batch Input Files	43: Procurement	AS400 Coexistence Tables
66	812	F47102	SZ	221	1	EDI Response to RFQ Detail - Inbound	Batch Input Files	43: Procurement	AS400 Coexistence Tables
67	812	F47103	SZ	22	1	EDI Response to RFQ Detail Quantity - Inbound	Batch Input Files	43: Procurement	Business Data
68	812	F47106	SY	143	1	EDI Response to RFQ Header - Outbound	Batch Input Files	42: Sales Management	AS400 Coexistence Tables
69	812	F471061	S3	66	1	EDI Response to RFQ Additional Header - Outbound	Batch Input Files	42: Sales Management	AS400 Coexistence Tables
70	812	F47107	SZ	252	1	EDI Response to RFQ Detail - Outbound	Batch Input Files	42: Sales Management	AS400 Coexistence Tables
71	812	F471071	S4	49	1	EDI Response to RFQ Additional Detail - Outbound	Batch Input Files	42: Sales Management	AS400 Coexistence Tables
72	812	F47111	Z1	26	2	EDI Lockbox/Payment Header - Transaction	Batch Input Files	03B: Enhanced Accounts Receivable	AS400 Coexistence Tables
73	812	F47112	Z2	37	1	EDI Lockbox Header - Transaction	Batch Input Files	03B: Enhanced Accounts Receivable	AS400 Coexistence Tables
74	812	F47113	Z3	40	1	EDI Lockbox/Payment Detail - Batch	Batch Input Files	03B: Enhanced Accounts Receivable	AS400 Coexistence Tables
75	812	F47114	Z4	45	1	EDI Lockbox/Payment Detail - Payment	Batch Input Files	03B: Enhanced Accounts Receivable	AS400 Coexistence Tables
76	812	F47121	M1	30	1	EDI Product Activity Data Header - Inbound	Batch Input Files	41: Inventory Management	AS400 Coexistence Tables
77	812	F47122	MJ	86	1	EDI Product Activity Data Detail - Inbound	Batch Input Files	41: Inventory Management	AS400 Coexistence Tables
78	812	F47123	MK	57	1	EDI Product Activity Data (SDQ) - Inbound	Batch Input Files	41: Inventory Management	AS400 Coexistence Tables
79	812	F47126	M1	30	1	EDI Product Activity Data Header - Outbound	Batch Input Files	41: Inventory Management	AS400 Coexistence Tables
80	812	F47127	MJ	88	1	EDI Product Activity Data Detail - Outbound	Batch Input Files	41: Inventory Management	AS400 Coexistence Tables
81	812	F47128	MK	57	1	EDI Product Activity Data (SDQ) - Outbound	Batch Input Files	41: Inventory Management	AS400 Coexistence Tables
82	812	F47131	SY	162	1	EDI Purchase Order Change Header - Inbound	Batch Input Files	42B: Sales Order Entry	AS400 Coexistence Tables
83	812	F4713150	CH	9	1	EDI Purchase Order Change Header Commission - Inbound	Files	42B: Sales Order Entry
84	812	F47132	SZ	253	1	EDI Purchase Order Change Detail - Inbound	Batch Input Files	42B: Sales Order Entry	AS400 Coexistence Tables
85	812	F4713260	PD	11	1	EDI Purchase Order Change Detail Commission - Inbound	Files	42B: Sales Order Entry
86	812	F47136	SY	111	1	EDI Purchase Order Change Header - Outbound	Batch Input Files	43: Procurement	AS400 Coexistence Tables
87	812	F47137	SZ	189	1	EDI Purchase Order Change Detail - Outbound	Batch Input Files	43: Procurement	AS400 Coexistence Tables
88	812	F4714	ZT	22	1	EDI Order Text Lines - Header	Extra Features Files	47: Electronic Commerce	AS400 Coexistence Tables
89	812	F47141	SY	111	1	EDI P.O. Change Acknowledgment Header - Inbound	Batch Input Files	43: Procurement	AS400 Coexistence Tables
90	812	F471411	SZ	15	1	Purchase Order Edit Object Log Table	Batch Input Files	43: Procurement	Business Data
91	812	F47142	SZ	223	1	EDI P.O. Change Acknowledgment Detail - Inbound	Batch Input Files	43: Procurement	AS400 Coexistence Tables
92	812	F47146	SY	143	1	EDI P.O. Change Acknowledgment Header - Outbound	Batch Input Files	42: Sales Management	AS400 Coexistence Tables
93	812	F47147	SZ	254	1	EDI P.O. Change Acknowledgment Detail - Outbound	Batch Input Files	42: Sales Management	AS400 Coexistence Tables
94	812	F4715	ZD	22	1	EDI Order Text Lines - Detail	Extra Features Files	47: Electronic Commerce	AS400 Coexistence Tables
95	812	F47156	SY	104	3	EDI Shipping Schedule Header - Outbound	Transaction Files	31: Shop Floor Control	No
96	812	F47157	SZ	218	2	EDI Shipping Schedule Detail - Outbound	Transaction Files	31: Shop Floor Control	No
97	812	F4716	SZ	30	1	EDI Item Text - Inbound/Outbound	Batch Input Files	43: Procurement	Business Data
98	812	F47191	AH	56	1	EDI Acknowledgement Header	Files	47: Electronic Commerce
99	812	F47192	AE	27	1	EDI Acknowledgement Error Detail	Files	47: Electronic Commerce	Business Data
100	812	F47194	AR	20	1	EDI Acknowledgement References	Files	47: Electronic Commerce	Business Data
101	812	F47196	AA	22	1	EDI Acknowledgement Name And Address	Files	47: Electronic Commerce	Business Data
102	812	F47198	AN	20	1	EDI Acknowledgement Notes	Files	47: Electronic Commerce	Business Data
103	812	F4722	PZ	11	1	EDI Tolerance Rules	Constants Files	47: Electronic Commerce	AS400 Coexistence Tables
104	812	F4780	AX	23	1	Address Cross-Reference	Extra Features Files	45: Advanced Pricing	No
105	812	F47CTL	Z5	29	1	EDI Lockbox/Payment Work File	Work Files	03B: Enhanced Accounts Receivable	No
106	812	F47HL	HL	18	1	Hierarchical Configuration	Secondary Master Files	49: Transportation Management	No
107	812	F47UI001	SZ	56	1	ASN Extract Work File	Batch Input Files	42: Sales Management	No

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

107 tables812 | 47