|
|
SQL Banking / Bank Statement Header
API Bank Statements / Bank Statement
OBNH - Bank Statement Header Table
Bank Statement BankStatement Object· Table: OBNH
Parent: Bank Statements BankStatements Collection
OBNH SQL Table
House Bank Accounts DSC1 SQL Table
Currency Codes OCRN SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | IdNumber KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| ActKey KEY UNIQUE | Bank Account Internal Number | Int | 11 | DSC1 House Bank Accounts | ACT_NUM_DT | Yes | ||
| BSNum | Statement Internal Number | Int | 11 | |||||
| BSDate | Statement Date | Date | 8 | |||||
| Status | Status | VarChar | E) Finalized D) Draft O) Old | 1 | D | |||
| Imported | Imported From File | VarChar | Y) Yes N) No | 1 | Y | |||
| StrtBlncF | Starting Balance (FC) | Num | 20 | |||||
| EndBlncF | Ending Balance (FC) | Num | 20 | |||||
| Currency | Currency | nVarChar | 3 | OCRN Currency Codes | ||||
| StrtBlncL | Starting Balance (LC) | Num | 20 | |||||
| EndBlncL | Ending Balance (LC) | Num | 20 | |||||
| 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 |
Table relationship map
SELECT statement
SELECT
OBNH.IdNumber AS 'Internal Number',
OBNH.ActKey AS 'Bank Account Internal Number',
OBNH.BSNum AS 'Statement Internal Number',
OBNH.BSDate AS 'Statement Date',
OBNH.Status AS 'Status',
OBNH.Imported AS 'Imported From File',
OBNH.StrtBlncF AS 'Starting Balance (FC)',
OBNH.EndBlncF AS 'Ending Balance (FC)',
OBNH.Currency AS 'Currency',
OBNH.StrtBlncL AS 'Starting Balance (LC)',
OBNH.EndBlncL AS 'Ending Balance (LC)',
OBNH.FileCRC AS 'Bank Statement File Hash',
OBNH.StmtGuid AS 'Bank Statement GUID',
OBNH.BSFileNum AS 'Bank Statement Number',
OBNH.PeriodAbs AS 'Period Abs Entry'
FROM OBNH AS OBNH
Related information
Bank Statement BankStatement Object· Table: OBNH
A data structure related with the BankStatementService holding the bank statement header properties.
Source table: OBNH.
Parent: Bank Statements BankStatements CollectionOBNH SQL Table
House Bank Accounts DSC1 SQL Table
Currency Codes OCRN SQL Table
BankStatements
Object
BankStatement
Collection
Method
Property
Currency
DB
Status
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
