PriceTCMasterCatalogWithFiltering mapping (Business Edition)

TERMCOND
column name
Column type Column description
trading_id Bigint not null Primary key, foreign key to the trading agreement table.
termcond_id BIGINT not null The primary key ID.
tcSubType_id CHAR(64) The type of the term and condition. Foreign key to TCSUBTYPE table.
The value of this column must be PriceTCMasterCatalogWithFiltering
mandatory Integer default 0 0 - no 1 - yes (participant must respond to this term and condition during negotiation)
changeable Integer default 0 0 - no 1 - yes (participant can change the term and condition).
timeCreated TimeStamp Time created
timeUpdated TimeStamp Time updated
elementData LongVARCHAR Default null  
StringField1 VARChar (3000)  
StringField2 VARChar (254)  
StringField3 VARChar (254)  
IntegerField1 Integer entireCatalogSelected
IntegerField2 Integer deployStatus
IntegerField3 Integer  
FloatField1 Double entireCatalogAdjustment
FloatField2 Double  
FloatField3 Double  
BigIntField1 BigInt priceListId
BigIntField2 BigInt  
BigIntField3 BigInt  
DecimalField1 Decimal (20,5)  
DecimalField2 Decimal (20,5)  
DecimalField3 Decimal (20,5)  
TimeField1 TimeStamp deployTimeStamp
TimeField2 TimeStamp  
TimeField3 TimeStamp