📚 SAP Business One SDK Help

Table Name: BNK2

Table Description: Bank Statement - Recommendation List

Field Description Type Size Related Default Value Constraints
IdNumber Bank Statement ID Int 11 -      
BSLine Bank Statement Line ID Int 11 -      
ListLineID List Line ID Int 6 -      
DocID Document Identifier nVarChar 35 -      
DocType Document Type Int 6 -   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
AmntLC Applied Amount (LC) Num 19.6 -      
AmntFC Applied Amount (FC) Num 19.6 -      
IsDebit Debit [Yes/No] VarChar 1 - Y Y Yes
            N No
GLAct G/L Account or BP Code nVarChar 15 OACT      
PrftCenter Distribution Rule nVarChar 8 OOCR      
Project Project nVarChar 20 OPRJ      
VatCode VAT Code nVarChar 8 OVTG      
Selected Selected VarChar 1 -   Y Yes
            N No
VatLC VAT or Discount Amount (LC) Num 19.6 -      
VatFC VAT or Discount Amount (FC) Num 19.6 -      
Installmnt Installment Int 11 -      
InterimAct Interim Account nVarChar 15 OACT      
JdtLine Journal Entry Int 11 OJDT      
DocNum Document Number Int 11 -      
PrftCent2 Distribution Rule2 nVarChar 8 OOCR      
PrftCent3 Distribution Rule3 nVarChar 8 OOCR      
PrftCent4 Distribution Rule4 nVarChar 8 OOCR      
PrftCent5 Distribution Rule5 nVarChar 8 OOCR      
MatchLog Matching Criteria Log nVarChar 254 -      
DueBal Balance Due Num 19.6 -      
DueBalFC Balance Due (FC) Num 19.6 -      
AmntSC Applied Amount (SC) Num 19.6 -      
BPLId Branch ID Int 11 OBPL      
BPLName Branch Name nVarChar 200 -      
Key Unique Field
PRIMARY Yes IdNumber
    BSLine
    ListLineID