INFUL_DMDALN_VW (SQL View)	Index Back
Demand Address Seq Num View 08/04/04 PWF Data Model Change: Change to IN_DEMAND from SHIP_INF_INV

INFUL_DMDALN_VW

(SQL View)

Demand Address Seq Num View

08/04/04 PWF Data Model Change: Change to IN_DEMAND from SHIP_INF_INV

SELECT DISTINCT business_unit , ship_to_cust_id , address_seq_num FROM PS_IN_DEMAND WHERE ship_to_cust_id <> ' ' AND in_fulfill_state >='50'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 SL_SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer selection

3 SL_ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number selection

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	SL_SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer selection
3	SL_ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number selection