SCON_COMPTTRS

(SQL Table)
Index Back

Sales Contract Competitor

This record hold competitor information for a Product. Use of this record is optional.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID

Prompt Table: SCON_HDR

3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
5 COMPETITOR_CD Character(6) VARCHAR2(6) NOT NULL Competitor Code

Prompt Table: COMPETITOR_CD

6 PRICE_TO_BEAT Number(16,2) DECIMAL(15,2) NOT NULL Price to Beat