CASH_FLOW_TR

(SQL Table)
Index Back

Treasury Cashflows

Treasury Cashflows due to Deals, Bank Transfers, EFT's, Facility Fees. NOTES: When changing this record (add or delete field) make sure change the related temp table CASH_FLW_TR_TMP, as well as the following SQLs: AP_APY2015_TRET_C AP_APY2015_TRET_G AP_APY2015_TR_C AP_APY2015_TR_G

  • Parent Record Of CASH_FLOW_CF_VW CASH_FLW_POS_VW
  • # 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 PAY_DOC_SEQ Number(5,0) INTEGER NOT NULL Advice Sequence
    9 CASH_TYPE Character(2) VARCHAR2(2) NOT NULL Represents the type of cash flow stored in the Treasury database.
    01=Actual
    02=Provisional
    03=Sample
    04=Deactivated
    10 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
    11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    12 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.

    Prompt Table: SP_SIACT_NONVW

    13 BANK_CD_CUST Character(5) VARCHAR2(5) NOT NULL Represents the customer bank or counterparty in a relationship that pairs differing sets of b
    14 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

    Prompt Table: BANK_CD_TBL

    15 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

    Prompt Table: BANK_ACCT_DEFN

    16 ACCT_BUS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL The general ledger business unit associated with a given bank/counterparty account.

    Prompt Table: SP_BU_GL_NONVW

    17 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.

    Prompt Table: BANK_ID_VW

    18 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.

    Prompt Table: BANK_ACCTKEY_VW

    19 TRANSACTION_LINE Number(3,0) SMALLINT NOT NULL The separate and distinct base instrument type components of a given deal transaction.
    20 RECONCILE_DT Date(10) DATE The transaction reconciliation date.
    21 RECONCILE_OPRID Character(30) VARCHAR2(30) NOT NULL The user ID that performed the reconciliation for a given transaction.
    22 RECON_TYPE Character(1) VARCHAR2(1) NOT NULL Represents a series of options as to how a treasury wishes to perform reconciliation for a given bank
    A=Automatically Reconciled
    B=Balance System(s) to BankTran
    F=Forced to Reconcile
    M=Manually Reconciled
    S=Semi Manual
    U=Unreconciled

    Default Value: U

    23 RECON_STATUS Character(3) VARCHAR2(3) NOT NULL Reconciliation Status
    ALG=Alignment Check
    AMB=Ambiguous Match
    AMT=Amounts Not Equal
    CUR=Currency not Defined
    DAT=Tran Date <> Value Date
    DPI=Duplicate Input Transactions
    DUP=Duplicate Transaction
    MSC=Miscellaneous Transaction
    NAM=Payee Names Not Equal
    NTB=Not Found in Statement
    NTF=Not Found In System
    NTP=Not Found in POS Data
    NUL=Null Transaction ID Ref
    OVR=Overflow
    PND=Pending Reconciliation
    REC=Reconciled
    RPR=Reprinted Check
    RR=Requires Review - BSAC
    STP=Stop Payment
    TYP=Wrong Transaction Type
    UNR=Unreconciled
    VOI=Voided Check

    Default Value: UNR

    24 RECON_CYCLE_NBR Number(10,0) DECIMAL(10) NOT NULL The bank statement ID.
    25 RECORD_SEQ_NUMBER Number(10,0) DECIMAL(10) NOT NULL An internal work field utilized to enumerate database records in bank statement processing.
    26 STTLMNT_DT_ACTUAL Date(10) DATE Date in which a deal transaction is actually settled with a counterparty.
    27 NET_STATUS Character(1) VARCHAR2(1) NOT NULL Indicates the counterparty netting status of a given settlement transaction.
    D=Netted
    N=Net
    O=Not Netted

    Default Value: O

    28 SELECTED_OPRID Character(30) VARCHAR2(30) NOT NULL Selected Operator
    29 SELECTED_DTTM DateTime(26) TIMESTAMP Selected Date
    30 APPROVAL_OPRID Character(30) VARCHAR2(30) NOT NULL A system generated value that reflects the operator that approved a given transaction.
    31 APPROVAL_DTTM DateTime(26) TIMESTAMP A system generated value that reflects the date and time a given transaction is approved by an oper
    32 CPTY_REFERENCE Character(15) VARCHAR2(15) NOT NULL A reference identifier associated with a dealing counterparty transaction.
    33 NET_REF_ID Character(12) VARCHAR2(12) NOT NULL A reference identifier associated with a cash transaction subject to netting with a given bank/count
    34 CF_SOURCE_REF_ID Character(40) VARCHAR2(40) NOT NULL Reference identifier for a treasury system cash flow.
    35 CP_NETTOR Character(30) VARCHAR2(30) NOT NULL Allows the user to indicate whether a given dealing counterparty permits netting of inbound and outbou
    36 PYMNT_METHOD Character(3) VARCHAR2(3) NOT NULL Payment Method
    ACH=Automated Clearing House
    BEF=Draft - Customer EFT
    BOO=Draft - Customer Initiated
    CHK=System Check
    D=Deposit
    DD=Direct Debit
    DFT=Draft - Supplier Initiated
    DRA=Draft
    EFT=Electronic Funds Transfer
    GE=Giro - EFT
    GM=Giro - Manual
    LC=Letter of Credit
    MAN=Manual Check
    TRW=Treasury Wire
    WIR=Wire Transfer

    Prompt Table: STL_PYMT_MTHD_V

    37 SETTLEMENT_ID Character(5) VARCHAR2(5) NOT NULL A unique key identifier that represents the settlement instructions for a given bank/counterparty and acc

    Prompt Table: STL_INSTRUC_VW3

    38 PYMNT_SELCT_STATUS Character(1) VARCHAR2(1) NOT NULL Payment Selection Status
    C=Closed
    D=Negative Voucher Sum
    E=Externally Paid
    F=Federal Sanctions Error
    I=In Process - EFT
    N=Not Selected for Payment
    O=Financial Sanctions Review
    P=Paid
    R=Requested for Payment
    S=Settlement Payment
    V=Convert Error
    X=Canceled
    Y=Prepaid

    Default Value: X

    39 APPROVAL_FLG_TR Character(1) VARCHAR2(1) NOT NULL An internal work field that indicates that a given treasury transaction has been approved by
    A=Approved
    D=Denied
    N=None Required
    P=Pending Approval

    Default Value: N

    40 APPROV_SUBMITTED Character(1) VARCHAR2(1) NOT NULL An internal work field that indicates whether a treasury deal review and/or confirmation transac

    Y/N Table Edit

    Default Value: N

    41 PYMNT_ID Character(10) VARCHAR2(10) NOT NULL Payment Number
    42 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
    43 BASE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents a transaction amount calculated and stored in the base currency of its associated General Ledger bus
    44 BASE_CURRENCY_BNK Character(3) VARCHAR2(3) NOT NULL The base currency of the subject bank general ledger business unit.
    45 BNK_RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL An internal convention utilized for determining whether a currency exchange spot rate is store
    46 BNK_RATE_MULT Number(16,8) DECIMAL(15,8) NOT NULL An internal convention utilized for determining whether a currency exchange spot rate is stored either as
    47 CUR_RT_TYPE_BNK Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
    48 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency
    49 PAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount
    50 PAID_AMT_BNK_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount - Base Bank Unit
    51 BSE_RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Base Rate Divisor for Exchange Rates
    52 BSE_RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Base Rate Multiplier for Exchange Rates
    53 PAID_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Paid Amount
    54 PYMNT_RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL An internal convention utilized for determining whether a currency exchange rate is store
    55 PYMNT_RATE_MULT Number(16,8) DECIMAL(15,8) NOT NULL An internal convention utilized for determining whether a currency exchange rate is stored
    56 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle
    57 PAY_CYCLE_SEQ_NUM Number(6,0) INTEGER NOT NULL Pay Cycle Sequence Number
    58 BANK_STMT_DT Date(10) DATE "The bank statement date
    59 RECON_RUN_ID Character(15) VARCHAR2(15) NOT NULL Recon Run ID
    60 BANK_ACCT_RVL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Field used to store the amount on a transaction revalued in the base currency of the transactions bank account.
    61 STL_THROUGH Character(2) VARCHAR2(2) NOT NULL Settle through
    01=Financial Gateway
    02=Pay Cycle
    62 EVENT_TRACKING_ID Number(10,0) DECIMAL(10) NOT NULL The event tracking ID is used in order to correlate objects with an event. Each object (i.e. Payment) will store the tracking ID with a given payment. That way the system can obtain all the events for a given payment via the tracking ID.
    63 REPETITVE_TRNFR_CD Character(15) VARCHAR2(15) NOT NULL Repetitive Transfer Code assigned by customers Bank
    64 DRAWDOWN_FLG Character(1) VARCHAR2(1) NOT NULL Drawdown Transfer Flag, either yes or no.
    N=No
    Y=Yes
    65 PMT_ID Character(15) VARCHAR2(15) NOT NULL Payment id
    66 PMT_STATUS Character(2) VARCHAR2(2) NOT NULL Payment status
    C=Canceled
    CM=Cancelled with Message
    E=Error
    H=Flagged for Hold
    L=Awaiting Dispatch
    N=Not Processed
    P=Paid
    PC=Pending Cancellation
    PR=Pending Reversal
    R=Received by Bank
    RM=Reversed with Message
    S=Dispatched to Bank
    SC=In Process
    67 FORMAT_ID Character(10) VARCHAR2(10) NOT NULL Format ID

    Prompt Table: TR_FORMAT_VW

    68 TRP_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Pool Business Unit
    69 POOL_ID Character(10) VARCHAR2(10) NOT NULL Pool ID field.
    70 CD Character(30) VARCHAR2(30) NOT NULL Code
    71 PRTRY Character(30) VARCHAR2(30) NOT NULL Proprietary