GPNL_TXR_LCA_DT (SQL Table)	Index Back
Tax - Labor Costs Details This record is used to track the company Paid Labor Costs and Tax Payments according to the Labor Cost Agreement "Werkkostenregeling".

GPNL_TXR_LCA_DT

(SQL Table)

Tax - Labor Costs Details

This record is used to track the company Paid Labor Costs and Tax Payments according to the Labor Cost Agreement "Werkkostenregeling".

Parent record: GPNL_TXR_LCA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

2 GPNL_YEAR Number(4,0) SMALLINT NOT NULL Specify the calendar year using 4 digits, e.g. 2010.

3 PRD_BGN_DT Date(10) DATE NOT NULL Period Begin Date

4 GPNL_TAX_WAGE Number(12,0) DECIMAL(12) NOT NULL Total amount of Column 14 (Taxable Wage) for the employer over a full year.

5 GPNL_LCA_PAYMENTS Signed Number(20,6) DECIMAL(18,6) NOT NULL Track the paid labor costs per period.

6 GPNL_LCA_TAX Signed Number(11,0) DECIMAL(10) NOT NULL Track the paid labor costs per period.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
2	GPNL_YEAR	Number(4,0)	SMALLINT NOT NULL	Specify the calendar year using 4 digits, e.g. 2010.
3	PRD_BGN_DT	Date(10)	DATE NOT NULL	Period Begin Date
4	GPNL_TAX_WAGE	Number(12,0)	DECIMAL(12) NOT NULL	Total amount of Column 14 (Taxable Wage) for the employer over a full year.
5	GPNL_LCA_PAYMENTS	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Track the paid labor costs per period.
6	GPNL_LCA_TAX	Signed Number(11,0)	DECIMAL(10) NOT NULL	Track the paid labor costs per period.