| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| Administration | ||||||||||
| 1 | AADM | Administration - Log | 7 | Fax | Fax Number | nVarChar | 20 | 0 | ||
| 2 | AOB1 | Sent Messages - User History | 20 | Fax | Fax Number | nVarChar | 20 | 0 | ||
| 3 | AUSR | Users - History | 31 | Fax | Fax Number | nVarChar | 20 | 0 | ||
| 4 | MLS1 | Distribution Lists - Recipients | 8 | Fax | Fax Number | nVarChar | 20 | 0 | ||
| 5 | OADM | Administration | 7 | Fax | Fax Number | nVarChar | 20 | 0 | ||
| 6 | OUDG | User Defaults | 17 | Fax | Fax Number | nVarChar | 20 | 0 | ||
| 7 | OUSR | Users | 31 | Fax | Fax Number | nVarChar | 20 | 0 | ||
| Banking | ||||||||||
| 8 | ADS1 | House Bank Accounts | 38 | Fax | Fax | nVarChar | 25 | 0 | ||
| 9 | DSC1 | House Bank Accounts | 38 | Fax | Fax | nVarChar | 25 | 0 | ||
| 10 | OPWB | PWZ - Bank Account | 28 | Fax | Fax | nVarChar | 25 | 0 | ||
| Business Partners | ||||||||||
| 11 | ACLG | Activities - History | 11 | Fax | Fax | nVarChar | 20 | 0 | ||
| 12 | ACPR | Contact Persons - History | 9 | Fax | Fax Number | nVarChar | 20 | 0 | ||
| 13 | ACRB | Business Partner Bank Accounts - History | 28 | Fax | Fax | nVarChar | 25 | 0 | ||
| 14 | ACRD | Business Partners - History | 12 | Fax | Fax Number | nVarChar | 20 | 0 | ||
| 15 | OCLG | Activities | 11 | Fax | Fax | nVarChar | 20 | 0 | ||
| 16 | OCPR | Contact Persons | 9 | Fax | Fax | nVarChar | 20 | 0 | ||
| 17 | OCRB | BP - Bank Account | 28 | Fax | Fax | nVarChar | 25 | 0 | ||
| 18 | OCRD | Business Partner | 12 | Fax | Fax Number | nVarChar | 20 | 0 | ||
| 19 | OSLP | Sales Employee | 13 | Fax | Fax | nVarChar | 20 | 0 | ||
| 20 | OTBP | Target Group Business Partner | 9 | Fax | Fax | nVarChar | 20 | 0 | ||
| 21 | TGG1 | Target Group Details | 13 | Fax | Fax | nVarChar | 20 | 0 | ||
| Human Resources | ||||||||||
| 22 | AHEM | Employees - History | 25 | fax | Fax | nVarChar | 20 | 0 | ||
| 23 | OHEM | Employees | 25 | fax | Fax | nVarChar | 20 | 0 | ||