GPNL_TXR_LCA (SQL Table)	Index Back
Tax Reports - Labor Costs This record is used to track the company setup for the Labor Cost Agreement "Werkkostenregeling".

GPNL_TXR_LCA

(SQL Table)

Tax Reports - Labor Costs

This record is used to track the company setup for the Labor Cost Agreement "Werkkostenregeling".

Parent record: GPNL_TXR

# 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 GPNL_RPT_FREQ Character(1) VARCHAR2(1) NOT NULL Tax reporting frequency, either Monthly or 4-Weekly.
F=Every Four Weeks
M=Monthly
Default Value: M

4 GPNL_LCA_METHOD Character(1) VARCHAR2(1) NOT NULL Specify the method that is used to calculate the tax following to the Labor Cost Agreement.
A=Annual Threshold/Period Calc
C=Annual Threshold/Cumulative
N=Not Applicable
P=Period Threshold/Period Calc

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

#	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	GPNL_RPT_FREQ	Character(1)	VARCHAR2(1) NOT NULL	Tax reporting frequency, either Monthly or 4-Weekly. F=Every Four Weeks M=Monthly Default Value: M
4	GPNL_LCA_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Specify the method that is used to calculate the tax following to the Labor Cost Agreement. A=Annual Threshold/Period Calc C=Annual Threshold/Cumulative N=Not Applicable P=Period Threshold/Period Calc
5	GPNL_TAX_WAGE	Number(12,0)	DECIMAL(12) NOT NULL	Total amount of Column 14 (Taxable Wage) for the employer over a full year.