Oracle ATG Web 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 | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the |
| integer | not null | The |
| varchar(40) | not null | The ID of the order for which the |
| date | null | The date and time that the order was most recently modified. This property is used to detect activity on abandoned orders. |
| varchar(40) | null | The abandonment state of the associated order. |
| integer | null | The number of times the associated order has been identified as ABANDONED. |
| date | null | The date and time the associated order was most recently identified as ABANDONED. |
| date | null | The date and time the associated order was most recently identified as REANIMATED. |
| date | null | The date and time the associated order was identified as CONVERTED. |
| 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 | Description |
---|---|---|---|
| varchar(40) | not null | The ID of this |
| varchar(40) | not null | The ID of the order. |
| 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 | Description |
---|---|---|---|
| varchar(40) | not null | The ID of the converted order. |
| date | not null | The date and time that the order was converted. |
| double precision | not null | The total price of the converted order. |
| integer | null | The number of promotions that were applied to the converted order. |
| 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 | Description |
---|---|---|---|
| varchar(40) | not null | The ID of the submitted order. |
| varchar(40) | not null | The ID of the dataset. |
| date timestamp | not null | The date and time that the order was converted. |
| double | not null | The total price of the submitted order. |
| integer | null | The number of promotions that were applied to the converted order. |
| varchar(40) | null | The total value of the promotions that were applied to the converted order. |
| varchar(40) | null | The total value of the promotions that were applied to the converted order. |
| numeric | null | A value of 1 indicates that the order is persistent. |