RECV_ASHD_VW

(SQL View)
 Index Back

ASN In Shipment Header


SELECT EIP_CTL_ID , CUST_ID , SHIPMENT_NO , CARRIER_ID , SHIP_TYPE_ID , ASN_STATUS , ASN_RECEIVED_DT , SHIPTO_ID , VENDOR_ID , VNDR_LOC FROM PS_RECV_ASHD_EC WHERE ASN_STATUS <> 'X'

# 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 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
3 SHIPMENT_NO Character(30) VARCHAR2(30) NOT NULL Shipment Number
4 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
5 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
6 ASN_STATUS Character(1) VARCHAR2(1) NOT NULL ASR Processing Status
E=Error
N=New
P=Processed
R=Ready
V=Validated
X=Canceled
7 ASN_RECEIVED_DT Date(10) DATE ASR Trans Receipt Date
8 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
9 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
10 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

Prompt Table: VNDR_LOC_ORD_VW