biuan SAP® BUSINESS ONE SDK
DTW Banking / Bill of Exchange / Bill of Exchange Transactions
API OBNK / Bank Pages
OBNK - External Bank Statement Received Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
IdNumberExternal Bank Statement No.Int
11OBNH
Bank Statement Header
AcctCode KEY UNIQUEAccount NumbernVarChar
15OACT
G/L Accounts
PRIMARYYes
SequenceSequence No.Int
11
0
AcctNameAccount NamenVarChar
100
RefReferencenVarChar
27
DueDateDue DateDate
8
MemoDetailsnVarChar
127
DebAmountDebit Amount (FC)Num
20
DebAmntCurCurrency for Accounts PayablenVarChar
3OCRN
Currency Codes
CredAmntCredit Amount (FC)Num
20
CredAmntCuCredit CurrencynVarChar
3OCRN
Currency Codes
balanceBalanceNum
20
BankMatch KEYReconciliation No.Int
11
MATCH_IDNo
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser SignatureInt
6OUSR
Users
ExternCodeExternal CodenVarChar
30
CardCodeBP CodenVarChar
15OCRD
Business Partner
CardNameBP NamenVarChar
100
StatemNoStatement NumberInt
11
DocNumInvoice DocumentnVarChar
27
PaymCreatPayment CreatedVarChar
Y) Yes
N) No
1
N
LineStatusRow StatusVarChar
1
VisOrderVisual OrderInt
11
DocNumTypeDoc. No. SourceVarChar
P) Payment Reference No.
I) ISR
D) Doc Num
1
D
Memo2Details 2nVarChar
127
PaymentRefPayment Reference No.nVarChar
27
autoCreateManually/Automatically CreateVarChar
M) Manual
A) Automatic
1
M
BSLineDateBank Statement Entry DateDate
8
BSValuDateBank Statement Due DateDate
8
InOpCodeInternal Bank Operation CodeInt
11OBTC
Internal Bank Operation Codes
ClearedClearedVarChar
Y) Yes
N) No
1
N
OposActBP Bank AccountnVarChar
50
DebAmntLCDebit Amount (LC)Num
20
CredAmntLCCredit Amount (LC)Num
20
ExchngRateExchange RateNum
20
BPIBANIBAN of the BP Bank AccountnVarChar
50
FeeFee on the LineNum
20
PmnPstDatePayment Posting DateDate
8
PmnValDatePayment Due DateDate
8
LnDocDateLine Document DateDate
8
VatAmntLCVAT Amount (LC)Num
20
VatAmntFCVAT Amount (FC)Num
20
JDTIDJournal Entry IDInt
11OJDT
Journal Entry
PmntIDPayment IDInt
11
ObjCrtTypeDocument TypeInt
6
24
PstMethodPosting MethodVarChar
A) G/L Account from/to Bank Account
C) BP from/to Bank Account
J) Interim Account from/to Bank Account
E) External Reconciliation
I) Ignore
1
C
FeeActG/L Account for FeenVarChar
15OACT
G/L Accounts
FeeProfitCFee Distribution RulenVarChar
8OOCR
Distribution Rule
FeeProjProject FeenVarChar
20OPRJ
Project Codes
BpBankCodeBP Bank CodenVarChar
30
FeeProfit2Fee Distribution Rule2nVarChar
8OOCR
Distribution Rule
FeeProfit3Fee Distribution Rule3nVarChar
8OOCR
Distribution Rule
FeeProfit4Fee Distribution Rule4nVarChar
8OOCR
Distribution Rule
FeeProfit5Fee Distribution Rule5nVarChar
8OOCR
Distribution Rule
ApplWTSumApplied WTax SumNum
20
InfoLogInformation LognVarChar
127
LineOriginRow OriginVarChar
R) Regular
A) Archive
1
R
BPSwiftBP BIC/SWIFT CodenVarChar
50
SourceSourceVarChar
I) Imported
A) Imported and Amended
M) Manually Entered
1
I
PayOrderNoPayment Order NumberInt
11
TaxIDNumFederal Tax IDnVarChar
32
PONumberExternal Payment Order NumberInt
11
FormatNameFormat Name for Bank StatementnVarChar
127
FileCRCBank Statement File Hash CodenVarChar
32
FolioPrefFolio Prefix StringnVarChar
4
FolioNumFolio NumberInt
11
BPLIdPmnBranch for Payment IDInt
11OBPL
Business Place
BPAcctNameBP Bank Account NamenVarChar
127

Table relationship map

SELECT statement

SELECT OBNK.IdNumber AS 'External Bank Statement No.', OBNK.AcctCode AS 'Account Number', OBNK.Sequence AS 'Sequence No.', OBNK.AcctName AS 'Account Name', OBNK.Ref AS 'Reference', OBNK.DueDate AS 'Due Date', OBNK.Memo AS 'Details', OBNK.DebAmount AS 'Debit Amount (FC)', OBNK.DebAmntCur AS 'Currency for Accounts Payable', OBNK.CredAmnt AS 'Credit Amount (FC)', OBNK.CredAmntCu AS 'Credit Currency', OBNK.balance AS 'Balance', OBNK.BankMatch AS 'Reconciliation No.', OBNK.DataSource AS 'Data Source', OBNK.UserSign AS 'User Signature', OBNK.ExternCode AS 'External Code', OBNK.CardCode AS 'BP Code', OBNK.CardName AS 'BP Name', OBNK.StatemNo AS 'Statement Number', OBNK.DocNum AS 'Invoice Document', OBNK.PaymCreat AS 'Payment Created', OBNK.LineStatus AS 'Row Status', OBNK.VisOrder AS 'Visual Order', OBNK.DocNumType AS 'Doc. No. Source', OBNK.Memo2 AS 'Details 2', OBNK.PaymentRef AS 'Payment Reference No.', OBNK.autoCreate AS 'Manually/Automatically Create', OBNK.BSLineDate AS 'Bank Statement Entry Date', OBNK.BSValuDate AS 'Bank Statement Due Date', OBNK.InOpCode AS 'Internal Bank Operation Code', OBNK.Cleared AS 'Cleared', OBNK.OposAct AS 'BP Bank Account', OBNK.DebAmntLC AS 'Debit Amount (LC)', OBNK.CredAmntLC AS 'Credit Amount (LC)', OBNK.ExchngRate AS 'Exchange Rate', OBNK.BPIBAN AS 'IBAN of the BP Bank Account', OBNK.Fee AS 'Fee on the Line', OBNK.PmnPstDate AS 'Payment Posting Date', OBNK.PmnValDate AS 'Payment Due Date', OBNK.LnDocDate AS 'Line Document Date', OBNK.VatAmntLC AS 'VAT Amount (LC)', OBNK.VatAmntFC AS 'VAT Amount (FC)', OBNK.JDTID AS 'Journal Entry ID', OBNK.PmntID AS 'Payment ID', OBNK.ObjCrtType AS 'Document Type', OBNK.PstMethod AS 'Posting Method', OBNK.FeeAct AS 'G/L Account for Fee', OBNK.FeeProfitC AS 'Fee Distribution Rule', OBNK.FeeProj AS 'Project Fee', OBNK.BpBankCode AS 'BP Bank Code', OBNK.FeeProfit2 AS 'Fee Distribution Rule2', OBNK.FeeProfit3 AS 'Fee Distribution Rule3', OBNK.FeeProfit4 AS 'Fee Distribution Rule4', OBNK.FeeProfit5 AS 'Fee Distribution Rule5', OBNK.ApplWTSum AS 'Applied WTax Sum', OBNK.InfoLog AS 'Information Log', OBNK.LineOrigin AS 'Row Origin', OBNK.BPSwift AS 'BP BIC/SWIFT Code', OBNK.Source AS 'Source', OBNK.PayOrderNo AS 'Payment Order Number', OBNK.TaxIDNum AS 'Federal Tax ID', OBNK.PONumber AS 'External Payment Order Number', OBNK.FormatName AS 'Format Name for Bank Statement', OBNK.FileCRC AS 'Bank Statement File Hash Code', OBNK.FolioPref AS 'Folio Prefix String', OBNK.FolioNum AS 'Folio Number', OBNK.BPLIdPmn AS 'Branch for Payment ID', OBNK.BPAcctName AS 'BP Bank Account Name' FROM OBNK AS OBNK

Related information


Bank Pages BankPages Object· Table: OBNK
BankPages is a business object that represents external bank statements in the Banking module. This object enables you to: Add bank statements. Retrieve a bank statement by its key. Update bank statements. Save the object in XML format....


Bank Statement Row BankStatementRow Object· Table: OBNK
A data structure related to the BankStatementService holding the properties of a bank statement line. Access this object via BankStatement.BankStatementRows.  Source table: OBNK
   Parent: Bank Statement Rows BankStatementRows Collection

Reconciliation Bank Statement Line ReconciliationBankStatementLine Object· Table: OBNK
Represents open transactions to be reconciled in external bank statement. ReconciliationBankStatementLine is a child object of the ExternalReconciliation object. Source table: OBNK.
   Parent: Reconciliation Bank Statement Lines ReconciliationBankStatementLines Collection

Bill Of Exchange Trans Bank Pages BillOfExchangeTrans_BankPages Object· Table: OBNK
For internal use.
   Parent: Bill Of Exchange Transaction BillOfExchangeTransaction Object· Table: OBOT
G/L Accounts OACT SQL Table

Business Place OBPL SQL Table

Business Partner OCRD SQL Table

Currency Codes OCRN SQL Table

Distribution Rule OOCR SQL Table

Project Codes OPRJ SQL Table

Bank Statement Header OBNH SQL Table

Internal Bank Operation Codes OBTC SQL Table

Journal Entry OJDT SQL Table

Users OUSR SQL Table



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