|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Bank Statement Header
Table Name: OBNH
Table Description: Bank Statement Header
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| IdNumber | Internal Number | Int | 11 | - | Â | Â | Â |
| ActKey | Bank Account Internal Number | Int | 11 | DSC1 | Â | Â | Â |
| BSNum | Statement Internal Number | Int | 11 | - | Â | Â | Â |
| BSDate | Statement Date | Date | 8 | - | Â | Â | Â |
| Status | Status | VarChar | 1 | - | D | E | Finalized |
| Â | Â | Â | Â | Â | Â | D | Draft |
| Â | Â | Â | Â | Â | Â | O | Old |
| Imported | Imported From File | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| StrtBlncF | Starting Balance (FC) | Num | 19.6 | - | Â | Â | Â |
| EndBlncF | Ending Balance (FC) | Num | 19.6 | - | Â | Â | Â |
| Currency | Currency | nVarChar | 3 | OCRN | Â | Â | Â |
| StrtBlncL | Starting Balance (LC) | Num | 19.6 | - | Â | Â | Â |
| EndBlncL | Ending Balance (LC) | Num | 19.6 | - | Â | Â | Â |
| FileCRC | Bank Statement File Hash | nVarChar | 32 | - | Â | Â | Â |
| StmtGuid | Bank Statement GUID | nVarChar | 32 | - | Â | Â | Â |
| BSFileNum | Bank Statement Number | nVarChar | 50 | - | Â | Â | Â |
| PeriodAbs | Period Abs Entry | Int | 11 | - | Â | Â | Â |
| DfltBPL | Default Branch | Int | 11 | - | Â | Â | Â |
| OrigBSDate | Original Statement Date | Date | 8 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | IdNumber |
| ACT_NUM_DT | Yes | ActKey |
| Â | Â | BSNum |
| Â | Â | BSDate |