TL_XREFCOST_HST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
4	XREF_NUM	Number(15,0)	DECIMAL(15) NOT NULL	T&L Xref Num
5	PAY_SYSTEM	Character(4)	VARCHAR2(4) NOT NULL	Payroll System GP=Global Payroll NA=North American Payroll
6	DIST_ACTION_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Action Type for Labor Distribution. An action type of add will add the amount given to the amount in Payable Time. An action type of update will replace the amound in Payable Time with the amount given. A=Add U=Update
7	RATE_COST_FLAG	Character(1)	VARCHAR2(1) NOT NULL	The flag is used for labor distribution. It indicatates whether a rate or a cost should be used for labor distribution. C=Cost R=Rate
8	XREF_COST	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Actual cost of payroll entry
9	RATE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Rate
10	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
11	STATUS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Status Flag