|
|
API BNK2
BNK2 - Bank Statement - Recommendation List Table
Business Place OBPL SQL Table
G/L Accounts OACT SQL Table
Journal Entry OJDT SQL Table
Distribution Rule OOCR SQL Table
Project Codes OPRJ SQL Table
Tax Definition OVTG SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | IdNumber KEY UNIQUE | Bank Statement ID | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| BSLine | Bank Statement Line ID | Int | 11 | |||||
| ListLineID | List Line ID | Int | 6 | |||||
| DocID | Document Identifier | nVarChar | 27 | |||||
| DocType | Document Type | Int | 15) Delivery 16) Returns 203) A/R Down Payment 13) A/R Invoice 14) A/R Credit Memo 132) Correction Invoice 20) Goods Receipt PO 21) Goods Returns 204) A/P Down Payment 18) A/P Invoice 19) A/P Credit Memo 24) Incoming Payment 25) Deposit 46) Payment Advice 57) Checks for Payment 76) Postdated Deposit -2) Opening Balance -3) Closing Balance 30) Journal Entry 58) Whse Reconciliation 59) Goods Receipt 60) Goods Issue 67) Inventory Transfers -1) All transactions | 6 | ||||
| AmntLC | Applied Amount (LC) | Num | 20 | |||||
| AmntFC | Applied Amount (FC) | Num | 20 | |||||
| IsDebit | Debit [Yes/No] | VarChar | Y) Yes N) No | 1 | Y | |||
| GLAct | G/L Account or BP Code | nVarChar | 15 | OACT G/L Accounts | ||||
| PrftCenter | Distribution Rule | nVarChar | 8 | OOCR Distribution Rule | ||||
| Project | Project | nVarChar | 20 | OPRJ Project Codes | ||||
| VatCode | VAT Code | nVarChar | 8 | OVTG Tax Definition | ||||
| Selected | Selected | VarChar | Y) Yes N) No | 1 | ||||
| VatLC | VAT or Discount Amount (LC) | Num | 20 | |||||
| VatFC | VAT or Discount Amount (FC) | Num | 20 | |||||
| Installmnt | Installment | Int | 11 | |||||
| InterimAct | Interim Account | nVarChar | 15 | OACT G/L Accounts | ||||
| JdtLine | Journal Entry | Int | 11 | OJDT Journal Entry | ||||
| DocNum | Document Number | Int | 11 | |||||
| PrftCent2 | Distribution Rule2 | nVarChar | 8 | OOCR Distribution Rule | ||||
| PrftCent3 | Distribution Rule3 | nVarChar | 8 | OOCR Distribution Rule | ||||
| PrftCent4 | Distribution Rule4 | nVarChar | 8 | OOCR Distribution Rule | ||||
| PrftCent5 | Distribution Rule5 | nVarChar | 8 | OOCR Distribution Rule | ||||
| MatchLog | Matching Criteria Log | nVarChar | 127 | |||||
| DueBal | Balance Due | Num | 20 | |||||
| DueBalFC | Balance Due (FC) | Num | 20 | |||||
| AmntSC | Applied Amount (SC) | Num | 20 | |||||
| BPLId | Branch ID | Int | 11 | OBPL Business Place | ||||
| BPLName | Branch Name | nVarChar | 100 |
Table relationship map
SELECT statement
SELECT
BNK2.IdNumber AS 'Bank Statement ID',
BNK2.BSLine AS 'Bank Statement Line ID',
BNK2.ListLineID AS 'List Line ID',
BNK2.DocID AS 'Document Identifier',
BNK2.DocType AS 'Document Type',
BNK2.AmntLC AS 'Applied Amount (LC)',
BNK2.AmntFC AS 'Applied Amount (FC)',
BNK2.IsDebit AS 'Debit [Yes/No]',
BNK2.GLAct AS 'G/L Account or BP Code',
BNK2.PrftCenter AS 'Distribution Rule',
BNK2.Project AS 'Project',
BNK2.VatCode AS 'VAT Code',
BNK2.Selected AS 'Selected',
BNK2.VatLC AS 'VAT or Discount Amount (LC)',
BNK2.VatFC AS 'VAT or Discount Amount (FC)',
BNK2.Installmnt AS 'Installment',
BNK2.InterimAct AS 'Interim Account',
BNK2.JdtLine AS 'Journal Entry',
BNK2.DocNum AS 'Document Number',
BNK2.PrftCent2 AS 'Distribution Rule2',
BNK2.PrftCent3 AS 'Distribution Rule3',
BNK2.PrftCent4 AS 'Distribution Rule4',
BNK2.PrftCent5 AS 'Distribution Rule5',
BNK2.MatchLog AS 'Matching Criteria Log',
BNK2.DueBal AS 'Balance Due',
BNK2.DueBalFC AS 'Balance Due (FC)',
BNK2.AmntSC AS 'Applied Amount (SC)',
BNK2.BPLId AS 'Branch ID',
BNK2.BPLName AS 'Branch Name'
FROM BNK2 AS BNK2
Related information
Business Place OBPL SQL Table
G/L Accounts OACT SQL Table
Journal Entry OJDT SQL Table
Distribution Rule OOCR SQL Table
Project Codes OPRJ SQL Table
Tax Definition OVTG SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
