Country/Region

    API Details

    Property Value
    Endpoint /tablesGeneral/countryRegions
    Table name Country/Region
    Table id 9
    Table caption Country/Region
    Data per company True
    Group General

    Schema

    erd

    Properties

    Property Table Fieldname Type Max.Length Key Options Table relation Version introduced Version removed Obsolete state Obsolete reason
    id System Id GUID 16
    code Code Code 10 *
    name Name Text 50
    isoCode ISO Code Code 2
    isoNumericCode ISO Numeric Code Code 3
    euCountryRegionCode EU Country/Region Code Code 10
    intrastatCode Intrastat Code Code 10
    addressFormat Address Format Option 4 Post Code+City, City+Post Code, City+County+Post Code, Blank Line+Post Code+City, Custom
    contactAddressFormat Contact Address Format Option 4 First, After Company Name, Last
    vatScheme VAT Scheme Code 10
    lastModifiedDateTime Last Modified Date Time DateTime 8
    countyName County Name Text 30
    sepaAllowed SEPA Allowed Boolean 4
    systemId System ID GUID 16
    systemCreatedAt Created At DateTime 8
    systemCreatedBy Created By GUID 16 User
    systemModifiedAt Modified At DateTime 8
    systemModifiedBy Modified By GUID 16 User