RECIPIENT

(SQL Table)
 Index Back

Receiver Account Table

Receiver Account Table

  • Parent Record Of GPAU_RCP_PYENT GPNZ_RCPPYE GPNZ_RCPPYE_HD GPNZ_RECIPIENT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RECIPIENT_ID Character(8) VARCHAR2(8) NOT NULL Payment recipient ID
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 RECIPIENT_CATEGORY Character(1) VARCHAR2(1) NOT NULL Recipient Category
    G=General
    I=Individual

    Default Value: G

    5 PAYMENT_MTHD Character(1) VARCHAR2(1) NOT NULL Payment Method
    A=Cash
    C=Check
    O=Pay Primary Account Only
    P=Postal Order
    T=Bank Transfer
    U=Use Normal Distribution
    W=Wire Transfer
    6 COUNTRY_CD Character(3) VARCHAR2(3) NOT NULL Country Code

    Default Value: OPR_DEF_TBL_HR.COUNTRY

    Prompt Table: COUNTRY_TBL

    7 BANK_CD Character(11) VARCHAR2(11) NOT NULL Bank ID

    Prompt Table: BANK_EC_TBL

    8 BRANCH_EC_CD Character(17) VARCHAR2(17) NOT NULL Bank Branch ID

    Prompt Table: %GP_EDIT_FLD1

    9 ACCOUNT_EC_ID Character(35) VARCHAR2(35) NOT NULL Account Number used in banking.
    10 CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL Check Digit
    11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: COUNTRY_CUR_TBL.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    12 ACCOUNT_NAME Character(50) VARCHAR2(50) NOT NULL Account Name
    13 INTL_BANK_ACCT_NBR Character(34) VARCHAR2(34) NOT NULL IBAN International Bank Account Number
    14 ROLL_NAME Character(50) VARCHAR2(50) NOT NULL Roll Name
    15 ROLL_NUMBER Character(20) VARCHAR2(20) NOT NULL Roll Number
    16 IAT_IND Character(1) VARCHAR2(1) NOT NULL International ACH Transaction Bank (or IAT) Indicator

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: SCC_CNT_ADFMTVW

    18 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    19 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    20 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    21 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    22 CITY Character(30) VARCHAR2(30) NOT NULL City
    23 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    24 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    25 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    26 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    27 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    28 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    29 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    30 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    31 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    32 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    33 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    34 DEP_SCHED_ID Character(10) VARCHAR2(10) NOT NULL Deposit Schedule

    Prompt Table: DEP_SCHED

    35 PURPOSE1 Character(35) VARCHAR2(35) NOT NULL Purpose 1
    36 PURPOSE2 Character(35) VARCHAR2(35) NOT NULL Purpose 2