|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Bank Codes
Table Name: ODSC
Table Description: Bank Codes
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| BankCode | Bank Code | nVarChar | 30 | - | Â | Â | Â |
| BankName | Bank Name | nVarChar | 250 | - | Â | Â | Â |
| DfltAcct | Account for Outgoing Checks | nVarChar | 50 | - | Â | Â | Â |
| DfltBranch | Branch for Outgoing Checks | nVarChar | 50 | - | Â | Â | Â |
| NextChckNo | Next Check Number | Int | 11 | - | Â | Â | Â |
| Locked | Locked | VarChar | 1 | - | N | N | Changeable |
| Â | Â | Â | Â | Â | Â | Y | Locked |
| DataSource | Data Source | VarChar | 1 | - | N | N | Unknown |
| Â | Â | Â | Â | Â | Â | I | Interface |
| Â | Â | Â | Â | Â | Â | U | Update |
| Â | Â | Â | Â | Â | Â | M | Import |
| Â | Â | Â | Â | Â | Â | O | DI API |
| Â | Â | Â | Â | Â | Â | S | Service Layer |
| Â | Â | Â | Â | Â | Â | W | Web Client |
| Â | Â | Â | Â | Â | Â | A | Doc. Generation Wizard |
| Â | Â | Â | Â | Â | Â | D | Restore Wizard |
| Â | Â | Â | Â | Â | Â | P | Partner Implementation |
| Â | Â | Â | Â | Â | Â | T | Year Transfer |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| SwiftNum | BIC/SWIFT Code | nVarChar | 50 | - | Â | Â | Â |
| IBAN | IBAN | nVarChar | 50 | - | Â | Â | Â |
| CountryCod | Country/Region Code | nVarChar | 3 | OCRY | Â | Â | Â |
| PostOffice | Post Office | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| AliasName | Alias Name | nVarChar | 50 | - | Â | Â | Â |
| AbsEntry | Absolute entry | Int | 11 | - | Â | Â | Â |
| DfltActKey | Default Bank Account Key | Int | 11 | DSC1 | Â | Â | Â |
| NextNum | Our Number in Next Boleto | Int | 11 | - | Â | Â | Â |
| BsPstDate | Posting Date Definition | VarChar | 1 | - | C | S | Statement Date |
| Â | Â | Â | Â | Â | Â | L | Row Date |
| Â | Â | Â | Â | Â | Â | V | Due Date |
| Â | Â | Â | Â | Â | Â | C | Current Date |
| BsValDate | Due Date Definition | VarChar | 1 | - | C | S | Statement Date |
| Â | Â | Â | Â | Â | Â | L | Row Date |
| Â | Â | Â | Â | Â | Â | V | Due Date |
| Â | Â | Â | Â | Â | Â | C | Current Date |
| BnkOpCode | Bank Operation Code List | Int | 11 | OBOC | Â | Â | Â |
| BsDocDate | Document Date Definition | VarChar | 1 | - | C | S | Statement Date |
| Â | Â | Â | Â | Â | Â | L | Row Date |
| Â | Â | Â | Â | Â | Â | V | Due Date |
| Â | Â | Â | Â | Â | Â | C | Current Date |
| TaxIdNum | Federal Tax ID | nVarChar | 32 | - | Â | Â | Â |
| EncryptIV | Encrypt IV | nVarChar | 100 | - | Â | Â | Â |
| EnDfltAcct | Encryption of Default Account | Text | 16 | - | Â | Â | Â |
| DigPayment | Digital Payments | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| SECONDARY | Yes | CountryCod |
| Â | Â | BankCode |