	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

87 COLUMNS | 3 INDEXES | 812 | 76B | F7601B TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
76B: Brazil - Reporting System Only
1	812	F7601B	FH	87	3	Nota Fiscal Header - Brazil	Master Files	42: Sales Management	AS400 Coexistence Tables

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

SELECT FHBNNF, FHBSER, FHN001, FHDCT, FHBNF0, FHBSR0, FHN002, FHBNFS, FHOCTO, FHMCU, FHCO, FHFCO, FHSHAN, FHAN8, FHBCGT, FHBCPT, FHSHST, FHSHZP, FHVR01, FHBSFH, FHAN8V, FHBCGF, FHBCPF, FHADDS, FHBFRT, FHBSEG, FHBDFN, FHBDES, FHBVTM, FHGDVL, FHBVTN, FHBICM, FHBBCL, FHBVIS, FHBBIS, FHBREP, FHBDIZ, FHBVII, FHBVOI, FHBIPI, FHBBTP, FHBVOP, FHBVIP, FHBISS, FHBBCS, FHBIRT, FHBBCR, FHBIIT, FHBBCI, FHIRRI, FHISSU, FHSHPJ, FHADDJ, FHCNDJ, FHDETM, FHBINM, FHLNID, FHANCR, FHBCGC, FHCRTY, FHFRTH, FHLICP, FHSTCD, FHTOQN, FHEQUP, FHR2, FHREF, FHITWT, FHTOWT, FHBD01, FHAA1, FHBD02, FHAA2, FHBD03, FHBD04, FHBVLF, FHUSER, FHPID, FHJOBN, FHUPMJ, FHTDAY, FHBBIR, FHBIPR, FHCRCD, FHFTR, FHF1T, FHUSB1 FROM F7601B

TOP 812 | 76B | F7601B COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	FHBNNF	Nota Fiscal Number	Numeric	Generic Edit	6	0	Allow NULL?
2	FHBSER	Nota Fiscal Series	String	Generic Edit	2	0	Allow NULL?
3	FHN001	Next Number Range 1	Numeric	Generic Edit	8	0	Allow NULL?
4	FHDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
5	FHBNF0	Nota Fiscal Number - Original	Numeric	Generic Edit	6	0	Allow NULL?
6	FHBSR0	Nota Fiscal Series - Original	String	Generic Edit	2	0	Allow NULL?
7	FHN002	Next Number Range 2	Numeric	Generic Edit	8	0	Allow NULL?
8	FHBNFS	Nota Fiscal Source	Character	UDC (76 NF)	1	0	Allow NULL?
9	FHOCTO	Original Order Type	String	UDC (00 DT)	2	0	Allow NULL?
10	FHMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
11	FHCO	Company	String	Generic Edit	5	0	Allow NULL?
12	FHFCO	Company From	String	Generic Edit	5	0	Allow NULL?
13	FHSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
14	FHAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
15	FHBCGT	CGC Tax ID - Ship To	String	Generic Edit	15	0	Allow NULL?
16	FHBCPT	FederaL Taxpayer ID - Person- Ship To	String	Generic Edit	11	0	Allow NULL?
17	FHSHST	State - Ship to State	String	UDC (00 S)	3	0	Allow NULL?
18	FHSHZP	Zip Code - Ship to Postal Code	String	Generic Edit	12	0	Allow NULL?
19	FHVR01	Reference	String	Generic Edit	25	0	Allow NULL?
20	FHBSFH	Address Number - Ship From	Numeric	Generic Edit	8	0	Allow NULL?
21	FHAN8V	Address Number - Supplier	Numeric	Generic Edit	8	0	Allow NULL?
22	FHBCGF	CGC Tax ID - Ship From	String	Generic Edit	15	0	Allow NULL?
23	FHBCPF	FederaL Taxpayer ID - Person- Ship From	String	Generic Edit	11	0	Allow NULL?
24	FHADDS	State	String	UDC (00 S)	3	0	Allow NULL?
25	FHBFRT	Amount - Nota Fiscal Freight	Numeric	Generic Edit	15	2	Allow NULL?
26	FHBSEG	Amount - Nota Fiscal Insurance	Numeric	Generic Edit	15	2	Allow NULL?
27	FHBDFN	Amount - Nota Fiscal Financial Expenses	Numeric	Generic Edit	15	2	Allow NULL?
28	FHBDES	Amount - Nota Fiscal Discount	Numeric	Generic Edit	15	2	Allow NULL?
29	FHBVTM	Amount - Price Net	Numeric	Generic Edit	15	2	Allow NULL?
30	FHGDVL	Amount - Goods Value	Numeric	Generic Edit	15	2	Allow NULL?
31	FHBVTN	Amount - Nota Fiscal Total	Numeric	Generic Edit	15	2	Allow NULL?
32	FHBICM	Amount - ICMS Tax	Numeric	Generic Edit	15	2	Allow NULL?
33	FHBBCL	Amount - ICMS Taxable	Numeric	Generic Edit	15	2	Allow NULL?
34	FHBVIS	Amount - ICMS Substitute	Numeric	Generic Edit	15	2	Allow NULL?
35	FHBBIS	Amount - ICMS Substitute Taxable	Numeric	Generic Edit	15	2	Allow NULL?
36	FHBREP	Amount - ICMS Repass Discount	Numeric	Generic Edit	15	2	Allow NULL?
37	FHBDIZ	Amount - ICMS Free Port Zone Discount	Numeric	Generic Edit	15	2	Allow NULL?
38	FHBVII	Amount - ICMS Exempt	Numeric	Generic Edit	15	2	Allow NULL?
39	FHBVOI	Amount - ICMS Other	Numeric	Generic Edit	15	2	Allow NULL?
40	FHBIPI	Amount - IPI Tax	Numeric	Generic Edit	15	2	Allow NULL?
41	FHBBTP	Amount - IPI Taxable	Numeric	Generic Edit	15	2	Allow NULL?
42	FHBVOP	Amount - IPI Other	Numeric	Generic Edit	15	2	Allow NULL?
43	FHBVIP	Amount - IPI Exempt	Numeric	Generic Edit	15	2	Allow NULL?
44	FHBISS	Amount - ISS Tax	Numeric	Generic Edit	15	2	Allow NULL?
45	FHBBCS	Amount - ISS Taxable	Numeric	Generic Edit	15	2	Allow NULL?
46	FHBIRT	Amount - IR Tax	Numeric	Generic Edit	15	2	Allow NULL?
47	FHBBCR	Amount - IR Taxable	Numeric	Generic Edit	15	2	Allow NULL?
48	FHBIIT	Amount - II Tax	Numeric	Generic Edit	15	2	Allow NULL?
49	FHBBCI	Amount - II Taxable	Numeric	Generic Edit	15	2	Allow NULL?
50	FHIRRI	Withholding Tax Amount	Numeric	Generic Edit	15	2	Allow NULL?
51	FHISSU	Date - Issue	Date	Generic Edit	6	0
52	FHSHPJ	Date - Shipped (Julian)	Date	Generic Edit	6	0
53	FHADDJ	Date - Actual Ship Date	Date	Generic Edit	6	0
54	FHCNDJ	Date - Cancel	Date	Generic Edit	6	0
55	FHDETM	Time - Departure	Numeric	Generic Edit	6	0	Allow NULL?
56	FHBINM	Print Message - Fiscal Purpose	String	UDC (40 PM)	10	0	Allow NULL?
57	FHLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
58	FHANCR	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
59	FHBCGC	CGC Tax ID - Carrier	String	Generic Edit	15	0	Allow NULL?
60	FHCRTY	Carrier Type	String	Generic Edit	3	0	Allow NULL?
61	FHFRTH	Freight Handling Code	String	UDC (42 FR)	3	0	Allow NULL?
62	FHLICP	License Plate Number	String	Generic Edit	10	0	Allow NULL?
63	FHSTCD	State Code	String	Generic Edit	3	0	Allow NULL?
64	FHTOQN	Total Quantity	Numeric	Generic Edit	15	2	Allow NULL?
65	FHEQUP	Description - Equipment	String	Generic Edit	15	0	Allow NULL?
66	FHR2	Reference 2	String	Generic Edit	8	0	Allow NULL?
67	FHREF	Reference	String	Generic Edit	15	0	Allow NULL?
68	FHITWT	Unit Weight	Numeric	Generic Edit	15	4	Allow NULL?
69	FHTOWT	Total Weight	Numeric	Generic Edit	15	4	Allow NULL?
70	FHBD01	Category Code - Fiscal Remarks 01	String	UDC (76 MC)	3	0	Allow NULL?
71	FHAA1	Amount	Numeric	Generic Edit	15	2	Allow NULL?
72	FHBD02	Category Code - Fiscal Remarks 02	String	UDC (76 MC)	3	0	Allow NULL?
73	FHAA2	Amount	Numeric	Generic Edit	15	2	Allow NULL?
74	FHBD03	Category Code - Fiscal Remarks 03	String	UDC (76 FM)	3	0	Allow NULL?
75	FHBD04	Category Code - Fiscal Remarks 04	String	UDC (76 FM)	3	0	Allow NULL?
76	FHBVLF	Amount - Fiscal Book Value	Numeric	Generic Edit	15	2	Allow NULL?
77	FHUSER	User ID	String	Generic Edit	10	0	Allow NULL?
78	FHPID	Program ID	String	Generic Edit	10	0	Allow NULL?
79	FHJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
80	FHUPMJ	Date - Updated	Date	Generic Edit	6	0
81	FHTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
82	FHBBIR	Amount - ICMS Reduced Taxable	Numeric	Generic Edit	15	2	Allow NULL?
83	FHBIPR	Amount - IPI Tax Recoverable	Numeric	Generic Edit	15	2	Allow NULL?
84	FHCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
85	FHFTR	Amount - Future Amount Due	Numeric	Generic Edit	15	2	Allow NULL?
86	FHF1T	Future 1 Text	String	Generic Edit	30	0	Allow NULL?
87	FHUSB1	Future 1 (Julian)	Date	Generic Edit	6	0

TOP 812 | 76B | F7601B INDEXES

Number

Description

NotaFiscal (Primary/Unique)

Element	Alias	Description	Sequence
1	BNNF	Nota Fiscal Number	Ascending
2	BSER	Nota Fiscal Series	Ascending
3	N001	Next Number Range 1	Ascending
4	DCT	Document Type	Ascending

NFNumber NFSeries DocumentType

Element	Alias	Description	Sequence
1	BNNF	Nota Fiscal Number	Ascending
2	BSER	Nota Fiscal Series	Ascending
3	DCT	Document Type	Ascending

ShipFrom NF Number +

Element	Alias	Description	Sequence
1	BSFH	Address Number - Ship From	Ascending
2	BNNF	Nota Fiscal Number	Ascending
3	BSER	Nota Fiscal Series	Ascending
4	DCT	Document Type	Ascending

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

87 COLUMNS | 3 INDEXES | 812 | 76B | F7601B TABLE

TOP 812 | 76B | F7601B COLUMNS

TOP 812 | 76B | F7601B INDEXES

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

87 COLUMNS | 3 INDEXES | 812 | 76B | F7601B TABLE

TOP812 | 76B | F7601B COLUMNS

TOP812 | 76B | F7601B INDEXES

TOP 812 | 76B | F7601B COLUMNS

TOP 812 | 76B | F7601B INDEXES