BS_TRNS_PD_EC_C

(SQL Table)
Index Back

BTF:Bank Acct Transaction Line

Bank Account Transaction Line

  • Parent record: BS_BKBAL_PD_EC
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TEST_CASE Character(30) VARCHAR2(30) NOT NULL BTF Test Case
    2 COMPARE_TYPE Character(1) VARCHAR2(1) NOT NULL Compare report type
    1=Delta (Results v.s Expected)
    2=Expected data not in Results
    3=Unexpected data in Results
    3 COMPARE_SOURCE Character(1) VARCHAR2(1) NOT NULL Compare data source (Actuals or Expected results).
    A=Actuals
    E=Expected
    4 STATEMENT_ID Number(10,0) DECIMAL(10) NOT NULL Statement ID for bank statements, key on Bank Statement Header
    5 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
    6 BRANCH_ID Character(10) VARCHAR2(10) NOT NULL The local branch office identifier associated with a given bank/counterparty.
    7 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
    8 RECORD_SEQ_NUMBER Number(10,0) DECIMAL(10) NOT NULL An internal work field utilized to enumerate database records in bank statement processing.
    9 BANK_STMT_CODE Character(8) VARCHAR2(8) NOT NULL Bank Statement code - used to identify the codes used on the bank statement for different entires of balances and transactions.

    Prompt Table: BSP_TXN_CODE_VW

    10 BANK_TRANS_CODE Character(20) VARCHAR2(20) NOT NULL A code that describes the type of transaction submitted by the bank via report or flat file.
    11 RECON_TRANS_CODE Character(3) VARCHAR2(3) NOT NULL The PeopleSoft-specific bank transaction code
    ACH=Automated Clearing House
    B=Direct Debit
    BA=Bank Adjustments
    BOE=Bill of Exchange - Disburse
    BOO=Bill of Order - Disburse
    C=Trade Receipt
    CHK=Check
    D=Deposits
    DD=Direct Debit - Disburse
    EFT=Electronic Funds Transfer
    F=Fee Expense
    G=General Transaction
    I=Interest Expense
    M=Miscellaneous Transaction
    MAN=Manual Check
    P=Payment
    R=Drafts
    S=Stop Pay
    TRW=Treasury Wire
    U=Funding Receipt
    V=Voided Payment
    WIR=Wire - Disbursement
    WRI=Wire - Incoming
    12 BSP_TRAN_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount of the Bank statement Transaction
    13 FUNDS_TYPE Character(1) VARCHAR2(1) NOT NULL Funds Availability Type
    0=Immediate Availability
    1=One-day Availability
    2=Two-or more-day Availability
    D=Distributed Availability-vary
    S=Distributed Availability-fixed
    V=Value Dated
    Z=unknown
    14 IMMEDIATE_BAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Available Balance
    15 FLOAT1 Signed Number(28,3) DECIMAL(26,3) NOT NULL One Day Float Balance
    16 FLOAT2 Signed Number(28,3) DECIMAL(26,3) NOT NULL Two or More Days Float Balance
    17 VALUE_DT Date(10) DATE Equivalent to a deal transaction's settlement date.
    18 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    19 RECON_REF_ID Character(20) VARCHAR2(20) NOT NULL The transaction reference identifier on the inbound bank statement.
    20 BANK_REF_ID Character(16) VARCHAR2(16) NOT NULL A reference identifier associated with a given bank/counterparty transaction.
    21 STMT_ACTIVITY_TYPE Character(5) VARCHAR2(5) NOT NULL Represents a series of values that provide a more granular definition of a given reconcil
    22 LOADED_SW Character(1) VARCHAR2(1) NOT NULL An internal work field that indicates whether a given treasury transaction successfully has been imp

    Default Value: N

    23 BAL_LOADED_SW Character(1) VARCHAR2(1) NOT NULL An internal work field that designates whether a given bank balance has been loaded into the sys

    Default Value: N

    24 DESCRLONG Long Character CLOB Long Description
    25 TRANSACTION_DT Date(10) DATE Transaction date (often used as trade date)