API GetDocumentItems - Historie editací

Chrzaszcz v 30. 9. 2021, 14:14

2021-09-30T14:14:46Z

Chrzaszcz v 3. 8. 2017, 08:55

2017-08-03T08:55:15Z

Chrzaszcz v 31. 7. 2017, 08:29

2017-07-31T08:29:39Z

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method gives You overview of existing document items in system. ==== Exact name ==== `API_GetDocumentItems` ==== Type ==…“

2017-07-31T07:15:42Z

Založena nová stránka s textem „==== Description ==== Method gives You overview of existing document items in system. ==== Exact name ==== <code>API_GetDocumentItems</code> ==== Type ==…“

Nová stránka

==== Description ====
Method gives You overview of existing document items in system.

==== Exact name ====
<code>API_GetDocumentItems</code>

==== Type ====
Standard view.

==== Specification ====
{| class="wikitable"
!Column
!Data type
!Description
!Relation
|-
|ID
|int
|Internal system id
|
|-
|ReceiptID
|int
|ReceiptID
|
|-
|DocumentID
|int
|DocumentID
|
|-
|DocumentID2
|int
|DocumentID2
|
|-
|ProductID
|int
|ProductID
|
|-
|StorageCardID
|int
|StorageCardID
|
|-
|MeasureUnitID
|int
|MeasureUnitID
|
|-
|VATID
|int
|VATID
|
|-
|TypeID
|int
|TypeID
|
|-
|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
|VATTypeID
|
|-
|VATSetted
|int
|VAT setted
|
|-
|VATSettedDate
|datetime
|VAT setted date
|
|-
|Note
|nvarchar(100)
|Note
|
|-
|AvailableStockQuantity
|decimal(18,3)
|Available stock quantity
|
|-
|StockClosed
|int
|Stock closed
|
|-
|OriginItemID
|int
|OriginItemID
|
|-
|ReturnID
|int
|ReturnID
|
|-
|ReturnItemID
|int
|ReturnItemID
|
|-
|ActionPrice
|int
|Action price
0 - normal price
1 - action price
|
|-
|Name2
|nvarchar(200)
|Name 2
|
|}

==== Example ====
<syntaxhighlight lang="sql">
SELECT TOP 1000 * FROM [API_GetDocumentItems]
</syntaxhighlight>

==== Notices ====
None.

@@ Řádka 22: / Řádka 22: @@
 |ReceiptID
 |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

@@ Řádka 58: / Řádka 58: @@
 |int
 |Type ID.
--produkt,
+- Product,
--usługa,
+- Service,
--text,
+- Text,
--korekta ceny ,
+- CreditNote,
--zaokrąglenie
+- Round
+|
 |-

@@ Řádka 22: / Řádka 22: @@
 |ReceiptID
 |int
-|ReceiptID
+|ID of customer from customer list (see relation)
+| API_GetCustomers.ID
 |-
 |DocumentID
 |int
-|DocumentID
+|ID of invoices from invoices list (see relation)
+| API_GetInvoices.ID
 |-
 |DocumentID2
 |int
-|DocumentID2
+|ID of original invoices from invoices list (see relation)
+| API_GetInvoices.ID
 |-
 |ProductID
 |int
-|ProductID
+|ID of product from products list (see relation)
+| API_GetProducts.ID
 |-
 |StorageCardID
 |int
-|StorageCardID
+|ID of stock dispositions from stock dispositions list (see relation)
+| API_GetStockDispositions.ID
 |-
 |MeasureUnitID
 |int
-|MeasureUnitID
+|ID of unit from units list (see relation)
+| API_GetUnits.ID
 |-
 |VATID
 |int
-|VATID
+|ID of VAT rates from VAT rates list (see relation)
+| API_GetVATRates.ID
 |-
 |TypeID
 |int
-|TypeID
+|Type ID.
+|
 |-
@@ Řádka 157: / Řádka 166: @@
 |VATTypeID
 |int
-|VATTypeID
+|VAT Type ID
+| -1
 |-
 |VATSetted
 |int
 |VAT setted
+| 0
 |-
 |VATSettedDate
 |datetime
 |VAT setted date
+| null
 |-
 |Note
@@ Řádka 183: / Řádka 192: @@
 |int
 |Stock closed
+| 0
 |-
 |OriginItemID
 |int
-|OriginItemID
+|ID of original items from document items list (see relation)
+| API_GetDocumentItems.ID
 |-
 |ReturnID
 |int
-|ReturnID
+|
 |-
 |ReturnItemID
 |int
-|ReturnItemID
+|
 |-
@@ Řádka 204: / Řádka 213: @@
 |Action price
 - normal price
 - action price
+|

API GetDocumentItems - Historie editací

Chrzaszcz v 30. 9. 2021, 14:14

Chrzaszcz v 3. 8. 2017, 08:55

Chrzaszcz v 31. 7. 2017, 08:29

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method gives You overview of existing document items in system. ==== Exact name ==== API_GetDocumentItems ==== Type ==…“

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method gives You overview of existing document items in system. ==== Exact name ==== `API_GetDocumentItems` ==== Type ==…“