GPBR_IREN_TXBL(SQL Table) |
Index Back |
---|---|
Income, Deductable and WitholdTaxable Income, Tax-Deductable and Witholding Tax |
# | 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_IREN_TXBL | Character(2) | VARCHAR2(2) NOT NULL |
Taxable Parameters
01=01-Total Income 02=02-Officl Contrib for Retirmnt 03=03-Cntribs Private Fund 04=04-Pensn Allimony Grnshmnts 05=05-Withholding Tax Default Value: 01 |
4 | ENTRY_TYPE_ELEM | Character(3) | VARCHAR2(3) NOT NULL |
entry type element
Default Value: ER0 Prompt Table: GPBR_ENT_ED_VW |
5 | GPBR_PIN_IREN_NUM | Number(8,0) | INTEGER NOT NULL |
IREN Pin Number
Prompt Table: %GP_PIN_E_D_VW |
6 | GPBR_ERDD_SIGN | Character(1) | VARCHAR2(1) NOT NULL |
Sign
A=Add S=Subtract Default Value: A |
7 | FAPI_CD_BRA | Character(10) | VARCHAR2(10) NOT NULL |
Fapi Provider Code
Prompt Table: FAPI_PROV_BRA |