TradeItemManagerFillCache

Stores transferred article details, price lines, or texts using a stored procedure into the ArticlePool_CacheTable.

Note: Works only with MS-SQL Server and needs to be used together with the Jobstep TradeItemManagerBookCache On non MS-SQL Server systems, the TradeItemManagerBookCache must be used.

Name Meaning
TypeType of the job step.
NameName of the job step that will appear in the job designer
DescriptionOptional description for the job step.
ExternalFillProcedureThe jobstep can be used directly (vertical direction directly under Job). You must specify an external stored procedure using View 'ArticlePool_FillPriceLineCacheView' . This name is entered in this field. If the jobstep is used horizontally in the workflow behind an EntityTransformer under 'ExternalFillProcedure' nothing can be assigned.
ItemsToBook Indicates the type of TradeItems to be posted (item details, price lines, or texts).
OverwriteThe caching strategy for duplicate entries in a document can be defined here. If this property is set to 'True', the strategy is 'last wins' (double position entry wins).
SqlCommandTimeoutThe SQL server timeout for the SQL queries can be entered here.
DeleteCacheYou can set the Jobstep to delete its contents before filling the cache table. This prevents a primary key violation if the cache table is reloaded with the same data after an error when it is written to the ArticlePool by a ReRun.

Note: For the simultaneous booking of article-data-data in the cache-tables or in the article-tools-tables two consecutive running jobs to avoid , this jobstep is equipped with a Lock-Mechanismuns .

The following JobSteps are usually connected to the TradeItemManagerFillCache