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