|
|
SQL Banking / Bank Codes
DTW Administration / Setup / Banking / Banks
API ODSC / / Banks
ODSC - Bank Codes Table
Banks Banks Object· Table: ODSC
ODSC SQL Table
External Bank Operation Code Category OBOC SQL Table
Countries OCRY 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 |
|---|---|---|---|---|---|---|---|---|
| BankName | Bank Name | nVarChar | 127 | |||||
| DfltAcct | Account for Outgoing Checks | nVarChar | 50 | |||||
| DfltBranch | Branch for Outgoing Checks | nVarChar | 50 | |||||
| NextChckNo | Next Check Number | Int | 11 | |||||
| Locked | Locked | VarChar | N) Changeable Y) Locked | 1 | N | |||
| DataSource | Data Source | VarChar | 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 | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| SwiftNum | BIC/SWIFT Code | nVarChar | 50 | |||||
| IBAN | IBAN | nVarChar | 50 | |||||
| CountryCod KEY UNIQUE | Country Code | nVarChar | 3 | OCRY Countries | SECONDARY | Yes | ||
| PostOffice | Post Office | VarChar | Y) Yes N) No | 1 | N | |||
| AliasName | Alias Name | nVarChar | 50 | |||||
| AbsEntry KEY UNIQUE | Absolute entry | Int | 11 | PRIMARY | Yes | |||
| DfltActKey | Default Bank Account Key | Int | 11 | DSC1 House Bank Accounts | ||||
| NextNum | Our Number in Next Boleto | Int | 11 | |||||
| BsPstDate | Posting Date Definition | VarChar | S) Statement Date L) Row Date V) Due Date C) Current Date | 1 | C | |||
| BsValDate | Due Date Definition | VarChar | S) Statement Date L) Row Date V) Due Date C) Current Date | 1 | C | |||
| BnkOpCode | Bank Operation Code List | Int | 11 | OBOC External Bank Operation Code Category | ||||
| BsDocDate | Document Date Definition | VarChar | 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
Banks
Method
Property
AbsoluteEntry
DTW DB
BankCode
DTW DB
BankName
DTW DB
CountryCode
DTW DB
DefaultBankAccountKey
DTW DB
IBAN
DTW DB
PostOffice
DTW DB
SwiftNo
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
