Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
---|---|---|---|---|---|---|---|---|---|---|
Administration | ||||||||||
1 | AUSR | Users - History | 111 | NaturalPer | Natural Person | VarChar | 1 | 0 | N | N=No, Y=Yes |
2 | OUSR | Users | 111 | NaturalPer | Natural Person | VarChar | 1 | 0 | N | N=No, Y=Yes |
Business Partners | ||||||||||
3 | ACPR | Contact Persons - History | 47 | NaturalPer | Natural Person | VarChar | 1 | 0 | N | N=No, Y=Yes |
4 | ACRD | Business Partners - History | 357 | NaturalPer | Natural Person | VarChar | 1 | 0 | N | N=No, Y=Yes |
5 | OCPR | Contact Persons | 47 | NaturalPer | Natural Person | VarChar | 1 | 0 | N | N=No, Y=Yes |
6 | OCRD | Business Partner | 357 | NaturalPer | Natural Person | VarChar | 1 | 0 | N | N=No, Y=Yes |
Human Resources | ||||||||||
7 | AHEM | Employees - History | 124 | NaturalPer | Natural Person | VarChar | 1 | 0 | N | N=No, Y=Yes |
8 | OHEM | Employees | 124 | NaturalPer | Natural Person | VarChar | 1 | 0 | N | N=No, Y=Yes |