PV_SS_ASNOLN_VW

(SQL View)
 Index Back

Sup Portal: ASN History Vw


SELECT D.BUSINESS_UNIT_REQ , D.REQ_ID , A.BUSINESS_UNIT_PO , A.PO_ID , A.EIP_CTL_ID , A.ASN_SEQ_NBR , A.ASN_SCHED_NBR , A.LINE_NBR , A.SCHED_NBR , A.ORDER_NO , A.ORDER_INT_LINE_NO , A.ASN_STATUS , B.ITM_ID_VNDR , A.INV_ITEM_ID , A.ASN_DESCR , A.DESCR254_MIXED , A.REVISION , A.QTY_SHIPPED_CONV , 0 , A.UNIT_MEASURE_SHIP , A.MESSAGE_NBR , A.SERIAL_CONTROL , A.LOT_CONTROL , ' ' , A.INVOICE_ID , A.PRO_NUMBER , A.BILL_OF_LADING , A.ERS_ACTION FROM PS_PV_REQ_ASN_VW D , PS_RECV_AOLN_EC A , PS_PO_LINE B WHERE D.BUSINESS_UNIT=A.BUSINESS_UNIT_PO AND D.PO_ID = A.PO_ID AND A.BUSINESS_UNIT_PO = B.BUSINESS_UNIT AND A.PO_ID = B.PO_ID AND A.LINE_NBR = B.LINE_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_REQ Character(5) VARCHAR2(5) NOT NULL Requesting Business Unit
2 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
5 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
6 ASN_SEQ_NBR Number(9,0) DECIMAL(9) NOT NULL ASR Key sequence number
7 ASN_SCHED_NBR Number(9,0) DECIMAL(9) NOT NULL ASR Schedule Sequence Number
8 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
9 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
10 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
11 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
12 ASN_STATUS Character(1) VARCHAR2(1) NOT NULL ASR Processing Status
E=Error
N=New
P=Processed
R=Ready
V=Validated
X=Canceled
13 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
14 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
15 ASN_DESCR Character(30) VARCHAR2(30) NOT NULL ASR Item Description
16 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
17 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label
18 QTY_SHIPPED_CONV Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
19 QTY_SHIPPED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
20 UNIT_MEASURE_SHIP Character(3) VARCHAR2(3) NOT NULL Shipment Unit of Measure
21 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
22 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
N=N
Y=Y
23 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
N=N
Y=Y
24 MESSAGE_TEXT Character(100) VARCHAR2(100) NOT NULL Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
25 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
26 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number
27 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
28 ERS_ACTION Character(1) VARCHAR2(1) NOT NULL ERS Action
N=No
Y=Yes