	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

82 columns | 920 | UNCS

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP03B: Enhanced Accounts Receivable
1	F03B29	Credit Insurance	12	IP	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
TOP13: Plant/Equipment Management
2	F13017	Equipment Parts List	33	PL	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
3	F3111IGS	WO Parts for IGS Integration	9	IG	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
TOP30: Product Data Management
4	F300211	Lean Multi Level Bill of Material Detail	74	ED	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
5	F3002Z1	Bill of Material Transaction File	66	SZ	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
TOP31B: Blend Management
6	F31B211	Cost Groups Detail	4	CG	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
7	F31B31C	Blend Lot Costs	6	BC	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
8	F31B3CZ1	Operations Cost Transaction File	21	SZ	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
9	F31B66	Blend Transactions	11	BT	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
TOP38: Agreement Management
10	F38111	Agreements Transaction Ledger	53	DZ	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
TOP39: Advanced Stock Valuation
11	F3908	Item Pool Valuation Cost Master	6	CS	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
12	F39120	Temporary Period Build File for Stock Valuation	10	TF	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
13	F39120W	Period Detail Work File	8	TW	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
14	F39121W	Additional Quantity Work File	9	AQ	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
TOP40: Inventory/OP Base
15	F3002	Bill of Material Master File	53	IX	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
16	F3011	Bill of Materials Change File	53	IZ	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
17	F3013	ECO Parts List Detail	35	CY	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
18	F30UI004	Bill of Material Update Work File	55	WF	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
19	F4011Z	Batch Receiver File - Order Details	98	SZ	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
20	F4012ZW	WF - Destination Quantity	32	SP	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
21	F4013Z	Kit Components Batch File	13	KS	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
22	F4211Z1	Sales Order Detail Unedited Transaction File	95	SZ	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
TOP41: Inventory Management
23	F4105	Item Cost File	9	CO	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
24	F4105Z1	Unedited Transaction Table - Item Cost	22	SZ	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
25	F4111	Item Ledger File	41	IL	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
26	F4133	Usage Detail (FUTURE)	21	UD	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
27	F4141	Cycle Count Transaction File	20	PJ	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
28	F4141Z1	F4141 Cycle Count Unedited Transaction Table	35	SZ	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
29	F4160	Tag Inventory File	25	IT	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
30	F41UI001	Inventory Transactions Detail File	20	IT	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
31	F41UI002	Inventory Transactions Batch File	9	TI	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
TOP41B: Bulk Stock Management
32	F41511	Bulk Product Transaction File	40	PA	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
TOP41F: Apparel Management
33	FCW12	Item Cost File Work File	8	WC	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
TOP42: Sales Management
34	F4211	Sales Order Detail File	82	SD	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
35	F42119	Sales Order History File	82	SD	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
36	F42199	S.O. Detail Ledger File	82	SL	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
37	F42UI11	SO Detail Cache File (MBF)	70	ZD	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
38	F42UI130	Commitment Work File	45	ZC	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
39	F42UI521	Pick Slips Detail File	75	S9	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
40	F42UI800	Sales Detail Work File - Sales Update	52	SD	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
TOP42B: Sales Order Entry
41	F42420	Audit Log Transaction	37	AL	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
42	F42UI440	Customer Segment Items - Work File	7	CS	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
TOP42I: Outbound Inventory Management
43	F42I015	Outbound Inventory Agreement Transaction File	33	OI	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
TOP42X: In-Memory Sales Advisor
44	F42X010W	Line Advisor Work File	29	US	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
45	F42X020W	Order Advisor Work File	20	XC	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
46	F42X201	Profitability Simulator Saved Scenarios	9	PS	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
TOP43: Procurement
47	F4314Z	Voucher Match Selection File	67	PN	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
48	F4371	Suggested Reorder Stock Items	14	PD	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
TOP45: Advanced Pricing
49	F4073	Free Goods Master File	9	FG	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
50	F4073P	Free Goods Master File Purge	10	FG	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
51	F4576Z1	Ship and Debit Claims Unedited Transaction Table	144	Z1	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
TOP47: Electronic Commerce
52	F47012	EDI Purchase Order Detail - Inbound	99	SZ	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
53	F47027	EDI P.O. Acknowledgment Detail - Outbound	99	SZ	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
54	F47037	EDI Shipping Notice Detail - Outbound	94	SZ	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
55	F470371	EDI Shipping Notice Detail - Outbound	105	SZ	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
56	F47047	EDI Invoice Detail (Sales) - Outbound	99	SZ	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
57	F47092	EDI Request for Quote Detail - Inbound	99	SZ	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
58	F47107	EDI Response to RFQ Detail - Outbound	99	SZ	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
59	F47122	EDI Product Activity Data Detail - Inbound	43	MJ	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
60	F47127	EDI Product Activity Data Detail - Outbound	43	MJ	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
61	F47132	EDI Purchase Order Change Detail - Inbound	100	SZ	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
62	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	101	SZ	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
TOP49: Transportation Management
63	F49631	Load In-transit Ledger	56	TO	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
TOP54R: Rental Management
64	F54R11	Rental Contract Detail	112	CD	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
65	F54R199	Rental Contract Detail Ledger	108	DL	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
TOP75I: India
66	F75I3901	Work With Consignment - IND -43	28	CO	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
67	F75I395B	ER - 5 (2)	23	ER	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
68	F75I395T	ER - 5 (temp)	24	ER	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
69	F75I396B	ER-6	26	SE	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
70	F75I396T	ER-6 Temp	25	SE	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
TOP76A: Argentina
71	F76A393	Calculated costs detail - 76A	12	C3	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
72	F76A396	Item Valuation Cost Master - 76A	6	CS	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
TOP76B: Brazil
73	F76B400A	IN86-Work Table for Storage Control - 41	16	SC	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
74	F76B50	Item Ledger Table - IN68 - 42	11	CE	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
75	F76B51	Inventory Records Table - IN68 - 42	9	RI	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
TOP76H: Chile
76	F76H6105	Item Actual Cost File - CHI - 41 - 76H	9	AC	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
77	F76H611	Actual Item Ledger File - CHI - 41 - 76H	42	AL	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
78	F76H6205	Item Replacement Cost - CHI - 41	14	IR	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
TOP79A: Greenhouse Gas Accounting
79	F79A80	GHG Carbon Permit Management	7	CP	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
TOPF30L: DFM Line Design
80	FF30L002	DFM Bill of Material Master	47	DH	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
TOPH90: EnterpriseOne TOOLS
81	F99DTL	Workflow Demonstration Sales Order Detail	6	WD	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4
82	F99WFITM	Workflow Demonstration Item Table	3	WI	UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4

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

82 columns | 920 | UNCS