Develop > Controller layer > Application developer > Trading subsystem > WebSphere Commerce business policy framework
Contract data in the Advanced B2B direct starter store
The following is an introduction to some of the contract data that is used in the advanced B2B direct 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 ShipTCShippingMode 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 ShipMode 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