COST_ASOF1_VW (SQL View)	Index Back
Asest Cost As Of Temp View

COST_ASOF1_VW

(SQL View)

Asest Cost As Of Temp View

SELECT A.BUSINESS_UNIT , A.ASSET_ID , A.BOOK , A.CF_SEQNO , %subrec(CF12_AN_SBR, A) , %subrec(AM_CF1_N_SBR, A) , A.PROJECT_ID , A.DEPTID , A.CATEGORY , A.COST_TYPE , A.DTTM_STAMP , A.TRANS_DT , A.TRANS_TYPE , A.TRANS_IN_OUT , A.TRANS_CODE , A.ACTIVITY_SW , A.RETIRE_SW , A.QUANTITY , A.COST , A.SALVAGE_VALUE , B.CAL_DEPR_PD , A.ACCOUNTING_DT , A.GROUP_ASSET_ID , A.FROM_CUR , A.AM_PHY_TXN_SW FROM PS_BU_BOOK_VW B , PS_COST A WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BOOK = B.BOOK

Parent record: BOOK

# 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 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

39 GROUP_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Group Asset ID

40 FROM_CUR Character(3) VARCHAR2(3) NOT NULL From Currency Code

41 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.

#	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	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
39	GROUP_ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Group Asset ID
40	FROM_CUR	Character(3)	VARCHAR2(3) NOT NULL	From Currency Code
41	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.