CmpnyLoc
| CompanyID | Company Identifier | SmallID | 12 | |
| LocationID | Location Identifier | BigID | 12 | |
| Address1 | Address, Line 1 | Varchar | 80 | |
| Address2 | Address, Line 2 | Varchar | 80 | |
| City | City | Varchar | 80 | |
| State | State Code | Varchar | 2 | |
| ZipCode | Zip Code | Varchar | 10 | |
| Country | Country | Varchar | 80 | |
| CntctEmail | Contact Email Address | Varchar | 80 | |
| CntctFax | Contact Fax Number | Varchar | 25 | |
| CntctName | Contact Name | Varchar | 80 | |
| CntctNotes | Contact Notes | Text | 16000 | |
| CntctPhone | Contact Phone Number | Varchar | 40 | |
| CntctTitle | Contact Title | Varchar | 80 | |
| FaxNbr | Fax Number | Varchar | 25 | |
| LocName | Location Name | Varchar | 40 | |
| LocNbr | Location Number | Varchar | 10 | |
| Notes | Comments | Text | 16000 | |
| PhoneNbr | Phone Number | Varchar | 40 | |
| ActiveFlag | A-Active, I-Inactive | Varchar | 1 | |
| LstModBy | Last Modified By Name | Varchar | 40 | |
| LstModDate | Last Modified Date | Date | 32 | |
| LockSeqNbr | *SYSTEM* Row Sequence Nbr | Long | 12 |