	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

20 COLUMNS | 5 INDEXES | 812 | 05 | F051171 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
05: Time Accounting and HRM Base
1	812	F051171	GL	20	5	Goal Actions	Files	05: Time Accounting and HRM Base	Business Data

TOP 812 | 05 | F051171 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	GLGOAL	Goal Code	String	Generic Edit	10	Allow NULL?
2	GLGSEQ	Goal Sequence	Integer	Generic Edit	11	Allow NULL?
3	GLGAID	Goal Action ID	Integer	Generic Edit	11	Allow NULL?
4	GLSGID	Suggestion ID	Numeric	Generic Edit	9	Allow NULL?
5	GLGASTS	Goal Action Status	String	UDC (05 G3)	4	Allow NULL?
6	GLGAD	Goal Action Description	String	Generic Edit	100	Allow NULL?
7	GLGLDT	Date Set	Date	Generic Edit	6
8	GLESD	Estimated Start Date	Date	Generic Edit	6
9	GLESED	Estimate End Date	Date	Generic Edit	6
10	GLTREN	End Date	Date	Generic Edit	6
11	GLTRSD	Start Date	Date	Generic Edit	6
12	GLCHRN	Change Reason	String	UDC (05 CH)	3	Allow NULL?
13	GLPID	Program ID	String	Generic Edit	10	Allow NULL?
14	GLUSER	User ID	String	Generic Edit	10	Allow NULL?
15	GLJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
16	GLUPMJ	Date - Updated	Date	Generic Edit	6
17	GLUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?
18	GLGCB	Goal Created By	Numeric	Generic Edit	8	Allow NULL?
19	GLGOT	Goal Originator Type	String	UDC (08 AN)	5	Allow NULL?
20	GLALPH	Name - Alpha	String	Generic Edit	40	Allow NULL?

Number

Description

Primary (Primary/Unique)

Element	Alias	Description	Sequence
1	GOAL	Goal Code	Descending
2	GSEQ	Goal Sequence	Descending
3	GAID	Goal Action ID	Descending

SuggestionID

Element	Alias	Description	Sequence
1	GOAL	Goal Code	Ascending
2	GSEQ	Goal Sequence	Ascending
3	SGID	Suggestion ID	Ascending

DueDate

Element	Alias	Description	Sequence
1	GOAL	Goal Code	Ascending
2	ESED	Estimate End Date	Descending

Originator

Element	Alias	Description	Sequence
1	GOAL	Goal Code	Ascending
2	ALPH	Name - Alpha	Ascending

Status

Element	Alias	Description	Sequence
1	GOAL	Goal Code	Ascending
2	GASTS	Goal Action Status	Ascending