SCON_PRICE_VW

(SQL View)
Index Back

Buying Agreement Price View

Buying Agreement Price View

SELECT a.cntrct_id , b.ship_from_bu , a.sold_to_cust_id , b.product_id , a.start_dt , a.end_dt , b.price , a.default_cntrct , b.business_unit , b.unit_of_measure FROM PS_SCON_HDR a , ps_scon_line b WHERE a.setid = b.setid AND a.cntrct_id = b.cntrct_id AND %CurrentDateIn BETWEEN a.start_dt AND a.end_dt

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
2 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU
3 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
4 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
5 START_DT Date(10) DATE Start Date
6 END_DT Date(10) DATE End Date
7 PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL This is price per unit for calculating the service charge.
8 DEFAULT_CNTRCT Character(1) VARCHAR2(1) NOT NULL Default Contract
9 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
10 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage