biuan SAP® BUSINESS ONE SDK
API Bank Statements / Bank Statement
OBNH - Bank Statement Header Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
IdNumber KEY UNIQUEInternal NumberInt
11
PRIMARYYes
ActKey KEY UNIQUEBank Account Internal NumberInt
11DSC1
House Bank Accounts
ACT_NUM_DTYes
BSNumStatement Internal NumberInt
11
BSDateStatement DateDate
8
StatusStatusVarChar
E) Finalized
D) Draft
O) Old
1
D
ImportedImported From FileVarChar
Y) Yes
N) No
1
Y
StrtBlncFStarting Balance (FC)Num
20
EndBlncFEnding Balance (FC)Num
20
CurrencyCurrencynVarChar
3OCRN
Currency Codes
StrtBlncLStarting Balance (LC)Num
20
EndBlncLEnding Balance (LC)Num
20
FileCRCBank Statement File HashnVarChar
32
StmtGuidBank Statement GUIDnVarChar
32
BSFileNumBank Statement NumbernVarChar
50
PeriodAbsPeriod Abs EntryInt
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 Collection
OBNH SQL Table

House Bank Accounts DSC1 SQL Table

Currency Codes OCRN SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates