Home Information PDF Documents EULANDA Handbooks Training Book's corner Download Contact us Table of Contents About us

Glossary

Password needed Newsgroup

Remote Support system

cn_JbAdd (SQL API)

Back | Level back

This procedure puts on a linkage of a parts list element (jumbo). Over this API a parts list element is added in each case to a major item and/or a super ordinate article. The main or sub article can be indicated alternatively as their ID or the article numbers. Apart from the quantity can be indicated purchase price, selling price or weights also deviating.

As result the procedure supplies the value "0", if the plant of the linkage were successful.

Produced by implementing the API a data line in the table "JumboPos" the major item and/or upper article of this linkage is not present yet, then additionally a data line in table "Jumbo" is produced with the standard defaults.

Syntax

PROC cn_JbAdd
  @ArticleId int,
  @SubArticleId int,
  @Quantity numeric(18,4),
  @Info varchar(200),
  @JumboId int = NULL OUT,
  @SellingPriceNet numeric(18,2),
  @PurchasePriceNet numeric(18,2),
  @Weight numeric(18,4),
  @Volume numeric(18,4),
  @ArtNumber varchar(40),
  @SubArtNumber varchar(40)

Argument

@ArticleId

The argument @ArticleId is the ID of the type integer of an existing major article to this lower part to be linked is. One does not hand over @ArticleId, then the major article must be indicated over the article number and the argument more @ArtNumber. If both arguments are indicated, then @ArticleId has the priority.

@SubArticleId

The argument @SubArticleId  is the ID of the type integer of an existing sub-article with the major article to be linked is. One does not hand over @SubArticleId, then the sub-article must be indicated over the article number and the argument more @SubArtNumber. If both arguments are indicated, then @SubArticleId has the priority.

@Quantity

The argument @Quantity indicates the number of the sub-articles, thus how often this is needed in the main parts list. @Quantity is of the type Numeric(18,4) and becomes, if this value omitted, automatically assumed as .

@Info

Over the argument @Info describing information at the sub-article can be added. The description can contain max. 200 indications text.

@JumboID

[OUT]
Over the argument @JumboID one can be able to be returned the ID number of the ID number of the jumbo header record. For each parts list in the table "Jumbo“ a header record is formed internally. All elements, the component sequence number are thus stored in the table "JumboPos“.

@PurchasePriceNet

The argument  @PurchasePriceNet can contain a deviating purchase price for the sub-article. @PurchasePriceNet is of the type numeric(18,2).

@SellingPriceNet

The argument @SellingPriceNet can a deviating selling price for the sub-article contain. @SellingPriceNet is of the type numeric(18,2).

@Weight

The argument @Weight can contain a deviating weight value for the sub-article. @Weight is of the type numeric(18,4).

@Volume

The argument @Volume can contain a deviating volume value for the sub-article. @Volume is of the type numeric(18,4).

This argument is supported at present not constantly and is only intended for a future version. They can however already set it in your application. If necessary you inquire with the support, starting from which EULANDA® version the volume is usable.

@ArtNumber

The argument more @ArtNumber can be indicated alternatively too @ArticleID. It is of the type Varchar(40) and contains the article number the major article.

@SubArtNumber

The argument more @SubArtNumber can be indicated alternatively too @SubArticleID. It is of the type Varchar(40) and contains the article number of the sub-article.

Example 

DECLARE @e int,@JumboId int

EXEC @e = cn_JbAdd 
             @ArtNumber='T1', 
             @SubArtNumber='T2', 
             @Quantity=3, 
             @Info='Test',
             @PurchasePriceNet=2.30, 
             @SellingPriceNet=5.45, 
             @Weigt=2.123, 
             @JumboId = @JumboId OUT

SELECT @e [Exec], @JumboId [JumboId]

The two articles "T1“ and "T2“ must be present in the article stock.

In this example to the article with the article number "T1“, which becomes thereby automatically a major article  and/or an upper article, is linked an article "T2“ as sub-article. The sub-article gets a deviating selling price, purchase price and a deviating weight. The result of the execution is returned the delivery in the variable @e. If the operation was successfully accomplished, then as result "0“ one supplies. Additionally over @JumboID header record is returned the delivery.