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

23 COLUMNS | 3 INDEXES | 920 | 76B | F76B429 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
76B: Brazil
1	920	F76B429	SN	23	3	Service Nota Fiscal Wh by Formula Installment - BRA - 76B	Files	76B: Brazil

TOP 920 | 76B | F76B429 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	SNBNNF	Nota Fiscal Number	Numeric	Generic Edit	6	0	Allow NULL?
2	SNBSER	Nota Fiscal Series	String	Generic Edit	2	0	Allow NULL?
3	SNN001	Next Number Range 1	Numeric	Generic Edit	8	0	Allow NULL?
4	SNDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
5	SNUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
6	SNBRTX	Tax Type - Brazil	String	UDC (76B TR)	2	0	Allow NULL?
7	SNSEQN	Sequence Number	Numeric	Generic Edit	7	0	Allow NULL?
8	SNBRTX2	Tax Information - Brazil	String	Generic Edit	8	0	Allow NULL?
9	SNBRTXB	Tax Basis - Brazil	Numeric	Generic Edit	15	2	Allow NULL?
10	SNBRTXA	Tax Amount - Brazil	Numeric	Generic Edit	15	2	Allow NULL?
11	SNBRTXR	Tax Rate - Brazil	Numeric	Generic Edit	7	3	Allow NULL?
12	SNCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
13	SNB76MAF	Minimum Achieved Flag	Character	Generic Edit	1	0	Allow NULL?
14	SNB76SSWF	Service Subject to Withhold Flag	Character	Generic Edit	1	0	Allow NULL?
15	SNCALCDJ	Date - Calculated	Date	Generic Edit	6	0
16	SNCENTYR	Century/Year	Numeric	Generic Edit	4	0	Allow NULL?
17	SNMNTH	Month	Numeric	Generic Edit	2	0	Allow NULL?
18	SNUSER	User ID	String	Generic Edit	10	0	Allow NULL?
19	SNPID	Program ID	String	Generic Edit	10	0	Allow NULL?
20	SNTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
21	SNUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
22	SNUPMJ	Date - Updated	Date	Generic Edit	6	0
23	SNJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?

Number

Description

BNNF BSER N001 DCT UKID BRTX (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
6	BRTX	Tax Type - Brazil	Ascending
7	SEQN	Sequence Number	Ascending

TXTP CENTYR MNTH

Element	Alias	Description	Sequence
1	BRTX	Tax Type - Brazil	Ascending
2	CENTYR	Century/Year	Ascending
3	MNTH	Month	Ascending

TXTP.CALCDJ

Element	Alias	Description	Sequence
1	BRTX	Tax Type - Brazil	Ascending
2	CALCDJ	Date - Calculated	Ascending