BU_HOLD_VW (SQL View)	Index Back
Business Hold - OM This temporary table is used by the on-line order processing system to determine whether or not order schedules should be passed to inventory for fulfillment abd to the planning system.

BU_HOLD_VW

(SQL View)

Business Hold - OM

This temporary table is used by the on-line order processing system to determine whether or not order schedules should be passed to inventory for fulfillment abd to the planning system.

SELECT BUSINESS_UNIT , PASS_HOLD , PASS_HOLD_LEVEL , PASS_HOLD_CD , 'N' FROM PS_BU_HOLD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: BUS_UNIT_TBL_OM

2 PASS_HOLD Character(2) VARCHAR2(2) NOT NULL Pass Hold
20=Pass To Unfulfilled
30=Pass To Releasable
40=Pass To Released
50=Pass To Pick/Confirmed
60=Pass To Shipping
BI=Pass To Billing
P=Include in Planning
PO=Include in Purchasing

3 PASS_HOLD_LEVEL Character(4) VARCHAR2(4) NOT NULL Hold Code Level
CUST=Customer Hold
HDR=Header Hold
LINE=Line Hold
PROD=Product Hold
SCH=Schedule Hold
SYS=System Holds

4 PASS_HOLD_CD Character(6) VARCHAR2(6) NOT NULL System Hold Code
Prompt Table: HOLD_CD

5 PASSED Character(1) VARCHAR2(1) NOT NULL Passed Test

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUS_UNIT_TBL_OM
2	PASS_HOLD	Character(2)	VARCHAR2(2) NOT NULL	Pass Hold 20=Pass To Unfulfilled 30=Pass To Releasable 40=Pass To Released 50=Pass To Pick/Confirmed 60=Pass To Shipping BI=Pass To Billing P=Include in Planning PO=Include in Purchasing
3	PASS_HOLD_LEVEL	Character(4)	VARCHAR2(4) NOT NULL	Hold Code Level CUST=Customer Hold HDR=Header Hold LINE=Line Hold PROD=Product Hold SCH=Schedule Hold SYS=System Holds
4	PASS_HOLD_CD	Character(6)	VARCHAR2(6) NOT NULL	System Hold Code Prompt Table: HOLD_CD
5	PASSED	Character(1)	VARCHAR2(1) NOT NULL	Passed Test