PC_AM_AST_BK_VW

(SQL View)
 Index Back

Projects Book Level Assets


SELECT A.BUSINESS_UNIT_AM , A.ASSET_ID , A.BUSINESS_UNIT , A.PROJECT_ID , A.BOOK , A.CRITERIA_ID , B.CATEGORY , B.GROUP_ASSET_ID , C.CURRENCY_CD , B.BK_CAP_THRSHLD_ID , %subrec(PC_AM_BOOK_SBR, B) FROM PS_PC_AM_ASSET A , PS_PROFILE_DET_TBL B , PS_BU_BOOK_TBL C WHERE A.PROFILE_ID = B.PROFILE_ID AND A.BOOK = B.BOOK AND B.SETID = ( SELECT SCR.SETID FROM PS_SET_CNTRL_REC SCR WHERE SCR.RECNAME = 'PROFILE_DET_TBL' AND SCR.SETCNTRLVALUE = A.BUSINESS_UNIT_AM) AND %EffdtCheck(PROFILE_DET_TBL, B, %CurrentDateIn) AND A.BUSINESS_UNIT_AM = C.BUSINESS_UNIT AND A.BOOK = C.BOOK

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_PC_NONVW

4 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: SP_PROJ_NONVW

5 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
6 CRITERIA_ID Character(10) VARCHAR2(10) NOT NULL Selection Criteria ID
7 CATEGORY Character(5) VARCHAR2(5) NOT NULL Asset Category

Prompt Table: CATEGORY_TBL
Set Control Field: BUSINESS_UNIT_AM

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

Prompt Table: BK_GRP_ASSET_VW

9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
10 BK_CAP_THRSHLD_ID Character(10) VARCHAR2(10) NOT NULL Threshold ID
11 DEPR_STATUS Character(1) VARCHAR2(1) NOT NULL Depreciation Status
D=Depreciable
N=Non Depreciable
12 REGULATION Character(1) VARCHAR2(1) NOT NULL Depreciation Regulation
A=Accelerated Cost Recovery Sys
D=Asset Depreciation Range
F=Conventional/Facts& Circumstan
G=Guideline
M=Modified Accel Cost Recovery
13 RECOVERY_LIFE Number(4,1) DECIMAL(3,1) NOT NULL Recovery Life
14 RECOVERY_SUBTYPE Character(2) VARCHAR2(2) NOT NULL Recovery SubType
LI=Low-Income Housing
PU=Public Utility Property
15 CONVENTION Character(2) VARCHAR2(2) NOT NULL Book Depreciation Convention or Cost Convention

Prompt Table: CONV_SETID_VW

16 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
17 CALCULATION_TYPE Character(1) VARCHAR2(1) NOT NULL Calculation Type
L=Life-to-Date
R=Remaining Value
18 DEPR_PERCENT Number(10,8) DECIMAL(9,8) NOT NULL Depreciation Percent
19 DB_PERCENT Number(16,14) DECIMAL(15,14) NOT NULL Declining Balance Percent
20 DEPR_SCHED_CD Character(10) VARCHAR2(10) NOT NULL Schedule Code

Prompt Table: DEPR_SCHED_TBL

21 DEPR_LIMIT_CD Character(10) VARCHAR2(10) NOT NULL Depreciation Limit Code

Prompt Table: DEPR_LIM_TBL

22 LIFE Number(4,0) SMALLINT NOT NULL Useful Life
23 TAX_CLASS_AM Character(6) VARCHAR2(6) NOT NULL Guideline Tax Class

Prompt Table: TAX_CLASS_AM

24 PROPERTY_CD Character(1) VARCHAR2(1) NOT NULL Property Code
1=1245 Property
2=1250 Property
25 PROPERTY_TYPE Character(1) VARCHAR2(1) NOT NULL Property Type
P=Personal
R=Non-Residential Real
S=Residential Real
26 SALVAGE_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Salvage Value
27 SALVAGE_PCT Number(16,14) DECIMAL(15,14) NOT NULL Salvage Percentage
28 LIFE_END_DT Date(10) DATE Useful Life End Date
29 DEPR_LOW_LIMIT Signed Number(28,3) DECIMAL(26,3) NOT NULL Depr Low Limit Amount
30 COST_BASIS_LIMIT Signed Number(28,3) DECIMAL(26,3) NOT NULL Cost Basis Limit
31 DEPR_AVG_OPTION Character(1) VARCHAR2(1) NOT NULL Depreciation Averaging Option
M=Monthly Averaging
N=No Averaging
Y=Yearly Averaging
32 UOP_ID Character(10) VARCHAR2(10) NOT NULL Units of Production ID

Prompt Table: UOP_TBL

33 INCLUDE_CAP_GAINS Character(1) VARCHAR2(1) NOT NULL CGT Applicable

Y/N Table Edit

34 UD_METHOD_ID Character(5) VARCHAR2(5) NOT NULL Method ID

Prompt Table: UD_METHOD

35 ACCOUNTING_MTHD Character(3) VARCHAR2(3) NOT NULL Accounting Method
ALL=Allowance
EXP=Expense
RES=Reserve
36 AM_BK_UD_CHAR1 Character(10) VARCHAR2(10) NOT NULL User Defined Char Field1
37 AM_BK_UD_CHAR2 Character(10) VARCHAR2(10) NOT NULL User Defined Char Field2
38 AM_BK_UD_DATE1 Date(10) DATE User Defined Date Field1
39 AM_BK_UD_NUM1 Number(19,3) DECIMAL(18,3) NOT NULL User Defined Number Field1
40 AM_BK_UD_NUM2 Number(19,3) DECIMAL(18,3) NOT NULL User Defined Number Field2
41 FUTURE_DEPR_YEARS Number(3,0) SMALLINT NOT NULL No of Future Depreciation Year
42 INCREASE_RATE Signed Number(11,6) DECIMAL(9,6) NOT NULL Increased Rate
43 DEPR_BONUS_PCT Number(6,2) DECIMAL(5,2) NOT NULL Depreciation Bonus Percent
44 DEPR_BONUS_SW Character(3) VARCHAR2(3) NOT NULL Resolution Date Description -------------- ------- ------------------ 753343 03/13/08 New depreciation bonus:Stimulus Act is added.
0=None
1=Section 101 - Federal
2=New York Liberty Zone
3=Section 101 - Local
4=Gulf Opportunity Zone
5=Stimulus Act
6=American Recovery&Reinvestment
45 ADJUST_CONVENTION Character(2) VARCHAR2(2) NOT NULL Adjustment Convention