ReferralInterfaceTC 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 to TCSUBTYPE table. The value of this column must be ReferralInterfaceTC
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  
IntegerField2 Integer  
IntegerField3 Integer  
FloatField1 Double  
FloatField2 Double  
FloatField3 Double  
BigIntField1 BigInt  
BigIntField2 BigInt  
BigIntField3 BigInt  
DecimalField1 Decimal (20,5)  
DecimalField2 Decimal (20,5)  
DecimalField3 Decimal (20,5)  
TimeField1 TimeStamp  
TimeField2 TimeStamp  
TimeField3 TimeStamp