|
|
DTW Banking / Bill of Exchange / Bill of Exchange Transactions
API OBNK / Bank Pages
OBNK - External Bank Statement Received Table
Bank Pages BankPages Object· Table: OBNK
Bank Statement Row BankStatementRow Object· Table: OBNK
Parent: Bank Statement Rows BankStatementRows Collection
Reconciliation Bank Statement Line ReconciliationBankStatementLine Object· Table: OBNK Parent: Reconciliation Bank Statement Lines ReconciliationBankStatementLines Collection
Bill Of Exchange Trans Bank Pages BillOfExchangeTrans_BankPages Object· Table: OBNK 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
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | IdNumber | External Bank Statement No. | Int | 11 | OBNH Bank Statement Header |
|---|---|---|---|---|---|---|---|---|
| AcctCode KEY UNIQUE | Account Number | nVarChar | 15 | OACT G/L Accounts | PRIMARY | Yes | ||
| Sequence | Sequence No. | Int | 11 | 0 | ||||
| AcctName | Account Name | nVarChar | 100 | |||||
| Ref | Reference | nVarChar | 27 | |||||
| DueDate | Due Date | Date | 8 | |||||
| Memo | Details | nVarChar | 127 | |||||
| DebAmount | Debit Amount (FC) | Num | 20 | |||||
| DebAmntCur | Currency for Accounts Payable | nVarChar | 3 | OCRN Currency Codes | ||||
| CredAmnt | Credit Amount (FC) | Num | 20 | |||||
| CredAmntCu | Credit Currency | nVarChar | 3 | OCRN Currency Codes | ||||
| balance | Balance | Num | 20 | |||||
| BankMatch KEY | Reconciliation No. | Int | 11 | MATCH_ID | No | |||
| DataSource | Data Source | VarChar | 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 | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| ExternCode | External Code | nVarChar | 30 | |||||
| CardCode | BP Code | nVarChar | 15 | OCRD Business Partner | ||||
| CardName | BP Name | nVarChar | 100 | |||||
| StatemNo | Statement Number | Int | 11 | |||||
| DocNum | Invoice Document | nVarChar | 27 | |||||
| PaymCreat | Payment Created | VarChar | Y) Yes N) No | 1 | N | |||
| LineStatus | Row Status | VarChar | 1 | |||||
| VisOrder | Visual Order | Int | 11 | |||||
| DocNumType | Doc. No. Source | VarChar | P) Payment Reference No. I) ISR D) Doc Num | 1 | D | |||
| Memo2 | Details 2 | nVarChar | 127 | |||||
| PaymentRef | Payment Reference No. | nVarChar | 27 | |||||
| autoCreate | Manually/Automatically Create | VarChar | M) Manual A) Automatic | 1 | M | |||
| BSLineDate | Bank Statement Entry Date | Date | 8 | |||||
| BSValuDate | Bank Statement Due Date | Date | 8 | |||||
| InOpCode | Internal Bank Operation Code | Int | 11 | OBTC Internal Bank Operation Codes | ||||
| Cleared | Cleared | VarChar | Y) Yes N) No | 1 | N | |||
| OposAct | BP Bank Account | nVarChar | 50 | |||||
| DebAmntLC | Debit Amount (LC) | Num | 20 | |||||
| CredAmntLC | Credit Amount (LC) | Num | 20 | |||||
| ExchngRate | Exchange Rate | Num | 20 | |||||
| BPIBAN | IBAN of the BP Bank Account | nVarChar | 50 | |||||
| Fee | Fee on the Line | Num | 20 | |||||
| PmnPstDate | Payment Posting Date | Date | 8 | |||||
| PmnValDate | Payment Due Date | Date | 8 | |||||
| LnDocDate | Line Document Date | Date | 8 | |||||
| VatAmntLC | VAT Amount (LC) | Num | 20 | |||||
| VatAmntFC | VAT Amount (FC) | Num | 20 | |||||
| JDTID | Journal Entry ID | Int | 11 | OJDT Journal Entry | ||||
| PmntID | Payment ID | Int | 11 | |||||
| ObjCrtType | Document Type | Int | 6 | 24 | ||||
| PstMethod | Posting Method | VarChar | 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 | |||
| FeeAct | G/L Account for Fee | nVarChar | 15 | OACT G/L Accounts | ||||
| FeeProfitC | Fee Distribution Rule | nVarChar | 8 | OOCR Distribution Rule | ||||
| FeeProj | Project Fee | nVarChar | 20 | OPRJ Project Codes | ||||
| BpBankCode | BP Bank Code | nVarChar | 30 | |||||
| FeeProfit2 | Fee Distribution Rule2 | nVarChar | 8 | OOCR Distribution Rule | ||||
| FeeProfit3 | Fee Distribution Rule3 | nVarChar | 8 | OOCR Distribution Rule | ||||
| FeeProfit4 | Fee Distribution Rule4 | nVarChar | 8 | OOCR Distribution Rule | ||||
| FeeProfit5 | Fee Distribution Rule5 | nVarChar | 8 | OOCR Distribution Rule | ||||
| ApplWTSum | Applied WTax Sum | Num | 20 | |||||
| InfoLog | Information Log | nVarChar | 127 | |||||
| LineOrigin | Row Origin | VarChar | R) Regular A) Archive | 1 | R | |||
| BPSwift | BP BIC/SWIFT Code | nVarChar | 50 | |||||
| Source | Source | VarChar | I) Imported A) Imported and Amended M) Manually Entered | 1 | I | |||
| PayOrderNo | Payment Order Number | Int | 11 | |||||
| TaxIDNum | Federal Tax ID | nVarChar | 32 | |||||
| PONumber | External Payment Order Number | Int | 11 | |||||
| FormatName | Format Name for Bank Statement | nVarChar | 127 | |||||
| FileCRC | Bank Statement File Hash Code | nVarChar | 32 | |||||
| FolioPref | Folio Prefix String | nVarChar | 4 | |||||
| FolioNum | Folio Number | Int | 11 | |||||
| BPLIdPmn | Branch for Payment ID | Int | 11 | OBPL Business Place | ||||
| BPAcctName | BP Bank Account Name | nVarChar | 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 CollectionReconciliation 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 CollectionBill 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
BankPages
Method
Property
AccountCode
DTW DB
AccountName
DB
BankMatch
DB
BICSwiftCode
DB
CardCode
DTW DB
CardName
DTW DB
CreditAmount
DTW DB
DebitAmount
DTW DB
DocNumberType
DTW DB
DueDate
DTW DB
ExternalCode
DTW DB
InvoiceNumber
DTW DB
Memo
DTW DB
PaymentCreated
DTW DB
PaymentReference
DTW DB
Reference
DTW DB
Sequence
DTW DB
StatementNumber
DTW DB
VisualOrder
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
