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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The ID associated with the order. | |
| INTEGER | NOT NULL |
An INTEGER representing the specific type of item descriptor. | ||
| INTEGER | NOT NULL |
The version of the data within the row. | ||
| VARCHAR(40) | NULL |
A string representing the type of order. | ||
| VARCHAR(40) | NULL |
The ID of the profile to which the order belongs. | ||
| VARCHAR(64) | NULL |
A text description of the order. | ||
| VARCHAR(40) | NULL |
The state of the order. | ||
| VARCHAR(254) | NULL |
Detailed state information about the order. | ||
| DATE | NULL |
The date and time the order was created. | ||
| DATE | NULL |
The date and time the order was submitted for processing. | ||
| DATE | NULL |
The date the order was last modified. | ||
| DATE | NULL |
The date the order was completed. | ||
| VARCHAR(40) | NULL |
The price data for the order. | ||
| VARCHAR(40) | NULL |
The price data for the tax of the 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The ID associated with the shipping group. | |
| INTEGER | NOT NULL |
An INTEGER representing the specific type of item descriptor. | ||
| INTEGER | NOT NULL |
The version of the data within the row. | ||
| VARCHAR(40) | NULL |
A string representing the type of shipping group. | ||
| VARCHAR(40) | NULL |
The shipping method, for example Ground, Next Day, etc. | ||
| VARCHAR(64) | NULL |
A text description of the shipping order. | ||
| DATE | NULL |
The date to ship the items within the shipping group. | ||
| DATE | NULL |
The actual date that the items within the shipping group were shipped. | ||
| VARCHAR(40) | NULL |
The state of the shipping group. | ||
| VARCHAR(254) | NULL |
Detailed state information about the shipping group. | ||
| DATE | NULL |
The date that the shipping group was submitted for processing. | ||
| VARCHAR(40) | NULL |
The price data for the shipping group. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The ID associated with the payment group. | |
| INTEGER | NOT NULL |
An INTEGER representing the specific type of item descriptor. | ||
| INTEGER | NOT NULL |
The version of the data within the row. | ||
| VARCHAR(40) | NULL |
A string representing the type of payment group. | ||
| VARCHAR(40) | NULL |
The payment method, for example Credit Card, Gift Certificate, etc. | ||
| NUMERIC (19,7) | NULL |
The amount of the order this payment group represents. | ||
| NUMERIC (19,7) | NULL |
The amount of the order that was authorized. | ||
| NUMERIC (19,7) | NULL |
The amount of the order was been debited. | ||
| NUMERIC (19,7) | NULL |
The amount of the order that was credited. | ||
| VARCHAR(10) | NULL |
The currency code for the payment group. | ||
| VARCHAR(40) | NULL |
The state of the payment group. | ||
| VARCHAR(254) | NULL |
Detailed state information about the payment group. | ||
| DATE | NULL |
The date and time the payment group was submitted for processing. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the item. | |
| INTEGER | NOT NULL |
An integer representing the specific type of item descriptor. | ||
| INTEGER | NOT NULL |
The version of the data within the row. | ||
| VARCHAR(40) | NULL |
A string representing the type of commerce item. | ||
| VARCHAR(40) | NULL |
The ID of the catalog associated with this commerce item. | ||
| VARCHAR(40) | NULL |
The catalog reference ID of the item that this item represents (the SKU). | ||
| VARCHAR(40) | NULL |
An optional property that can be used to signify from which catalog the item was added. Usually contains a locale. | ||
| VARCHAR(40) | NULL |
The ID of the product that this item represents. | ||
| INTEGER | NULL |
The quantity of the item. | ||
| VARCHAR(40) | NULL |
The state of the commerce item. | ||
| VARCHAR(254) | NULL |
Detailed state information about the commerce item. | ||
| VARCHAR(40) | NULL |
The price data for the commerce item. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the relationship. | |
| INTEGER | NOT NULL |
An INTEGER representing the specific type of item descriptor. | ||
| INTEGER | NOT NULL |
The version of the data within the row. | ||
| VARCHAR(40) | NULL |
A string representing the type of relationship. | ||
| VARCHAR(40) | NULL |
The type of the relationship. For example, SHIPPINGQUANTITY. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | References | |
| VARCHAR(40) | NOT NULL |
The id of another order which was created in reference to this order. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier of the order to which this instruction belongs. References | |
| VARCHAR(42) | NOT NULL |
(primary key) | The identifier for the order instruction. | |
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier of the order to which the shipping group belongs. References | |
| VARCHAR(40) | NOT NULL |
The ID of the shipping group. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier of the order to which the payment group belongs. References | |
| VARCHAR(40) | NOT NULL |
The ID of the payment group. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier of the order to which the commerce item belongs. References | |
| VARCHAR(40) | NOT NULL |
The ID of the commerce item. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier of the order to which the relationship belongs. References | |
| VARCHAR(40) | NOT NULL |
The ID of the relationship. | ||
| INTEGER | NOT NULL |
(primary key) | The element number within the list to which the relationship belongs. |
dbcpp_sched_order
This table contains information related to scheduled orders.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The repository ID of the scheduled order entry. | |
| INT | NOT NULL |
The repository type of the item. | ||
| INT | NOT NULL |
The repository version number. | ||
| WVARCHAR(32) | NULL |
The user defined name of a scheduled order. | ||
| VARCHAR(40) | NULL |
The profile ID of the owner of a scheduled order. | ||
| TIMESTAMP | NULL |
The creation date of the scheduled order. | ||
| TIMESTAMP | NULL |
The date that the scheduled order is to begin submission. | ||
| TIMESTAMP | NULL |
The date that the scheduled order is to terminate submission. | ||
| VARCHAR(32) | NULL |
The order ID of the template order. | ||
| INT | NULL |
The state of the scheduled order. | ||
| TIMESTAMP | NULL |
The time of the next scheduled submission. | ||
| VARCHAR(255) | NULL |
The schedule of when the order is to be submitted. |
dcspp_ship_inst
This table contains information about any special instructions associated with the shipping group.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier of the shipping group to which this instruction belongs. References | |
| VARCHAR(42) | NOT NULL |
(primary key) | The identifier for the shipping group instruction. | |
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the shipping group. References | |
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the shipping group. References | |
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the shipping group. References | |
| VARCHAR(40) | NULL |
The prefix associated with the name in the shipping address. (Miss, Mrs., etc.) | ||
| VARCHAR(40) | NULL |
The first name of the user at this shipping address. | ||
| VARCHAR(40) | NULL |
The middle name of the user at this shipping address. | ||
| VARCHAR(40) | NULL |
The last name of the user at this shipping address. | ||
| VARCHAR(40) | NULL |
The suffix associated with the name in the shipping address. (Jr. Sr., etc.) | ||
| VARCHAR(40) | NULL |
The job title of the person in the shipping address. | ||
| VARCHAR(50) | NULL |
The street and number of this shipping address. | ||
| VARCHAR(50) | NULL |
The street and number of this shipping address. | ||
| VARCHAR(50) | NULL |
The street and number of this shipping address. | ||
| VARCHAR(40) | NULL |
The city of this shipping address. | ||
| VARCHAR(50) | NULL |
The county of this shipping address. | ||
| VARCHAR(40) | NULL |
The state of this shipping address. | ||
| VARCHAR(10) | NULL |
The postal code of this shipping address. | ||
| VARCHAR(40) | NULL |
The country of this shipping address. | ||
| VARCHAR(40) | NULL |
The phone number of the user at this shipping address. | ||
| VARCHAR(40) | NULL |
The fax number of the user at this shipping address. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the handling instruction. | |
| INTEGER | NOT NULL |
An integer representing the specific type of item descriptor. | ||
| INTEGER | NOT NULL |
The version of the data within the row. | ||
| VARCHAR(40) | NULL |
A string representing the type of handling instruction. | ||
| VARCHAR(40) | NULL |
The handling method. | ||
| VARCHAR(40) | NULL |
The ID of the shipping group to which this handling instruction belongs. | ||
| VARCHAR(40) | NULL |
The ID of the commerce item that this handling instruction represents | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the gift list handling instruction. References | |
| VARCHAR(40) | NULL |
The ID of the gift list that this handling instruction represents. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier of the shipping group to which the handling instruction belongs. References | |
| VARCHAR(40) | NOT NULL |
The ID of the handling instruction. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
The unique identifier associated with the payment group. References | ||
| VARCHAR(42) | NOT NULL |
The identifier for the payment group instruction. | ||
| VARCHAR(254) | NULL |
The instruction information. |
dcspp_config_item
This table includes information on configurable commerce items.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | References | |
| VARCHAR(255) | NULL |
Optional reconfiguration data about this configurable commerce item. | ||
| VARCHAR(255) | NULL |
Optional notes about this configurable commerce item. |
dcspp_subsku_item
This table includes information on a subSKU.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | References | |
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | References | |
| VARCHAR(40) | NOT NULL |
The ID of the subSKU commerce item within this configurable commerce item. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the payment group. References | |
| VARCHAR(40) | NULL |
The profile ID to which this gift certificate payment group belongs. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | References | |
| VARCHAR(40) | NULL |
The profile id of the user associated with the store credit referenced in the | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the payment group. References | |
| VARCHAR(40) | NULL |
The credit card number. | ||
| VARCHAR(40) | NULL |
The type of the credit card. | ||
| VARCHAR(20) | NULL |
The month the credit card expires. | ||
| VARCHAR(20) | NULL |
The day of the month the credit card expires. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the payment group. References | |
| VARCHAR(40) | NULL |
The prefix associated with the name in the billing address. (Miss, Mrs., etc.) | ||
| VARCHAR(40) | NULL |
The first name of the user at this billing address. | ||
| VARCHAR(40) | NULL |
The middle name of the user at this shipping address. | ||
| VARCHAR(40) | NULL |
The last name of the user at this shipping address. | ||
| VARCHAR(40) | NULL |
The suffix associated with the name in the billing address. (Jr. Sr., etc.) | ||
| VARCHAR(40) | NULL |
The job title of the person in the billing address. | ||
| VARCHAR(50) | NULL |
The street and number of this billing address. | ||
| VARCHAR(50) | NULL |
The street and number of this billing address. | ||
| VARCHAR(50) | NULL |
The street and number of this billing address. | ||
| VARCHAR(40) | NULL |
The city of this billing address. | ||
| VARCHAR(40) | NULL |
The county of this billing address. | ||
| VARCHAR(40) | NULL |
The state of this billing address. | ||
| VARCHAR(10) | NULL |
The postal code of this billing address. | ||
| VARCHAR(40) | NULL |
The country of this billing address. | ||
| VARCHAR(40) | NULL |
The phone number of the user at this billing address. | ||
| VARCHAR(40) | NULL |
The fax number of the user at this billing address. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the payment status. | |
| INTEGER | NOT NULL |
An integer representing the specific type of item descriptor. | ||
| INTEGER | NOT NULL |
The version of the data within the row. | ||
| VARCHAR(50) | NULL |
The transaction ID of the payment status. | ||
| NUMERIC (19,7) | NULL |
The amount this payment status represents. | ||
| NUMERIC (1) | NULL CHECK |
A flag indicating the success of the transaction. | ||
| VARCHAR(254) | NULL |
The error message of the transaction, if any. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the credit card status. References | |
| TIMESTAMP | NULL |
The time and date the authorization expires. | ||
| VARCHAR(40) | NULL |
The address verification code. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the gift certificate status. References | |
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the store credit status. References | |
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier of the payment group which the authorization status belongs. References | |
| VARCHAR(40) | NOT NULL |
The ID of the authorization status. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier of the payment group which the debit status belongs. References | |
| VARCHAR(40) | NOT NULL |
The ID of the debit status. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier of the payment group which the credit status belongs. References | |
| VARCHAR(40) | NOT NULL |
The ID of the credit status. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the shipping group commerce item relationship. References | |
| VARCHAR(40) | NULL |
The ID of the shipping group for this relationship. | ||
| VARCHAR(40) | NULL |
The ID of the commerce item for this relationship. | ||
| INTEGER | NULL |
The quantity of the commerce item to which this relationship applies. | ||
| NUMERIC | NULL |
The returned quantity of the commerce item. | ||
| NUMERIC (19,7) | NULL |
The amount of the commerce item to which this relationship applies. | ||
| VARCHAR(40) | NULL |
The state of the relationship. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The relationship that uses this range. | |
| INTEGER | NULL |
The index (inclusive) of the first item in the range. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The relationship that uses this range. | |
| INTEGER | NULL |
The index (inclusive) of the first item in the range. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the payment group commerce item relationship. References | |
| VARCHAR(40) | NULL |
The ID of the payment group for this relationship. | ||
| VARCHAR(40) | NULL |
The ID of the commerce item for this relationship. | ||
| NUMERIC (19,7) | NULL |
The quantity of the commerce item to which this relationship applies. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the payment group shipping group relationship. References | |
| VARCHAR(40) | NULL |
The ID of the payment group for this relationship. | ||
| VARCHAR(40) | NULL |
The ID of the shipping group for this relationship. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the payment group order relationship. References | |
| VARCHAR(40) | NULL |
The ID of the payment group for this relationship. | ||
| VARCHAR(40) | NULL |
The ID of the order for this relationship. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the amount info. | |
| INTEGER | NOT NULL |
An integer representing the specific type of item descriptor. | ||
| integer | NOT NULL |
The version of the data within the row. | ||
| VARCHAR(10) | NULL |
The currency code of the amount info. | ||
| NUMERIC (19,7) | NULL |
The amount of the amount info. | ||
| NUMERIC (1) | NULL CHECK |
Flag indicating if a discount has been applied. | ||
| TINYINT | NULL CHECK( |
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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the order price info. References | |
| NUMERIC (19,7) | NULL |
The raw subtotal of the order. | ||
| NUMERIC (19,7) | NULL |
The tax for the order. | ||
| NUMERIC (19,7) | NULL |
The shipping cost for the order. | ||
| NUMERIC (19,7) | NULL |
Total amount of all manual adjustments associated with 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the item price info. References | |
| NUMERIC (19,7) | NULL |
The list price of the item. | ||
| NUMERIC (19,7) | NULL |
The raw total price of the item. | ||
| NUMERIC (19,7) | NULL |
The sale price of the item. | ||
| NUMERIC (1) | CHECK |
Flag indicating whether item is on sale. | ||
| NUMERIC (19,0) | NULL |
The quantity of the items that were discounted. | ||
| NUMERIC (19,0) | NULL |
The quantity of the items that are being used as qualifiers. | ||
| DOUBLE PRECISION | NULL |
The discount associated with the item. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the tax price info. References | |
| NUMERIC (19,7) | NULL |
The amount of the city tax. | ||
| NUMERIC (19,7) | NULL |
The amount of the county tax. | ||
| NUMERIC (19,7) | NULL |
The amount of the state 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the shipping price info. References | |
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier of the amount info to which the adjustment belongs. References | |
| VARCHAR(40) | NOT NULL |
The unique identifier of the adjustment. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the adjustment. | |
| integer | NOT NULL |
The version of the data within the row. | ||
| VARCHAR(254) | NULL |
A description of the adjustment. | ||
| VARCHAR(40) | NULL |
The unique identifier of the pricing model used for this adjustment. | ||
| DOUBLE PRECISION | NULL |
The amount of the adjustment. | ||
| integer | NULL |
The quantity of items this adjustment represents. | ||
| VARCHAR(40) | NULL |
The amount of the adjustment. |
dcspp_shipitem_sub
This table contains the shipping subtotal for a shipping group in an order.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier of the amount info to which the shipping subtotal info belongs. References | |
| VARCHAR(42) | NOT NULL |
(primary key) | The ID associated with the shipping group. | |
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier of the amount info to which the shipping tax info belongs. References | |
| VARCHAR(42) | NOT NULL |
(primary key) | The ID associated with the shipping group. | |
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | References | |
| VARCHAR(42) | NOT NULL |
(primary key) | The ID associated with the shipping group. | |
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier of the amount info to which the detailed price info belongs. References | |
| VARCHAR(40) | NOT NULL |
The detailed price info. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the detailed item price info. | |
| NUMERIC (19,0) | NULL |
The quantity of items to which this detailed item price info applies. | ||
| NUMERIC (19,0) | NULL |
The quantity of items that acted as a qualifier. | ||
| DOUBLE PRECISION | NULL |
The amount of the order discount. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL UNIQUE |
(primary key) | The ID of the event. | |
| TIMESTAMP | NULL |
The date and time that the event was sent. | ||
| VARCHAR(40) | NULL |
The ID of the order that was submitted. | ||
| 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. | ||
| VARCHAR(100) | NULL |
The current session ID associated with the request when this message is sent in the context of an HTTP request. | ||
| 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 | |
---|---|---|---|
| VARCHAR(40) | NOT NULL UNIQUE | |
(primary key) | The ID of the event. | ||
| TIMESTAMP | NULL | |
The date and time that the event was sent. | |||
| VARCHAR(40) | NULL | |
The ID of the source order that was merged into the destination order. | |||
| VARCHAR(40) | NULL | |
The ID of the destination order into which the source order was merged. | |||
| TINYINT | NULL CHECK | |
Determines whether the source order is removed after it is merged with the destination order. | |||
| 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. | |||
| VARCHAR(100) | NULL | |
The current session ID associated with the request when this message is sent in the context of an HTTP request. | |||
| 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. |
dcspp_order_adj
This table contains information about manual adjustments performed by agents using CSC.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key component) | The ID of the order that received the adjustment; foreign key to the | |
| VARCHAR(40) | NOT NULL |
The ID of the adjustment. | ||
| INTEGER | NOT NULL |
(primary key component) | A sequentially generated number that combines with the |
dcspp_manual_adj
This table contains information about manual adjustments performed by agents using CSC.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The ID of the manual adjustment. | |
| INTEGER | NOT NULL |
The repository item type of the manual adjustment. Possible values are: 0 – | ||
| INTEGER | NOT NULL |
The type of adjustment made. Possible values are: 0 – 1 – | ||
| INTEGER | NOT NULL |
The reason for applying the adjustment. Possible values are: 0 – 1 -- | ||
| DOUBLE | NULL |
Amount of the adjustment. | ||
| VARCHAR(255) | NULL |
Agent notes related to this adjustment. | ||
| INTEGER | NOT NULL |
The integer incremented with each revision to prevent version conflict. |