biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Banking / House Bank Accounts
API DSC1 / House Bank Accounts
DSC1 - House Bank Accounts Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
BankCodeBank CodenVarChar
30
AccountAcct No.nVarChar
50
BranchBranchnVarChar
50
NextCheckNext Check No.Int
11
GLAccountG/L AccountnVarChar
15OACT
G/L Accounts
FreeFreeVarChar
1
StreetStreetnVarChar
100
BlockBlocknVarChar
100
ZipCodeZip CodenVarChar
20
CityCitynVarChar
100
CountyCountynVarChar
100
Country KEY UNIQUECountrynVarChar
3OCRY
Countries
SECONDARYYes
StateStatenVarChar
3OCST
States
BISRBISRVarChar
Y) Yes
N) No
1
N
ControlKeyControl KeynVarChar
2
UsrNumber1User No. 1nVarChar
25
UsrNumber2User No. 2nVarChar
25
UsrNumber3User No. 3nVarChar
25
UsrNumber4User No. 4nVarChar
25
IBANIBANnVarChar
50
DscountBOEDebt of Discounted BoEnVarChar
15OACT
G/L Accounts
TolrnceDayTolerance DaysInt
11
MinAmntBOEMin. Amount of Bill of ExchangeNum
20
MaxAmntBOEMax. Amount of Bill of ExchangeNum
20
DscntLimitDiscount LimitNum
20
DaysInAdvaDays in AdvanceInt
11
BankCollecBank on CollectionnVarChar
15OACT
G/L Accounts
BankDiscouBank on DiscountednVarChar
15OACT
G/L Accounts
BranchNameBranch NamenVarChar
50
AliasNameAlias NamenVarChar
50
CompanyCodCompany CodenVarChar
10
AcctTypeAccount TypeVarChar
1
BuildingBuilding/Floor/RoomText
16
BIKBIKnVarChar
15
AcctNameBank Account NamenVarChar
127
CorresAcctCorrespondent AccountnVarChar
30
PhoneTelephone No.nVarChar
25
FaxFaxnVarChar
25
GLIntriActG/L Interim AccountnVarChar
15OACT
G/L Accounts
ChkPaperPaper TypeVarChar
B) Blank Paper
S) Overflow Prenumbered Check Stock
P) Overflow Blank Paper
D) Default
1
D
MaxChkLineMaximum LinesInt
6
TmpltNameTemplate NamenVarChar
8
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
BankKeyBank Internal IDInt
11ODSC
Bank Codes
LockChkLock Checks PrintingVarChar
Y) Yes
N) No
1
N
OurNumOur Number in Next BoletoInt
11
AgreeNumAgreement NumbernVarChar
10
AccountChkAccount Check DigitVarChar
1
ISRTypeISR TypeInt
1) ISR
2) BISR
3) ISR+
4) BISR+
6
2
ISRBillerIISR Biller IDnVarChar
9
CustIdNumCustomer ID NumbernVarChar
6
0
InSeriIncoming Payment SeriesInt
6NNM1
Documents Numbering - Series
-1
OutSeriOutgoing Payment SeriesInt
6NNM1
Documents Numbering - Series
-1
JDTSeriJournal Entry SeriesInt
6NNM1
Documents Numbering - Series
-1
FilePlugImport File NamenVarChar
50
ImpStmtImported Bank StatementVarChar
Y) Create New - From File
N) Create New - Manually
1
N
PreNumberPrenumbered CheckVarChar
Y) Yes
N) No
1
Y
AddrTypeAddress TypenVarChar
100
StreetNoStreet No.nVarChar
100
LogInstancLog InstanceInt
11
0
UpdateDateDate of UpdateDate
8
UsrLogSignUser SignatureInt
6OUSR
Users
UserSign2Updating UserInt
6OUSR
Users
SwiftNumBIC/SWIFT CodenVarChar
50
FineAcctFine AccountnVarChar
15OACT
G/L Accounts
IntrstAcctInterest AccountnVarChar
15OACT
G/L Accounts
DscntAcctDiscount AccountnVarChar
15OACT
G/L Accounts
SvcFeeAcctService Fee AccountnVarChar
15OACT
G/L Accounts
BranchChkBranch Check DigitnVarChar
5
RetFileRetorno File FormatnVarChar
50
IOFTaxAcctIOF Tax AccountnVarChar
15
OthExpAcctOther Expenses AccountnVarChar
15OACT
G/L Accounts
OthIncAcctOther Incomes AccountnVarChar
15OACT
G/L Accounts
CollCodeCollection CodenVarChar
50
FileSeqNNoFile Sequence Next NumberInt
11

Table relationship map

SELECT statement

SELECT DSC1.BankCode AS 'Bank Code', DSC1.Account AS 'Acct No.', DSC1.Branch AS 'Branch', DSC1.NextCheck AS 'Next Check No.', DSC1.GLAccount AS 'G/L Account', DSC1.Free AS 'Free', DSC1.Street AS 'Street', DSC1.Block AS 'Block', DSC1.ZipCode AS 'Zip Code', DSC1.City AS 'City', DSC1.County AS 'County', DSC1.Country AS 'Country', DSC1.State AS 'State', DSC1.BISR AS 'BISR', DSC1.ControlKey AS 'Control Key', DSC1.UsrNumber1 AS 'User No. 1', DSC1.UsrNumber2 AS 'User No. 2', DSC1.UsrNumber3 AS 'User No. 3', DSC1.UsrNumber4 AS 'User No. 4', DSC1.IBAN AS 'IBAN', DSC1.DscountBOE AS 'Debt of Discounted BoE', DSC1.TolrnceDay AS 'Tolerance Days', DSC1.MinAmntBOE AS 'Min. Amount of Bill of Exchange', DSC1.MaxAmntBOE AS 'Max. Amount of Bill of Exchange', DSC1.DscntLimit AS 'Discount Limit', DSC1.DaysInAdva AS 'Days in Advance', DSC1.BankCollec AS 'Bank on Collection', DSC1.BankDiscou AS 'Bank on Discounted', DSC1.BranchName AS 'Branch Name', DSC1.AliasName AS 'Alias Name', DSC1.CompanyCod AS 'Company Code', DSC1.AcctType AS 'Account Type', DSC1.Building AS 'Building/Floor/Room', DSC1.BIK AS 'BIK', DSC1.AcctName AS 'Bank Account Name', DSC1.CorresAcct AS 'Correspondent Account', DSC1.Phone AS 'Telephone No.', DSC1.Fax AS 'Fax', DSC1.GLIntriAct AS 'G/L Interim Account', DSC1.ChkPaper AS 'Paper Type', DSC1.MaxChkLine AS 'Maximum Lines', DSC1.TmpltName AS 'Template Name', DSC1.AbsEntry AS 'Internal Number', DSC1.BankKey AS 'Bank Internal ID', DSC1.LockChk AS 'Lock Checks Printing', DSC1.OurNum AS 'Our Number in Next Boleto', DSC1.AgreeNum AS 'Agreement Number', DSC1.AccountChk AS 'Account Check Digit', DSC1.ISRType AS 'ISR Type', DSC1.ISRBillerI AS 'ISR Biller ID', DSC1.CustIdNum AS 'Customer ID Number', DSC1.InSeri AS 'Incoming Payment Series', DSC1.OutSeri AS 'Outgoing Payment Series', DSC1.JDTSeri AS 'Journal Entry Series', DSC1.FilePlug AS 'Import File Name', DSC1.ImpStmt AS 'Imported Bank Statement', DSC1.PreNumber AS 'Prenumbered Check', DSC1.AddrType AS 'Address Type', DSC1.StreetNo AS 'Street No.', DSC1.LogInstanc AS 'Log Instance', DSC1.UpdateDate AS 'Date of Update', DSC1.UsrLogSign AS 'User Signature', DSC1.UserSign2 AS 'Updating User', DSC1.SwiftNum AS 'BIC/SWIFT Code', DSC1.FineAcct AS 'Fine Account', DSC1.IntrstAcct AS 'Interest Account', DSC1.DscntAcct AS 'Discount Account', DSC1.SvcFeeAcct AS 'Service Fee Account', DSC1.BranchChk AS 'Branch Check Digit', DSC1.RetFile AS 'Retorno File Format', DSC1.IOFTaxAcct AS 'IOF Tax Account', DSC1.OthExpAcct AS 'Other Expenses Account', DSC1.OthIncAcct AS 'Other Incomes Account', DSC1.CollCode AS 'Collection Code', DSC1.FileSeqNNo AS 'File Sequence Next Number' FROM DSC1 AS DSC1

Related information


House Bank Accounts HouseBankAccounts Object· Table: DSC1
The HouseBankAccounts object enables to define the company bank accounts. Source table: DSC1.

DSC1 SQL Table

G/L Accounts OACT SQL Table

Countries OCRY SQL Table

Documents Numbering - Series NNM1 SQL Table

States OCST 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