INC6503_VW2

(SQL View)
 Index Back

Shipping Document


SELECT A.BUSINESS_UNIT , A.DEMAND_SOURCE , A.SOURCE_BUS_UNIT , A.ORDER_NO , A.ORDER_INT_LINE_NO , A.SCHED_LINE_NBR , A.INV_ITEM_ID , A.DEMAND_LINE_NO , A.IN_FULFILL_STATE , A.SHIP_CUST_NAME1 , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , A.SHIP_ID , A.SHIP_LINE_NO , %DatePart(A.SHIP_DTTM) , A.QTY_SHIPPED_CONV , A.UNIT_OF_MEASURE , A.UNIT_MEASURE_SHIP , A.QTY_SHIPPED , A.ROUTE_CD , A.ROUTE_STOP_NBR , A.INTERUNIT_FLG , A.INTERUNIT_ID , A.REQ_ID , A.EXPORT , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , A.REASON_CD , A.CNTRCT_ID , %TimePart(A.SHIP_DTTM) , A.SHIP_TO_CUST_ID , %DatePart(A.SCHED_DTTM) , A.CNTCT_SEQ_SHIP , A.ADDRESS_SEQ_NUM , A.QTY_REQUESTED_BASE , A.QTY_BACKORDER_BASE , A.QTY_ALLOC_BASE , A.QTY_PROMISED_BASE , A.QTY_PICK_OVR_BASE , A.DESTIN_BU , A.LOCATION , A.ADDR_OVRD_LEVEL FROM PS_IN_DEMAND A WHERE A.IN_FULFILL_STATE BETWEEN '20' AND '70'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

2 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order

Default Value: OPR_DEF_TBL_IN.DEMAND_SOURCE

3 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit

Default Value: OPR_DEF_TBL_IN.SOURCE_BUS_UNIT

4 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
5 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
6 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
8 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
9 IN_FULFILL_STATE Character(2) VARCHAR2(2) NOT NULL Inventory Fulfillment State
10=Pending
20=Unfulfilled
30=Releasable
40=Released
50=Confirmed
60=Shipped
70=Depleted
90=Canceled
10 SHIP_CUST_NAME1 Character(40) VARCHAR2(40) NOT NULL Ship To Name
11 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
12 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
13 CITY Character(30) VARCHAR2(30) NOT NULL City
14 STATE Character(6) VARCHAR2(6) NOT NULL State
15 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
16 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
17 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID
18 SHIP_LINE_NO Number(10,2) DECIMAL(9,2) NOT NULL Ship Line No
19 SHIP_DATE Date(10) DATE Item Shipping Date
20 QTY_SHIPPED_CONV Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
21 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
22 UNIT_MEASURE_SHIP Character(3) VARCHAR2(3) NOT NULL Shipment Unit of Measure
23 QTY_SHIPPED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
24 ROUTE_CD Character(6) VARCHAR2(6) NOT NULL A unique identifier assigned to a delivery route. Route codes can be associated with customer addresses for external orders or locations for internal orders. Route codes can be used to identify the appropriate delivery schedule for a customer/location if you are managing product shipments with your own vehicles.
25 ROUTE_STOP_NBR Number(5,0) INTEGER NOT NULL An identifier used to sequence customer addresses/location for a given route.
26 INTERUNIT_FLG Character(1) VARCHAR2(1) NOT NULL InterUnit
N=No
Y=Yes
27 INTERUNIT_ID Character(10) VARCHAR2(10) NOT NULL InterUnit Order ID
28 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
29 EXPORT Character(1) VARCHAR2(1) NOT NULL Export Analytic Instance
N=No
Y=Yes
30 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
31 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
32 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
33 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
34 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer
35 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
36 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
37 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
38 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code
39 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
40 SHIP_TIME Time(15) TIMESTAMP Ship Time
41 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
42 SCHED_DATE Date(10) DATE Schedule Date
43 CNTCT_SEQ_SHIP Number(5,0) INTEGER NOT NULL Primary Contact - Ship To
44 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
45 QTY_REQUESTED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested Base
46 QTY_BACKORDER_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Base Qty
47 QTY_ALLOC_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity allocation
48 QTY_PROMISED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Promised Base
49 QTY_PICK_OVR_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Field used to override the net requested quantity in standard uom when printing the pick play for non-soft reservation items.
50 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit
51 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
52 ADDR_OVRD_LEVEL Character(1) VARCHAR2(1) NOT NULL Address Override Level
D=Demand Line
H=Header
L=Line
S=Schedule