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

21 COLUMNS | 1 INDEXES | 812 | 00 | F4096 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
00: Foundation Environment
1	812	F4096	FA	21	1	Sales Flex Accounting	Master Files	42: Sales Management	AS400 Coexistence Tables

TOP 812 | 00 | F4096 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	FAANUM	Number - AAI Table Number	Numeric	Generic Edit	4	Allow NULL?
2	FAAST	Price Adjustment Name	String	UDC (40 TY)	8	Allow NULL?
3	FACO	Company	String	Generic Edit	5	Allow NULL?
4	FAITEM	Item Number	String	Generic Edit	6	Allow NULL?
5	FAOBJF	Object Account From	String	Generic Edit	6	Allow NULL?
6	FAOBJT	Object Account Thru	String	Generic Edit	6	Allow NULL?
7	FADCTO	Order Type	String	UDC (00 DT)	2	Allow NULL?
8	FA@RT	Record Type - CC/SUB/SBL Flex Format	Character	Generic Edit	1	Allow NULL?
9	FAEL	Element - Element Number	Numeric	Generic Edit	3	Allow NULL?
10	FADL01	Description	String	Generic Edit	30	Allow NULL?
11	FASBLT	Subledger Type	Character	UDC (00 ST)	1	Allow NULL?
12	FASEGS	Segment Size	Numeric	Generic Edit	2	Allow NULL?
13	FASFIT	Data Item	String	UDC (40 DI)	10	Allow NULL?
14	FASFDT	Data Type	Character	UDC (40 DP)	1	Allow NULL?
15	FAABT1	Managerial Analysis Type 1	Character	UDC	1	Allow NULL?
16	FAFILE	File Name	String	Generic Edit	10	Allow NULL?
17	FAPID	Program ID	String	Generic Edit	10	Allow NULL?
18	FAJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
19	FAUSER	User ID	String	Generic Edit	10	Allow NULL?
20	FAUPMJ	Date - Updated	Date	Generic Edit	6
21	FATDAY	Time of Day	Numeric	Generic Edit	6	Allow NULL?

Number

Description

AaiTableNo Co + (Primary/Unique)

Element	Alias	Description	Sequence
1	ANUM	Number - AAI Table Number	Ascending
2	CO	Company	Ascending
3	AST	Price Adjustment Name	Ascending
4	ITEM	Item Number	Ascending
5	OBJF	Object Account From	Ascending
6	OBJT	Object Account Thru	Ascending
7	DCTO	Order Type	Ascending
8	EL	Element - Element Number	Ascending
9	@RT	Record Type - CC/SUB/SBL Flex Format	Ascending