COST_ASOF2_VW

#	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
2	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
3	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name
4	CF_SEQNO	Number(6,0)	INTEGER NOT NULL	Chartfield Sequence Number
5	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField
6	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField
7	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code
8	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field
9	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField
10	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference
11	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate
12	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1
13	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate
14	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1
15	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2
16	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3
17	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
18	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
19	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type
20	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category
21	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory
22	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
23	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
24	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
25	CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Asset Category
26	COST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Cost Type
27	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.
28	TRANS_DT	Date(10)	DATE	Transaction Date
29	TRANS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Types of Asset Management Transactions ACR=Accretion Expense ADD=Asset Addition ADJ=Asset Cost Adjustment BKS=Book Adjustment BUD=Budgeted Depreciation DPR=Depreciation INF=Inflation Adjustment LEX=Lease Expense LPB=Budgeted Lease Payments LPY=Lease Payment PDP=Prior Period Depreciation PLP=Prior Lease Payment RAD=Manual Reserve Adjustment RCT=Asset Recategorization REI=Asset Reinstatement RES=Resume Depreciation RET=Asset Retirement RRC=Retro rate change for grp ast SUS=Suspend Depreciation TRF=Asset Transfer
30	TRANS_IN_OUT	Character(1)	VARCHAR2(1) NOT NULL	Transaction In/Out I=In M=IUT Proceeds Markup O=Out
31	TRANS_CODE	Character(5)	VARCHAR2(5) NOT NULL	Transaction Code
32	ACTIVITY_SW	Signed Number(2,0)	DECIMAL(1) NOT NULL	Activity Switch
33	RETIRE_SW	Signed Number(2,0)	DECIMAL(1) NOT NULL	Retirement Switch
34	QUANTITY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Interface
35	COST	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Cost
36	SALVAGE_VALUE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Salvage Value
37	CAL_DEPR_PD	Character(2)	VARCHAR2(2) NOT NULL	Calendar
38	GROUP_ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Group Asset ID
39	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
40	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
41	FROM_CUR	Character(3)	VARCHAR2(3) NOT NULL	From Currency Code
42	AM_PHY_TXN_SW	Character(1)	VARCHAR2(1) NOT NULL	This field will be used on the Cost table and will specifiy whether the transaction is Financial or Physical.