invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

SalesForecastItemsEx: Exact Online Sales Forecast Items

insert update per partition XML

  • Catálogo: ExactOnlineXML
  • Esquema: XML
  • Label: Sales Forecast Items

Los datos de esta tabla están divididos por el valor de la columna Division.

Permite recuperar y modificar datos mediante insert y update.

Resumen

Additional where-clause columns supported:

  • division

Fuente de la API

  • Servicio XML: SalesForecasts
  • Tema XML: SalesForecasts
  • Ruta XML: /SalesForecastItems/SalesForecastItem

Parámetros

Name Tipo de Datos 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.

Columnas de la Tabla

A continuación se muestran las columnas de la tabla SalesForecastItemsEx. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

Name Tipo de Datos Label Required Marks Documentation
DIVISION_CODE varchar2 Identificación de la Administración Número único Interno de la administración de Exact Online.
DIVISION_HID int64 Administration Number of the Exact Online administration.Not guaranteed to be unique.
DIVISION_NAME varchar2(240) Nombre de la Adminisración Name of the Exact Online administration.Not guaranteed to be unique.
INTERFACE_URL varchar2(4000) URL de Interfaz URL utilizada para que interactúe esta fila con Exact Online.
ITEM_BARCODE number Código de barras del artículo /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/Barcode/
ITEM_CODE_ATTR varchar2 Código del Artículo /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) Descripción del Elemento /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 Descripción adicional del artículo /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 Identificación del Elemento /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 Número de la Fila Número de fila dentro de los resultados, empezando por el 1.
SALESFORECASTITEMS_SALESFORECAST_CODE_ATTR varchar2 Sales Forecast Code /eExact/SalesForecasts/SalesForecast/code
SALESFORECASTITEMS_SALESFORECAST_DESCRIPTION varchar2(255) Descripción de la previsión de ventas /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

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: