BANK_ACCT_AP_VW

(SQL View)
 Index Back

Bank Accounts

View over the BANK_ACCT_DEFN table for bank accounts

SELECT A.SETID , B.COUNTERPARTY , A.BANK_ACCT_KEY , A.BANK_ACCOUNT_NUM , A.DESCR , A.DESCRSHORT , A.PYMNT_HANDLING_CD , A.PYMNT_OVRD_AMT , A.RECON_TYPE_FLG , A.RECON_HEADER , A.CURRENCY_CD , A.CUR_RT_TYPE , A.RATE_INDEX , A.SETTLEMENT_ID , B.BUSINESS_UNIT_GL , A.LAST_PYMNT_ID_USED , A.PYMNT_ID_REF_LEN , A.FRACT_RTG_NUM , A.DFI_ID_NUM , A.DFI_ID_QUAL , A.NPL_BNK_CHRT_VALUE , A.IU_PYBL_NPL_ACCT , A.IU_RCVBL_NPL_ACCT , A.CSH_PL_CLRG_ACCT , A.CSH_PL_ACCT , A.PL_BNK_ACCT_FLG , A.AR , A.AP , A.TR , A.BI , A.PP_SW , A.ENABLE_WF_SW , A.DEPOSIT_TYPE , A.FORECAST , A.TARGET_BALANCE , A.PRE_RECONCILE , A.CASH_CNTL_USE_FLG , A.DRAFT_CNTL_USE_FLG , A.CHECK_DIGIT , A.INT_BASIS , A.MARGIN_PTS , A.CREATION_DT , A.OPRID_ENTERED_BY , A.OPRID_LAST_UPDT , A.DEPOSIT_BU , A.CHRG_BANK_CD , A.CHRG_BANK_ACCT_KEY , A.RCN_ACCTG_SW , A.DEFAULT_ACCT_SW , A.BANK_ACCT_QUAL , A.PREFERRED_LANGUAGE , A.PAYER_ID_NUM , A.BANK_ACCT_TYPE , A.CREDIT_RATE , A.DEBIT_RATE FROM PS_BANK_ACCT_DEFN A , PS_BANK_ACCT_CPTY B WHERE A.SETID = B.SETID AND A.BANK_CD = B.BANK_CD AND A.BANK_CD_CPTY = B.BANK_CD_CPTY AND A.BANK_ACCT_KEY = B.BANK_ACCT_KEY AND A.AP = 'Y'

  • Related Language Record: BANK_ACCT_LG_VW

  • Parent record: BANK_CD_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

    Prompt Table: BANK_CD_INT_VW

    3 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
    4 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 PYMNT_HANDLING_CD Character(2) VARCHAR2(2) NOT NULL Payment Handling

    Prompt Table: %EDITTABLE4

    8 PYMNT_OVRD_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Handling Override Amt
    9 RECON_TYPE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates which method has been utilized to reconcile a given source system transaction.
    A=Automatic
    M=Manual
    N=None
    S=Semi Manual
    10 RECON_HEADER Character(1) VARCHAR2(1) NOT NULL An internal work field that indicates that the account balance has been submitted with the bank statement.

    Y/N Table Edit

    Default Value: N

    11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: USD

    Prompt Table: CURRENCY_CD_TBL

    12 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type

    Prompt Table: CUR_RT_TYPE_TBL

    13 RATE_INDEX Character(10) VARCHAR2(10) NOT NULL Rate index
    14 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_INSTRUCT_VW

    15 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

    Prompt Table: BU_GL_UPDATE_VW

    16 LAST_PYMNT_ID_USED Number(10,0) DECIMAL(10) NOT NULL Last Payment Id
    17 PYMNT_ID_REF_LEN Number(3,0) SMALLINT NOT NULL Check # Length

    Default Value: 6

    18 FRACT_RTG_NUM Character(20) VARCHAR2(20) NOT NULL Federal Reserve bank routing number used for funds transfer.
    19 DFI_ID_NUM Character(12) VARCHAR2(12) NOT NULL A banking industry convention identifier utilized to drive electronic settlements processing for a given bank/coun
    20 DFI_ID_QUAL Character(2) VARCHAR2(2) NOT NULL A banking industry convention identifier utilized to drive data validation for a given bank/counterparty.
    01=Transit Number
    02=Swift ID/BIC
    03=CHIPS Participant ID
    04=Canadian Bank Branch/Institute
    05=CHIPS Universal ID
    ZZ=Mutually Defined

    Default Value: 01

    21 NPL_BNK_CHRT_VALUE Character(15) VARCHAR2(15) NOT NULL Bank Chartfield Value

    Prompt Table: %EDITTABLE6

    22 IU_PYBL_NPL_ACCT Character(10) VARCHAR2(10) NOT NULL InterFund Payable Nonpooled

    Prompt Table: GL_ACCT_BUGL_VW

    23 IU_RCVBL_NPL_ACCT Character(10) VARCHAR2(10) NOT NULL InterFund Receivable Nonpooled

    Prompt Table: GL_ACCT_BUGL_VW

    24 CSH_PL_CLRG_ACCT Character(10) VARCHAR2(10) NOT NULL Cash Pooled Clearing Account

    Prompt Table: GL_ACCT_BUGL_VW

    25 CSH_PL_ACCT Character(10) VARCHAR2(10) NOT NULL Cash Pooled Account

    Prompt Table: GL_ACCT_BUGL_VW

    26 PL_BNK_ACCT_FLG Character(1) VARCHAR2(1) NOT NULL Pooled Bank Account

    Y/N Table Edit

    Default Value: N

    27 AR Character(1) VARCHAR2(1) NOT NULL Receivables

    Y/N Table Edit

    Default Value: N

    28 AP Character(1) VARCHAR2(1) NOT NULL Payables

    Y/N Table Edit

    Default Value: N

    29 TR Character(1) VARCHAR2(1) NOT NULL Treasury

    Y/N Table Edit

    Default Value: N

    30 BI Character(1) VARCHAR2(1) NOT NULL Billing

    Y/N Table Edit

    Default Value: N

    31 PP_SW Character(1) VARCHAR2(1) NOT NULL Payment Predictor

    Y/N Table Edit

    Default Value: N

    32 ENABLE_WF_SW Character(1) VARCHAR2(1) NOT NULL Allows a user to enable workflow worklist processing for automated reconciliation purposes. Th
    F=Nofitication Framework
    N=No Workflow
    Y=Workflow
    33 DEPOSIT_TYPE Character(1) VARCHAR2(1) NOT NULL Deposit Type
    A=Amount
    B=Balance of Net Pay
    P=Percent

    Prompt Table: %EDITTABLE2

    34 FORECAST Character(1) VARCHAR2(1) NOT NULL Include in Cash Forecast

    Y/N Table Edit

    Default Value: N

    35 TARGET_BALANCE Signed Number(28,3) DECIMAL(26,3) NOT NULL The target bank account balance assigned to a given bank account.
    36 PRE_RECONCILE Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate whether the automated reconciliation process should apply a n

    Y/N Table Edit

    Default Value: N

    37 CASH_CNTL_USE_FLG Character(1) VARCHAR2(1) NOT NULL Cash Clearing

    Y/N Table Edit

    Default Value: N

    38 DRAFT_CNTL_USE_FLG Character(1) VARCHAR2(1) NOT NULL Drafts Payable
    39 CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL Check Digit
    40 INT_BASIS Character(2) VARCHAR2(2) NOT NULL Day Count Basis
    30=30/360
    3E=30E/360
    A0=Actual/360
    A5=Actual/365
    AA=Actual/Actual
    41 MARGIN_PTS Number(4,0) SMALLINT NOT NULL Margin (Pts)
    42 CREATION_DT Date(10) DATE Creation Date

    Default Value: %date

    43 OPRID_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
    44 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update
    45 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.

    Prompt Table: BU_AR_ALT

    46 CHRG_BANK_CD Character(5) VARCHAR2(5) NOT NULL Charge Bank
    47 CHRG_BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL Charge Account
    48 RCN_ACCTG_SW Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate that the subject bank account's eligible transactions will generate ac
    49 DEFAULT_ACCT_SW Character(1) VARCHAR2(1) NOT NULL Allows the user to designate a specific internal current account as the default account for an inter
    50 BANK_ACCT_QUAL Character(1) VARCHAR2(1) NOT NULL "An account attribute that determines
    C=Corporate Account
    51 PREFERRED_LANGUAGE Character(3) VARCHAR2(3) NOT NULL Preferred Language
    ARA=Arabic
    CFR=Canadian French
    CZE=Czech
    DAN=Danish
    DUT=Dutch
    E=English
    ENG=English
    ESP=Spanish
    F=French
    FIN=Finnish
    FRA=French
    GER=German
    HUN=Hungarian
    INE=International English
    ITA=Italian
    JPN=Japanese
    KOR=Korean
    NOR=Norwegian
    POL=Polish
    POR=Portuguese
    RUS=Russian
    SVE=Swedish
    THA=Thai
    UKE=UK English
    ZHS=Simplified Chinese
    ZHT=Traditional Chinese
    52 PAYER_ID_NUM Character(10) VARCHAR2(10) NOT NULL Remitter ID Number
    53 BANK_ACCT_TYPE Character(2) VARCHAR2(2) NOT NULL An account attribute that describes the ostensible purposes of a given bank/counterparty account.
    01=Time Deposit
    03=Checking Account
    05=Stock
    06=Bond
    07=Life Insurance Value
    08=Retirement Account
    10=Business Account
    11=Trust Fund Account
    12=Stock & Bond Account
    13=Life Insurance Acct
    CA=Current Account
    CH=Charges Account
    DA=Demand Deposit
    LN=Loan
    RD=Return Items on DDA
    RS=Return Items-Savings
    SA=Settlement Account
    SV=Savings Account
    Z=Mutually Defined
    54 CREDIT_RATE Number(7,3) DECIMAL(6,3) NOT NULL Represents the credit-specific interest rate applicable to an internal current account.
    55 DEBIT_RATE Number(7,3) DECIMAL(6,3) NOT NULL Represents the debit-specific interest rate applicable to an internal current account.