BOOK_IUT_DTM_VW(SQL View) |
Index Back |
|---|---|
Current Financial Book |
| SELECT A.BUSINESS_UNIT , A.ASSET_ID , A.BOOK , B.DTTM_STAMP ,A.LAST_BK_DTTM_STAMP , B.ACCOUNTING_DT , B.CALC_DEPR_STATUS , B.CALC_DIST_STATUS FROM PS_BOOK A , PS_OPEN_TRANS B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.ASSET_ID = B.ASSET_ID AND A.BOOK = B.BOOK AND B.DTTM_STAMP = ( SELECT MAX(C.DTTM_STAMP) FROM PS_OPEN_TRANS C WHERE B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.ASSET_ID = C.ASSET_ID ) |
| # | 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 | DTTM_STAMP |
DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 5 | LAST_BK_DTTM_STAMP | DateTime(26) | TIMESTAMP | Last Book Dttm Stamp |
| 6 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 7 | CALC_DEPR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Depreciation Calc Status
C=Completed Depreciation H=Held For Transfer In I=In Processing N=Never Calculate Depreciation P=Pending Depreciation |
| 8 | CALC_DIST_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Acctg Entry Creation Status
C=Completed Distribution N=Never Calculate Distribution P=Pending Distribution R=Reconcilie Clearing |