API CreateDocumentItem: Porovnání verzí

Z Podpora.nextis.cz
Skočit na navigaci Skočit na vyhledávání
← Porovnání se starší verzí

Chrzaszcz (diskuse | příspěvky)

2 uživatelské skupiny
542 editací
VizuálníWikitext
Bez shrnutí editace
Bez shrnutí editace
 
(Není zobrazeno 5 mezilehlých verzí od stejného uživatele.)
Řádek 16: Řádek 16:
!Relation
!Relation
|-
|-
|ReceiptID
|@ReceiptID
|int  
|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
|@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)  
|
|
Řádek 256: Řádek 256:
|  
|  
|}
|}
==== Return ====
0 : OK
100 : Item could not be created


==== Example ====
==== Example ====
<syntaxhighlight lang="sql">
<syntaxhighlight lang="sql">
EXEC [API_CreateDocumentItem] @Name = 'Name' ,@Description= 'Description'
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, 14: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.

Citováno z „https://podpora.nextis.cz/index.php?title=API_CreateDocumentItem&oldid=3149“