EXD_LOCATION_VW (SQL View)	Index Back
SHIP EXCISE INVOICE LOC VIEW

EXD_LOCATION_VW

(SQL View)

SHIP EXCISE INVOICE LOC VIEW

SELECT DISTINCT A.BUSINESS_UNIT ,A.LOCATION ,A.SHIP_CUST_NAME1 FROM PS_IN_DEMAND A WHERE A.IN_FULFILL_STATE BETWEEN '50' AND '70' AND A.LOCATION <>' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

3 SHIP_CUST_NAME1 Character(40) VARCHAR2(40) NOT NULL Ship To Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
3	SHIP_CUST_NAME1	Character(40)	VARCHAR2(40) NOT NULL	Ship To Name