API GetDocumentItems - Historie editací

Chrzaszcz v 30. 9. 2021, 14:14

2021-09-30T14:14:46Z

← Starší verze		Verze z 30. 9. 2021, 14:14
Řádek 22:		Řádek 22:
	\|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

Chrzaszcz v 3. 8. 2017, 08:55

2017-08-03T08:55:15Z

← Starší verze		Verze z 3. 8. 2017, 08:55
Řádek 58:		Řádek 58:
	\|int		\|int
	\|Type ID.		\|Type ID.
	1-~~produkt~~,		1 - Product,

	2-~~usługa~~,		2 - Service,

	7-~~text~~,		7 - Text,

	500-~~korekta ceny~~ ,		500 - CreditNote,

	999-~~zaokrąglenie~~		999 - Round
	\|		\|
	\|-		\|-

Chrzaszcz v 31. 7. 2017, 08:29

2017-07-31T08:29:39Z

← Starší verze		Verze z 31. 7. 2017, 08:29
Řádek 22:		Řádek 22:
	\|ReceiptID		\|ReceiptID
	\|int		\|int
	\|~~ReceiptID~~		\|ID of customer from customer list (see relation)
	\|		\| API_GetCustomers.ID
	\|-		\|-
	\|DocumentID		\|DocumentID
	\|int		\|int
	\|~~DocumentID~~		\|ID of invoices from invoices list (see relation)
	\|		\| API_GetInvoices.ID
	\|-		\|-
	\|DocumentID2		\|DocumentID2
	\|int		\|int
	\|~~DocumentID2~~		\|ID of original invoices from invoices list (see relation)
	\|		\| API_GetInvoices.ID
	\|-		\|-
	\|ProductID		\|ProductID
	\|int		\|int
	\|~~ProductID~~		\|ID of product from products list (see relation)
	\|		\| API_GetProducts.ID
	\|-		\|-
	\|StorageCardID		\|StorageCardID
	\|int		\|int
	\|~~StorageCardID~~		\|ID of stock dispositions from stock dispositions list (see relation)
	\|		\| API_GetStockDispositions.ID
	\|-		\|-
	\|MeasureUnitID		\|MeasureUnitID
	\|int		\|int
	\|~~MeasureUnitID~~		\|ID of unit from units list (see relation)
	\|		\| API_GetUnits.ID
	\|-		\|-
	\|VATID		\|VATID
	\|int		\|int
	\|~~VATID~~		\|ID of VAT rates from VAT rates list (see relation)
	\|		\| API_GetVATRates.ID
	\|-		\|-
	\|TypeID		\|TypeID
	\|int		\|int
	\|~~TypeID~~		\|Type ID.
			1-produkt,

			2-usługa,

			7-text,

			500-korekta ceny ,

			999-zaokrąglenie
	\|		\|
	\|-		\|-
Řádek 157:		Řádek 166:
	\|VATTypeID		\|VATTypeID
	\|int		\|int
	\|~~VATTypeID~~		\|VAT Type ID
	\|		\| -1
	\|-		\|-
	\|VATSetted		\|VATSetted
	\|int		\|int
	\|VAT setted		\|VAT setted
	\|		\| 0
	\|-		\|-
	\|VATSettedDate		\|VATSettedDate
	\|datetime		\|datetime
	\|VAT setted date		\|VAT setted date
	\|		\| null
	\|-		\|-
	\|Note		\|Note
Řádek 183:		Řádek 192:
	\|int		\|int
	\|Stock closed		\|Stock closed
	\|		\| 0
	\|-		\|-
	\|OriginItemID		\|OriginItemID
	\|int		\|int
	\|~~OriginItemID~~		\|ID of original items from document items list (see relation)
	\|		\| API_GetDocumentItems.ID
	\|-		\|-
	\|ReturnID		\|ReturnID
	\|int		\|int
	\|~~ReturnID~~		\|
	\|		\|
	\|-		\|-
	\|ReturnItemID		\|ReturnItemID
	\|int		\|int
	\|~~ReturnItemID~~		\|
	\|		\|
	\|-		\|-
Řádek 204:		Řádek 213:
	\|Action price		\|Action price
	0 - normal price		0 - normal price

	1 - action price		1 - action price
	\|		\|

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.

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 ==…“