|
|
DTW Administration / Setup / Purchasing / Countries
API Countries Service / Country
OCRY - Countries Table
Country Country Object· Table: OCRY
Parent: Countries Service CountriesService Service· Table: OCRY
Country Params CountryParams Object· Table: OCRY Parent: Countries Service CountriesService Service· Table: OCRY
Countries Service CountriesService Service· Table: OCRY
OCRY SQL Table
Address Formats OADF SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Code KEY UNIQUE | Code | nVarChar | 3 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Name | Name | nVarChar | 100 | |||||
| AddrFormat | Address Format | Int | 6 | OADF Address Formats | ||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| IsEC | EU | VarChar | Y) Yes N) No | 1 | N | |||
| 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 | XX) BE) Belgium ES) Spain FR) France IT) Italy NL) Netherlands PT) Portugal | 3 | XX | |||
| ValIban | IBAN Validation | VarChar | Y) Yes N) No | 1 | N | |||
| IsBlackLst | On Black List | VarChar | Y) Yes N) No | 1 | N | |||
| UICCode | UIC Country Code | nVarChar | 3 | |||||
| CntCodNum | Country Code Number | nVarChar | 4 | |||||
| Siscomex | SISCOMEX Country Code | nVarChar | 3 |
Table relationship map
SELECT statement
SELECT
OCRY.Code AS 'Code',
OCRY.Name AS 'Name',
OCRY.AddrFormat AS 'Address Format',
OCRY.UserSign AS 'User Signature',
OCRY.IsEC AS 'EU',
OCRY.ReportCode AS 'Code for Reports',
OCRY.TaxIdDigts AS 'No. of Digits for Tax ID',
OCRY.BnkCodDgts AS 'No. of Digits for Bank Code',
OCRY.BnkBchDgts AS 'No. of Digits for Branch',
OCRY.BnkActDgts AS 'No. of Digits for Account No.',
OCRY.BnkCtKDgts AS 'No. of Digits for Control No.',
OCRY.ValDomAcct AS 'Domestic Bank Acct. Validation',
OCRY.ValIban AS 'IBAN Validation',
OCRY.IsBlackLst AS 'On Black List',
OCRY.UICCode AS 'UIC Country Code',
OCRY.CntCodNum AS 'Country Code Number',
OCRY.Siscomex AS 'SISCOMEX Country Code'
FROM OCRY AS OCRY
Related information
Country Country Object· Table: OCRY
A data structure object holding properties for the CountriesService object.
Source table: OCRY.
Parent: Countries Service CountriesService Service· Table: OCRY Country Params CountryParams Object· Table: OCRY
This object holds identification properties for the CountriesService object.
Source table: OCRY.
Parent: Countries Service CountriesService Service· Table: OCRY Countries Service CountriesService Service· Table: OCRY
The CountriesService manages the setting of each country in SAP Business One. For example, country code, country name and address format.
Source table: OCRY.
OCRY SQL Table
Address Formats OADF SQL Table
CountriesService
Object
Country
Enumeration
Method
Property
Code
DB
Name
DB
Collection
Enumeration
Method
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
