CNTRCT_ERR_IMP

(SQL Table)
Index Back

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

Default Value: %date

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