RECV_ASHD_EC

#	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	ASN_RECEIVED_DT	Date(10)	DATE	ASR Trans Receipt Date
3	ASN_STATUS	Character(1)	VARCHAR2(1) NOT NULL	ASR Processing Status E=Error N=New P=Processed R=Ready V=Validated X=Canceled
4	BUSINESS_UNIT_OM	Character(5)	VARCHAR2(5) NOT NULL	Order Management Business Unit
5	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
6	CARRIER_ID	Character(10)	VARCHAR2(10) NOT NULL	Carrier ID
7	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.
8	DEVICE_ID	Character(10)	VARCHAR2(10) NOT NULL	Device ID
9	DEVICE_DTTIME	DateTime(26)	TIMESTAMP	Device Date Time
10	ECPRIEVTCD	Character(6)	VARCHAR2(6) NOT NULL	Electronic Commerce Primary Event Codes (or Purpose codes) - specify the status of the transaction. New, Cancellation, duplicate, etc. Every transaction has a primary code assigned to it. Used in EDI Manager.
11	ECSECEVTCD	Character(10)	VARCHAR2(10) NOT NULL	Electronic Commerce Secondary Event Codes (or transaction codes) - specify the type of transaction in detail. Used in EDI Manager. This could indicate a rush order, catalog order, or request for a sample. Not all transaction types include secondary codes.
12	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
13	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
14	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code
15	SHIPMENT_NO	Character(30)	VARCHAR2(30) NOT NULL	Shipment Number
16	SHIPTO_SETID	Character(5)	VARCHAR2(5) NOT NULL	ShipTo SetID
17	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location
18	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
19	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
20	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location Prompt Table: VNDR_LOC_ORD_VW
21	VNDR_UPN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Vendor Universal Product Number Ready Flag
22	STD_ID_NUM_VNDR	Character(20)	VARCHAR2(20) NOT NULL	Vendor ID Number
23	STD_ID_NUM_SHIPTO	Character(20)	VARCHAR2(20) NOT NULL	Ship To GLN