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 |