API UpdateDocumentItem

Description

Method allows You to update document item in system.

Exact name

API_UpdateDocumentItem

Type

Standard executable stored procedure.

Specification

Parameter	Data type	Value range	Description	Relation
@ID	int		Internal system id	API_GetDocumentItems.ID
@ReceiptID	int		ID of customer from customer list (see relation)	API_GetCustomers.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

Example

 DECLARE @ID int
 DECLARE @ReceiptID int
 DECLARE @DocumentID int
 DECLARE @DocumentID2 int
 DECLARE @ProductID int
 DECLARE @Name2 nvarchar(200)
 DECLARE @StorageCardID int
 DECLARE @MeasureUnitID int
 DECLARE @VATID int
 DECLARE @TypeID int
 DECLARE @IssueQuantity numeric(12,4)
 DECLARE @RetailPricePerPiece decimal(18,4)
 DECLARE @PurchPrice decimal(19,4)
 DECLARE @PurchasePriceInCurrency decimal(19,4)
 DECLARE @TotalPrice decimal(19,2)
 DECLARE @TotalPriceInCurrency decimal(19,2)
 DECLARE @DiscountPercent decimal(6,2)
 DECLARE @DiscountPrice decimal(18,2)
 DECLARE @DiscountPriceInCurrency decimal(18,2)
 DECLARE @PurchasePriceAfterDiscount decimal(18,4)
 DECLARE @PurchasePriceAfterDiscountInCurrency decimal(18,4)
 DECLARE @TotalPriceAfterDiscount decimal(18,2)
 DECLARE @TotalPriceAfterDiscountInCurrency decimal(18,2)
 DECLARE @PerPiecePurchasePrice decimal(18,6)
 DECLARE @PerPieceVATPrice decimal(18,4)
 DECLARE @TotalPriceWithVAT decimal(18,2)
 DECLARE @TotalPriceWithVATInCurrency decimal(18,2)
 DECLARE @VATRate numeric(6,2)
 DECLARE @ExchangeRate decimal(19,4)
 DECLARE @VATTypeID int
 DECLARE @VATSetted int
 DECLARE @VATSettedDate datetime
 DECLARE @Note nvarchar(100)
 DECLARE @AvailableStockQuantity decimal(18,3)
 DECLARE @StockClosed int
 DECLARE @OriginItemID int
 DECLARE @ReturnID int
 DECLARE @ReturnItemID int
 DECLARE @ActionPrice int
 
 SELECT @ID = [ID], 
       @ReceiptID = [ReceiptID],
       @DocumentID = [DocumentID],
       @DocumentID2 = [DocumentID2],
       @ProductID = [ProductID],
       @Name2 = 'Name X',
       @StorageCardID = [StorageCardID],
       @MeasureUnitID = [MeasureUnitID],
       @VATID = [VATID],
       @TypeID = [TypeID],
       @IssueQuantity = [IssueQuantity],
       @RetailPricePerPiece = [RetailPricePerPiece],
       @PurchPrice = [PurchPrice],
       @PurchasePriceInCurrency = [PurchasePriceInCurrency],
       @TotalPrice = [TotalPrice],
       @TotalPriceInCurrency = [TotalPriceInCurrency],
       @DiscountPercent = [DiscountPercent],
       @DiscountPrice = [DiscountPrice],
       @DiscountPriceInCurrency = [DiscountPriceInCurrency],
       @PurchasePriceAfterDiscount = [PurchasePriceAfterDiscount],
       @PurchasePriceAfterDiscountInCurrency = [PurchasePriceAfterDiscountInCurrency],
       @TotalPriceAfterDiscount = [TotalPriceAfterDiscount],
       @TotalPriceAfterDiscountInCurrency = [TotalPriceAfterDiscountInCurrency],
       @PerPiecePurchasePrice = [PerPiecePurchasePrice],
       @PerPieceVATPrice = [PerPieceVATPrice],
       @TotalPriceWithVAT = [TotalPriceWithVAT],
       @TotalPriceWithVATInCurrency = [TotalPriceWithVATInCurrency],
       @VATRate = [VATRate],
       @ExchangeRate = [ExchangeRate],
       @VATTypeID = [VATTypeID],
       @VATSetted = [VATSetted],
       @VATSettedDate = [VATSettedDate],
       @Note = [Note],
       @AvailableStockQuantity = [AvailableStockQuantity],
       @StockClosed = [StockClosed],
       @OriginItemID = [OriginItemID],
       @ReturnID = [ReturnID],
       @ReturnItemID = [ReturnItemID],
       @ActionPrice = [ActionPrice],
 FROM   [API_GetDocumentItems] 
 WHERE  id = 3
 
 EXECUTE [API_UpdateDocumentItem] 
  @ID, 
  @ReceiptID,
  @DocumentID,
  @DocumentID2,
  @ProductID,
  @Name2,
  @StorageCardID,
  @MeasureUnitID,
  @VATID,
  @TypeID,
  @IssueQuantity,
  @RetailPricePerPiece,
  @PurchPrice,
  @PurchasePriceInCurrency,
  @TotalPrice,
  @TotalPriceInCurrency,
  @DiscountPercent,
  @DiscountPrice,
  @DiscountPriceInCurrency,
  @PurchasePriceAfterDiscount,
  @PurchasePriceAfterDiscountInCurrency,
  @TotalPriceAfterDiscount,
  @TotalPriceAfterDiscountInCurrency,
  @PerPiecePurchasePrice,
  @PerPieceVATPrice,
  @TotalPriceWithVAT,
  @TotalPriceWithVATInCurrency,
  @VATRate,
  @ExchangeRate,
  @VATTypeID,
  @VATSetted,
  @VATSettedDate,
  @Note,
  @AvailableStockQuantity,
  @StockClosed,
  @OriginItemID,
  @ReturnID,
  @ReturnItemID,
  @ActionPrice,

Notices

None.