AM_WC_FYDPR1_VW(SQL View) |
Index Back |
---|---|
AM WorkCenter Fully Depr ViewFully 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 |