PeopleSoft 9
Asset Management

Table Name OPEN_TRANS

Table Description
OPEN_TRANS
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
BOOK char(10) Yes Yes
DTTM_STAMP PSDATETIME Yes Yes
TRANS_DT PSDATE Yes No
ACCOUNTING_DT PSDATE Yes No
TRANS_TYPE char(3) Yes No
MEM_IN_SERVICE_DT PSDATE Yes No
CONVENTION char(2) 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
CALC_DEPR_STATUS char(1) No No
CALC_DIST_STATUS char(1) No No
CALC_REPT_STATUS char(1) No No
SUM_GROUP_STATUS char(1) No No
OPRID char(30) No No
OPEN_TRANS_ID decimal(10) No No
MIN_DTTM_STAMP PSDATETIME No No
MAX_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 PK Yes
PS0OPEN_TRANS IE1 No
PS1OPEN_TRANS IE2 No
PS2OPEN_TRANS IE3 No
PS3OPEN_TRANS IE4 No
PSAOPEN_TRANS IE5 No
PSBOPEN_TRANS IE6 No
Member(s) of "PS_OPEN_TRANS" Index
BUSINESS_UNIT
ASSET_ID
BOOK
DTTM_STAMP
TRANS_DT
ACCOUNTING_DT
TRANS_TYPE
MEM_IN_SERVICE_DT
CONVENTION
GROUP_ASSET_ID
Member(s) of "PS0OPEN_TRANS" Index
CALC_DEPR_STATUS
BUSINESS_UNIT
ASSET_ID
BOOK
DTTM_STAMP
TRANS_DT
ACCOUNTING_DT
TRANS_TYPE
MEM_IN_SERVICE_DT
CONVENTION
GROUP_ASSET_ID
Member(s) of "PS1OPEN_TRANS" Index
CALC_DIST_STATUS
BUSINESS_UNIT
ASSET_ID
BOOK
DTTM_STAMP
TRANS_DT
ACCOUNTING_DT
TRANS_TYPE
MEM_IN_SERVICE_DT
CONVENTION
GROUP_ASSET_ID
Member(s) of "PS2OPEN_TRANS" Index
CALC_REPT_STATUS
BUSINESS_UNIT
ASSET_ID
BOOK
DTTM_STAMP
TRANS_DT
ACCOUNTING_DT
TRANS_TYPE
MEM_IN_SERVICE_DT
CONVENTION
GROUP_ASSET_ID
Member(s) of "PS3OPEN_TRANS" Index
SUM_GROUP_STATUS
BUSINESS_UNIT
ASSET_ID
BOOK
DTTM_STAMP
TRANS_DT
ACCOUNTING_DT
TRANS_TYPE
MEM_IN_SERVICE_DT
CONVENTION
GROUP_ASSET_ID
Member(s) of "PSAOPEN_TRANS" Index
BUSINESS_UNIT
ASSET_ID
BOOK
OPEN_TRANS_ID
Member(s) of "PSBOPEN_TRANS" Index
OPEN_TRANS_ID
BUSINESS_UNIT
BOOK

Published December 16, 2006