GPAR_INC_TAX_DD

(SQL Table)
 Index Back

Income tax deductions detail

Maintain income tax deductions detail for Argentinian payees.

  • Parent record: GPAR_INC_TAX_DP

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    6 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    7 CUIT_ARG Character(13) VARCHAR2(13) NOT NULL CUIT Number ARG
    8 GPAR_INC_TAX_DDESC Character(30) VARCHAR2(30) NOT NULL Income tax deduction description.
    9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    10 AMOUNT Signed Number(20,3) DECIMAL(18,3) NOT NULL Commuting Allowance Paid Per Cycle.
    11 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    12 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    13 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    14 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    15 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    16 CITY Character(30) VARCHAR2(30) NOT NULL City
    17 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    18 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    19 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    20 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    21 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    22 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    23 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    24 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    25 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    26 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    27 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    28 GPAR_SIRADIG Character(1) VARCHAR2(1) NOT NULL Use to mark if record was uploaded by xml file for SIRADIG
    N=N
    Y=Yes

    Default Value: N

    29 GPAR_CARD_TYPE Character(1) VARCHAR2(1) NOT NULL Card Type ARG
    0=Totaled/No Apply
    1=Credit Card/Purchase
    2=Debit Card
    30 GPAR_ID_BANK Character(2) VARCHAR2(2) NOT NULL ID Bank for SiRADIG
    1=Master Card
    2=Visa
    3=American Express
    4=Cabal
    5=Italcred
    6=Naranja
    7=Nativa
    8=Diners Club
    99=Other
    31 GPAR_CRED_CARD_NUM Character(16) VARCHAR2(16) NOT NULL Credit Card Number
    32 GPAR_CBU Character(22) VARCHAR2(22) NOT NULL CBU Number as string for SiRADIG
    33 GPAR_CUIT_AGENT Character(13) VARCHAR2(13) NOT NULL CUIT Number ARG
    34 GPAR_DESCR Character(200) VARCHAR2(200) NOT NULL Description