TERMCOND database table column mapping

The WebSphere Commerce TERMCOND database table stores information about terms and conditions for trading agreements, such as business accounts, contracts, or request for quotes (RFQs).

The TERMCOND database table contains a number of generic columns. Different terms and conditions use these columns differently. The following mappings show how the information in the XML elements of the terms and conditions map to the columns in the TERMCOND database table:

AddressBookTC mapping

TERMCOND_ID

The primary key ID.

TCSUBTYPE_ID

Identifies the type of term and condition. This column is a foreign key to TCSUBTYPE table. The value of this column must be the value of the AddressBookTC.

TRADING_ID

Primary key. Foreign key to the TRADING database table.

MANDATORY

Indicates whether the trading agreement participant must respond to this term during negotiation. The following values are valid for this column:

0

The term is not mandatory.

1

The term in mandatory and the participant must respond to this term during negotiation.

CHANGEABLE

Indicates whether the trading agreement participant can change the term. The following values are valid for this column:

0

The term cannot be changed.

1

The participant can change the term.

TIMECREATED

Time that the term and condition is created.

TIMEUPDATED

Time that the term and condition is 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 database 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

Indicates whether the trading agreement participant must respond to this term during negotiation. The following values are valid for this column:

0

The term is not mandatory.

1

The term in mandatory and the participant must respond to this term during negotiation.

CHANGEABLE

Indicates whether the trading agreement participant can change the term. The following values are valid for this column:

0

The term cannot be changed.

1

The participant can change the term.

TIMECREATED

Time that the term and condition is created.

TIMEUPDATED

Time that the term and condition is updated.

FulfillmentTC mapping

INTEGERFIELD1

center1Id

INTEGERFIELD2

center2Id

INTEGERFIELD3

center3Id

TRADING_ID

Primary key. Foreign key to the TRADING database 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

Indicates whether the trading agreement participant must respond to this term during negotiation. The following values are valid for this column:

0

The term is not mandatory.

1

The term in mandatory and the participant must respond to this term during negotiation.

CHANGEABLE

Indicates whether the trading agreement participant can change the term. The following values are valid for this column:

0

The term cannot be changed.

1

The participant can change the term.

TIMECREATED

Time that the term and condition is created.

TIMEUPDATED

Time that the term and condition is updated.

InvoiceTC mapping

TRADING_ID

Primary key. Foreign key to the TRADING database 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

Indicates whether the trading agreement participant must respond to this term during negotiation. The following values are valid for this column:

0

The term is not mandatory.

1

The term in mandatory and the participant must respond to this term during negotiation.

CHANGEABLE

Indicates whether the trading agreement participant can change the term. The following values are valid for this column:

0

The term cannot be changed.

1

The participant can change the term.

TIMECREATED

Time that the term and condition is created.

TIMEUPDATED

Time that the term and condition is updated.

ObligationToBuyTCByAmount mapping

INTEGERFIELD1

numberOfDays

DECIMALFIELD1

Value

TRADING_ID

Primary key. Foreign key to the TRADING database 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

Indicates whether the trading agreement participant must respond to this term during negotiation. The following values are valid for this column:

0

The term is not mandatory.

1

The term in mandatory and the participant must respond to this term during negotiation.

CHANGEABLE

Indicates whether the trading agreement participant can change the term. The following values are valid for this column:

0

The term cannot be changed.

1

The participant can change the term.

TIMECREATED

Time that the term and condition is created.

TIMEUPDATED

Time that the term and condition is updated.

OrderApprovalTC mapping

DECIMALFIELD1

Value

STRINGFIELD1

Mapped to currency identifier for example, USD.

TRADING_ID

Primary key. Foreign key to the TRADING database 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

Indicates whether the trading agreement participant must respond to this term during negotiation. The following values are valid for this column:

0

The term is not mandatory.

1

The term in mandatory and the participant must respond to this term during negotiation.

CHANGEABLE

Indicates whether the trading agreement participant can change the term. The following values are valid for this column:

0

The term cannot be changed.

1

The participant can change the term.

TIMECREATED

Time that the term and condition is created.

TIMEUPDATED

Time that the term and condition is updated.

OrderTCOrderComment mapping

TRADING_ID

Primary key. Foreign key to the TRADING database 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

Indicates whether the trading agreement participant must respond to this term during negotiation. The following values are valid for this column:

0

The term is not mandatory.

1

The term in mandatory and the participant must respond to this term during negotiation.

CHANGEABLE

Indicates whether the trading agreement participant can change the term. The following values are valid for this column:

0

The term cannot be changed.

1

The participant can change the term.

TIMECREATED

Time that the term and condition is created.

TIMEUPDATED

Time that the term and condition is updated.

OrderTCOrderItemPAttribute mapping

BIGINTFIELD1

catEntryId

TRADING_ID

Primary key. Foreign key to the TRADING database 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

Indicates whether the trading agreement participant must respond to this term during negotiation. The following values are valid for this column:

0

The term is not mandatory.

1

The term in mandatory and the participant must respond to this term during negotiation.

CHANGEABLE

Indicates whether the trading agreement participant can change the term. The following values are valid for this column:

0

The term cannot be changed.

1

The participant can change the term.

TIMECREATED

Time that the term and condition is created.

TIMEUPDATED

Time that the term and condition is updated.

PaymentTC mapping

STRINGFIELD2

nickName

BIGINTFIELD1

memberId

TRADING_ID

Primary key. Foreign key to the TRADING database 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

Indicates whether the trading agreement participant must respond to this term during negotiation. The following values are valid for this column:

0

The term is not mandatory.

1

The term in mandatory and the participant must respond to this term during negotiation.

CHANGEABLE

Indicates whether the trading agreement participant can change the term. The following values are valid for this column:

0

The term cannot be changed.

1

The participant can change the term.

TIMECREATED

Time that the term and condition is created.

TIMEUPDATED

Time that the term and condition is updated.

POTCBlanket mapping

BIGINTFIELD1

poId

TRADING_ID

Primary key. Foreign key to the TRADING database 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

Indicates whether the trading agreement participant must respond to this term during negotiation. The following values are valid for this column:

0

The term is not mandatory.

1

The term in mandatory and the participant must respond to this term during negotiation.

CHANGEABLE

Indicates whether the trading agreement participant can change the term. The following values are valid for this column:

0

The term cannot be changed.

1

The participant can change the term.

TIMECREATED

Time that the term and condition is created.

TIMEUPDATED

Time that the term and condition is updated.

POTCIndividual mapping

INTEGERFIELD1

checkUniqueness

TRADING_ID

Primary key. Foreign key to the TRADING database 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

Indicates whether the trading agreement participant must respond to this term during negotiation. The following values are valid for this column:

0

The term is not mandatory.

1

The term in mandatory and the participant must respond to this term during negotiation.

CHANGEABLE

Indicates whether the trading agreement participant can change the term. The following values are valid for this column:

0

The term cannot be changed.

1

The participant can change the term.

TIMECREATED

Time that the term and condition is created.

TIMEUPDATED

Time that the term and condition is updated.

POTCLimited mapping

STRINGFIELD2

Currency

DECIMALFIELD1

Value

BIGINTFIELD1

poId

TRADING_ID

Primary key. Foreign key to the TRADING database 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

Indicates whether the trading agreement participant must respond to this term during negotiation. The following values are valid for this column:

0

The term is not mandatory.

1

The term in mandatory and the participant must respond to this term during negotiation.

CHANGEABLE

Indicates whether the trading agreement participant can change the term. The following values are valid for this column:

0

The term cannot be changed.

1

The participant can change the term.

TIMECREATED

Time that the term and condition is created.

TIMEUPDATED

Time that the term and condition is updated.

PriceTCConfigBuildBlock mapping

TRADING_ID

Primary key. Foreign key to the TRADING database 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

Indicates whether the trading agreement participant must respond to this term during negotiation. The following values are valid for this column:

0

The term is not mandatory.

1

The term in mandatory and the participant must respond to this term during negotiation.

CHANGEABLE

Indicates whether the trading agreement participant can change the term. The following values are valid for this column:

0

The term cannot be changed.

1

The participant can change the term.

TIMECREATED

Time that the term and condition is created.

TIMEUPDATED

Time that the term and condition is 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 database 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

Indicates whether the trading agreement participant must respond to this term during negotiation. The following values are valid for this column:

0

The term is not mandatory.

1

The term in mandatory and the participant must respond to this term during negotiation.

CHANGEABLE

Indicates whether the trading agreement participant can change the term. The following values are valid for this column:

0

The term cannot be changed.

1

The participant can change the term.

TIMECREATED

Time that the term and condition is created.

TIMEUPDATED

Time that the term and condition is updated.

PriceTCMasterCatalogWithFiltering mapping

INTEGERFIELD1

entireCatalogSelected

FLOATFIELD1

entireCatalogAdjustment

TIMEFIELD1

deployTimeStamp

INTEGERFIELD2

deployStatus

BIGINTFIELD1

priceListId

TRADING_ID

Primary key. Foreign key to the TRADING database 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

Indicates whether the trading agreement participant must respond to this term during negotiation. The following values are valid for this column:

0

The term is not mandatory.

1

The term in mandatory and the participant must respond to this term during negotiation.

CHANGEABLE

Indicates whether the trading agreement participant can change the term. The following values are valid for this column:

0

The term cannot be changed.

1

The participant can change the term.

TIMECREATED

Time that the term and condition is created.

TIMEUPDATED

Time that the term and condition is updated.

PriceTCMasterCatalogWithOptionalAdjustment mapping

BIGINTFIELD1

priceListId

FLOATFIELD1

signedPercentage

INTEGERFIELD1

productSetId

TRADING_ID

Primary key. Foreign key to the TRADING database 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

Indicates whether the trading agreement participant must respond to this term during negotiation. The following values are valid for this column:

0

The term is not mandatory.

1

The term in mandatory and the participant must respond to this term during negotiation.

CHANGEABLE

Indicates whether the trading agreement participant can change the term. The following values are valid for this column:

0

The term cannot be changed.

1

The participant can change the term.

TIMECREATED

Time that the term and condition is created.

TIMEUPDATED

Time that the term and condition is updated.

PriceTCPriceListWithOptionalAdjustment mapping

BIGINTFIELD1

priceListId

FLOATFIELD1

signedPercentage

INTEGERFIELD1

productSetId

TRADING_ID

Primary key. Foreign key to the TRADING database 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

Indicates whether the trading agreement participant must respond to this term during negotiation. The following values are valid for this column:

0

The term is not mandatory.

1

The term in mandatory and the participant must respond to this term during negotiation.

CHANGEABLE

Indicates whether the trading agreement participant can change the term. The following values are valid for this column:

0

The term cannot be changed.

1

The participant can change the term.

TIMECREATED

Time that the term and condition is created.

TIMEUPDATED

Time that the term and condition is updated.

PriceTCPriceListWithSelectiveAdjustment mapping

BIGINTFIELD1

priceListId

INTEGERFIELD2

adjustmentProductSetId

BIGINTFIELD2

adjustmentProductSetOwnerId

INTEGERFIELD1

productSetId

FLOATFIELD1

signedPercentage

INTEGERFIELD3

customProductSetFlag

TRADING_ID

Primary key. Foreign key to the TRADING database 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

Indicates whether the trading agreement participant must respond to this term during negotiation. The following values are valid for this column:

0

The term is not mandatory.

1

The term in mandatory and the participant must respond to this term during negotiation.

CHANGEABLE

Indicates whether the trading agreement participant can change the term. The following values are valid for this column:

0

The term cannot be changed.

1

The participant can change the term.

TIMECREATED

Time that the term and condition is created.

TIMEUPDATED

Time that the term and condition is updated.

ProductSetTCCustomExclusion mapping

INTEGERFIELD1

productSetId

BIGINTFIELD1

productSetOwnerId

TRADING_ID

Primary key. Foreign key to the TRADING database 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

Indicates whether the trading agreement participant must respond to this term during negotiation. The following values are valid for this column:

0

The term is not mandatory.

1

The term in mandatory and the participant must respond to this term during negotiation.

CHANGEABLE

Indicates whether the trading agreement participant can change the term. The following values are valid for this column:

0

The term cannot be changed.

1

The participant can change the term.

TIMECREATED

Time that the term and condition is created.

TIMEUPDATED

Time that the term and condition is updated.

ProductSetTCCustomInclusion mapping

INTEGERFIELD1

productSetId

BIGINTFIELD1

productSetOwnerId

TRADING_ID

Primary key. Foreign key to the TRADING database 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

Indicates whether the trading agreement participant must respond to this term during negotiation. The following values are valid for this column:

0

The term is not mandatory.

1

The term in mandatory and the participant must respond to this term during negotiation.

CHANGEABLE

Indicates whether the trading agreement participant can change the term. The following values are valid for this column:

0

The term cannot be changed.

1

The participant can change the term.

TIMECREATED

Time that the term and condition is created.

TIMEUPDATED

Time that the term and condition is updated.

ProductSetTCExclusion mapping

INTEGERFIELD1

productSetId

TRADING_ID

Primary key. Foreign key to the TRADING database 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

Indicates whether the trading agreement participant must respond to this term during negotiation. The following values are valid for this column:

0

The term is not mandatory.

1

The term in mandatory and the participant must respond to this term during negotiation.

CHANGEABLE

Indicates whether the trading agreement participant can change the term. The following values are valid for this column:

0

The term cannot be changed.

1

The participant can change the term.

TIMECREATED

Time that the term and condition is created.

TIMEUPDATED

Time that the term and condition is updated.

ProductSetTCInclusion mapping

INTEGERFIELD1

productSetId

TRADING_ID

Primary key. Foreign key to the TRADING database 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

Indicates whether the trading agreement participant must respond to this term during negotiation. The following values are valid for this column:

0

The term is not mandatory.

1

The term in mandatory and the participant must respond to this term during negotiation.

CHANGEABLE

Indicates whether the trading agreement participant can change the term. The following values are valid for this column:

0

The term cannot be changed.

1

The participant can change the term.

TIMECREATED

Time that the term and condition is created.

TIMEUPDATED

Time that the term and condition is updated.

ReferralInterfaceTC mapping

TRADING_ID

Primary key. Foreign key to the TRADING database 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

Indicates whether the trading agreement participant must respond to this term during negotiation. The following values are valid for this column:

0

The term is not mandatory.

1

The term in mandatory and the participant must respond to this term during negotiation.

CHANGEABLE

Indicates whether the trading agreement participant can change the term. The following values are valid for this column:

0

The term cannot be changed.

1

The participant can change the term.

TIMECREATED

Time that the term and condition is created.

TIMEUPDATED

Time that the term and condition is updated.

ReturnTCRefundPaymentMethod mapping

TRADING_ID

Primary key. Foreign key to the TRADING database 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

Indicates whether the trading agreement participant must respond to this term during negotiation. The following values are valid for this column:

0

The term is not mandatory.

1

The term in mandatory and the participant must respond to this term during negotiation.

CHANGEABLE

Indicates whether the trading agreement participant can change the term. The following values are valid for this column:

0

The term cannot be changed.

1

The participant can change the term.

TIMECREATED

Time that the term and condition is created.

TIMEUPDATED

Time that the term and condition is updated.

ReturnTCReturnCharge mapping

TRADING_ID

Primary key. Foreign key to the TRADING database 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

Indicates whether the trading agreement participant must respond to this term during negotiation. The following values are valid for this column:

0

The term is not mandatory.

1

The term in mandatory and the participant must respond to this term during negotiation.

CHANGEABLE

Indicates whether the trading agreement participant can change the term. The following values are valid for this column:

0

The term cannot be changed.

1

The participant can change the term.

TIMECREATED

Time that the term and condition is created.

TIMEUPDATED

Time that the term and condition is updated.

RightToBuyTCByAmount mapping

DECIMALFIELD1

Value

TRADING_ID

Primary key. Foreign key to the TRADING database 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

Indicates whether the trading agreement participant must respond to this term during negotiation. The following values are valid for this column:

0

The term is not mandatory.

1

The term in mandatory and the participant must respond to this term during negotiation.

CHANGEABLE

Indicates whether the trading agreement participant can change the term. The following values are valid for this column:

0

The term cannot be changed.

1

The participant can change the term.

TIMECREATED

Time that the term and condition is created.

TIMEUPDATED

Time that the term and condition is updated.

ShippingTCShippingCharge mapping

TRADING_ID

Primary key. Foreign key to the TRADING database 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

Indicates whether the trading agreement participant must respond to this term during negotiation. The following values are valid for this column:

0

The term is not mandatory.

1

The term in mandatory and the participant must respond to this term during negotiation.

CHANGEABLE

Indicates whether the trading agreement participant can change the term. The following values are valid for this column:

0

The term cannot be changed.

1

The participant can change the term.

TIMECREATED

Time that the term and condition is created.

TIMEUPDATED

Time that the term and condition is 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 subtype of the term. The value of this column must be ShippingTCShippingChargeAdjustment.

TRADING_ID

Foreign key to the TRADING database table. This column indicates the trading agreement to which this term belongs.

MANDATORY

Indicates whether the trading agreement participant must respond to this term during negotiation. The following values are valid for this column:

0

The term is not mandatory.

1

The term in mandatory and the participant must respond to this term during negotiation.

CHANGEABLE

Indicates whether the trading agreement participant can change the term. The following values are valid for this column:

0

The term cannot be changed.

1

The participant can change the term.

TIMECREATED

Time that the term and condition is created.

TIMEUPDATED

Time that the term and condition is updated.

STRINGFIELD1

Currency

STRINGFIELD2

Identifier for either the category or catalog entry to which the shipping adjustment applies.

STRINGFIELD3

ownerDn for either the category or catalog entry to which the shipping adjustment applies.

INTEGERFIELD1

Indicates the type of catalog entity (category or catalog entry) to which the string fields refer. This field cannot be NULL. There is no default value.

0

Entire order.

1

The identifier in STRINGFIELD2 is a category.

2

The identifier in STRINGFIELD2 is a catalog entry.

BIGINTFIELD1

This column contains a category ID (CATGROUP.CATGROUP_ID). This column includes a value unless the INTEGERFIELD1 is a catalog entry.

BIGINTFIELD2

This column contains a catalog entry ID (CATENTRY.CATENTRY_ID). This column includes a value when the type (INTEGERFIELD1) is not NULL and BIGINTFIELD1 column is NULL. The ShippingTCShippingChargeAdjustment category is determined with 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 catalog ID (CATALOG.CATALOG_ID). This value is required to enable the logic for determining the category.

FLOATFIELD1

Signed percentage that indicates 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 database 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

Indicates whether the trading agreement participant must respond to this term during negotiation. The following values are valid for this column:

0

The term is not mandatory.

1

The term in mandatory and the participant must respond to this term during negotiation.

CHANGEABLE

Indicates whether the trading agreement participant can change the term. The following values are valid for this column:

0

The term cannot be changed.

1

The participant can change the term.

TIMECREATED

Time that the term and condition is created.

TIMEUPDATED

Time that the term and condition is updated.

STRINGFIELD1

Nickname of the address.

INTEGERFIELD1

Owner of the address.

Related concepts
WebSphere Commerce database schema