	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

45 tables812 | 03B

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
03B: Enhanced Accounts Receivable
1	812	F03B08	RD	13	2	Credit/Collection Date Pattern	Constants Files	03B: Enhanced Accounts Receivable	No
2	812	F03B11	RP	157	24	Customer Ledger	Transaction Files	03B: Enhanced Accounts Receivable	AS400 Coexistence Tables
3	812	F03B112	RW	67	5	Invoice Revisions	Balance Files	03B: Enhanced Accounts Receivable	AS400 Coexistence Tables
4	812	F03B112P	RW	67	1	Invoice Revisions Purge File	Purge Files	03B: Enhanced Accounts Receivable	No
5	812	F03B11P	RP	157	1	Customer Ledger Purge File	Purge Files	03B: Enhanced Accounts Receivable	AS400 Coexistence Tables
6	812	F03B11Z1	VJ	202	1	Invoice Transactions - Batch File	Batch Input Files	03B: Enhanced Accounts Receivable	AS400 Coexistence Tables
7	812	F03B11Z2	SY	171	2	F03B11 Interoperability Table	Batch Input Files	03B: Enhanced Accounts Receivable	No
8	812	F03B13	RY	97	10	Receipts Header File	Transaction Files	03B: Enhanced Accounts Receivable	AS400 Coexistence Tables
9	812	F03B13P	RY	97	1	Receipts Header Purge File	Purge Files	03B: Enhanced Accounts Receivable	AS400 Coexistence Tables
10	812	F03B13Z1	RU	43	5	Electronic Receipts Input	Batch Input Files	03B: Enhanced Accounts Receivable	No
11	812	F03B13Z2	SY	110	2	F03B13 Interoperability Table	Batch Input Files	03B: Enhanced Accounts Receivable	No
12	812	F03B14	RZ	135	16	A/R Check Detail File	Transaction Files	03B: Enhanced Accounts Receivable	AS400 Coexistence Tables
13	812	F03B14P	RZ	135	1	Receipts Detail Purge File	Purge Files	03B: Enhanced Accounts Receivable	AS400 Coexistence Tables
14	812	F03B14Z2	SZ	149	2	F03B14 Interoperability Table	Batch Input Files	03B: Enhanced Accounts Receivable	No
15	812	F03B15	RT	56	2	Credit and Cash Management	Regular Work Files	03B: Enhanced Accounts Receivable	No
16	812	F03B16	RV	58	4	A/R Statistical History	History Files	03B: Enhanced Accounts Receivable	No
17	812	F03B16S	RS	47	2	A/R Statistical Summary	History Files	03B: Enhanced Accounts Receivable	No
18	812	F03B20	ZR	62	4	A/R Notification History	History Files	03B: Enhanced Accounts Receivable	No
19	812	F03B21	ZS	63	2	A/R Notification History Detail	History Files	03B: Enhanced Accounts Receivable	No
20	812	F03B22	RS	33	1	A/R Fee Journal History	History Files	03B: Enhanced Accounts Receivable	AS400 Coexistence Tables
21	812	F03B23	RT	24	1	A/R Fee Journal History Detail	History Files	03B: Enhanced Accounts Receivable	AS400 Coexistence Tables
22	812	F03B25	RF	12	2	A/R Delinquency Policy Table	Constants Files	03B: Enhanced Accounts Receivable	No
23	812	F03B26	RL	24	2	A/R Delinquency Policy Notification	Constants Files	03B: Enhanced Accounts Receivable	No
24	812	F03B27	RM	25	1	A/R Delinquency Policy Detail - Fees	Constants Files	03B: Enhanced Accounts Receivable	AS400 Coexistence Tables
25	812	F03B28	RJ	9	1	Letter Text Table	Constants Files	03B: Enhanced Accounts Receivable	AS400 Coexistence Tables
26	812	F03B29	IP	19	3	Credit Insurance Table	Secondary Master Files	03B: Enhanced Accounts Receivable	No
27	812	F03B30	ZI	9	1	Activity Type Master	Constants Files	03B: Enhanced Accounts Receivable	AS400 Coexistence Tables
28	812	F03B31	ZG	15	5	Customer Activity Log	Transaction Files	03B: Enhanced Accounts Receivable	AS400 Coexistence Tables
29	812	F03B40	RB	38	2	A/R Deduction Management	Transaction Files	03B: Enhanced Accounts Receivable	No
30	812	F03B40T	RB			A/R Deduction Management Tag	Files	03B: Enhanced Accounts Receivable
31	812	F03B41	RC	23	2	A/R Deduction Activity	Transaction Files	03B: Enhanced Accounts Receivable	No
32	812	F03B41Z1	SZ	31	2	Inteoperability - Deductions Management	Files	03B: Enhanced Accounts Receivable	No
33	812	F03B42	RD	14	1	Deductions Activity Master	Master Files	03B: Enhanced Accounts Receivable	No
34	812	F03B465	RO	55	1	A/R Netting Workfile	Work Files	03B: Enhanced Accounts Receivable	No
35	812	F03B50	RE	10	1	Receipt Application Algorithm Execution Lists	Secondary Master Files	03B: Enhanced Accounts Receivable	AS400 Coexistence Tables
36	812	F03B571	RC	35	1	Auto Debit Batch Control	Transaction Files	03B: Enhanced Accounts Receivable	No
37	812	F03B575	RD	144	1	Auto Debit Invoice Select and Build	Transaction Files	03B: Enhanced Accounts Receivable	No
38	812	F03B57OW	RE	5	1	Auto Debit Standard Formatted Tape File	Transaction Files	03B: Enhanced Accounts Receivable	No
39	812	F03B672	RD	80	3	Draft Remittance Work File - One World Only	Transaction Files	03B: Enhanced Accounts Receivable	No
40	812	F03B67OW	RE	6	1	Drafts Standard Formatted Tape File	Transaction Files	03B: Enhanced Accounts Receivable	No
41	812	F03B920	ZC	2	1	Credit Reporting Tape - TRW	Extra Features Files	03B: Enhanced Accounts Receivable	No
42	812	F03B920C	ZD	2	1	Create Credit Reporting Tape - Creditel	Extra Features Files	03B: Enhanced Accounts Receivable	No
43	812	F03BUI04	W3	10	1	Work File for Integrity by Offset Account	Regular Work Files	03B: Enhanced Accounts Receivable	No
44	812	F03BUI05	R5	4	1	Auto Receipts Batch Workfile	Regular Work Files	03B: Enhanced Accounts Receivable	No
45	812	F09UI011	GL	41	1	Receipt Prepost Work File	Regular Work Files	03B: Enhanced Accounts Receivable	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

45 tables812 | 03B