	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

21 COLUMNS | 3 INDEXES | 812 | 76B | F76B473 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
76B: Brazil - Reporting System Only
1	812	F76B473	DS	21	3	Dynamic Formater Layouts Specification - 03B	Secondary Master Files	76: Latin American Localization	Business Data

TOP 812 | 76B | F76B473 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	DSBDFLAY	Dynamic Formater Layout	String	Generic Edit	10	Allow NULL?
2	DSDRIN	Direction Indicator	Character	UDC (00 DN)	1	Allow NULL?
3	DSEDTY	Type Record	Character	UDC (00 RD)	1	Allow NULL?
4	DSLIID	Line ID	Numeric	Generic Edit	3	Allow NULL?
5	DSBDFATR	Dynamic Formater Attribute	String	UDC (76B F1)	5	Allow NULL?
6	DSBDFBEP	Dynamic Formater Begin Position	Numeric	Generic Edit	7	Allow NULL?
7	DSBDFENP	Dynamic Formater End Position	Numeric	Generic Edit	7	Allow NULL?
8	DSDSCA	Alpha Description	String	Generic Edit	40	Allow NULL?
9	DSDFTV	Default Value	String	Generic Edit	30	Allow NULL?
10	DSOWTP	Data Type - EnterpriseOne	String	UDC (H98 DT)	2	Allow NULL?
11	DSDTAD	Data File Decimals	Numeric	Generic Edit	2	Allow NULL?
12	DSDECF	Decimal Format Character	Character	UDC (H98 DE)	1	Allow NULL?
13	DSJDEALGNL	Align Left	Character	Generic Edit	1	Allow NULL?
14	DSQ1	Alpha Filler 1 Long	Character	Generic Edit	1	Allow NULL?
15	DSFRMT	Date Format	String	UDC (00 DF)	3	Allow NULL?
16	DSDSEP	Date Separator Character	Character	UDC (H98 DS)	1	Allow NULL?
17	DSPID	Program ID	String	Generic Edit	10	Allow NULL?
18	DSJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
19	DSUSER	User ID	String	Generic Edit	10	Allow NULL?
20	DSUPMJ	Date - Updated	Date	Generic Edit	6
21	DSUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?

Number

Description

PrimaryKey (Primary/Unique)

Element	Alias	Description	Sequence
1	BDFLAY	Dynamic Formater Layout	Ascending
2	DRIN	Direction Indicator	Ascending
3	EDTY	Type Record	Ascending
4	LIID	Line ID	Ascending
5	BDFBEP	Dynamic Formater Begin Position	Ascending

BDFLAY DRIN EDTY LIID BDFATR

Element	Alias	Description	Sequence
1	BDFLAY	Dynamic Formater Layout	Ascending
2	DRIN	Direction Indicator	Ascending
3	EDTY	Type Record	Ascending
4	LIID	Line ID	Ascending
5	BDFATR	Dynamic Formater Attribute	Ascending

BDFLAY DRIN EDTY BDFATR

Element	Alias	Description	Sequence
1	BDFLAY	Dynamic Formater Layout	Ascending
2	DRIN	Direction Indicator	Ascending
3	EDTY	Type Record	Ascending
4	BDFATR	Dynamic Formater Attribute	Ascending