SSF_PMTCH_ALLOC

(SQL Table)
Index Back

Payment Split

  • Parent record: PAYMENT_TBL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT

    Prompt Table: SP_BU_SF_NONVW

    2 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
    3 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
    O=Organization
    P=Person
    4 PAYMENT_ID_NBR Number(12,0) DECIMAL(12) NOT NULL Payment ID Nbr
    5 ITEM_NBR Character(15) VARCHAR2(15) NOT NULL Item Nbr

    Prompt Table: SSF_ITCHRG_VW

    6 PAYOUT_AMT Number(17,2) DECIMAL(16,2) NOT NULL New Allocation
    7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: PAYMENT_TBL.CURRENCY_CD

    8 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    9 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    10 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    11 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time