BCT_STG_INV_VW (SQL View)	Index Back
Prompt Table for Staging ID This is used as a prompt table for the staging ID field in RUN_CNTL_IN.

BCT_STG_INV_VW

(SQL View)

Prompt Table for Staging ID

This is used as a prompt table for the staging ID field in RUN_CNTL_IN.

select distinct BUSINESS_UNIT, STAGING_ID, STAGED_DATE from PS_STAGED_ITEM_INV where PUTAWAY_STATUS = '1' and PUTAWAY_FLAG <> 'Y' and PTWY_PLAN_ID = 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 STAGING_ID Number(15,0) DECIMAL(15) NOT NULL Putaway Staging ID

3 STAGED_DATE Date(10) DATE Staged Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	STAGING_ID	Number(15,0)	DECIMAL(15) NOT NULL	Putaway Staging ID
3	STAGED_DATE	Date(10)	DATE	Staged Date