PeopleSoft 9 Asset Management |
Table Name | AMAEDIST_RQST |
Table Description |
AMAEDIST_RQST |
Columns |
Name | Datatype | Is PK | Is FK |
OPRID | char(30) | Yes | No |
RUN_CNTL_ID | char(30) | Yes | No |
REQUEST_ID | char(10) | Yes | No |
PROCESS_FREQUENCY | char(1) | No | No |
PROCESS_STATUS | char(1) | No | No |
PROCESS_INSTANCE | decimal(10) | No | No |
PROCESS_ORIG | char(1) | No | No |
DTTM_STAMP_SEC | PSDATETIME | No | No |
PARALLEL_SW | char(1) | No | No |
PROCESSING_SEQ | int | No | No |
OPEN_TRANS_FLAG | char(1) | No | No |
OPEN_TRANS_ID | decimal(10) | No | No |
TO_OPEN_TRANS_ID | decimal(10) | No | No |
BUSINESS_UNIT | char(5) | No | No |
BOOK | char(10) | No | No |
ASSET_ID_FROM | char(12) | No | No |
ASSET_ID_TO | char(12) | No | No |
BASE_CURRENCY | char(3) | No | No |
RATE_MULT | decimal(15,8) | No | No |
RATE_DIV | decimal(15,8) | No | No |
RT_TYPE | char(5) | No | No |
RATE_EFFDT | PSDATE | No | No |
COST_SUM_SW | char(1) | No | No |
Index |
Name | Type | Unique | Member |
PS_AMAEDIST_RQST | PK | Yes |
![]() |
Member(s) of "PS_AMAEDIST_RQST" Index |
OPRID |
RUN_CNTL_ID |
REQUEST_ID |
Published December 16, 2006 |