AM_ADD_ATT

(SQL Table)
Index Back

AM asset file attachment

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_AM_NONVW

2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
3 SCM_ATTACH_ID Character(64) VARCHAR2(64) NOT NULL The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications.
4 ATT_VERSION Number(3,0) SMALLINT NOT NULL The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files.
5 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
6 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
7 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
8 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
9 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.