PROFILE_PARC_BK(SQL Table) |
Index Back |
|---|---|
Child Asset Inheritance |
| # | 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 | PAR_LIFE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Copy Rem Life from Parent?
Y/N Table Edit |
| 6 | PAR_CONVENTION_SW | Character(1) | VARCHAR2(1) NOT NULL |
Copy Convention from Parent?
Y/N Table Edit |
| 7 | PAR_RET_CONV_SW | Character(1) | VARCHAR2(1) NOT NULL |
Retirement Convention
Y/N Table Edit |
| 8 | PAR_METHOD_SW | Character(1) | VARCHAR2(1) NOT NULL |
Copy Method from Parent Asset?
Y/N Table Edit |
| 9 | PAR_TAX_CODE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Copy Tax Code from Parent?
Y/N Table Edit |
| 10 | PAR_MULTI_SHIFT_SW | Character(1) | VARCHAR2(1) NOT NULL |
Multi-Shift Code
Y/N Table Edit |
| 11 | PAR_SALVAGE_VAL_SW | Character(1) | VARCHAR2(1) NOT NULL |
Copy Salvage Value from Parent
Y/N Table Edit |
| 12 | PAR_DEPR_LIMIT_SW | Character(1) | VARCHAR2(1) NOT NULL |
Copy Depr Limit from Parent?
Y/N Table Edit |
| 13 | PAR_COST_BASLIM_SW | Character(1) | VARCHAR2(1) NOT NULL |
Cost Basis Limit
Y/N Table Edit |