API CreateDocumentItem - Historie editací

Chrzaszcz v 30. 9. 2021, 14:13

2021-09-30T14:13:52Z

Chrzaszcz v 22. 9. 2017, 08:31

2017-09-22T08:31:31Z

Chrzaszcz v 4. 8. 2017, 14:19

2017-08-04T14:19:41Z

Chrzaszcz v 4. 8. 2017, 14:18

2017-08-04T14:18:52Z

Chrzaszcz v 4. 8. 2017, 14:18

2017-08-04T14:18:24Z

Chrzaszcz v 4. 8. 2017, 14:09

2017-08-04T14:09:15Z

Ukázat změny

Chrzaszcz v 4. 8. 2017, 14:07

2017-08-04T14:07:25Z

Ukázat změny

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

2017-08-04T14:06:16Z

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

Nová stránka

==== Description ====
Method allows You to create new document item in system.

==== Exact name ====
<code>API_CreateDocumentItem</code>

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

==== Specification ====
{| class="wikitable"
!Parameter
!Data type
!Value range
!Description
!Relation
|-
|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">
EXEC [API_CreateDocumentItem] @Name = 'Name' ,@Description= 'Description'
</syntaxhighlight>

==== Notices ====
None.

@@ Řádka 19: / Řádka 19: @@
 |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 256: / Řádka 256: @@
+|
 |}
 ==== Example ====
 <syntaxhighlight lang="sql">
-EXEC [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'
+ DECLARE @return_value int
 </syntaxhighlight>
 ==== Notices ====
 None.

API CreateDocumentItem - Historie editací

Chrzaszcz v 30. 9. 2021, 14:13

Chrzaszcz v 22. 9. 2017, 08:31

Chrzaszcz v 4. 8. 2017, 14:19

Chrzaszcz v 4. 8. 2017, 14:18

Chrzaszcz v 4. 8. 2017, 14:18

Chrzaszcz v 4. 8. 2017, 14:09

Chrzaszcz v 4. 8. 2017, 14:07

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to create new document item in system. ==== Exact name ==== API_CreateDocumentItem ==== Type ==== St…“

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