COST_ASOF4A_VW

(SQL View)
 Index Back

Asset Cost As Of Year/Period


SELECT A.BOOK , B.FISCAL_YEAR , B.ACCOUNTING_PERIOD , B.CALENDAR_ID , A.BUSINESS_UNIT , A.ASSET_ID , %subrec(CF12_AN_SBR, A) , %subrec(AM_CF1_N_SBR, A), A.PROJECT_ID , A.DEPTID , A.CAL_DEPR_PD , A.TRANS_DT , A.CATEGORY , A.COST_TYPE , A.QUANTITY , SUM(A.COST) , D.DEPR_PERCENT , D.LIFE_END_DT , D.SUSPEND_DT , D.RESUME_DT , D.METHOD , D.LIFE_IN_YRS , E.ACCUM_DEPR , E.NET_BK_VALUE , E.DEPR_CUR , F.NUMBER_OF_PERIODS , A.FROM_CUR FROM PS_COST_ASOF1_VW A , PS_CAL_DETP_TBL B , PS_SET_CNTRL_REC C , PS_BOOK D , PS_INSTALLATION_AM E , PS_CAL_DEFN_TBL F WHERE B.SETID = C.SETID AND C.SETCNTRLVALUE= A.BUSINESS_UNIT AND C.RECNAME='CAL_DETP_TBL' AND A.TRANS_DT < B.BEGIN_DT AND A.CAL_DEPR_PD = B.CALENDAR_ID AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.ASSET_ID = D.ASSET_ID AND A.BOOK = D.BOOK AND B.SETID = F.SETID AND B.CALENDAR_ID = F.CALENDAR_ID GROUP BY A.BOOK , B.FISCAL_YEAR , B.ACCOUNTING_PERIOD , B.CALENDAR_ID , A.BUSINESS_UNIT , A.ASSET_ID , %subrec(CF12_AN_SBR, A), %subrec(AM_CF1_N_SBR, A), A.PROJECT_ID, A.DEPTID, A.CAL_DEPR_PD , A.TRANS_DT , A.CATEGORY , A.COST_TYPE , A.QUANTITY, D.DEPR_PERCENT , D.LIFE_END_DT , D.SUSPEND_DT , D.RESUME_DT , D.METHOD , D.LIFE_IN_YRS , E.ACCUM_DEPR , E.NET_BK_VALUE , E.DEPR_CUR, F.NUMBER_OF_PERIODS , A.FROM_CUR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
2 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
3 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.
4 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

6 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
7 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
8 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
9 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
10 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
11 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
12 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
13 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
14 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
15 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
16 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
17 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
18 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
19 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
20 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
21 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
22 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
23 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
24 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
25 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
26 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
27 CAL_DEPR_PD Character(2) VARCHAR2(2) NOT NULL Calendar
28 TRANS_DT Date(10) DATE Transaction Date
29 CATEGORY Character(5) VARCHAR2(5) NOT NULL Asset Category
30 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type
31 QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Interface
32 COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Cost
33 DEPR_PERCENT Number(10,8) DECIMAL(9,8) NOT NULL Depreciation Percent
34 LIFE_END_DT Date(10) DATE Useful Life End Date
35 SUSPEND_DT Date(10) DATE Suspend Date
36 RESUME_DT Date(10) DATE Resume Date
37 METHOD Character(2) VARCHAR2(2) NOT NULL Method
DL=DB w/SL By Limit%
DX=Declining Balance w/SL
F1=France Derogatory Balance
FL=Flat Rate %
G1=Germany Staffel Method
J1=Japan- Tangible/Declining Bal
J2=Japan- Tangible/Strt Line
J3=Japan- Intangible/Strt Line
J4=Japan - Lease Depreciation
J5=Japan-Changes DB to SL
J6=Japan - Changes DB to SL 250
J7=Japan-Tangible/Strt Line Rev
J8=Japan - Changes DB to SL 200
J9=JPN - Changes 200/250 DB to SL
JE=Japan - Extended/Strt Line
MN=Manual Depreciation
PC=Declining Balance
SC=Depreciation Schedule
SL=Straight Line
SP=Straight Line Percent
SY=Sum of the Years
UD=User Defined Method
UP=Units of Production
38 LIFE_IN_YRS Number(6,1) DECIMAL(5,1) NOT NULL Life in Years
39 ACCUM_DEPR Signed Number(28,3) DECIMAL(26,3) NOT NULL Accumulated Depreciation
40 NET_BK_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Book Value
41 DEPR_CUR Signed Number(28,3) DECIMAL(26,3) NOT NULL Current Period Depreciation
42 NUMBER_OF_PERIODS Number(3,0) SMALLINT NOT NULL Periods in a Year
43 FROM_CUR Character(3) VARCHAR2(3) NOT NULL From Currency Code