API CreateDeliveryNote - Historie editací

Chrzaszcz v 9. 11. 2018, 11:29

2018-11-09T11:29:05Z

Chrzaszcz v 22. 9. 2017, 08:29

2017-09-22T08:29:25Z

Chrzaszcz v 22. 9. 2017, 08:29

2017-09-22T08:29:00Z

Chrzaszcz v 4. 8. 2017, 14:03

2017-08-04T14:03:14Z

Chrzaszcz v 4. 8. 2017, 13:57

2017-08-04T13:57:40Z

Chrzaszcz v 4. 8. 2017, 13:40

2017-08-04T13:40:16Z

Ukázat změny

Chrzaszcz v 4. 8. 2017, 13:31

2017-08-04T13:31:53Z

Ukázat změny

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to create new delivery note in system. ==== Exact name ==== `API_CreateDeliveryNote` ==== Type ==== St…“

2017-08-04T13:30:36Z

Založena nová stránka s textem „==== Description ==== Method allows You to create new delivery note in system. ==== Exact name ==== <code>API_CreateDeliveryNote</code> ==== Type ==== St…“

Nová stránka

==== Description ====
Method allows You to create new delivery note in system.

==== Exact name ====
<code>API_CreateDeliveryNote</code>

==== Type ====
Standard executable stored procedure.

==== Specification ====
{| class="wikitable"
!Parameter
!Data type
!Value range
!Description
!Relation
|-
|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
|Payment type ID.
-1 - _NA

1 - Cash

2 - WireTransfer

3 - CreditCard

4 - Before

5 - Voucher

6 - CashOnDelivery
|
|-
|CurrencyID
|int
|ID of currency from currency list (see relation)
| API_GetCurrency.ID
|-
|_del_Kurz
|decimal(18,6)
|Exchange Rate
|
|-
|Number
|varchar(25)
|Number
|
|-
|Date
|datetime
|Date
|
|-
|OrdererName
|varchar(140)
|Orderer name
|
|-
|OrdererStreet
|varchar(100)
|Orderer street
|
|-
|OrdererCity
|varchar(140)
|Orderer city
|
|-
|OrdererZIPCode
|char(10)
|Orderer ZIP code
|
|-
|OrdererCountry
|varchar(50)
|Orderer country
|
|-
|OrdererRegion
|varchar(30)
|Orderer region
|
|-
|OrdererState
|varchar(50)
|Orderer state
|
|-
|CompanyRegistrationNumber
|char(20)
|Company registration number
|
|-
|VATNumber
|char(20)
|VAT number
|
|-
|RecipientName
|varchar(140)
|Recipient name
|
|-
|RecipientStreet
|varchar(100)
|Recipient street
|
|-
|RecipientCity
|varchar(140)
|Recipient city
|
|-
|RecipientZIPCode
|char(10)
|Recipient ZIP code
|
|-
|RecipientCountry
|varchar(50)
|Recipient country
|
|-
|RecipientRegion
|varchar(30)
|Recipient region
|
|-
|RecipientState
|varchar(50)
|Recipient state
|
|-
|RecipientNote
|nvarchar(250)
|Recipient note
|
|-
|IsCanceled
|int
|Is canceled
|
|-
|IsCancelReason
|varchar(150)
|Is cancel reason
|
|-
|IsCancelDate
|datetime
|Is cancel date
|
|-
|Note
|varchar(300)
|Note
|
|-
|OrdererPhone
|nvarchar(30)
|Orderer phone
|
|-
|OrdererFax
|nvarchar(30)
|Orderer fax
|
|-
|OrdererMobilePhone
|nvarchar(30)
|Orderer mobile phone
|
|-
|OrdererEmail
|nvarchar(60)
|Orderer email
|
|-
|OrdererUrl
|nvarchar(50)
|Orderer url
|
|-
|RecipientPhone
|nvarchar(30)
|Recipient phone
|
|-
|RecipientFax
|nvarchar(30)
|Recipient fax
|
|-
|RecipientMobilePhone
|nvarchar(30)
|Recipient mobile phone
|
|-
|Recipient email
|nvarchar(60)
|Recipient email
|
|-
|RecipientUrl
|nvarchar(50)
|Recipient url
|
|-
|RecipientCompanyRegistrationNumber
|char(20)
|Recipient company registration number
|
|-
|RecipientVATNumber
|char(20)
|Recipient VAT number
|
|-
|OrdererBankName
|nvarchar(120)
|Orderer bank name
|
|-
|OrdererBankAccount
|nvarchar(50)
|Orderer bank account
|
|-
|OrdererVATNumber2
|char(20)
|Orderer VAT number 2
|
|-
|RecipientVATNumber2
|char(20)
|Recipient VAT number 2
|
|-
|IsPrinted
|int
|Is printed
|
|-
|PrintedDate
|date
|Printed date
|
|-
|StornoDocument
|int
|Storno document
|
|-
|StornoDocumentOriginID
|int
|ID of delivery note from delivery note list (see relation)
| API_GetDeliveryNote.ID
|-
|CurrencyInCurrencyID
|int
|ID of currency from currency list (see relation)
| API_GetCurrency.ID
|-
|ExchangeRate
|decimal(18,2)
|Exchange rate
|
|}

==== Example ====
<syntaxhighlight lang="sql">
EXEC [API_CreateDeliveryNote] @Name = 'Name' ,@Description= 'Description'
</syntaxhighlight>

==== Notices ====
None.

@@ Řádka 78: / Řádka 78: @@
 |-
 |@Number
-|varchar(25)
+|nvarchar(25)
+|
 |Number
@@ Řádka 90: / Řádka 90: @@
 |-
 |@OrdererName
-|varchar(140)
+|nvarchar(140)
+|
 |Orderer name
@@ Řádka 96: / Řádka 96: @@
 |-
 |@OrdererStreet
-|varchar(100)
+|nvarchar(100)
+|
 |Orderer street
@@ Řádka 102: / Řádka 102: @@
 |-
 |@OrdererCity
-|varchar(140)
+|nvarchar(140)
+|
 |Orderer city
@@ Řádka 108: / Řádka 108: @@
 |-
 |@OrdererZIPCode
-|char(10)
+|nvarchar(10)
+|
 |Orderer ZIP code
@@ Řádka 114: / Řádka 114: @@
 |-
 |@OrdererCountry
-|varchar(50)
+|nvarchar(50)
+|
 |Orderer country
@@ Řádka 120: / Řádka 120: @@
 |-
 |@OrdererRegion
-|varchar(30)
+|nvarchar(30)
+|
 |Orderer region
@@ Řádka 126: / Řádka 126: @@
 |-
 |@OrdererState
-|varchar(50)
+|nvarchar(50)
+|
 |Orderer state
@@ Řádka 132: / Řádka 132: @@
 |-
 |@CompanyRegistrationNumber
-|char(20)
+|nvarchar(20)
+|
 |Company registration number
@@ Řádka 138: / Řádka 138: @@
 |-
 |@VATNumber
-|char(20)
+|nvarchar(20)
+|
 |VAT number
@@ Řádka 144: / Řádka 144: @@
 |-
 |@RecipientName
-|varchar(140)
+|nvarchar(140)
+|
 |Recipient name
@@ Řádka 150: / Řádka 150: @@
 |-
 |@RecipientStreet
-|varchar(100)
+|nvarchar(100)
+|
 |Recipient street
@@ Řádka 156: / Řádka 156: @@
 |-
 |@RecipientCity
-|varchar(140)
+|nvarchar(140)
+|
 |Recipient city
@@ Řádka 162: / Řádka 162: @@
 |-
 |@RecipientZIPCode
-|char(10)
+|nvarchar(10)
+|
 |Recipient ZIP code
@@ Řádka 168: / Řádka 168: @@
 |-
 |@RecipientCountry
-|varchar(50)
+|nvarchar(50)
+|
 |Recipient country
@@ Řádka 174: / Řádka 174: @@
 |-
 |@RecipientRegion
-|varchar(30)
+|nvarchar(30)
+|
 |Recipient region
@@ Řádka 180: / Řádka 180: @@
 |-
 |@RecipientState
-|varchar(50)
+|nvarchar(50)
+|
 |Recipient state
@@ Řádka 198: / Řádka 198: @@
 |-
 |@IsCancelReason
-|varchar(150)
+|nvarchar(150)
+|
 |Is cancel reason
@@ Řádka 210: / Řádka 210: @@
 |-
 |@Note
-|varchar(300)
+|nvarchar(300)
+|
 |Note
@@ Řádka 276: / Řádka 276: @@
 |-
 |@RecipientCompanyRegistrationNumber
-|char(20)
+|nvarchar(20)
+|
 |Recipient company registration number
@@ Řádka 282: / Řádka 282: @@
 |-
 |@RecipientVATNumber
-|char(20)
+|nvarchar(20)
+|
 |Recipient VAT number
@@ Řádka 300: / Řádka 300: @@
 |-
 |@OrdererVATNumber2
-|char(20)
+|nvarchar(20)
+|
 |Orderer VAT number 2
@@ Řádka 306: / Řádka 306: @@
 |-
 |@RecipientVATNumber2
-|char(20)
+|nvarchar(20)
+|
 |Recipient VAT number 2

@@ Řádka 354: / Řádka 354: @@
 ==== Example ====
 <syntaxhighlight lang="sql">
 DECLARE @d datetime
 set @d = getdate()
   EXEC @return_value = [API_CreateDeliveryNote] @StockID= 1 ,@BranchID= 1 ,@SupplierID= 10 ,@OrdererID= 10 ,@RecipientID= 10 ,@TransportID= -1 ,@PaymentTypeID= 1 ,@CurrencyID= 16034 ,@Number= 'WZ-0001' ,@Date= @d ,@OrdererName= 'OrdererName' ,@OrdererStreet= 'OrdererStreet' ,@OrdererCity= 'OrdererCity' ,@OrdererZIPCode= 'OrdererZIPCode' ,@OrdererCountry= 'OrdererCountry' ,@OrdererRegion= 'OrdererRegion' ,@OrdererState= 'OrdererState' ,@CompanyRegistrationNumber= 'CompanyRegistrationNumber' ,@VATNumber= 'VATNumber' ,@RecipientName= 'RecipientName' ,@RecipientStreet= 'RecipientStreet' ,@RecipientCity= 'RecipientCity' ,@RecipientZIPCode= 'RecipientZIPCode' ,@RecipientCountry= 'RecipientCountry' ,@RecipientRegion= 'RecipientRegion' ,@RecipientState= 'RecipientState' ,@RecipientNote= 'RecipientNote' ,@IsCanceled= 0 ,@IsCancelReason= '' ,@IsCancelDate= NULL ,@Note= '' ,@OrdererPhone= 'OrdererPhone' ,@OrdererFax= 'OrdererFax' ,@OrdererMobilePhone= 'OrdererMobilePhone' ,@OrdererEmail= 'OrdererEmail' ,@OrdererUrl= 'OrdererUrl' ,@RecipientPhone= 'RecipientPhone' ,@RecipientFax= 'RecipientFax' ,@RecipientMobilePhone= 'RecipientMobilePhone' ,@RecipientEmail= 'RecipientEmail' ,@RecipientUrl= 'RecipientUrl' ,@RecipientCompanyRegistrationNumber= 'RecipientCompanyRegistrationNumber' ,@RecipientVATNumber= 'RecipientVATNumber' ,@OrdererBankName= 'OrdererBankName' ,@OrdererBankAccount= 'OrdererBankAccount' ,@OrdererVATNumber2= 'OrdererVATNumber2' ,@RecipientVATNumber2= 'RecipientVATNumber2' ,@IsPrinted= 0 ,@PrintedDate= NULL ,@StornoDocument= -1 ,@StornoDocumentOriginID= -1 ,@CurrencyInCurrencyID= 16034 ,@ExchangeRate= 1
 </syntaxhighlight>

@@ Řádka 347: / Řádka 347: @@
+|
 |}
 ==== Example ====
@@ Řádka 353: / Řádka 357: @@
 set @d = getdate()
-EXEC [API_CreateDeliveryNote] @StockID= 1 ,@BranchID= 1 ,@SupplierID= 10 ,@OrdererID= 10 ,@RecipientID= 10 ,@TransportID= -1 ,@PaymentTypeID= 1 ,@CurrencyID= 16034 ,@Number= 'WZ-0001' ,@Date= @d ,@OrdererName= 'OrdererName' ,@OrdererStreet= 'OrdererStreet' ,@OrdererCity= 'OrdererCity' ,@OrdererZIPCode= 'OrdererZIPCode' ,@OrdererCountry= 'OrdererCountry' ,@OrdererRegion= 'OrdererRegion' ,@OrdererState= 'OrdererState' ,@CompanyRegistrationNumber= 'CompanyRegistrationNumber' ,@VATNumber= 'VATNumber' ,@RecipientName= 'RecipientName' ,@RecipientStreet= 'RecipientStreet' ,@RecipientCity= 'RecipientCity' ,@RecipientZIPCode= 'RecipientZIPCode' ,@RecipientCountry= 'RecipientCountry' ,@RecipientRegion= 'RecipientRegion' ,@RecipientState= 'RecipientState' ,@RecipientNote= 'RecipientNote' ,@IsCanceled= 0 ,@IsCancelReason= '' ,@IsCancelDate= NULL ,@Note= '' ,@OrdererPhone= 'OrdererPhone' ,@OrdererFax= 'OrdererFax' ,@OrdererMobilePhone= 'OrdererMobilePhone' ,@OrdererEmail= 'OrdererEmail' ,@OrdererUrl= 'OrdererUrl' ,@RecipientPhone= 'RecipientPhone' ,@RecipientFax= 'RecipientFax' ,@RecipientMobilePhone= 'RecipientMobilePhone' ,@RecipientEmail= 'RecipientEmail' ,@RecipientUrl= 'RecipientUrl' ,@RecipientCompanyRegistrationNumber= 'RecipientCompanyRegistrationNumber' ,@RecipientVATNumber= 'RecipientVATNumber' ,@OrdererBankName= 'OrdererBankName' ,@OrdererBankAccount= 'OrdererBankAccount' ,@OrdererVATNumber2= 'OrdererVATNumber2' ,@RecipientVATNumber2= 'RecipientVATNumber2' ,@IsPrinted= 0 ,@PrintedDate= NULL ,@StornoDocument= -1 ,@StornoDocumentOriginID= -1 ,@CurrencyInCurrencyID= 16034 ,@ExchangeRate= 1
+ DECLARE @return_value int
 </syntaxhighlight>
 ==== Notices ====
 None.

@@ Řádka 263: / Řádka 263: @@
+|
 |-
-|@Recipient email
+|@RecipientEmail
 |nvarchar(60)
+|
@@ Řádka 353: / Řádka 353: @@
 set @d = getdate()
-EXEC [API_CreateDeliveryNote] @Name = 'Name' ,@Description= 'Description'
+EXEC [API_CreateDeliveryNote] @StockID= 1 ,@BranchID= 1 ,@SupplierID= 10 ,@OrdererID= 10 ,@RecipientID= 10 ,@TransportID= -1 ,@PaymentTypeID= 1 ,@CurrencyID= 16034 ,@Number= 'WZ-0001' ,@Date= @d ,@OrdererName= 'OrdererName' ,@OrdererStreet= 'OrdererStreet' ,@OrdererCity= 'OrdererCity' ,@OrdererZIPCode= 'OrdererZIPCode' ,@OrdererCountry= 'OrdererCountry' ,@OrdererRegion= 'OrdererRegion' ,@OrdererState= 'OrdererState' ,@CompanyRegistrationNumber= 'CompanyRegistrationNumber' ,@VATNumber= 'VATNumber' ,@RecipientName= 'RecipientName' ,@RecipientStreet= 'RecipientStreet' ,@RecipientCity= 'RecipientCity' ,@RecipientZIPCode= 'RecipientZIPCode' ,@RecipientCountry= 'RecipientCountry' ,@RecipientRegion= 'RecipientRegion' ,@RecipientState= 'RecipientState' ,@RecipientNote= 'RecipientNote' ,@IsCanceled= 0 ,@IsCancelReason= '' ,@IsCancelDate= NULL ,@Note= '' ,@OrdererPhone= 'OrdererPhone' ,@OrdererFax= 'OrdererFax' ,@OrdererMobilePhone= 'OrdererMobilePhone' ,@OrdererEmail= 'OrdererEmail' ,@OrdererUrl= 'OrdererUrl' ,@RecipientPhone= 'RecipientPhone' ,@RecipientFax= 'RecipientFax' ,@RecipientMobilePhone= 'RecipientMobilePhone' ,@RecipientEmail= 'RecipientEmail' ,@RecipientUrl= 'RecipientUrl' ,@RecipientCompanyRegistrationNumber= 'RecipientCompanyRegistrationNumber' ,@RecipientVATNumber= 'RecipientVATNumber' ,@OrdererBankName= 'OrdererBankName' ,@OrdererBankAccount= 'OrdererBankAccount' ,@OrdererVATNumber2= 'OrdererVATNumber2' ,@RecipientVATNumber2= 'RecipientVATNumber2' ,@IsPrinted= 0 ,@PrintedDate= NULL ,@StornoDocument= -1 ,@StornoDocumentOriginID= -1 ,@CurrencyInCurrencyID= 16034 ,@ExchangeRate= 1
 </syntaxhighlight>
 ==== Notices ====
 None.

API CreateDeliveryNote - Historie editací

Chrzaszcz v 9. 11. 2018, 11:29

Chrzaszcz v 22. 9. 2017, 08:29

Chrzaszcz v 22. 9. 2017, 08:29

Chrzaszcz v 4. 8. 2017, 14:03

Chrzaszcz v 4. 8. 2017, 13:57

Chrzaszcz v 4. 8. 2017, 13:40

Chrzaszcz v 4. 8. 2017, 13:31

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to create new delivery note in system. ==== Exact name ==== API_CreateDeliveryNote ==== Type ==== St…“

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to create new delivery note in system. ==== Exact name ==== `API_CreateDeliveryNote` ==== Type ==== St…“