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 that is 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 identifer in STRINGFIELD2 is a category.
2
The identifer 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.