PO_ASN_AOLN_EVW

(SQL View)
 Index Back

ASN In Order Line View

ASN In Order Line View

SELECT ASN_SEQ_NBR , ASN_SCHED_NBR , CONTAINER_ID , SHIPMENT_NO , ORDER_NO , ORDER_INT_LINE_NO , SCHED_LINE_NO , CAST ((SCHED_LINE_NO * 100) AS DECIMAL(6,0)) , ASN_INV_ITEM_ID , DEMAND_LINE_NO , ASN_DESCR , QTY_SHIPPED_CONV , UNIT_MEASURE_SHIP , CUSTOMER_ITEM_NBR , PARENT_PROD_ID , PARENT_PROD_DESCR , QTY_PER , QTY_CODE , BUSINESS_UNIT_PO , PO_ID , LINE_NBR , SCHED_NBR , BILL_OF_LADING , PROCESS_INSTANCE , ASN_DEFAULT_KEY , ASN_STATUS , MESSAGE_NBR , BUSINESS_UNIT_RECV , CONVERSION_RATE , CURRENCY_CD , ERS_ACTION , INV_ITEM_ID , DESCR254_MIXED , ITM_SETID , LOT_CONTROL , RECEIVER_ID , RECV_LN_NBR , RECV_SHIP_SEQ_NBR , SERIAL_CONTROL , SHIPTO_ID , SHIPTO_SETID , UNIT_MEASURE_STD , UNIT_OF_MEASURE , VENDOR_ID , VENDOR_SETID , REV_OVERRIDE , REVISION , PRO_NUMBER , CONTRACT_ID , INVOICE_ID , UPN_ID , STD_ID_NUM_VNDR , STD_ID_NUM_SHIPTO FROM PS_RECV_AOLN_EC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ASN_SEQ_NBR Number(9,0) DECIMAL(9) NOT NULL ASR Key sequence number
2 ASN_SCHED_NBR Number(9,0) DECIMAL(9) NOT NULL ASR Schedule Sequence Number
3 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID
4 SHIPMENT_NO Character(30) VARCHAR2(30) NOT NULL Shipment Number
5 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
6 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
7 SCHED_LINE_NO Number(7,2) DECIMAL(6,2) NOT NULL Sched Line NO
8 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
9 ASN_INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL ASR Item ID
10 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
11 ASN_DESCR Character(30) VARCHAR2(30) NOT NULL ASR Item Description
12 QTY_SHIPPED_CONV Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
13 UNIT_MEASURE_SHIP Character(3) VARCHAR2(3) NOT NULL Shipment Unit of Measure
14 CUSTOMER_ITEM_NBR Character(18) VARCHAR2(18) NOT NULL Customer Item Number
15 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id
16 PARENT_PROD_DESCR Character(30) VARCHAR2(30) NOT NULL Parent Product Description
17 QTY_PER Number(10,4) DECIMAL(9,4) NOT NULL Quantity
18 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order
19 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
20 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
21 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
22 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
23 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
24 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
25 ASN_DEFAULT_KEY Character(1) VARCHAR2(1) NOT NULL ASR Default Key
26 ASN_STATUS Character(1) VARCHAR2(1) NOT NULL ASR Processing Status
E=Error
N=New
P=Processed
R=Ready
V=Validated
X=Canceled
27 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
28 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
29 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
30 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
31 ERS_ACTION Character(1) VARCHAR2(1) NOT NULL ERS Action
N=No
Y=Yes
32 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
33 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
34 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
35 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
N=N
Y=Y
36 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
37 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
38 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
39 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
N=N
Y=Y
40 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
41 SHIPTO_SETID Character(5) VARCHAR2(5) NOT NULL ShipTo SetID
42 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
43 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
44 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
45 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
46 REV_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Allow Revision to be overridden

Default Value: N

47 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label
48 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number
49 CONTRACT_ID Character(10) VARCHAR2(10) NOT NULL Vendor Contract ID
50 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
51 UPN_ID Character(20) VARCHAR2(20) NOT NULL Universal Product Number
52 STD_ID_NUM_VNDR Character(20) VARCHAR2(20) NOT NULL Vendor ID Number
53 STD_ID_NUM_SHIPTO Character(20) VARCHAR2(20) NOT NULL Ship To GLN