| Column | Data Type | Nullable | Default | Description |
| CustomerID | int | not null | | Store identification number. Foreign key to Customer.CustomerID. |
| ContactID | int | not null | | Contact (store employee) identification number. Foreign key to Contact.ContactID. |
| ContactTypeID | int | not null | | Contact type such as owner or purchasing agent. Foreign key to ContactType.ContactTypeID. |
| rowguid | uniqueidentifier | not null | (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated. |