API CreateDocumentItem: Porovnání verzí
Z Podpora.nextis.cz
| (Není zobrazeno 5 mezilehlých verzí od stejného uživatele.) | |||
| Řádka 16: | Řádka 16: | ||
!Relation | !Relation | ||
|- | |- | ||
| − | |ReceiptID | + | |@ReceiptID |
|int | |int | ||
| | | | ||
| − | |ID of | + | |ID of delivery note from delivery note list (see relation) |
| − | | | + | | API_GetDeliveryNote.ID |
|- | |- | ||
| − | |DocumentID | + | |@DocumentID |
|int | |int | ||
| | | | ||
| Řádka 28: | Řádka 28: | ||
| API_GetInvoices.ID | | API_GetInvoices.ID | ||
|- | |- | ||
| − | |DocumentID2 | + | |@DocumentID2 |
|int | |int | ||
| | | | ||
| Řádka 34: | Řádka 34: | ||
| API_GetInvoices.ID | | API_GetInvoices.ID | ||
|- | |- | ||
| − | |ProductID | + | |@ProductID |
|int | |int | ||
| | | | ||
| Řádka 40: | Řádka 40: | ||
| API_GetProducts.ID | | API_GetProducts.ID | ||
|- | |- | ||
| − | |StorageCardID | + | |@StorageCardID |
|int | |int | ||
| | | | ||
| Řádka 46: | Řádka 46: | ||
| API_GetStockDispositions.ID | | API_GetStockDispositions.ID | ||
|- | |- | ||
| − | |MeasureUnitID | + | |@MeasureUnitID |
|int | |int | ||
| | | | ||
| Řádka 52: | Řádka 52: | ||
| API_GetUnits.ID | | API_GetUnits.ID | ||
|- | |- | ||
| − | |VATID | + | |@VATID |
|int | |int | ||
| | | | ||
| Řádka 58: | Řádka 58: | ||
| API_GetVATRates.ID | | API_GetVATRates.ID | ||
|- | |- | ||
| − | |TypeID | + | |@TypeID |
|int | |int | ||
| | | | ||
| Řádka 73: | Řádka 73: | ||
| | | | ||
|- | |- | ||
| − | |IssueQuantity | + | |@IssueQuantity |
|numeric(12,4) | |numeric(12,4) | ||
| | | | ||
| Řádka 79: | Řádka 79: | ||
| | | | ||
|- | |- | ||
| − | |RetailPricePerPiece | + | |@RetailPricePerPiece |
|decimal(18,4) | |decimal(18,4) | ||
| | | | ||
| Řádka 85: | Řádka 85: | ||
| | | | ||
|- | |- | ||
| − | |PurchPrice | + | |@PurchPrice |
|decimal(19,4) | |decimal(19,4) | ||
| | | | ||
| Řádka 91: | Řádka 91: | ||
| | | | ||
|- | |- | ||
| − | |PurchasePriceInCurrency | + | |@PurchasePriceInCurrency |
|decimal(19,4) | |decimal(19,4) | ||
| | | | ||
| Řádka 97: | Řádka 97: | ||
| | | | ||
|- | |- | ||
| − | |TotalPrice | + | |@TotalPrice |
|decimal(19,2) | |decimal(19,2) | ||
| | | | ||
| Řádka 103: | Řádka 103: | ||
| | | | ||
|- | |- | ||
| − | |TotalPriceInCurrency | + | |@TotalPriceInCurrency |
|decimal(19,2) | |decimal(19,2) | ||
| | | | ||
| Řádka 109: | Řádka 109: | ||
| | | | ||
|- | |- | ||
| − | |DiscountPercent | + | |@DiscountPercent |
|decimal(6,2) | |decimal(6,2) | ||
| | | | ||
| Řádka 115: | Řádka 115: | ||
| | | | ||
|- | |- | ||
| − | |DiscountPrice | + | |@DiscountPrice |
|decimal(18,2) | |decimal(18,2) | ||
| | | | ||
| Řádka 121: | Řádka 121: | ||
| | | | ||
|- | |- | ||
| − | |DiscountPriceInCurrency | + | |@DiscountPriceInCurrency |
|decimal(18,2) | |decimal(18,2) | ||
| | | | ||
| Řádka 127: | Řádka 127: | ||
| | | | ||
|- | |- | ||
| − | |PurchasePriceAfterDiscount | + | |@PurchasePriceAfterDiscount |
|decimal(18,4) | |decimal(18,4) | ||
| | | | ||
| Řádka 133: | Řádka 133: | ||
| | | | ||
|- | |- | ||
| − | |PurchasePriceAfterDiscountInCurrency | + | |@PurchasePriceAfterDiscountInCurrency |
|decimal(18,4) | |decimal(18,4) | ||
| | | | ||
| Řádka 139: | Řádka 139: | ||
| | | | ||
|- | |- | ||
| − | |TotalPriceAfterDiscount | + | |@TotalPriceAfterDiscount |
|decimal(18,2) | |decimal(18,2) | ||
| | | | ||
| Řádka 145: | Řádka 145: | ||
| | | | ||
|- | |- | ||
| − | |TotalPriceAfterDiscountInCurrency | + | |@TotalPriceAfterDiscountInCurrency |
|decimal(18,2) | |decimal(18,2) | ||
| | | | ||
| Řádka 151: | Řádka 151: | ||
| | | | ||
|- | |- | ||
| − | |PerPiecePurchasePrice | + | |@PerPiecePurchasePrice |
|decimal(18,6) | |decimal(18,6) | ||
| | | | ||
| Řádka 157: | Řádka 157: | ||
| | | | ||
|- | |- | ||
| − | |PerPieceVATPrice | + | |@PerPieceVATPrice |
|decimal(18,4) | |decimal(18,4) | ||
| | | | ||
| Řádka 163: | Řádka 163: | ||
| | | | ||
|- | |- | ||
| − | |TotalPriceWithVAT | + | |@TotalPriceWithVAT |
|decimal(18,2) | |decimal(18,2) | ||
| | | | ||
| Řádka 169: | Řádka 169: | ||
| | | | ||
|- | |- | ||
| − | |TotalPriceWithVATInCurrency | + | |@TotalPriceWithVATInCurrency |
|decimal(18,2) | |decimal(18,2) | ||
| | | | ||
| Řádka 175: | Řádka 175: | ||
| | | | ||
|- | |- | ||
| − | |VATRate | + | |@VATRate |
|numeric(6,2) | |numeric(6,2) | ||
| | | | ||
| Řádka 181: | Řádka 181: | ||
| | | | ||
|- | |- | ||
| − | |ExchangeRate | + | |@ExchangeRate |
|decimal(19,4) | |decimal(19,4) | ||
| | | | ||
| Řádka 187: | Řádka 187: | ||
| | | | ||
|- | |- | ||
| − | |VATTypeID | + | |@VATTypeID |
|int | |int | ||
| | | | ||
| Řádka 193: | Řádka 193: | ||
| -1 | | -1 | ||
|- | |- | ||
| − | |VATSetted | + | |@VATSetted |
|int | |int | ||
| | | | ||
| Řádka 199: | Řádka 199: | ||
| 0 | | 0 | ||
|- | |- | ||
| − | |VATSettedDate | + | |@VATSettedDate |
|datetime | |datetime | ||
| | | | ||
| Řádka 205: | Řádka 205: | ||
| null | | null | ||
|- | |- | ||
| − | |Note | + | |@Note |
|nvarchar(100) | |nvarchar(100) | ||
| | | | ||
| Řádka 211: | Řádka 211: | ||
| | | | ||
|- | |- | ||
| − | |AvailableStockQuantity | + | |@AvailableStockQuantity |
|decimal(18,3) | |decimal(18,3) | ||
| | | | ||
| Řádka 217: | Řádka 217: | ||
| | | | ||
|- | |- | ||
| − | |StockClosed | + | |@StockClosed |
|int | |int | ||
| | | | ||
| Řádka 223: | Řádka 223: | ||
| 0 | | 0 | ||
|- | |- | ||
| − | |OriginItemID | + | |@OriginItemID |
|int | |int | ||
| | | | ||
| Řádka 229: | Řádka 229: | ||
| API_GetDocumentItems.ID | | API_GetDocumentItems.ID | ||
|- | |- | ||
| − | |ReturnID | + | |@ReturnID |
|int | |int | ||
| | | | ||
| Řádka 235: | Řádka 235: | ||
| | | | ||
|- | |- | ||
| − | |ReturnItemID | + | |@ReturnItemID |
|int | |int | ||
| | | | ||
| Řádka 241: | Řádka 241: | ||
| | | | ||
|- | |- | ||
| − | |ActionPrice | + | |@ActionPrice |
|int | |int | ||
| | | | ||
| Řádka 250: | Řádka 250: | ||
| | | | ||
|- | |- | ||
| − | |Name2 | + | |@Name2 |
|nvarchar(200) | |nvarchar(200) | ||
| | | | ||
| Řádka 256: | Řádka 256: | ||
| | | | ||
|} | |} | ||
| + | |||
| + | ==== Return ==== | ||
| + | 0 : OK | ||
| + | 100 : Item could not be created | ||
==== Example ==== | ==== Example ==== | ||
<syntaxhighlight lang="sql"> | <syntaxhighlight lang="sql"> | ||
| − | EXEC [API_CreateDocumentItem] @ | + | 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' | ||
</syntaxhighlight> | </syntaxhighlight> | ||
==== Notices ==== | ==== Notices ==== | ||
None. | None. | ||
Aktuální verze z 30. 9. 2021, 15:13
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.
