GPBR_AU_DIRF_ER

(SQL Table)
Index Back

DIRF Autonomous Year Amounts

DIRF Autonomous Year Amounts

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
2 GPBR_CNPJ Character(14) VARCHAR2(14) NOT NULL Establlishment CNPJ Number
3 GPBR_BATCH_CODE Character(15) VARCHAR2(15) NOT NULL Batch Code for Vacation Credit
4 CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL Calendar Year
5 NID_CPF_BRA Character(20) VARCHAR2(20) NOT NULL Brazilian CPF National ID
6 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: TX

7 GPBR_AMT_01 Signed Number(20,6) DECIMAL(18,6) NOT NULL January Amount
8 GPBR_AMT_02 Signed Number(20,6) DECIMAL(18,6) NOT NULL February Amount
9 GPBR_AMT_03 Signed Number(20,6) DECIMAL(18,6) NOT NULL March Amount
10 GPBR_AMT_04 Signed Number(20,6) DECIMAL(18,6) NOT NULL April Amount
11 GPBR_AMT_05 Signed Number(20,6) DECIMAL(18,6) NOT NULL May Amount
12 GPBR_AMT_06 Signed Number(20,6) DECIMAL(18,6) NOT NULL June Amount
13 GPBR_AMT_07 Signed Number(20,6) DECIMAL(18,6) NOT NULL Jully Amount
14 GPBR_AMT_08 Signed Number(20,6) DECIMAL(18,6) NOT NULL Jully Amount
15 GPBR_AMT_09 Signed Number(20,6) DECIMAL(18,6) NOT NULL September Amount
16 GPBR_AMT_10 Signed Number(20,6) DECIMAL(18,6) NOT NULL October Amount
17 GPBR_AMT_11 Signed Number(20,6) DECIMAL(18,6) NOT NULL November Amount
18 GPBR_AMT_12 Signed Number(20,6) DECIMAL(18,6) NOT NULL December Amount
19 GPBR_AMT_13 Signed Number(20,6) DECIMAL(18,6) NOT NULL 13th Salary