ORIGIN_AP_AR

(SQL View)
 Index Back

Refund AP Origin Definition


select distinct b.business_unit_ap, a.setid, a.origin, a.descrshort from PS_ORIGIN_AP a, ps_bu_ap_ref b where a.setid = (select setid from ps_set_cntrl_rec where setcntrlvalue = b.business_unit_ap and recname = 'ORIGIN_AP')

  • Related Language Record: ORIGIN_AP_AR_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit
    2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    3 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description