FulfillmentTC mapping (Business Edition)

TERMCOND
column name
Column type Column description
trading_id BigInt,
not null
Primary key. Foreign key to the trading agreement (TRADING) table
termcond_id BigInt,
not null
The primary key ID.
tcSubType_id Char(64) The type of the term. Foreign key to TCSUBTYPE table.
The value of this column must be FulfillmentTC.
mandatory Integer,
default 0
0 - no 1 - yes (participant must respond to this term during negotiation)
changeable Integer,
default 0
0 - no 1 - yes (participant can change the term)
timeCreated TimeStamp Time created.
timeUpdated TimeStamp Time updated.
elementData LongVarChar,
Default null
 
StringField1 VarChar (3000)  
StringField2 VarChar (254)  
StringField3 VarChar (254)  
IntegerField1 Integer center1Id. Foreign key to FFMCENTER.
IntegerField2 Integer center2Id. Foreign key to FFMCENTER.
IntegerField3 Integer center3Id. Foreign key to FFMCENTER.
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