|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Manual Distribution Rule - Rows
Table Name: MDR1
Table Description: Manual Distribution Rule - Rows
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| OcrCode | Factor Code | nVarChar | 8 | OMDR | Â | Â | Â |
| PrcCode | Center Code | nVarChar | 8 | OPRC | Â | Â | Â |
| PrcAmount | Total in Center | Num | 19.6 | - | Â | Â | Â |
| OcrTotal | Total Factor | Num | 19.6 | - | Â | Â | Â |
| Direct | Direct | VarChar | 1 | - | N | Y | Â |
| Â | Â | Â | Â | Â | Â | N | Â |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| ValidFrom | Effective From | Date | 8 | - | 19000101 | 19000101 | Â |
| ValidTo | Effective To | Date | 8 | - | Â | Â | Â |
| logInstanc | Log Instance | Int | 11 | - | Â | Â | Â |
| UserSign2 | Updating User | Int | 6 | OUSR | Â | Â | Â |
| updateDate | Date of Update | Date | 8 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | OcrCode |
| Â | Â | PrcCode |
| Â | Â | ValidFrom |
| PROF_ID | No | PrcCode |