invantive documentation
Invantive Support ForumsLog In / Sign Up

FinishedAssemblySerialNumbers: Exact Online Finished Assembly Serial Numbers

insert update per partition XML

  • Catalog: ExactOnlineXML
  • Schema: XML
  • Label: Finished Assembly Serial Numbers

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

Table Columns

The columns of the table FinishedAssemblySerialNumbers 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
BLOCKED_ATTR boolean Blocked /eExact/FinishedAssemblies/FinishedAssembly/SerialNumbers/SerialNumber/Blocked
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.
ENDDATE_ATTR date End Date /eExact/FinishedAssemblies/FinishedAssembly/SerialNumbers/SerialNumber/EndDate
INTERFACE_URL varchar2(4000) Interface URL URL used to interface this row with Exact Online.
NOTES_ATTR varchar2 Notes /eExact/FinishedAssemblies/FinishedAssembly/SerialNumbers/SerialNumber/Notes
ROWNUM int64 Row Number Number of the row within the results, starting at 1.
SERIALNUMBERS_FINISHEDASSEMBLY_ASSEMBLYDATE date Finished Assembly Assembly Date /eExact/FinishedAssemblies/FinishedAssembly/AssemblyDate/ Assembly date: YYYY-MM-DD
SERIALNUMBERS_FINISHEDASSEMBLY_ASSEMBLYNUMBER_ATTR varchar2 Finished Assembly Assembly Number /eExact/FinishedAssemblies/FinishedAssembly/assemblynumber Only used for export.
SERIALNUMBERS_FINISHEDASSEMBLY_ORDERNUMBER_ATTR varchar2 Finished Assembly Order Number /eExact/FinishedAssemblies/FinishedAssembly/ordernumber The order number can be used multiple times.
SERIALNUMBERS_FINISHEDASSEMBLY_QUANTITY number Finished Assembly Quantity /eExact/FinishedAssemblies/FinishedAssembly/Quantity/
SERIALNUMBERS_FINISHEDASSEMBLY_TYPE_ATTR varchar2 Finished Assembly Type /eExact/FinishedAssemblies/FinishedAssembly/type 8060=Assembly, 8061=Disassemble. Only used for export, imported assembly orders always default type according PlannedQuantity.
SERIALNUMBER_ATTR varchar2(60) Serial Number /eExact/FinishedAssemblies/FinishedAssembly/SerialNumbers/SerialNumber/SerialNumber
STARTDATE_ATTR date Start Date /eExact/FinishedAssemblies/FinishedAssembly/SerialNumbers/SerialNumber/StartDate

Release Notes

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

Changes of This Table, 26.0 to 27.0

  • + SERIALNUMBERS_FINISHEDASSEMBLY_TYPE_ATTR (varchar2)

All changes of the driver, 26.0 to 27.0