WM_TOP_COST_AST

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_AM_NONVW

3 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

Default Value: NEXT

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
6 COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Cost
7 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

Default Value: %datetime