ORDENT_PPRCHSET

(SQL View)
Index Back

Order price hdr sets


SELECT o.business_unit , o.order_no , o.order_int_line_no , o.sched_line_nbr , o.eoep_rule_id , o.break_id FROM PS_ORD_PPRC_SET o WHERE o.order_int_line_no = 0 AND o.sched_line_nbr = 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
3 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
4 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
5 EOEP_RULE_ID Character(30) VARCHAR2(30) NOT NULL Price Rule ID
6 BREAK_ID Number(10,0) DECIMAL(10) NOT NULL Price Break ID