GPBR_DIRF_DATA

(SQL Table)
Index Back

DIRF Tax Income Elements

DIRF Tax Income Elements

  • Parent record: GPBR_PARM_DIRF
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 GPBR_PAYROLL_TYPE Character(2) VARCHAR2(2) NOT NULL Payroll Type Brazil
    10=Regular Payroll
    20=13 th. Salary
    30=Profit Sharing Program

    Default Value: 10

    4 GPBR_SECTYPE_DIRF Character(2) VARCHAR2(2) NOT NULL Parameter Type DIRF
    65=>=65 Non Taxable Prt Incme
    AP=PLR - Alimony
    CV=Credit Vacation
    DD=Dependents
    IN=Taxable Income
    IP=PLR - Taxable Income
    PA=Alimony
    PD=Per Diary & Cost Allowances
    PO=Official Welfare
    PP=Private Welfare and FAPI
    RP=PLR - Withholding Tax
    TI=Termination Indemnity
    TX=Withholding Tax

    Default Value: IN

    5 GPBR_ENTYPE_DIRF Character(2) VARCHAR2(2) NOT NULL Entry Type DIRF.
    DD=Deductions
    ER=Earnings

    Default Value: DD

    6 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

    Prompt Table: %EDITTABLE2

    7 GPBR_SIGN_USE Character(1) VARCHAR2(1) NOT NULL Sign Use
    A=Add
    S=Substract

    Default Value: A

    8 GPBR_SIGN_NBR Signed Number(3,0) DECIMAL(2) NOT NULL Sign number