PeopleSoft 9.0
Cash Management

Table Name TRA_EVENT_CAL

Table Description
TRA_EVENT_CAL
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT CHAR(5) Yes Yes
TR_SOURCE_CD CHAR(1) Yes No
EVENT_ID CHAR(20) Yes No
EVENT_DT PSDATE Yes No
SEQ_NBR DECIMAL(15) Yes No
TRANSACTION_LEG SMALLINT Yes No
ACCTG_EVENT_TYPE CHAR(2) Yes No
CASH_FLOW_LINE DECIMAL(15) No No
ACCTG_TMPL_ID CHAR(15) No No
ACCRUED_UP_TO_AMT DECIMAL(26,3) No No
CURRENCY_CD CHAR(3) No No
ACCRUED_UP_TO_AMT2 DECIMAL(26,3) No No
CURRENCY_CD_2 CHAR(3) No No
ACCRUED_UP_TO_DT PSDATE No No
END_DT PSDATE No No
TRA_PROCESS_STATUS CHAR(1) No No
PROCESS_INSTANCE DECIMAL(10) No No
DOC_TYPE CHAR(8) No No
Index
Name Type Unique Member
PS_TRA_EVENT_CAL PK Yes
PSATRA_EVENT_CAL IE1 No
Member(s) of "PS_TRA_EVENT_CAL" Index
BUSINESS_UNIT
TR_SOURCE_CD
EVENT_ID
EVENT_DT
SEQ_NBR
TRANSACTION_LEG
ACCTG_EVENT_TYPE
Member(s) of "PSATRA_EVENT_CAL" Index
PROCESS_INSTANCE
TRA_PROCESS_STATUS
TR_SOURCE_CD
BUSINESS_UNIT
ACCTG_TMPL_ID
EVENT_ID
SEQ_NBR

Published April 30, 2007