PeopleSoft 9 Asset Management |
Table Name | OPEN_TRANS_ARCH |
Table Description |
OPEN_TRANS_ARCH |
Columns |
Name | Datatype | Is PK | Is FK |
ARCHIVE_ID | char(8) | Yes | No |
ARCHIVE_DT | PSDATE | Yes | No |
OPRID | char(30) | Yes | No |
OPEN_TRANS_ID | decimal(10) | Yes | No |
BUSINESS_UNIT | char(5) | Yes | No |
ASSET_ID | char(12) | Yes | No |
BOOK | char(10) | Yes | No |
DTTM_STAMP | PSDATETIME | Yes | No |
TRANS_TYPE | char(3) | Yes | No |
TRANS_DT | PSDATE | Yes | No |
ACCOUNTING_DT | PSDATE | Yes | No |
CALC_DEPR_STATUS | char(1) | Yes | No |
CALC_DIST_STATUS | char(1) | Yes | No |
GROUP_ASSET_ID | char(12) | Yes | No |
EFFDT | PSDATE | No | No |
TRANSFER_BU | char(5) | No | No |
TRANSFER_ASSET_ID | char(12) | No | No |
TRANSFER_BOOK | char(10) | No | No |
TRANS_IN_OUT | char(1) | No | No |
SUM_GROUP_STATUS | char(1) | No | No |
MIN_DTTM_STAMP | PSDATETIME | No | No |
PROCESS_INSTANCE | decimal(10) | No | No |
REQUEST_ID | char(10) | No | No |
Index |
Name | Type | Unique | Member |
PS_OPEN_TRANS_ARCH | PK | Yes |
![]() |
Member(s) of "PS_OPEN_TRANS_ARCH" Index |
ARCHIVE_ID |
ARCHIVE_DT |
OPRID |
OPEN_TRANS_ID |
BUSINESS_UNIT |
ASSET_ID |
BOOK |
DTTM_STAMP |
TRANS_TYPE |
TRANS_DT |
ACCOUNTING_DT |
CALC_DEPR_STATUS |
CALC_DIST_STATUS |
GROUP_ASSET_ID |
Published December 16, 2006 |