SCR_BNK_ORG_VW

(SQL View)
 Index Back

Supplier Bank Accounts

View of Supplier Bank Accounts for Supplier Request for Change

SELECT A.SETID , A.VENDOR_ID , A.VNDR_LOC , A.BANK_ACCT_SEQ_NBR , A.EFFDT , A.DESCR , A.DEFAULT_IND , %subrec(BANK_ACCT_SBR, A) FROM PS_VNDR_BANK_ACCT A , PS_SCR_LOC_SCRL_VW B WHERE A.SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.VNDR_LOC = B.VNDR_LOC AND A.EFFDT = B.EFFDT

  • Parent record: SCR_LOC_SCRL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    3 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    4 BANK_ACCT_SEQ_NBR Number(3,0) SMALLINT NOT NULL Bank Account Sequence Number

    Default Value: 1

    5 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DEFAULT_IND Character(1) VARCHAR2(1) NOT NULL Default Election
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: Y

    8 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    9 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    10 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    11 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    12 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    13 CITY Character(30) VARCHAR2(30) NOT NULL City
    14 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    15 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    16 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat
    WW=Trailer
    17 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    18 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    19 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    20 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    21 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: %EDIT_STATE

    22 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    23 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    24 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    25 BANK_ID_QUAL Character(3) VARCHAR2(3) NOT NULL "A bank/counterparty attribute that determines

    Prompt Table: BNK_ID_QUAL_VW

    26 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
    27 BRANCH_ID Character(10) VARCHAR2(10) NOT NULL The local branch office identifier associated with a given bank/counterparty.
    28 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
    29 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
    30 CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL Check Digit
    31 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
    32 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
    33 BENEFICIARY_BANK Character(30) VARCHAR2(30) NOT NULL The bank/counterparty associated with a given beneficiary.
    34 BENEFICIARY_BNK_AC Character(30) VARCHAR2(30) NOT NULL Alternate Character Set field for BENEFICIARY_BANK
    35 BENEF_BRANCH Character(30) VARCHAR2(30) NOT NULL Beneficiary Branch field
    36 BENEF_BRANCH_AC Character(30) VARCHAR2(30) NOT NULL Branch Alternate Char
    37 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix
    38 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    39 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone Extension
    40 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
    41 IBAN_CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL IBAN Check Digit
    42 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