EM_DISP_LINE_VW

(SQL View)
 Index Back

eS Invoice Line Disputes

Used for line level disputes of invoices.

SELECT D.BUSINESS_UNIT , D.VOUCHER_ID , D.VOUCHER_LINE_NUM , D.DISTRIB_LINE_NUM , D.OPRID , NM.NAME1 , D.SEQ_NBR_3 , bu.descrshort , V.INVOICE_ID , S.VENDOR_NAME_SHORT , D.DTTM_STAMP , D.DESCRLONG FROM PS_EM_DISPUTE_LINE D , PS_VOUCHER V , PS_VENDOR S , ps_bus_unit_tbl_fs bu , PS_OPR_DEF_TBL_FS NM WHERE D.BUSINESS_UNIT=V.BUSINESS_UNIT AND V.BUSINESS_UNIT = BU.BUSINESS_UNIT AND D.VOUCHER_ID = V.VOUCHER_ID AND V.VENDOR_ID = S.VENDOR_ID AND V.VENDOR_SETID = S.SETID AND NM.OPRID = D.OPRID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
3 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
4 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
6 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
7 SEQ_NBR_3 Number(3,0) SMALLINT NOT NULL Sequence
8 EM_BU_NAME_SHORT Character(10) VARCHAR2(10) NOT NULL Buyer Name
9 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
10 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
11 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
12 DESCRLONG Long Character CLOB Long Description