API GetInvoices - Historie editací

Chrzaszcz v 9. 11. 2018, 13:06

2018-11-09T13:06:25Z

Chrzaszcz v 3. 8. 2017, 08:47

2017-08-03T08:47:13Z

Chrzaszcz v 27. 7. 2017, 13:25

2017-07-27T13:25:03Z

Chrzaszcz v 27. 7. 2017, 11:22

2017-07-27T11:22:11Z

Chrzaszcz v 26. 7. 2017, 14:34

2017-07-26T14:34:13Z

Chrzaszcz v 26. 7. 2017, 12:53

2017-07-26T12:53:28Z

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

2017-07-26T12:37:12Z

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

Nová stránka

====Description====
Method gives You overview of existing invoices in system.
====Exact name====
<code>API_GetInvoices</code>
====Type====
Standard view.
====Specification====
{| class="wikitable"
!Column
!Data type
!Description
!Relation
|-
|ID
|int
|Internal system id
|
|-
|ContactID
|int
|
|
|-
|OrdererID
|int
|
|
|-
|RecipientID
|int
|
|
|-
|StockID
|int
|
|
|-
|BranchID
|int
|
|
|-
|DocumentTypeID
|int
|
|
|-
|TransportID
|int
|
|
|-
|PaymentTypeID
|int
|
|
|-
|PriceTypeID
|int
|
|
|-
|DocumentNumber
|nvarchar(40)
|Document number
|
|-
|Date
|datetime
|Date
|
|-
|TaxableSupplyDate
|datetime
|Taxable supply date
|
|-
|DueDate
|datetime
|Due date
|
|-
|VariableSymbol
|bigint
|Variable symbol
|
|-
|BasicPrice
|decimal(18,6)
|Basic price
|
|-
|BasicPriceInCurrency
|decimal(18,6)
|Basic price in currency
|
|-
|VATPrice
|decimal(18,6)
|VAT price
|
|-
|VATPriceInCurrency
|decimal(18,6)
|VAT price in currency
|
|-
|TotalPrice
|decimal(18,6)
|Total price
|
|-
|TotalPriceInCurrency
|decimal(18,6)
|Total price in currency
|
|-
|RoundPrice
|decimal(18,4)
|Round price
|
|-
|RoundPriceInCurrency
|decimal(18,4)
|Round price in currency
|
|-
|Price
|decimal(19,6)
|Price
|
|-
|PriceInCurrency
|decimal(19,6)
|Price in currency
|
|-
|Currency
|varchar(5)
|Currency
|
|-
|CurrencyID
|int
|CurrencyID
|
|-
|CurrencyIDInCurrency
|int
|CurrencyIDInCurrency
|
|-
|ExchangeRate
|decimal(19,4)
|Exchange rate
|
|-
|ExchangeRate2
|decimal(18,4)
|Exchange rate 2
|
|-
|AccountingExchangeRate
|decimal(18,6)
|Accounting exchange rate
|
|-
|VATExchangeRate
|decimal(18,4)
|VAT exchange rate
|
|-
|AccountingExchangeRate2
|decimal(18,6)
|Accounting exchange rate 2
|
|-
|RoundStyle
|int
|Round style
|
|-
|RoundType
|int
|Round type
|
|-
|SupplierName
|nvarchar(140)
|Supplier name
|
|-
|SupplierStreet
|nvarchar(100)
|Supplier street
|
|-
|SupplierCity
|nvarchar(140)
|Supplier city
|
|-
|SupplierZIPCode
|char(10)
|Supplier ZIP code
|
|-
|SupplierCountry
|nvarchar(50)
|Supplier country
|
|-
|SupplierRegion
|nvarchar(30)
|Supplier region
|
|-
|SupplierState
|nvarchar(50)
|Supplier state
|
|-
|SupplierCompanyRegistrationNumber
|char(20)
|Supplier company registration number
|
|-
|SupplierVATNumber2
|char(20)
|Supplier VAT number 2
|
|-
|SupplierVATNumber
|char(20)
|Supplier VAT number
|
|-
|SupplierPhone
|nvarchar(30)
|Supplier phone
|
|-
|SupplierFax
|nvarchar(30)
|Supplier fax
|
|-
|SupplierMobilePhone
|nvarchar(30)
|Supplier mobile phone
|
|-
|SupplierEmail
|nvarchar(60)
|Supplier email
|
|-
|SupplierWeb
|nvarchar(50)
|Supplier web
|
|-
|SupplierBankName
|nvarchar(120)
|Supplier bank name
|
|-
|SupplierBankAccount
|nvarchar(50)
|Supplier bank account
|
|-
|SupplierBankSwift
|nvarchar(50)
|Supplier bank swift
|
|-
|OrdererName
|nvarchar(140)
|Orderer name
|
|-
|OrdererStreet
|nvarchar(100)
|Orderer street
|
|-
|OrdererCity
|nvarchar(140)
|Orderer city
|
|-
|OrdererZIPCode
|char(10)
|Orderer ZIP code
|
|-
|OrdererCountry
|nvarchar(50)
|Orderer country
|
|-
|OrdererRegion
|nvarchar(30)
|Orderer region
|
|-
|OrdererState
|nvarchar(50)
|Orderer state
|
|-
|OrdererCompanyRegistrationNumber
|char(20)
|Orderer company registration number
|
|-
|OrdererVATNumber2
|char(20)
|Orderer VAT number 2
|
|-
|OrdererVATNumber
|char(20)
|Orderer VAT number
|
|-
|OrdererPhone
|nvarchar(30)
|Orderer phone
|
|-
|OrdererFax
|nvarchar(30)
|Orderer fax
|
|-
|OrdererMobilePhone
|nvarchar(30)
|Orderer mobile phone
|
|-
|OrdererEmail
|nvarchar(60)
|Orderer email
|
|-
|OrdererWeb
|nvarchar(50)
|Orderer web
|
|-
|OrdererBankName
|nvarchar(120)
|Orderer bank name
|
|-
|OrdererBankAccount
|nvarchar(50)
|Orderer bank account
|
|-
|RecipientName
|nvarchar(120)
|Recipient name
|
|-
|RecipientStreet
|nvarchar(100)
|Recipient street
|
|-
|RecipientCity
|nvarchar(140)
|Recipient city
|
|-
|RecipientZIPCode
|char(10)
|Recipient ZIP code
|
|-
|RecipientCountry
|nvarchar(50)
|Recipient country
|
|-
|RecipientRegion
|nvarchar(30)
|Recipient region
|
|-
|RecipientState
|nvarchar(50)
|Recipient state
|
|-
|RecipientCompanyRegistrationNumber
|char(20)
|Recipient company registration number
|
|-
|RecipientVATNumber
|char(20)
|Recipient VAT number
|
|-
|RecipientPhone
|nvarchar(30)
|Recipient phone
|
|-
|RecipientFax
|nvarchar(30)
|Recipient fax
|
|-
|RecipientMobilePhone
|nvarchar(30)
|Recipient mobile phone
|
|-
|RecipientEmail
|nvarchar(60)
|Recipient email
|
|-
|RecipientWeb
|nvarchar(50)
|Recipient web
|
|-
|RecipientBankName
|nvarchar(120)
|Recipient bank name
|
|-
|RecipientBankAccount
|nvarchar(50)
|Recipient bank account
|
|-
|IsCanceled
|int
|Is canceled
|
|-
|CancelationReason
|nvarchar(100)
|Cancelation reason
|
|-
|CancelationDate
|datetime
|Cancelation date
|
|-
|IsForeign
|int
|Is foreign
|
|-
|FinancialYear
|int
|Financial year
|
|-
|FinancialMonth
|int
|Financial month
|
|-
|Note
|nvarchar(500)
|Note
|
|-
|Note2
|varchar(120)
|Note 2
|
|-
|IsPrintedOnFiscal
|int
|Is printed on fiscal
|
|-
|FiskalComputerName
|nvarchar(255)
|Fiskal computer name
|
|-
|IsPrinted
|int
|Is printed
|
|-
|CancelDocument
|int
|Cancel document
|
|-
|CancelDocumentOriginID
|int
|Cancel document origin ID
|
|-
|FiskalPrintDate
|date
|Fiskal print date
|
|-
|FiskalPrintOrder
|int
|Fiskal print order
|
|}
====Example====
<syntaxhighlight lang="sql">
SELECT TOP 1000 * FROM [API_GetInvoices]
</syntaxhighlight>
====Notices<span> </span><span> </span>====
None.

@@ Řádka 46: / Řádka 46: @@
 | Document type ID
-- Faktura
+- Invoice
-- Faktura_Zalohova
+- InvoiceProforma
-- Faktura_Za_Body
+- InvoiceForPoints
-- Paragon
+- Chit
-- Dobropis
+- CreditNote
-- DodaciList
+- DeliveryNote
+|
 |-
@@ Řádka 68: / Řádka 68: @@
 | Payment type ID.
-_NA = -1
+-1 - _NA
-Hotove = 1
+- Cash
-Prevodem = 2
+- WireTransfer
-Kartou = 3
+- CreditCard
-Predem = 4
+- Before
-Poukazkou = 5
+- Voucher
-Dobirkou = 6
+- CashOnDelivery
+|
 |-
@@ Řádka 87: / Řádka 87: @@
 | Price type ID
-VcetneDPH = 0
+- WithVAT
-BezDPH = 1
+- WithoutVAT
-PrenosDPH = 2
+- VATTransfer
+|
 |-
@@ Řádka 212: / Řádka 212: @@
 |int
 |Round style.
--1 - not selected,
+-1        - not selected,
-- round off,
+        - round off,
--1000 - 0,0001,
+-1000  - 0,0001,
--100 - 0,001
+-100    - 0,001
-- 0,01
+        - 0,01
-- 1
+        - 1
-- 10
+        - 10
-- 100
+        - 100
-- 1000
+        - 1000
+|
 |-

@@ Řádka 44: / Řádka 44: @@
 |DocumentTypeID
 |int
+| Document type ID
+|
 |-
@@ Řádka 56: / Řádka 68: @@
 | Payment type ID.
--NotSetCashOnly,
+_NA = -1
--CashOnly,
+Hotove = 1
--Wiretransfer
+Prevodem = 2
+|
 |-
 |PriceTypeID
 |int
+| Price type ID
+|
 |-
@@ Řádka 186: / Řádka 212: @@
 |int
 |Round style.
--1 - default,
+-1 - not selected,
 - round off,
@@ Řádka 208: / Řádka 234: @@
 |int
 |Round type
--1-default,
+-1 - not selected,
--Up,
+- Up,
 - Down,
--Mathematical
+- Mathematical
+|
 |-

@@ Řádka 170: / Řádka 170: @@
 |-
 |Currency
-|varchar(5)
+|nvarchar(5)
 |Currency
+|
@@ Řádka 259: / Řádka 259: @@
 |-
 |SupplierZIPCode
-|char(10)
+|nvarchar(10)
 |Supplier ZIP code
+|
@@ Řádka 279: / Řádka 279: @@
 |-
 |SupplierCompanyRegistrationNumber
-|char(20)
+|nvarchar(20)
 |Supplier company registration number
+|
 |-
 |SupplierVATNumber2
-|char(20)
+|nvarchar(20)
 |Supplier VAT number 2
+|
 |-
 |SupplierVATNumber
-|char(20)
+|nvarchar(20)
 |Supplier VAT number
+|
@@ Řádka 349: / Řádka 349: @@
 |-
 |OrdererZIPCode
-|char(10)
+|nvarchar(10)
 |Orderer ZIP code
+|
@@ Řádka 369: / Řádka 369: @@
 |-
 |OrdererCompanyRegistrationNumber
-|char(20)
+|nvarchar(20)
 |Orderer company registration number
+|
 |-
 |OrdererVATNumber2
-|char(20)
+|nvarchar(20)
 |Orderer VAT number 2
+|
 |-
 |OrdererVATNumber
-|char(20)
+|nvarchar(20)
 |Orderer VAT number
+|
@@ Řádka 434: / Řádka 434: @@
 |-
 |RecipientZIPCode
-|char(10)
+|nvarchar(10)
 |Recipient ZIP code
+|
@@ Řádka 454: / Řádka 454: @@
 |-
 |RecipientCompanyRegistrationNumber
-|char(20)
+|nvarchar(20)
 |Recipient company registration number
+|
 |-
 |RecipientVATNumber
-|char(20)
+|nvarchar(20)
 |Recipient VAT number
+|
@@ Řádka 534: / Řádka 534: @@
 |-
 |Note2
-|varchar(120)
+|nvarchar(120)
 |Note 2
+|

@@ Řádka 560: / Řádka 560: @@
 |CancelDocumentOriginID
 |int
-|Cancel document origin ID
+|ID of invoice from invoice list (see relation)
+|API_GetInvoices.ID
 |-
 |FiskalPrintDate

@@ Řádka 54: / Řádka 54: @@
 |PaymentTypeID
 |int
+| Payment type ID.
+|
 |-
@@ Řádka 144: / Řádka 150: @@
 |CurrencyID
 |int
-|CurrencyID
+|ID of currency from currency list (see relation)
+|API_GetCurrency.ID
 |-
 |CurrencyIDInCurrency
 |int
-|CurrencyIDInCurrency
+|ID of currency from currency list (see relation)
+|API_GetCurrency.ID
 |-
 |ExchangeRate
@@ Řádka 179: / Řádka 185: @@
 |RoundStyle
 |int
-|Round style
+|Round style.
+|
 |-
 |RoundType
 |int
 |Round type
+|
 |-

@@ Řádka 19: / Řádka 19: @@
 |ContactID
 |int
+|ID of customer from customer list (see relation)
+|API_GetCustomers.ID
 |-
 |OrdererID
 |int
+|ID of customer from customer list (see relation)
+|API_GetCustomers.ID
 |-
 |RecipientID
 |int
+|ID of customer from customer list (see relation)
+|API_GetCustomers.ID
 |-
 |StockID
 |int
+|ID of stock from stock list (see relation)
+|API_GetStocks.ID
 |-
 |BranchID
 |int
+|ID of branch from branch list (see relation)
+|API_GetBranches.ID
 |-
 |DocumentTypeID
@@ Řádka 49: / Řádka 49: @@
 |TransportID
 |int
+|ID of transport from transport list (see relation)
+|API_GetTransports.ID
 |-
 |PaymentTypeID