PI_BOOK_VW

(SQL View)
 Index Back

Physical Inv & Defualt Book

Physical Inventory and Default Book View. Date Initials Issue Description 032708 UMA 1739018000 Physical Inventory Extract does not work after change in the default book for given BU.

SELECT PI_ID , PI_NAME , A.BUSINESS_UNIT , CASE WHEN A.BOOK = ' ' THEN B.DEFAULT_BOOK ELSE A.BOOK END , PI_EXT_MC_ID , PI_SCAN_MC_ID ,OPRID FROM PS_PI_CNTL A , PS_BUS_UNIT_TBL_AM B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PI_ID Character(10) VARCHAR2(10) NOT NULL Physical Inventory ID
2 PI_NAME Character(30) VARCHAR2(30) NOT NULL Physical Inventory Name
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 DEFAULT_BOOK Character(10) VARCHAR2(10) NOT NULL Default Book
5 PI_EXT_MC_ID Character(30) VARCHAR2(30) NOT NULL PI Mass Change Extract ID

Prompt Table: PI_MC_EXTR_VW

6 PI_SCAN_MC_ID Character(30) VARCHAR2(30) NOT NULL PI Scan Scope Mass Change ID

Prompt Table: PI_MC_SCAN_VW

7 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).