biuan SAP® BUSINESS ONE SDK
API BNK2
BNK2 - Bank Statement - Recommendation List Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
IdNumber KEY UNIQUEBank Statement IDInt
11
PRIMARYYes
BSLineBank Statement Line IDInt
11
ListLineIDList Line IDInt
6
DocIDDocument IdentifiernVarChar
27
DocTypeDocument TypeInt
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
AmntLCApplied Amount (LC)Num
20
AmntFCApplied Amount (FC)Num
20
IsDebitDebit [Yes/No]VarChar
Y) Yes
N) No
1
Y
GLActG/L Account or BP CodenVarChar
15OACT
G/L Accounts
PrftCenterDistribution RulenVarChar
8OOCR
Distribution Rule
ProjectProjectnVarChar
20OPRJ
Project Codes
VatCodeVAT CodenVarChar
8OVTG
Tax Definition
SelectedSelectedVarChar
Y) Yes
N) No
1
VatLCVAT or Discount Amount (LC)Num
20
VatFCVAT or Discount Amount (FC)Num
20
InstallmntInstallmentInt
11
InterimActInterim AccountnVarChar
15OACT
G/L Accounts
JdtLineJournal EntryInt
11OJDT
Journal Entry
DocNumDocument NumberInt
11
PrftCent2Distribution Rule2nVarChar
8OOCR
Distribution Rule
PrftCent3Distribution Rule3nVarChar
8OOCR
Distribution Rule
PrftCent4Distribution Rule4nVarChar
8OOCR
Distribution Rule
PrftCent5Distribution Rule5nVarChar
8OOCR
Distribution Rule
MatchLogMatching Criteria LognVarChar
127
DueBalBalance DueNum
20
DueBalFCBalance Due (FC)Num
20
AmntSCApplied Amount (SC)Num
20
BPLIdBranch IDInt
11OBPL
Business Place
BPLNameBranch NamenVarChar
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



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