|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Countries/Regions
Table Name: OCRY
Table Description: Countries/Regions
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| Code | Code | nVarChar | 3 | - | Â | Â | Â |
| Name | Name | nVarChar | 100 | - | Â | Â | Â |
| AddrFormat | Address Format | Int | 6 | OADF | Â | Â | Â |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| IsEC | EU | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ReportCode | Code for Reports | nVarChar | 3 | - | Â | Â | Â |
| TaxIdDigts | No. of Digits for Tax ID | Int | 6 | - | Â | Â | Â |
| BnkCodDgts | No. of Digits for Bank Code | Int | 11 | - | Â | Â | Â |
| BnkBchDgts | No. of Digits for Branch | Int | 11 | - | Â | Â | Â |
| BnkActDgts | No. of Digits for Account No. | Int | 11 | - | Â | Â | Â |
| BnkCtKDgts | No. of Digits for Control No. | Int | 11 | - | Â | Â | Â |
| ValDomAcct | Domestic Bank Acct. Validation | nVarChar | 3 | - | XX | XX | Â |
| Â | Â | Â | Â | Â | Â | BE | Belgium |
| Â | Â | Â | Â | Â | Â | ES | Spain |
| Â | Â | Â | Â | Â | Â | FR | France |
| Â | Â | Â | Â | Â | Â | IT | Italy |
| Â | Â | Â | Â | Â | Â | NL | Netherlands |
| Â | Â | Â | Â | Â | Â | PT | Portugal |
| ValIban | IBAN Validation | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| IsBlackLst | On Black List | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| UICCode | UIC Country Code | nVarChar | 3 | - | Â | Â | Â |
| CntCodNum | Country/Region Code Number | nVarChar | 4 | - | Â | Â | Â |
| Siscomex | SISCOMEX Country/Region Code | nVarChar | 3 | - | Â | Â | Â |
| IsIntraS | Intrastat Trans. | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EAEU | EAEU | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ISO2Code | ISO Alpha-2 Code | nVarChar | 2 | - | Â | Â | Â |
| ISO3Code | ISO Alpha-3 Code | nVarChar | 3 | - | Â | Â | Â |
| ISONumeric | ISO Numeric | nVarChar | 3 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | Code |