TL_XREF_COSTS

(SQL Table)
Index Back

Payroll Cost information

Payroll Cost information

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 XREF_NUM Number(15,0) DECIMAL(15) NOT NULL T&L Xref Num
3 PAY_SYSTEM Character(4) VARCHAR2(4) NOT NULL Payroll System
GP=Global Payroll
NA=North American Payroll
4 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
5 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
6 XREF_COST Signed Number(20,6) DECIMAL(18,6) NOT NULL Actual cost of payroll entry
7 RATE Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate
8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
9 STATUS_FLAG Character(1) VARCHAR2(1) NOT NULL Status Flag