|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Authorization Group
Table Name: OUGR
Table Description: Authorization Group
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| GroupId | Authorization Group ID | Int | 6 | - | Â | Â | Â |
| GroupName | Group Name | nVarChar | 155 | - | Â | Â | Â |
| GroupDec | Group Description | nVarChar | 155 | - | Â | Â | Â |
| Allowences | Allowances | Text | 16 | - | Â | Â | Â |
| TPLId | Template ID | Int | 6 | UICU | Â | Â | Â |
| StartDate | Start Date | Date | 8 | - | Â | Â | Â |
| DueDate | Due Date | Date | 8 | - | Â | Â | Â |
| GroupType | Group Type | VarChar | 1 | - | A | A | Authorization |
| Â | Â | Â | Â | Â | Â | F | Form Settings |
| Â | Â | Â | Â | Â | Â | T | Alerts |
| Â | Â | Â | Â | Â | Â | U | UI Configuration Templates |
| Â | Â | Â | Â | Â | Â | L | All |
| CockpitId | Cockpit Template ID | Int | 6 | - | Â | Â | Â |
| logInstanc | Log Instance | Int | 11 | - | Â | Â | Â |
| userSign | Creating User - History | Int | 6 | OUSR | Â | Â | Â |
| createDate | Creation Date - History | Date | 8 | - | Â | Â | Â |
| userSign2 | Updating User - History | Int | 6 | OUSR | Â | Â | Â |
| updateDate | Date of Update - History | Date | 8 | - | Â | Â | Â |
| VersionNum | Version Number | nVarChar | 13 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | GroupId |
| NAME_KEY | Yes | GroupName |