API GetDeliveryNote - Historie editací

Chrzaszcz v 9. 11. 2018, 11:32

2018-11-09T11:32:39Z

Chrzaszcz v 4. 8. 2017, 13:37

2017-08-04T13:37:41Z

Chrzaszcz v 3. 8. 2017, 08:49

2017-08-03T08:49:07Z

Chrzaszcz v 27. 7. 2017, 13:24

2017-07-27T13:24:56Z

Chrzaszcz v 27. 7. 2017, 13:02

2017-07-27T13:02:42Z

Ukázat změny

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

2017-07-27T12:54:42Z

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

Nová stránka

====Description====
Method gives You overview of existing delivery note in system.
====Exact name====
<code>API_GetDeliveryNote</code>
====Type====
Standard view.
====Specification====
{| class="wikitable"
!Column
!Data type
!Description
!Relation
|-
|ID
|int
|Internal system id
|
|-
|StockID
|int
|
|
|-
|BranchID
|int
|
|
|-
|SupplierID
|int
|
|
|-
|OrdererID
|int
|
|
|-
|RecipientID
|int
|
|
|-
|TransportID
|int
|
|
|-
|PaymentTypeID
|int
|PaymentTypeID
|
|-
|CurrencyID
|int
|
|
|-
|_del_Kurz
|decimal(18,6)
|_del_Kurz
|
|-
|Number
|varchar(25)
|Number
|
|-
|Date
|datetime
|Date
|
|-
|OrdererName
|varchar(140)
|OrdererName
|
|-
|OrdererStreet
|varchar(100)
|OrdererStreet
|
|-
|OrdererCity
|varchar(140)
|OrdererCity
|
|-
|OrdererZIPCode
|char(10)
|OrdererZIPCode
|
|-
|OrdererCountry
|varchar(50)
|OrdererCountry
|
|-
|OrdererRegion
|varchar(30)
|OrdererRegion
|
|-
|OrdererState
|varchar(50)
|OrdererState
|
|-
|CompanyRegistrationNumber
|char(20)
|CompanyRegistrationNumber
|
|-
|VATNumber
|char(20)
|VATNumber
|
|-
|RecipientName
|varchar(140)
|RecipientName
|
|-
|RecipientStreet
|varchar(100)
|RecipientStreet
|
|-
|RecipientCity
|varchar(140)
|RecipientCity
|
|-
|RecipientZIPCode
|char(10)
|RecipientZIPCode
|
|-
|RecipientCountry
|varchar(50)
|RecipientCountry
|
|-
|RecipientRegion
|varchar(30)
|RecipientRegion
|
|-
|RecipientState
|varchar(50)
|RecipientState
|
|-
|RecipientNote
|nvarchar(250)
|RecipientNote
|
|-
|IsCanceled
|int
|IsCanceled
|
|-
|IsCancelReason
|varchar(150)
|IsCancelReason
|
|-
|IsCancelDate
|datetime
|IsCancelDate
|
|-
|Note
|varchar(300)
|Note
|
|-
|OrdererPhone
|nvarchar(30)
|OrdererPhone
|
|-
|OrdererFax
|nvarchar(30)
|OrdererFax
|
|-
|OrdererMobilePhone
|nvarchar(30)
|OrdererMobilePhone
|
|-
|OrdererEmail
|nvarchar(60)
|OrdererEmail
|
|-
|OrdererUrl
|nvarchar(50)
|OrdererUrl
|
|-
|RecipientPhone
|nvarchar(30)
|RecipientPhone
|
|-
|RecipientFax
|nvarchar(30)
|RecipientFax
|
|-
|RecipientMobilePhone
|nvarchar(30)
|RecipientMobilePhone
|
|-
|RecipientEmail
|nvarchar(60)
|RecipientEmail
|
|-
|RecipientUrl
|nvarchar(50)
|RecipientUrl
|
|-
|RecipientCompanyRegistrationNumber
|char(20)
|RecipientCompanyRegistrationNumber
|
|-
|RecipientVATNumber
|char(20)
|RecipientVATNumber
|
|-
|OrdererBankName
|nvarchar(120)
|OrdererBankName
|
|-
|OrdererBankAccount
|nvarchar(50)
|OrdererBankAccount
|
|-
|OrdererVATNumber2
|char(20)
|OrdererVATNumber2
|
|-
|RecipientVATNumber2
|char(20)
|RecipientVATNumber2
|
|-
|IsPrinted
|int
|IsPrinted
|
|-
|PrintedDate
|date
|PrintedDate
|
|-
|StornoDocument
|int
|StornoDocument
|
|-
|StornoDocumentOriginID
|int
|StornoDocumentOriginID
|
|-
|CurrencyInCurrencyID
|int
|CurrencyInCurrencyID
|
|-
|ExchangeRate
|decimal(18,2)
|ExchangeRate
|
|}
====Example====
<syntaxhighlight lang="sql">
SELECT TOP 1000 * FROM [API_GetDeliveryNote]
</syntaxhighlight>
====Notices<span> </span><span> </span>====
None.

@@ Řádka 69: / Řádka 69: @@
 |ID of currency from currency list (see relation)
 | API_GetCurrency.ID
 |-
 |Number

@@ Řádka 50: / Řádka 50: @@
 |int
 |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 71: / Řádka 71: @@
 |-
 |Number
-|varchar(25)
+|nvarchar(25)
 |Number
+|
@@ Řádka 81: / Řádka 81: @@
 |-
 |OrdererName
-|varchar(140)
+|nvarchar(140)
 |Orderer name
+|
 |-
 |OrdererStreet
-|varchar(100)
+|nvarchar(100)
 |Orderer street
+|
 |-
 |OrdererCity
-|varchar(140)
+|nvarchar(140)
 |Orderer city
+|
 |-
 |OrdererZIPCode
-|char(10)
+|nvarchar(10)
 |Orderer ZIP code
+|
 |-
 |OrdererCountry
-|varchar(50)
+|nvarchar(50)
 |Orderer country
+|
 |-
 |OrdererRegion
-|varchar(30)
+|nvarchar(30)
 |Orderer region
+|
 |-
 |OrdererState
-|varchar(50)
+|nvarchar(50)
 |Orderer state
+|
 |-
 |CompanyRegistrationNumber
-|char(20)
+|nvarchar(20)
 |Company registration number
+|
 |-
 |VATNumber
-|char(20)
+|nvarchar(20)
 |VAT number
+|
 |-
 |RecipientName
-|varchar(140)
+|nvarchar(140)
 |Recipient name
+|
 |-
 |RecipientStreet
-|varchar(100)
+|nvarchar(100)
 |Recipient street
+|
 |-
 |RecipientCity
-|varchar(140)
+|nvarchar(140)
 |Recipient city
+|
 |-
 |RecipientZIPCode
-|char(10)
+|nvarchar(10)
 |Recipient ZIP code
+|
 |-
 |RecipientCountry
-|varchar(50)
+|nvarchar(50)
 |Recipient country
+|
 |-
 |RecipientRegion
-|varchar(30)
+|nvarchar(30)
 |Recipient region
+|
 |-
 |RecipientState
-|varchar(50)
+|nvarchar(50)
 |Recipient state
+|
@@ Řádka 171: / Řádka 171: @@
 |-
 |IsCancelReason
-|varchar(150)
+|nvarchar(150)
 |Is cancel reason
+|
@@ Řádka 181: / Řádka 181: @@
 |-
 |Note
-|varchar(300)
+|nvarchar(300)
 |Note
+|
@@ Řádka 236: / Řádka 236: @@
 |-
 |RecipientCompanyRegistrationNumber
-|char(20)
+|nvarchar(20)
 |Recipient company registration number
+|
 |-
 |RecipientVATNumber
-|char(20)
+|nvarchar(20)
 |Recipient VAT number
+|
@@ Řádka 256: / Řádka 256: @@
 |-
 |OrdererVATNumber2
-|char(20)
+|nvarchar(20)
 |Orderer VAT number 2
+|
 |-
 |RecipientVATNumber2
-|char(20)
+|nvarchar(20)
 |Recipient VAT number 2
+|

@@ Řádka 19: / Řádka 19: @@
 |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
 |-
 |SupplierID
 |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
 |-
 |TransportID
 |int
+|ID of transport from transport list (see relation)
+| API_GetTransports.ID
 |-
 |PaymentTypeID
 |int
-|PaymentTypeID
+|Payment type ID.
+|
 |-
 |CurrencyID
 |int
+|ID of currency from currency list (see relation)
+| API_GetCurrency.ID
 |-
 |_del_Kurz
@@ Řádka 274: / Řádka 287: @@
 |StornoDocumentOriginID
 |int
-|Storno document origin ID
+|ID of delivery note from delivery note list (see relation)
+| API_GetDeliveryNote.ID
 |-
 |CurrencyInCurrencyID
 |int
-|Currency in currency ID
+|ID of currency from currency list (see relation)
+| API_GetCurrency.ID
 |-
 |ExchangeRate