	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	F4102	IB	Item Branch File
7	F9671	SD	Software Update Detail Table
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

68 columns | 812 | UPRC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP36: Forecasting
1	F34007	Forecast Prices	7	FH	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
TOP38: Agreement Management
2	F38011	Agreement Quantities	16	DF	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
TOP40: Inventory/OP Base
3	F40051	Return Material Authorization	33	RD	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
4	F4011Z	Batch Receiver File - Order Details	91	SZ	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
5	F4012ZW	WF - Destination Quantity	30	SP	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
6	F4013Z	Kit Components Batch File	12	KS	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
7	F40UI74	Price Adjustment History Work File	29	AW	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
8	F4106	Item Base Price File	16	BP	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
9	F4106NC	Base Price Extraction	18	SZ	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
10	F4211Z1	Sales Order Detail Unedited Transaction File	88	SZ	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
TOP40G: Grower Management
11	F40G150	Crush and Purchase Report Details	41	CP	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
TOP42: Sales Management
12	F4074	Price Adjustment Ledger File	23	AL	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
13	F4211	Sales Order Detail File	75	SD	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
14	F42119	Sales Order History File	75	SD	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
15	F42199	S.O. Detail Ledger File	75	SL	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
16	F42565	Invoice Print File	26	IW	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
17	F42UI11	SO Detail Cache File (MBF)	63	ZD	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
18	F42UI521	Pick Slips Detail File	70	S9	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
TOP42B: Sales Order Entry
19	F42420	Audit Log Transaction	19	AL	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
20	F42440	Customer Segment Items	6	CS	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
21	F42UI440	Customer Segment Items - Work File	6	CS	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
TOP44H: Homebuilder Management
22	F4459	Material Item Pricing (World)	6	JL	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
23	F44H603	Material Item Pricing	12	MP	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
TOP45: Advanced Pricing
24	F4075	Price Variable Table	4	VB	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
25	F45521	Price List Detail	18	PD	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
26	F4574	Key Reference Table	59	KR	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
27	F4575	Ship and Debit History	25	AH	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
28	F4575TMP	Ship and Debit History - Temp Table	25	AH	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
29	F4576Z1	Ship and Debit Claims Unedited Transaction Table	110	Z1	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
TOP47: Electronic Commerce
30	F47012	EDI Purchase Order Detail - Inbound	92	SZ	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
31	F47027	EDI P.O. Acknowledgment Detail - Outbound	92	SZ	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
32	F47037	EDI Shipping Notice Detail - Outbound	89	SZ	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
33	F470371	EDI Shipping Notice Detail - Outbound	100	SZ	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
34	F47042	EDI Invoice Detail - Inbound	59	SZ	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
35	F47047	EDI Invoice Detail (Sales) - Outbound	92	SZ	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
36	F470473	EDI Invoice Detail Charges	15	S7	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
37	F47062	EDI Planning Schedule Detail - Inbound	22	MY	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
38	F47067	EDI Planning Schedule Detail - Outbound	22	MY	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
39	F47082	EDI Price Sales Catalog Detail - Inbound	72	FY	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
40	F47092	EDI Request for Quote Detail - Inbound	92	SZ	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
41	F47107	EDI Response to RFQ Detail - Outbound	92	SZ	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
42	F47132	EDI Purchase Order Change Detail - Inbound	93	SZ	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
43	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	94	SZ	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
44	F47157	EDI Shipping Schedule Detail - Outbound	204	SZ	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
TOP55: Reserved for Clients
45	F74H1051	Invoicing Workfile - New	17	IW	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
46	F74H1057	Invoice Line Pricing Information	6	IP	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
TOP74: EMEA Localization
47	F7420033	Sales Document Line (Print Info) - COMM - 42	14	PI	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
48	F7420034	Price Adjustment (Print Info) - COMM - 42	9	PI	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
TOP75C: China - Reporting System Only
49	F75C4106	Chinese Free Goods VAT base price - F75C4106	10	IB	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
TOP75T: Taiwan
50	F75T005	GUI/VAT Transaction Detail - 75T	14	TD	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
51	F75T0059	GUI/VAT Transaction Detail History - 75T	14	TD	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
52	F75T005P	GUI/VAT Transaction Detail POS - 75T	14	TD	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
53	F75T005Z	GUI/VAT Transaction Detail - Work - 75T	20	ZD	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
TOP76A: Argentina
54	F76A0219	Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A	13	DL	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
55	F76A021P	Detail Lines Inv./ShipmentNote History WF Purge - ARG - 76A	13	DL	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
56	F76A393	Calculated costs detail - 76A	11	C3	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
57	F76AUI21	Detail Lines Invoice/ShipmentNote Workfile - ARG - 00 - 00	13	DL	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
TOP76B: Brazil - Reporting System Only
58	F76111B	Nota Fiscal - Detail (Fiscal Books) - 42	13	QU	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
59	F76111BT	Conversion table for CFOP 5 digits - F76111B - 42	13	TA	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
60	F7611B	Nota Fiscal Detail - Brazil	37	FD	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
61	F761BA	AS Fiscal file book	40	FB	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
62	F76B31	Nota Fiscal Detail/Table for Goods - IN68 - 42	19	IM	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
TOP76H: Chile
63	F76H3B34	Sales Document Line (Print Info) - CHI - 03B - 76H	12	PI	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
64	F76H3B35	Price Adjustment (Print Info) - CHI - 03B - 76H	9	PI	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
65	F76H3B38	Shipment Guide Line (Print Info) - CHI - 03B - 76H	11	PI	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
TOP76P: Peru
66	F76P393Z	Calculated Costs detail Z1 - PER - 41 - 76P	9	CZ	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
TOPH90: ONEWORLD TOOLS
67	F99DTL	Workflow Demonstration Sales Order Detail	7	WD	UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4
68	F99WFITM	Workflow Demonstration Item Table	4	WI	UPRC	Amount - Price per Unit	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

68 columns | 812 | UPRC