BCT_PWYL_INV_VW (SQL View)	Index Back
Prompt table for Putaway Line

BCT_PWYL_INV_VW

(SQL View)

Prompt table for Putaway Line

SELECT DISTINCT BUSINESS_UNIT, PTWY_PLAN_ID, PTWYPLAN_LN_NBR FROM PS_STAGED_ITEM_INV WHERE PUTAWAY_FLAG <> 'Y' AND PUTAWAY_STATUS = '1'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PTWY_PLAN_ID Number(10,0) DECIMAL(10) NOT NULL Putaway Plan ID

3 PTWYPLAN_LN_NBR Number(10,0) DECIMAL(10) NOT NULL Putaway Line Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PTWY_PLAN_ID	Number(10,0)	DECIMAL(10) NOT NULL	Putaway Plan ID
3	PTWYPLAN_LN_NBR	Number(10,0)	DECIMAL(10) NOT NULL	Putaway Line Number