HCL Commerce Enterprise

Sample: Contract data in a B2B store

The following is an introduction to some of the contract data that is used in the advanced B2B starter store.

The sample data in the following sections is organized by database table. Only the relevant rows and columns are displayed. Also note that when the sample is installed any unique identifiers (such as CONTRACT_ID) may have different values than what is shown here.

CONTRACT table sample data

The following table shows relevant sample data from the CONTRACT database table. Note that for display purposes, the database column headings are shown the first column and the row of sample data from the table is shown in the second column.

Column name Sample data
CONTRACT_ID 10007
MAJORVERSION 1
MINORVERSION 0
NAME AdvancedB2BDirectContractNumber 4567
MEMBER_ID -2001
ORIGIN 0
STATE 3
USAGE 1
MARKFORDELETE 0

TERMCOND table sample data

The following table shows relevant sample data from the TERMCOND database table. Note that for display purposes, the database column headings are shown the first column and the rows of sample data from the table are shown in the second and third columns.

Column name Sample data row 1 Sample data row 2
TERMCOND_ID 10025 10030
TCSUBTYPE_ID PriceTCPriceListWith SelectiveAdjustment ShippingTCShippingMode
TRADING_ID 10007 10007
STRINGFILED1 ProductSet2
INTEGERFIELD2 10002
INTEGERFIELD3 1
BIGINTFIELD1 10051
FLOATFIELD1 -50.0
SEQUENCE 1 6

POLICYTC table sample data

The following table shows relevant sample data from the POLICYTC database table. This table establishes the relationship between a policy and a terms and conditions object.

The following table shows sample data rows by column name.

Column name
POLICY_ID TERMCOND_ID
Sample data row 1 10053 10025
Sample data row 2 10056 10030

POLICY table sample data

The following table shows relevant sample data from the POLICY database table.

Column name Sample data row 1 Sample data row 2
POLICY_ID 10053 10056
POLICYNAME MasterCatalogPriceList A3
POLICYTYPE_ID Price ShippingMode
STOREENT_ID 10051 10051
PROPERTIES name=AdvancedB2BDirect& member_id=-2001 shippingMode=A3
STARTTIME null null
ENDTIME null null

TRADEPOSCN table sample data

The following table shows relevant sample data from the TRADEPOSCN database table.

The following table shows sample data rows by column name.

Column name
TRADEEPOSCN_ID MEMBER_ID NAME TYPE
Sample data row 10051 -2001 AdvancedB2BDirect S

SHIPMODE table sample data

The following table shows relevant sample data from the SHIPMODE database table.

The following table shows sample data rows by column name.

Column name
SHIPMODE_ID STOREENTITY_ID CODE CARRIER
Sample data row 10053 10051 A3 XYZ Carrier