BUSINESS_UNITASSET_IDBOOKPrompt Table: CONV_TBL
BOOK_CURMC_VW(SQL View) |
Index Back |
|---|---|
Current Financial Book |
| SELECT BUSINESS_UNIT , ASSET_ID , BOOK , IN_SERVICE_DT , Convention , INCREASE_RATE FROM PS_BOOK |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 3 | BOOK |
Character(10) | VARCHAR2(10) NOT NULL | Asset Book Name |
| 4 | IN_SERVICE_DT | Date(10) | DATE | In Service Date |
| 5 | CONVENTION | Character(2) | VARCHAR2(2) NOT NULL |
Book Depreciation Convention
or Cost Convention
Prompt Table: CONV_TBL |
| 6 | INCREASE_RATE | Signed Number(11,6) | DECIMAL(9,6) NOT NULL | Increased Rate |