biuan SAP® BUSINESS ONE SDK
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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates