	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

86 columns | 910 | UPRC

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

86 columns | 910 | UPRC