AM_COMMENTS_VW(SQL View) |
Index Back |
|---|---|
AM asset file attachment |
| SELECT TRX.BUSINESS_UNIT , TRX.ASSET_ID , TRX.DTTM_STAMP , TRX.TXN_SRC_ID , TRX.OPRID , TRX.NAME , TRX.COMMENTS FROM PS_ASSET_COMMENTS TRX |
| # | 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 | 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. |
| 4 | TXN_SRC_ID | Character(3) | VARCHAR2(3) NOT NULL |
Transaction Source
ADD=Addition ADJ=Adjustment AFT=Asset Fluid Transactions ARO=ARO Measurement BAO=Define Asset Operational Info BAS=Basic Add BKS=Define Tax/Depr Criteria IMW=Impairment Worksheet IUM=Fixed Price MarkUp IUT=InterUnit Transfer RCT=Recategorize REA=Approve Disposals RET=Retire/Reinstate REW=Disposal Worksheet RVL=Revaluation RVW=Revaluation Worksheet TRF=Transfer TRV=Transaction Reversal |
| 5 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 6 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 7 | COMMENTS | Long Character | CLOB | Comment |