WHAT_IF_DPR_VW2

(SQL View)

SELECT A.RUN_ID , A.BUSINESS_UNIT , A.WHAT_IF_METHOD , A.BOOK , A.METHOD , A.DEPR_FY , SUM(A.DEPR) , SUM(A.WHAT_IF_DEPR) , B.CURRENCY_CD FROM PS_WHAT_IF_DEPR A , PS_BU_BOOK_TBL B WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.BOOK = A.BOOK GROUP BY A.RUN_ID , A.BUSINESS_UNIT , A.WHAT_IF_METHOD , A.BOOK , A.METHOD , A.DEPR_FY, B.CURRENCY_CD

# 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

6 DEPR_FY Number(4,0) SMALLINT NOT NULL

7 DEPR Signed Number(28,3) DECIMAL(26,3) NOT NULL Depreciation Amt

8 WHAT_IF_DEPR Signed Number(28,3) DECIMAL(26,3) NOT NULL What IF Depreciation Amount

9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

#	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
6	DEPR_FY	Number(4,0)	SMALLINT NOT NULL
7	DEPR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Depreciation Amt
8	WHAT_IF_DEPR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	What IF Depreciation Amount
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code