	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

259 columns | 920 | TXA1

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0006	Business Unit Master	47	MC	TXA1	Tax Rate/Area	String	Generic Edit	10	0
2	F0006S	Date Effective Business Unit Master	49	MC	TXA1	Tax Rate/Area	String	Generic Edit	10	0
3	F0006Z1	Cost Center Unedited Transaction Table	60	SZ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
4	F0006Z2	Business Unit Master Z File	60	SZ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
5	F0018	Taxes	16	TD	TXA1	Tax Rate/Area	String	Generic Edit	10	0
6	F00189	WF - Tax Reconciliation	12	TG	TXA1	Tax Rate/Area	String	Generic Edit	10	0
7	F0018R	Tax Reconciliation Repository	17	ED	TXA1	Tax Rate/Area	String	Generic Edit	10	0
8	F004201	Prepayment Transaction Table	49	PT	TXA1	Tax Rate/Area	String	Generic Edit	10	0
9	F0911	Account Ledger	127	GL	TXA1	Tax Rate/Area	String	Generic Edit	10	0
10	F4008	Tax Areas	1	TA	TXA1	Tax Rate/Area	String	Generic Edit	10	0
11	F40081	Alternate Tax Rate/Area Definition	6	EU	TXA1	Tax Rate/Area	String	Generic Edit	10	0
12	F40082	Alternate Tax Area by Country - 00	2	AC	TXA1	Tax Rate/Area	String	Generic Edit	10	0
13	F744008	Tax areas - Tag Table EMEA - Spain / Italy	1	TA	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP03: Accounts Receivable
14	F03012	Customer Master by Line of Business	11	AI	TXA1	Tax Rate/Area	String	Generic Edit	10	0
15	F03012Z1	Customer Master LOB-Batch Table	24	VO	TXA1	Tax Rate/Area	String	Generic Edit	10	0
16	F0311	Accounts Receivable Ledger	41	RP	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP03B: Enhanced Accounts Receivable
17	F03B11	Customer Ledger	43	RP	TXA1	Tax Rate/Area	String	Generic Edit	10	0
18	F03B112	Invoice Revisions	45	RW	TXA1	Tax Rate/Area	String	Generic Edit	10	0
19	F03B112P	Invoice Revisions Purge File	45	RW	TXA1	Tax Rate/Area	String	Generic Edit	10	0
20	F03B117	Revenue Recognition GL Info	22	RL	TXA1	Tax Rate/Area	String	Generic Edit	10	0
21	F03B119	Revenue Recognition GL Info Audit	10	RN	TXA1	Tax Rate/Area	String	Generic Edit	10	0
22	F03B11P	Customer Ledger Purge File	43	RP	TXA1	Tax Rate/Area	String	Generic Edit	10	0
23	F03B11Z1	Batch Invoices	60	VJ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
24	F03B11Z2	F03B11 Interoperability Table	56	SY	TXA1	Tax Rate/Area	String	Generic Edit	10	0
25	F03B575	Auto Debit Invoice Select and Build	52	RD	TXA1	Tax Rate/Area	String	Generic Edit	10	0
26	F09UI011	Receipt Prepost Work File	50	GL	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP04: Accounts Payable
27	F0411	Accounts Payable Ledger	31	RP	TXA1	Tax Rate/Area	String	Generic Edit	10	0
28	F0411A	WF - 'As Of' Accounts Payable Ledger	31	RP	TXA1	Tax Rate/Area	String	Generic Edit	10	0
29	F0411P	Purge - Accounts Payable Ledger	31	RP	TXA1	Tax Rate/Area	String	Generic Edit	10	0
30	F0411Z1	Voucher Transactions - Batch Upload	49	VL	TXA1	Tax Rate/Area	String	Generic Edit	10	0
31	F0411Z3	F0411 Interoperability Table	53	SZ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
32	F09UI005	Tax Offsets User Index	55	GL	TXA1	Tax Rate/Area	String	Generic Edit	10	0
33	F09UI006	Tax (F0018) Replica	16	TD	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP07: Payroll
34	F0716701	Employee Assignment T/E Template Information	82	EA	TXA1	Tax Rate/Area	String	Generic Edit	10	0
35	F0716709	Employee Assignment T/E Template Info History	82	EA	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP09: General Accounting
36	F0901	Account Master	62	GM	TXA1	Tax Rate/Area	String	Generic Edit	10	0
37	F0911P	Purge - Account Ledger	127	GL	TXA1	Tax Rate/Area	String	Generic Edit	10	0
38	F0911R	WF - Account Ledger Reconciliation	70	GL	TXA1	Tax Rate/Area	String	Generic Edit	10	0
39	F0911Z1	Journal Entry Transactions - Batch File	177	VN	TXA1	Tax Rate/Area	String	Generic Edit	10	0
40	F0911Z4	F0911 Interoperability Table	156	SZ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
41	F0917	Bank Statement Detail	19	GD	TXA1	Tax Rate/Area	String	Generic Edit	10	0
42	F09617	Auto Bank Statement Detail	22	GM	TXA1	Tax Rate/Area	String	Generic Edit	10	0
43	F09628	Auto Bank Statement Account Setup	7	GA	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP09E: Expense Reimbursment
44	F09E105	Tax Mapping	5	TM	TXA1	Tax Rate/Area	String	Generic Edit	10	0
45	F20112	Expense Report Detail	39	ED	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP15: Real Estate Management
46	F15012	Tenant E.P. Class Master	51	NS	TXA1	Tax Rate/Area	String	Generic Edit	10	0
47	F15012B	Tenant E.P. Class Master	58	NS	TXA1	Tax Rate/Area	String	Generic Edit	10	0
48	F15013	Sales Overage Master	63	NO	TXA1	Tax Rate/Area	String	Generic Edit	10	0
49	F15013B	Sales Overage Master File	42	NO	TXA1	Tax Rate/Area	String	Generic Edit	10	0
50	F15016	Tenant Escalation Master	50	NU	TXA1	Tax Rate/Area	String	Generic Edit	10	0
51	F15016B	Tenant Escalation Master	53	NU	TXA1	Tax Rate/Area	String	Generic Edit	10	0
52	F1502	Recurring Billings Master	45	NF	TXA1	Tax Rate/Area	String	Generic Edit	10	0
53	F1502B	Recurring Billings Master	45	NF	TXA1	Tax Rate/Area	String	Generic Edit	10	0
54	F1502WB	Estimated EP Recurring Billings	48	N4	TXA1	Tax Rate/Area	String	Generic Edit	10	0
55	F1511	Tenant/Lease Billings Detail	46	NJ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
56	F1511B	Lease Billings Master	46	NJ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
57	F1511H	Tenant/Lease Billings Detail History	46	N#	TXA1	Tax Rate/Area	String	Generic Edit	10	0
58	F1511HB	Lease Billings History	46	NC	TXA1	Tax Rate/Area	String	Generic Edit	10	0
59	F1525	A/R Fee Interest	35	N0	TXA1	Tax Rate/Area	String	Generic Edit	10	0
60	F1525B	Fees and Interest	32	NM	TXA1	Tax Rate/Area	String	Generic Edit	10	0
61	F1538	WF - Expence Participation Register	61	NZ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
62	F1538B	EP Billing Register	63	NZ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP17: Customer Service Management
63	F1720	Contract Header	29	CH	TXA1	Tax Rate/Area	String	Generic Edit	10	0
64	F1721	Contract Detail	34	CD	TXA1	Tax Rate/Area	String	Generic Edit	10	0
65	F4801TZ2	Warranty Claim/Supplier Recovery processing	75	WQ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP17C: Call Management
66	F1755	Case Master	207	ZA	TXA1	Tax Rate/Area	String	Generic Edit	10	0
67	F1760	Time Entry	86	ZB	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP40: Inventory/OP Base
68	F4001Z	Batch Receiver File - Order Headings	59	SY	TXA1	Tax Rate/Area	String	Generic Edit	10	0
69	F4011Z	Batch Receiver File - Order Details	124	SZ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
70	F4012ZW	WF - Destination Quantity	40	SP	TXA1	Tax Rate/Area	String	Generic Edit	10	0
71	F40UI00T	Tax Work File	15	PN	TXA1	Tax Rate/Area	String	Generic Edit	10	0
72	F4201Z1	Sales Order Header Unedited Transaction File	48	SY	TXA1	Tax Rate/Area	String	Generic Edit	10	0
73	F4211Z1	Sales Order Detail Unedited Transaction File	118	SZ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
74	F49211	Sales Order Detail File - Tag File	61	UD	TXA1	Tax Rate/Area	String	Generic Edit	10	0
75	F49211Z1	Sales Order Detail Tag Unedited Transaction File	74	S1	TXA1	Tax Rate/Area	String	Generic Edit	10	0
76	F49219	Sales Order Detail - Tag History File	61	UD	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP42: Sales Management
77	F4201	Sales Order Header File	35	SH	TXA1	Tax Rate/Area	String	Generic Edit	10	0
78	F42019	Sales Order Header History File	35	SH	TXA1	Tax Rate/Area	String	Generic Edit	10	0
79	F4211	Sales Order Detail File	105	SD	TXA1	Tax Rate/Area	String	Generic Edit	10	0
80	F42119	Sales Order History File	105	SD	TXA1	Tax Rate/Area	String	Generic Edit	10	0
81	F42199	S.O. Detail Ledger File	105	SL	TXA1	Tax Rate/Area	String	Generic Edit	10	0
82	F42565	Invoice Print File	43	IW	TXA1	Tax Rate/Area	String	Generic Edit	10	0
83	F42800G1	Sales Update G Batch Detail Workfile	48	DG	TXA1	Tax Rate/Area	String	Generic Edit	10	0
84	F42UI01	SO Header Cache File (MBF)	40	ZH	TXA1	Tax Rate/Area	String	Generic Edit	10	0
85	F42UI12	Sales Order Detail Cache 2 (MBF)	35	ZD	TXA1	Tax Rate/Area	String	Generic Edit	10	0
86	F42UI521	Pick Slips Detail File	88	S9	TXA1	Tax Rate/Area	String	Generic Edit	10	0
87	F470371T	Tag for F470371- EDI shipping Notice Detail - Outbound	81	UZ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP42B: Sales Order Entry
88	F42420	Audit Log Transaction	84	AL	TXA1	Tax Rate/Area	String	Generic Edit	10	0
89	F49299	S.O. Detail Tag Ledger File	61	UD	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP43: Procurement
90	F4301	Purchase Order Header	34	PH	TXA1	Tax Rate/Area	String	Generic Edit	10	0
91	F4301Z	PO Header Work File	38	PA	TXA1	Tax Rate/Area	String	Generic Edit	10	0
92	F4301Z1	Purchase Order Header Unedited Transaction Table	47	SY	TXA1	Tax Rate/Area	String	Generic Edit	10	0
93	F43080	Approvals Fields Constants	94	PD	TXA1	Tax Rate/Area	String	Generic Edit	10	0
94	F4311	Purchase Order Detail File	90	PD	TXA1	Tax Rate/Area	String	Generic Edit	10	0
95	F4311Z	Purchase Order Generator File	94	PW	TXA1	Tax Rate/Area	String	Generic Edit	10	0
96	F4311Z1	Purchase Order Detail Unedited Transaction Table	103	SZ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
97	F43121	Purchase Order Receiver File	64	PR	TXA1	Tax Rate/Area	String	Generic Edit	10	0
98	F43121Z1	Receipts Unedited Transaction Table	81	SZ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
99	F4314Z	Voucher Match Selection File	164	PN	TXA1	Tax Rate/Area	String	Generic Edit	10	0
100	F43199	P.O. Detail Ledger File - Flexible Version	90	OL	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP44H: Homebuilder Management
101	F44H601	Bid Header	36	BH	TXA1	Tax Rate/Area	String	Generic Edit	10	0
102	F44H603	Material Item Pricing	18	MP	TXA1	Tax Rate/Area	String	Generic Edit	10	0
103	F44H611	Bid Details	55	BD	TXA1	Tax Rate/Area	String	Generic Edit	10	0
104	F44H611W	Bid Details Work File	59	BW	TXA1	Tax Rate/Area	String	Generic Edit	10	0
105	F44H711	Lot Start Workfile	62	SW	TXA1	Tax Rate/Area	String	Generic Edit	10	0
106	F44H711P	After Start Purchasing	35	TP	TXA1	Tax Rate/Area	String	Generic Edit	10	0
107	F44H711Z	HB Lot Start Unedited Transaction File	75	SZ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
108	F44H71W1	Lot Start Generation Workfile	62	GW	TXA1	Tax Rate/Area	String	Generic Edit	10	0
109	F44H73W1	Lot Start - P.O. / Committment Generation Work File	50	CG	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP45: Advanced Pricing
110	F45520TX	Price List Header Tax Table	4	PT	TXA1	Tax Rate/Area	String	Generic Edit	10	0
111	F4576Z1	Ship and Debit Claims Unedited Transaction Table	150	Z1	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP47: Electronic Commerce
112	F47011	EDI Purchase Order Header - Inbound	54	SY	TXA1	Tax Rate/Area	String	Generic Edit	10	0
113	F47012	EDI Purchase Order Detail - Inbound	125	SZ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
114	F47016	EDI Purchase Order Header - Outbound	49	SY	TXA1	Tax Rate/Area	String	Generic Edit	10	0
115	F47017	EDI Purchase Order Detail - Outbound	104	SZ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
116	F47021	EDI P.O. Acknowledgment Header - Inbound	49	SY	TXA1	Tax Rate/Area	String	Generic Edit	10	0
117	F47022	EDI P.O. Acknowledgment Detail - Inbound	104	SZ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
118	F47026	EDI P.O. Acknowledgment Header - Outbound	50	SY	TXA1	Tax Rate/Area	String	Generic Edit	10	0
119	F47027	EDI P.O. Acknowledgment Detail - Outbound	125	SZ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
120	F47031	EDI Shipping Notice Header - Inbound	44	SY	TXA1	Tax Rate/Area	String	Generic Edit	10	0
121	F47032	EDI Shipping Notice Detail - Inbound	75	SZ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
122	F47032T	EDI Shipping Notice Detail- Inbound Tag	27	SZ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
123	F47041	EDI Invoice Header - Inbound	35	SY	TXA1	Tax Rate/Area	String	Generic Edit	10	0
124	F47042	EDI Invoice Detail - Inbound	82	SZ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
125	F47046	EDI Invoice Header (Sales) - Outbound	50	SY	TXA1	Tax Rate/Area	String	Generic Edit	10	0
126	F47047	EDI Invoice Detail (Sales) - Outbound	125	SZ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
127	F470473	EDI Invoice Detail Charges	17	S7	TXA1	Tax Rate/Area	String	Generic Edit	10	0
128	F47057	EDI Payment Order Remittance Advice - Outbound	77	D3	TXA1	Tax Rate/Area	String	Generic Edit	10	0
129	F47057W	EDI Payment Order Remittance Advice - Work	77	D3	TXA1	Tax Rate/Area	String	Generic Edit	10	0
130	F47071	EDI Receiving Advice Header - Inbound	50	SY	TXA1	Tax Rate/Area	String	Generic Edit	10	0
131	F47072	EDI Receiving Advice Detail - Inbound	105	SZ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
132	F47076	EDI Receiving Advice Header - Outbound	50	SY	TXA1	Tax Rate/Area	String	Generic Edit	10	0
133	F47077	EDI Receiving Advice Detail - Outbound	105	SZ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
134	F47091	EDI Request for Quote Header - Inbound	54	SY	TXA1	Tax Rate/Area	String	Generic Edit	10	0
135	F47092	EDI Request for Quote Detail - Inbound	125	SZ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
136	F47096	EDI Request for Quote Header - Outbound	49	SY	TXA1	Tax Rate/Area	String	Generic Edit	10	0
137	F47097	EDI Request for Quote Detail - Outbound	104	SZ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
138	F47101	EDI Response to RFQ Header - Inbound	49	SY	TXA1	Tax Rate/Area	String	Generic Edit	10	0
139	F47102	EDI Response to RFQ Detail - Inbound	104	SZ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
140	F47106	EDI Response to RFQ Header - Outbound	50	SY	TXA1	Tax Rate/Area	String	Generic Edit	10	0
141	F47107	EDI Response to RFQ Detail - Outbound	125	SZ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
142	F47131	EDI Purchase Order Change Header - Inbound	51	SY	TXA1	Tax Rate/Area	String	Generic Edit	10	0
143	F47132	EDI Purchase Order Change Detail - Inbound	126	SZ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
144	F47136	EDI Purchase Order Change Header - Outbound	49	SY	TXA1	Tax Rate/Area	String	Generic Edit	10	0
145	F47137	EDI Purchase Order Change Detail - Outbound	105	SZ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
146	F47141	EDI P.O. Change Acknowledgment Header - Inbound	50	SY	TXA1	Tax Rate/Area	String	Generic Edit	10	0
147	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	106	SZ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
148	F47146	EDI P.O. Change Acknowledgment Header - Outbound	51	SY	TXA1	Tax Rate/Area	String	Generic Edit	10	0
149	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	127	SZ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
150	F47156	EDI Shipping Schedule Header - Outbound	52	SY	TXA1	Tax Rate/Area	String	Generic Edit	10	0
151	F47157	EDI Shipping Schedule Detail - Outbound	111	SZ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP48: Work Order Processing
152	F4801ST	Purge - Work Order Master Tag File	62	WA	TXA1	Tax Rate/Area	String	Generic Edit	10	0
153	F4801T	Work Order Master Tag File	62	WA	TXA1	Tax Rate/Area	String	Generic Edit	10	0
154	F4817	Service Order Extension	16	SR	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP48S: Service Billing
155	F4812	Billing Detail Workfile	104	WD	TXA1	Tax Rate/Area	String	Generic Edit	10	0
156	F48127	Tax Derivation Information	10	WO	TXA1	Tax Rate/Area	String	Generic Edit	10	0
157	F4812H	Billing Workfile History	104	WD	TXA1	Tax Rate/Area	String	Generic Edit	10	0
158	F4812HS	Billing Workfile History Purged Save	104	WD	TXA1	Tax Rate/Area	String	Generic Edit	10	0
159	F4822	Invoice Summary Work File	49	W4	TXA1	Tax Rate/Area	String	Generic Edit	10	0
160	F4823	Voucher Summary	45	W0	TXA1	Tax Rate/Area	String	Generic Edit	10	0
161	F48S910	Billing Detail Journal Workfile	87	W2	TXA1	Tax Rate/Area	String	Generic Edit	10	0
162	F48S911	Summarized Journal Workfile	49	W3	TXA1	Tax Rate/Area	String	Generic Edit	10	0
163	F48SUI01	Billing Detail Print Workfile	104	WD	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP49: Transportation Management
164	F4950	Routing Entries	49	RT	TXA1	Tax Rate/Area	String	Generic Edit	10	0
165	F49501	Intermodal Detail Routing Entries	31	RD	TXA1	Tax Rate/Area	String	Generic Edit	10	0
166	F4978	Charge Code Definitions	3	CG	TXA1	Tax Rate/Area	String	Generic Edit	10	0
167	F4981	Freight Audit History	75	FH	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP52: Contract Billing
168	F5201	Contract Master	36	G4	TXA1	Tax Rate/Area	String	Generic Edit	10	0
169	F5202	Contract Billing Line Detail	34	G6	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP52G: Proj & Gov Contract Accounting
170	F4822H	Invoice Summary History	49	IH	TXA1	Tax Rate/Area	String	Generic Edit	10	0
171	F52G01M	Advanced Contracts Modifications	41	CM	TXA1	Tax Rate/Area	String	Generic Edit	10	0
172	F52G90	Invoice Printing Work Table	47	WT	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP54R: Rental Management
173	F54R099	Rental Contract Header Ledger	58	HL	TXA1	Tax Rate/Area	String	Generic Edit	10	0
174	F54R10	Rental Contract Header	56	CH	TXA1	Tax Rate/Area	String	Generic Edit	10	0
175	F54R11	Rental Contract Detail	152	CD	TXA1	Tax Rate/Area	String	Generic Edit	10	0
176	F54R199	Rental Contract Detail Ledger	148	DL	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP70: Multi-National Products
177	F700103	Suspended VAT - Exception Method - COMM - 70	4	EM	TXA1	Tax Rate/Area	String	Generic Edit	10	0
178	F704008	Localizations Additional Fields Tax Area - 04	1	LA	TXA1	Tax Rate/Area	String	Generic Edit	10	0
179	F704100	Suspended VAT AP - COMM - 70	11	VA	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP74: EMEA Localization
180	F740018D	Data extraction ESL - 74	14	DE	TXA1	Tax Rate/Area	String	Generic Edit	10	0
181	F740018W	Data extraction ESL - Workfile - 74	14	DE	TXA1	Tax Rate/Area	String	Generic Edit	10	0
182	F7400C2	Obsolete - R7400C2 Worktable	4	DP	TXA1	Tax Rate/Area	String	Generic Edit	10	0
183	F74091	Class/Register Setup - Italy	2	HA	TXA1	Tax Rate/Area	String	Generic Edit	10	0
184	F74093	Worktable for Printing IVA Summary - Italy	15	HC	TXA1	Tax Rate/Area	String	Generic Edit	10	0
185	F7430033	A/R Document Line (Print Info) - COMM - 03B	7	PI	TXA1	Tax Rate/Area	String	Generic Edit	10	0
186	F743035	Display Taxes by Legal Document Line - COMM - 03B	7	DT	TXA1	Tax Rate/Area	String	Generic Edit	10	0
187	F74900	Foreign Receivables and Payables - EMEA	50	RP	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP74B: Begium Localization
188	F74B100	Monthly VAT Table Belgium Localisations	1	BT	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP74H: Hungary
189	F74H1004	VAT Declaration Detail - HUN -04	9	VD	TXA1	Tax Rate/Area	String	Generic Edit	10	0
190	F74H1007	Tax Rate Summary Setup - HUN - 00	1	TS	TXA1	Tax Rate/Area	String	Generic Edit	10	0
191	F74H410	Foreign Voucher Supplier Amounts - HUN - 74H	5	SA	TXA1	Tax Rate/Area	String	Generic Edit	10	0
192	F74H910	JE VAT Differences - HUN - 09	5	VD	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP74L: Portugal
193	F74L3035	Tax Details by Legal Document - POR - 74L	6	TD	TXA1	Tax Rate/Area	String	Generic Edit	10	0
194	F74L4008	Tax Rate/Area Additional Information - Tag File- POR - 74L	1	TK	TXA1	Tax Rate/Area	String	Generic Edit	10	0
195	F74LUI03	Tax Details - Temp Table - 74L	2	TT	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP74R: Russia
196	F74R0018	Russian Tax File - 74R	23	TD	TXA1	Tax Rate/Area	String	Generic Edit	10	0
197	F74R0480	Pay Item Differences - RUS - 04 - 74R	8	RP	TXA1	Tax Rate/Area	String	Generic Edit	10	0
198	F74R311	Prepayment Detail Tax File - RUS - 03B	30	DE	TXA1	Tax Rate/Area	String	Generic Edit	10	0
199	F74R400	Account Payable Setup for VAT Release - RUS - 00	1	VR	TXA1	Tax Rate/Area	String	Generic Edit	10	0
200	F74R410	Tax on Hold - RUS - 04	4	TH	TXA1	Tax Rate/Area	String	Generic Edit	10	0
201	F74R420	Tax Releases - RUS - 04	4	TR	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP74S: Spain
202	F74S408	Tax Areas - 340 Model - ESP - 00	1	TA	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP74U: United Kingdom Localizations
203	F74U0205	Payment Profile - 15	7	P8	TXA1	Tax Rate/Area	String	Generic Edit	10	0
204	F74U0212	Accounting Billing Profile - 15	7	P8	TXA1	Tax Rate/Area	String	Generic Edit	10	0
205	F74U0213	Weekly Accounting Profile - 15	8	PW	TXA1	Tax Rate/Area	String	Generic Edit	10	0
206	F74U0405	SPC Certificate Holding Table - UK - 43	45	CH	TXA1	Tax Rate/Area	String	Generic Edit	10	0
207	F74U0420	SPC - Application Master - UK - 43	33	SE	TXA1	Tax Rate/Area	String	Generic Edit	10	0
208	F74U0425	SPC - Certificate Master - UK - 43	35	SF	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP74Y: Italy
209	F740018A	Tax Rate Area and Transaction Type Mapping	1	TT	TXA1	Tax Rate/Area	String	Generic Edit	10	0
210	F743B14I	Suspended IVA Generation - Receipt/Rebate Control-Ita - 03B	22	TI	TXA1	Tax Rate/Area	String	Generic Edit	10	0
211	F74Y008	Intrastat Additional Info for Service Tax Areas - ITA - 00	1	IN	TXA1	Tax Rate/Area	String	Generic Edit	10	0
212	F74Y010	Black List Setup by Country Tax Area	2	BL	TXA1	Tax Rate/Area	String	Generic Edit	10	0
213	F74Y011	Multi Purpose VAT Classification by Tax Area / Item - 74Y	1	MP	TXA1	Tax Rate/Area	String	Generic Edit	10	0
214	F74Y015	Yearly List Declaration - WF - IT - 00	19	YL	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP74Z: Czech Republic
215	F74ZUI02	Czech VAT Report - CZE - 74Z - Work File	2	CZ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP75J: Japan
216	F75J504	Setup Rounding Options - 75J - JAP	2	RO	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP75T: Taiwan
217	F75T004	GUI/VAT Transaction Header - 75T	17	TH	TXA1	Tax Rate/Area	String	Generic Edit	10	0
218	F75T0049	GUI/VAT Transaction Header History - 75T	17	TH	TXA1	Tax Rate/Area	String	Generic Edit	10	0
219	F75T004P	GUI/VAT Transaction Header POS - 75T	16	TH	TXA1	Tax Rate/Area	String	Generic Edit	10	0
220	F75T004Z	GUI/VAT Transaction Header - Work - 75T	15	ZH	TXA1	Tax Rate/Area	String	Generic Edit	10	0
221	F75T005	GUI/VAT Transaction Detail - 75T	14	TD	TXA1	Tax Rate/Area	String	Generic Edit	10	0
222	F75T0059	GUI/VAT Transaction Detail History - 75T	14	TD	TXA1	Tax Rate/Area	String	Generic Edit	10	0
223	F75T005P	GUI/VAT Transaction Detail POS - 75T	14	TD	TXA1	Tax Rate/Area	String	Generic Edit	10	0
224	F75T005T	GUI/VAT Transaction Detail Temp - 75T	14	TD	TXA1	Tax Rate/Area	String	Generic Edit	10	0
225	F75T005Z	GUI/VAT Transaction Detail - Work - 75T	21	ZD	TXA1	Tax Rate/Area	String	Generic Edit	10	0
226	F75T008	GUI/VAT Tax Type Mapping - 75T	1	TM	TXA1	Tax Rate/Area	String	Generic Edit	10	0
227	F75T42W	Work file with union of F4211 and F42119	30	SW	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP76A: Argentina
228	F764008A	Aditionals Tax Areas - ARG - 04 - 76A	1	TQ	TXA1	Tax Rate/Area	String	Generic Edit	10	0
229	F76A15	Taxes - Effective and Expiration Dates - ARG - 00 - 76A	1	TE	TXA1	Tax Rate/Area	String	Generic Edit	10	0
230	F76A16	Taxes - Tax Groups - ARG - 00 - 76A	1	TG	TXA1	Tax Rate/Area	String	Generic Edit	10	0
231	F76A17	Taxes - Invoice/Shipment Note Letter - ARG - 03B - 76A	1	TL	TXA1	Tax Rate/Area	String	Generic Edit	10	0
232	F76A21	Credit Invoice Header - F76A21 - ARG - 3B - 76A	18	IH	TXA1	Tax Rate/Area	String	Generic Edit	10	0
233	F76A21P	Credit Invoice Header Purge - ARG - 03B - 76A	18	IH	TXA1	Tax Rate/Area	String	Generic Edit	10	0
234	F76A25	Credit Invoice Tax Area Relationship - ARG - 04 - 76A	1	IF	TXA1	Tax Rate/Area	String	Generic Edit	10	0
235	F76AUI89	Work File to Generate ND/NC Gain/Loss - ARG - 03B - 76A	22	WF	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP76C: Colombia
236	F76C0005	Tax Areas Relationship Setup - CO - 76C	1	TX	TXA1	Tax Rate/Area	String	Generic Edit	10	0
237	F76C031A	A/R Customer ledger As Of - F76C031A - COL - 04	42	RP	TXA1	Tax Rate/Area	String	Generic Edit	10	0
238	F76C0411	A/P Tag File - COL - 76C	9	RP	TXA1	Tax Rate/Area	String	Generic Edit	10	0
239	F76C4008	Additionals Tax Areas - COL - 04	1	TA	TXA1	Tax Rate/Area	String	Generic Edit	10	0
240	F76C575	Work File Magnetic Media - COL - 04	48	Q1	TXA1	Tax Rate/Area	String	Generic Edit	10	0
241	F76CI3	Tax Areas Tag File - COL - 76C	1	TA	TXA1	Tax Rate/Area	String	Generic Edit	10	0
242	F76CT2	Sales/Use/V.A.T. Tax File - COL - 76C	17	CT	TXA1	Tax Rate/Area	String	Generic Edit	10	0
243	F76CUI02	Tax Detail - Work File - COL - 76C	9	TD	TXA1	Tax Rate/Area	String	Generic Edit	10	0
244	F76CUI04	Tax Detail for Distribution - Work File - COL - 76C	10	TD	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP76E: Ecuador
245	F76E4020	Withholding Certificate Information w/ SRI - EC - 04	5	CR	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP76H: Chile
246	F76H003	Tax Area Type - CHI - 00 - 76H	1	TT	TXA1	Tax Rate/Area	String	Generic Edit	10	0
247	F76H004	Tax Area Non-Reimbursable - CHI - 00 - 76H	1	TN	TXA1	Tax Rate/Area	String	Generic Edit	10	0
248	F76H020	Tax rate columns reports set up - CHI - 00 - 76H	1	NO	TXA1	Tax Rate/Area	String	Generic Edit	10	0
249	F76H218	Taxes by Sales Order Line - CHI - 42 - 76H	8	TD	TXA1	Tax Rate/Area	String	Generic Edit	10	0
250	F76HUI32	Workfile for R76H3B40 - CHI - 42 - 76H	24	WF	TXA1	Tax Rate/Area	String	Generic Edit	10	0
251	F76HUI33	Workfile for R76H3B40 - CHI - 42 - 76H	12	WF	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP76P: Peru
252	F76P030	Taxable non taxable reports set up - PER - 04 - 76P	1	TS	TXA1	Tax Rate/Area	String	Generic Edit	10	0
253	F76PUI45	Workfile VAT Purchasing Ledger - PER - 04 - 76P	11	WF	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP76V: Venezuela
254	F76V306	A/R Tax Area / Fiscal Operation Codification - VEN - 03B	1	RT	TXA1	Tax Rate/Area	String	Generic Edit	10	0
255	F76V406	A/P Tax Area / Fiscal Operation Codification - VEN - 04	1	PT	TXA1	Tax Rate/Area	String	Generic Edit	10	0
256	F76VLC01	Purchase Register Temporal - VEN -04 - 76V	2	LC	TXA1	Tax Rate/Area	String	Generic Edit	10	0
257	F76VLV01	Temporal Table for VAT Type - R76VLV01 - VEN -03B - 76V	1	IM	TXA1	Tax Rate/Area	String	Generic Edit	10	0
258	F76VLV03	Temporal Table for VAT Type - R76VLV02 - VEN -03B - 76V	1	IA	TXA1	Tax Rate/Area	String	Generic Edit	10	0
TOP89: Conversion Programs
259	F43199A	Temp F43199 for ERP 9.0 Upgrade	90	OL	TXA1	Tax Rate/Area	String	Generic Edit	10	0

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

259 columns | 920 | TXA1