IN_RULE_ADD_VW

(SQL View)

SELECT RULE_CD , RULE_TYPE FROM PS_IN_RULE_HDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RULE_CD Character(5) VARCHAR2(5) NOT NULL Rule Code

2 RULE_TYPE Character(1) VARCHAR2(1) NOT NULL Rule Type
B=Line Backorder Rule
L=Line Reservation - Backorder
O=Order Reservation Rule
R=Line Reservation Rule

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RULE_CD	Character(5)	VARCHAR2(5) NOT NULL	Rule Code
2	RULE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Rule Type B=Line Backorder Rule L=Line Reservation - Backorder O=Order Reservation Rule R=Line Reservation Rule