invantive documentation
Invantive Support ForumsLog In / Sign Up

OwnerAdministrationAssignedTypes: Exact Online Current Customer Administration Assigned Types

insert update per partition XML

  • Catalog: ExactOnlineXML
  • Schema: XML
  • Label: Current Customer Administration Assigned Types

The data in this table is partitioned per value of the Division column.

Can retrieve data and change data using insert and update.

Summary

Additional where-clause columns supported:

  • division
  • code
  • number_from
  • number_to
  • startdate_from
  • startdate_to

API Source

  • XML service: Administrations
  • XML topic: Administrations
  • XML path: /AdministrationTypes/AdministrationType

Table Columns

The columns of the table OwnerAdministrationAssignedTypes are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
ADMINISTRATIONTYPES_ADMINISTRATION_ACTIVITYSECTOR_CODE_ATTR varchar2 Activity Sector Code /eExact/Administrations/Administration/ActivitySector/code
ADMINISTRATIONTYPES_ADMINISTRATION_ACTIVITYSUBSECTOR_CODE_ATTR varchar2 Activity Sub Sector Code /eExact/Administrations/Administration/ActivitySubSector/code
ADMINISTRATIONTYPES_ADMINISTRATION_ADDRESSLINE1 varchar2 Administration Address Line 1 /eExact/Administrations/Administration/AddressLine1/
ADMINISTRATIONTYPES_ADMINISTRATION_ADDRESSLINE2 varchar2 Administration Address Line 2 /eExact/Administrations/Administration/AddressLine2/
ADMINISTRATIONTYPES_ADMINISTRATION_ADDRESSLINE3 varchar2 Administration Address Line 3 /eExact/Administrations/Administration/AddressLine3/
ADMINISTRATIONTYPES_ADMINISTRATION_BLOCKINGSTATUS varchar2 Administration Blocking Status /eExact/Administrations/Administration/BlockingStatus/ 0=Not blocked, 1=Backup, 2=Conversion busy, 3=Conversion shadow, 4=Conversion waiting, 5=Copy data waiting, 6=Copy data busy
ADMINISTRATIONTYPES_ADMINISTRATION_BUSINESSTYPE_CODE_ATTR varchar2 Administration Business Type Code /eExact/Administrations/Administration/BusinessType/code
ADMINISTRATIONTYPES_ADMINISTRATION_CHAMBEROFCOMMERCE varchar2 Administration Chamber of Commerce /eExact/Administrations/Administration/ChamberOfCommerce/
ADMINISTRATIONTYPES_ADMINISTRATION_CHAMBEROFCOMMERCEESTABLISHMENT varchar2 Administration Chamber of Commerce Establishment /eExact/Administrations/Administration/ChamberOfCommerceEstablishment/
ADMINISTRATIONTYPES_ADMINISTRATION_CITY varchar2 Administration City /eExact/Administrations/Administration/City/
ADMINISTRATIONTYPES_ADMINISTRATION_CODE_ATTR varchar2 Administration Code /eExact/Administrations/Administration/code The internal unique code of the administration.
ADMINISTRATIONTYPES_ADMINISTRATION_COMPANYSIZE_CODE_ATTR varchar2 Administration Company Size Code /eExact/Administrations/Administration/CompanySize/code
ADMINISTRATIONTYPES_ADMINISTRATION_COUNTRY_CODE_ATTR varchar2 Country Code /eExact/Administrations/Administration/Country/code
ADMINISTRATIONTYPES_ADMINISTRATION_COUNTRY_DESCRIPTION varchar2(255) Country Description /eExact/Administrations/Administration/Country/Description/
ADMINISTRATIONTYPES_ADMINISTRATION_COUNTRY_DESCRIPTION_TERMID_ATTR number itgen_eol_administrations_administration_country_description Term ID /eExact/Administrations/Administration/Country/Description/termid
ADMINISTRATIONTYPES_ADMINISTRATION_CURRENCY_CODE_ATTR varchar2 Administration Currency Code /eExact/Administrations/Administration/Currency/code
ADMINISTRATIONTYPES_ADMINISTRATION_CURRENCY_DESCRIPTION varchar2(255) Administration Currency Description /eExact/Administrations/Administration/Currency/Description/
ADMINISTRATIONTYPES_ADMINISTRATION_CURRENCY_DESCRIPTION_TERMID_ATTR number itgen_eol_administrations_administration_currency_description Term ID /eExact/Administrations/Administration/Currency/Description/termid
ADMINISTRATIONTYPES_ADMINISTRATION_DIGITALPOSTBOXES varchar2 Administration Digital Post Boxes /eExact/Administrations/Administration/DigitalPostBoxes/
ADMINISTRATIONTYPES_ADMINISTRATION_DIVISIONCLASSNAMES varchar2 Administration Division Class Names /eExact/Administrations/Administration/DivisionClassNames/
ADMINISTRATIONTYPES_ADMINISTRATION_EMAIL varchar2 Administration Email /eExact/Administrations/Administration/Email/
ADMINISTRATIONTYPES_ADMINISTRATION_ENDDATE date Administration End Date /eExact/Administrations/Administration/EndDate/ End date: YYYY-MM-DD
ADMINISTRATIONTYPES_ADMINISTRATION_ETTSOURCE varchar2 Administration ETT Source /eExact/Administrations/Administration/EttSource/ 0=Not applicable, 1=ProAcc PersProf, 2=ProAcc Corporate, 3=ProAcc Studio, 4=Cubic, 5=Globe, 6=ExactOnLine, 7=Winbooks, 8=Auditfile - Twinfield, 9=Auditfile - Microsoft Navision Attain, 10=Auditfile - iMUIS, 11=Auditfile - Reeleezee Audit, 12=Auditfile - SAP SBO NL, 13=Auditfile - Yuki, 14=Auditfile - Snelstart Reserve [15 to 18] for dataswitcher conversion sources, not displaying it in documentation 15=DataSwitcher - Vero 16=DataSwitcher - SageBob 17=DataSwitcher - ExpertM 18=DataSwitcher - Adsolut
ADMINISTRATIONTYPES_ADMINISTRATION_FAX varchar2 Administration Fax /eExact/Administrations/Administration/Fax/
ADMINISTRATIONTYPES_ADMINISTRATION_HOMEPAGE varchar2 Administration Home Page /eExact/Administrations/Administration/HomePage/
ADMINISTRATIONTYPES_ADMINISTRATION_NAME varchar2 Administration Name /eExact/Administrations/Administration/Name/
ADMINISTRATIONTYPES_ADMINISTRATION_NUMBER_ATTR number Administration Number /eExact/Administrations/Administration/number The external code of the administration as shown in the administration card.
ADMINISTRATIONTYPES_ADMINISTRATION_PHONE varchar2 Administration Phone /eExact/Administrations/Administration/Phone/
ADMINISTRATIONTYPES_ADMINISTRATION_PHONEEXT varchar2 Administration Phone Extension /eExact/Administrations/Administration/PhoneExt/
ADMINISTRATIONTYPES_ADMINISTRATION_POSTCODE varchar2 Administration Postal Code /eExact/Administrations/Administration/Postcode/
ADMINISTRATIONTYPES_ADMINISTRATION_SBICODE_CODE_ATTR varchar2 SBI Code /eExact/Administrations/Administration/SBICode/code
ADMINISTRATIONTYPES_ADMINISTRATION_SEPADDCREDITORIDENTIFIER varchar2 Administration SEPA Direct Dunning Creditor Identifier /eExact/Administrations/Administration/SepaDDCreditorIdentifier/
ADMINISTRATIONTYPES_ADMINISTRATION_STARTDATE date Administration Start Date /eExact/Administrations/Administration/StartDate/ Start date: YYYY-MM-DD
ADMINISTRATIONTYPES_ADMINISTRATION_STATE_CODE_ATTR varchar2 Status Code /eExact/Administrations/Administration/State/code
ADMINISTRATIONTYPES_ADMINISTRATION_STATE_DESCRIPTION varchar2(255) Status Description /eExact/Administrations/Administration/State/Description/
ADMINISTRATIONTYPES_ADMINISTRATION_STATE_DESCRIPTION_TERMID_ATTR number itgen_eol_administrations_administration_state_description Term ID /eExact/Administrations/Administration/State/Description/termid
ADMINISTRATIONTYPES_ADMINISTRATION_USERADMINISTRATIONS varchar2 Administration User Administrations /eExact/Administrations/Administration/UserAdministrations/
ADMINISTRATIONTYPES_ADMINISTRATION_VATNUMBER varchar2 Administration VAT Number /eExact/Administrations/Administration/VATNumber/
CODE_ATTR varchar2 Code /eExact/Administrations/Administration/AdministrationTypes/AdministrationType/code
DESCRIPTION varchar2 Description /eExact/Administrations/Administration/AdministrationTypes/AdministrationType/Description/
DIVISION_CODE varchar2 Administration ID Internal unique number of the Exact Online administration.
DIVISION_HID int64 Administration Number of the Exact Online administration. Not guaranteed to be unique.
DIVISION_NAME varchar2(240) Administration Name Name of the Exact Online administration. Not guaranteed to be unique.
INTERFACE_URL varchar2(4000) Interface URL URL used to interface this row with Exact Online.
ROWNUM int64 Row Number Number of the row within the results, starting at 1.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: