PROCESS_INSTANCEY/N Table Edit
Default Value: N
AM_DEPR_INS_AET(SQL Table) |
Index Back |
|---|---|
AM installation optn state recAM installation option state record for depreciation process |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | TYPE_ADD | Character(3) | VARCHAR2(3) NOT NULL | Trans Type - Add |
| 3 | TYPE_ADJUSTMENT | Character(3) | VARCHAR2(3) NOT NULL | Trans Type - Adjustment |
| 4 | TYPE_TRANSFER | Character(3) | VARCHAR2(3) NOT NULL | Trans Type - Transfer In |
| 5 | TYPE_DEPR | Character(3) | VARCHAR2(3) NOT NULL | Depreciation |
| 6 | TYPE_PRIOR_DEPR | Character(3) | VARCHAR2(3) NOT NULL | Prior Depreciation |
| 7 | TYPE_RECATEGORIZE | Character(3) | VARCHAR2(3) NOT NULL | Recategorize |
| 8 | TYPE_RESERVE_ADJ | Character(3) | VARCHAR2(3) NOT NULL | Reserve Adjustment |
| 9 | TYPE_RETIRE | Character(3) | VARCHAR2(3) NOT NULL | Trans Type - Class Retire |
| 10 | TYPE_REINSTATE | Character(3) | VARCHAR2(3) NOT NULL | Reinstatement |
| 11 | TYPE_BOOK_CHANGE | Character(3) | VARCHAR2(3) NOT NULL | Book Change |
| 12 | TYPE_SUSPEND | Character(3) | VARCHAR2(3) NOT NULL | Trans Type - Suspend |
| 13 | TYPE_RESUME | Character(3) | VARCHAR2(3) NOT NULL | Trans Type - Resume |
| 14 | TYPE_RRC | Character(3) | VARCHAR2(3) NOT NULL | Retro Rate Change for Groups |
| 15 | GROUP_PROC_SW | Character(1) | VARCHAR2(1) NOT NULL |
Group Asset Processing
Y/N Table Edit Default Value: N |
| 16 | CURRENT_FY_PDP | Character(1) | VARCHAR2(1) NOT NULL | Current FY PDP for Reglr Asset |
| 17 | CURRENT_FY_PDP_GRP | Character(1) | VARCHAR2(1) NOT NULL | Current FY PDP for Grp Asset |