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

26 COLUMNS | 3 INDEXES | 812 | 08 | F087103 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
08: Human Resources
1	812	F087103	TD	26	3	Setup Task Details	Master Files	08: Human Resources	No

TOP 812 | 08 | F087103 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	TDTSKCD	Employee Setup Task Code	Numeric	Generic Edit	8	Allow NULL?
2	TDL001	Location Code 001	String	UDC (08 L1)	10	Allow NULL?
3	TDL002	Location Code 002	String	UDC (08 L2)	10	Allow NULL?
4	TDL003	Location Code 003	String	UDC (08 L3)	10	Allow NULL?
5	TDL004	Location Code 004	String	UDC (08 L4)	10	Allow NULL?
6	TDL005	Location Code 005	String	UDC (08 L5)	10	Allow NULL?
7	TDL006	Location Code 006	String	UDC (08 L6)	10	Allow NULL?
8	TDL007	Location Code 007	String	UDC (08 L7)	10	Allow NULL?
9	TDL008	Location Code 008	String	UDC (08 L8)	10	Allow NULL?
10	TDL009	Location Code 009	String	UDC (08 L9)	10	Allow NULL?
11	TDL010	Location Code 010	String	UDC (08 L0)	10	Allow NULL?
12	TDANR	Task Recipient	Numeric	Generic Edit	8	Allow NULL?
13	TDDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	Allow NULL?
14	TDTYPS	Type - W.O.	Character	UDC (00 TY)	1	Allow NULL?
15	TDOBNM	Object Name	String	Generic Edit	10	Allow NULL?
16	TDVERS	Version History	String	Generic Edit	10	Allow NULL?
17	TDPROCNAME	Process ID	String	Generic Edit	10	Allow NULL?
18	TDSEM	Send E-Mail	Character	Check Box	1	Allow NULL?
19	TDCOS	Completion Offset Days	Numeric	Generic Edit	3	Allow NULL?
20	TDDUR	Duration	Numeric	Generic Edit	3	Allow NULL?
21	TDBOD	Based on Date	Character	UDC (08 BO)	1	Allow NULL?
22	TDUPMJ	Date - Updated	Date	Generic Edit	6
23	TDUSER	User ID	String	Generic Edit	10	Allow NULL?
24	TDJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
25	TDPID	Program ID	String	Generic Edit	10	Allow NULL?
26	TDAPRV	Address Number - Approved by	Numeric	Generic Edit	8	Allow NULL?

Number

Description

TaskCode Location (Primary/Unique)

Element	Alias	Description	Sequence
1	TSKCD	Employee Setup Task Code	Ascending
2	L001	Location Code 001	Ascending
3	L002	Location Code 002	Ascending
4	L003	Location Code 003	Ascending
5	L004	Location Code 004	Ascending
6	L005	Location Code 005	Ascending
7	L006	Location Code 006	Ascending
8	L007	Location Code 007	Ascending
9	L008	Location Code 008	Ascending
10	L009	Location Code 009	Ascending

Recipient

Element	Alias	Description	Sequence
1	ANR	Task Recipient	Ascending

Approver

Element	Alias	Description	Sequence
1	APRV	Address Number - Approved by	Ascending