| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SETID_TBL
|
| 2 |
PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Profile ID
Prompt Table:
PROFILE_TBL
|
| 3 |
BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Book Name
Prompt Table:
SP_BOOK_NONVW
|
| 4 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 5 |
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
|
| 6 |
TAX_CREDIT_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Tax Credit Code
Prompt Table:
TAX_CR_VW
|
| 7 |
BASIS_RED_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Basis Reduction Option
B=Basis Reduction
N=None - No Basis Reduction
P=Percentage Rate Reduction
Prompt Table:
TAX_CR_RED_VW
|
| 8 |
QUAL_INV_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Qualified Investment Code
A=Accelerated Cost Recovery Sys
D=Asset Depreciation Range
F=Conventional/Facts& Circumstan
G=Guideline
M=Modified Accel Cost Recovery
|
| 9 |
TAX_CR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Credit Status
Prompt Table:
TAX_CR_STAT_VW
|