Order Tables

ATG Commerce uses the following tables to store order information:

dcspp_order

This table stores information associated with a user’ s order such as the submitted date, the state, and the price.

Column	Data Type	Constraint
`order_id`	VARCHAR(40)	NOT NULL
(primary key)	The ID associated with the order.
`type`	INTEGER	NOT NULL
	An INTEGER representing the specific type of item descriptor.
`version`	INTEGER	NOT NULL
	The version of the data within the row.
`order_class_type`	VARCHAR(40)	NULL
	A string representing the type of order.
`profile_id`	VARCHAR(40)	NULL
	The ID of the profile to which the order belongs.
`description`	VARCHAR(64)	NULL
	A text description of the order.
`state`	VARCHAR(40)	NULL
	The state of the order.
`state_detail`	VARCHAR(254)	NULL
	Detailed state information about the order.
`creation_date`	DATE	NULL
	The date and time the order was created.
`submitted_date`	DATE	NULL
	The date and time the order was submitted for processing.
`last_modified_date`	DATE	NULL
	The date the order was last modified.
`completed_date`	DATE	NULL
	The date the order was completed.
`price_info`	VARCHAR(40)	NULL
	The price data for the order.
`tax_price_info`	VARCHAR(40)	NULL
	The price data for the tax of the order.
`created_by_order`	VARCHAR(40)	NULL
	Contains the ID of the order from which this order was created. Used by the Customer Service Module in situations such as exchanges.

dcspp_ship_group

This table stores information associated with a shipping group such as the shipping date, the state, and the shipping cost.

Column	Data Type	Constraint
`shipping_group_id`	VARCHAR(40)	NOT NULL
(primary key)	The ID associated with the shipping group.
`type`	INTEGER	NOT NULL
	An INTEGER representing the specific type of item descriptor.
`version`	INTEGER	NOT NULL
	The version of the data within the row.
`shipgrp_class_type`	VARCHAR(40)	NULL
	A string representing the type of shipping group.
`shipping_method`	VARCHAR(40)	NULL
	The shipping method, for example Ground, Next Day, etc.
`description`	VARCHAR(64)	NULL
	A text description of the shipping order.
`ship_on_date`	DATE	NULL
	The date to ship the items within the shipping group.
`actual_ship_date`	DATE	NULL
	The actual date that the items within the shipping group were shipped.
`state`	VARCHAR(40)	NULL
	The state of the shipping group.
`state_detail`	VARCHAR(254)	NULL
	Detailed state information about the shipping group.
`submitted_date`	DATE	NULL
	The date that the shipping group was submitted for processing.
`price_info`	VARCHAR(40)	NULL
	The price data for the shipping group.
`order_ref`	VARCHAR(40)	NULL
	The ID of the order to which this shipping group belongs.

dcspp_pay_group

This table stores information associated with a payment group such as the amount, the state, and the submitted date.

Column	Data Type	Constraint
`payment_group_id`	VARCHAR(40)	NOT NULL
(primary key)	The ID associated with the payment group.
`type`	INTEGER	NOT NULL
	An INTEGER representing the specific type of item descriptor.
`Version`	INTEGER	NOT NULL
	The version of the data within the row.
`paygrp_class_type`	VARCHAR(40)	NULL
	A string representing the type of payment group.
`payment_method`	VARCHAR(40)	NULL
	The payment method, for example Credit Card, Gift Certificate, etc.
`amount`	NUMERIC (19,7)	NULL
	The amount of the order this payment group represents.
`amount_authorized`	NUMERIC (19,7)	NULL
	The amount of the order that was authorized.
`amount_debited`	NUMERIC (19,7)	NULL
	The amount of the order was been debited.
`amount_credited`	NUMERIC (19,7)	NULL
	The amount of the order that was credited.
`currency_code`	VARCHAR(10)	NULL
	The currency code for the payment group.
`state`	VARCHAR(40)	NULL
	The state of the payment group.
`state_detail`	VARCHAR(254)	NULL
	Detailed state information about the payment group.
`submitted_date`	DATE	NULL
	The date and time the payment group was submitted for processing.
`order_ref`	VARCHAR(40)	NULL
	The ID of the order to which this payment group belongs.

dcspp_item

This table stores all the properties of an item in a cart such as the SKU ID, the quantity, and the price.

Column	Data Type	Constraint
`commerce_item_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the item.
`type`	INTEGER	NOT NULL
	An integer representing the specific type of item descriptor.
`version`	INTEGER	NOT NULL
	The version of the data within the row.
`item_class_type`	VARCHAR(40)	NULL
	A string representing the type of commerce item.
`catalog_id`	VARCHAR(40)	NULL
	The ID of the catalog associated with this commerce item.
`catalog_ref_id`	VARCHAR(40)	NULL
	The catalog reference ID of the item that this item represents (the SKU).
`catalog_key`	VARCHAR(40)	NULL
	An optional property that can be used to signify from which catalog the item was added. Usually contains a locale.
`product_id`	VARCHAR(40)	NULL
	The ID of the product that this item represents.
`quantity`	INTEGER	NULL
	The quantity of the item.
`state`	VARCHAR(40)	NULL
	The state of the commerce item.
`state_detail`	VARCHAR(254)	NULL
	Detailed state information about the commerce item.
`price_info`	VARCHAR(40)	NULL
	The price data for the commerce item.
`order_ref`	VARCHAR(40)	NULL
	The ID of the order to which this commerce item belongs.

dcspp_relationship

This table stores information associated with the relationship of an order such as the relationship type.

Column	Data Type	Constraint
`relationship_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the relationship.
`type`	INTEGER	NOT NULL
	An INTEGER representing the specific type of item descriptor.
`version`	INTEGER	NOT NULL
	The version of the data within the row.
`rel_class_type`	VARCHAR(40)	NULL
	A string representing the type of relationship.
`relationship_type`	VARCHAR(40)	NULL
	The type of the relationship. For example, SHIPPINGQUANTITY.
`order_ref`	VARCHAR(40)	NULL
	The ID of the order to which this relationship belongs.

dcspp_rel_orders

This table stores the individual entries of the specialInstructions property of the atg.commerce.order.Order object.

Column	Data Type	Constraint
`order_id`	VARCHAR(40)	NOT NULL
(primary key)	References `dcspp_order(order_id)`
`related_orders`	VARCHAR(40)	NOT NULL
	The id of another order which was created in reference to this order.
`seq_num`	VARCHAR(40)	NOT NULL
(primary key)	The sequence number in the list of related orders.

dcspp_order_inst

This table stores the individual entries of the specialInstructions property of the atg.commerce.order.Order object.

Column	Data Type	Constraint
`order_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier of the order to which this instruction belongs. References `dcspp_order(order_id)`
`tag`	VARCHAR(42)	NOT NULL
(primary key)	The identifier for the order instruction.
`special_inst`	VARCHAR(254)	NULL
	The instruction information.

dcspp_order_sg

This table stores the list of ShippingGroup ids that are contained within an Order.

Column	Data Type	Constraint
`order_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier of the order to which the shipping group belongs. References `dcspp_order(order_id)`
`shipping_groups`	VARCHAR(40)	NOT NULL
	The ID of the shipping group.
`sequence_num`	INTEGER	NOT NULL
(primary key)	The element number within the list to which the shipping group belongs.

dcspp_order_pg

This table stores the list of PaymentGroup IDs that are contained within an order.

Column	Data Type	Constraint
`order_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier of the order to which the payment group belongs. References `dcspp_order(order_id)`
`payment_groups`	VARCHAR(40)	NOT NULL
	The ID of the payment group.
`sequence_num`	INTEGER	NOT NULL
(primary key)	The element number within the list to which the payment group belongs.

dcspp_order_item

This table stores the list of CommerceItem IDs that are contained within an order.

Column	Data Type	Constraint
`order_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier of the order to which the commerce item belongs. References `dcspp_order(order_id)`
`commerce_items`	VARCHAR(40)	NOT NULL
	The ID of the commerce item.
`sequence_num`	INTEGER	NOT NULL
(primary key)	The element number within the list to which the commerce item belongs.

dcspp_order_rel

This table stores the list of Relationship IDs that are contained within an order.

Column	Data Type	Constraint
`order_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier of the order to which the relationship belongs. References `dcspp_order(order_id)`
`relationships`	VARCHAR(40)	NOT NULL
	The ID of the relationship.
`sequence_num`	INTEGER	NOT NULL
(primary key)	The element number within the list to which the relationship belongs.

dcspp_ship_inst

This table contains information about any special instructions associated with the shipping group.

Column	Data Type	Constraint
`shipping_group_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier of the shipping group to which this instruction belongs. References `dcspp_ship_group(shipping_group_id)`
`tag`	VARCHAR(42)	NOT NULL
(primary key)	The identifier for the shipping group instruction.
`special_inst`	VARCHAR(254)	NULL
	The instruction information.

dcspp_hrd_ship_grp

This table contains information about the hardgood shipping group such as the tracking number.

Column	Data Type	Constraint
`shipping_group_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the shipping group. References `dcspp_ship_group(shipping_group_id)`
`tracking_number`	VARCHAR(40)	NULL
	The tracking number for the hardgood shipping group.

dcspp_ele_ship_grp

This table contains information about an electronic shipping group such as the e-mail address.

Column	Data Type	Constraint
`shipping_group_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the shipping group. References `dcspp_ship_group(shipping_group_id)`
`email_address`	VARCHAR(40)	NULL
	The e-mail address of the user to which this shipping group belongs.

dcspp_ship_addr

This table contains information about the shipping address of a shipping group.

Column	Data Type	Constraint
`shipping_group_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the shipping group. References `dcspp_ship_group(shipping_group_id)`
`prefix`	VARCHAR(40)	NULL
	The prefix associated with the name in the shipping address. (Miss, Mrs., etc.)
`first_name`	VARCHAR(40)	NULL
	The first name of the user at this shipping address.
`middle_name`	VARCHAR(40)	NULL
	The middle name of the user at this shipping address.
`last_name`	VARCHAR(40)	NULL
	The last name of the user at this shipping address.
`suffix`	VARCHAR(40)	NULL
	The suffix associated with the name in the shipping address. (Jr. Sr., etc.)
`job_title`	VARCHAR(40)	NULL
	The job title of the person in the shipping address.
`address_1`	VARCHAR(50)	NULL
	The street and number of this shipping address.
`address_2`	VARCHAR(50)	NULL
	The street and number of this shipping address.
`address_3`	VARCHAR(50)	NULL
	The street and number of this shipping address.
`city`	VARCHAR(40)	NULL
	The city of this shipping address.
`county`	VARCHAR(50)	NULL
	The county of this shipping address.
`state`	VARCHAR(40)	NULL
	The state of this shipping address.
`postal_code`	VARCHAR(10)	NULL
	The postal code of this shipping address.
`country`	VARCHAR(40)	NULL
	The country of this shipping address.
`phone_number`	VARCHAR(40)	NULL
	The phone number of the user at this shipping address.
`fax_number`	VARCHAR(40)	NULL
	The fax number of the user at this shipping address.
`email`	VARCHAR(40)	NULL
	The e-mail of the user at this shipping address.

dcspp_hand_inst

This table stores all the properties of the atg.commerce.order.HandlingInstruction object such as the item and quantity to which the handling instruction belongs.

Column	Data Type	Constraint
`handling_inst_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the handling instruction.
`type`	INTEGER	NOT NULL
	An integer representing the specific type of item descriptor.
`version`	INTEGER	NOT NULL
	The version of the data within the row.
`hndinst_class_type`	VARCHAR(40)	NULL
	A string representing the type of handling instruction.
`handling_method`	VARCHAR(40)	NULL
	The handling method.
`shipping_group_id`	VARCHAR(40)	NULL
	The ID of the shipping group to which this handling instruction belongs.
`commerce_item_id`	VARCHAR(40)	NULL
	The ID of the commerce item that this handling instruction represents
`quantity`	INTEGER	NULL
	The quantity of the commerce item to which this handling instruction applies.

dcspp_gift_inst

This table stores all the properties of a gift list handling instruction object such as the gift list ID.

Column	Data Type	Constraint
`handling_inst_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the gift list handling instruction. References `dcspp_hand_inst(handling_inst_id)`
`giftlist_id`	VARCHAR(40)	NULL
	The ID of the gift list that this handling instruction represents.
`giftlist_item_id`	VARCHAR(40)	NULL
	The ID of the item within the gift list that this handling instruction represents.

dcspp_sg_hand_inst

This table stores the list of HandlingInstruction IDs that are contained within a shipping group.

Column	Data Type	Constraint
`shipping_group_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier of the shipping group to which the handling instruction belongs. References `dcspp_ship_group(shipping_group_id)`
`handling_instrs`	VARCHAR(40)	NOT NULL
	The ID of the handling instruction.
`sequence_num`	INTEGER	NOT NULL
(primary key)	The element number within the list to which the handling instruction belongs.

dcspp_pay_inst

This table stores the individual entries of the specialInstructions property of the atg.commerce.order.PaymentGroup object. The table contains special order instructions for each item in a certain payment group.

Column	Data Type	Constraint
`payment_group_id`	VARCHAR(40)	NOT NULL
	The unique identifier associated with the payment group. References `dcspp_pay_group(payment_group_id)`
`Tag`	VARCHAR(42)	NOT NULL
	The identifier for the payment group instruction.
`special_inst`	VARCHAR(254)	NULL
	The instruction information.

dcspp_config_item

This table includes information on configurable commerce items.

Column	Data Type	Constraint
`config_item_id`	VARCHAR(40)	NOT NULL
(primary key)	References `dcspp_item(commerce_item_id)`
`reconfig_data`	VARCHAR(255)	NULL
	Optional reconfiguration data about this configurable commerce item.
`notes`	VARCHAR(255)	NULL
	Optional notes about this configurable commerce item.

dcspp_subsku_item

This table includes information on a subSKU.

Column	Data Type	Constraint
`subsku_item_id`	VARCHAR(40)	NOT NULL
(primary key)	References `dcspp_item(commerce_item_id)`
`ind_quantity`	INTEGER	NULL
	The quantity of this subSKU that is contained within a single configurable commerce item.

dcspp_item_ci

This table includes information on a configurable commerce item.

Column	Data Type	Constraint
`commerce_item_id`	VARCHAR(40)	NOT NULL
(primary key)	References `dcspp_item(commerce_item_id)`
`commerce_items`	VARCHAR(40)	NOT NULL
	The ID of the subSKU commerce item within this configurable commerce item.
`sequence_num`	INTEGER	NOT NULL
(primary key)	The sequence number in the list of subSKU commerce items.

dcspp_gift_cert

This table stores all the properties of a gift certificate in an order such as the profile ID and the gift certificate number.

Column	Data Type	Constraint
`payment_group_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the payment group. References `dcspp_pay_group(payment_group_id)`
`profile_id`	VARCHAR(40)	NULL
	The profile ID to which this gift certificate payment group belongs.
`gift_cert_number`	VARCHAR(50)	NULL
	The gift certificate number that this gift certificate payment group represents.

dcspp_store_cred

This table includes information on store credit.

Column	Data Type	Constraint
`payment_group_id`	VARCHAR(40)	NOT NULL
(primary key)	References `dcspp_payment_group(payment_group_id)`
`profile_id`	VARCHAR(40)	NULL
	The profile id of the user associated with the store credit referenced in the `store_cred_number`.
`store_cred_number`	VARCHAR(50)	NULL
	The store credit number associated with this store credit..

dcspp_credit_card

This table stores all the properties of a credit card in an order such as the credit card number, the expiration month, the day of the month, and year, and the credit card type.

Column	Data Type	Constraint
`payment_group_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the payment group. References `dcspp_pay_group(payment_group_id)`
`credit_card_number`	VARCHAR(40)	NULL
	The credit card number.
`credit_card_type`	VARCHAR(40)	NULL
	The type of the credit card.
`expiration_month`	VARCHAR(20)	NULL
	The month the credit card expires.
`exp_day_of_month`	VARCHAR(20)	NULL
	The day of the month the credit card expires.
`expiration_year`	VARCHAR(20)	NULL
	The year the credit card expires.

dcspp_bill_addr

This table stores the billing address information for a certain payment group.

Column	Data Type	Constraint
`payment_group_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the payment group. References `dcspp_pay_group(payment_group_id)`
`prefix`	VARCHAR(40)	NULL
	The prefix associated with the name in the billing address. (Miss, Mrs., etc.)
`first_name`	VARCHAR(40)	NULL
	The first name of the user at this billing address.
`middle_name`	VARCHAR(40)	NULL
	The middle name of the user at this shipping address.
`last_name`	VARCHAR(40)	NULL
	The last name of the user at this shipping address.
`suffix`	VARCHAR(40)	NULL
	The suffix associated with the name in the billing address. (Jr. Sr., etc.)
`job_title`	VARCHAR(40)	NULL
	The job title of the person in the billing address.
`address_1`	VARCHAR(50)	NULL
	The street and number of this billing address.
`address_2`	VARCHAR(50)	NULL
	The street and number of this billing address.
`address_3`	VARCHAR(50)	NULL
	The street and number of this billing address.
`city`	VARCHAR(40)	NULL
	The city of this billing address.
`county`	VARCHAR(40)	NULL
	The county of this billing address.
`state`	VARCHAR(40)	NULL
	The state of this billing address.
`postal_code`	VARCHAR(10)	NULL
	The postal code of this billing address.
`country`	VARCHAR(40)	NULL
	The country of this billing address.
`phone_number`	VARCHAR(40)	NULL
	The phone number of the user at this billing address.
`fax_number`	VARCHAR(40)	NULL
	The fax number of the user at this billing address.
`email`	VARCHAR(40)	NULL
	The e-mail of the user at this billing address.

dcspp_pay_status

This table stores all the properties of a payment status in a payment group such as the amount, the transaction success, and the transaction timestamp.

Column	Data Type	Constraint
`status_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the payment status.
`type`	INTEGER	NOT NULL
	An integer representing the specific type of item descriptor.
`version`	INTEGER	NOT NULL
	The version of the data within the row.
`trans_id`	VARCHAR(50)	NULL
	The transaction ID of the payment status.
`amount`	NUMERIC (19,7)	NULL
	The amount this payment status represents.
`trans_success`	NUMERIC (1)	NULL CHECK `(trans_success IN (01))`
	A flag indicating the success of the transaction.
`error_message`	VARCHAR(254)	NULL
	The error message of the transaction, if any.
`trans_timestamp`	DATE	NULL
	The timestamp of the transaction.

dcspp_cc_status

This table stores all the properties of a credit card status in a payment group.

Column	Data Type	Constraint
`status_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the credit card status. References `dcspp_pay_status(status_id)`
`auth_expiration`	TIMESTAMP	NULL
	The time and date the authorization expires.
`avs_code`	VARCHAR(40)	NULL
	The address verification code.
`avs_desc_result`	VARCHAR(254)	NULL
	The address verification descriptive result.

dcspp_gc_status

This table stores all the properties of a gift certificate status in a payment group.

Column	Data Type	Constraint
`status_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the gift certificate status. References `dcspp_pay_status(status_id)`
`auth_expiration`	TIMESTAMP	NULL
	The time and date the authorization expires.

dcspp_sc_status

This table stores all the properties of a store credit status in a payment group.

Column	Data Type	Constraint
`status_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the store credit status. References `dcspp_pay_status(status_id)`
`auth_expiration`	TIMESTAMP	NULL
	The time and date the authorization expires.

dcspp_auth_status

This table stores the list of PaymentStatus IDs that are contained within a PaymentGroup that represent authorizations.

Column	Data Type	Constraint
`payment_group_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier of the payment group which the authorization status belongs. References `dcspp_pay_group(payment_group_id)`
`auth_status`	VARCHAR(40)	NOT NULL
	The ID of the authorization status.
`sequence_num`	INTEGER	NOT NULL
(primary key)	The element number within the list to which the authorization status belongs.

dcspp_debit_status

This table stores the list of PaymentStatus IDs that are contained within a PaymentGroup that represent debits.

Column	Data Type	Constraint
`payment_group_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier of the payment group which the debit status belongs. References `dcspp_pay_group(payment_group_id)`
`debit_status`	VARCHAR(40)	NOT NULL
	The ID of the debit status.
`sequence_num`	INTEGER	NOT NULL
(primary key)	The element number within the list to which the debit status belongs.

dcspp_cred_status

This table stores the list of PaymentStatus IDs that are contained within a PaymentGroup that represent credits.

Column	Data Type	Constraint
`payment_group_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier of the payment group which the credit status belongs. References `dcspp_pay_group(payment_group_id)`
`credit_status`	VARCHAR(40)	NOT NULL
	The ID of the credit status.
`sequence_num`	INTEGER	NOT NULL
(primary key)	The element number within the list to which the credit status belongs.

dcspp_shipitem_rel

This table contains information about relationships between shipping groups and commerce items. This table stores all the properties of a ShippingGroupCommerceItemRelationship such as shipping group ID, commerce item ID, and relationship quantity.

Column	Data Type	Constraint
`relationship_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the shipping group commerce item relationship. References `dcspp_relationship(relationship_id)`
`shipping_group_id`	VARCHAR(40)	NULL
	The ID of the shipping group for this relationship.
`commerce_item_id`	VARCHAR(40)	NULL
	The ID of the commerce item for this relationship.
`quantity`	INTEGER	NULL
	The quantity of the commerce item to which this relationship applies.
`returned_qty`	NUMERIC (19, 7)	NULL
	The returned quantity of the commerce item.
`amount`	NUMERIC (19,7)	NULL
	The amount of the commerce item to which this relationship applies.
`state`	VARCHAR(40)	NULL
	The state of the relationship.
`state_detail`	VARCHAR(254)	NULL
	Detailed state information about the relationship.

dcspp_rel_range

This table includes information on the ranges associated with a particular relationship. Specifically, ShippingGroupCommerceItemRelationship objects refer to some quantity of a CommerceItem. The range tells you which commerce items are in the given shipping group.

Column	Data Type	Constraint
`relationship_id`	VARCHAR(40)	NOT NULL
(primary key)	The relationship that uses this range.
`low_bound`	INTEGER	NULL
	The index (inclusive) of the first item in the range.
`high_bound`	INTEGER	NULL
	The index (inclusive) of the last item in the range.

dcspp_det_range

This table includes information on the ranges associated with a particular item price detail. Specifically, DetailedItemPriceInfo objects refer to some quantity of a CommerceItem. The range tells you which commerce items are priced in a particular way.

Column	Data Type	Constraint
`relationship_id`	VARCHAR(40)	NOT NULL
(primary key)	The relationship that uses this range.
`low_bound`	INTEGER	NULL
	The index (inclusive) of the first item in the range.
`high_bound`	INTEGER	NULL
	The index (inclusive) of the last item in the range.

dcspp_payitem_rel

This table contains information about relationships between payment groups and commerce items. This table stores all the properties of a PaymentGroupCommerceItemRelationship such as payment group ID, commerce item ID, and relationship amount.

Column	Data Type	Constraint
`relationship_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the payment group commerce item relationship. References `dcspp_relationship(relationship_id)`
`payment_group_id`	VARCHAR(40)	NULL
	The ID of the payment group for this relationship.
`commerce_item_id`	VARCHAR(40)	NULL
	The ID of the commerce item for this relationship.
`quantity`	NUMERIC (19,7)	NULL
	The quantity of the commerce item to which this relationship applies.
`amount`	NUMERIC (19,7)	NULL
	The amount of the commerce item to which this relationship applies.

dcspp_payship_rel

This table contains information about relationships between payment and shipping groups. This table stores all the properties of a PaymentGroupShippingGroupRelationship such as payment group ID, shipping group ID, and relationship amount.

Column	Data Type	Constraint
`relationship_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the payment group shipping group relationship. References `dcspp_relationship(relationship_id)`
`payment_group_id`	VARCHAR(40)	NULL
	The ID of the payment group for this relationship.
`shipping_group_id`	VARCHAR(40)	NULL
	The ID of the shipping group for this relationship.
`amount`	NUMERIC (19,7)	NULL
	The amount of the shipping group to which this relationship applies.

dcspp_payorder_rel

This table stores all the properties of a PaymentGroupOrderRelationship such as payment group ID, order ID, and relationship amount.

Column	Data Type	Constraint
`relationship_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the payment group order relationship. References `dcspp_relationship(relationship_id)`
`payment_group_id`	VARCHAR(40)	NULL
	The ID of the payment group for this relationship.
`order_id`	VARCHAR(40)	NULL
	The ID of the order for this relationship.
`amount`	NUMERIC (19,7)	NULL
	The amount of the order to which this relationship applies.

dcspp_amount_info

This table stores all the common properties of the priceInfo object.

Column	Data Type	Constraint
`amount_info_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the amount info.
`type`	INTEGER	NOT NULL
	An integer representing the specific type of item descriptor.
`version`	integer	NOT NULL
	The version of the data within the row.
`currency_code`	VARCHAR(10)	NULL
	The currency code of the amount info.
`amount`	NUMERIC (19,7)	NULL
	The amount of the amount info.
`discounted`	NUMERIC (1)	NULL CHECK`(discounted` IN (01))
	Flag indicating if a discount has been applied.
`amount_is_final`	TINYINT	NULL CHECK(`amount_is_final` IN (0,1))
	Flag indicating if amount is final amount.

dcspp_order_price

This table contains information about the price it costs to put together an order. This table stores all the properties of an OrderPriceInfo object such as raw subtotal, tax, and shipping.

Column	Data Type	Constraint
`amount_info_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the order price info. References `dcspp_amount_info(amount_info_id)`
`raw_subtotal`	NUMERIC (19,7)	NULL
	The raw subtotal of the order.
`tax`	NUMERIC (19,7)	NULL
	The tax for the order.
`shipping`	NUMERIC (19,7)	NULL
	The shipping cost for the order.

dcspp_item_price

This table contains information about the price of a specific item. This table stores the properties of an ItemPriceInfo object such as list price, raw total price, and sale price.

Column	Data Type	Constraint
`amount_info_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the item price info. References `dcspp_amount_info(amount_info_id)`
`list_price`	NUMERIC (19,7)	NULL
	The list price of the item.
`raw_total_price`	NUMERIC (19,7)	NULL
	The raw total price of the item.
`sale_price`	NUMERIC (19,7)	NULL
	The sale price of the item.
`on_sale`	NUMERIC (1)	CHECK`(on_sale IN (01))`
	Flag indicating whether item is on sale.
`qty_discounted`	NUMERIC (19,0)	NULL
	The quantity of the items that were discounted.
`qty_as_qualifier`	NUMERIC (19,0)	NULL
	The quantity of the items that are being used as qualifiers.
`order_discount`	DOUBLE PRECISION	NULL
	The discount associated with the item.
`price_list`	VARCHAR(40)	NULL
	The price list associated with the item.

dcspp_tax_price

This table contains all the tax information associated with an order. This table stores all the properties of a TaxPriceInfo object such as city tax, county tax, state tax, and country tax.

Column	Data Type	Constraint
`amount_info_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the tax price info. References `dcspp_amount_info(amount_info_id)`
`city_tax`	NUMERIC (19,7)	NULL
	The amount of the city tax.
`county_tax`	NUMERIC (19,7)	NULL
	The amount of the county tax.
`state_tax`	NUMERIC (19,7)	NULL
	The amount of the state tax.
`country_tax`	NUMERIC (19,7)	NULL
	The amount of the country tax.

dcspp_ship_price

This table stores information about the as raw shipping cost of an order

Column	Data Type	Constraint
`amount_info_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the shipping price info. References `dcspp_amount_info(amount_info_id)`
`raw_shipping`	NUMERIC (19,7)	NULL
	The amount of the raw shipping cost.

dcspp_amtinfo_adj

This table stores the list of PricingAdjustment IDs that are contained within a PriceInfo object.

Column	Data Type	Constraint
`amount_info_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier of the amount info to which the adjustment belongs. References `dcspp_amount_info(amount_info_id)`
`adjustments`	VARCHAR(40)	NOT NULL
	The unique identifier of the adjustment.
`sequence_num`	integer	NOT NULL
(primary key)	The element number within the list to which the adjustment belongs.

dcspp_price_adjust

This table stores all the properties of a PricingAdjustment object such as pricing model and adjustment.

Column	Data Type	Constraint
`adjustment_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the adjustment.
`version`	integer	NOT NULL
	The version of the data within the row.
`adj_description`	VARCHAR(254)	NULL
	A description of the adjustment.
`pricing_model`	VARCHAR(40)	NULL
	The unique identifier of the pricing model used for this adjustment.
`Adjustment`	DOUBLE PRECISION	NULL
	The amount of the adjustment.
`qty_adjusted`	integer	NULL
	The quantity of items this adjustment represents.

dcspp_shipitem_sub

This table contains the shipping subtotal for a shipping group in an order.

Column	Data Type	Constraint
`amount_info_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier of the amount info to which the shipping subtotal info belongs. References `dcspp_amount_info(amount_info_id)`
`shipping_group_id`	VARCHAR(42)	NOT NULL
(primary key)	The ID associated with the shipping group.
`ship_item_subtotal`	VARCHAR(40)	NOT NULL
	The subtotal of the shipping charge.

dcspp_taxshipitem

This table contains the tax information for a shipping group in an order.

Column	Data Type	Constraint
`amount_info_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier of the amount info to which the shipping tax info belongs. References `dcspp_amount_info(amount_info_id)`
`shipping_group_id`	VARCHAR(42)	NOT NULL
(primary key)	The ID associated with the shipping group.
`tax_ship_item_sub`	VARCHAR(40)	NOT NULL
	The amount of the shipping tax.

dcspp_ntaxshipitem

This table contains information about the non-taxable items in a shipping group in an order.

Column	Data Type	Constraint
`amount_info_id`	VARCHAR(40)	NOT NULL
(primary key)	References `dcspp_amount_info(amount_info_id)`
`shipping_group_id`	VARCHAR(42)	NOT NULL
(primary key)	The ID associated with the shipping group.
`non_tax_item_sub`	VARCHAR(40)	NOT NULL
	The amount of the shipping group that is non-taxable..

dcspp_itmprice_det

This table stores the list of DetailedItemPriceInfo IDs contained within a PriceInfo object.

Column	Data Type	Constraint
`amount_info_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier of the amount info to which the detailed price info belongs. References `dcspp_amount_info(amount_info_id)`
`cur_price_details`	VARCHAR(40)	NOT NULL
	The detailed price info.
`sequence_num`	integer	NOT NULL
(primary key)	The element number within the list to which the detailed price info belongs.

dcspp_det_price

This table stores detailed item price information such as quantity and quantity as qualifier.

Column	Data Type	Constraint
`amount_info_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the detailed item price info.
`quantity`	NUMERIC (19,0)	NULL
	The quantity of items to which this detailed item price info applies.
`qty_as_qualifier`	NUMERIC (19,0)	NULL
	The quantity of items that acted as a qualifier.
`order_discount`	DOUBLE PRECISION	NULL
	The amount of the order discount.
`tax`	DOUBLE PRECISION	NULL
	The amount of the tax on the order.

dcs_submt_ord_evt

This table contains information about Order Submitted events.

Column	Data Type	Constraint
`id`	VARCHAR(40)	NOT NULL UNIQUE
(primary key)	The ID of the event.
`clocktime`	TIMESTAMP	NULL
	The date and time that the event was sent.
`orderid`	VARCHAR(40)	NULL
	The ID of the order that was submitted.
`profileid`	VARCHAR(40)	NULL
	The profile ID of the user associated with the request when this message is sent in the context of an HTTP request.
`sessionid`	VARCHAR(100)	NULL
	The current session ID associated with the request when this message is sent in the context of an HTTP request.
`parentsessionid`	VARCHAR(100)	NULL
	The parent session ID. This ID may be different from the request’s current session ID on application servers that use a separate session ID for each Web application.

dcs_ord_merge_evt

This table contains information about Orders Merged events.

Column	Data Type		Constraint
`id`	VARCHAR(40)		NOT NULL UNIQUE
(primary key)	The ID of the event.
`clocktime`	TIMESTAMP		NULL
	The date and time that the event was sent.
`sourceorderid`	VARCHAR(40)		NULL
	The ID of the source order that was merged into the destination order.
`destorderid`	VARCHAR(40)		NULL
	The ID of the destination order into which the source order was merged.
`sourceremoved`	TINYINT		NULL CHECK `(sourceremoved in (0,1))`
	Determines whether the source order is removed after it is merged with the destination order.
`profileid`	VARCHAR(40)		NULL
	The profile ID of the user associated with the request when this message is sent in the context of an HTTP request.
`sessionid`	VARCHAR(100)	NULL
	The current session ID associated with the request when this message is sent in the context of an HTTP request.
`parentsessionid`	VARCHAR(100)	NULL
	The parent session ID. This ID may be different from the request’s current session ID on application servers that use a separate session ID for each Web application.

ATG Commerce Programming Guide