BANK_ACCT_ALL_V

(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.ACCT_STATUS , A.DESCR , A.DESCRSHORT , A.BRANCH_NAME , 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.DRAFT_CNTL_AR_FLG , A.DIT_USE_FLG , C.BRANCH_ID , 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 , A.SCHEDULE , A.INTEREST_SW ,%subrec(ADDRESS_SBR,C) ,A.IBAN_CHECK_DIGIT ,A.IBAN_ID , A.PYCYCL_PAY_LIMIT , A.PYCYCL_PAY_LMTCURR , A.SINGLE_PAY_LIMIT , A.SINGLE_PAY_LMTCURR , A.IPAC_SENDER_DO , A.GP FROM PS_BANK_ACCT_DEFN A , PS_BANK_ACCT_CPTY B , PS_BANK_BRANCH_TBL C 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.SETID = C.SETID AND A.BANK_CD = C.BANK_CD AND A.BRANCH_NAME = C.BRANCH_NAME

  • Related Language Record: BANK_ACCT_LN_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_TBL

    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 ACCT_STATUS Character(1) VARCHAR2(1) NOT NULL Account Status - Active/Inactive
    A=Active
    I=Inactive
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    8 BRANCH_NAME Character(10) VARCHAR2(10) NOT NULL Branch Name
    9 PYMNT_HANDLING_CD Character(2) VARCHAR2(2) NOT NULL Payment Handling

    Prompt Table: %EDITTABLE4

    10 PYMNT_OVRD_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Handling Override Amt
    11 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
    12 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

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

    Default Value: USD

    Prompt Table: CURRENCY_CD_TBL

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

    Prompt Table: CUR_RT_TYPE_TBL

    15 RATE_INDEX Character(10) VARCHAR2(10) NOT NULL Rate index
    16 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

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

    Prompt Table: BU_GL_UPDATE_VW

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

    Default Value: 6

    20 FRACT_RTG_NUM Character(20) VARCHAR2(20) NOT NULL Federal Reserve bank routing number used for funds transfer.
    21 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
    22 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

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

    Prompt Table: %EDITTABLE6

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

    Prompt Table: GL_ACCT_BUGL_VW

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

    Prompt Table: GL_ACCT_BUGL_VW

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

    Prompt Table: GL_ACCT_BUGL_VW

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

    Prompt Table: GL_ACCT_BUGL_VW

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    34 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
    35 DEPOSIT_TYPE Character(1) VARCHAR2(1) NOT NULL Deposit Type
    A=Amount
    B=Balance of Net Pay
    P=Percent

    Prompt Table: %EDITTABLE2

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

    Y/N Table Edit

    Default Value: N

    37 TARGET_BALANCE Signed Number(28,3) DECIMAL(26,3) NOT NULL The target bank account balance assigned to a given bank account.
    38 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

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

    Y/N Table Edit

    Default Value: N

    40 DRAFT_CNTL_USE_FLG Character(1) VARCHAR2(1) NOT NULL Drafts Payable
    41 DRAFT_CNTL_AR_FLG Character(1) VARCHAR2(1) NOT NULL AR Draft Cash Control
    42 DIT_USE_FLG Character(1) VARCHAR2(1) NOT NULL Deposit in Transit field for JFMIP functionality

    Y/N Table Edit

    Default Value: N

    43 BRANCH_ID Character(10) VARCHAR2(10) NOT NULL The local branch office identifier associated with a given bank/counterparty.
    44 CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL Check Digit
    45 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
    46 MARGIN_PTS Number(4,0) SMALLINT NOT NULL Margin (Pts)
    47 CREATION_DT Date(10) DATE Creation Date

    Default Value: %date

    48 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
    49 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update
    50 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.

    Prompt Table: BU_AR_ALT

    51 CHRG_BANK_CD Character(5) VARCHAR2(5) NOT NULL Charge Bank
    52 CHRG_BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL Charge Account
    53 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
    54 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
    55 BANK_ACCT_QUAL Character(1) VARCHAR2(1) NOT NULL "An account attribute that determines
    C=Corporate Account
    56 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
    57 PAYER_ID_NUM Character(10) VARCHAR2(10) NOT NULL Remitter ID Number
    58 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
    59 CREDIT_RATE Number(7,3) DECIMAL(6,3) NOT NULL Represents the credit-specific interest rate applicable to an internal current account.
    60 DEBIT_RATE Number(7,3) DECIMAL(6,3) NOT NULL Represents the debit-specific interest rate applicable to an internal current account.
    61 SCHEDULE Character(10) VARCHAR2(10) NOT NULL Schedule ID
    62 INTEREST_SW Character(1) VARCHAR2(1) NOT NULL Accrue Interest
    63 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    64 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    65 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    66 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    67 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    68 CITY Character(30) VARCHAR2(30) NOT NULL City
    69 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    70 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    71 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat
    WW=Trailer
    72 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    73 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    74 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    75 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    76 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: %EDIT_STATE

    77 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    78 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    79 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    80 IBAN_CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL IBAN Check Digit
    81 IBAN_ID Character(34) VARCHAR2(34) NOT NULL IBAN - Internation Bank Account Number is used in European countries to uniquely identify Bank accounts across borders
    82 PYCYCL_PAY_LIMIT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of a direct debit in its entry currency (DD_CURRENCY). This field is maintained by the Direct debit generation process.
    83 PYCYCL_PAY_LMTCURR Character(3) VARCHAR2(3) NOT NULL Currency Code
    84 SINGLE_PAY_LIMIT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of a direct debit in its entry currency (DD_CURRENCY). This field is maintained by the Direct debit generation process.
    85 SINGLE_PAY_LMTCURR Character(3) VARCHAR2(3) NOT NULL Currency Code
    86 IPAC_SENDER_DO Character(5) VARCHAR2(5) NOT NULL Sender Disbursing Office
    87 GP Character(1) VARCHAR2(1) NOT NULL Global Payroll Source