PeopleSoft 9 Asset Management |
Table Name | IU_SYS_TRAN_TBL |
Table Description |
IU_SYS_TRAN_TBL |
Columns |
Name | Datatype | Is PK | Is FK |
IU_SYS_TRAN_CD | char(8) | Yes | No |
DESCR | char(30) | No | No |
MULTIPLE_FLG | char(1) | No | No |
RECNAME_HEADER | char(15) | No | No |
RECNAME_LINE | char(15) | No | No |
FIELDNAME_BU_GL | char(18) | No | No |
FIELDNAME_ACCTDATE | char(18) | No | No |
FIELDNAME_FRN_CUR | char(18) | No | No |
FIELDNAME_FRN_AMT | char(18) | No | No |
FIELDNAME_BASE_CUR | char(18) | No | No |
FIELDNAME_BASE_AMT | char(18) | No | No |
FIELDNAME_RT_MULT | char(18) | No | No |
FIELDNAME_RT_DIV | char(18) | No | No |
FIELDNAME_DESCR | char(18) | No | No |
FIELDNAME_LOCK | char(18) | No | No |
FIELDNAME_RT_TYPE | char(18) | No | No |
FIELDNAME_CUREFFDT | char(18) | No | No |
FIELDNAME_IU_FLAG | char(18) | No | No |
FIELDNAME_SEQ_FLD | char(18) | No | No |
FIELD_VALUE_LOCK | char(30) | No | No |
FIELD_VALUE_INTERP | char(30) | No | No |
FIELD_VALUE_INTERR | char(30) | No | No |
FIELD_VALUE_INTRAP | char(30) | No | No |
FIELD_VALUE_INTRAR | char(30) | No | No |
SEQUENCE_NBR_9 | int | No | No |
COMMIT_AFTER_LOCK | char(1) | No | No |
HEADER_LINE_FLAG | char(1) | No | No |
HEADER_LINE_FLAG2 | char(1) | No | No |
HEADER_LINE_FLAG3 | char(1) | No | No |
IU_TRANS_COMPLETE | char(1) | No | No |
IU_ANCHOR_BAL_OPTN | char(1) | No | No |
IU_SUMMARIZATION | char(1) | No | No |
ACT_BAL_GRP_FLG | char(1) | No | No |
WHERE_CLAUSE | char(254) | No | No |
Index |
Name | Type | Unique | Member |
PS_IU_SYS_TRAN_TBL | PK | Yes |
![]() |
Member(s) of "PS_IU_SYS_TRAN_TBL" Index |
IU_SYS_TRAN_CD |
Published December 16, 2006 |