biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Banking / Banks
API ODSC / / Banks
ODSC - Bank Codes Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
BankCodeBank CodenVarChar
30
BankNameBank NamenVarChar
127
DfltAcctAccount for Outgoing ChecksnVarChar
50
DfltBranchBranch for Outgoing ChecksnVarChar
50
NextChckNoNext Check NumberInt
11
LockedLockedVarChar
N) Changeable
Y) Locked
1
N
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser SignatureInt
6OUSR
Users
SwiftNumBIC/SWIFT CodenVarChar
50
IBANIBANnVarChar
50
CountryCod KEY UNIQUECountry CodenVarChar
3OCRY
Countries
SECONDARYYes
PostOfficePost OfficeVarChar
Y) Yes
N) No
1
N
AliasNameAlias NamenVarChar
50
AbsEntry KEY UNIQUEAbsolute entryInt
11
PRIMARYYes
DfltActKeyDefault Bank Account KeyInt
11DSC1
House Bank Accounts
NextNumOur Number in Next BoletoInt
11
BsPstDatePosting Date DefinitionVarChar
S) Statement Date
L) Row Date
V) Due Date
C) Current Date
1
C
BsValDateDue Date DefinitionVarChar
S) Statement Date
L) Row Date
V) Due Date
C) Current Date
1
C
BnkOpCodeBank Operation Code ListInt
11OBOC
External Bank Operation Code Category
BsDocDateDocument Date DefinitionVarChar
S) Statement Date
L) Row Date
V) Due Date
C) Current Date
1
C

Table relationship map

SELECT statement

SELECT ODSC.BankCode AS 'Bank Code', ODSC.BankName AS 'Bank Name', ODSC.DfltAcct AS 'Account for Outgoing Checks', ODSC.DfltBranch AS 'Branch for Outgoing Checks', ODSC.NextChckNo AS 'Next Check Number', ODSC.Locked AS 'Locked', ODSC.DataSource AS 'Data Source', ODSC.UserSign AS 'User Signature', ODSC.SwiftNum AS 'BIC/SWIFT Code', ODSC.IBAN AS 'IBAN', ODSC.CountryCod AS 'Country Code', ODSC.PostOffice AS 'Post Office', ODSC.AliasName AS 'Alias Name', ODSC.AbsEntry AS 'Absolute entry', ODSC.DfltActKey AS 'Default Bank Account Key', ODSC.NextNum AS 'Our Number in Next Boleto', ODSC.BsPstDate AS 'Posting Date Definition', ODSC.BsValDate AS 'Due Date Definition', ODSC.BnkOpCode AS 'Bank Operation Code List', ODSC.BsDocDate AS 'Document Date Definition' FROM ODSC AS ODSC

Related information


Banks Banks Object· Table: ODSC
The Banks object enables to define banks, which can be used by the HouseBankAccounts and BPBankAccounts objects. Source table: ODSC.

ODSC SQL Table

External Bank Operation Code Category OBOC SQL Table

Countries OCRY SQL Table

Users OUSR 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