PRCR_HST_A_VWLN

(SQL View)
 Index Back

Procurement History Item View


SELECT A.REPORT_ENTITY ,A.PRCR_YEAR ,A.PRCR_PERIOD ,A.ITM_SETID ,A.INV_ITEM_ID ,A.CATEGORY_ID ,A.VENDOR_SETID ,A.VENDOR_ID ,A.BUSINESS_UNIT_PO ,A.SHIPTO_SETID ,A.SHIPTO_ID ,A.CURRENCY_CD ,A.UNIT_MEASURE_STD ,A.UNIT_MEASURE_WT ,L.LANGUAGE_CD ,V.VENDOR_NAME_SHORT ,L.NAME1 FROM PS_PRCR_ITEM_HST A , PS_VENDOR V , PS_VENDOR_LANG L WHERE A.VENDOR_SETID = V.SETID AND V.SETID =L.SETID AND A.VENDOR_ID = V.VENDOR_ID AND V.VENDOR_ID = L.VENDOR_ID

  • Related Language Record for PRCR_HST_AAA_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REPORT_ENTITY Character(5) VARCHAR2(5) NOT NULL Reporting Entity ID
    2 PRCR_YEAR Number(4,0) SMALLINT NOT NULL Procurement Year
    3 PRCR_PERIOD Number(3,0) SMALLINT NOT NULL Procurement Period
    4 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
    5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    6 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
    7 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    8 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    9 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
    10 SHIPTO_SETID Character(5) VARCHAR2(5) NOT NULL ShipTo SetID
    11 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
    12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    13 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
    14 UNIT_MEASURE_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM
    15 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    16 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    17 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1