|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Budget - Cost Accounting Rows
Table Name: BGT3
Table Description: Budget - Cost Accounting Rows
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| BudgId | Budget Key | Int | 11 | OBGT | Â | Â | Â |
| OcrCode | Factor Code | nVarChar | 8 | OOCR | Â | Â | Â |
| DimCode | In Which Dimension | Int | 6 | ODIM | Â | Â | Â |
| Instance | Instance | Int | 11 | OBGS | 1 | Â | Â |
| Line_ID | Row Number | Int | 11 | - | Â | Â | Â |
| DebLTotal | Monthly Budget - Deb. | Num | 19.6 | - | Â | Â | Â |
| CredLTotal | Monthly Budget - Cr. | Num | 19.6 | - | Â | Â | Â |
| DebSTotal | Monthly Budget - SC Deb. | Num | 19.6 | - | Â | Â | Â |
| CredSTotal | Monthly Budget - SC Cr. | Num | 19.6 | - | Â | Â | Â |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | BudgId |
| Â | Â | OcrCode |
| Â | Â | DimCode |
| Â | Â | Line_ID |