AM_WC_FYDPR1_VW

(SQL View)
Index Back

AM WorkCenter Fully Depr View

Fully Depreciated Stage View

SELECT DISTINCT BOOK.BUSINESS_UNIT , BOOK.ASSET_ID , BOOK.BOOK , A.DESCR , BOOK.END_DEPR_DT , A.ASSET_STATUS , BOOK.METHOD , BOOK.LIFE , BOOK.BEGIN_DEPR_DT FROM PS_BOOK BOOK , PS_ASSET A WHERE BOOK.RETIRED_SW IN (' ', 'N') AND BOOK.BUSINESS_UNIT = A.BUSINESS_UNIT AND BOOK.ASSET_ID = A.ASSET_ID AND A.ASSET_STATUS NOT IN ('T','D')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 END_DEPR_DT Date(10) DATE End Depreciation Date
6 ASSET_STATUS Character(1) VARCHAR2(1) NOT NULL Asset Status
A=Received (Not in Service)
B=Budgeted
C=Commitment
D=Disposed
I=In Service
M=Suspended
R=Requisitioned
T=Transferred
W=Work In Progress
7 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
8 LIFE Number(4,0) SMALLINT NOT NULL Useful Life
9 BEGIN_DEPR_DT Date(10) DATE Begin Depr Date