	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

213 columns | 920 | EXR1 | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0006	Business Unit Master	48	MC	EXR1	Tax Expl Code 1	String	UDC	2	0
2	F0006S	Date Effective Business Unit Master	50	MC	EXR1	Tax Expl Code 1	String	UDC	2	0
3	F0006Z1	Cost Center Unedited Transaction Table	61	SZ	EXR1	Tax Expl Code 1	String	UDC	2	0
4	F0006Z2	Business Unit Master Z File	61	SZ	EXR1	Tax Expl Code 1	String	UDC	2	0
5	F0018	Taxes	17	TD	EXR1	Tax Expl Code 1	String	UDC	2	0
6	F00189	WF - Tax Reconciliation	13	TG	EXR1	Tax Expl Code 1	String	UDC	2	0
7	F0018R	Tax Reconciliation Repository	18	ED	EXR1	Tax Expl Code 1	String	UDC	2	0
8	F004201	Prepayment Transaction Table	51	PT	EXR1	Tax Expl Code 1	String	UDC	2	0
9	F0911	Account Ledger	128	GL	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP03: Accounts Receivable
10	F03012	Customer Master by Line of Business	12	AI	EXR1	Tax Expl Code 1	String	UDC	2	0
11	F03012Z1	Customer Master LOB-Batch Table	25	VO	EXR1	Tax Expl Code 1	String	UDC	2	0
12	F0311	Accounts Receivable Ledger	42	RP	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP03B: Enhanced Accounts Receivable
13	F03B11	Customer Ledger	44	RP	EXR1	Tax Expl Code 1	String	UDC	2	0
14	F03B112	Invoice Revisions	46	RW	EXR1	Tax Expl Code 1	String	UDC	2	0
15	F03B112P	Invoice Revisions Purge File	46	RW	EXR1	Tax Expl Code 1	String	UDC	2	0
16	F03B117	Revenue Recognition GL Info	28	RL	EXR1	Tax Expl Code 1	String	UDC	2	0
17	F03B119	Revenue Recognition GL Info Audit	16	RN	EXR1	Tax Expl Code 1	String	UDC	2	0
18	F03B11P	Customer Ledger Purge File	44	RP	EXR1	Tax Expl Code 1	String	UDC	2	0
19	F03B11Z1	Batch Invoices	61	VJ	EXR1	Tax Expl Code 1	String	UDC	2	0
20	F03B11Z2	F03B11 Interoperability Table	57	SY	EXR1	Tax Expl Code 1	String	UDC	2	0
21	F03B575	Auto Debit Invoice Select and Build	53	RD	EXR1	Tax Expl Code 1	String	UDC	2	0
22	F09UI011	Receipt Prepost Work File	51	GL	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP04: Accounts Payable
23	F0411	Accounts Payable Ledger	32	RP	EXR1	Tax Expl Code 1	String	UDC	2	0
24	F0411A	WF - 'As Of' Accounts Payable Ledger	32	RP	EXR1	Tax Expl Code 1	String	UDC	2	0
25	F0411P	Purge - Accounts Payable Ledger	32	RP	EXR1	Tax Expl Code 1	String	UDC	2	0
26	F0411Z1	Voucher Transactions - Batch Upload	50	VL	EXR1	Tax Expl Code 1	String	UDC	2	0
27	F0411Z3	F0411 Interoperability Table	54	SZ	EXR1	Tax Expl Code 1	String	UDC	2	0
28	F09UI005	Tax Offsets User Index	56	GL	EXR1	Tax Expl Code 1	String	UDC	2	0
29	F09UI006	Tax (F0018) Replica	17	TD	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP07: Payroll
30	F0716701	Employee Assignment T/E Template Information	81	EA	EXR1	Tax Expl Code 1	String	UDC	2	0
31	F0716709	Employee Assignment T/E Template Info History	81	EA	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP09: General Accounting
32	F0911P	Purge - Account Ledger	128	GL	EXR1	Tax Expl Code 1	String	UDC	2	0
33	F0911R	WF - Account Ledger Reconciliation	71	GL	EXR1	Tax Expl Code 1	String	UDC	2	0
34	F0911Z1	Journal Entry Transactions - Batch File	176	VN	EXR1	Tax Expl Code 1	String	UDC	2	0
35	F0911Z4	F0911 Interoperability Table	157	SZ	EXR1	Tax Expl Code 1	String	UDC	2	0
36	F0917	Bank Statement Detail	18	GD	EXR1	Tax Expl Code 1	String	UDC	2	0
37	F09617	Auto Bank Statement Detail	21	GM	EXR1	Tax Expl Code 1	String	UDC	2	0
38	F09628	Auto Bank Statement Account Setup	8	GA	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP09E: Expense Reimbursment
39	F09E105	Tax Mapping	6	TM	EXR1	Tax Expl Code 1	String	UDC	2	0
40	F20112	Expense Report Detail	54	ED	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP15: Real Estate Management
41	F15012	Tenant E.P. Class Master	52	NS	EXR1	Tax Expl Code 1	String	UDC	2	0
42	F15012B	Tenant E.P. Class Master	59	NS	EXR1	Tax Expl Code 1	String	UDC	2	0
43	F15013	Sales Overage Master	64	NO	EXR1	Tax Expl Code 1	String	UDC	2	0
44	F15013B	Sales Overage Master File	43	NO	EXR1	Tax Expl Code 1	String	UDC	2	0
45	F15016	Tenant Escalation Master	51	NU	EXR1	Tax Expl Code 1	String	UDC	2	0
46	F15016B	Tenant Escalation Master	54	NU	EXR1	Tax Expl Code 1	String	UDC	2	0
47	F1502	Recurring Billings Master	46	NF	EXR1	Tax Expl Code 1	String	UDC	2	0
48	F1502B	Recurring Billings Master	46	NF	EXR1	Tax Expl Code 1	String	UDC	2	0
49	F1502WB	Estimated EP Recurring Billings	49	N4	EXR1	Tax Expl Code 1	String	UDC	2	0
50	F1511	Tenant/Lease Billings Detail	47	NJ	EXR1	Tax Expl Code 1	String	UDC	2	0
51	F1511B	Lease Billings Master	47	NJ	EXR1	Tax Expl Code 1	String	UDC	2	0
52	F1511H	Tenant/Lease Billings Detail History	47	N#	EXR1	Tax Expl Code 1	String	UDC	2	0
53	F1511HB	Lease Billings History	47	NC	EXR1	Tax Expl Code 1	String	UDC	2	0
54	F1525	A/R Fee Interest	36	N0	EXR1	Tax Expl Code 1	String	UDC	2	0
55	F1525B	Fees and Interest	33	NM	EXR1	Tax Expl Code 1	String	UDC	2	0
56	F1538	WF - Expence Participation Register	62	NZ	EXR1	Tax Expl Code 1	String	UDC	2	0
57	F1538B	EP Billing Register	64	NZ	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP17: Customer Service Management
58	F1720	Contract Header	28	CH	EXR1	Tax Expl Code 1	String	UDC	2	0
59	F1721	Contract Detail	33	CD	EXR1	Tax Expl Code 1	String	UDC	2	0
60	F4801TZ2	Warranty Claim/Supplier Recovery processing	76	WQ	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP17C: Call Management
61	F1755	Case Master	211	ZA	EXR1	Tax Expl Code 1	String	UDC	2	0
62	F1760	Time Entry	87	ZB	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP40: Inventory/OP Base
63	F4001Z	Batch Receiver File - Order Headings	60	SY	EXR1	Tax Expl Code 1	String	UDC	2	0
64	F4011Z	Batch Receiver File - Order Details	125	SZ	EXR1	Tax Expl Code 1	String	UDC	2	0
65	F4012ZW	WF - Destination Quantity	39	SP	EXR1	Tax Expl Code 1	String	UDC	2	0
66	F40UI00T	Tax Work File	13	PN	EXR1	Tax Expl Code 1	String	UDC	2	0
67	F4201Z1	Sales Order Header Unedited Transaction File	49	SY	EXR1	Tax Expl Code 1	String	UDC	2	0
68	F4211Z1	Sales Order Detail Unedited Transaction File	119	SZ	EXR1	Tax Expl Code 1	String	UDC	2	0
69	F49211	Sales Order Detail File - Tag File	62	UD	EXR1	Tax Expl Code 1	String	UDC	2	0
70	F49211Z1	Sales Order Detail Tag Unedited Transaction File	75	S1	EXR1	Tax Expl Code 1	String	UDC	2	0
71	F49219	Sales Order Detail - Tag History File	62	UD	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP42: Sales Management
72	F4201	Sales Order Header File	36	SH	EXR1	Tax Expl Code 1	String	UDC	2	0
73	F42019	Sales Order Header History File	36	SH	EXR1	Tax Expl Code 1	String	UDC	2	0
74	F4211	Sales Order Detail File	106	SD	EXR1	Tax Expl Code 1	String	UDC	2	0
75	F42119	Sales Order History File	106	SD	EXR1	Tax Expl Code 1	String	UDC	2	0
76	F42199	S.O. Detail Ledger File	106	SL	EXR1	Tax Expl Code 1	String	UDC	2	0
77	F42565	Invoice Print File	44	IW	EXR1	Tax Expl Code 1	String	UDC	2	0
78	F42800G1	Sales Update G Batch Detail Workfile	47	DG	EXR1	Tax Expl Code 1	String	UDC	2	0
79	F42UI01	SO Header Cache File (MBF)	41	ZH	EXR1	Tax Expl Code 1	String	UDC	2	0
80	F42UI12	Sales Order Detail Cache 2 (MBF)	36	ZD	EXR1	Tax Expl Code 1	String	UDC	2	0
81	F42UI521	Pick Slips Detail File	89	S9	EXR1	Tax Expl Code 1	String	UDC	2	0
82	F470371T	Tag for F470371- EDI shipping Notice Detail - Outbound	31	UZ	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP42B: Sales Order Entry
83	F42420	Audit Log Transaction	83	AL	EXR1	Tax Expl Code 1	String	UDC	2	0
84	F49299	S.O. Detail Tag Ledger File	62	UD	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP43: Procurement
85	F4301	Purchase Order Header	33	PH	EXR1	Tax Expl Code 1	String	UDC	2	0
86	F4301Z	PO Header Work File	37	PA	EXR1	Tax Expl Code 1	String	UDC	2	0
87	F4301Z1	Purchase Order Header Unedited Transaction Table	46	SY	EXR1	Tax Expl Code 1	String	UDC	2	0
88	F43080	Approvals Fields Constants	93	PD	EXR1	Tax Expl Code 1	String	UDC	2	0
89	F4311	Purchase Order Detail File	89	PD	EXR1	Tax Expl Code 1	String	UDC	2	0
90	F4311Z	Purchase Order Generator File	93	PW	EXR1	Tax Expl Code 1	String	UDC	2	0
91	F4311Z1	Purchase Order Detail Unedited Transaction Table	102	SZ	EXR1	Tax Expl Code 1	String	UDC	2	0
92	F43121	Purchase Order Receiver File	63	PR	EXR1	Tax Expl Code 1	String	UDC	2	0
93	F43121Z1	Receipts Unedited Transaction Table	80	SZ	EXR1	Tax Expl Code 1	String	UDC	2	0
94	F4314Z	Voucher Match Selection File	163	PN	EXR1	Tax Expl Code 1	String	UDC	2	0
95	F43199	P.O. Detail Ledger File - Flexible Version	89	OL	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP43E: Requisition Self Service
96	F43E20	Shopping Cart Detail	22	SC	EXR1	Tax Expl Code 1	String	UDC	2	0
97	F43E20WF	eReq - Shopping Cart Work File	22	SW	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP44H: Homebuilder Management
98	F44H601	Bid Header	37	BH	EXR1	Tax Expl Code 1	String	UDC	2	0
99	F44H603	Material Item Pricing	19	MP	EXR1	Tax Expl Code 1	String	UDC	2	0
100	F44H611	Bid Details	54	BD	EXR1	Tax Expl Code 1	String	UDC	2	0
101	F44H611W	Bid Details Work File	58	BW	EXR1	Tax Expl Code 1	String	UDC	2	0
102	F44H711	Lot Start Workfile	61	SW	EXR1	Tax Expl Code 1	String	UDC	2	0
103	F44H711P	After Start Purchasing	34	TP	EXR1	Tax Expl Code 1	String	UDC	2	0
104	F44H711Z	HB Lot Start Unedited Transaction File	74	SZ	EXR1	Tax Expl Code 1	String	UDC	2	0
105	F44H71W1	Lot Start Generation Workfile	61	GW	EXR1	Tax Expl Code 1	String	UDC	2	0
106	F44H73W1	Lot Start - P.O. / Committment Generation Work File	49	CG	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP45: Advanced Pricing
107	F45520TX	Price List Header Tax Table	5	PT	EXR1	Tax Expl Code 1	String	UDC	2	0
108	F4576Z1	Ship and Debit Claims Unedited Transaction Table	151	Z1	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP47: Electronic Commerce
109	F47011	EDI Purchase Order Header - Inbound	55	SY	EXR1	Tax Expl Code 1	String	UDC	2	0
110	F47012	EDI Purchase Order Detail - Inbound	126	SZ	EXR1	Tax Expl Code 1	String	UDC	2	0
111	F47016	EDI Purchase Order Header - Outbound	48	SY	EXR1	Tax Expl Code 1	String	UDC	2	0
112	F47017	EDI Purchase Order Detail - Outbound	103	SZ	EXR1	Tax Expl Code 1	String	UDC	2	0
113	F47021	EDI P.O. Acknowledgment Header - Inbound	48	SY	EXR1	Tax Expl Code 1	String	UDC	2	0
114	F47022	EDI P.O. Acknowledgment Detail - Inbound	103	SZ	EXR1	Tax Expl Code 1	String	UDC	2	0
115	F47026	EDI P.O. Acknowledgment Header - Outbound	51	SY	EXR1	Tax Expl Code 1	String	UDC	2	0
116	F47027	EDI P.O. Acknowledgment Detail - Outbound	126	SZ	EXR1	Tax Expl Code 1	String	UDC	2	0
117	F47031	EDI Shipping Notice Header - Inbound	43	SY	EXR1	Tax Expl Code 1	String	UDC	2	0
118	F47032	EDI Shipping Notice Detail - Inbound	74	SZ	EXR1	Tax Expl Code 1	String	UDC	2	0
119	F47032T	EDI Shipping Notice Detail- Inbound Tag	16	SZ	EXR1	Tax Expl Code 1	String	UDC	2	0
120	F47041	EDI Invoice Header - Inbound	34	SY	EXR1	Tax Expl Code 1	String	UDC	2	0
121	F47042	EDI Invoice Detail - Inbound	81	SZ	EXR1	Tax Expl Code 1	String	UDC	2	0
122	F47046	EDI Invoice Header (Sales) - Outbound	51	SY	EXR1	Tax Expl Code 1	String	UDC	2	0
123	F47047	EDI Invoice Detail (Sales) - Outbound	126	SZ	EXR1	Tax Expl Code 1	String	UDC	2	0
124	F470473	EDI Invoice Detail Charges	18	S7	EXR1	Tax Expl Code 1	String	UDC	2	0
125	F47057	EDI Payment Order Remittance Advice - Outbound	78	D3	EXR1	Tax Expl Code 1	String	UDC	2	0
126	F47057W	EDI Payment Order Remittance Advice - Work	78	D3	EXR1	Tax Expl Code 1	String	UDC	2	0
127	F47071	EDI Receiving Advice Header - Inbound	49	SY	EXR1	Tax Expl Code 1	String	UDC	2	0
128	F47072	EDI Receiving Advice Detail - Inbound	104	SZ	EXR1	Tax Expl Code 1	String	UDC	2	0
129	F47076	EDI Receiving Advice Header - Outbound	49	SY	EXR1	Tax Expl Code 1	String	UDC	2	0
130	F47077	EDI Receiving Advice Detail - Outbound	104	SZ	EXR1	Tax Expl Code 1	String	UDC	2	0
131	F47091	EDI Request for Quote Header - Inbound	55	SY	EXR1	Tax Expl Code 1	String	UDC	2	0
132	F47092	EDI Request for Quote Detail - Inbound	126	SZ	EXR1	Tax Expl Code 1	String	UDC	2	0
133	F47096	EDI Request for Quote Header - Outbound	48	SY	EXR1	Tax Expl Code 1	String	UDC	2	0
134	F47097	EDI Request for Quote Detail - Outbound	103	SZ	EXR1	Tax Expl Code 1	String	UDC	2	0
135	F47101	EDI Response to RFQ Header - Inbound	48	SY	EXR1	Tax Expl Code 1	String	UDC	2	0
136	F47102	EDI Response to RFQ Detail - Inbound	103	SZ	EXR1	Tax Expl Code 1	String	UDC	2	0
137	F47106	EDI Response to RFQ Header - Outbound	51	SY	EXR1	Tax Expl Code 1	String	UDC	2	0
138	F47107	EDI Response to RFQ Detail - Outbound	126	SZ	EXR1	Tax Expl Code 1	String	UDC	2	0
139	F47131	EDI Purchase Order Change Header - Inbound	52	SY	EXR1	Tax Expl Code 1	String	UDC	2	0
140	F47132	EDI Purchase Order Change Detail - Inbound	127	SZ	EXR1	Tax Expl Code 1	String	UDC	2	0
141	F47136	EDI Purchase Order Change Header - Outbound	48	SY	EXR1	Tax Expl Code 1	String	UDC	2	0
142	F47137	EDI Purchase Order Change Detail - Outbound	104	SZ	EXR1	Tax Expl Code 1	String	UDC	2	0
143	F47141	EDI P.O. Change Acknowledgment Header - Inbound	49	SY	EXR1	Tax Expl Code 1	String	UDC	2	0
144	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	105	SZ	EXR1	Tax Expl Code 1	String	UDC	2	0
145	F47146	EDI P.O. Change Acknowledgment Header - Outbound	52	SY	EXR1	Tax Expl Code 1	String	UDC	2	0
146	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	128	SZ	EXR1	Tax Expl Code 1	String	UDC	2	0
147	F47156	EDI Shipping Schedule Header - Outbound	51	SY	EXR1	Tax Expl Code 1	String	UDC	2	0
148	F47157	EDI Shipping Schedule Detail - Outbound	110	SZ	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP48: Work Order Processing
149	F4801ST	Purge - Work Order Master Tag File	63	WA	EXR1	Tax Expl Code 1	String	UDC	2	0
150	F4801T	Work Order Master Tag File	63	WA	EXR1	Tax Expl Code 1	String	UDC	2	0
151	F4817	Service Order Extension	17	SR	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP48S: Service Billing
152	F4812	Billing Detail Workfile	103	WD	EXR1	Tax Expl Code 1	String	UDC	2	0
153	F48127	Tax Derivation Information	11	WO	EXR1	Tax Expl Code 1	String	UDC	2	0
154	F4812H	Billing Workfile History	103	WD	EXR1	Tax Expl Code 1	String	UDC	2	0
155	F4812HS	Billing Workfile History Purged Save	103	WD	EXR1	Tax Expl Code 1	String	UDC	2	0
156	F4822	Invoice Summary Work File	50	W4	EXR1	Tax Expl Code 1	String	UDC	2	0
157	F4823	Voucher Summary	46	W0	EXR1	Tax Expl Code 1	String	UDC	2	0
158	F48S910	Billing Detail Journal Workfile	46	W2	EXR1	Tax Expl Code 1	String	UDC	2	0
159	F48S911	Summarized Journal Workfile	50	W3	EXR1	Tax Expl Code 1	String	UDC	2	0
160	F48SUI01	Billing Detail Print Workfile	103	WD	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP49: Transportation Management
161	F4950	Routing Entries	50	RT	EXR1	Tax Expl Code 1	String	UDC	2	0
162	F49501	Intermodal Detail Routing Entries	32	RD	EXR1	Tax Expl Code 1	String	UDC	2	0
163	F4978	Charge Code Definitions	4	CG	EXR1	Tax Expl Code 1	String	UDC	2	0
164	F4981	Freight Audit History	76	FH	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP52: Contract Billing
165	F5201	Contract Master	35	G4	EXR1	Tax Expl Code 1	String	UDC	2	0
166	F5202	Contract Billing Line Detail	33	G6	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP52G: Proj & Gov Contract Accounting
167	F4822H	Invoice Summary History	50	IH	EXR1	Tax Expl Code 1	String	UDC	2	0
168	F52G01M	Advanced Contracts Modifications	40	CM	EXR1	Tax Expl Code 1	String	UDC	2	0
169	F52G90	Invoice Printing Work Table	48	WT	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP54R: Rental Management
170	F54R099	Rental Contract Header Ledger	57	HL	EXR1	Tax Expl Code 1	String	UDC	2	0
171	F54R10	Rental Contract Header	55	CH	EXR1	Tax Expl Code 1	String	UDC	2	0
172	F54R11	Rental Contract Detail	90	CD	EXR1	Tax Expl Code 1	String	UDC	2	0
173	F54R199	Rental Contract Detail Ledger	86	DL	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP70: Multi-National Products
174	F700102	Suspended VAT - Tax Explanation Code - COMM - 70	3	TE	EXR1	Tax Expl Code 1	String	UDC	2	0
175	F704100	Suspended VAT AP - COMM - 70	12	VA	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP74: EMEA Localization
176	F740018D	Data extraction ESL - 74	15	DE	EXR1	Tax Expl Code 1	String	UDC	2	0
177	F740018W	Data extraction ESL - Workfile - 74	15	DE	EXR1	Tax Expl Code 1	String	UDC	2	0
178	F74093	Worktable for Printing IVA Summary - Italy	16	HC	EXR1	Tax Expl Code 1	String	UDC	2	0
179	F7430033	A/R Document Line (Print Info) - COMM - 03B	8	PI	EXR1	Tax Expl Code 1	String	UDC	2	0
180	F74900	Foreign Receivables and Payables - EMEA	51	RP	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP74H: Hungary
181	F74H410	Foreign Voucher Supplier Amounts - HUN - 74H	4	SA	EXR1	Tax Expl Code 1	String	UDC	2	0
182	F74H910	JE VAT Differences - HUN - 09	4	VD	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP74R: Russia
183	F74R0018	Russian Tax File - 74R	20	TD	EXR1	Tax Expl Code 1	String	UDC	2	0
184	F74R0480	Pay Item Differences - RUS - 04 - 74R	6	RP	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP74U: United Kingdom Localizations
185	F74U0205	Payment Profile - 15	8	P8	EXR1	Tax Expl Code 1	String	UDC	2	0
186	F74U0212	Accounting Billing Profile - 15	8	P8	EXR1	Tax Expl Code 1	String	UDC	2	0
187	F74U0213	Weekly Accounting Profile - 15	9	PW	EXR1	Tax Expl Code 1	String	UDC	2	0
188	F74U0405	SPC Certificate Holding Table - UK - 43	46	CH	EXR1	Tax Expl Code 1	String	UDC	2	0
189	F74U0420	SPC - Application Master - UK - 43	34	SE	EXR1	Tax Expl Code 1	String	UDC	2	0
190	F74U0425	SPC - Certificate Master - UK - 43	36	SF	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP75T: Taiwan
191	F75T004	GUI/VAT Transaction Header - 75T	16	TH	EXR1	Tax Expl Code 1	String	UDC	2	0
192	F75T0049	GUI/VAT Transaction Header History - 75T	16	TH	EXR1	Tax Expl Code 1	String	UDC	2	0
193	F75T004P	GUI/VAT Transaction Header POS - 75T	15	TH	EXR1	Tax Expl Code 1	String	UDC	2	0
194	F75T004Z	GUI/VAT Transaction Header - Work - 75T	14	ZH	EXR1	Tax Expl Code 1	String	UDC	2	0
195	F75T005	GUI/VAT Transaction Detail - 75T	13	TD	EXR1	Tax Expl Code 1	String	UDC	2	0
196	F75T0059	GUI/VAT Transaction Detail History - 75T	13	TD	EXR1	Tax Expl Code 1	String	UDC	2	0
197	F75T005P	GUI/VAT Transaction Detail POS - 75T	13	TD	EXR1	Tax Expl Code 1	String	UDC	2	0
198	F75T005T	GUI/VAT Transaction Detail Temp - 75T	13	TD	EXR1	Tax Expl Code 1	String	UDC	2	0
199	F75T005Z	GUI/VAT Transaction Detail - Work - 75T	20	ZD	EXR1	Tax Expl Code 1	String	UDC	2	0
200	F75T008	GUI/VAT Tax Type Mapping - 75T	2	TM	EXR1	Tax Expl Code 1	String	UDC	2	0
201	F75T42W	Work file with union of F4211 and F42119	31	SW	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP76A: Argentina
202	F76AUI89	Work File to Generate ND/NC Gain/Loss - ARG - 03B - 76A	23	WF	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP76C: Colombia
203	F76C031A	A/R Customer ledger As Of - F76C031A - COL - 04	43	RP	EXR1	Tax Expl Code 1	String	UDC	2	0
204	F76C0411	A/P Tag File - COL - 76C	10	RP	EXR1	Tax Expl Code 1	String	UDC	2	0
205	F76C575	Work File Magnetic Media - COL - 04	49	Q1	EXR1	Tax Expl Code 1	String	UDC	2	0
206	F76CT2	Sales/Use/V.A.T. Tax File - COL - 76C	14	CT	EXR1	Tax Expl Code 1	String	UDC	2	0
207	F76CUI02	Tax Detail - Work File - COL - 76C	10	TD	EXR1	Tax Expl Code 1	String	UDC	2	0
208	F76CUI04	Tax Detail for Distribution - Work File - COL - 76C	11	TD	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP76H: Chile
209	F76H218	Taxes by Sales Order Line - CHI - 42 - 76H	9	TD	EXR1	Tax Expl Code 1	String	UDC	2	0
210	F76HUI32	Workfile for R76H3B40 - CHI - 42 - 76H	25	WF	EXR1	Tax Expl Code 1	String	UDC	2	0
211	F76HUI33	Workfile for R76H3B40 - CHI - 42 - 76H	13	WF	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP76V: Venezuela
212	F76VLC01	Purchase Register Temporal - VEN -04 - 76V	1	LC	EXR1	Tax Expl Code 1	String	UDC	2	0
TOP89: Conversion Programs
213	F43199A	Temp F43199 for ERP 9.0 Upgrade	89	OL	EXR1	Tax Expl Code 1	String	UDC	2	0

User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.

TOPUDC 00 / EX (Tax Explanation Codes) stock values

	Value	Description	Hard Coded
1		.	Y
2	AR	Billable Tax	Y
3	B	Value Added + Self-Assessment	Y
4	BT	VAT + Self-Assmt Tax, Tax Only	Y
5	C	Value Added + Sales Tax	Y
6	CT	VAT + Sales Tax, Tax Only	Y
7	E	GST Free	Y
8	E3	Government	N
9	E4	Interstate	N
10	E5	Processing	N
11	E6	Resale	N
12	S	Sales or VAT (output) Tax	Y
13	ST	Sales Tax, Tax Only	Y
14	U	Self-Assessment (use) Tax	Y
15	UT	Self-Assessment Tax, Tax Only	Y
16	V	GST Applies	Y
17	V+	Value Added Tax, Tax on Tax	Y
18	VT	GST Only	Y

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

213 columns | 920 | EXR1 | STOCK UDC

TOPUDC 00 / EX (Tax Explanation Codes) stock values