SETIDDefault Value: OPR_DEF_TBL_FS.SETID
TAX_CREDIT_TYPEE=Energy Tax Credit
I=Regular Investment Tax Credit
R=Rehabilitation Tax Credit
U=User-Defined
TAX_CREDIT_CDPrompt Table: TAX_CR_TBL
TAX_CR_VW(SQL View) |
Index Back |
|---|---|
Tax Credits View |
| select setid, tax_credit_type, tax_credit_cd, lc_cntry, descr from PS_TAX_CR_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID |
| 2 | TAX_CREDIT_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Tax Credit Type
E=Energy Tax Credit I=Regular Investment Tax Credit R=Rehabilitation Tax Credit U=User-Defined |
| 3 | TAX_CREDIT_CD |
Character(6) | VARCHAR2(6) NOT NULL |
Tax Credit Code
Prompt Table: TAX_CR_TBL |
| 4 | LC_CNTRY | Character(3) | VARCHAR2(3) NOT NULL | The local country. |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |