EM_SP_OUTBAL_LN

(SQL View)
 Index Back

Customer Outstanding Bal Lang

Seller Bill Presentement / Customer Outstanding Balance language view

SELECT V.BUSINESS_UNIT , SEC.OPRID , BUL.LANGUAGE_CD , BUL.DESCRSHORT FROM PS_VOUCHER V , PS_PYMNT_VCHR_XREF P , PS_VENDOR_USER SEC , PS_BUS_UNIT_TBL_FS BU , PS_BUS_UNIT_LANG BUL WHERE SEC.SETID = V.VENDOR_SETID AND SEC.VENDOR_ID = V.VENDOR_ID AND V.VOUCHER_STYLE <> 'PPAY' AND V.ENTRY_STATUS <> 'X' AND (V.PROCESS_MAN_CLOSE = 'N' OR V.CLOSE_STATUS <> 'C') AND V.BUSINESS_UNIT = P.BUSINESS_UNIT AND V.VOUCHER_ID = P.VOUCHER_ID AND P.PYMNT_SELCT_STATUS NOT IN ('P','X','E') AND P.PYMNT_TYPE <> 'W' AND P.DUE_DT IS NOT NULL AND V.BUSINESS_UNIT = BU.BUSINESS_UNIT AND BUL.BUSINESS_UNIT = BU.BUSINESS_UNIT

  • Related Language Record for EM_SP_OUTBAL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 EM_BU_NAME_SHORT Character(10) VARCHAR2(10) NOT NULL Buyer Short Name