biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Purchasing / Countries
API Countries Service / Country
OCRY - Countries Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUECodenVarChar
3
PRIMARYYes
NameNamenVarChar
100
AddrFormatAddress FormatInt
6OADF
Address Formats
UserSignUser SignatureInt
6OUSR
Users
IsECEUVarChar
Y) Yes
N) No
1
N
ReportCodeCode for ReportsnVarChar
3
TaxIdDigtsNo. of Digits for Tax IDInt
6
BnkCodDgtsNo. of Digits for Bank CodeInt
11
BnkBchDgtsNo. of Digits for BranchInt
11
BnkActDgtsNo. of Digits for Account No.Int
11
BnkCtKDgtsNo. of Digits for Control No.Int
11
ValDomAcctDomestic Bank Acct. ValidationnVarChar
XX)
BE) Belgium
ES) Spain
FR) France
IT) Italy
NL) Netherlands
PT) Portugal
3
XX
ValIbanIBAN ValidationVarChar
Y) Yes
N) No
1
N
IsBlackLstOn Black ListVarChar
Y) Yes
N) No
1
N
UICCodeUIC Country CodenVarChar
3
CntCodNumCountry Code NumbernVarChar
4
SiscomexSISCOMEX Country CodenVarChar
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



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates