WHAT_IF_DPR_VW1

(SQL View)
Index Back

What If Depreciation


SELECT DISTINCT RUN_ID , BUSINESS_UNIT , WHAT_IF_METHOD , BOOK , METHOD FROM PS_WHAT_IF_DEPR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RUN_ID Character(25) VARCHAR2(25) NOT NULL Run ID
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 WHAT_IF_METHOD Character(2) VARCHAR2(2) NOT NULL Method
DL=Declining Balance w/SL% /Limit
DX=Declining Balance w/SL%
F1=France Derogatory Balance
FL=Flat Rate %
G1=Germany Staffel Method
J1=Japan- Intangible/Strt Line
J2=Japan- Tangible/Strt Line
J3=Japan- Tangible/Declining Bal
J4=Japanese- Lease Depreciation
J5=Japan-Changes DB to SL
MN=Manual Depreciation
PC=Declining Balance
SC=Depreciation Schedule
SL=Straight Line
SY=Sum of the Years
UD=User Defined Method
UP=Units of Production
4 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
5 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