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 |