API CreateDocumentItem: Porovnání verzí
Z Podpora.nextis.cz
(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…“) |
(Žádný rozdíl)
|
Verze z 4. 8. 2017, 15:06
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 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
EXEC [API_CreateDocumentItem] @Name = 'Name' ,@Description= 'Description'
Notices
None.
