Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
---|---|---|---|---|---|---|---|---|---|---|
Administration | ||||||||||
1 | AADM | Administration - Log | 230 | AliasName | Alias Name | Text | 16 | 0 | ||
2 | OADM | Administration | 230 | AliasName | Alias Name | Text | 16 | 0 | ||
Banking | ||||||||||
3 | ADS1 | House Bank Accounts | 30 | AliasName | Alias Name | nVarChar | 50 | 0 | ||
4 | DSC1 | House Bank Accounts | 30 | AliasName | Alias Name | nVarChar | 50 | 0 | ||
5 | ODSC | Bank Codes | 13 | AliasName | Alias Name | nVarChar | 50 | 0 | ||
6 | OPWB | PWZ - Bank Account | 21 | AliasName | Alias Name | nVarChar | 50 | 0 | ||
Business Partners | ||||||||||
7 | ACRB | Business Partner Bank Accounts - History | 21 | AliasName | Alias Name | nVarChar | 50 | 0 | ||
8 | ACRD | Business Partners - History | 235 | AliasName | Alias Name | Text | 16 | 0 | ||
9 | OCRB | BP - Bank Account | 21 | AliasName | Alias Name | nVarChar | 50 | 0 | ||
10 | OCRD | Business Partner | 235 | AliasName | Alias Name | Text | 16 | 0 |