PAY_TAX_LIAB_AP

(SQL Table)
 Index Back

TAX LIABILITY AP

This record contains the committment accounting 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(4,0) SMALLINT NOT NULL Page #
    6 LINE_NUM Number(2,0) SMALLINT NOT NULL Line #
    7 SEPCHK Number(1,0) SMALLINT NOT NULL Separate check number.
    8 STATE Character(6) VARCHAR2(6) NOT NULL State
    9 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality
    10 TAX_CLASS Character(1) VARCHAR2(1) NOT NULL Tax Balance Class
    11 WORK_PSD_CD Character(6) VARCHAR2(6) NOT NULL Locality
    12 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
    13 TAX_CUR Signed Number(12,2) DECIMAL(10,2) NOT NULL Current Tax
    14 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
    15 DEPTID_CF Character(10) VARCHAR2(10) NOT NULL Department
    16 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project/Grant
    17 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product
    18 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
    19 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code
    20 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field.
    21 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field
    22 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit
    23 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
    24 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference Chartfield
    25 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield number 1
    26 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
    27 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
    28 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
    29 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
    30 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number