PAY_CTX_LIAB_AP

(SQL Table)
Index Back

Canadian CA Tax Liability

This record contains the committment accounting Canadian tax liability information to be sent to AP.

  • Parent record: PAY_CHECK
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

    Prompt Table: PAYGROUP_TBL

    3 PAY_END_DT Date(10) DATE NOT NULL Pay Period End Date

    Prompt Table: PAY_CALENDAR

    4 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?

    Y/N Table Edit

    5 PAGE_NUM Number(5,0) INTEGER NOT NULL Page Nbr
    6 LINE_NUM Number(3,0) SMALLINT NOT NULL Line Nbr
    7 SEPCHK Number(2,0) SMALLINT NOT NULL Separate check number.
    8 PROVINCE Character(6) VARCHAR2(6) NOT NULL Province
    9 TAX_CLASS_CAN Character(3) VARCHAR2(3) NOT NULL Canadian Tax Class
    ALL=Total Gross
    CBT=Canadian Bonus Tax
    CIT=Canadian Income Tax (T4)
    CP2=CPP Second Additional Employee
    CPA=Pension Adjustment
    CPP=Canada Pension Plan Employee
    CPR=Canada Pension Plan Employer
    CR2=CPP Second Additional Employer
    EIE=Employment Insurance Employee
    EIR=Employment Insurance Employer
    HTX=Provincial Health Tax
    PYT=Payroll Tax
    QBT=Quebec Bonus Tax
    QCD=Quebec Tax Deduction
    QIE=Quebec Parental Plan Employee
    QIR=Quebec Parental Plan Employer
    QIT=Quebec Income Tax (RL-1)
    QP2=QPP Second Additional Employee
    QPP=Quebec Pension Plan Employee
    QPR=Quebec Pension Plan Employer
    QR2=QPP Second Additional Employer
    RV2=Quebec Income Tax (RL-2)
    T4A=Canadian Income Tax (T4A)
    TRV=True RL
    TT4=True T4
    10 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
    11 TAX_CUR Signed Number(12,2) DECIMAL(10,2) NOT NULL Current Tax
    12 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
    13 DEPTID_CF Character(10) VARCHAR2(10) NOT NULL Department
    14 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project/Grant
    15 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product
    16 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
    17 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code
    18 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field.
    19 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field
    20 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit
    21 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
    22 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference Chartfield
    23 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield number 1
    24 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
    25 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
    26 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
    27 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate2
    28 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL Project Costing Business Unit
    29 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    30 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Project Costing Resource Type
    31 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Project Costing Resource Category
    32 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Project Costing Resource Sub Category
    33 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number