biuan SAP® BUSINESS ONE SDK
SQL Banking / Bank Statement - Documents List
API Multiple Payments / Multiple Payment
BNK1 - Bank Statement - Documents 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
AmntLCAmount (LC)Num
20
AmnFCAmount (FC)Num
20
IsDebitDebit [Yes/No]VarChar
Y) Yes
N) No
1
Y

SELECT statement

SELECT BNK1.IdNumber AS 'Bank Statement ID', BNK1.BSLine AS 'Bank Statement Line ID', BNK1.ListLineID AS 'List Line ID', BNK1.DocID AS 'Document Identifier', BNK1.AmntLC AS 'Amount (LC)', BNK1.AmnFC AS 'Amount (FC)', BNK1.IsDebit AS 'Debit [Yes/No]' FROM BNK1 AS BNK1

Related information


Multiple Payment MultiplePayment Object· Table: BNK1
A data structure related to BankStatementService holding properties for a multiple payment on a bank statement line. Source table: BNK1.
   Parent: Multiple Payments MultiplePayments Collection
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