GPNZ_PE_SBANK

(SQL Table)
 Index Back

Source Bank To Org Unit Link

This record allows the normal Source Bank Account to be overridden for a particular type of payment.

  • Parent record: GP_PE_SBANK_DTL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

    Default Value: GP_PE_SBANK_DTL.PAY_ENTITY

    2 ORG_LINK_OPTN Character(2) VARCHAR2(2) NOT NULL Identifies at what org level source banks are assigned. Value set at this time: Company, Dept, Location, Pay Entity, Pay Group
    CO=Company
    DE=Department
    ET=Establishment
    LO=Location
    PG=Pay Group

    Default Value: GP_PE_SBANK_DTL.ORG_LINK_OPTN

    3 EFFDT Date(10) DATE Effective Date

    Default Value: GP_PE_SBANK_DTL.EFFDT

    4 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: GP_PE_SBANK_DTL.SETID

    Prompt Table: %GP_EDIT_FLD2

    5 ORG_LINK_UNIT Character(12) VARCHAR2(12) NOT NULL Contains ID of an org unit to which a source bank is assigned. can be Company, Dept, Location, Pay Group or Pay Entity ID

    Default Value: GP_PE_SBANK_DTL.ORG_LINK_UNIT

    Prompt Table: %GP_EDIT_FLD1

    6 GPNZ_BANK_DB_TYPE Character(2) VARCHAR2(2) NOT NULL This field distinguishes the debit types that a source bank account is to be used for.
    10=Group Tax
    20=Net Payment
    30=Recipient
    7 SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Source Bank ID

    Prompt Table: SRC_BANK