	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	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

102 tables812 | 76B

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
76B: Brazil - Reporting System Only
1	812	F7600B	NI	15	1	Nota Fiscal Next Number Control - Brazil	Transaction Files	00: Foundation Environment	AS400 Coexistence Tables
2	812	F76011	AI	35	2	Address Book Brazilian Tag File	Transaction Files	04: Accounts Payable	No
3	812	F76011P	PR	35	2	Archive Address Book Brazilian Tag Table - 04	Transaction Files	76: Latin American Localization	Business Data
4	812	F7601B	FH	87	3	Nota Fiscal Header - Brazil	Master Files	42: Sales Management	AS400 Coexistence Tables
5	812	F7602B	NJ	12	1	Fiscal Book Next Number Control - Brazil	Transaction Files	00: Foundation Environment	AS400 Coexistence Tables
6	812	F7603B1	CI	25	1	A/R Additional Information - Brazil	Master Files	03B: Enhanced Accounts Receivable	AS400 Coexistence Tables
7	812	F7603B1P	BP	25	1	Archive A/R Additional Information - Brazil - 03B	Purge Files	76: Latin American Localization	Business Data
8	812	F7603BZ1	BS	2	1	Bank Data - Remessa - Brazil	Communication Files	03B: Enhanced Accounts Receivable	AS400 Coexistence Tables
9	812	F7603BZ2	BR	2	1	Bank Data - Retorno - Brazil	Communication Files	03B: Enhanced Accounts Receivable	AS400 Coexistence Tables
10	812	F7606B	MI	7	1	Branch/Plant Fiscal Company X-Reference - Brazil	Secondary Master Files	00: Foundation Environment	AS400 Coexistence Tables
11	812	F7608B	TB	17	1	ICMS Tax Rates	Constants Files	40: Inventory/OP Base	AS400 Coexistence Tables
12	812	F76101B	QX	60	4	Nota Fiscal - Header (Fiscal Books) - 42	Master Files	76: Latin American Localization	Business Data
13	812	F76111B	QU	59	1	Nota Fiscal - Detail (Fiscal Books) - 42	Master Files	76: Latin American Localization	Business Data
14	812	F76111BT	TA	44	1	Conversion table for CFOP 5 digits - F76111B - 42	Files	76: Latin American Localization
15	812	F7611B	FD	114	5	Nota Fiscal Detail - Brazil	Master Files	42: Sales Management	AS400 Coexistence Tables
16	812	F76121B	FZ	12	1	Nota Fiscal Print Message Header - Brazil	Extra Features Files	42: Sales Management	AS400 Coexistence Tables
17	812	F7612B	FY	14	1	Nota Fiscal Print Message - Brazil	Extra Features Files	42: Sales Management	AS400 Coexistence Tables
18	812	F7615B	TN	15	1	Transaction Nature - Brazil	Transaction Files	42B: Sales Order Entry	AS400 Coexistence Tables
19	812	F7617B	TS	16	1	Code - ICMS IPI Tax Summa	Transaction Files	40: Inventory/OP Base	AS400 Coexistence Tables
20	812	F761BA	FB	111	1	AS Fiscal file book	Regular Work Files	09: General Accounting	AS400 Coexistence Tables
21	812	F76411	IT	16	1	Item Master Regional Information - Brazil	Transaction Files	41: Inventory Management	No
22	812	F76412	IJ	19	1	Item Branch Regional Information - Brazil	Transaction Files	41: Inventory Management	No
23	812	F76421	SI	12	1	Sales Order Header Tag File - Brazil	Master Files	42: Sales Management	AS400 Coexistence Tables
24	812	F76422	SJ	18	1	Sales Order Detail Tag File - Brazil	Transaction Files	42: Sales Management	AS400 Coexistence Tables
25	812	F76422UI	WF	18	1	Work File for temporary F76422 Records - Brazil	Work Files	42: Sales Management	AS400 Coexistence Tables
26	812	F76431	PI	11	1	Purchase Order Header Tag File - Brazil	Master Files	43: Procurement	AS400 Coexistence Tables
27	812	F76432	PJ	18	1	Purchase Order Detail Tag File - Brazil	Transaction Files	43: Procurement	AS400 Coexistence Tables
28	812	F76B001	TH	25	1	Nota Fiscal Taxes Header - Brazil - 42	Files	76: Latin American Localization
29	812	F76B003	PU	50	1	Purchase Use Tax Setup - Brazil - 42	Files	76: Latin American Localization
30	812	F76B006	BB	11	2	IN86-Work Table for Business Unit - 09	Work Files	76: Latin American Localization
31	812	F76B011	TD	32	2	Nota Fiscal Taxes Detail - Brazil - 42	Files	76: Latin American Localization
32	812	F76B0401	CT	23	1	Tax Code - 04	Files	76: Latin American Localization	Business Data
33	812	F76B0402	TP	4	1	IR Progressive - 04	Files	76: Latin American Localization	Business Data
34	812	F76B0403	ST	15	1	Service Taxes Paid Externally - 04	Files	76: Latin American Localization
35	812	F76B0411	VB	32	2	Voucher Additional Information Brazil - 04	Secondary Master Files	76: Latin American Localization
36	812	F76B04A	RF	38	1	Generation for Federal Tax Authority - 04	Files	76: Latin American Localization	Business Data
37	812	F76B04BC	BC	11	1	Voucher Additional Information - Brazil - 04	Secondary Master Files	76: Latin American Localization	Business Data
38	812	F76B10	AR	24	1	Account Ledger - IN68 - 09	Files	76: Latin American Localization	Business Data
39	812	F76B102	QD	14	1	Verification ICMS / IPI - Statement - 42	Master Files	76: Latin American Localization	Business Data
40	812	F76B103	QD	11	1	Verification ICMS / IPI - Information - 42	Master Files	76: Latin American Localization	Business Data
41	812	F76B104	QD	6	1	Verification ICMS / IPI - Comments - 42	Master Files	76: Latin American Localization	Business Data
42	812	F76B105	QC	15	2	GNRE Table - 42	Master Files	76B: Brazil - Reporting System Only	Business Data
43	812	F76B11	AB	17	1	Account Balances - IN68 - 09	Files	76: Latin American Localization	Business Data
44	812	F76B127A	TC	13	1	GIA Valid DIPAM-B Code - 42	Files	76: Latin American Localization	Business Data
45	812	F76B127B	TC	13	2	GIA DIPAM-B Cross Reference - 42	Files	76: Latin American Localization	Business Data
46	812	F76B128A	TC	13	1	GIA Sub-Item Code - 42	Files	76: Latin American Localization	Business Data
47	812	F76B128B	TC	16	1	GIA Occurrences - 42	Files	76: Latin American Localization	Business Data
48	812	F76B129	TC	14	3	GIA Company Profile - 42	Files	76: Latin American Localization	Business Data
49	812	F76B130	TC	16	1	Electronic GIA Header - 42	Files	76: Latin American Localization	Business Data
50	812	F76B131	TC	16	2	Electronic GIA Detail - 42	Files	76: Latin American Localization	Business Data
51	812	F76B132	TC	13	2	GIA City Code - 42	Files	76: Latin American Localization	Business Data
52	812	F76B18	FC	15	1	IPI Taxes	Master Files	40: Inventory/OP Base	AS400 Coexistence Tables
53	812	F76B20	PR	20	1	Account Payable and Receivable Table - IN68 - 03B	Files	76: Latin American Localization	Business Data
54	812	F76B200	DP	11	2	Table for BNOP Conversion (Fiscal Books only) - 42	Files	76: Latin American Localization	Business Data
55	812	F76B30	MM	40	1	Nota Fiscal Header/Table for Goods - IN68 - 42	Files	76: Latin American Localization	Business Data
56	812	F76B3010	IP	24	2	Work Table for Item/Part List - 30	Files	76: Latin American Localization
57	812	F76B31	IM	46	1	Nota Fiscal Detail/Table for Goods - IN68 - 42	Files	76: Latin American Localization	Business Data
58	812	F76B40	MS	21	1	Nota Fiscal Header/Table for Services - IN68 - 42	Files	76: Latin American Localization	Business Data
59	812	F76B400A	SC	41	2	IN86-Work Table for Storage Control - 41	Files	76: Latin American Localization
60	812	F76B400B	IR	31	2	IN86-Work Table for Inventory Records - 41	Files	76: Latin American Localization
61	812	F76B400F	TN	27	2	IN86-Work Table for Transaction Nature - 42	Files	76: Latin American Localization
62	812	F76B400G	IS	27	2	IN86-Work Table for Item Number and Service Code - 41	Files	76: Latin American Localization
63	812	F76B4012	VP	15	1	Voucher Tax Processed File - BR - 04	Files	76B: Brazil - Reporting System Only
64	812	F76B4016	AA	14	1	Tax Accumulates by AN8 - BR - 04	Files	76B: Brazil - Reporting System Only
65	812	F76B4017	AC	13	1	Tax Accumulates by AN8 - Company - BR - 04	Files	76B: Brazil - Reporting System Only
66	812	F76B41	IS	21	1	Nota Fiscal Detail/Table for Services - IN68 - 42	Files	76: Latin American Localization	Business Data
67	812	F76B4100	PS	6	1	Withholding Data Conversion Status - BR - 04	Files	76B: Brazil - Reporting System Only
68	812	F76B410C	SH	37	1	IN86-Work Table for Services Outbound Nota Fiscal Hea - 42	Files	76: Latin American Localization
69	812	F76B410D	CH	54	1	IN86-Work Table for Merchandise Nota Fiscal Issued by - 42	Files	76: Latin American Localization
70	812	F76B410E	SH	44	1	IN86-Work Table for Merchandise NF Issued by Supplier - 41	Files	76: Latin American Localization
71	812	F76B410H	SI	46	1	INSS-Work Table for Services Third Party Inbound NF H - 42	Files	76: Latin American Localization
72	812	F76B411A	WM	11	1	PIS - COFINS and CSLL bellow minimum - BR - 04	Files	76B: Brazil - Reporting System Only
73	812	F76B411C	SD	38	1	IN86-Work Table for Services Outbound Nota Fiscal Det - 42	Files	76: Latin American Localization
74	812	F76B411D	CD	55	1	IN86-Work Table for Merchandise Nota Fiscal Issued by - 42	Files	76: Latin American Localization
75	812	F76B411E	SD	55	1	IN86-Work Table for Merchandise NF Issued by Supplier - 41	Files	76: Latin American Localization
76	812	F76B471	DL	8	1	Dynamic Formater Layouts - 03B	Secondary Master Files	76: Latin American Localization	Business Data
77	812	F76B472	DD	10	1	Dynamic Formater Layout Transaction and Line Types - 03B	Secondary Master Files	76: Latin American Localization	Business Data
78	812	F76B473	DS	21	3	Dynamic Formater Layouts Specification - 03B	Secondary Master Files	76: Latin American Localization	Business Data
79	812	F76B473T	W3	38	1	F04573 Brazilian Temp WH File - BR - 04	Files	76B: Brazil - Reporting System Only
80	812	F76B474	BA	12	1	Dynamic Formater Bank Attributes - 03B	Secondary Master Files	76: Latin American Localization	Business Data
81	812	F76B474I	BI	18	4	File Upload For Bank Transaction Inbound Process - 03B	Secondary Master Files	76: Latin American Localization	Business Data
82	812	F76B475	BL	9	1	Dynamic Formater Bank Layout by Payment Instument - 03B	Secondary Master Files	76: Latin American Localization	Business Data
83	812	F76B476	BX	11	2	Dynamic Formater Bank Attributes Cross Reference - 03B	Secondary Master Files	76: Latin American Localization	Business Data
84	812	F76B477	BG	11	2	Dynamic Formater GL Bank Account File Numbers - 03B	Secondary Master Files	76: Latin American Localization	Business Data
85	812	F76B50	CE	29	1	Item Ledger Table - IN68 - 42	Files	76: Latin American Localization	Business Data
86	812	F76B51	RI	16	1	Inventory Records Table - IN68 - 42	Files	76: Latin American Localization	Business Data
87	812	F76B60	PR	11	1	Products Table - IN68 - 30	Files	76: Latin American Localization	Business Data
88	812	F76B61	IE	14	2	Packing and Raw Material Table - IN68 - 30	Files	76: Latin American Localization	Business Data
89	812	F76B62	BI	33	1	Fixed Assets Table - IN68 - 12	Files	76: Latin American Localization	Business Data
90	812	F76B63	BD	10	1	Information for Depreciation on Hold Table - IN68 - 12	Files	76: Latin American Localization	Business Data
91	812	F76B64	BS	17	1	Balances/JE's w/ Currency Correction Table - IN68 - 12	Files	76: Latin American Localization	Business Data
92	812	F76B70	FJ	20	2	Physical and Legal Person Table - IN68 - 42	Files	76: Latin American Localization	Business Data
93	812	F76B80	CD	9	2	Codes Table - IN68 - 42	Files	76: Latin American Localization	Business Data
94	812	F76B8200	FA	32	1	IN86-Work Table for Fixed Assets - 12	Files	76: Latin American Localization
95	812	F76B8601	FJ	20	1	IN86-Work Table for Individuals and Legal Entities - 04	Work Files	76: Latin American Localization	Business Data
96	812	F76B8602	PR	30	4	IN86-Work Table for Suppliers and Customers - 04	Work Files	76: Latin American Localization	Business Data
97	812	F76B901	BA	18	2	IN86- Work Table for Account Master - 09	Work Files	76: Latin American Localization
98	812	F76B902	BC	22	2	IN86-Work Table for Account Balance - 09	Work Files	76: Latin American Localization
99	812	F76B911	BD	27	2	IN86-Work Table for Journal Entries - 09	Work Files	76: Latin American Localization
100	812	F76BUI01	WF	3	1	Install Process Workfile - BR - 04	Files	76B: Brazil - Reporting System Only
101	812	T76B001	QA	3	1	Temporary file for DIPJ - Customer / Supplier - 42	"T" Work Files	76: Latin American Localization	Business Data
102	812	T76B002	QB	4	1	Temporary file for DIPJ - Material - 42	"T" Work Files	76: Latin American Localization	Business Data

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

102 tables812 | 76B