BI_LINE_SHPF_VW (SQL View)	Index Back
BI line distinct SHIP FROM vw

BI_LINE_SHPF_VW

(SQL View)

BI line distinct SHIP FROM vw

SELECT DISTINCT BUSINESS_UNIT , INVOICE, PROCESS_INSTANCE , SHIP_FROM_BU FROM PS_BI_LINE WHERE SHIP_FROM_BU <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice

3 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

4 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
3	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
4	SHIP_FROM_BU	Character(5)	VARCHAR2(5) NOT NULL	Ship from INV BU