|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Budget - Rows
Table Name: BGT1
Table Description: Budget - Rows
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| BudgId | Budget Key | Int | 11 | OBGT | Â | Â | Â |
| Line_ID | Row Number | Int | 11 | - | 0 | Â | Â |
| 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 | - | Â | Â | Â |
| DebRLTotal | Monthly Bal. - Deb. | Num | 19.6 | - | Â | Â | Â |
| CrdRLTotal | Monthly Bal. - Cr. | Num | 19.6 | - | Â | Â | Â |
| DebRSTotal | Monthly Bal. - SC Deb. | Num | 19.6 | - | Â | Â | Â |
| CrdRSTotal | Monthly Bal. - SC Cred. | Num | 19.6 | - | Â | Â | Â |
| FtrIDRLSum | Fut. Monthly Incomes SC Cr. | Num | 19.6 | - | Â | Â | Â |
| FtrIDRSSum | Fut. Monthly Incomes SC Deb. | Num | 19.6 | - | Â | Â | Â |
| FtrICRLSum | Fut. Incomes - Cr. | Num | 19.6 | - | Â | Â | Â |
| FtrICRSSum | Fut. Incomes - Sys. Cr. | Num | 19.6 | - | Â | Â | Â |
| FtrODRLSum | Fut. Expen - Local Deb. | Num | 19.6 | - | Â | Â | Â |
| FtrODRSSum | Fut.Expen - SC Deb. | Num | 19.6 | - | Â | Â | Â |
| FtrOCRLSum | Fut.Expen - Local Cr. | Num | 19.6 | - | Â | Â | Â |
| FtrOCRSSum | Fut.Expen - Sys. Cr. | Num | 19.6 | - | Â | Â | Â |
| MonthPrcnt | % of annual budget amount | Num | 19.6 | - | Â | Â | Â |
| LineMemo | Row Details | nVarChar | 50 | - | Â | Â | Â |
| Instance | Instance | Int | 11 | OBGS | 1 | Â | Â |
| AcctCode | Account Code | nVarChar | 15 | - | Â | Â | Â |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | BudgId |
| Â | Â | Line_ID |