COST_TMP2 (SQL Table)	Index Back
Cost Tmp tbl used for Perf Used for performance improvement in AMIF1000

COST_TMP2

(SQL Table)

Cost Tmp tbl used for Perf

Used for performance improvement in AMIF1000

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name

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

4 TRANS_DT Date(10) DATE Transaction Date

5 DTTM_STAMP 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.

6 ACTIVITY_SW Signed Number(2,0) DECIMAL(1) NOT NULL Activity Switch

7 RETIRE_SW Signed Number(2,0) DECIMAL(1) NOT NULL Retirement Switch

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name
3	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
4	TRANS_DT	Date(10)	DATE	Transaction Date
5	DTTM_STAMP	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.
6	ACTIVITY_SW	Signed Number(2,0)	DECIMAL(1) NOT NULL	Activity Switch
7	RETIRE_SW	Signed Number(2,0)	DECIMAL(1) NOT NULL	Retirement Switch