|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Budget
Table Name: OBGT
Table Description: Budget
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsId | Internal Number | Int | 11 | - | Â | Â | Â |
| AcctCode | Account Code | nVarChar | 15 | - | Â | Â | Â |
| BgdCode | Division Code | Int | 11 | OBGD | Â | Â | Â |
| FatherCode | Parent Account Key | nVarChar | 15 | - | Â | Â | Â |
| FthrPrcnt | Parent Acct % | Num | 19.6 | - | Â | Â | Â |
| DebLTotal | Total Annual Budget - Debit (LC) | Num | 19.6 | - | Â | Â | Â |
| CredLTotal | Total Annual Budget - Credit (LC) | Num | 19.6 | - | Â | Â | Â |
| DebSTotal | Total Annual Budget - Debit (SC) | Num | 19.6 | - | Â | Â | Â |
| CredSTotal | Total Annual Budget - Credit (SC) | Num | 19.6 | - | Â | Â | Â |
| DebRLTotal | Budget Balance - Debit (LC) | Num | 19.6 | - | Â | Â | Â |
| CrdRLTotal | Budget Balance - Credit (LC) | Num | 19.6 | - | Â | Â | Â |
| DebRSTotal | Budget Balance - Debit (SC) | Num | 19.6 | - | Â | Â | Â |
| CrdRSTotal | Budget Balance - Credit (SC) | Num | 19.6 | - | Â | Â | Â |
| FtrIDRLSum | Future Annual Revenues - Debit (LC) | Num | 19.6 | - | Â | Â | Â |
| FtrIDRSSum | Future Annual Revenues - Credit (SC) | Num | 19.6 | - | Â | Â | Â |
| FtrICRLSum | Future Revenues - Debit (LC) | Num | 19.6 | - | Â | Â | Â |
| FtrICRSSum | Future Revenues - Debit (SC) | Num | 19.6 | - | Â | Â | Â |
| FtrODRLSum | Future Annual Expenses - Credit (LC) | Num | 19.6 | - | Â | Â | Â |
| FtrOCRLSum | Future Annual Expenses - Debit (LC) | Num | 19.6 | - | Â | Â | Â |
| FtrODRSSum | Future Annual Expenses - Credit (SC) | Num | 19.6 | - | Â | Â | Â |
| FtrOCRSSum | Future Annual Expenses - Debit (SC) | Num | 19.6 | - | Â | Â | Â |
| FinancYear | Start of Fiscal Year | Date | 8 | - | Â | Â | Â |
| Instance | Instance | Int | 11 | OBGS | 1 | Â | Â |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| SCNCounter | SCN Counter | Int | 6 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsId |
| ACCNT_CODE | Yes | AcctCode |
| Â | Â | FinancYear |
| Â | Â | Instance |
| INTER_KEY | No | FatherCode |