CS_CNT_CL_BU_VW

(SQL View)
Index Back

Control Type Business Unit

PO002 Manufacturer Contract. Primary Record of control type BU grid.

SELECT SETID , CNTRCT_ID , VERSION_NBR , CONTROL_TYPE , SEQ_NO ,CNTRCT_ID_DST , BUSINESS_UNIT , CNTRCT_MARKUP FROM PS_CNT_CTRL_TYPE WHERE CONTROL_TYPE='BU'

# 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

Default Value: 1

4 CONTROL_TYPE Character(4) VARCHAR2(4) NOT NULL PO002 Manufacturer Contract
BU=Business Unit
CDOM=Contract Domain
SHIP=Ship To
X=Not Used
5 SEQ_NO Number(15,0) DECIMAL(15) NOT NULL Sequence Number
6 CNTRCT_ID_DST Character(25) VARCHAR2(25) NOT NULL Contract ID To
7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_PM_NONVW

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