	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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

162 columns | 812 | LOTN

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP12: Fixed Assets
1	F1217	Equipment Master Extension	53	WR	LOTN	Lot/Serial Number	String	Generic Edit	30	0
2	F1217P	Equipment Master Extension Purge Table	53	WR	LOTN	Lot/Serial Number	String	Generic Edit	30	0
3	F1217Z1	Unedited Equipment Tag Transactions	57	WR	LOTN	Lot/Serial Number	String	Generic Edit	30	0
4	F1217Z2	Unedited Equipment Tag Transactions	57	WR	LOTN	Lot/Serial Number	String	Generic Edit	30	0
TOP13: Plant/Equipment Management
5	F13017	Equipment Parts List	10	PL	LOTN	Lot/Serial Number	String	Generic Edit	30	0
TOP17: Customer Service Management
6	F1721	Contract Detail	42	CD	LOTN	Lot/Serial Number	String	Generic Edit	30	0
7	F3111Z2	Warranty Claim/Supplier Recovery processing	47	WP	LOTN	Lot/Serial Number	String	Generic Edit	30	0
8	F4801Z2	Warranty Claim/Supplier Recovery processing	108	WS	LOTN	Lot/Serial Number	String	Generic Edit	30	0
TOP17C: Call Management
9	F1755	Customer Call Master	73	ZA	LOTN	Lot/Serial Number	String	Generic Edit	30	0
TOP30: Product Data Management
10	F300211	Lean Multi Level Bill of Material Detail	62	ED	LOTN	Lot/Serial Number	String	Generic Edit	30	0
TOP30A: Product Costing
11	F300261	Item Cost Component Detail	6	IE	LOTN	Lot/Serial Number	String	Generic Edit	30	0
TOP31: Shop Floor Control
12	F30161Z1	Inbound Kanban Card Detail	20	SZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
13	F3105	Work Order LSN	5	IS	LOTN	Lot/Serial Number	String	Generic Edit	30	0
14	F3105S	Purge Work Order LSN	5	IS	LOTN	Lot/Serial Number	String	Generic Edit	30	0
15	F3111	Work Order Parts List	34	WM	LOTN	Lot/Serial Number	String	Generic Edit	30	0
16	F3111S	Purge - Shop Floor Parts List	34	WM	LOTN	Lot/Serial Number	String	Generic Edit	30	0
17	F3111Z1	Outbound Work Order Parts List	47	SZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
18	F4801S	Purge - Work Order Master file	89	WA	LOTN	Lot/Serial Number	String	Generic Edit	30	0
19	F4801Z1	Outbound Work Order Header	108	SY	LOTN	Lot/Serial Number	String	Generic Edit	30	0
TOP31B: Blend Management
20	F31B053	Consumable Assignments	10	CA	LOTN	Lot/Serial Number	String	Generic Edit	30	0
21	F31B07	EUR Master File	42	EU	LOTN	Lot/Serial Number	String	Generic Edit	30	0
22	F31B66	Blend Transactions	57	BT	LOTN	Lot/Serial Number	String	Generic Edit	30	0
23	F31B84	Operation Additives	13	OA	LOTN	Lot/Serial Number	String	Generic Edit	30	0
24	F31B85	Weigh Tag Master	39	WT	LOTN	Lot/Serial Number	String	Generic Edit	30	0
25	F31B85T	Weigh Tag Master Tag Table	7	WT	LOTN	Lot/Serial Number	String	Generic Edit	30	0
26	F31B98	Bottling Master	6	BM	LOTN	Lot/Serial Number	String	Generic Edit	30	0
27	F31B99	Decant Detail	7	DD	LOTN	Lot/Serial Number	String	Generic Edit	30	0
TOP32: Configuration Management
28	F3215	Configurator Component Table	18	CC	LOTN	Lot/Serial Number	String	Generic Edit	30	0
29	F32159	Configurator Component History Table	18	CH	LOTN	Lot/Serial Number	String	Generic Edit	30	0
30	F3294	Configured String History File	4	KZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
31	F32943	Configured String History - OneWorld	4	KO	LOTN	Lot/Serial Number	String	Generic Edit	30	0
TOP34: Requirements Planning
32	F3411	MPS/MRP/DRP Message File	31	MM	LOTN	Lot/Serial Number	String	Generic Edit	30	0
TOP37: Quality Management
33	F3703	Non-Conforming Material	4	QE	LOTN	Lot/Serial Number	String	Generic Edit	30	0
34	F3711	Test Results	11	TR	LOTN	Lot/Serial Number	String	Generic Edit	30	0
35	F3711Z1	Test Results Unedited Transaction Table	24	SZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
36	F37900	Certificate of Analysis (COA) Extract	10	TR	LOTN	Lot/Serial Number	String	Generic Edit	30	0
TOP40: Inventory/OP Base
37	F30026	Item Cost Component Add-Ons	6	IE	LOTN	Lot/Serial Number	String	Generic Edit	30	0
38	F30UI006	Lot Tracking Work File	3	IL	LOTN	Lot/Serial Number	String	Generic Edit	30	0
39	F40051	Return Material Authorization	59	RD	LOTN	Lot/Serial Number	String	Generic Edit	30	0
40	F4011Z	Batch Receiver File - Order Details	53	SZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
41	F4012ZW	WF - Destination Quantity	25	SP	LOTN	Lot/Serial Number	String	Generic Edit	30	0
42	F4106	Item Base Price File	6	BP	LOTN	Lot/Serial Number	String	Generic Edit	30	0
43	F4108	Lot Master	1	IO	LOTN	Lot/Serial Number	String	Generic Edit	30	0
44	F41112	Item ASOF File	9	IN	LOTN	Lot/Serial Number	String	Generic Edit	30	0
45	F4171	Critical Hold Management	2	I1	LOTN	Lot/Serial Number	String	Generic Edit	30	0
46	F4207	Price by Item	25	PM	LOTN	Lot/Serial Number	String	Generic Edit	30	0
47	F4211DT	Sales Order Detail Date Tracking File	15	DT	LOTN	Lot/Serial Number	String	Generic Edit	30	0
48	F4211Z1	Sales Order Detail Unedited Transaction File	50	SZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
49	F4220	Basic Serial Numbers	8	SW	LOTN	Lot/Serial Number	String	Generic Edit	30	0
TOP41: Inventory Management
50	F4101A	Item File	87	IM	LOTN	Lot/Serial Number	String	Generic Edit	30	0
51	F4101Z1	F4101 Item Master Unedited Transaction Table	185	SZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
52	F41021	Item Location File	4	LI	LOTN	Lot/Serial Number	String	Generic Edit	30	0
53	F410211	Project Commitment Detail Table	6	PC	LOTN	Lot/Serial Number	String	Generic Edit	30	0
54	F41021A	Item Location File - Temporary Upgrade	4	LI	LOTN	Lot/Serial Number	String	Generic Edit	30	0
55	F41021WF	F41021 Transaction Workfile	8	LW	LOTN	Lot/Serial Number	String	Generic Edit	30	0
56	F41021Z1	Item Location Unedited Transaction File	17	SZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
57	F4105	Item Cost File	6	CO	LOTN	Lot/Serial Number	String	Generic Edit	30	0
58	F41051	Average Cost Work file	5	CH	LOTN	Lot/Serial Number	String	Generic Edit	30	0
59	F4105Z1	Unedited Transaction Table - Item Cost	19	SZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
60	F4111	Item Ledger File	7	IL	LOTN	Lot/Serial Number	String	Generic Edit	30	0
61	F41113	Lot Ledger	4	I8	LOTN	Lot/Serial Number	String	Generic Edit	30	0
62	F41131	Stranded Hard Commitments Table	3	IU	LOTN	Lot/Serial Number	String	Generic Edit	30	0
63	F4141	Cycle Count Transaction File	8	PJ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
64	F4141Z1	F4141 Cycle Count Unedited Transaction Table	21	SZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
65	F4160	Tag Inventory File	6	IT	LOTN	Lot/Serial Number	String	Generic Edit	30	0
66	F41UI001	Inventory Transactions Detail File	18	IT	LOTN	Lot/Serial Number	String	Generic Edit	30	0
67	F41UI002	Inventory Transactions Batch File	8	TI	LOTN	Lot/Serial Number	String	Generic Edit	30	0
TOP41B: Bulk Stock Management
68	F41511	Bulk Product Transaction File	37	PA	LOTN	Lot/Serial Number	String	Generic Edit	30	0
TOP42: Sales Management
69	F4211	Sales Order Detail File	37	SD	LOTN	Lot/Serial Number	String	Generic Edit	30	0
70	F42119	Sales Order History File	37	SD	LOTN	Lot/Serial Number	String	Generic Edit	30	0
71	F42199	S.O. Detail Ledger File	37	SL	LOTN	Lot/Serial Number	String	Generic Edit	30	0
72	F4239	Last Customer Shipment	7	LC	LOTN	Lot/Serial Number	String	Generic Edit	30	0
73	F42565	Invoice Print File	119	IW	LOTN	Lot/Serial Number	String	Generic Edit	30	0
74	F42UI11	SO Detail Cache File (MBF)	40	ZD	LOTN	Lot/Serial Number	String	Generic Edit	30	0
75	F42UI12	Sales Order Detail Cache 2 (MBF)	73	ZD	LOTN	Lot/Serial Number	String	Generic Edit	30	0
76	F42UI130	Commitment Work File	20	ZC	LOTN	Lot/Serial Number	String	Generic Edit	30	0
77	F42UI521	Pick Slips Detail File	32	S9	LOTN	Lot/Serial Number	String	Generic Edit	30	0
78	F42UI800	Sales Detail Work File - Sales Update	40	SD	LOTN	Lot/Serial Number	String	Generic Edit	30	0
TOP42B: Sales Order Entry
79	F42420	Audit Log Transaction	24	AL	LOTN	Lot/Serial Number	String	Generic Edit	30	0
TOP43: Procurement
80	F41291	Item Cost Components	7	IG	LOTN	Lot/Serial Number	String	Generic Edit	30	0
81	F43080	Approvals Fields Constants	47	PD	LOTN	Lot/Serial Number	String	Generic Edit	30	0
82	F43092Z1	Receipt Routing Unedited Transaction Table	46	SZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
83	F4311	Purchase Order Detail File	39	PD	LOTN	Lot/Serial Number	String	Generic Edit	30	0
84	F4311Z	Purchase Order Generator File	43	PW	LOTN	Lot/Serial Number	String	Generic Edit	30	0
85	F4311Z1	Purchase Order Detail Unedited Transaction Table	52	SZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
86	F43121	Purchase Order Receiver File	19	PR	LOTN	Lot/Serial Number	String	Generic Edit	30	0
87	F43121Z	Receiver workfile	24	PW	LOTN	Lot/Serial Number	String	Generic Edit	30	0
88	F43121Z1	Receipts Unedited Transaction Table	36	SZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
89	F4314Z	Voucher Match Selection File	118	PN	LOTN	Lot/Serial Number	String	Generic Edit	30	0
90	F43199	P.O. Detail Ledger File - Flexible Version	39	OL	LOTN	Lot/Serial Number	String	Generic Edit	30	0
TOP45: Advanced Pricing
91	F4574	Key Reference Table	10	KR	LOTN	Lot/Serial Number	String	Generic Edit	30	0
TOP46: Warehouse Management
92	F4142	Warehouse Count Transactions	6	CT	LOTN	Lot/Serial Number	String	Generic Edit	30	0
93	F4602	Location Detail Information	4	IF	LOTN	Lot/Serial Number	String	Generic Edit	30	0
94	F46130	Putaway Reservations	13	R3	LOTN	Lot/Serial Number	String	Generic Edit	30	0
95	F46130PU	Putaway Reservations - Purged	13	R3	LOTN	Lot/Serial Number	String	Generic Edit	30	0
TOP46L: License Plating
96	F46L11	License Plate Item Detail	3	ID	LOTN	Lot/Serial Number	String	Generic Edit	30	0
97	F46L12	License Plate Commitment	15	LC	LOTN	Lot/Serial Number	String	Generic Edit	30	0
98	F46L42	License Plate Cycle and Tag Count	6	CC	LOTN	Lot/Serial Number	String	Generic Edit	30	0
99	F46L99	License Plate History	9	LM	LOTN	Lot/Serial Number	String	Generic Edit	30	0
100	F46LUI01	Assign/Remove Items To LP Work File	10	WF	LOTN	Lot/Serial Number	String	Generic Edit	30	0
TOP47: Electronic Commerce
101	F47012	EDI Purchase Order Detail - Inbound	54	SZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
102	F47017	EDI Purchase Order Detail - Outbound	53	SZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
103	F47022	EDI P.O. Acknowledgment Detail - Inbound	53	SZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
104	F47027	EDI P.O. Acknowledgment Detail - Outbound	54	SZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
105	F47032	EDI Shipping Notice Detail - Inbound	52	SZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
106	F47037	EDI Shipping Notice Detail - Outbound	54	SZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
107	F470371	EDI Shipping Notice Detail - Outbound	60	SZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
108	F47042	EDI Invoice Detail - Inbound	34	SZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
109	F47047	EDI Invoice Detail (Sales) - Outbound	54	SZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
110	F47072	EDI Receiving Advice Detail - Inbound	54	SZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
111	F47077	EDI Receiving Advice Detail - Outbound	54	SZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
112	F47092	EDI Request for Quote Detail - Inbound	54	SZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
113	F47097	EDI Request for Quote Detail - Outbound	53	SZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
114	F47102	EDI Response to RFQ Detail - Inbound	53	SZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
115	F47107	EDI Response to RFQ Detail - Outbound	54	SZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
116	F47122	EDI Product Activity Data Detail - Inbound	26	MJ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
117	F47127	EDI Product Activity Data Detail - Outbound	26	MJ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
118	F47132	EDI Purchase Order Change Detail - Inbound	55	SZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
119	F47137	EDI Purchase Order Change Detail - Outbound	54	SZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
120	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	55	SZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
121	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	56	SZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
122	F47157	EDI Shipping Schedule Detail - Outbound	56	SZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
TOP48: Work Order Processing
123	F4801	Work Order Master File	89	WA	LOTN	Lot/Serial Number	String	Generic Edit	30	0
124	F48UI001	X4801 Master Business Function Workfile	92	WA	LOTN	Lot/Serial Number	String	Generic Edit	30	0
TOP49: Transportation Management
125	F4963	Load In-transit	5	TI	LOTN	Lot/Serial Number	String	Generic Edit	30	0
126	F49631	Load In-transit Ledger	33	TO	LOTN	Lot/Serial Number	String	Generic Edit	30	0
127	F49632	Load In-transit Left on Board	5	LB	LOTN	Lot/Serial Number	String	Generic Edit	30	0
TOP55: Reserved for Clients
128	F74H1051	Invoicing Workfile - New	12	IW	LOTN	Lot/Serial Number	String	Generic Edit	30	0
TOP74: EMEA Localization
129	F7420033	Sales Document Line (Print Info) - COMM - 42	9	PI	LOTN	Lot/Serial Number	String	Generic Edit	30	0
130	F7464108	Lot Additional Information - COMM - 41	1	LO	LOTN	Lot/Serial Number	String	Generic Edit	30	0
TOP75C: China - Reporting System Only
131	F75C4106	Chinese Free Goods VAT base price - F75C4106	5	IB	LOTN	Lot/Serial Number	String	Generic Edit	30	0
TOP76A: Argentina
132	F76A0219	Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A	24	DL	LOTN	Lot/Serial Number	String	Generic Edit	30	0
133	F76A021P	Detail Lines Inv./ShipmentNote History WF Purge - ARG - 76A	24	DL	LOTN	Lot/Serial Number	String	Generic Edit	30	0
134	F76A393	Calculated costs detail - 76A	9	C3	LOTN	Lot/Serial Number	String	Generic Edit	30	0
135	F76A394	Adjustments - 76A	9	C4	LOTN	Lot/Serial Number	String	Generic Edit	30	0
136	F76AUI21	Detail Lines Invoice/ShipmentNote Workfile - ARG - 00 - 00	24	DL	LOTN	Lot/Serial Number	String	Generic Edit	30	0
TOP76B: Brazil - Reporting System Only
137	F7611B	Nota Fiscal Detail - Brazil	29	FD	LOTN	Lot/Serial Number	String	Generic Edit	30	0
138	F761BA	AS Fiscal file book	33	FB	LOTN	Lot/Serial Number	String	Generic Edit	30	0
139	F76412	Item Branch Regional Information - Brazil	4	IJ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
TOP76H: Chile
140	F76H6002	Indirect Costs Selection EPS F1602 - CHI - 41 - 76H	27	I1	LOTN	Lot/Serial Number	String	Generic Edit	30	0
141	F76H6003	Indirect Costs Selection EPS F1642 - CHI - 41 - 76H	28	I2	LOTN	Lot/Serial Number	String	Generic Edit	30	0
142	F76H6004	Item Cost Component WF - CHI - 41 - 76H	7	IC	LOTN	Lot/Serial Number	String	Generic Edit	30	0
143	F76H6008	Manufactured Items - CHI - 41 - 76H	7	IP	LOTN	Lot/Serial Number	String	Generic Edit	30	0
144	F76H6105	Item Actual Cost File - CHI - 41 - 76H	7	AC	LOTN	Lot/Serial Number	String	Generic Edit	30	0
145	F76H611	Actual Item Ledger File - CHI - 41 - 76H	7	AL	LOTN	Lot/Serial Number	String	Generic Edit	30	0
146	F76H6112	Actual Item ASOF File - CHI - 41 - 76H	9	AN	LOTN	Lot/Serial Number	String	Generic Edit	30	0
147	F76H6205	Item Replacement Cost - CHI - 41	7	IR	LOTN	Lot/Serial Number	String	Generic Edit	30	0
TOP76P: Peru
148	F76P393Z	Calculated Costs detail Z1 - PER - 41 - 76P	8	CZ	LOTN	Lot/Serial Number	String	Generic Edit	30	0
TOP89: Conversion Programs
149	F43199A	Temp F43199 for ERP 9.0 Upgrade	39	OL	LOTN	Lot/Serial Number	String	Generic Edit	30	0
TOPD3N: dcLINK (data collection) - DSI
150	FD3N1611	Pallet Tracking Table 2	3	PD	LOTN	Lot/Serial Number	String	Generic Edit	30	0
151	FD3N161P	Pallet Tracking Table 4	5	PH	LOTN	Lot/Serial Number	String	Generic Edit	30	0
152	FD3N4041	Pallet Tracking Table 6	4	CD	LOTN	Lot/Serial Number	String	Generic Edit	30	0
153	FD3N4116	dcLINK Interface - Inventory Reclassification	19	IR	LOTN	Lot/Serial Number	String	Generic Edit	30	0
154	FD3N421P	Pallet Tracking Table 3	3	SH	LOTN	Lot/Serial Number	String	Generic Edit	30	0
155	FD3N4950	dcLINK Delivery Confirmation Work File	10	DC	LOTN	Lot/Serial Number	String	Generic Edit	30	0
TOPF31: Lean Transactions
156	FF31010	Production Master File	10	EH	LOTN	Lot/Serial Number	String	Generic Edit	30	0
157	FF31011	TransactionID Master File	22	EH	LOTN	Lot/Serial Number	String	Generic Edit	30	0
158	FF31011S	Purge - TransactionID Master File	22	ER	LOTN	Lot/Serial Number	String	Generic Edit	30	0
159	FF31111	Lean Transaction Parts List	35	PL	LOTN	Lot/Serial Number	String	Generic Edit	30	0
160	FF31111S	Purge - Lean Transaction Parts List	35	PR	LOTN	Lot/Serial Number	String	Generic Edit	30	0
TOPH91: Design Tools
161	F98TC01	Table Conversion UnNormalized	4	TC	LOTN	Lot/Serial Number	String	Generic Edit	30	0
162	F98TC03	Table Conversion Normalized 2	4	TN	LOTN	Lot/Serial Number	String	Generic Edit	30	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

162 columns | 812 | LOTN