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