API CreateDocumentItem: Porovnání verzí

Z Podpora.nextis.cz
Přejít na: navigace, hledání
(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…“)
 
Řádka 18: Řádka 18:
 
|ReceiptID
 
|ReceiptID
 
|int  
 
|int  
 +
|
 
|ID of customer from customer list (see relation)
 
|ID of customer from customer list (see relation)
 
| API_GetCustomers.ID
 
| API_GetCustomers.ID
Řádka 23: Řádka 24:
 
|DocumentID
 
|DocumentID
 
|int  
 
|int  
 +
|
 
|ID of invoices from invoices list (see relation)
 
|ID of invoices from invoices list (see relation)
 
| API_GetInvoices.ID
 
| API_GetInvoices.ID
Řádka 28: Řádka 30:
 
|DocumentID2
 
|DocumentID2
 
|int  
 
|int  
 +
|
 
|ID of original invoices from invoices list (see relation)
 
|ID of original invoices from invoices list (see relation)
 
| API_GetInvoices.ID
 
| API_GetInvoices.ID
Řádka 33: Řádka 36:
 
|ProductID
 
|ProductID
 
|int  
 
|int  
 +
|
 
|ID of product from products list (see relation)
 
|ID of product from products list (see relation)
 
| API_GetProducts.ID
 
| API_GetProducts.ID
Řádka 38: Řádka 42:
 
|StorageCardID
 
|StorageCardID
 
|int  
 
|int  
 +
|
 
|ID of stock dispositions from stock dispositions list (see relation)
 
|ID of stock dispositions from stock dispositions list (see relation)
 
| API_GetStockDispositions.ID
 
| API_GetStockDispositions.ID
Řádka 43: Řádka 48:
 
|MeasureUnitID
 
|MeasureUnitID
 
|int  
 
|int  
 +
|
 
|ID of unit from units list (see relation)
 
|ID of unit from units list (see relation)
 
| API_GetUnits.ID
 
| API_GetUnits.ID
Řádka 48: Řádka 54:
 
|VATID
 
|VATID
 
|int  
 
|int  
 +
|
 
|ID of VAT rates from VAT rates list (see relation)
 
|ID of VAT rates from VAT rates list (see relation)
 
| API_GetVATRates.ID
 
| API_GetVATRates.ID
Řádka 53: Řádka 60:
 
|TypeID
 
|TypeID
 
|int  
 
|int  
 +
|
 
|Type ID.
 
|Type ID.
 
1 - Product,  
 
1 - Product,  
Řádka 67: Řádka 75:
 
|IssueQuantity
 
|IssueQuantity
 
|numeric(12,4)  
 
|numeric(12,4)  
 +
|
 
|Issue quantity
 
|Issue quantity
 
|  
 
|  
Řádka 72: Řádka 81:
 
|RetailPricePerPiece
 
|RetailPricePerPiece
 
|decimal(18,4)  
 
|decimal(18,4)  
 +
|
 
|Retail price per piece
 
|Retail price per piece
 
|  
 
|  
Řádka 77: Řádka 87:
 
|PurchPrice
 
|PurchPrice
 
|decimal(19,4)  
 
|decimal(19,4)  
 +
|
 
|Purch price
 
|Purch price
 
|  
 
|  
Řádka 82: Řádka 93:
 
|PurchasePriceInCurrency
 
|PurchasePriceInCurrency
 
|decimal(19,4)  
 
|decimal(19,4)  
 +
|
 
|Purchase price in currency
 
|Purchase price in currency
 
|  
 
|  
Řádka 87: Řádka 99:
 
|TotalPrice
 
|TotalPrice
 
|decimal(19,2)  
 
|decimal(19,2)  
 +
|
 
|Total price
 
|Total price
 
|  
 
|  
Řádka 92: Řádka 105:
 
|TotalPriceInCurrency
 
|TotalPriceInCurrency
 
|decimal(19,2)  
 
|decimal(19,2)  
 +
|
 
|Total price in currency
 
|Total price in currency
 
|  
 
|  
Řádka 97: Řádka 111:
 
|DiscountPercent
 
|DiscountPercent
 
|decimal(6,2)  
 
|decimal(6,2)  
 +
|
 
|Discount percent
 
|Discount percent
 
|  
 
|  
Řádka 102: Řádka 117:
 
|DiscountPrice
 
|DiscountPrice
 
|decimal(18,2)  
 
|decimal(18,2)  
 +
|
 
|Discount price
 
|Discount price
 
|  
 
|  
Řádka 107: Řádka 123:
 
|DiscountPriceInCurrency
 
|DiscountPriceInCurrency
 
|decimal(18,2)  
 
|decimal(18,2)  
 +
|
 
|Discount price in currency
 
|Discount price in currency
 
|  
 
|  
Řádka 112: Řádka 129:
 
|PurchasePriceAfterDiscount
 
|PurchasePriceAfterDiscount
 
|decimal(18,4)  
 
|decimal(18,4)  
 +
|
 
|Purchase price after discount
 
|Purchase price after discount
 
|  
 
|  
Řádka 117: Řádka 135:
 
|PurchasePriceAfterDiscountInCurrency
 
|PurchasePriceAfterDiscountInCurrency
 
|decimal(18,4)  
 
|decimal(18,4)  
 +
|
 
|Purchase price after discount in currency
 
|Purchase price after discount in currency
 
|  
 
|  
Řádka 122: Řádka 141:
 
|TotalPriceAfterDiscount
 
|TotalPriceAfterDiscount
 
|decimal(18,2)  
 
|decimal(18,2)  
 +
|
 
|Total price after discount
 
|Total price after discount
 
|  
 
|  
Řádka 127: Řádka 147:
 
|TotalPriceAfterDiscountInCurrency
 
|TotalPriceAfterDiscountInCurrency
 
|decimal(18,2)  
 
|decimal(18,2)  
 +
|
 
|Total price after discount in currency
 
|Total price after discount in currency
 
|  
 
|  
Řádka 132: Řádka 153:
 
|PerPiecePurchasePrice
 
|PerPiecePurchasePrice
 
|decimal(18,6)  
 
|decimal(18,6)  
 +
|
 
|Per piece purchase price
 
|Per piece purchase price
 
|  
 
|  
Řádka 137: Řádka 159:
 
|PerPieceVATPrice
 
|PerPieceVATPrice
 
|decimal(18,4)  
 
|decimal(18,4)  
 +
|
 
|Per piece VAT price
 
|Per piece VAT price
 
|  
 
|  
Řádka 142: Řádka 165:
 
|TotalPriceWithVAT
 
|TotalPriceWithVAT
 
|decimal(18,2)  
 
|decimal(18,2)  
 +
|
 
|Total price with VAT
 
|Total price with VAT
 
|  
 
|  
Řádka 147: Řádka 171:
 
|TotalPriceWithVATInCurrency
 
|TotalPriceWithVATInCurrency
 
|decimal(18,2)  
 
|decimal(18,2)  
 +
|
 
|Total price with VAT in currency
 
|Total price with VAT in currency
 
|  
 
|  
Řádka 152: Řádka 177:
 
|VATRate
 
|VATRate
 
|numeric(6,2)  
 
|numeric(6,2)  
 +
|
 
|VAT rate
 
|VAT rate
 
|  
 
|  
Řádka 157: Řádka 183:
 
|ExchangeRate
 
|ExchangeRate
 
|decimal(19,4)  
 
|decimal(19,4)  
 +
|
 
|Exchange rate
 
|Exchange rate
 
|  
 
|  
Řádka 162: Řádka 189:
 
|VATTypeID
 
|VATTypeID
 
|int  
 
|int  
 +
|
 
|VAT Type ID
 
|VAT Type ID
 
| -1
 
| -1
Řádka 167: Řádka 195:
 
|VATSetted
 
|VATSetted
 
|int  
 
|int  
 +
|
 
|VAT setted
 
|VAT setted
 
| 0
 
| 0
Řádka 172: Řádka 201:
 
|VATSettedDate
 
|VATSettedDate
 
|datetime  
 
|datetime  
 +
|
 
|VAT setted date
 
|VAT setted date
 
| null
 
| null
Řádka 177: Řádka 207:
 
|Note
 
|Note
 
|nvarchar(100)  
 
|nvarchar(100)  
 +
|
 
|Note
 
|Note
 
|  
 
|  
Řádka 182: Řádka 213:
 
|AvailableStockQuantity
 
|AvailableStockQuantity
 
|decimal(18,3)  
 
|decimal(18,3)  
 +
|
 
|Available stock quantity
 
|Available stock quantity
 
|  
 
|  
Řádka 187: Řádka 219:
 
|StockClosed
 
|StockClosed
 
|int  
 
|int  
 +
|
 
|Stock closed
 
|Stock closed
 
| 0
 
| 0
Řádka 192: Řádka 225:
 
|OriginItemID
 
|OriginItemID
 
|int  
 
|int  
 +
|
 
|ID of original items from document items list (see relation)
 
|ID of original items from document items list (see relation)
 
| API_GetDocumentItems.ID
 
| API_GetDocumentItems.ID
Řádka 197: Řádka 231:
 
|ReturnID
 
|ReturnID
 
|int  
 
|int  
 +
|
 
|
 
|
 
|  
 
|  
Řádka 202: Řádka 237:
 
|ReturnItemID
 
|ReturnItemID
 
|int  
 
|int  
 +
|
 
|
 
|
 
|  
 
|  
Řádka 207: Řádka 243:
 
|ActionPrice
 
|ActionPrice
 
|int  
 
|int  
 +
|
 
|Action price
 
|Action price
 
0 - normal price
 
0 - normal price
Řádka 215: Řádka 252:
 
|Name2
 
|Name2
 
|nvarchar(200)  
 
|nvarchar(200)  
 +
|
 
|Name 2
 
|Name 2
 
|  
 
|  

Verze z 4. 8. 2017, 15:07

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.

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