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 |
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 |