API CreateDocumentItem: Porovnání verzí

Z Podpora.nextis.cz
Skočit na navigaci Skočit na vyhledávání
Porovnání s novější verzí →

Chrzaszcz (diskuse | příspěvky)

2 uživatelské skupiny
542 editací
VizuálníWikitext
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…“
 
Bez shrnutí editace
Řádek 18: Řádek 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
Řádek 23: Řádek 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
Řádek 28: Řádek 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
Řádek 33: Řádek 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
Řádek 38: Řádek 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
Řádek 43: Řádek 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
Řádek 48: Řádek 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
Řádek 53: Řádek 60:
|TypeID
|TypeID
|int  
|int  
|
|Type ID.
|Type ID.
1 - Product,  
1 - Product,  
Řádek 67: Řádek 75:
|IssueQuantity
|IssueQuantity
|numeric(12,4)  
|numeric(12,4)  
|
|Issue quantity
|Issue quantity
|  
|  
Řádek 72: Řádek 81:
|RetailPricePerPiece
|RetailPricePerPiece
|decimal(18,4)  
|decimal(18,4)  
|
|Retail price per piece
|Retail price per piece
|  
|  
Řádek 77: Řádek 87:
|PurchPrice
|PurchPrice
|decimal(19,4)  
|decimal(19,4)  
|
|Purch price
|Purch price
|  
|  
Řádek 82: Řádek 93:
|PurchasePriceInCurrency
|PurchasePriceInCurrency
|decimal(19,4)  
|decimal(19,4)  
|
|Purchase price in currency
|Purchase price in currency
|  
|  
Řádek 87: Řádek 99:
|TotalPrice
|TotalPrice
|decimal(19,2)  
|decimal(19,2)  
|
|Total price
|Total price
|  
|  
Řádek 92: Řádek 105:
|TotalPriceInCurrency
|TotalPriceInCurrency
|decimal(19,2)  
|decimal(19,2)  
|
|Total price in currency
|Total price in currency
|  
|  
Řádek 97: Řádek 111:
|DiscountPercent
|DiscountPercent
|decimal(6,2)  
|decimal(6,2)  
|
|Discount percent
|Discount percent
|  
|  
Řádek 102: Řádek 117:
|DiscountPrice
|DiscountPrice
|decimal(18,2)  
|decimal(18,2)  
|
|Discount price
|Discount price
|  
|  
Řádek 107: Řádek 123:
|DiscountPriceInCurrency
|DiscountPriceInCurrency
|decimal(18,2)  
|decimal(18,2)  
|
|Discount price in currency
|Discount price in currency
|  
|  
Řádek 112: Řádek 129:
|PurchasePriceAfterDiscount
|PurchasePriceAfterDiscount
|decimal(18,4)  
|decimal(18,4)  
|
|Purchase price after discount
|Purchase price after discount
|  
|  
Řádek 117: Řádek 135:
|PurchasePriceAfterDiscountInCurrency
|PurchasePriceAfterDiscountInCurrency
|decimal(18,4)  
|decimal(18,4)  
|
|Purchase price after discount in currency
|Purchase price after discount in currency
|  
|  
Řádek 122: Řádek 141:
|TotalPriceAfterDiscount
|TotalPriceAfterDiscount
|decimal(18,2)  
|decimal(18,2)  
|
|Total price after discount
|Total price after discount
|  
|  
Řádek 127: Řádek 147:
|TotalPriceAfterDiscountInCurrency
|TotalPriceAfterDiscountInCurrency
|decimal(18,2)  
|decimal(18,2)  
|
|Total price after discount in currency
|Total price after discount in currency
|  
|  
Řádek 132: Řádek 153:
|PerPiecePurchasePrice
|PerPiecePurchasePrice
|decimal(18,6)  
|decimal(18,6)  
|
|Per piece purchase price
|Per piece purchase price
|  
|  
Řádek 137: Řádek 159:
|PerPieceVATPrice
|PerPieceVATPrice
|decimal(18,4)  
|decimal(18,4)  
|
|Per piece VAT price
|Per piece VAT price
|  
|  
Řádek 142: Řádek 165:
|TotalPriceWithVAT
|TotalPriceWithVAT
|decimal(18,2)  
|decimal(18,2)  
|
|Total price with VAT
|Total price with VAT
|  
|  
Řádek 147: Řádek 171:
|TotalPriceWithVATInCurrency
|TotalPriceWithVATInCurrency
|decimal(18,2)  
|decimal(18,2)  
|
|Total price with VAT in currency
|Total price with VAT in currency
|  
|  
Řádek 152: Řádek 177:
|VATRate
|VATRate
|numeric(6,2)  
|numeric(6,2)  
|
|VAT rate
|VAT rate
|  
|  
Řádek 157: Řádek 183:
|ExchangeRate
|ExchangeRate
|decimal(19,4)  
|decimal(19,4)  
|
|Exchange rate
|Exchange rate
|  
|  
Řádek 162: Řádek 189:
|VATTypeID
|VATTypeID
|int  
|int  
|
|VAT Type ID
|VAT Type ID
| -1
| -1
Řádek 167: Řádek 195:
|VATSetted
|VATSetted
|int  
|int  
|
|VAT setted
|VAT setted
| 0
| 0
Řádek 172: Řádek 201:
|VATSettedDate
|VATSettedDate
|datetime  
|datetime  
|
|VAT setted date
|VAT setted date
| null
| null
Řádek 177: Řádek 207:
|Note
|Note
|nvarchar(100)  
|nvarchar(100)  
|
|Note
|Note
|  
|  
Řádek 182: Řádek 213:
|AvailableStockQuantity
|AvailableStockQuantity
|decimal(18,3)  
|decimal(18,3)  
|
|Available stock quantity
|Available stock quantity
|  
|  
Řádek 187: Řádek 219:
|StockClosed
|StockClosed
|int  
|int  
|
|Stock closed
|Stock closed
| 0
| 0
Řádek 192: Řádek 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
Řádek 197: Řádek 231:
|ReturnID
|ReturnID
|int  
|int  
|
|
|
|  
|  
Řádek 202: Řádek 237:
|ReturnItemID
|ReturnItemID
|int  
|int  
|
|
|
|  
|  
Řádek 207: Řádek 243:
|ActionPrice
|ActionPrice
|int  
|int  
|
|Action price
|Action price
0 - normal price
0 - normal price
Řádek 215: Řádek 252:
|Name2
|Name2
|nvarchar(200)  
|nvarchar(200)  
|
|Name 2
|Name 2
|  
|  

Verze z 4. 8. 2017, 14: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“