WV_PE_ASNLST_VW(SQL View) |
Index Back |
|---|---|
Supplier Portal: Recent ASN's |
| SELECT DISTINCT A.EIP_CTL_ID , A.VENDOR_SETID , A.VENDOR_ID , C.SHIPMENT_NO , C.SHIP_DATE , ' ' , B.EIP_SOURCE FROM PS_RECV_ASHD_EC A , PS_EO_EIP_CTL B , PS_RECV_AOHD_EC C WHERE A.EIP_CTL_ID = B.EIP_CTL_ID AND A.EIP_CTL_ID = C.EIP_CTL_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EIP_CTL_ID | Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |
| 2 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 3 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 4 | SHIPMENT_NO | Character(30) | VARCHAR2(30) NOT NULL | Shipment Number |
| 5 | SHIP_DATE | Date(10) | DATE | Item Shipping Date |
| 6 | WV_PE_EIP_SOURCE | Character(3) | VARCHAR2(3) NOT NULL | EIP Source |
| 7 | EIP_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
EIP Source
1=Msg Agent 2=Online 3=Batch 4=Auto Gen 5=Message |