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 | SXRRO | XLR Relations | 5 | Descriptio | Description | nVarChar | 254 | 0 | ||
Human Resources | ||||||||||
11 | OHED | Education Types | 3 | descriptio | Description | Text | 16 | 0 | ||
12 | OHPS | Employee Position | 3 | descriptio | Description | Text | 16 | 0 | ||
13 | OHST | Employee Status | 3 | descriptio | Description | Text | 16 | 0 | ||
14 | OHTM | Employee Teams | 3 | descriptio | Description | Text | 16 | 0 | ||
15 | OHTR | Termination Reason | 3 | descriptio | Description | Text | 16 | 0 | ||
16 | OHTY | Employee Types | 3 | descriptio | Description | Text | 16 | 0 | ||
Reports | ||||||||||
17 | XROBJ | XLR Company Report Objects | 3 | Descriptio | Description | Text | 16 | 0 | ||
18 | XRUDF | XLR company UDF | 5 | Descriptio | Description | nVarChar | 254 | 0 | ||
Service | ||||||||||
19 | OCTR | Service Contracts | 17 | Descriptio | Description | nVarChar | 254 | 0 | ||
20 | OCTT | Contract Template | 9 | Descriptio | Description | nVarChar | 254 | 0 | ||
21 | OSCO | Service Call Origins | 3 | Descriptio | Description | Text | 16 | 0 | ||
22 | OSCP | Service Call Problem Types | 3 | Descriptio | Description | Text | 16 | 0 | ||
23 | OSCS | Service Call Statuses | 3 | Descriptio | Description | Text | 16 | 0 | ||
24 | OSCT | Service Call Types | 3 | Descriptio | Description | Text | 16 | 0 | ||
25 | OSLT | Service Call Solutions | 12 | Descriptio | Description | Text | 16 | 0 | ||
26 | OSST | Service Call Solution Statuses | 3 | Descriptio | Description | nVarChar | 254 | 0 |