	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

22 COLUMNS | 6 INDEXES | 910 | 05 | F05102 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
05: Time Accounting and HRM Base
1	910	F05102	SM	22	6	Goal Master	Master Files	05: Time Accounting and HRM Base	Business Data

TOP 910 | 05 | F05102 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	SMGOAL	Goal Code	String	Generic Edit	10	Allow NULL?
2	SMAN8	Address Number	Numeric	UDC	8	Allow NULL?
3	SMGOLT	Goal Type	Character	UDC (05 GT)	1	Allow NULL?
4	SMGDSC	Goal Descripton	String	Generic Edit	100	Allow NULL?
5	SMGMSTS	Goal Master Status	String	UDC (05 G3)	4	Allow NULL?
6	SMGLDT	Date Set	Date	Generic Edit	6
7	SMTINC	Type of Increase Next Review	Character	UDC (06 RV)	1	Allow NULL?
8	SMANPA	Supervisor	Numeric	Generic Edit	8	Allow NULL?
9	SMDEF	Date - Effective	Date	Generic Edit	6
10	SMSERK	Key Value Serial Number	Numeric	Generic Edit	15	Allow NULL?
11	SMOTPS	Organization Type Structure	String	UDC (00 TS)	3	Allow NULL?
12	SMORMCU	Organizational Business Unit	String	Generic Edit	12	Allow NULL?
13	SMJBCD	Job Type (Craft) Code	String	UDC (06 G)	6	Allow NULL?
14	SMJBST	Job Step	String	UDC (06 GS)	4	Allow NULL?
15	SMGCB	Goal Created By	Numeric	Generic Edit	8	Allow NULL?
16	SMGOT	Goal Originator Type	String	UDC (08 AN)	5	Allow NULL?
17	SMGMN	Goal Mentor Number	Numeric	Generic Edit	8	Allow NULL?
18	SMUPMJ	Date - Updated	Date	Generic Edit	6
19	SMUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?
20	SMUSER	User ID	String	Generic Edit	10	Allow NULL?
21	SMPID	Program ID	String	Generic Edit	10	Allow NULL?
22	SMJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?

Number

Description

Goal Code (Primary/Unique)

Element	Alias	Description	Sequence
1	GOAL	Goal Code	Descending

AddressNumber Type+

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	GOLT	Goal Type	Ascending
3	GMSTS	Goal Master Status	Ascending

AddressNumber DateSet+

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	GLDT	Date Set	Ascending

PerformanceAppraisal

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	TINC	Type of Increase Next Review	Ascending
3	ANPA	Supervisor	Ascending
4	DEF	Date - Effective	Ascending

Competency

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	OTPS	Organization Type Structure	Ascending
3	ORMCU	Organizational Business Unit	Ascending
4	JBCD	Job Type (Craft) Code	Ascending
5	JBST	Job Step	Ascending

KeyValueSerialNumber

Element	Alias	Description	Sequence
1	SERK	Key Value Serial Number	Ascending