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 |