invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

SalesForecastItemsEx: Exact Online Sales Forecast Items

insert update per partition XML

  • Catalogue : ExactOnlineXML
  • Schéma : XML
  • Label: Sales Forecast Items

Les données de cette table sont partitionnées en fonction de la valeur de la colonne Division.

Permet de récupérer et de modifier des données à l'aide de insert et update.

Résumé

Additional where-clause columns supported:

  • division

Source de l'API

  • Service XML : SalesForecasts
  • Rubrique XML : SalesForecasts
  • Chemin XML : /SalesForecastItems/SalesForecastItem

Paramètres

Name Type de données 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.

Colonnes de table

Les colonnes de la table SalesForecastItemsEx sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

Name Type de données Label Required Marks Documentation
DIVISION_CODE varchar2 Identifiant d'administration Numéro unique interne de l'administration d'Exact Online.
DIVISION_HID int64 Administration Number of the Exact Online administration.Not guaranteed to be unique.
DIVISION_NAME varchar2(240) Nom de l'administration Name of the Exact Online administration.Not guaranteed to be unique.
INTERFACE_URL varchar2(4000) URL de l'interface URL utilisée pour relier cette ligne à Exact Online.
ITEM_BARCODE number Code-barres de l'article /eExact/SalesForecasts/SalesForecast/SalesForecastItems/SalesForecastItem/Item/Barcode/
ITEM_CODE_ATTR varchar2 Code de l'article /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) Description de l’article /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 Description complémentaire de l'article /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 ID de l'article /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 Numéro de ligne Numéro de la ligne dans les résultats, en commençant par 1.
SALESFORECASTITEMS_SALESFORECAST_CODE_ATTR varchar2 Sales Forecast Code /eExact/SalesForecasts/SalesForecast/code
SALESFORECASTITEMS_SALESFORECAST_DESCRIPTION varchar2(255) Description des prévisions de ventes /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

Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :