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 about how terms and conditions information is mapped to the columns in the
TERMCOND database table, terms and conditions mapping descriptions:
AddressBookTC mapping
- TERMCOND_ID
- The primary key ID.
- TCSUBTYPE_ID
- The type of term and condition, Foreign key to
TCSUBTYPE table. The value of this column must be AddressBookTC.
- TRADING_ID
- Primary key, foreign key to the trading agreement table.
- 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
- StringField1
- Shipping or billing
- IntegerField1
- usePersonalAddressBook
- IntegerField2
- useParentOrgAddressBook
- IntegerField3
- useAccountAddressBook
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
PriceTCConfigBuildBlock 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 PriceTCConfigBuildBlock.
- 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
- INTEGERFIELD1
- productSetId
- BIGINTFIELD1
- Custom priceListId
- BIGINTFIELD2
- A list of priceListId values. If there is only one, use the information stored in the
POLICYTC table.
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
- TERMCOND_ID
- The primary key ID and internal reference for this term.
- TCSUBTYPE_ID
- Foreign key to the
TCSUBTYPE table. This column indicates the sub-type of the term. The value of this column must be ShippingTCShippingChargeAdjustment.
- TRADING_ID
- Foreign key to the
TRADING table. This column indicates the trading agreement to which this term belongs.
- 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
- STRINGFIELD1
- Currency
- STRINGFIELD2
- Identifier for either the CATGROUP or CATENTRY to which the shipping adjustment applies.
- STRINGFIELD3
- ownerDn for either the CATGROUP or CATENTRY to which the shipping adjustment applies.
- INTEGERFIELD1
- Indicates the type of catalog entity (catgroup or catentry) to which the string fields refer. This will not be NULL, and there is no default value.
- 0
- entire order
- 1
- The identifer in STRINGFIELD2 is a CATGROUP.
- 2
- The identifer in STRINGFIELD2 is a CATENTRY.
- BIGINTFIELD1
- This column contains a catgroupId. This will be specified a value unless the IntegerField1 is a CATENTRY rather than a CATGROUP.
- BIGINTFIELD2
- This column contains a catentryId. This will be specified a value when the type(IntegerField1) is not NULL, and if the catgroupId above(BigIntField1) is NULL. So the ShippingTCShippingChargeAdjustment's category is determined using the following logic:
if type=catgroup category = BigIntField1 else if type=catentry category = BigIntField2 else category = ALL (this term and condition applies to all categories)
- BIGINTFIELD3
- This column contains a catalogId. This is required to enable for the category walking logic. Need to walk the tree for this specific catalog.
- FLOATFIELD1
- Signed percentage indicating the amount of the discount.
- DECIMALFIELD1
- Value indicating the amount of the discount.
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
Related concepts