SHIP_SUM_INV_VW (SQL View)	Index Back
Shipping Summary - View /* mmt 04/05/04 Data model changes */

SHIP_SUM_INV_VW

(SQL View)

Shipping Summary - View

/* mmt 04/05/04 Data model changes */

SELECT DISTINCT a.business_unit , a.demand_source , a.source_bus_unit , a.order_no , a.pro_number , a.direct_invoicing , a.ship_id , a.partial_order_flag , a.single_ship_flag ,0 ,0 FROM PS_IN_DEMAND a , ps_issue_hdr_inv b WHERE a.in_fulfill_state BETWEEN '50' AND '70' AND a.business_unit = b.business_unit AND a.demand_source = b.demand_source AND a.source_bus_unit = b.source_bus_unit AND a.order_no = b.order_no AND b.fulfill_flag = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL 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

3 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL 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 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number

6 DIRECT_INVOICING Character(1) VARCHAR2(1) NOT NULL Direct Invoicing
Y/N Table Edit

7 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID

8 PARTIAL_ORDER_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Orders Can Ship
N=No
Y=Yes

9 SINGLE_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Single Ship Flag
N=No
Y=Yes
Y/N Table Edit
Default Value: N

10 INCLUDED_LINES Number(6,0) INTEGER NOT NULL Total number of shipped demand lines for a particular order number satisfying a particular selection criteria on the Fulfillment Status Inquiry Panel.

11 SHIPPED_LINES Number(6,0) INTEGER NOT NULL Total number of shipped demand lines for a particular order number satisfying a particular selection criteria on the Fulfillment Status Inquiry Panel.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	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
3	SOURCE_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	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	PRO_NUMBER	Character(40)	VARCHAR2(40) NOT NULL	Pro Number
6	DIRECT_INVOICING	Character(1)	VARCHAR2(1) NOT NULL	Direct Invoicing Y/N Table Edit
7	SHIP_ID	Character(10)	VARCHAR2(10) NOT NULL	Shipping ID
8	PARTIAL_ORDER_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Partial Orders Can Ship N=No Y=Yes
9	SINGLE_SHIP_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Single Ship Flag N=No Y=Yes Y/N Table Edit Default Value: N
10	INCLUDED_LINES	Number(6,0)	INTEGER NOT NULL	Total number of shipped demand lines for a particular order number satisfying a particular selection criteria on the Fulfillment Status Inquiry Panel.
11	SHIPPED_LINES	Number(6,0)	INTEGER NOT NULL	Total number of shipped demand lines for a particular order number satisfying a particular selection criteria on the Fulfillment Status Inquiry Panel.