====== TradeItemManagerFillCache ======

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

{{:images:sign_warning.png?nolink|}}**Note:** __Works only with MS-SQL Server__ and needs to be used together with the Jobstep [[en:prozessdefinition:jobs:jobsteps:supplier:tradeitemmanagerbookcache]]
On __non MS-SQL Server__ systems, the [[en:prozessdefinition:jobs:jobsteps:supplier: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.|

{{:images:sign_warning.png?nolink|}}**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 =====

  * [[en:prozessdefinition:jobs:jobsteps:allgemein:EntitySelector]]
  * [[en:prozessdefinition:jobs:jobsteps:supplier:tradeitemmanagerbookcache]]