API CreateDocumentItem: Porovnání verzí
Skočit na navigaci
Skočit na vyhledávání
Bez shrnutí editace |
Bez shrnutí editace |
||
| Řádek 16: | Řádek 16: | ||
!Relation | !Relation | ||
|- | |- | ||
|ReceiptID | |@ReceiptID | ||
|int | |int | ||
| | | | ||
| Řádek 22: | Řádek 22: | ||
| API_GetCustomers.ID | | API_GetCustomers.ID | ||
|- | |- | ||
|DocumentID | |@DocumentID | ||
|int | |int | ||
| | | | ||
| Řádek 28: | Řádek 28: | ||
| API_GetInvoices.ID | | API_GetInvoices.ID | ||
|- | |- | ||
|DocumentID2 | |@DocumentID2 | ||
|int | |int | ||
| | | | ||
| Řádek 34: | Řádek 34: | ||
| API_GetInvoices.ID | | API_GetInvoices.ID | ||
|- | |- | ||
|ProductID | |@ProductID | ||
|int | |int | ||
| | | | ||
| Řádek 40: | Řádek 40: | ||
| API_GetProducts.ID | | API_GetProducts.ID | ||
|- | |- | ||
|StorageCardID | |@StorageCardID | ||
|int | |int | ||
| | | | ||
| Řádek 46: | Řádek 46: | ||
| API_GetStockDispositions.ID | | API_GetStockDispositions.ID | ||
|- | |- | ||
|MeasureUnitID | |@MeasureUnitID | ||
|int | |int | ||
| | | | ||
| Řádek 52: | Řádek 52: | ||
| API_GetUnits.ID | | API_GetUnits.ID | ||
|- | |- | ||
|VATID | |@VATID | ||
|int | |int | ||
| | | | ||
| Řádek 58: | Řádek 58: | ||
| API_GetVATRates.ID | | API_GetVATRates.ID | ||
|- | |- | ||
|TypeID | |@TypeID | ||
|int | |int | ||
| | | | ||
| Řádek 73: | Řádek 73: | ||
| | | | ||
|- | |- | ||
|IssueQuantity | |@IssueQuantity | ||
|numeric(12,4) | |numeric(12,4) | ||
| | | | ||
| Řádek 79: | Řádek 79: | ||
| | | | ||
|- | |- | ||
|RetailPricePerPiece | |@RetailPricePerPiece | ||
|decimal(18,4) | |decimal(18,4) | ||
| | | | ||
| Řádek 85: | Řádek 85: | ||
| | | | ||
|- | |- | ||
|PurchPrice | |@PurchPrice | ||
|decimal(19,4) | |decimal(19,4) | ||
| | | | ||
| Řádek 91: | Řádek 91: | ||
| | | | ||
|- | |- | ||
|PurchasePriceInCurrency | |@PurchasePriceInCurrency | ||
|decimal(19,4) | |decimal(19,4) | ||
| | | | ||
| Řádek 97: | Řádek 97: | ||
| | | | ||
|- | |- | ||
|TotalPrice | |@TotalPrice | ||
|decimal(19,2) | |decimal(19,2) | ||
| | | | ||
| Řádek 103: | Řádek 103: | ||
| | | | ||
|- | |- | ||
|TotalPriceInCurrency | |@TotalPriceInCurrency | ||
|decimal(19,2) | |decimal(19,2) | ||
| | | | ||
| Řádek 109: | Řádek 109: | ||
| | | | ||
|- | |- | ||
|DiscountPercent | |@DiscountPercent | ||
|decimal(6,2) | |decimal(6,2) | ||
| | | | ||
| Řádek 115: | Řádek 115: | ||
| | | | ||
|- | |- | ||
|DiscountPrice | |@DiscountPrice | ||
|decimal(18,2) | |decimal(18,2) | ||
| | | | ||
| Řádek 121: | Řádek 121: | ||
| | | | ||
|- | |- | ||
|DiscountPriceInCurrency | |@DiscountPriceInCurrency | ||
|decimal(18,2) | |decimal(18,2) | ||
| | | | ||
| Řádek 127: | Řádek 127: | ||
| | | | ||
|- | |- | ||
|PurchasePriceAfterDiscount | |@PurchasePriceAfterDiscount | ||
|decimal(18,4) | |decimal(18,4) | ||
| | | | ||
| Řádek 133: | Řádek 133: | ||
| | | | ||
|- | |- | ||
|PurchasePriceAfterDiscountInCurrency | |@PurchasePriceAfterDiscountInCurrency | ||
|decimal(18,4) | |decimal(18,4) | ||
| | | | ||
| Řádek 139: | Řádek 139: | ||
| | | | ||
|- | |- | ||
|TotalPriceAfterDiscount | |@TotalPriceAfterDiscount | ||
|decimal(18,2) | |decimal(18,2) | ||
| | | | ||
| Řádek 145: | Řádek 145: | ||
| | | | ||
|- | |- | ||
|TotalPriceAfterDiscountInCurrency | |@TotalPriceAfterDiscountInCurrency | ||
|decimal(18,2) | |decimal(18,2) | ||
| | | | ||
| Řádek 151: | Řádek 151: | ||
| | | | ||
|- | |- | ||
|PerPiecePurchasePrice | |@PerPiecePurchasePrice | ||
|decimal(18,6) | |decimal(18,6) | ||
| | | | ||
| Řádek 157: | Řádek 157: | ||
| | | | ||
|- | |- | ||
|PerPieceVATPrice | |@PerPieceVATPrice | ||
|decimal(18,4) | |decimal(18,4) | ||
| | | | ||
| Řádek 163: | Řádek 163: | ||
| | | | ||
|- | |- | ||
|TotalPriceWithVAT | |@TotalPriceWithVAT | ||
|decimal(18,2) | |decimal(18,2) | ||
| | | | ||
| Řádek 169: | Řádek 169: | ||
| | | | ||
|- | |- | ||
|TotalPriceWithVATInCurrency | |@TotalPriceWithVATInCurrency | ||
|decimal(18,2) | |decimal(18,2) | ||
| | | | ||
| Řádek 175: | Řádek 175: | ||
| | | | ||
|- | |- | ||
|VATRate | |@VATRate | ||
|numeric(6,2) | |numeric(6,2) | ||
| | | | ||
| Řádek 181: | Řádek 181: | ||
| | | | ||
|- | |- | ||
|ExchangeRate | |@ExchangeRate | ||
|decimal(19,4) | |decimal(19,4) | ||
| | | | ||
| Řádek 187: | Řádek 187: | ||
| | | | ||
|- | |- | ||
|VATTypeID | |@VATTypeID | ||
|int | |int | ||
| | | | ||
| Řádek 193: | Řádek 193: | ||
| -1 | | -1 | ||
|- | |- | ||
|VATSetted | |@VATSetted | ||
|int | |int | ||
| | | | ||
| Řádek 199: | Řádek 199: | ||
| 0 | | 0 | ||
|- | |- | ||
|VATSettedDate | |@VATSettedDate | ||
|datetime | |datetime | ||
| | | | ||
| Řádek 205: | Řádek 205: | ||
| null | | null | ||
|- | |- | ||
|Note | |@Note | ||
|nvarchar(100) | |nvarchar(100) | ||
| | | | ||
| Řádek 211: | Řádek 211: | ||
| | | | ||
|- | |- | ||
|AvailableStockQuantity | |@AvailableStockQuantity | ||
|decimal(18,3) | |decimal(18,3) | ||
| | | | ||
| Řádek 217: | Řádek 217: | ||
| | | | ||
|- | |- | ||
|StockClosed | |@StockClosed | ||
|int | |int | ||
| | | | ||
| Řádek 223: | Řádek 223: | ||
| 0 | | 0 | ||
|- | |- | ||
|OriginItemID | |@OriginItemID | ||
|int | |int | ||
| | | | ||
| Řádek 229: | Řádek 229: | ||
| API_GetDocumentItems.ID | | API_GetDocumentItems.ID | ||
|- | |- | ||
|ReturnID | |@ReturnID | ||
|int | |int | ||
| | | | ||
| Řádek 235: | Řádek 235: | ||
| | | | ||
|- | |- | ||
|ReturnItemID | |@ReturnItemID | ||
|int | |int | ||
| | | | ||
| Řádek 241: | Řádek 241: | ||
| | | | ||
|- | |- | ||
|ActionPrice | |@ActionPrice | ||
|int | |int | ||
| | | | ||
| Řádek 250: | Řádek 250: | ||
| | | | ||
|- | |- | ||
|Name2 | |@Name2 | ||
|nvarchar(200) | |nvarchar(200) | ||
| | | | ||
Verze z 4. 8. 2017, 14:09
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.