GPAU_RCP_PYENT

(SQL Table)
 Index Back

Stores Extra Recipient Info

The record is used for recipient country extension information. This record stores commission rates, group numbers and Cemtex file generation processing options.

  • Parent record: RECIPIENT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RECIPIENT_ID Character(8) VARCHAR2(8) NOT NULL Payment recipient ID
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

    Prompt Table: GP_PYENT

    4 GPAU_RCP_COMM_AMT Number(9,2) DECIMAL(8,2) NOT NULL The Commission Amount is the percentage or flatamount deducted from the payments given to a recipient.
    5 GPAU_RCP_COMM_TYPE Character(2) VARCHAR2(2) NOT NULL The commission type determines if a payment amount is reduced when paying a recipient.
    10=Flat Amount
    20=Percentage
    30=None

    Default Value: 30

    6 GPAU_RCP_COMM_OPTN Character(2) VARCHAR2(2) NOT NULL This is used to identify whether to calculate commission amounts or not.
    10=Deduct Commission
    20=Report Only
    30=None

    Default Value: 30

    7 GPAU_RCP_GROUP_ID Character(18) VARCHAR2(18) NOT NULL The Group ID is required for the file generated by GPAU_RCPFILE.