GPBR_AU_DIRF_ER(SQL Table) |
Index Back |
---|---|
DIRF Autonomous Year AmountsDIRF 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 |