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 |