API CreateDocumentItem

Z Podpora.nextis.cz
Přejít na: navigace, hledání

Description

Method allows You to create new document item in system.

Exact name

API_CreateDocumentItem

Type

Standard executable stored procedure.

Specification

Parameter Data type Value range Description Relation
@ReceiptID int ID of delivery note from delivery note list (see relation) API_GetDeliveryNote.ID
@DocumentID int ID of invoices from invoices list (see relation) API_GetInvoices.ID
@DocumentID2 int ID of original invoices from invoices list (see relation) API_GetInvoices.ID
@ProductID int ID of product from products list (see relation) API_GetProducts.ID
@StorageCardID int ID of stock dispositions from stock dispositions list (see relation) API_GetStockDispositions.ID
@MeasureUnitID int ID of unit from units list (see relation) API_GetUnits.ID
@VATID int ID of VAT rates from VAT rates list (see relation) API_GetVATRates.ID
@TypeID int Type ID.

1 - Product,

2 - Service,

7 - Text,

500 - CreditNote,

999 - Round

@IssueQuantity numeric(12,4) Issue quantity
@RetailPricePerPiece decimal(18,4) Retail price per piece
@PurchPrice decimal(19,4) Purch price
@PurchasePriceInCurrency decimal(19,4) Purchase price in currency
@TotalPrice decimal(19,2) Total price
@TotalPriceInCurrency decimal(19,2) Total price in currency
@DiscountPercent decimal(6,2) Discount percent
@DiscountPrice decimal(18,2) Discount price
@DiscountPriceInCurrency decimal(18,2) Discount price in currency
@PurchasePriceAfterDiscount decimal(18,4) Purchase price after discount
@PurchasePriceAfterDiscountInCurrency decimal(18,4) Purchase price after discount in currency
@TotalPriceAfterDiscount decimal(18,2) Total price after discount
@TotalPriceAfterDiscountInCurrency decimal(18,2) Total price after discount in currency
@PerPiecePurchasePrice decimal(18,6) Per piece purchase price
@PerPieceVATPrice decimal(18,4) Per piece VAT price
@TotalPriceWithVAT decimal(18,2) Total price with VAT
@TotalPriceWithVATInCurrency decimal(18,2) Total price with VAT in currency
@VATRate numeric(6,2) VAT rate
@ExchangeRate decimal(19,4) Exchange rate
@VATTypeID int VAT Type ID -1
@VATSetted int VAT setted 0
@VATSettedDate datetime VAT setted date null
@Note nvarchar(100) Note
@AvailableStockQuantity decimal(18,3) Available stock quantity
@StockClosed int Stock closed 0
@OriginItemID int ID of original items from document items list (see relation) API_GetDocumentItems.ID
@ReturnID int
@ReturnItemID int
@ActionPrice int Action price

0 - normal price

1 - action price

@Name2 nvarchar(200) Name 2

Return

0 : OK
100 : Item could not be created

Example

 DECLARE @return_value int
 EXEC @return_value = [API_CreateDocumentItem] @ReceiptID= -1 ,@DocumentID= 7 ,@DocumentID2= -1 ,@ProductID= -1 ,@StorageCardID= -1 ,@MeasureUnitID= 148 ,@VATID= 16028 ,@TypeID= 7 ,@IssueQuantity= 1 ,@RetailPricePerPiece= 300 ,@PurchPrice= 300 ,@PurchasePriceInCurrency= 300 ,@TotalPrice= 300.00 ,@TotalPriceInCurrency= 300 ,@DiscountPercent= 10 ,@DiscountPrice= 30 ,@DiscountPriceInCurrency= 30 ,@PurchasePriceAfterDiscount= 270 ,@PurchasePriceAfterDiscountInCurrency= 270 ,@TotalPriceAfterDiscount= 270.00 ,@TotalPriceAfterDiscountInCurrency= 270 ,@PerPiecePurchasePrice= 0 ,@PerPieceVATPrice= 56.7 ,@TotalPriceWithVAT= 56.7 ,@TotalPriceWithVATInCurrency= 56.7 ,@VATRate= 21.00 ,@ExchangeRate= 1 ,@VATTypeID= 20 ,@VATSetted= 2 ,@VATSettedDate= NULL ,@Note= '' ,@AvailableStockQuantity= 0 ,@StockClosed= 0 ,@OriginItemID= -1 ,@ReturnID= NULL ,@ReturnItemID= NULL ,@ActionPrice= NULL ,@Name2= 'GDB400'

Notices

None.