Chrzaszcz v 30. 9. 2021, 14:11

2021-09-30T14:11:51Z

Chrzaszcz v 22. 9. 2017, 08:32

2017-09-22T08:32:46Z

Chrzaszcz v 7. 8. 2017, 13:38

2017-08-07T13:38:35Z

Chrzaszcz v 7. 8. 2017, 13:37

2017-08-07T13:37:35Z

Chrzaszcz v 7. 8. 2017, 13:31

2017-08-07T13:31:17Z

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update document item in system. ==== Exact name ==== `API_UpdateDocumentItem` ==== Type ==== Standa…“

2017-08-07T13:28:33Z

Založena nová stránka s textem „==== Description ==== Method allows You to update document item in system. ==== Exact name ==== <code>API_UpdateDocumentItem</code> ==== Type ==== Standa…“

Nová stránka

==== Description ====
Method allows You to update document item in system.

==== Exact name ====
<code>API_UpdateDocumentItem</code>

==== Type ====
Standard executable stored procedure.

==== Specification ====
{| class="wikitable"
!Parameter
!Data type
!Value range
!Description
!Relation
|-
|@ID
|int
|
|Internal system id
|API_GetBranches.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 ====
<syntaxhighlight lang="sql">
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,
</syntaxhighlight>

==== Notices ====
None.

@@ Řádka 25: / Řádka 25: @@
 |int
+|
-|ID of customer from customer list (see relation)
+|ID of delivery note from delivery note list (see relation)
-| API_GetCustomers.ID
+| API_GetDeliveryNote.ID
 |-
 |@DocumentID

@@ Řádka 263: / Řádka 263: @@
 |}
 ==== Example ====
 <syntaxhighlight lang="sql">
   DECLARE @ID int
   DECLARE @ReceiptID int
@@ Řádka 348: / Řádka 352: @@
   WHERE  id = 3
-  EXECUTE [API_UpdateDocumentItem]
+  EXECUTE @return_value = [API_UpdateDocumentItem]
    @ID,
    @ReceiptID,

@@ Řádka 387: / Řádka 387: @@
    @ReturnID,
    @ReturnItemID,
-   @ActionPrice,
+   @ActionPrice
 </syntaxhighlight>
 ==== Notices ====
 None.

@@ Řádka 45: / Řádka 45: @@
 |ID of product from products list (see relation)
 | API_GetProducts.ID
 |-
 |@StorageCardID
@@ Řádka 254: / Řádka 260: @@
 - action price
+|
 |}

@@ Řádka 20: / Řádka 20: @@
+|
 |Internal system id
-|API_GetBranches.ID
+|API_GetDocumentItems.ID
 |-
 |@ReceiptID