CNTRCT_ERRIMPVW

(SQL View)
 Index Back

SELECT DISTINCT eip_ctl_id , setid , cntrct_id , version_nbr , cntrct_line_nbr , cat_line_nbr , effdt , qty_min , price_adjust_seq , message_set_nbr , message_nbr , po_param1 , recdescr , po_param2 , l.lbltext , po_fieldvalue100 , message_text_254 FROM ps_cntrct_err_imp e, PSRECDEFN r, pspnlfield l WHERE e.po_param1 = r.recname AND l.pnlname in ('CNTRCT_STG_EDIT', 'CNTRCT_UOM_IMPREV', 'CNTRCT_ADJC_IMPREV', 'CNTRCT_ADJD_IMPREV') and e.po_param1 = l.recname and e.po_param2 = l.fieldname

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
3 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
4 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number
5 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
6 CAT_LINE_NBR Number(5,0) INTEGER NOT NULL Contract Category Line Number
7 EFFDT Date(10) DATE Effective Date

Default Value: %date

8 QTY_MIN Number(16,4) DECIMAL(15,4) NOT NULL Minimum Quantity
9 PRICE_ADJUST_SEQ Number(3,0) SMALLINT NOT NULL Price Adjustment Sequence
10 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
11 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
12 PO_PARAM1 Character(30) VARCHAR2(30) NOT NULL Transaction Name
13 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description
14 PO_PARAM2 Character(30) VARCHAR2(30) NOT NULL Transaction Name
15 LBLTEXT Character(60) VARCHAR2(60) NOT NULL Field Name
16 PO_FIELDVALUE100 Character(100) VARCHAR2(100) NOT NULL Transaction Name
17 MESSAGE_TEXT_254 Character(254) VARCHAR2(254) NOT NULL Message Text