MFG_MARKUP_VW

(SQL View)
Index Back

Menufacturer Markup View

PO002 Manufacturer Contract. Markup detail view for Manufacturer Contract List on Distributor Contract page.

SELECT SETID , CNTRCT_ID_DST , 1 , CNTRCT_ID , VERSION_NBR , CONTROL_TYPE , BUSINESS_UNIT , CTRL_SETID , REGION_CD , CTRL_SETID , SHIPTO_ID , CNTRCT_MARKUP FROM PS_CNT_CTRL_TYPE WHERE CNTRCT_ID <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
3 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number
4 CNTRCT_ID_MFG Character(25) VARCHAR2(25) NOT NULL Contract ID To
5 VERSION_NBR_MFG Number(5,0) INTEGER NOT NULL Contract Version number
6 CONTROL_TYPE Character(4) VARCHAR2(4) NOT NULL PO002 Manufacturer Contract
BU=Business Unit
CDOM=Contract Domain
SHIP=Ship To
X=Not Used
7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_PM_NONVW

8 REGION_SETID Character(5) VARCHAR2(5) NOT NULL REGION_SETID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

9 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.

Prompt Table: REGION_CD_CNT

10 SHIPTO_SETID Character(5) VARCHAR2(5) NOT NULL ShipTo SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

11 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

Prompt Table: CNT_SHIPTOID_VW

12 CNTRCT_MARKUP Signed Number(10,4) DECIMAL(8,4) NOT NULL PO002