TERMCOND database table column mapping

The WebSphere Commerce TERMCOND database table stores information about terms and conditions (also known as terms). This database table contains a number of generic columns used to store information about terms and condition. Different terms and conditions use the columns differently. Each mapping shows how the information in the XML elements of the terms and conditions map to columns in the TERMCOND database table.

For information on how terms and conditions information is mapped to the columns in the TERMCOND database table, terms and conditions mapping descriptions:

AddressBookTC mapping

TCSUBTYPE_ID
The type of term and condition, Foreign key to TCSUBTYPE table.

DisplayCustomizationTC mapping

BIGINTFIELD1
attachmentId
FLOATFIELD1
sequenceNumber
STRINGFIELD2
displayType
STRINGFIELD1
displayText
INTEGERFIELD1
displayTextLocale
TRADING_ID
Primary key. Foreign key to the trading agreement the TRADING table.
TERMCOND_ID
The primary key ID.
TCSUBTYPE_ID
The type of the term. Foreign key to the TCSUBTYPE table. The value of this column must be DisplayCustomizationTC.
MANDATORY
0
no
1
yes (participant must respond to this term during negotiation)
CHANGEABLE
0
no
1
yes (participant can change the term)
TIMECREATED
Time created
TIMEUPDATED
Time updated

FulfillmentTC mapping

INTEGERFIELD1
center1Id
INTEGERFIELD2
center2Id
INTEGERFIELD3
center3Id
TRADING_ID
Primary key. Foreign key to the TRADING table.
TERMCOND_ID
The primary key ID.
TCSUBTYPE_ID
The type of the term. Foreign key to the TCSUBTYPE table. The value of this column must be FulfillmentTC.
MANDATORY
0
no
1
yes (participant must respond to this term during negotiation)
CHANGEABLE
0
no
1
yes (participant can change the term)
TIMECREATED
Time created
TIMEUPDATED
Time updated

InvoiceTC mapping

TRADING_ID
Primary key. Foreign key to the TRADING table.
TERMCOND_ID
The primary key ID.
TCSUBTYPE_ID
The type of the term. Foreign key to the TCSUBTYPE table. The value of this column must be InvoiceTC.
MANDATORY
0
no
1
yes (participant must respond to this term during negotiation)
CHANGEABLE
0
no
1
yes (participant can change the term)
TIMECREATED
Time created
TIMEUPDATED
Time updated

ObligationToBuyTCByAmount mapping

INTEGERFIELD1
numberOfDays
DECIMALFIELD1
value
TRADING_ID
Primary key. Foreign key to the TRADING table.
TERMCOND_ID
The primary key ID.
TCSUBTYPE_ID
The type of the term. Foreign key to the TCSUBTYPE table. The value of this column must be ObligationToBuyTCByAmount.
MANDATORY
0
no
1
yes (participant must respond to this term during negotiation)
CHANGEABLE
0
no
1
yes (participant can change the term)
TIMECREATED
Time created
TIMEUPDATED
Time updated

OrderApprovalTC mapping

DECIMALFIELD1
value
TRADING_ID
Primary key. Foreign key to the TRADING table.
TERMCOND_ID
The primary key ID.
TCSUBTYPE_ID
The type of the term. Foreign key to the TCSUBTYPE table. The value of this column must be OrderApprovalTC.
MANDATORY
0
no
1
yes (participant must respond to this term during negotiation)
CHANGEABLE
0
no
1
yes (participant can change the term)
TIMECREATED
Time created
TIMEUPDATED
Time updated

OrderTCOrderComment mapping

TRADING_ID
Primary key. Foreign key to the TRADING table.
TERMCOND_ID
The primary key ID.
TCSUBTYPE_ID
The type of the term. Foreign key to the TCSUBTYPE table. The value of this column must be OrderTCOrderComment.
MANDATORY
0
no
1
yes (participant must respond to this term during negotiation)
CHANGEABLE
0
no
1
yes (participant can change the term)
TIMECREATED
Time created
TIMEUPDATED
Time updated

OrderTCOrderItemPAttribute mapping

BIGINTFIELD1
catEntryId
TRADING_ID
Primary key. Foreign key to the TRADING table.
TERMCOND_ID
The primary key ID.
TCSUBTYPE_ID
The type of the term. Foreign key to the TCSUBTYPE table. The value of this column must be OrderTCOrderItemPAttribute.
MANDATORY
0
no
1
yes (participant must respond to this term during negotiation)
CHANGEABLE
0
no
1
yes (participant can change the term)
TIMECREATED
Time created
TIMEUPDATED
Time updated

PaymentTC mapping

STRINGFIELD2
nickName
BIGINTFIELD1
memberId
TRADING_ID
Primary key. Foreign key to the TRADING table.
TERMCOND_ID
The primary key ID.
TCSUBTYPE_ID
The type of the term. Foreign key to the TCSUBTYPE table. The value of this column must be PaymentTC.
MANDATORY
0
no
1
yes (participant must respond to this term during negotiation)
CHANGEABLE
0
no
1
yes (participant can change the term)
TIMECREATED
Time created
TIMEUPDATED
Time updated

POTCBlanket mapping

BIGINTFIELD1
poId
TRADING_ID
Primary key. Foreign key to the TRADING table.
TERMCOND_ID
The primary key ID.
TCSUBTYPE_ID
The type of the term. Foreign key to the TCSUBTYPE table. The value of this column must be POTCBlanket.
MANDATORY
0
no
1
yes (participant must respond to this term during negotiation)
CHANGEABLE
0
no
1
yes (participant can change the term)
TIMECREATED
Time created
TIMEUPDATED
Time updated

POTCIndividual mapping

INTEGERFIELD1
checkUniqueness
TRADING_ID
Primary key. Foreign key to the TRADING table.
TERMCOND_ID
The primary key ID.
TCSUBTYPE_ID
The type of the term. Foreign key to the TCSUBTYPE table. The value of this column must be POTCIndividual.
MANDATORY
0
no
1
yes (participant must respond to this term during negotiation)
CHANGEABLE
0
no
1
yes (participant can change the term)
TIMECREATED
Time created
TIMEUPDATED
Time updated

POTCLimited mapping

STRINGFIELD2
currency
DECIMALFIELD1
value
BIGINTFIELD1
poId
TRADING_ID
Primary key. Foreign key to the TRADING table.
TERMCOND_ID
The primary key ID.
TCSUBTYPE_ID
The type of the term. Foreign key to the TCSUBTYPE table. The value of this column must be POTCLimited.
MANDATORY
0
no
1
yes (participant must respond to this term during negotiation)
CHANGEABLE
0
no
1
yes (participant can change the term)
TIMECREATED
Time created
TIMEUPDATED
Time updated

PriceTCCustomPriceList mapping

BIGINTFIELD1
priceListId
INTEGERFIELD1
productSetId
TRADING_ID
Primary key. Foreign key to the TRADING table.
TERMCOND_ID
The primary key ID.
TCSUBTYPE_ID
The type of the term. Foreign key to the TCSUBTYPE table. The value of this column must be PriceTCCustomPriceList.
MANDATORY
0
no
1
yes (participant must respond to this term during negotiation)
CHANGEABLE
0
no
1
yes (participant can change the term)
TIMECREATED
Time created
TIMEUPDATED
Time updated

PriceTCMasterCatalogWithFiltering mapping

INTEGERFIELD1
entireCatalogSelected
FLOATFIELD1
entireCatalogAdjustment
TIMEFIELD1
deployTimeStamp
INTEGERFIELD2
deployStatus
BIGINTFIELD1
priceListId
TRADING_ID
Primary key. Foreign key to the TRADING table.
TERMCOND_ID
The primary key ID.
TCSUBTYPE_ID
The type of the term. Foreign key to the TCSUBTYPE table. The value of this column must be PriceTCMasterCatalogWithFiltering.
MANDATORY
0
no
1
yes (participant must respond to this term during negotiation)
CHANGEABLE
0
no
1
yes (participant can change the term)
TIMECREATED
Time created
TIMEUPDATED
Time updated

PriceTCMasterCatalogWithOptionalAdjustment mapping

BIGINTFIELD1
priceListId
FLOATFIELD1
signedPercentage
INTEGERFIELD1
productSetId
TRADING_ID
Primary key. Foreign key to the TRADING table.
TERMCOND_ID
The primary key ID.
TCSUBTYPE_ID
The type of the term. Foreign key to the TCSUBTYPE table. The value of this column must be PriceTCMasterCatalogWithOptionalAdjustment.
MANDATORY
0
no
1
yes (participant must respond to this term during negotiation)
CHANGEABLE
0
no
1
yes (participant can change the term)
TIMECREATED
Time created
TIMEUPDATED
Time updated

PriceTCPriceListWithOptionalAdjustment mapping

BIGINTFIELD1
priceListId
FLOATFIELD1
signedPercentage
INTEGERFIELD1
productSetId
TRADING_ID
Primary key. Foreign key to the TRADING table.
TERMCOND_ID
The primary key ID.
TCSUBTYPE_ID
The type of the term. Foreign key to the TCSUBTYPE table. The value of this column must be PriceTCPriceListWithOptionalAdjustment.
MANDATORY
0
no
1
yes (participant must respond to this term during negotiation)
CHANGEABLE
0
no
1
yes (participant can change the term)
TIMECREATED
Time created
TIMEUPDATED
Time updated

PriceTCPriceListWithSelectiveAdjustment mapping

BIGINTFIELD1
priceListId
INTEGERFIELD2
adjustmentProductSetId
BIGINTFIELD2
adjustmentProductSetOwnerId
INTEGERFIELD1
productSetId
FLOATFIELD1
signedPercentage
INTEGERFIELD3
customProductSetFlag
TRADING_ID
Primary key. Foreign key to the TRADING table.
TERMCOND_ID
The primary key ID.
TCSUBTYPE_ID
The type of the term. Foreign key to the TCSUBTYPE table. The value of this column must be PriceTCPriceListWithSelectiveAdjustment.
MANDATORY
0
no
1
yes (participant must respond to this term during negotiation)
CHANGEABLE
0
no
1
yes (participant can change the term)
TIMECREATED
Time created
TIMEUPDATED
Time updated

ProductSetTCCustomExclusion mapping

INTEGERFIELD1
productSetId
BIGINTFIELD1
productSetOwnerId
TRADING_ID
Primary key. Foreign key to the TRADING table.
TERMCOND_ID
The primary key ID.
TCSUBTYPE_ID
The type of the term. Foreign key to the TCSUBTYPE table. The value of this column must be ProductSetTCCustomExclusion.
MANDATORY
0
no
1
yes (participant must respond to this term during negotiation)
CHANGEABLE
0
no
1
yes (participant can change the term)
TIMECREATED
Time created
TIMEUPDATED
Time updated

ProductSetTCCustomInclusion mapping

INTEGERFIELD1
productSetId
BIGINTFIELD1
productSetOwnerId
TRADING_ID
Primary key. Foreign key to the TRADING table.
TERMCOND_ID
The primary key ID.
TCSUBTYPE_ID
The type of the term. Foreign key to the TCSUBTYPE table. The value of this column must be ProductSetTCCustomInclusion.
MANDATORY
0
no
1
yes (participant must respond to this term during negotiation)
CHANGEABLE
0
no
1
yes (participant can change the term)
TIMECREATED
Time created
TIMEUPDATED
Time updated

ProductSetTCExclusion mapping

INTEGERFIELD1
productSetId
TRADING_ID
Primary key. Foreign key to the TRADING table.
TERMCOND_ID
The primary key ID.
TCSUBTYPE_ID
The type of the term. Foreign key to the TCSUBTYPE table. The value of this column must be ProductSetTCExclusion.
MANDATORY
0
no
1
yes (participant must respond to this term during negotiation)
CHANGEABLE
0
no
1
yes (participant can change the term)
TIMECREATED
Time created
TIMEUPDATED
Time updated

ProductSetTCInclusion mapping

INTEGERFIELD1
productSetId
TRADING_ID
Primary key. Foreign key to the TRADING table.
TERMCOND_ID
The primary key ID.
TCSUBTYPE_ID
The type of the term. Foreign key to the TCSUBTYPE table. The value of this column must be ProductSetTCInclusion.
MANDATORY
0
no
1
yes (participant must respond to this term during negotiation)
CHANGEABLE
0
no
1
yes (participant can change the term)
TIMECREATED
Time created
TIMEUPDATED
Time updated

ReferralInterfaceTC mapping

TRADING_ID
Primary key. Foreign key to the TRADING table.
TERMCOND_ID
The primary key ID.
TCSUBTYPE_ID
The type of the term. Foreign key to the TCSUBTYPE table. The value of this column must be ReferralInterfaceTC.
MANDATORY
0
no
1
yes (participant must respond to this term during negotiation)
CHANGEABLE
0
no
1
yes (participant can change the term)
TIMECREATED
Time created
TIMEUPDATED
Time updated

ReturnTCRefundPaymentMethod mapping

TRADING_ID
Primary key. Foreign key to the TRADING table.
TERMCOND_ID
The primary key ID.
TCSUBTYPE_ID
The type of the term. Foreign key to the TCSUBTYPE table. The value of this column must be ReturnTCRefundPaymentMethod.
MANDATORY
0
no
1
yes (participant must respond to this term during negotiation)
CHANGEABLE
0
no
1
yes (participant can change the term)
TIMECREATED
Time created
TIMEUPDATED
Time updated

ReturnTCReturnCharge mapping

TRADING_ID
Primary key. Foreign key to the TRADING table.
TERMCOND_ID
The primary key ID.
TCSUBTYPE_ID
The type of the term. Foreign key to the TCSUBTYPE table. The value of this column must be ReturnTCReturnCharge.
MANDATORY
0
no
1
yes (participant must respond to this term during negotiation)
CHANGEABLE
0
no
1
yes (participant can change the term)
TIMECREATED
Time created
TIMEUPDATED
Time updated

RightToBuyTCByAmount mapping

DECIMALFIELD1
value
TRADING_ID
Primary key. Foreign key to the TRADING table.
TERMCOND_ID
The primary key ID.
TCSUBTYPE_ID
The type of the term. Foreign key to the TCSUBTYPE table. The value of this column must be RightToBuyTCByAmount.
MANDATORY
0
no
1
yes (participant must respond to this term during negotiation)
CHANGEABLE
0
no
1
yes (participant can change the term)
TIMECREATED
Time created
TIMEUPDATED
Time updated

ShippingTCShippingCharge mapping

TRADING_ID
Primary key. Foreign key to the TRADING table.
TERMCOND_ID
The primary key ID.
TCSUBTYPE_ID
The type of the term. Foreign key to the TCSUBTYPE table. The value of this column must be ShippingTCShippingCharge.
MANDATORY
0
no
1
yes (participant must respond to this term during negotiation)
CHANGEABLE
0
no
1
yes (participant can change the term)
TIMECREATED
Time created
TIMEUPDATED
Time updated

ShippingTCShippingChargeAdjustment mapping

TRADING_ID
Primary key. Foreign key to the TRADING table.
TERMCOND_ID
The primary key ID.
TCSUBTYPE_ID
The type of the term. Foreign key to the TCSUBTYPE table. The value of this column must be ShippingTCShippingChargeAdjustment.
MANDATORY
0
no
1
yes (participant must respond to this term during negotiation)
CHANGEABLE
0
no
1
yes (participant can change the term)
TIMECREATED
Time created
TIMEUPDATED
Time updated

ShippingTCShippingMode mapping

TRADING_ID
Primary key. Foreign key to the TRADING table.
TERMCOND_ID
The primary key ID.
TCSUBTYPE_ID
The type of the term. Foreign key to the TCSUBTYPE table. The value of this column must be ShippingTCShippingMode.
MANDATORY
0
no
1
yes (participant must respond to this term during negotiation)
CHANGEABLE
0
no
1
yes (participant can change the term)
TIMECREATED
Time created
TIMEUPDATED
Time updated

ShippingTCShipToAddress mapping

BIGINTFIELD1
memberId
TRADING_ID
Primary key. Foreign key to the TRADING table.
TERMCOND_ID
The primary key ID.
TCSUBTYPE_ID
The type of the term. Foreign key to the TCSUBTYPE table. The value of this column must be ShippingTCShipToAddress.
MANDATORY
0
no
1
yes (participant must respond to this term during negotiation)
CHANGEABLE
0
no
1
yes (participant can change the term)
TIMECREATED
Time created
TIMEUPDATED
Time updated

Feedback