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