|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Resource Groups
Table Name: ORSB
Table Description: Resource Groups
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| ResGrpCod | Number | Int | 6 | - | Â | Â | Â |
| ResGrpNam | Group Name | nVarChar | 20 | - | Â | Â | Â |
| Locked | Locked | VarChar | 1 | - | N | N | Changeable |
| Â | Â | Â | Â | Â | Â | Y | Locked |
| DataSource | Data Source | VarChar | 1 | - | N | N | Unknown |
| Â | Â | Â | Â | Â | Â | I | Interface |
| Â | Â | Â | Â | Â | Â | U | Update |
| Â | Â | Â | Â | Â | Â | M | Import |
| Â | Â | Â | Â | Â | Â | O | DI API |
| Â | Â | Â | Â | Â | Â | S | Service Layer |
| Â | Â | Â | Â | Â | Â | W | Web Client |
| Â | Â | Â | Â | Â | Â | A | Doc. Generation Wizard |
| Â | Â | Â | Â | Â | Â | D | Restore Wizard |
| Â | Â | Â | Â | Â | Â | P | Partner Implementation |
| Â | Â | Â | Â | Â | Â | T | Year Transfer |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| Object | Object Type - History | nVarChar | 20 | - | 292 | Â | Â |
| logInstanc | Log Instance - History | Int | 11 | - | Â | Â | Â |
| createDate | Creation Date - History | Date | 8 | - | Â | Â | Â |
| userSign2 | Updating User - History | Int | 6 | - | Â | Â | Â |
| updateDate | Date of Update - History | Date | 8 | - | Â | Â | Â |
| ResType | Resource Type | VarChar | 1 | - | M | M | Machine |
| Â | Â | Â | Â | Â | Â | L | Labor |
| Â | Â | Â | Â | Â | Â | O | Other |
| CostName1 | Resource Std Cost 1 | nVarChar | 254 | - | Â | Â | Â |
| CostVal1 | Resource Std Cost 1 | Num | 19.6 | - | Â | Â | Â |
| CostName2 | Resource Std Cost 2 | nVarChar | 254 | - | Â | Â | Â |
| CostVal2 | Resource Std Cost 2 | Num | 19.6 | - | Â | Â | Â |
| CostName3 | Resource Std Cost 3 | nVarChar | 254 | - | Â | Â | Â |
| CostVal3 | Resource Std Cost 3 | Num | 19.6 | - | Â | Â | Â |
| CostName4 | Resource Std Cost 4 | nVarChar | 254 | - | Â | Â | Â |
| CostVal4 | Resource Std Cost 4 | Num | 19.6 | - | Â | Â | Â |
| CostName5 | Resource Std Cost 5 | nVarChar | 254 | - | Â | Â | Â |
| CostVal5 | Resource Std Cost 5 | Num | 19.6 | - | Â | Â | Â |
| CostName6 | Resource Std Cost 6 | nVarChar | 254 | - | Â | Â | Â |
| CostVal6 | Resource Std Cost 6 | Num | 19.6 | - | Â | Â | Â |
| CostName7 | Resource Std Cost 7 | nVarChar | 254 | - | Â | Â | Â |
| CostVal7 | Resource Std Cost 7 | Num | 19.6 | - | Â | Â | Â |
| CostName8 | Resource Std Cost 8 | nVarChar | 254 | - | Â | Â | Â |
| CostVal8 | Resource Std Cost 8 | Num | 19.6 | - | Â | Â | Â |
| CostName9 | Resource Std Cost 9 | nVarChar | 254 | - | Â | Â | Â |
| CostVal9 | Resource Std Cost 9 | Num | 19.6 | - | Â | Â | Â |
| CostName10 | Resource Std Cost 10 | nVarChar | 254 | - | Â | Â | Â |
| CostVal10 | Resource Std Cost 10 | Num | 19.6 | - | Â | Â | Â |
| ResUoM | Resource Unit of Measurement | nVarChar | 20 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | ResGrpCod |
| GROUP_NAME | Yes | ResGrpNam |