| # |
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 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
Prompt Table:
ASSET_VW
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
|
| 4 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
Default Value: 0
|
| 5 |
DATETIME_STAMP |
DateTime(26) |
TIMESTAMP |
DateTime Stamp
Default Value: %date
|
| 6 |
FMV |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Fair (Market) Value Amount
|
| 7 |
APPRAISAL_DT |
Date(10) |
DATE |
Appraisal Date
|
| 8 |
VALUATION_METHOD |
Character(30) |
VARCHAR2(30) NOT NULL |
Valuation Method
Prompt Table:
AM_FV_METHOD
Set Control Field: BUSINESS_UNIT
|
| 9 |
VALUATION_PREMISE |
Character(1) |
VARCHAR2(1) NOT NULL |
Fair Value Valuation Premise: 1:In-Exchange;2:In-Use
1=In-Exchange
2=In-Use
|
| 10 |
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
|
| 11 |
FV_GROUP_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
FV Group ID used to group related FV Assets
Prompt Table:
%EDITTABLE
|
| 12 |
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
|
| 13 |
COMMENTS |
Long Character |
CLOB |
Comment
|
| 14 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 15 |
FMV_LOAD_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
FMV Load Source
1=On-line
2=Lease
3=Revaluation Worksheet
4=Revalue In Mass
5=Transaction Loader
6=Component Interface
7=Other
|
| 16 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 17 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Default Value: CUR_RT_TYPE_VW.RT_TYPE
Prompt Table:
RT_TYPE_TBL
|