EULANDA® ERP System Head Start thru Technology

cn_creafp (SQL API)

Back | Level back

Puts on an article to an existing order. The article must be likewise present. The article can be indicated over the article number and alternatively over the ID of the article. The order is generally indicated over the ID of the header record. To each position which can be put on a quantity can be indicated. All fields of the position are filled from the read article.

The procedure supplies the return value 0 during error free execution. All deviating values are errors.

If the order should be seized another currency like the read articles , then the article currencies are converted automatically with the import into the order currency.

Syntax

cn_creafp @af_id = www, @ar_id = xxx, @ar_number = 'yyy', @afp_quantity= zzz

Argument

@af_id = www

www is the ID of an existing head data set to an order. The order may not be booked yet..

@ar_id = xxx

xxx indicates the ID to existing articles. The data of the article are copied to course-read and into the position. The position reference dbo.OrdePos.ArticleID contains of the position after the creation in xxx indicated. Alternatively to the ID also the article number can be indicated as parameters more @ar_number.

@ar_number = 'yyy'

yyy indicates the article number to existing articles. The data of the article are copied to course-read and into the position. The position reference dbo.OrderPos.ArticIeID contains the ID of the read article of the position after the creation. Alternatively to the article number also the ID of the article can be directly indicated. In this case the parameter must be used @ar_id.

@afp_quantity = zzz

zzz  indicates the quantity. 

Example

declare @e int
exec @e = cn_creAfp @af_id=136, @ar_Number='Adobe Indesign', @afp_quantity=2
Select @e [Exec]

In this example to the existing order with the ID 136 a position with the article "Adobe Indesign“ and the quantity of 2 is added.

©Eulanda Software GmbH Made in Germany, 1989-2010. All rights reserved.