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.
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.
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.
Column name | ||||
---|---|---|---|---|
SHIPMODE_ID | STOREENTITY_ID | CODE | CARRIER | |
Sample data row | 10053 | 10051 | A3 | XYZ Carrier |