REPORT_ENTITYPRCR_YEARPRCR_PERIODITM_SETIDINV_ITEM_IDCATEGORY_IDVENDOR_SETIDVENDOR_IDBUSINESS_UNITSHIPTO_SETIDSHIPTO_IDCURRENCY_CDUNIT_MEASURE_STDUNIT_MEASURE_WTLANGUAGE_CDPO_ONTIME_L_VW(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 , OL.OPRDEFNDESC ,L.VENDOR_NAME_SHORT ,L.NAME1 FROM PS_PRCR_ITEM_HST A , PS_VENDOR_LANG L , PSOPRDEFN_LANG OL WHERE A.VENDOR_SETID = L.SETID AND A.VENDOR_ID = L.VENDOR_ID AND OL.OPRID = A.BUYER_ID |
| # | 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 |
Character(5) | VARCHAR2(5) NOT NULL | 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 | BUYER_NAME | Character(30) | VARCHAR2(30) NOT NULL | Buyer Desc |
| 17 | VENDOR_NAME_SHORT | Character(14) | VARCHAR2(14) NOT NULL | Short Vendor Name |
| 18 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |