	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

144 columns | 812 | UORG

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F00092	Supplemental Data	10	T3	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
2	F0018	Sales/Use/V.A.T. Tax File	27	TD	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
3	F004201	Prepayment Transaction Table	47	PT	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
TOP04: Accounts Payable
4	F09UI006	Tax (F0018) Replica	27	TD	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
TOP13: Plant/Equipment Management
5	F3111IGS	WO Parts for IGS Integration	12	IG	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
TOP17: Customer Service Management
6	F1775	Claim Temporary Table	12	TC	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
7	F3111Z2	Warranty Claim/Supplier Recovery processing	53	WP	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
8	F3112Z2	Warranty Claim/Supplier Recovery processing	59	WL	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
9	F4801Z2	Warranty Claim/Supplier Recovery processing	82	WS	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
TOP30: Product Data Management
10	F3019	Kanban Replenishment Capacity	4	KR	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
TOP31: Shop Floor Control
11	F3111	Work Order Parts List	40	WM	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
12	F3111S	Purge - Shop Floor Parts List	40	WM	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
13	F3111Z1	Outbound Work Order Parts List	53	SZ	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
14	F3112	Work Order Routing	47	WL	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
15	F3112S	Purge Shop Floor Control Routing Instructions	47	WL	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
16	F3112Z1	Outbound Work Order Routings	59	SZ	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
17	F3115	Net Change Transaction table	11	NC	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
18	F3118	Shortage Maintenance Master File	6	WN	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
19	F31UI006	Line Scheduling Workbench - Work File	23	LS	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
20	F4801S	Purge - Work Order Master file	63	WA	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
21	F4801Z1	Outbound Work Order Header	82	SY	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
TOP31P: Engineer To Order
22	F31P11	Project Quote Detail	24	QP	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
TOP32: Configuration Management
23	F3212	Configurator Routings File	11	RC	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
TOP33: Capacity Planning
24	F3303	Capacity Resource Profile	7	CT	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
25	F3311	Capacity Message File	7	CN	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
26	F3312	Capacity Pegging	7	CW	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
27	F33UI001	Shop Floor Control Routing Instructions	20	WL	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
TOP34: Requirements Planning
28	F3412	MPS/MRP/DRP Lower Level Requirements File	7	MW	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
29	F3460	Forecast File	7	MF	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
TOP36: Forecasting
30	F3400	Forecast Summary File	17	SG	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
31	F3460Z1	Forecast Unedited Transactions	20	FT	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
TOP40: Inventory/OP Base
32	F3462	Forecast Shipment Summary	6	MB	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
33	F40051	Return Material Authorization	32	RD	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
34	F4011Z	Batch Receiver File - Order Details	81	SZ	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
35	F4012ZW	WF - Destination Quantity	29	SP	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
36	F4013Z	Kit Components Batch File	16	KS	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
37	F40300R	Preference Resolution History - Master	8	PM	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
38	F40UI17	Allocation Work File	20	ZG	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
39	F40UI74	Price Adjustment History Work File	42	AW	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
40	F4211AU	Sales Order Detail Audit File	36	AU	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
41	F4211Z1	Sales Order Detail Unedited Transaction File	78	SZ	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
TOP40R: Demand Scheduling
42	F471721	EDI Demand Supplemental Data	17	EU	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
TOP41: Inventory Management
43	F41131	Stranded Hard Commitments Table	19	IU	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
44	F4118	Container Deposit File	6	CN	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
45	F41181	Container Transaction File	13	CM	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
TOP42: Sales Management
46	F4211	Sales Order Detail File	65	SD	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
47	F42119	Sales Order History File	65	SD	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
48	F42199	S.O. Detail Ledger File	65	SL	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
49	F42UI11	SO Detail Cache File (MBF)	53	ZD	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
50	F42UI11C	Customer Self Service Shopping Cart Workfile	10	SC	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
51	F42UI521	Pick Slips Detail File	61	S9	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
52	F42UI800	Sales Detail Work File - Sales Update	44	SD	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
TOP42B: Sales Order Entry
53	F42216WF	Pending Blanket Release Work File - F42216WF	8	PB	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
54	F42420	Audit Log Transaction	17	AL	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
TOP43: Procurement
55	F41061	Supplier Price/Catalog File	16	CB	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
56	F43080	Approvals Fields Constants	68	PD	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
57	F4311	Purchase Order Detail File	61	PD	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
58	F4311Z	Purchase Order Generator File	65	PW	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
59	F4311Z1	Purchase Order Detail Unedited Transaction Table	74	SZ	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
60	F43121	Purchase Order Receiver File	66	PR	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
61	F43121Z1	Receipts Unedited Transaction Table	83	SZ	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
62	F4314Z	Voucher Match Selection File	166	PN	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
63	F4316	Purchase Order Multiple Account File	27	P3	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
64	F43199	P.O. Detail Ledger File - Flexible Version	61	OL	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
65	F4331	Quantity Breaks File	6	P1	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
66	F4343	Purchase Rebate History	18	RH	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
67	F43632Z	Open Purchase Order by Item Work File	20	OI	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
68	F4371	Suggested Reorder Stock Items	19	PD	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
69	F43E09	F43E09 - Approvals Activity Table	27	AA	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
70	F43UI50D	PO Print Detail Work File	10	PW	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
TOP43A: Purchase Order Receipt/Routing
71	F43126	Purchase Order Receiver Multiple Account	28	P4	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
TOP43E: Requisition Self Service
72	F43E11	Requisition Detail	26	RD	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
73	F43E16	Requisition Multiple Account File	27	P3	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
TOP43Q: Strategic Sourcing
74	F43Q11	Event Detail	24	ED	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
75	F43Q41	Response Line	8	RB	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
76	F43Q51	Analyze Event Detail	15	ED	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
TOP43S: Supplier Self Service
77	F43001	Procurement Self-Service Transaction Log	17	SA	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
TOP44H: Homebuilder Management
78	F4457	Takeoff File (World)	11	JJ	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
79	F4458	Takeoff (World)	11	JK	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
80	F44H602	Takeoff Master File	14	TO	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
81	F44H602H	Takeoff History File	15	TH	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
82	F44H602W	Take Off Summary Workfile	16	TS	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
83	F44H611	Bid Details	48	BD	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
84	F44H611W	Bid Details Work File	52	BW	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
85	F44H711	Lot Start Workfile	54	SW	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
86	F44H711P	After Start Purchasing	16	TP	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
87	F44H711Z	HB Lot Start Unedited Transaction File	67	SZ	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
88	F44H712	Lot Start Workfile Takeoff Detail	13	ST	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
89	F44H71W1	Lot Start Generation Workfile	54	GW	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
90	F44H73W1	Lot Start - P.O. / Committment Generation Work File	27	CG	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
TOP45: Advanced Pricing
91	F4073	Free Goods Master File	6	FG	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
92	F45521	Price List Detail	6	PD	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
93	F45522	Price List Level-Break Pattern	4	PL	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
94	F4574	Key Reference Table	65	KR	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
TOP46: Warehouse Management
95	F46130	Putaway Reservations	15	R3	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
96	F46130PU	Putaway Reservations - Purged	15	R3	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
TOP46L: License Plating
97	F46LUI01	Assign/Remove Items To LP Work File	17	WF	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
TOP47: Electronic Commerce
98	F47012	EDI Purchase Order Detail - Inbound	82	SZ	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
99	F47017	EDI Purchase Order Detail - Outbound	75	SZ	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
100	F47022	EDI P.O. Acknowledgment Detail - Inbound	75	SZ	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
101	F47027	EDI P.O. Acknowledgment Detail - Outbound	82	SZ	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
102	F47032	EDI Shipping Notice Detail - Inbound	58	SZ	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
103	F47037	EDI Shipping Notice Detail - Outbound	79	SZ	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
104	F470371	EDI Shipping Notice Detail - Outbound	89	SZ	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
105	F47047	EDI Invoice Detail (Sales) - Outbound	82	SZ	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
106	F47072	EDI Receiving Advice Detail - Inbound	76	SZ	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
107	F47077	EDI Receiving Advice Detail - Outbound	76	SZ	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
108	F47092	EDI Request for Quote Detail - Inbound	82	SZ	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
109	F47097	EDI Request for Quote Detail - Outbound	75	SZ	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
110	F47098	EDI RFQ Detail Quantity - Outbound	12	SZ	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
111	F47102	EDI Response to RFQ Detail - Inbound	75	SZ	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
112	F47103	EDI Response to RFQ Detail Quantity - Inbound	12	SZ	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
113	F47107	EDI Response to RFQ Detail - Outbound	82	SZ	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
114	F47132	EDI Purchase Order Change Detail - Inbound	83	SZ	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
115	F47137	EDI Purchase Order Change Detail - Outbound	76	SZ	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
116	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	77	SZ	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
117	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	84	SZ	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
118	F47157	EDI Shipping Schedule Detail - Outbound	81	SZ	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
119	F47UI001	ASN Extract Work File	46	SZ	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
TOP48: Work Order Processing
120	F4801	Work Order Master File	63	WA	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
121	F48092	WO Supplemental DB User Defined	5	W8	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
122	F48UI001	X4801 Master Business Function Workfile	66	WA	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
TOP55: Reserved for Clients
123	F74H1051	Invoicing Workfile - New	10	IW	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
TOP74: EMEA Localization
124	F74093	Workfile for Printing IVA Summary - Italy	26	HC	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
TOP75T: Taiwan
125	F75T004	GUI/VAT Transaction Header - 75T	64	TH	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
126	F75T0049	GUI/VAT Transaction Header History - 75T	64	TH	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
127	F75T004P	GUI/VAT Transaction Header POS - 75T	64	TH	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
128	F75T005	GUI/VAT Transaction Detail - 75T	9	TD	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
129	F75T0059	GUI/VAT Transaction Detail History - 75T	9	TD	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
130	F75T005P	GUI/VAT Transaction Detail POS - 75T	9	TD	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
131	F75T005Z	GUI/VAT Transaction Detail - Work - 75T	15	ZD	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
TOP76B: Brazil - Reporting System Only
132	F76111B	Nota Fiscal - Detail (Fiscal Books) - 42	10	QU	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
133	F76111BT	Conversion table for CFOP 5 digits - F76111B - 42	10	TA	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
134	F7611B	Nota Fiscal Detail - Brazil	34	FD	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
135	F761BA	AS Fiscal file book	38	FB	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
136	F76B31	Nota Fiscal Detail/Table for Goods - IN68 - 42	17	IM	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
137	F76B411D	IN86-Work Table for Merchandise Nota Fiscal Issued by - 42	16	CD	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
138	F76B411E	IN86-Work Table for Merchandise NF Issued by Supplier - 41	16	SD	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
139	F76B51	Inventory Records Table - IN68 - 42	8	RI	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
140	F76B60	Products Table - IN68 - 30	3	PR	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
141	F76B61	Packing and Raw Material Table - IN68 - 30	5	IE	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
TOP89: Conversion Programs
142	F43199A	Temp F43199 for ERP 9.0 Upgrade	61	OL	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
TOPF31: Lean Transactions
143	FF31112	Routing Transaction Table	41	EH	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2
144	FF31112S	Purge - Routing Transaction Table	41	ET	UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2

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

144 columns | 812 | UORG