biuan SAP® BUSINESS ONE SDK
SQL Business Partners / Business Place / Counties
DTW Administration / Setup / Financials / Business Places / Counties
API Business Places / County
OCNT - Counties Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsId KEY UNIQUEAuto KeyInt
11
PRIMARYYes
Code KEY UNIQUECounty CodenVarChar
7
UNIQUEYes
CountryCountrynVarChar
3OCST
States
StateStatenVarChar
3OCST
States
NameCounty NamenVarChar
100
TaxZoneTax Free ZoneVarChar
Y) Yes
N) No
1
N
IbgeCodeIBGE CodenVarChar
10
GiaCodeGIA CodenVarChar
10

Table relationship map

SELECT statement

SELECT OCNT.AbsId AS 'Auto Key', OCNT.Code AS 'County Code', OCNT.Country AS 'Country', OCNT.State AS 'State', OCNT.Name AS 'County Name', OCNT.TaxZone AS 'Tax Free Zone', OCNT.IbgeCode AS 'IBGE Code', OCNT.GiaCode AS 'GIA Code' FROM OCNT AS OCNT

Related information


County County Property· Table: OCNT
property County
· Table: OBPL    Parent: Business Places BusinessPlaces Object· Table: OBPL
OCNT SQL Table

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