API CreateDeliveryNote - Historie editací

Chrzaszcz v 9. 11. 2018, 11:29

2018-11-09T11:29:05Z

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

Chrzaszcz v 22. 9. 2017, 08:29

2017-09-22T08:29:25Z

← Starší verze		Verze z 22. 9. 2017, 08:29
Řádek 354:		Řádek 354:
	==== Example ====		==== Example ====
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
			DECLARE @return_value int
	DECLARE @d datetime		DECLARE @d datetime
	set @d = getdate()		set @d = getdate()

	~~DECLARE @return_value int~~
	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		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>		</syntaxhighlight>

Chrzaszcz v 22. 9. 2017, 08:29

2017-09-22T08:29:00Z

← Starší verze		Verze z 22. 9. 2017, 08:29
Řádek 347:		Řádek 347:
	\|		\|
	\|}		\|}

			==== Return ====
			0 : OK
			100 : Item could not be created

	==== Example ====		==== Example ====
Řádek 353:		Řádek 357:
	set @d = getdate()		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
			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>		</syntaxhighlight>

	==== Notices ====		==== Notices ====
	None.		None.

Chrzaszcz v 4. 8. 2017, 14:03

2017-08-04T14:03:14Z

← Starší verze		Verze z 4. 8. 2017, 14:03
Řádek 263:		Řádek 263:
	\|		\|
	\|-		\|-
	\|@~~Recipient email~~		\|@RecipientEmail
	\|nvarchar(60)		\|nvarchar(60)
	\|		\|
Řádek 353:		Řádek 353:
	set @d = getdate()		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>		</syntaxhighlight>

	==== Notices ====		==== Notices ====
	None.		None.

Chrzaszcz v 4. 8. 2017, 13:57

2017-08-04T13:57:40Z

← Starší verze		Verze z 4. 8. 2017, 13:57
Řádek 350:		Řádek 350:
	==== Example ====		==== Example ====
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
			DECLARE @d datetime
			set @d = getdate()

	EXEC [API_CreateDeliveryNote] @Name = 'Name' ,@Description= 'Description'		EXEC [API_CreateDeliveryNote] @Name = 'Name' ,@Description= 'Description'
	</syntaxhighlight>		</syntaxhighlight>

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.

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