ORIGIN_AP_AR_LG

(SQL View)
 Index Back

Refund AP Origin Definition


SELECT DISTINCT B.BUSINESS_UNIT_AP , A.ORIGIN , A.LANGUAGE_CD , A.DESCRSHORT FROM PS_ORIGIN_PO_V1_LN 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 for ORIGIN_AP_AR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit
    2 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description