|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Budget Scenario
Table Name: OBGS
Table Description: Budget Scenario
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsId | Internal Number | Int | 11 | - | Â | Â | Â |
| Name | Name | nVarChar | 100 | - | Â | Â | Â |
| BaseId | Basic Budget | Int | 11 | - | Â | Â | Â |
| InitRate | Initial Ratio Percentage | Num | 19.6 | - | Â | Â | Â |
| Locked | Locked | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| FinancYear | Start of Fiscal Year | Date | 8 | - | Â | Â | Â |
| IsMain | Main | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| 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 |
| RoundSys | Rounding Method | Int | 6 | - | 0 | 0 | No Rounding |
| Â | Â | Â | Â | Â | Â | 1 | Round to Full Decimal Amount |
| Â | Â | Â | Â | Â | Â | 2 | Round to Full Amount |
| Â | Â | Â | Â | Â | Â | 3 | Round to Full Tens Amount |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| OcrCode | Dimension 1 | nVarChar | 8 | OOCR | Â | Â | Â |
| OcrCode2 | Dimension 2 | nVarChar | 8 | OOCR | Â | Â | Â |
| OcrCode3 | Dimension 3 | nVarChar | 8 | OOCR | Â | Â | Â |
| OcrCode4 | Dimension 4 | nVarChar | 8 | OOCR | Â | Â | Â |
| OcrCode5 | Dimension 5 | nVarChar | 8 | OOCR | Â | Â | Â |
| PrjCode | Project Code | nVarChar | 20 | OPRJ | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsId |
| SECOND | Yes | Name |
| Â | Â | FinancYear |
| INTER_KEY | No | BaseId |