📚 SAP Business One SDK Help

Table Name: OCRB

Table Description: BP - Bank Account

Field Description Type Size Related Default Value Constraints
AbsEntry Internal Key Int 11 -      
CardCode BP Code nVarChar 15 OCRD      
BankCode Bank Code nVarChar 30 -      
Country Country/Region nVarChar 3 OCRY      
Account Account No. nVarChar 50 -      
Branch Branch nVarChar 50 -      
Street Street nVarChar 100 -      
Block Block nVarChar 100 -      
ZipCode Zip Code nVarChar 20 -      
City City nVarChar 100 -      
County County nVarChar 100 -      
State State nVarChar 3 -      
ControlKey Ctrl Int. ID nVarChar 2 -      
UsrNumber1 User No. 1 nVarChar 25 -      
UsrNumber2 User No. 2 nVarChar 25 -      
UsrNumber3 User No. 3 nVarChar 25 -      
UsrNumber4 User No. 4 nVarChar 25 -      
IBAN IBAN nVarChar 50 -      
LogInstanc Log Instance Int 11 - 0    
Building Building/Floor/Room Text 16 -      
AliasName Alias Name nVarChar 50 -      
AcctType Account Type VarChar 1 -      
BankKey Bank Internal ID Int 11 ODSC      
BIK BIK nVarChar 15 -      
AcctName Bank Account Name nVarChar 250 -      
CorresAcct Correspondent Account nVarChar 30 -      
Phone Phone nVarChar 50 -      
Fax Fax nVarChar 50 -      
ISRType ISR Type Int 6 - 2 1 ISR
            2 BISR
            3 ISR+
            4 BISR+
ISRBillerI ISR Biller ID nVarChar 9 -      
CustIdNum Customer ID Number nVarChar 6 - 0    
AddrType Address Type nVarChar 100 -      
StreetNo Street No. nVarChar 100 -      
SwiftNum BIC/SWIFT Code nVarChar 50 -      
ABARoutNum ABA Routing Number nVarChar 25 -      
MandateID Mandate ID nVarChar 35 -      
SignDate Date of Signature Date 8 -      
PWZAbsEntr PWZ ABS Entry Int 11 OPWZ      
BranchChk Branch Check Digit nVarChar 5 -      
MandatDate Date Of Mandate Expiration Date 8 -      
SeqType SEPA Seq. Type nVarChar 4 -   OOFF OOFF
            FRST FRST
            RCUR RCUR
            FNAL FNAL
ActType Account Type VarChar 1 -   C Checking Account
            S Savings Account
IsPrenot Is Prenotification VarChar 1 - N Y Yes
            N No
EnAccount Encryption of Account Text 16 -      
EnIBAN Encryption of IBAN Text 16 -      
EncryptIV Encrypt IV nVarChar 100 -      
Key Unique Field
PRIMARY Yes Country
    BankCode
    Account
    CardCode
ABSENTRY Yes AbsEntry