AM_TEMPLATE_TBL(SQL Table) |
Index Back |
|---|---|
Template TableTemplate Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  AM_TEMPLATE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Template ID |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | AM_TRANS | Character(3) | VARCHAR2(3) NOT NULL |
AM Spreadsheet Transaction Type
ACU=Asset Addition with Accum Depr ADA=Asset Cost Adjustment by Amt ADD=Asset Addition ADJ=Asset Cost Adjustment by % ARC=ARO Conversion ARO=ARO Measurement IUT=Interunit Transfer NCP=Non-Capitalized Asset Addition RCT=Asset Recategorization RET=Asset Retirement TRF=Transfer Assets |
| 4 | AM_CREATED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By |
| 5 | AM_CREATED_DTTM | DateTime(26) | TIMESTAMP | Created On |
| 6 | AM_LASTUPDT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Updated By |
| 7 | AM_LASTUPDT_DTTM | DateTime(26) | TIMESTAMP | Last Updated On |