VENDOR_SETIDVENDOR_IDVNDR_LOCITM_SETIDINV_ITEM_IDSHIPTO_SETIDSHIPTO_IDEFFDTVNDR_ITM_SHP_VW(SQL View) |
Index Back |
|---|---|
Valid Ship To for Item Supplie |
| select A.VENDOR_SETID, A.VENDOR_ID, A.VNDR_LOC, A.SETID, A.INV_ITEM_ID, A.SHIPTO_SETID, A.SHIPTO_ID, B.EFFDT, B.DESCR from PS_ITM_SHIPTO_VNDR A, PS_SHIPTO_TBL B where A.SHIPTO_SETID = B.SETID and A.SHIPTO_ID = B.SHIPTO_ID AND B.EFF_STATUS = 'A' AND B.EFFDT = (SELECT max(C.EFFDT) from PS_SHIPTO_TBL C where B.SETID = C.SETID AND B.SHIPTO_ID = C.SHIPTO_ID AND B.EFFDT = C.EFFDT AND B.EFF_STATUS = C.EFF_STATUS AND C.EFF_STATUS = 'A' AND C.EFFDT <=%currentdatein) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | VNDR_LOC |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 4 | ITM_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
| 5 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 6 | SHIPTO_SETID |
Character(5) | VARCHAR2(5) NOT NULL | ShipTo SetID |
| 7 | SHIPTO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Ship To Location |
| 8 | EFFDT |
Date(10) | DATE | Effective Date |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |