| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| Banking | ||||||||||
| 1 | OPBD | Document Type | 2 | Descriptio | Document Type Description | nVarChar | 254 | 0 | ||
| 2 | OPPT | Payment Type | 2 | Descriptio | Payment Type Description | nVarChar | 254 | 0 | ||
| 3 | OPRS | Tax Payer Status | 2 | Descriptio | Description | nVarChar | 254 | 0 | ||
| 4 | OPYR | Payment Reason | 2 | Descriptio | Payment Reason Description | nVarChar | 254 | 0 | ||
| Business Partners | ||||||||||
| 5 | OCLA | Activity Status | 3 | descriptio | Status Description | nVarChar | 254 | 0 | ||
| General | ||||||||||
| 6 | OPST | Service Call Problem Subtype | 3 | Descriptio | Description | Text | 16 | 0 | ||
| 7 | SXRCD | XLR Class Definitions | 3 | descriptio | description | nVarChar | 254 | 0 | ||
| 8 | SXRME | XLR Members | 7 | Descriptio | Description | nVarChar | 254 | 0 | ||
| 9 | SXROB | XLR Objects | 4 | descriptio | description | nVarChar | 254 | 0 | ||
| 10 | SXRPD | XLR Property Definitions | 6 | descriptio | description | nVarChar | 254 | 0 | ||
| 11 | SXRRO | XLR Relations | 5 | Descriptio | Description | nVarChar | 254 | 0 | ||
| Human Resources | ||||||||||
| 12 | OHED | Education Types | 3 | descriptio | Description | Text | 16 | 0 | ||
| 13 | OHPS | Employee Position | 3 | descriptio | Description | Text | 16 | 0 | ||
| 14 | OHST | Employee Status | 3 | descriptio | Description | Text | 16 | 0 | ||
| 15 | OHTM | Employee Teams | 3 | descriptio | Description | Text | 16 | 0 | ||
| 16 | OHTR | Termination Reason | 3 | descriptio | Description | Text | 16 | 0 | ||
| 17 | OHTY | Employee Types | 3 | descriptio | Description | Text | 16 | 0 | ||
| Reports | ||||||||||
| 18 | XROBJ | XLR Company Report Objects | 3 | Descriptio | Description | Text | 16 | 0 | ||
| 19 | XRUDF | XLR company UDF | 5 | Descriptio | Description | nVarChar | 254 | 0 | ||
| Service | ||||||||||
| 20 | ACTR | Service Contracts | 17 | Descriptio | Description | nVarChar | 254 | 0 | ||
| 21 | OCTR | Service Contracts | 17 | Descriptio | Description | nVarChar | 254 | 0 | ||
| 22 | OCTT | Contract Template | 9 | Descriptio | Description | nVarChar | 254 | 0 | ||
| 23 | OSCO | Service Call Origins | 3 | Descriptio | Description | Text | 16 | 0 | ||
| 24 | OSCP | Service Call Problem Types | 3 | Descriptio | Description | Text | 16 | 0 | ||
| 25 | OSCS | Service Call Statuses | 3 | Descriptio | Description | Text | 16 | 0 | ||
| 26 | OSCT | Service Call Types | 3 | Descriptio | Description | Text | 16 | 0 | ||
| 27 | OSLT | Service Call Solutions | 12 | Descriptio | Description | Text | 16 | 0 | ||
| 28 | OSST | Service Call Solution Statuses | 3 | Descriptio | Description | nVarChar | 254 | 0 | ||