AM_FV_TEMPLATE(SQL Table) |
Index Back |
|---|---|
AM Fair Value Template |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_AM_NONVW |
| 2 | FV_TEMPLATE_ID |
Character(12) | VARCHAR2(12) NOT NULL | Fair Value Template ID |
| 3 | VALUATION_METHOD | Character(30) | VARCHAR2(30) NOT NULL |
Valuation Method
Prompt Table:
AM_FV_METHOD
|
| 4 | VALUATION_PREMISE | Character(1) | VARCHAR2(1) NOT NULL |
Fair Value Valuation Premise: 1:In-Exchange;2:In-Use
1=In-Exchange 2=In-Use |
| 5 | FV_GROUP_BY | Character(1) | VARCHAR2(1) NOT NULL |
Fair Value Group By: 1:FV Group ID; 2:Cash Generating Unit; 3:Group Asset ID; 4:Parent ID
1=FV Group ID 2=Cash Generating Unit 3=Group Asset ID 4=Parent ID |
| 6 | FV_GROUP_ID | Character(20) | VARCHAR2(20) NOT NULL |
FV Group ID used to group related FV Assets
Prompt Table: %EDITTABLE |
| 7 | FV_INPUT_LEVEL | Character(1) | VARCHAR2(1) NOT NULL |
Fair Value Input Level. 1:Level1;2:Level2;3:Level4;4:All Level
1=Level 1 2=Level 2 3=Level 3 |
| 8 | COMMENTS | Long Character | CLOB | Comment |