	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 | 2 INDEXES | 812 | H95 | F9500005 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
H95: Tech Resources/Applications
1	812	F9500005	TA	21	2	Temporary Audit Table	Files	H95: Tech Resources/Applications	System Tables

TOP 812 | H95 | F9500005 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	TACFRGUID	Unique Identifier	String	Generic Edit	36	Allow NULL?
2	TAOBNM	Object Name	String	Generic Edit	10	Allow NULL?
3	TACOLUMN	Column	String	Generic Edit	10	Allow NULL?
4	TACFRSEQN	Sequence Number	Numeric	Generic Edit	15	Allow NULL?
5	TAISKEY	Is Part of the Primary Key	Integer	Generic Edit	11	Allow NULL?
6	TAB4DATA	Before Data	String	Generic Edit	256	Allow NULL?
7	TAAFTERDATA	After Data	String	Generic Edit	256	Allow NULL?
8	TAAUDITTYPE	Audit Type	Character	Generic Edit	1	Allow NULL?
9	TAACTION	Action Type	Character	Generic Edit	1	Allow NULL?
10	TAFFCFR25	Future User CFR 25	String	Generic Edit	10	Allow NULL?
11	TAFFCFR26	Future User CFR 26	String	Generic Edit	10	Allow NULL?
12	TAFFCFR27	Future User CFR 27	String	Generic Edit	50	Allow NULL?
13	TAFFCFR28	Future User CFR 28	String	Generic Edit	50	Allow NULL?
14	TAFFCFR29	Future User CFR 29	Numeric	Generic Edit	5	Allow NULL?
15	TAFFCFR30	Future User CFR 30	Numeric	Generic Edit	5	Allow NULL?
16	TACFRUSER	User ID	String	Generic Edit	10	Allow NULL?
17	TAFULLNAME	Full Name	String	Generic Edit	50	Allow NULL?
18	TAAN8	Address Number	Numeric	UDC	8	Allow NULL?
19	TACFRMKEY	Machine Key	String	Generic Edit	15	Allow NULL?
20	TACFRPID	Program ID	String	Generic Edit	10	Allow NULL?
21	TADATETIME	Date and Time Stamp	String	Generic Edit	26	Allow NULL?

Number

Description

CFR Guid Object Name Column (Primary/Unique)

Element	Alias	Description	Sequence
1	CFRGUID	Unique Identifier	Ascending
2	OBNM	Object Name	Ascending
3	COLUMN	Column	Ascending
4	CFRSEQN	Sequence Number	Ascending
5	FFCFR27	Future User CFR 27	Ascending

FFCFR27 CFRGUID OBNM CLMN SEQ

Element	Alias	Description	Sequence
1	FFCFR27	Future User CFR 27	Ascending
2	CFRGUID	Unique Identifier	Ascending
3	OBNM	Object Name	Ascending
4	COLUMN	Column	Ascending
5	CFRSEQN	Sequence Number	Ascending