CASH_FLW_POS_VW

(SQL View)
 Index Back

POS view for TR sources

Position source view for TR sources over CASH_FLOW_TR

SELECT A.TR_SOURCE_CD ,A.SOURCE_BUS_UNIT ,A.TR_SOURCE_ID ,A.BUSINESS_DATE ,A.CASH_FLOW_LINE ,A.CASH_FLOW_LEG ,A.SEQ_NBR ,A.BANK_SETID ,A.BANK_CD_CUST ,A.BANK_CD ,A.BANK_ACCT_KEY ,A.ACCT_BUS_UNIT_GL ,A.BNK_ID_NBR ,A.BANK_ACCOUNT_NUM ,A.AMOUNT ,A.CURRENCY_CD FROM PS_CASH_FLOW_TR A WHERE A.CASH_FLOW_LINE <> 0 AND A.RECON_STATUS = 'UNR' AND A.NET_STATUS <> 'D' AND A.BANK_CD = A.BANK_CD_CUST AND PYMNT_SELCT_STATUS <> 'P'

  • Parent record: CASH_FLOW_TR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TR_SOURCE_CD Character(1) VARCHAR2(1) NOT NULL Note: Changes to Translate Values must also be made to TRA_SOURCE_CD and SOURCE_TYPE. These 3 fields must be kept in sync. Values that are inactive are for use in TR Accounting only
    B=BSP
    D=Deals
    E=Deal Fees
    F=Facility Fees
    H=Hedges
    I=Interest
    M=Deal: Estimated Maturity Accr
    N=Netted Deal
    O=Other
    P=Investment Pools
    R=EFT Fees
    S=Securities
    T=LC Fees
    W=EFT Requests
    X=Bank Transfers
    2 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
    3 TR_SOURCE_ID Character(12) VARCHAR2(12) NOT NULL An internal work field that represents a unique identifier for records depicting a given treasury po
    4 BUSINESS_DATE Date(10) DATE Represents a date upon which business is conducted within a given company in a given country.
    5 CASH_FLOW_LINE Number(15,0) DECIMAL(15) NOT NULL A sequential number that indicates the time order sequence of a given deal transaction's cash flows.
    6 CASH_FLOW_LEG Number(1,0) SMALLINT NOT NULL A sequential number that indicates the relationship between a cash flow and its corresponding deal transaction leg
    7 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    8 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
    9 BANK_CD_CUST Character(5) VARCHAR2(5) NOT NULL Represents the customer bank or counterparty in a relationship that pairs differing sets of b
    10 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
    11 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank
    12 ACCT_BUS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL The general ledger business unit associated with a given bank/counterparty account.
    13 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
    14 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
    15 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
    16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code