invantive documentation
Invantive Support ForumsLog In / Sign Up

SalesForecastItemsEx: Exact Online Sales Forecast Items

insert update per partition XML

  • Catalog: ExactOnlineXML
  • Schema: XML
  • Label: Sales Forecast Items

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

API Source

  • XML service: SalesForecasts
  • XML topic: SalesForecasts
  • XML path: /SalesForecastItems/SalesForecastItem

Parameters

Name Data Type Required Default Documentation
division int32 Company code.
Params_ForecastPeriod_From int32 Forecast period (from)
Params_ForecastPeriod_To int32 Forecast period (through)
Params_Item varchar2 Item code.
Params_ItemGroup varchar2 Item group code.
Params_SalesForecast varchar2 Sales forecast GUID (enclose in '{' and '}'). Determine possible values by inspecting the URL generated during export through Exact Online web frontend.

Table Columns

The columns of the table SalesForecastItemsEx 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
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.
ITEM_BARCODE number Item Barcode /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/Barcode/
ITEM_CODE_ATTR varchar2 Item Code /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/code
ITEM_COPYREMARKS boolean Item Copy Remarks /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/CopyRemarks/ Copy sales remarks to sales lines
ITEM_DATEEND date Item Date End /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/DateEnd/ End date: YYYY-MM-DD
ITEM_DATESTART date Item Date Start /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/DateStart/ Start date: YYYY-MM-DD
ITEM_DESCRIPTION varchar2(255) Item Description /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/Description/
ITEM_DESCRIPTION_TERMID_ATTR number Item Description Term ID /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/Description/termid
ITEM_EXTRADESCRIPTION varchar2 Item Extra Description /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/ExtraDescription/
ITEM_EXTRADESCRIPTION_TERMID_ATTR varchar2 itgen_eol_item_extra_description Term ID /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/ExtraDescription/termid
ITEM_ID_ATTR varchar2 Item ID /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/ID
ITEM_IMAGE_BINARYDATA blob Item Image Binary Data /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/Image/BinaryData/
ITEM_IMAGE_ID_ATTR varchar2 Item Image ID /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/Image/ID
ITEM_IMAGE_NAME varchar2 Item Image Name /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/Image/Name/
ITEM_ISBATCHITEM boolean Item Batch Item /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/IsBatchItem/
ITEM_ISFRACTIONALLOWEDITEM boolean Item Fraction Allowed Item /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/IsFractionAllowedItem/
ITEM_ISMAKEITEM boolean Item Make Item /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/IsMakeItem/
ITEM_ISONDEMANDITEM boolean Item On Demand /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/IsOnDemandItem/
ITEM_ISPURCHASEITEM boolean Item Purchase Item /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/IsPurchaseItem/
ITEM_ISSALESITEM boolean Item Sales Item /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/IsSalesItem/
ITEM_ISSERIALITEM boolean Item Serial Item /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/IsSerialItem/
ITEM_ISSTOCKITEM boolean Item Stockable /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/IsStockItem/
ITEM_ISSUBCONTRACTEDITEM boolean Item Subcontracted Item /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/IsSubcontractedItem/
ITEM_ISTAXABLE boolean Item Is Taxable /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/IsTaxable/
ITEM_ISTIME boolean Item Time /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/IsTime/
ITEM_ISWEBSHOPITEM boolean Item Webshop Item /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/IsWebshopItem/
ITEM_ITEMEXTRAFIELDS_EXTRAFIELD1 varchar2 itgen_eol_item_item_extra_fields Extra Field 1 /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/ItemExtraFields/ExtraField1/
ITEM_ITEMEXTRAFIELDS_EXTRAFIELD10 varchar2 itgen_eol_item_item_extra_fields Extra Field 10 /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/ItemExtraFields/ExtraField10/
ITEM_ITEMEXTRAFIELDS_EXTRAFIELD2 varchar2 itgen_eol_item_item_extra_fields Extra Field 2 /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/ItemExtraFields/ExtraField2/
ITEM_ITEMEXTRAFIELDS_EXTRAFIELD3 varchar2 itgen_eol_item_item_extra_fields Extra Field 3 /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/ItemExtraFields/ExtraField3/
ITEM_ITEMEXTRAFIELDS_EXTRAFIELD4 varchar2 itgen_eol_item_item_extra_fields Extra Field 4 /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/ItemExtraFields/ExtraField4/
ITEM_ITEMEXTRAFIELDS_EXTRAFIELD5 varchar2 itgen_eol_item_item_extra_fields Extra Field 5 /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/ItemExtraFields/ExtraField5/
ITEM_ITEMEXTRAFIELDS_EXTRAFIELD6 varchar2 itgen_eol_item_item_extra_fields Extra Field 6 /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/ItemExtraFields/ExtraField6/
ITEM_ITEMEXTRAFIELDS_EXTRAFIELD7 varchar2 itgen_eol_item_item_extra_fields Extra Field 7 /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/ItemExtraFields/ExtraField7/
ITEM_ITEMEXTRAFIELDS_EXTRAFIELD8 varchar2 itgen_eol_item_item_extra_fields Extra Field 8 /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/ItemExtraFields/ExtraField8/
ITEM_ITEMEXTRAFIELDS_EXTRAFIELD9 varchar2 itgen_eol_item_item_extra_fields Extra Field 9 /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/ItemExtraFields/ExtraField9/
ITEM_NOTE varchar2 Item Note /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/Note/ Notes can contain many different characters, make sure to use a CDATA section.
ITEM_NUMBER_ATTR number Item Number /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/number
ITEM_SEARCHCODE_ATTR varchar2 Item Search Code /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/searchcode
ITEM_TRANSLATIONS_TERMID_ATTR varchar2 Item Translations Term ID /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/Translations/termid
ROWNUM int64 Row Number Number of the row within the results, starting at 1.
SALESFORECASTITEMS_SALESFORECAST_CODE_ATTR varchar2 Sales Forecast Code /eExact/SalesForecasts/SalesForecast/code
SALESFORECASTITEMS_SALESFORECAST_DESCRIPTION varchar2(255) Sales Forecast Description /eExact/SalesForecasts/SalesForecast/Description/
SALESFORECASTITEMS_SALESFORECAST_DESCRIPTION_TERMID_ATTR number Sales Forecast Description Term ID /eExact/SalesForecasts/SalesForecast/Description/termid
SALESFORECASTITEMS_SALESFORECAST_ISACTIVE_ATTR varchar2 Sales Forecast Active /eExact/SalesForecasts/SalesForecast/isActive 1=Active, 0=Inactive
SALESFORECASTITEMS_SALESFORECAST_NOTES varchar2 Sales Forecast Notes /eExact/SalesForecasts/SalesForecast/Notes/
SALESFORECASTITEMS_SALESFORECAST_PERIODTYPE_ATTR varchar2 Sales Forecast Period Type /eExact/SalesForecasts/SalesForecast/periodType 2=Week, 3=Month
SALESFORECASTITEMS_SALESFORECAST_WAREHOUSE_CODE_ATTR varchar2 Sales Forecast Warehouse Code /eExact/SalesForecasts/SalesForecast/Warehouse/code
SALESFORECASTITEMS_SALESFORECAST_YEARPERIODFROM_PERIOD_ATTR number Sales Forecast From Period /eExact/SalesForecasts/SalesForecast/YearPeriodFrom/period If periodType=2, min=1 max=52/53(if year has 53 weeks). If periodType=3, min=1 max=12
SALESFORECASTITEMS_SALESFORECAST_YEARPERIODFROM_YEAR_ATTR number Sales Forecast From Year /eExact/SalesForecasts/SalesForecast/YearPeriodFrom/year The minimum year is the first financial year used for the financial periods. out of range=year lesser than the minimum year
SALESFORECASTITEMS_SALESFORECAST_YEARPERIODTO_PERIOD_ATTR number Sales Forecast To Period /eExact/SalesForecasts/SalesForecast/YearPeriodTo/period If periodType=2, min=1 max=52/53(if year has 53 weeks). If periodType=3, min=1 max=12
SALESFORECASTITEMS_SALESFORECAST_YEARPERIODTO_YEAR_ATTR number Sales Forecast To Year /eExact/SalesForecasts/SalesForecast/YearPeriodTo/year The maximum year is 10 years from the current year. out of range=year greater than the maximum year

Release Notes

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