	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

114 COLUMNS | 5 INDEXES | 812 | 76B | F7611B TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
76B: Brazil - Reporting System Only
1	812	F7611B	FD	114	5	Nota Fiscal Detail - 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 FDBNNF, FDBSER, FDN001, FDDCT, FDUKID, FDSOS1, FDBNF0, FDBSR0, FDN002, FDBNFS, FDOCTO, FDMATC, FDDOCO, FDPDCT, FDKCOO, FDSFXO, FDLNID, FDNLIN, FDDOC, FDDCTO, FDCO, FDFCO, FDITM, FDLITM, FDAITM, FDCITM, FDMCU, FDLOCN, FDLOTN, FDDSC1, FDDSC2, FDLNTY, FDUOM, FDUORG, FDUOM3, FDUOM4, FDUPRC, FDAEXP, FDBDES, FDGLC, FDSHAN, FDAN8, FDBCGT, FDBCPT, FDSHST, FDSHZP, FDBSFH, FDAN8V, FDBCGF, FDBCPF, FDADDS, FDBNOP, FDBSOP, FDBDIP, FDBCLF, FDBCTF, FDBIST, FDBORI, FDBCFC, FDBSTT, FDBST1, FDBFRT, FDBSEG, FDBDFN, FDBICM, FDTXR1, FDBBCL, FDBBIR, FDBVIS, FDBBIS, FDBREP, FDBDIZ, FDBICP, FDBFII, FDBIPR, FDBIPI, FDTXR2, FDBBTP, FDBFIP, FDBISS, FDTXR3, FDBBCS, FDBIRT, FDTXR4, FDBBCR, FDBIIT, FDTXR5, FDBBCI, FDANI, FDAID, FDOMCU, FDOBJ, FDSUB, FDSBLT, FDSBL, FDBINM, FDISSU, FDBNIV, FDPGNO, FDNXTR, FDLTTR, FDUSER, FDPID, FDJOBN, FDUPMJ, FDTDAY, FDCRCD, FDFTR, FDF1T, FDF2A, FDF2T, FDUSB1, FDFLD3, FDFLD4 FROM F7611B

TOP 812 | 76B | F7611B COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	FDBNNF	Nota Fiscal Number	Numeric	Generic Edit	6	0	Allow NULL?
2	FDBSER	Nota Fiscal Series	String	Generic Edit	2	0	Allow NULL?
3	FDN001	Next Number Range 1	Numeric	Generic Edit	8	0	Allow NULL?
4	FDDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
5	FDUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
6	FDSOS1	Sequence Number	String	Generic Edit	3	0	Allow NULL?
7	FDBNF0	Nota Fiscal Number - Original	Numeric	Generic Edit	6	0	Allow NULL?
8	FDBSR0	Nota Fiscal Series - Original	String	Generic Edit	2	0	Allow NULL?
9	FDN002	Next Number Range 2	Numeric	Generic Edit	8	0	Allow NULL?
10	FDBNFS	Nota Fiscal Source	Character	UDC (76 NF)	1	0	Allow NULL?
11	FDOCTO	Original Order Type	String	UDC (00 DT)	2	0	Allow NULL?
12	FDMATC	Type - Match Record Type	Character	Generic Edit	1	0	Allow NULL?
13	FDDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
14	FDPDCT	Document Type - Purchase Order	String	UDC (00 DT)	2	0	Allow NULL?
15	FDKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
16	FDSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
17	FDLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
18	FDNLIN	Number of Lines	Numeric	Generic Edit	5	0	Allow NULL?
19	FDDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
20	FDDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
21	FDCO	Company	String	Generic Edit	5	0	Allow NULL?
22	FDFCO	Company From	String	Generic Edit	5	0	Allow NULL?
23	FDITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
24	FDLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
25	FDAITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
26	FDCITM	Item Number - Customer/Supplier	String	Generic Edit	25	0	Allow NULL?
27	FDMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
28	FDLOCN	Location	String	Generic Edit	20	0	Allow NULL?
29	FDLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
30	FDDSC1	Description	String	Generic Edit	30	0	Allow NULL?
31	FDDSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
32	FDLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
33	FDUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
34	FDUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2	Allow NULL?
35	FDUOM3	Unit of Measure - Purchasing	String	UDC (00 UM)	2	0	Allow NULL?
36	FDUOM4	Unit of Measure - Pricing	String	UDC (00 UM)	2	0	Allow NULL?
37	FDUPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
38	FDAEXP	Amount - Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
39	FDBDES	Amount - Nota Fiscal Discount	Numeric	Generic Edit	15	2	Allow NULL?
40	FDGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
41	FDSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
42	FDAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
43	FDBCGT	CGC Tax ID - Ship To	String	Generic Edit	15	0	Allow NULL?
44	FDBCPT	FederaL Taxpayer ID - Person- Ship To	String	Generic Edit	11	0	Allow NULL?
45	FDSHST	State - Ship to State	String	UDC (00 S)	3	0	Allow NULL?
46	FDSHZP	Zip Code - Ship to Postal Code	String	Generic Edit	12	0	Allow NULL?
47	FDBSFH	Address Number - Ship From	Numeric	Generic Edit	8	0	Allow NULL?
48	FDAN8V	Address Number - Supplier	Numeric	Generic Edit	8	0	Allow NULL?
49	FDBCGF	CGC Tax ID - Ship From	String	Generic Edit	15	0	Allow NULL?
50	FDBCPF	FederaL Taxpayer ID - Person- Ship From	String	Generic Edit	11	0	Allow NULL?
51	FDADDS	State	String	UDC (00 S)	3	0	Allow NULL?
52	FDBNOP	Code - Transaction Nature	Numeric	Generic Edit	3	0	Allow NULL?
53	FDBSOP	Suffix - Transaction Nature	String	Generic Edit	2	0	Allow NULL?
54	FDBDIP	Code - DIPI Classification	String	Generic Edit	4	0	Allow NULL?
55	FDBCLF	Fiscal Classification	String	Generic Edit	10	0	Allow NULL?
56	FDBCTF	ICMS/IPI Tax Summary	String	UDC (76 CT)	2	0	Allow NULL?
57	FDBIST	ICMS Tax Substitution Mark-up	Character	UDC (76 SM)	1	0	Allow NULL?
58	FDBORI	Item Origin	Character	UDC (76 IO)	1	0	Allow NULL?
59	FDBCFC	Purchase Use	String	UDC (76 PU)	3	0	Allow NULL?
60	FDBSTT	Code - ICMS Tax Situation (Nota Fiscal)	String	Generic Edit	2	0	Allow NULL?
61	FDBST1	Code - ICMS Tax Situation (Nota Fiscal)	String	UDC (76 ST)	3	0	Allow NULL?
62	FDBFRT	Amount - Nota Fiscal Freight	Numeric	Generic Edit	15	2	Allow NULL?
63	FDBSEG	Amount - Nota Fiscal Insurance	Numeric	Generic Edit	15	2	Allow NULL?
64	FDBDFN	Amount - Nota Fiscal Financial Expenses	Numeric	Generic Edit	15	2	Allow NULL?
65	FDBICM	Amount - ICMS Tax	Numeric	Generic Edit	15	2	Allow NULL?
66	FDTXR1	Tax Rate 1	Numeric	Generic Edit	7	3	Allow NULL?
67	FDBBCL	Amount - ICMS Taxable	Numeric	Generic Edit	15	2	Allow NULL?
68	FDBBIR	Amount - ICMS Reduced Taxable	Numeric	Generic Edit	15	2	Allow NULL?
69	FDBVIS	Amount - ICMS Substitute	Numeric	Generic Edit	15	2	Allow NULL?
70	FDBBIS	Amount - ICMS Substitute Taxable	Numeric	Generic Edit	15	2	Allow NULL?
71	FDBREP	Amount - ICMS Repass Discount	Numeric	Generic Edit	15	2	Allow NULL?
72	FDBDIZ	Amount - ICMS Free Port Zone Discount	Numeric	Generic Edit	15	2	Allow NULL?
73	FDBICP	Amount - ICMS to be Paid	Numeric	Generic Edit	15	2	Allow NULL?
74	FDBFII	Code - ICMS Reporting Column (Fiscal B.)	Character	UDC (76 II)	1	0	Allow NULL?
75	FDBIPR	Amount - IPI Tax Recoverable	Numeric	Generic Edit	15	2	Allow NULL?
76	FDBIPI	Amount - IPI Tax	Numeric	Generic Edit	15	2	Allow NULL?
77	FDTXR2	Tax Rate 2	Numeric	Generic Edit	7	3	Allow NULL?
78	FDBBTP	Amount - IPI Taxable	Numeric	Generic Edit	15	2	Allow NULL?
79	FDBFIP	Code - IPI Reporting Column (Fiscal B.)	Character	UDC (76 IP)	1	0	Allow NULL?
80	FDBISS	Amount - ISS Tax	Numeric	Generic Edit	15	2	Allow NULL?
81	FDTXR3	Tax Rate 3	Numeric	Generic Edit	7	3	Allow NULL?
82	FDBBCS	Amount - ISS Taxable	Numeric	Generic Edit	15	2	Allow NULL?
83	FDBIRT	Amount - IR Tax	Numeric	Generic Edit	15	2	Allow NULL?
84	FDTXR4	Tax Rate 4	Numeric	Generic Edit	7	3	Allow NULL?
85	FDBBCR	Amount - IR Taxable	Numeric	Generic Edit	15	2	Allow NULL?
86	FDBIIT	Amount - II Tax	Numeric	Generic Edit	15	2	Allow NULL?
87	FDTXR5	Tax Rate 5	Numeric	Generic Edit	7	3	Allow NULL?
88	FDBBCI	Amount - II Taxable	Numeric	Generic Edit	15	2	Allow NULL?
89	FDANI	Account Number - Input (Mode Unknown)	String	Generic Edit	29	0	Allow NULL?
90	FDAID	Account ID	String	Generic Edit	8	0	Allow NULL?
91	FDOMCU	Project Business Unit	String	Generic Edit	12	0	Allow NULL?
92	FDOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
93	FDSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
94	FDSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
95	FDSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
96	FDBINM	Print Message - Fiscal Purpose	String	UDC (40 PM)	10	0	Allow NULL?
97	FDISSU	Date - Issue	Date	Generic Edit	6	0
98	FDBNIV	Fiscal Book Number	Numeric	Generic Edit	5	0	Allow NULL?
99	FDPGNO	Page Number	Numeric	Generic Edit	4	0	Allow NULL?
100	FDNXTR	Status Code - Next	String	UDC (40 AT)	3	0	Allow NULL?
101	FDLTTR	Status Code - Last	String	UDC (40 AT)	3	0	Allow NULL?
102	FDUSER	User ID	String	Generic Edit	10	0	Allow NULL?
103	FDPID	Program ID	String	Generic Edit	10	0	Allow NULL?
104	FDJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
105	FDUPMJ	Date - Updated	Date	Generic Edit	6	0
106	FDTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
107	FDCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
108	FDFTR	Amount - Future Amount Due	Numeric	Generic Edit	15	2	Allow NULL?
109	FDF1T	Future 1 Text	String	Generic Edit	30	0	Allow NULL?
110	FDF2A	Future 2 Amount	Numeric	Generic Edit	15	0	Allow NULL?
111	FDF2T	Future 2 Text	String	Generic Edit	30	0	Allow NULL?
112	FDUSB1	Future 1 (Julian)	Date	Generic Edit	6	0
113	FDFLD3	Log Quality Management Changes	Character	Generic Edit	1	0	Allow NULL?
114	FDFLD4	% Bill Storage	Character	Generic Edit	1	0	Allow NULL?

TOP 812 | 76B | F7611B INDEXES

Number

Description

NotaFiscalDet (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
5	UKID	Unique Key ID (Internal)	Ascending

Matc Doco +

Element	Alias	Description	Sequence
1	MATC	Type - Match Record Type	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
3	PDCT	Document Type - Purchase Order	Ascending
4	KCOO	Order Company (Order Number)	Ascending
5	SFXO	Order Suffix	Ascending
6	LNID	Line Number	Ascending
7	NLIN	Number of Lines	Ascending

ThreeWay

Element	Alias	Description	Sequence
1	MATC	Type - Match Record Type	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
3	PDCT	Document Type - Purchase Order	Ascending
4	KCOO	Order Company (Order Number)	Ascending
5	LNID	Line Number	Ascending
6	NLIN	Number of Lines	Ascending
7	DOC	Document (Voucher Invoice etc.)	Ascending

KCOO BNNF BSER DOCO PDCT LNID

Element	Alias	Description	Sequence
1	KCOO	Order Company (Order Number)	Ascending
2	BNNF	Nota Fiscal Number	Ascending
3	BSER	Nota Fiscal Series	Ascending
4	DOCO	Document (Order No Invoice etc.)	Ascending
5	PDCT	Document Type - Purchase Order	Ascending
6	LNID	Line Number	Ascending

KCOO DOC DCTO

Element	Alias	Description	Sequence
1	KCOO	Order Company (Order Number)	Ascending
2	DOC	Document (Voucher Invoice etc.)	Ascending
3	DCTO	Order 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

114 COLUMNS | 5 INDEXES | 812 | 76B | F7611B TABLE

TOP 812 | 76B | F7611B COLUMNS

TOP 812 | 76B | F7611B 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

114 COLUMNS | 5 INDEXES | 812 | 76B | F7611B TABLE

TOP812 | 76B | F7611B COLUMNS

TOP812 | 76B | F7611B INDEXES

TOP 812 | 76B | F7611B COLUMNS

TOP 812 | 76B | F7611B INDEXES