PeopleSoft 9.0
Cash Management

Table Name TRX_HEADER_TR

Table Description
TRX_HEADER_TR
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT CHAR(5) Yes Yes
TREAS_HEADER_ID CHAR(12) Yes No
INSTRUMENT_TYPE CHAR(10) No No
INSTRMNT_TEMPLATE CHAR(10) No No
TRANSACTION_DT PSDATE No No
COUNTERPARTY_SETID CHAR(5) No No
COUNTERPARTY CHAR(5) No No
DEAL_FAMILY_TYPE CHAR(4) No No
INTER_UNIT_DEAL CHAR(1) No No
TREAS_MAST_SUB_BU CHAR(5) No No
TREAS_MAST_SUB_ID CHAR(12) No No
TREAS_MAST_ROLL_ID CHAR(12) No No
TREAS_BACK_ROLL_ID CHAR(12) No No
TREAS_MIRROR_BU CHAR(5) No No
TREAS_MIRROR_ID CHAR(12) No No
TREAS_MIRROR_CPTY CHAR(5) No No
DESCR150_MIXED CHAR(150) No No
TRANSACTION_ISSUER CHAR(5) No No
TRANSACT_GUARANTOR CHAR(5) No No
TRANSACTION_BROKER CHAR(5) No No
DEALER_OPRID CHAR(30) No No
TRANSACTION_DTTM PSDATETIME No No
ORIG_OPRID CHAR(30) No No
ORIG_DTTM PSDATETIME No No
TREASURY_PORTFOLIO CHAR(15) No Yes
CPTY_DEALER CHAR(10) No No
CPTY_REFERENCE CHAR(15) No No
TRANSACTION_LOCKED CHAR(1) No No
NET_CASHFLOWS CHAR(1) No No
TRA_ACTG_TREATMENT CHAR(2) No No
TR_COLL_LVL_MIN DECIMAL(26,3) No No
TR_SUB_REPO CHAR(1) No No
TR_COLL_LVL_MAX DECIMAL(26,3) No No
TR_SUB_LIMIT DECIMAL(5,2) No No
TR_REPO_PRICE DECIMAL(26,3) No No
MTM_CURRENCY CHAR(3) No No
MTM_VALUE_OVRD_SW CHAR(1) No No
MTM_ACCTG_VALUE_0 DECIMAL(26,3) No No
MTM_ACCTG_VALUE DECIMAL(26,3) No No
MTM_EXCL_VALUE DECIMAL(26,3) No No
MTM_DEAL_VALUE DECIMAL(26,3) No No
SALE_CPTY_SETID CHAR(5) No No
SALE_COUNTERPARTY CHAR(5) No No
SALE_CPTY_REF CHAR(15) No No
SALE_CPTY_DEALER CHAR(10) No No
SALE_TRANS_AMT DECIMAL(26,3) No No
SALE_PRICE_PERCENT DECIMAL(13,8) No No
SALE_PROCEEDS DECIMAL(26,3) No No
SALE_PRICE DECIMAL(26,3) No No
SALE_PURCH_INT DECIMAL(26,3) No No
PURCH_INT_SOURCE CHAR(1) No No
SALE_CURRENT_VALUE DECIMAL(26,3) No No
SALE_UBV_SOURCE CHAR(1) No No
SALE_UPB DECIMAL(26,3) No No
SALE_ORDER_TYPE CHAR(2) No No
AMORT_DISC_AMT DECIMAL(26,3) No No
UNAMORT_DISC_AMT DECIMAL(26,3) No No
SALE_PRO_PERCENT DECIMAL(13,8) No No
WRITEOFF_UNAM DECIMAL(26,3) No No
SALE_FEE_BALANCE DECIMAL(26,3) No No
AMORT_FEE_AMT DECIMAL(26,3) No No
UNAMORT_FEE_AMT DECIMAL(26,3) No No
WRITEOFF_FEE_AMT DECIMAL(26,3) No No
SALE_CURRENCY CHAR(3) No No
SALE_DT PSDATE No No
SALE_SETTLEMENT_DT PSDATE No No
SALE_BANK_SETID CHAR(5) No No
SALE_BANK_CD_CUST CHAR(5) No No
SALE_BANK_CD CHAR(5) No No
SALE_BANK_ACCT_KEY CHAR(4) No No
SALE_SETTLEMENT_ID CHAR(5) No No
SALE_PYMNT_METHOD CHAR(3) No No
SALE_FORMAT_ID CHAR(10) No No
PREAPPV_SW CHAR(1) No No
DEAL_PVW_SUBMITTED CHAR(1) No No
TR_APPV_STATUS CHAR(2) No No
PREAPPV_MAIL_SENT CHAR(2) No No
DEAL_STATUS CHAR(2) No No
DEAL_RVW_SUBMITTED CHAR(1) No No
CONF_RVW_SUBMITTED CHAR(1) No No
APPROVAL_DTTM PSDATETIME No No
APPROVAL_OPRID CHAR(30) No No
DEAL_CONF_STATUS CHAR(2) No No
DEAL_CONF_DTTM PSDATETIME No No
DEAL_CONF_OPRID CHAR(30) No No
AUTO_CONF_SENT CHAR(1) No No
CONF_MAIL_SENT CHAR(2) No No
CONFO_OUT_SENT CHAR(1) No No
LAST_MAINT_DTTM PSDATETIME No No
LAST_MAINT_OPRID CHAR(30) No No
EXCL_FROM_POSITION CHAR(1) No No
LIMIT_RESERVED CHAR(1) No No
FCLTY_ID CHAR(12) No No
TREAS_MASTER_ID CHAR(12) No No
TREAS_NEXT_ID CHAR(12) No No
TREAS_PREVIOUS_ID CHAR(12) No No
TRD_TRADE_ID CHAR(12) No No
TRADE_TYPE CHAR(1) No No
TRD_SELLBUY_FLAG CHAR(1) No No
START_DT PSDATE No No
START_DISCOUNT_AMT DECIMAL(26,3) No No
SECURITY_ID CHAR(10) No No
RUN_POSN CHAR(1) No No
TRP_BUSINESS_UNIT CHAR(5) No No
POOL_ID CHAR(10) No No
EVENT_TRACKING_ID DECIMAL(10) No No
CR_RATING_TYPE CHAR(8) No No
CR_RATING_VALUE SMALLINT No No
Index
Name Type Unique Member
PS_TRX_HEADER_TR PK Yes
PS0TRX_HEADER_TR IE1 No
PS1TRX_HEADER_TR IE2 No
PS2TRX_HEADER_TR IE3 No
PS3TRX_HEADER_TR IE4 No
PS4TRX_HEADER_TR IE5 No
PS5TRX_HEADER_TR IE6 No
PS6TRX_HEADER_TR IE7 No
PS7TRX_HEADER_TR IE8 No
PSATRX_HEADER_TR IE9 No
Member(s) of "PS_TRX_HEADER_TR" Index
BUSINESS_UNIT
TREAS_HEADER_ID
Member(s) of "PS0TRX_HEADER_TR" Index
INSTRUMENT_TYPE
BUSINESS_UNIT
TREAS_HEADER_ID
Member(s) of "PS1TRX_HEADER_TR" Index
INSTRMNT_TEMPLATE
BUSINESS_UNIT
TREAS_HEADER_ID
Member(s) of "PS2TRX_HEADER_TR" Index
TRANSACTION_DT
BUSINESS_UNIT
TREAS_HEADER_ID
Member(s) of "PS3TRX_HEADER_TR" Index
COUNTERPARTY
BUSINESS_UNIT
TREAS_HEADER_ID
Member(s) of "PS4TRX_HEADER_TR" Index
DEAL_STATUS
BUSINESS_UNIT
TREAS_HEADER_ID
Member(s) of "PS5TRX_HEADER_TR" Index
TREAS_MASTER_ID
BUSINESS_UNIT
TREAS_HEADER_ID
Member(s) of "PS6TRX_HEADER_TR" Index
TRD_TRADE_ID
BUSINESS_UNIT
TREAS_HEADER_ID
Member(s) of "PS7TRX_HEADER_TR" Index
SECURITY_ID
BUSINESS_UNIT
TREAS_HEADER_ID
Member(s) of "PSATRX_HEADER_TR" Index
BUSINESS_UNIT
TREAS_BACK_ROLL_ID

Published April 30, 2007