invantive documentation
Invantive Support ForumsLog In / Sign Up

OwnerAdministrations: Exact Online Current Customer Administrations

insert update per partition XML

  • Catalog: ExactOnlineXML
  • Schema: XML
  • Primary Keys: code_attr
  • Label: Current Customer Administrations

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: /

Table Columns

The columns of the table OwnerAdministrations 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
ACTIVITYSECTOR_CODE_ATTR varchar2 Activity Sector Code /eExact/Administrations/Administration/ActivitySector/code
ACTIVITYSUBSECTOR_CODE_ATTR varchar2 Activity Sub Sector Code /eExact/Administrations/Administration/ActivitySubSector/code
ADDRESSLINE1 varchar2 Address Line 1 /eExact/Administrations/Administration/AddressLine1/
ADDRESSLINE2 varchar2 Address Line 2 /eExact/Administrations/Administration/AddressLine2/
ADDRESSLINE3 varchar2 Address Line 3 /eExact/Administrations/Administration/AddressLine3/
ADMINISTRATIONTYPES varchar2 Administration Types /eExact/Administrations/Administration/AdministrationTypes/
BLOCKINGSTATUS varchar2 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
BUSINESSTYPE_CODE_ATTR varchar2 Business Type Code /eExact/Administrations/Administration/BusinessType/code
CHAMBEROFCOMMERCE varchar2 Chamber of Commerce /eExact/Administrations/Administration/ChamberOfCommerce/
CHAMBEROFCOMMERCEESTABLISHMENT varchar2 Chamber of Commerce Establishment /eExact/Administrations/Administration/ChamberOfCommerceEstablishment/
CITY varchar2 City /eExact/Administrations/Administration/City/
CODE_ATTR varchar2 Code /eExact/Administrations/Administration/code The internal unique code of the administration.
COMPANYSIZE_CODE_ATTR varchar2 Company Size Code /eExact/Administrations/Administration/CompanySize/code
COUNTRY_CODE_ATTR varchar2 Country Code /eExact/Administrations/Administration/Country/code
COUNTRY_DESCRIPTION varchar2(255) Country Description /eExact/Administrations/Administration/Country/Description/
COUNTRY_DESCRIPTION_TERMID_ATTR number Country Description Term ID /eExact/Administrations/Administration/Country/Description/termid
CURRENCY_CODE_ATTR varchar2 Currency Code /eExact/Administrations/Administration/Currency/code
CURRENCY_DESCRIPTION varchar2(255) Currency Description /eExact/Administrations/Administration/Currency/Description/
CURRENCY_DESCRIPTION_TERMID_ATTR number Currency Description Term ID /eExact/Administrations/Administration/Currency/Description/termid
DIGITALPOSTBOXES varchar2 Digital Post Boxes /eExact/Administrations/Administration/DigitalPostBoxes/
DIVISIONCLASSNAMES varchar2 Division Class Names /eExact/Administrations/Administration/DivisionClassNames/
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.
EMAIL varchar2 Email /eExact/Administrations/Administration/Email/
ENDDATE date End Date /eExact/Administrations/Administration/EndDate/ End date: YYYY-MM-DD
ETTSOURCE varchar2 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
FAX varchar2 Fax /eExact/Administrations/Administration/Fax/
HOMEPAGE varchar2 Home Page /eExact/Administrations/Administration/HomePage/
INTERFACE_URL varchar2(4000) Interface URL URL used to interface this row with Exact Online.
NAME varchar2 Name /eExact/Administrations/Administration/Name/
NUMBER_ATTR number Number /eExact/Administrations/Administration/number The external code of the administration as shown in the administration card.
PHONE varchar2 Phone /eExact/Administrations/Administration/Phone/
PHONEEXT varchar2 Phone Extension /eExact/Administrations/Administration/PhoneExt/
POSTCODE varchar2 Postal Code /eExact/Administrations/Administration/Postcode/
ROWNUM int64 Row Number Number of the row within the results, starting at 1.
SBICODE_CODE_ATTR varchar2 SBI Code Code /eExact/Administrations/Administration/SBICode/code
SEPADDCREDITORIDENTIFIER varchar2 SEPA Direct Dunning Creditor Identifier /eExact/Administrations/Administration/SepaDDCreditorIdentifier/
STARTDATE date Start Date /eExact/Administrations/Administration/StartDate/ Start date: YYYY-MM-DD
STATE_CODE_ATTR varchar2 State Code /eExact/Administrations/Administration/State/code
STATE_DESCRIPTION varchar2(255) State Description /eExact/Administrations/Administration/State/Description/
STATE_DESCRIPTION_TERMID_ATTR number itgen_eol_state_description Term ID /eExact/Administrations/Administration/State/Description/termid
USERADMINISTRATIONS varchar2 User Administrations /eExact/Administrations/Administration/UserAdministrations/
VATNUMBER varchar2 VAT Number /eExact/Administrations/Administration/VATNumber/

Release Notes

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