RECV_AOLS_TMP

(SQL Table)
Index Back

ASN In Order Lot/Serial

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
3 ASN_SEQ_NBR Number(9,0) DECIMAL(9) NOT NULL ASR Key sequence number
4 ASN_SCHED_NBR Number(9,0) DECIMAL(9) NOT NULL ASR Schedule Sequence Number
5 ASN_LOT_NBR Number(9,0) DECIMAL(9) NOT NULL ASN Lot/Serial Sequence Number
6 SHIPMENT_NO Character(30) VARCHAR2(30) NOT NULL Shipment Number
7 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
8 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
9 ASN_INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL ASR Item ID
10 SCHED_LINE_NO Number(7,2) DECIMAL(6,2) NOT NULL Sched Line NO
11 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
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 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
15 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
16 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
17 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
18 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
19 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
20 VENDOR_LOT_ID Character(15) VARCHAR2(15) NOT NULL Vendor Lot
21 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label
22 USER_RECV_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
23 CUSTOM_C100_E1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
24 CUSTOM_C100_E2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
25 CUSTOM_C100_E3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
26 CUSTOM_C100_E4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
27 CUSTOM_DATE_E Date(10) DATE Custom Date
28 CUSTOM_C1_E Character(1) VARCHAR2(1) NOT NULL Custom Character 2