PeopleSoft 9
Asset Management

Table Name AM_RETIRE_APPR

Table Description
AM_RETIRE_APPR
Columns
Name Datatype Is PK Is FK
ORIGINATOR_ID char(11) Yes Yes
DATE_SUBMITTED PSDATE Yes Yes
BUSINESS_UNIT char(5) Yes No
ASSET_ID char(12) Yes No
DTTM_STAMP PSDATETIME Yes Yes
ROLEUSER char(30) No No
APPROVER_ID char(11) No No
DATE_APPROVED PSDATE No No
APPR_STATUS char(1) No No
DESCR char(30) No No
TAG_NUMBER char(12) No No
SERIAL_ID char(20) No No
CATEGORY char(5) No No
COST decimal(26,3) No No
CURRENCY_CD char(3) No No
QUANTITY decimal(15,4) No No
PROCEEDS decimal(26,3) No No
TXN_CURRENCY_CD char(3) No No
REMOVAL_COST decimal(26,3) No No
TXN_CURRENCY_CD1 char(3) No No
RETIRE_QUANTITY decimal(15,4) No No
DISPOSAL_CODE char(1) No No
RETIREMENT_DT PSDATE No No
TRANS_CODE char(5) No No
TRANS_DT PSDATE No No
ACCOUNTING_DT PSDATE No No
CONVENTION char(2) No No
PROCEEDS_PERCENT decimal(17,12) No No
REFERENCE char(30) No No
Index
Name Type Unique Member
PS_AM_RETIRE_APPR PK Yes
Member(s) of "PS_AM_RETIRE_APPR" Index
ORIGINATOR_ID
DATE_SUBMITTED
BUSINESS_UNIT
ASSET_ID
DTTM_STAMP

Published December 16, 2006