	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

33 tables812 | D3N

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
D3N: dcLINK (data collection) - DSI
1	812	FD3N0001	ZZ	10	2	dcLINK Xpress Check Out	Files	D3N: dcLINK (data collection) - DSI
2	812	FD3N0002	NN	6	1	Pallet Tracking Table 7	Files	D3N: dcLINK (data collection) - DSI
3	812	FD3N0012	RC	1	1	dcLINK Factivity Interface - Load Scrap Reason Codes Table	Files	D3N: dcLINK (data collection) - DSI
4	812	FD3N0013	LP	1	1	dcLINK Factivity Interface - Load Plant Table	Files	D3N: dcLINK (data collection) - DSI
5	812	FD3N0014	ED	2	2	dcLINK Factivity Interface - Load Employees Table	Files	D3N: dcLINK (data collection) - DSI
6	812	FD3N0015	LC	1	1	dcLINK Factivity Interface - Load Plant and Locations Table	Files	D3N: dcLINK (data collection) - DSI
7	812	FD3N0016	OE	5	1	dcLINK Factivity Interface - Order Envelope Table	Files	D3N: dcLINK (data collection) - DSI
8	812	FD3N0100	PT	12	1	Pattern Maintenance Header File	Files	D3N: dcLINK (data collection) - DSI
9	812	FD3N0101	PD	20	1	Pattern Maintenance Detail File	Files	D3N: dcLINK (data collection) - DSI
10	812	FD3N0200	JL	14	3	Employee Join/Leave Pattern History File	Files	D3N: dcLINK (data collection) - DSI
11	812	FD3N0201	ES	3	2	Employee Join/Leave Employee Selection Cache	Files	D3N: dcLINK (data collection) - DSI
12	812	FD3N0300	AP	8	1	Activate Pattern File	Files	D3N: dcLINK (data collection) - DSI
13	812	FD3N120L	FA	2	2	Fixed Asset Confirmation Transaction Counter	Files	D3N: dcLINK (data collection) - DSI	No
14	812	FD3N120P	FA	4	2	Post Report Table	Files	D3N: dcLINK (data collection) - DSI	No
15	812	FD3N120T	FA	3	1	Asset Number Work File	Files	D3N: dcLINK (data collection) - DSI	No
16	812	FD3N120W	FA	9	2	Asset Field Counts	Files	D3N: dcLINK (data collection) - DSI	No
17	812	FD3N120X	FA	3	2	Fixed Asset Confirmation Find/Browse	Files	D3N: dcLINK (data collection) - DSI	No
18	812	FD3N1601	PH	18	1	Pallet Tracking Table 1	Files	D3N: dcLINK (data collection) - DSI
19	812	FD3N1611	PD	14	1	Pallet Tracking Table 2	Files	D3N: dcLINK (data collection) - DSI
20	812	FD3N161P	PH	17	1	Pallet Tracking Table 4	Files	D3N: dcLINK (data collection) - DSI
21	812	FD3N4040	CH	8	1	Pallet Tracking Table 5	Files	D3N: dcLINK (data collection) - DSI
22	812	FD3N4041	CD	10	1	Pallet Tracking Table 6	Files	D3N: dcLINK (data collection) - DSI
23	812	FD3N4116	IR	56	1	dcLINK Interface - Inventory Reclassification	Files	D3N: dcLINK (data collection) - DSI
24	812	FD3N421P	SH	10	1	Pallet Tracking Table 3	Files	D3N: dcLINK (data collection) - DSI
25	812	FD3N4950	DC	22	1	dcLINK Delivery Confirmation Work File	Regular Work Files	D3N: dcLINK (data collection) - DSI
26	812	FD3N901	LP	8	2	TranPrint - TranPrint Transaction - Table	Files	D3N: dcLINK (data collection) - DSI	No
27	812	FD3N902	LE	8	2	TranPrint - TranPrint Error - Table	Files	D3N: dcLINK (data collection) - DSI	No
28	812	FD3N903	LP	9	2	TranPrint - Transaction By Script Variable - Table	Files	D3N: dcLINK (data collection) - DSI	No
29	812	FD3N904	LE	9	2	TranPrint - Error By Script Variable - Table	Files	D3N: dcLINK (data collection) - DSI	No
30	812	FD3N911	UC	16	1	dcLINK Interface - Cache UCC128 Numbers - Table	Files	D3N: dcLINK (data collection) - DSI	No
31	812	FD3N913	DL	11	2	TranPrint - Default Labels - Table	Files	D3N: dcLINK (data collection) - DSI	No
32	812	FD3N920	PQ	8	1	TranPrint - Print Queue	Files	D3N: dcLINK (data collection) - DSI
33	812	FD3N925	EH	8	1	TranPrint - Error Handling	Files	D3N: dcLINK (data collection) - DSI

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

33 tables812 | D3N