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 |
|---|---|
| Type | Type of the job step. |
| Name | Name of the job step that will appear in the job designer |
| Description | Optional description for the job step. |
| ExternalFillProcedure | The 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). |
| Overwrite | The 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). |
| SqlCommandTimeout | The SQL server timeout for the SQL queries can be entered here. |
| DeleteCache | You 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 .