GPNL_RC_WD_COLL

(SQL Table)
Index Back

Wage Decl Collective Adjustmnt

This record is used as run control for the Wage Declaration functionality (Walvis) to allow adjustment of the Collective Tax Data

  • Parent record: GPNL_RC_WD
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 PRD_END_DT Date(10) DATE NOT NULL Pay Period End Date
    4 GPNL_COLUMN_2C Signed Number(20,6) DECIMAL(18,6) NOT NULL Employer Tax Report 2c
    5 GPNL_COLUMN_2E Signed Number(20,6) DECIMAL(18,6) NOT NULL Employer Tax Report 2e
    6 GPNL_COLUMN_2F Signed Number(20,6) DECIMAL(18,6) NOT NULL Employer Tax Report 2f
    7 GPNL_COLUMN_2H Signed Number(20,6) DECIMAL(18,6) NOT NULL Employer Tax Report 2h
    8 GPNL_COLUMN_2I Signed Number(20,6) DECIMAL(18,6) NOT NULL Employer Tax Report 2i
    9 GPNL_COLUMN_2J Signed Number(20,6) DECIMAL(18,6) NOT NULL Employer Tax Report 2J "Eindheffing doorlopend afwisselend gebruik bestelauto's"
    10 GPNL_COLUMN_2K1 Signed Number(20,6) DECIMAL(18,6) NOT NULL Employer Tax Report 2J "Eindheffing doorlopend afwisselend gebruik bestelauto's"
    11 GPNL_LCA_PAYMENTS Signed Number(20,6) DECIMAL(18,6) NOT NULL Track the paid labor costs per period.
    12 GPNL_COLUMN_3C Signed Number(20,6) DECIMAL(18,6) NOT NULL Employer Tax Report 3c
    13 GPNL_COLUMN_3F Signed Number(20,6) DECIMAL(18,6) NOT NULL Employer Tax Report 3f
    14 GPNL_COLUMN_3M Signed Number(20,6) DECIMAL(18,6) NOT NULL Employer Tax Report 3m Tax Reduction R&D, reduction for Research & Development (S&O - Speur- en Ontwikkelwerk)
    15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: EUR