LATE_MSG_ORG_VW

(SQL View)
 Index Back

Late Fees Msg View (Ext Org)


select distinct a.business_unit, a.batch_id, a.ext_org_id from PS_LATE_FEE_ORG_ID a, ps_late_fee_orgmsg b where a.business_unit = b.business_unit and a.batch_id = b.batch_id and a.ext_org_id = b.ext_org_id

  • Parent record: CANC_MSG_BAT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 BATCH_ID Character(12) VARCHAR2(12) NOT NULL Batch ID
    3 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID