====== TradeItemSelectorDirectSql ======

The **TradeItemSelectorDirectSql** extracts TradeItems from motion data. With this TradeItem list, article detail information is then determined from the ArticleDetail table of the Supplier.ArticlePool, and an ArticleDocument is generated from it, which is used to compile the accompanying article catalog..\\ 

^GENERATED src="eBiss.Supplier.Resources.JobSteps.DirectSqlTradeItemSelector" changed=""^^
^Properties^^
^Name^Description^
|**Type**|Class name of the jobstep|
|**Name**|Name for the jobstep that will appears in the job designer|
|**Description**|Optional description for the jobstep|
|**Collection scope**|All article details (EANs) for each article or only the matching article details (Per EAN). When selecting "Per EAN" the option 'Link article to article pool' is not possible, is disabled.|
|**Selection**|Here, the method according to which articles are extracted can be set. All for all articles, New only for articles which have not been extracted from a document before, NewOrChanged for new and changed articles, None for none, etc.|
|**Link articles to article pool**|True or False, in the case of True, already used articles are memorized (using the ArticlePoolLinkTable) noted and only sent if they have not yet occurred there.|
|**Query scope**|DEFAULT, NODE, SUBSCRIPTIONS|
|**Price line usage**|The Pricelines to be used.|
|**Missing EAN behaviour**|Setting what should happen if an EAN is not found.|
|**Price line**|Eine Fest eingestellt|
|**Partner language**|
|**Additional article info**|
|**Max. article batch**|Number of items to be executed at once. A value equals -1 means no batch handling|
|**Conflate article info**|Article information such as prices, article texts and additional info are filtered by the trading partner settings, e.g. only article texts and additional info assigned to the trading parter are submitted. Prices were selected by parter price line include the price hierarchie, if not defined in the selected price line.|
|**Timeout**|If operation runs in an DB timeout, you can increase it here|
|**Extended partner detection**|If false the TradingPartner from the original document is used.\\If true, the trading partner found by 1. by //@BuyerGLN or //@BuyerGln from the document, 2. set in the source frame variable, 3. from the original document.\\Default for new created job steps is true, for existing jobs the default is false.|
|**On partner**|Indicates whether the item pool is attached to the partner or system partner.|

{{:images:sign_warning.png?nolink|}}**Note:** If you want to record in the article pool which articles were sent last and when, you have to select "All article details" for the property "**Collection scope**". In other words: on the article pool only articles can be noted, but no article details or EANs!

===== The following JobSteps are usually connected to the TradeItemSelectorDirectSql =====

  * [[en:prozessdefinition:jobs:jobsteps:allgemein:EntityIfCase]]
  * [[en:prozessdefinition:jobs:jobsteps:allgemein:EntityTransformer]]