RO_PRICE_SET_HD (SQL View)	Index Back
Order Header Price Sets This record is used to keep the inforamtion on Order Header Price Sets

RO_PRICE_SET_HD

(SQL View)

Order Header Price Sets

This record is used to keep the inforamtion on Order Header Price Sets

SELECT capture_id ,line_nbr ,price_set_id ,break_id FROM PS_RO_PRICE_SET WHERE line_nbr = 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CAPTURE_ID Character(20) VARCHAR2(20) NOT NULL Field use to store the capture ID in order capture.

2 LINE_NBR Number(5,0) INTEGER NOT NULL This field represents the integer Order Line Number.

3 PRICE_SET_ID Character(10) VARCHAR2(10) NOT NULL Price Set ID

4 BREAK_ID Number(10,0) DECIMAL(10) NOT NULL Price Break ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAPTURE_ID	Character(20)	VARCHAR2(20) NOT NULL	Field use to store the capture ID in order capture.
2	LINE_NBR	Number(5,0)	INTEGER NOT NULL	This field represents the integer Order Line Number.
3	PRICE_SET_ID	Character(10)	VARCHAR2(10) NOT NULL	Price Set ID
4	BREAK_ID	Number(10,0)	DECIMAL(10) NOT NULL	Price Break ID