	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

60 tables920 | 03B

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
03B: Enhanced Accounts Receivable
1	920	F00171	NC	4	1	Interoperability-Net Change Table	Files	03B: Enhanced Accounts Receivable
2	920	F007101	TA	20	1	Text Processor Header	Transaction Files	03B: Enhanced Accounts Receivable	Business Data
3	920	F007111	TB	14	2	Text Processor Detail Table	Transaction Files	03B: Enhanced Accounts Receivable	Business Data
4	920	F03012T	AT	10	2	Customer Master by Line of Business Tag Table	Constants Files	01: Address Book
5	920	F03B08	RD	13	2	Credit/Collection Date Pattern	Constants Files	03B: Enhanced Accounts Receivable	Business Data
6	920	F03B11	RP	157	24	Customer Ledger	Transaction Files	03B: Enhanced Accounts Receivable	Business Data
7	920	F03B112	RW	67	5	Invoice Revisions	Balance Files	03B: Enhanced Accounts Receivable	Business Data
8	920	F03B112P	RW	67	1	Invoice Revisions Purge File	Purge Files	03B: Enhanced Accounts Receivable	Business Data
9	920	F03B116	RK	27	1	Revenue Recognition Invoice	Files	03B: Enhanced Accounts Receivable
10	920	F03B117	RL	82	5	Revenue Recognition GL Info	Files	03B: Enhanced Accounts Receivable
11	920	F03B118	RM	28	1	Revenue Recognition Invoice Audit	Files	03B: Enhanced Accounts Receivable
12	920	F03B119	RN	83	1	Revenue Recognition GL Info Audit	Files	03B: Enhanced Accounts Receivable
13	920	F03B11P	RP	157	1	Customer Ledger Purge File	Purge Files	03B: Enhanced Accounts Receivable	Business Data
14	920	F03B11SW	CS	11	1	Customer Ledger Summary Work Table	Files	03B: Enhanced Accounts Receivable
15	920	F03B11T	TK	9	1	Customer Ledger Tag Table	Files	03B: Enhanced Accounts Receivable
16	920	F03B11Z1	VJ	202	1	Batch Invoices	Batch Input Files	03B: Enhanced Accounts Receivable	Business Data
17	920	F03B11Z2	SY	171	2	F03B11 Interoperability Table	Batch Input Files	03B: Enhanced Accounts Receivable	Business Data
18	920	F03B13	RY	97	10	Receipts Header	Transaction Files	03B: Enhanced Accounts Receivable	Business Data
19	920	F03B13P	RY	97	1	Receipts Header Purge File	Purge Files	03B: Enhanced Accounts Receivable	Business Data
20	920	F03B13Z1	RU	43	5	Electronic Receipts Input	Batch Input Files	03B: Enhanced Accounts Receivable	Business Data
21	920	F03B13Z2	SY	110	2	F03B13 Interoperability Table	Batch Input Files	03B: Enhanced Accounts Receivable	Business Data
22	920	F03B14	RZ	135	17	Receipts Detail	Transaction Files	03B: Enhanced Accounts Receivable	Business Data
23	920	F03B14P	RZ	135	1	Receipts Detail Purge File	Purge Files	03B: Enhanced Accounts Receivable	Business Data
24	920	F03B14Z2	SZ	149	2	F03B14 Interoperability Table	Batch Input Files	03B: Enhanced Accounts Receivable	Business Data
25	920	F03B15	RT	56	2	Credit and Cash Management	Regular Work Files	03B: Enhanced Accounts Receivable	Business Data
26	920	F03B15T	RT	34	2	F03B15 Tag Table	Regular Work Files	03B: Enhanced Accounts Receivable
27	920	F03B16	RV	58	4	A/R Statistical History	History Files	03B: Enhanced Accounts Receivable	Business Data
28	920	F03B16S	RS	47	2	A/R Statistical Summary	History Files	03B: Enhanced Accounts Receivable	Business Data
29	920	F03B20	ZR	62	4	A/R Notification History	History Files	03B: Enhanced Accounts Receivable	Business Data
30	920	F03B21	ZS	63	2	A/R Notification History Detail	History Files	03B: Enhanced Accounts Receivable	Business Data
31	920	F03B22	RS	33	1	A/R Fee Journal History	History Files	03B: Enhanced Accounts Receivable	Business Data
32	920	F03B23	RT	24	1	A/R Fee Journal History Detail	History Files	03B: Enhanced Accounts Receivable	Business Data
33	920	F03B25	RF	12	2	Delinquency Policy	Constants Files	03B: Enhanced Accounts Receivable	Business Data
34	920	F03B26	RL	24	2	A/R Delinquency Policy Notification	Constants Files	03B: Enhanced Accounts Receivable	Business Data
35	920	F03B27	RM	25	1	A/R Delinquency Policy Detail - Fees	Constants Files	03B: Enhanced Accounts Receivable	Business Data
36	920	F03B28	RJ	9	1	Letter Text	Constants Files	03B: Enhanced Accounts Receivable	Business Data
37	920	F03B29	IP	19	3	Credit Insurance	Secondary Master Files	03B: Enhanced Accounts Receivable	Business Data
38	920	F03B30	ZI	9	1	Activity Type Master	Constants Files	03B: Enhanced Accounts Receivable	Business Data
39	920	F03B31	ZG	15	5	Customer Activity Log	Transaction Files	03B: Enhanced Accounts Receivable	Business Data
40	920	F03B40	RB	39	2	A/R Deduction Management	Transaction Files	03B: Enhanced Accounts Receivable	Business Data
41	920	F03B40T	RB	2	1	A/R Deduction Management Tag	Files	03B: Enhanced Accounts Receivable
42	920	F03B41	RC	23	2	A/R Deduction Activity	Transaction Files	03B: Enhanced Accounts Receivable	Business Data
43	920	F03B41Z1	SZ	31	2	Inteoperability - Deductions Management	Files	03B: Enhanced Accounts Receivable	Business Data
44	920	F03B42	RD	14	1	Deductions Activity Master	Master Files	03B: Enhanced Accounts Receivable	Business Data
45	920	F03B424	TK	12	1	Invoice Trigger Hierarchy	Files	03B: Enhanced Accounts Receivable
46	920	F03B425	TK	8	1	InvoiceTrigger Date	Files	03B: Enhanced Accounts Receivable
47	920	F03B426	TK	17	1	Invoice Trigger Configuration	Files	03B: Enhanced Accounts Receivable
48	920	F03B465	RO	55	1	A/R Netting Workfile	Work Files	03B: Enhanced Accounts Receivable	Business Data
49	920	F03B50	RE	10	1	Receipt Application Algorithm Execution Lists	Secondary Master Files	03B: Enhanced Accounts Receivable	Business Data
50	920	F03B571	RC	35	1	Auto Debit Batch Control	Transaction Files	03B: Enhanced Accounts Receivable	Business Data
51	920	F03B575	RD	144	1	Auto Debit Invoice Select and Build	Transaction Files	03B: Enhanced Accounts Receivable	Business Data
52	920	F03B57OW	RE	5	1	Auto Debit Standard Formatted Tape File	Transaction Files	03B: Enhanced Accounts Receivable	Business Data
53	920	F03B672	RD	80	3	Draft Remittance	Transaction Files	03B: Enhanced Accounts Receivable	Business Data
54	920	F03B67OW	RE	6	1	Drafts Standard Formatted Tape File	Transaction Files	03B: Enhanced Accounts Receivable	Business Data
55	920	F03B920	ZC	2	1	Credit Reporting Tape - Experian	Extra Features Files	03B: Enhanced Accounts Receivable	Business Data
56	920	F03B920C	ZD	2	1	Credit Reporting Tape - Creditel	Extra Features Files	03B: Enhanced Accounts Receivable	Business Data
57	920	F03BUI04	W3	10	1	Work File for Integrity by Offset Account	Regular Work Files	03B: Enhanced Accounts Receivable	Business Data
58	920	F03BUI05	R5	4	1	Auto Receipts Batch Workfile	Regular Work Files	03B: Enhanced Accounts Receivable	Business Data
59	920	F09UI011	GL	52	1	Receipt Prepost Work File	Regular Work Files	03B: Enhanced Accounts Receivable	Business Data
60	920	F74W300	RU	4	1	A/R Fee Journal History Detail Tag File	Files	03B: Enhanced Accounts Receivable

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

60 tables920 | 03B