invantive documentation
Invantive Support ForumsLog In / Sign Up

FinishedAssembliesEx: Exact Online Finished Assemblies

insert update per partition XML

  • Catalog: ExactOnlineXML
  • Schema: XML
  • Label: Finished Assemblies

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
  • downloadid
  • assemblynumber_from
  • assemblynumber_to
  • ordernumber_from
  • ordernumber_to
  • itemcode
  • status

API Source

  • XML service: FinishedAssemblies
  • XML topic: FinishedAssemblies
  • XML path: /

Parameters

Name Data Type Required Default Documentation
division int32 Company code.
Params_AssemblyNumber_From int32 Assembly number (from).
Params_AssemblyNumber_To int32 Assembly number (through).
Params_DownloadID varchar2 Data subscription token.
Params_ItemCode varchar2 Item code.
Params_OrderNumber_From int32 Order number (from).
Params_OrderNumber_To int32 Order number (through).
Params_Status varchar2 Multi-select; 30: Partial, 50: Complete.

Table Columns

The columns of the table FinishedAssembliesEx 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
ASSEMBLYDATE date Assembly Date /eExact/FinishedAssemblies/FinishedAssembly/AssemblyDate/ Assembly date: YYYY-MM-DD
ASSEMBLYNUMBER_ATTR varchar2 Assembly Number /eExact/FinishedAssemblies/FinishedAssembly/assemblynumber Only used for export.
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.
ORDERNUMBER_ATTR varchar2 Order Number /eExact/FinishedAssemblies/FinishedAssembly/ordernumber The order number can be used multiple times.
QUANTITY number Quantity /eExact/FinishedAssemblies/FinishedAssembly/Quantity/
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: