API UpdateDeliveryNote - Historie editací

Chrzaszcz v 9. 11. 2018, 11:55

2018-11-09T11:55:05Z

← Starší verze		Verze z 9. 11. 2018, 11:55
Řádek 370:		Řádek 370:
	DECLARE @PaymentTypeID int		DECLARE @PaymentTypeID int
	DECLARE @CurrencyID int		DECLARE @CurrencyID int
	DECLARE @Number ~~varchar~~(25)		DECLARE @Number nvarchar(25)
	DECLARE @Date datetime		DECLARE @Date datetime
	DECLARE @OrdererName ~~varchar~~(140)		DECLARE @OrdererName nvarchar(140)
	DECLARE @OrdererStreet ~~varchar~~(100)		DECLARE @OrdererStreet nvarchar(100)
	DECLARE @OrdererCity ~~varchar~~(140)		DECLARE @OrdererCity nvarchar(140)
	DECLARE @OrdererZIPCode ~~char~~(10)		DECLARE @OrdererZIPCode nvarchar(10)
	DECLARE @OrdererCountry ~~varchar~~(50)		DECLARE @OrdererCountry nvarchar(50)
	DECLARE @OrdererRegion ~~varchar~~(30)		DECLARE @OrdererRegion nvarchar(30)
	DECLARE @OrdererState ~~varchar~~(50)		DECLARE @OrdererState nvarchar(50)
	DECLARE @CompanyRegistrationNumber ~~char~~(20)		DECLARE @CompanyRegistrationNumber nvarchar(20)
	DECLARE @VATNumber ~~char~~(20)		DECLARE @VATNumber nvarchar(20)
	DECLARE @RecipientName ~~varchar~~(140)		DECLARE @RecipientName nvarchar(140)
	DECLARE @RecipientStreet ~~varchar~~(100)		DECLARE @RecipientStreet nvarchar(100)
	DECLARE @RecipientCity ~~varchar~~(140)		DECLARE @RecipientCity nvarchar(140)
	DECLARE @RecipientZIPCode ~~char~~(10)		DECLARE @RecipientZIPCode nvarchar(10)
	DECLARE @RecipientCountry ~~varchar~~(50)		DECLARE @RecipientCountry nvarchar(50)
	DECLARE @RecipientRegion ~~varchar~~(30)		DECLARE @RecipientRegion nvarchar(30)
	DECLARE @RecipientState ~~varchar~~(50)		DECLARE @RecipientState nvarchar(50)
	DECLARE @RecipientNote nvarchar(250)		DECLARE @RecipientNote nvarchar(250)
	DECLARE @IsCanceled int		DECLARE @IsCanceled int
	DECLARE @IsCancelReason ~~varchar~~(150)		DECLARE @IsCancelReason nvarchar(150)
	DECLARE @IsCancelDate datetime		DECLARE @IsCancelDate datetime
	DECLARE @Note ~~varchar~~(300)		DECLARE @Note nvarchar(300)
	DECLARE @OrdererPhone nvarchar(30)		DECLARE @OrdererPhone nvarchar(30)
	DECLARE @OrdererFax nvarchar(30)		DECLARE @OrdererFax nvarchar(30)
Řádek 403:		Řádek 403:
	DECLARE @RecipientEmail nvarchar(60)		DECLARE @RecipientEmail nvarchar(60)
	DECLARE @RecipientUrl nvarchar(50)		DECLARE @RecipientUrl nvarchar(50)
	DECLARE @RecipientCompanyRegistrationNumber ~~char~~(20)		DECLARE @RecipientCompanyRegistrationNumber nvarchar(20)
	DECLARE @RecipientVATNumber ~~char~~(20)		DECLARE @RecipientVATNumber nvarchar(20)
	DECLARE @OrdererBankName nvarchar(120)		DECLARE @OrdererBankName nvarchar(120)
	DECLARE @OrdererBankAccount nvarchar(50)		DECLARE @OrdererBankAccount nvarchar(50)
	DECLARE @OrdererVATNumber2 ~~char~~(20)		DECLARE @OrdererVATNumber2 nvarchar(20)
	DECLARE @RecipientVATNumber2 ~~char~~(20)		DECLARE @RecipientVATNumber2 nvarchar(20)
	DECLARE @IsPrinted int		DECLARE @IsPrinted int
	DECLARE @PrintedDate date		DECLARE @PrintedDate date

Chrzaszcz v 9. 11. 2018, 11:52

2018-11-09T11:52:13Z

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

Chrzaszcz v 22. 9. 2017, 08:30

2017-09-22T08:30:30Z

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

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

	==== Example ====		==== Example ====
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
			DECLARE @return_value int
	DECLARE @ID int		DECLARE @ID int
	DECLARE @StockID int		DECLARE @StockID int
Řádek 471:		Řádek 475:
	WHERE id = 15		WHERE id = 15

	EXECUTE [API_UpdateDeliveryNote]		EXECUTE @return_value = [API_UpdateDeliveryNote]
	@ID		@ID
	,@StockID		,@StockID

Chrzaszcz v 7. 8. 2017, 13:14

2017-08-07T13:14:40Z

Ukázat změny

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

2017-08-07T13:00:54Z

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

Nová stránka

==== Description ====
Method allows You to update delivery note in system.

==== Exact name ====
<code>API_UpdateDeliveryNote</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
|-
|@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
|
|-
|@RecipientEmail
|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">
DECLARE @ID INT
DECLARE @WorkshopID INT

SELECT @ID = id,
@WorkshopID = [workshopid],

FROM [API_GetDeliveryNote]
WHERE id = 3

EXECUTE [API_UpdateDeliveryNote]
@ID,

</syntaxhighlight>

==== Notices ====
None.

API UpdateDeliveryNote - Historie editací

Chrzaszcz v 9. 11. 2018, 11:55

Chrzaszcz v 9. 11. 2018, 11:52

Chrzaszcz v 22. 9. 2017, 08:30

Chrzaszcz v 7. 8. 2017, 13:14

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

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