PeopleSoft 9
Asset Management

Table Name AMI_RQST

Table Description
AMI_RQST
Columns
Name Datatype Is PK Is FK
RQST_ID int Yes No
RQST_LINE_NUM int Yes No
RQST_LOAD_STATUS char(3) No No
PROCESS_INSTANCE decimal(10) No No
DTTM_STAMP PSDATETIME No No
AMI_INTFC_TYPE char(3) No No
OPRID char(30) No No
MESSAGE_SET_NBR int No No
MESSAGE_NBR int No No
SYSTEM_SOURCE char(3) No No
APPROVAL_SW char(1) No No
TRANS_DT PSDATE No No
ACCOUNTING_DT PSDATE No No
BUSINESS_UNIT_AM char(5) No No
ASSET_ID char(12) No No
BUSINESS_UNIT_AM2 char(5) No No
ASSET_ID2 char(12) No No
AMOUNT_1 decimal(26,3) No No
CURRENCY_CD1 char(3) No No
AMOUNT_2 decimal(26,3) No No
CURRENCY_CD2 char(3) No No
AMI_REASON char(3) No No
NEEDS_REPAIR_SW char(1) No No
DISPOSAL_CODE char(1) No No
DTTM_STAMP_PREV PSDATETIME No No
Index
Name Type Unique Member
PS_AMI_RQST PK Yes
Member(s) of "PS_AMI_RQST" Index
RQST_ID
RQST_LINE_NUM

Published December 16, 2006