|
|
SQL Banking / House Bank Accounts
DTW Administration / Setup / Banking / House Bank Accounts
API DSC1 / House Bank Accounts
DSC1 - House Bank Accounts Table
House Bank Accounts HouseBankAccounts Object· 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
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | BankCode | Bank Code | nVarChar | 30 |
|---|---|---|---|---|---|---|---|---|
| Account | Acct No. | nVarChar | 50 | |||||
| Branch | Branch | nVarChar | 50 | |||||
| NextCheck | Next Check No. | Int | 11 | |||||
| GLAccount | G/L Account | nVarChar | 15 | OACT G/L Accounts | ||||
| Free | Free | VarChar | 1 | |||||
| Street | Street | nVarChar | 100 | |||||
| Block | Block | nVarChar | 100 | |||||
| ZipCode | Zip Code | nVarChar | 20 | |||||
| City | City | nVarChar | 100 | |||||
| County | County | nVarChar | 100 | |||||
| Country KEY UNIQUE | Country | nVarChar | 3 | OCRY Countries | SECONDARY | Yes | ||
| State | State | nVarChar | 3 | OCST States | ||||
| BISR | BISR | VarChar | Y) Yes N) No | 1 | N | |||
| ControlKey | Control Key | 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 | |||||
| DscountBOE | Debt of Discounted BoE | nVarChar | 15 | OACT G/L Accounts | ||||
| TolrnceDay | Tolerance Days | Int | 11 | |||||
| MinAmntBOE | Min. Amount of Bill of Exchange | Num | 20 | |||||
| MaxAmntBOE | Max. Amount of Bill of Exchange | Num | 20 | |||||
| DscntLimit | Discount Limit | Num | 20 | |||||
| DaysInAdva | Days in Advance | Int | 11 | |||||
| BankCollec | Bank on Collection | nVarChar | 15 | OACT G/L Accounts | ||||
| BankDiscou | Bank on Discounted | nVarChar | 15 | OACT G/L Accounts | ||||
| BranchName | Branch Name | nVarChar | 50 | |||||
| AliasName | Alias Name | nVarChar | 50 | |||||
| CompanyCod | Company Code | nVarChar | 10 | |||||
| AcctType | Account Type | VarChar | 1 | |||||
| Building | Building/Floor/Room | Text | 16 | |||||
| BIK | BIK | nVarChar | 15 | |||||
| AcctName | Bank Account Name | nVarChar | 127 | |||||
| CorresAcct | Correspondent Account | nVarChar | 30 | |||||
| Phone | Telephone No. | nVarChar | 25 | |||||
| Fax | Fax | nVarChar | 25 | |||||
| GLIntriAct | G/L Interim Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ChkPaper | Paper Type | VarChar | B) Blank Paper S) Overflow Prenumbered Check Stock P) Overflow Blank Paper D) Default | 1 | D | |||
| MaxChkLine | Maximum Lines | Int | 6 | |||||
| TmpltName | Template Name | nVarChar | 8 | |||||
| AbsEntry KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes | |||
| BankKey | Bank Internal ID | Int | 11 | ODSC Bank Codes | ||||
| LockChk | Lock Checks Printing | VarChar | Y) Yes N) No | 1 | N | |||
| OurNum | Our Number in Next Boleto | Int | 11 | |||||
| AgreeNum | Agreement Number | nVarChar | 10 | |||||
| AccountChk | Account Check Digit | VarChar | 1 | |||||
| ISRType | ISR Type | Int | 1) ISR 2) BISR 3) ISR+ 4) BISR+ | 6 | 2 | |||
| ISRBillerI | ISR Biller ID | nVarChar | 9 | |||||
| CustIdNum | Customer ID Number | nVarChar | 6 | 0 | ||||
| InSeri | Incoming Payment Series | Int | 6 | NNM1 Documents Numbering - Series | -1 | |||
| OutSeri | Outgoing Payment Series | Int | 6 | NNM1 Documents Numbering - Series | -1 | |||
| JDTSeri | Journal Entry Series | Int | 6 | NNM1 Documents Numbering - Series | -1 | |||
| FilePlug | Import File Name | nVarChar | 50 | |||||
| ImpStmt | Imported Bank Statement | VarChar | Y) Create New - From File N) Create New - Manually | 1 | N | |||
| PreNumber | Prenumbered Check | VarChar | Y) Yes N) No | 1 | Y | |||
| AddrType | Address Type | nVarChar | 100 | |||||
| StreetNo | Street No. | nVarChar | 100 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| UpdateDate | Date of Update | Date | 8 | |||||
| UsrLogSign | User Signature | Int | 6 | OUSR Users | ||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| SwiftNum | BIC/SWIFT Code | nVarChar | 50 | |||||
| FineAcct | Fine Account | nVarChar | 15 | OACT G/L Accounts | ||||
| IntrstAcct | Interest Account | nVarChar | 15 | OACT G/L Accounts | ||||
| DscntAcct | Discount Account | nVarChar | 15 | OACT G/L Accounts | ||||
| SvcFeeAcct | Service Fee Account | nVarChar | 15 | OACT G/L Accounts | ||||
| BranchChk | Branch Check Digit | nVarChar | 5 | |||||
| RetFile | Retorno File Format | nVarChar | 50 | |||||
| IOFTaxAcct | IOF Tax Account | nVarChar | 15 | |||||
| OthExpAcct | Other Expenses Account | nVarChar | 15 | OACT G/L Accounts | ||||
| OthIncAcct | Other Incomes Account | nVarChar | 15 | OACT G/L Accounts | ||||
| CollCode | Collection Code | nVarChar | 50 | |||||
| FileSeqNNo | File Sequence Next Number | Int | 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
HouseBankAccounts
Enumeration
Method
Property
AbsoluteEntry
DTW DB
AccNo
DTW DB
AccountCheckDigit
DTW DB
AddressType
DTW DB
AgreementNumber
DTW DB
BankCode
DB
BankKey
DTW DB
BankonCollection
DTW DB
BankonDiscounted
DTW DB
BISR
DTW DB
Block
DTW DB
Branch
DTW DB
Building
DTW DB
City
DTW DB
ControlKey
DTW DB
Country
DB
County
DTW DB
CustomerIdNumber
DTW DB
DaysInAdvance
DTW DB
DebtofDiscountedBillofExc
DTW DB
DiscountLimit
DTW DB
GLAccount
DTW DB
GLInterimAccount
DTW DB
IBAN
DTW DB
ImportFileName
DTW DB
IncomingPaymentSeries
DTW DB
ISRBillerID
DTW DB
ISRType
DTW DB
JournalEntrySeries
DTW DB
LockChecksPrinting
DTW DB
MaxAmountofBillofExchan
DTW DB
MaximumLines
DTW DB
MinAmountofBillofExchang
DTW DB
NextCheckNo
DTW DB
OurNumber
DTW DB
OutgoingPaymentSeries
DTW DB
PrintOn
DTW DB
State
DTW DB
Street
DTW DB
StreetNo
DTW DB
TemplateName
DTW DB
ToleranceDays
DTW DB
UserNo1
DTW DB
UserNo2
DTW DB
UserNo3
DTW DB
UserNo4
DTW DB
ZipCode
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
