ATG Commerce uses the following tables to store information about users’ abandoned orders:

See the Using Abandoned Order Services chapter for information on the Abandoned Order Services module.

dcspp_ord_abandon

This table contains information about abandoned orders.

Column

Data Type

Constraint

 

abandonment_id

VARCHAR(40)

NOT NULL

(primary key)

The unique identifier associated with the abandonmentInfo item.

version

INTEGER

NOT NULL

The abandonmentInfo item’s repository version number. This information is managed and used internally by the repository.

order_id

VARCHAR(40)

NOT NULL

The ID of the order for which the abandonmentInfo item holds abandonment information.

ord_last_updated

DATE

NULL

The date and time that the order was most recently modified. This property is used to detect activity on abandoned orders.

abandon_state

VARCHAR(40)

NULL

The abandonment state of the associated order.

abandonment_count

INTEGER

NULL

The number of times the associated order has been identified as ABANDONED.

abandonment_date

DATE

NULL

The date and time the associated order was most recently identified as ABANDONED.

reanimation_date

DATE

NULL

The date and time the associated order was most recently identified as REANIMATED.

convert_time

DATE

NULL

The date and time the associated order was identified as CONVERTED.

lost_date

DATE

NULL

The date and time the associated order was most recently identified as LOST.

dcs_user_abandoned

This table contains information about users’ abandoned orders.

Column

Data Type

Constraint

 

id

VARCHAR(40)

NOT NULL

(primary key)

The ID of this abandoned-order item.

order_id

VARCHAR(40)

NOT NULL

The ID of the order.

profile_id

VARCHAR(40)

NOT NULL

The profile ID of the user associated with the abandoned order.

drpt_conv_order

This table contains information about users’ converted orders, that is, previously abandoned, reanimated, or lost orders that subsequently have been checked out.

Column

Data Type

Constraint

 

order_id

VARCHAR(40)

NOT NULL

(primary key)

The ID of the converted order.

converted_date

DATE

NOT NULL

The date and time that the order was converted.

amount

DOUBLE
PRECISION

NOT NULL

The total price of the converted order.

promo_count

INTEGER

NULL

The number of promotions that were applied to the converted order.

promo_value

DOUBLE
PRECISION

NULL

The total value of the promotions that were applied to the converted order.

drpt_session_ord

This table tracks information about orders that have not been checked out at the end of a session.

Column

Data Type

Constraint

order_id

VARCHAR(40)

NOT NULL

(primary key)

The ID of the submitted order.

dataset_id

VARCHAR(40)

NOT NULL

The ID of the dataset.

date_time

DATE timestamp

NOT NULL

The date and time that the order was converted.

amount

DOUBLE
PRECISION numeric(19,7)

NOT NULL

The total price of the submitted order.

submitted

INTEGER

NULL

The number of promotions that were applied to the converted order.

session_id

VARCHAR(40)

NULL

The total value of the promotions that were applied to the converted order.

parent_session_id

VARCHAR(40)

NULL

The total value of the promotions that were applied to the converted order.

order_persistent

NUMERIC

NULL

A value of 1 indicates that the order is persistent.

 
loading table of contents...