Oracle ATG Web Commerce uses the following tables to store location information:
dcs_location
This table stores location information.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The ID of the location. |
| enum | null | The type of location, available types are |
| varchar(40) | null | An external location ID. |
| integer | not null | The version of the product. |
| varchar(254) | null | The name of the store. |
| datetime | null | The date from which available quantity can be searched. If no start date is provided, the current date is used. |
| datetime | null | The date to which available quantities can be searched. If no end date is provided, all quantity from the start date onward is returned. |
| numeric | not null | The latitude of the store. |
| numeric | not null | The longitude of the store. |
dcs_location_sites
This table stores location information for sites.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The ID of the location. |
| varchar(40) | not null | The ID of the site. |
dcs_loc_site_grps
This table stores location information for site groups.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The ID of the store. |
| varchar(40) | not null | The ID of the site group. |
dcs_location_store
This table stores location information for stores.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The ID of the store. |
| varchar(64) | null | The hours of the store. |
dcs_location_addr
This table stores location address information for stores.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The store ID. |
| varchar(50) | null | The first address line of the store. |
| varchar(50) | null | The second address line of the store. |
| varchar(50) | null | The third address line of the store. |
| varchar(40) | null | The city in which the store is located. |
| varchar(40) | null | The county in which the store is located. |
| varchar(40) | null | The state in which the store is located. |
| varchar(10) | null | The postal code of the store. |
| varchar(40) | null | The country in which the store is located. |
| varchar(40) | null | The phone number of the store. |
| varchar(40) | null | The fax number of the store. |
| varchar(255) | null | The e-mail address of the store. |