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 | Character(3) | VARCHAR2(3) NOT NULL | Company | |
| 2 | Character(14) | VARCHAR2(14) NOT NULL | Establlishment CNPJ Number | |
| 3 | Character(15) | VARCHAR2(15) NOT NULL | Batch Code for Vacation Credit | |
| 4 | Number(4,0) | SMALLINT NOT NULL | Calendar Year | |
| 5 | Character(20) | VARCHAR2(20) NOT NULL | Brazilian CPF National ID | |
| 6 | 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 |