	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

31 COLUMNS | 2 INDEXES | 910 | 76B | F76B12TE TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
76B: Brazil - Reporting System Only
1	910	F76B12TE	SL	31	2	NF-e Status Log - BRA - 76B	Files	76B: Brazil - Reporting System Only

TOP 910 | 76B | F76B12TE COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	SLBNNF	Nota Fiscal Number	Numeric	Generic Edit	6	Allow NULL?
2	SLBSER	Nota Fiscal Series	String	Generic Edit	2	Allow NULL?
3	SLDCT	Document Type	String	UDC (00 DT)	2	Allow NULL?
4	SLN001	Next Number Range 1	Numeric	Generic Edit	8	Allow NULL?
5	SLRC5	File Line Identifier 5.0	Numeric	Generic Edit	5	Allow NULL?
6	SLB76EMTY	NF-e Emission Type	Character	UDC (76B ET)	1	Allow NULL?
7	SLB76NFST	NF-e Status	Character	UDC (76B ST)	1	Allow NULL?
8	SLB76SACT	NF-e Status Active (Y/N)	Character	Generic Edit	1	Allow NULL?
9	SLB76PRON	NF-e Protocol Number	Numeric	Generic Edit	15	Allow NULL?
10	SLB76TNF	Nota Fiscal Type	String	UDC (70 TY)	10	Allow NULL?
11	SLB76LSER	Nota Fiscal Legal Serie	String	Generic Edit	10	Allow NULL?
12	SLB76LNUM	NF Legal Number	Numeric	Generic Edit	20	Allow NULL?
13	SLFCO	Company From	String	Generic Edit	5	Allow NULL?
14	SLB76AKEY	Access Key	String	Generic Edit	44	Allow NULL?
15	SLB76EPRD	NF-e Processed Date	Date	Generic Edit	6
16	SLB76EPRT	NF-e Processed Time	Numeric	Generic Edit	6	Allow NULL?
17	SLB76CAND	NF-e Cancelled Date	Date	Generic Edit	6
18	SLB76CANT	NF-e Cancelled Time	Numeric	Generic Edit	6	Allow NULL?
19	SLB76CONR	NF-e Contingency Reason	String	UDC (40 PM)	10	Allow NULL?
20	SLB76RSPC	NF-e Response Code	Numeric	UDC (76B RS)	3	Allow NULL?
21	SLB76ERN	NFe Receipt Number	String	Generic Edit	30	Allow NULL?
22	SLB76DPEN	DPEC Register Number	Numeric	Generic Edit	15	Allow NULL?
23	SLB76DPED	DPEC Register Date	Date	Generic Edit	6
24	SLB76DPET	DPEC Register Time	Numeric	Generic Edit	6	Allow NULL?
25	SLB76FSCN	FS Control Number	Numeric	Generic Edit	9	Allow NULL?
26	SLB76FSCS	FS Control Series	String	Generic Edit	2	Allow NULL?
27	SLUSER	User ID	String	Generic Edit	10	Allow NULL?
28	SLPID	Program ID	String	Generic Edit	10	Allow NULL?
29	SLJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
30	SLUPMJ	Date - Updated	Date	Generic Edit	6
31	SLUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?

TOP 910 | 76B | F76B12TE INDEXES

Number

Description

BNNF BSER + (Primary/Unique)

Element	Alias	Description	Sequence
1	BNNF	Nota Fiscal Number	Ascending
2	BSER	Nota Fiscal Series	Ascending
3	DCT	Document Type	Ascending
4	N001	Next Number Range 1	Ascending
5	RC5	File Line Identifier 5.0	Descending

B76AKEY B76SACT

Element	Alias	Description	Sequence
1	B76AKEY	Access Key	Ascending
2	B76SACT	NF-e Status Active (Y/N)	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

31 COLUMNS | 2 INDEXES | 910 | 76B | F76B12TE TABLE

TOP 910 | 76B | F76B12TE COLUMNS

TOP 910 | 76B | F76B12TE 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

31 COLUMNS | 2 INDEXES | 910 | 76B | F76B12TE TABLE

TOP910 | 76B | F76B12TE COLUMNS

TOP910 | 76B | F76B12TE INDEXES

TOP 910 | 76B | F76B12TE COLUMNS

TOP 910 | 76B | F76B12TE INDEXES