API UpdateDeliveryNote: Porovnání verzí
Z Podpora.nextis.cz
| Řádka 370: | Řádka 370: | ||
DECLARE @PaymentTypeID int | DECLARE @PaymentTypeID int | ||
DECLARE @CurrencyID int | DECLARE @CurrencyID int | ||
| − | DECLARE @Number | + | DECLARE @Number nvarchar(25) |
DECLARE @Date datetime | DECLARE @Date datetime | ||
| − | DECLARE @OrdererName | + | DECLARE @OrdererName nvarchar(140) |
| − | DECLARE @OrdererStreet | + | DECLARE @OrdererStreet nvarchar(100) |
| − | DECLARE @OrdererCity | + | DECLARE @OrdererCity nvarchar(140) |
| − | DECLARE @OrdererZIPCode | + | DECLARE @OrdererZIPCode nvarchar(10) |
| − | DECLARE @OrdererCountry | + | DECLARE @OrdererCountry nvarchar(50) |
| − | DECLARE @OrdererRegion | + | DECLARE @OrdererRegion nvarchar(30) |
| − | DECLARE @OrdererState | + | DECLARE @OrdererState nvarchar(50) |
| − | DECLARE @CompanyRegistrationNumber | + | DECLARE @CompanyRegistrationNumber nvarchar(20) |
| − | DECLARE @VATNumber | + | DECLARE @VATNumber nvarchar(20) |
| − | DECLARE @RecipientName | + | DECLARE @RecipientName nvarchar(140) |
| − | DECLARE @RecipientStreet | + | DECLARE @RecipientStreet nvarchar(100) |
| − | DECLARE @RecipientCity | + | DECLARE @RecipientCity nvarchar(140) |
| − | DECLARE @RecipientZIPCode | + | DECLARE @RecipientZIPCode nvarchar(10) |
| − | DECLARE @RecipientCountry | + | DECLARE @RecipientCountry nvarchar(50) |
| − | DECLARE @RecipientRegion | + | DECLARE @RecipientRegion nvarchar(30) |
| − | DECLARE @RecipientState | + | DECLARE @RecipientState nvarchar(50) |
DECLARE @RecipientNote nvarchar(250) | DECLARE @RecipientNote nvarchar(250) | ||
DECLARE @IsCanceled int | DECLARE @IsCanceled int | ||
| − | DECLARE @IsCancelReason | + | DECLARE @IsCancelReason nvarchar(150) |
DECLARE @IsCancelDate datetime | DECLARE @IsCancelDate datetime | ||
| − | DECLARE @Note | + | DECLARE @Note nvarchar(300) |
DECLARE @OrdererPhone nvarchar(30) | DECLARE @OrdererPhone nvarchar(30) | ||
DECLARE @OrdererFax nvarchar(30) | DECLARE @OrdererFax nvarchar(30) | ||
| Řádka 403: | Řádka 403: | ||
DECLARE @RecipientEmail nvarchar(60) | DECLARE @RecipientEmail nvarchar(60) | ||
DECLARE @RecipientUrl nvarchar(50) | DECLARE @RecipientUrl nvarchar(50) | ||
| − | DECLARE @RecipientCompanyRegistrationNumber | + | DECLARE @RecipientCompanyRegistrationNumber nvarchar(20) |
| − | DECLARE @RecipientVATNumber | + | DECLARE @RecipientVATNumber nvarchar(20) |
DECLARE @OrdererBankName nvarchar(120) | DECLARE @OrdererBankName nvarchar(120) | ||
DECLARE @OrdererBankAccount nvarchar(50) | DECLARE @OrdererBankAccount nvarchar(50) | ||
| − | DECLARE @OrdererVATNumber2 | + | DECLARE @OrdererVATNumber2 nvarchar(20) |
| − | DECLARE @RecipientVATNumber2 | + | DECLARE @RecipientVATNumber2 nvarchar(20) |
DECLARE @IsPrinted int | DECLARE @IsPrinted int | ||
DECLARE @PrintedDate date | DECLARE @PrintedDate date | ||
Aktuální verze z 9. 11. 2018, 12:55
Description
Method allows You to update delivery note in system.
Exact name
API_UpdateDeliveryNote
Type
Standard executable stored procedure.
Specification
| Parameter | Data type | Value range | Description | Relation |
|---|---|---|---|---|
| @ID | int | Internal system id | API_GetDeliveryNote.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 | |
| @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 | nvarchar(25) | Number | ||
| @Date | datetime | Date | ||
| @OrdererName | nvarchar(140) | Orderer name | ||
| @OrdererStreet | nvarchar(100) | Orderer street | ||
| @OrdererCity | nvarchar(140) | Orderer city | ||
| @OrdererZIPCode | nvarchar(10) | Orderer ZIP code | ||
| @OrdererCountry | nvarchar(50) | Orderer country | ||
| @OrdererRegion | nvarchar(30) | Orderer region | ||
| @OrdererState | nvarchar(50) | Orderer state | ||
| @CompanyRegistrationNumber | nvarchar(20) | Company registration number | ||
| @VATNumber | nvarchar(20) | VAT number | ||
| @RecipientName | nvarchar(140) | Recipient name | ||
| @RecipientStreet | nvarchar(100) | Recipient street | ||
| @RecipientCity | nvarchar(140) | Recipient city | ||
| @RecipientZIPCode | nvarchar(10) | Recipient ZIP code | ||
| @RecipientCountry | nvarchar(50) | Recipient country | ||
| @RecipientRegion | nvarchar(30) | Recipient region | ||
| @RecipientState | nvarchar(50) | Recipient state | ||
| @RecipientNote | nvarchar(250) | Recipient note | ||
| @IsCanceled | int | Is canceled | ||
| @IsCancelReason | nvarchar(150) | Is cancel reason | ||
| @IsCancelDate | datetime | Is cancel date | ||
| @Note | nvarchar(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 | nvarchar(20) | Recipient company registration number | ||
| @RecipientVATNumber | nvarchar(20) | Recipient VAT number | ||
| @OrdererBankName | nvarchar(120) | Orderer bank name | ||
| @OrdererBankAccount | nvarchar(50) | Orderer bank account | ||
| @OrdererVATNumber2 | nvarchar(20) | Orderer VAT number 2 | ||
| @RecipientVATNumber2 | nvarchar(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 |
Return
0 : OK 100 : Item could not be updated
Example
DECLARE @return_value int
DECLARE @ID int
DECLARE @StockID int
DECLARE @BranchID int
DECLARE @SupplierID int
DECLARE @OrdererID int
DECLARE @RecipientID int
DECLARE @TransportID int
DECLARE @PaymentTypeID int
DECLARE @CurrencyID int
DECLARE @Number nvarchar(25)
DECLARE @Date datetime
DECLARE @OrdererName nvarchar(140)
DECLARE @OrdererStreet nvarchar(100)
DECLARE @OrdererCity nvarchar(140)
DECLARE @OrdererZIPCode nvarchar(10)
DECLARE @OrdererCountry nvarchar(50)
DECLARE @OrdererRegion nvarchar(30)
DECLARE @OrdererState nvarchar(50)
DECLARE @CompanyRegistrationNumber nvarchar(20)
DECLARE @VATNumber nvarchar(20)
DECLARE @RecipientName nvarchar(140)
DECLARE @RecipientStreet nvarchar(100)
DECLARE @RecipientCity nvarchar(140)
DECLARE @RecipientZIPCode nvarchar(10)
DECLARE @RecipientCountry nvarchar(50)
DECLARE @RecipientRegion nvarchar(30)
DECLARE @RecipientState nvarchar(50)
DECLARE @RecipientNote nvarchar(250)
DECLARE @IsCanceled int
DECLARE @IsCancelReason nvarchar(150)
DECLARE @IsCancelDate datetime
DECLARE @Note nvarchar(300)
DECLARE @OrdererPhone nvarchar(30)
DECLARE @OrdererFax nvarchar(30)
DECLARE @OrdererMobilePhone nvarchar(30)
DECLARE @OrdererEmail nvarchar(60)
DECLARE @OrdererUrl nvarchar(50)
DECLARE @RecipientPhone nvarchar(30)
DECLARE @RecipientFax nvarchar(30)
DECLARE @RecipientMobilePhone nvarchar(30)
DECLARE @RecipientEmail nvarchar(60)
DECLARE @RecipientUrl nvarchar(50)
DECLARE @RecipientCompanyRegistrationNumber nvarchar(20)
DECLARE @RecipientVATNumber nvarchar(20)
DECLARE @OrdererBankName nvarchar(120)
DECLARE @OrdererBankAccount nvarchar(50)
DECLARE @OrdererVATNumber2 nvarchar(20)
DECLARE @RecipientVATNumber2 nvarchar(20)
DECLARE @IsPrinted int
DECLARE @PrintedDate date
DECLARE @StornoDocument int
DECLARE @StornoDocumentOriginID int
DECLARE @CurrencyInCurrencyID int
DECLARE @ExchangeRate decimal(18,2)
SELECT @ID = [ID],
@StockID = [StockID],
@BranchID = [BranchID],
@SupplierID = [SupplierID],
@OrdererID = [OrdererID],
@RecipientID = [RecipientID],
@TransportID = [TransportID],
@PaymentTypeID = [PaymentTypeID],
@CurrencyID = [CurrencyID],
@Number = '321564Z',
@Date = [Date],
@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 = [IsCanceled],
@IsCancelReason = [IsCancelReason],
@IsCancelDate = [IsCancelDate],
@Note = [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 = [IsPrinted],
@PrintedDate = [PrintedDate],
@StornoDocument = [StornoDocument],
@StornoDocumentOriginID = [StornoDocumentOriginID],
@CurrencyInCurrencyID = [CurrencyInCurrencyID],
@ExchangeRate = [ExchangeRate]
FROM [API_GetDeliveryNote]
WHERE id = 15
EXECUTE @return_value = [API_UpdateDeliveryNote]
@ID
,@StockID
,@BranchID
,@SupplierID
,@OrdererID
,@RecipientID
,@TransportID
,@PaymentTypeID
,@CurrencyID
,@Number
,@Date
,@OrdererName
,@OrdererStreet
,@OrdererCity
,@OrdererZIPCode
,@OrdererCountry
,@OrdererRegion
,@OrdererState
,@CompanyRegistrationNumber
,@VATNumber
,@RecipientName
,@RecipientStreet
,@RecipientCity
,@RecipientZIPCode
,@RecipientCountry
,@RecipientRegion
,@RecipientState
,@RecipientNote
,@IsCanceled
,@IsCancelReason
,@IsCancelDate
,@Note
,@OrdererPhone
,@OrdererFax
,@OrdererMobilePhone
,@OrdererEmail
,@OrdererUrl
,@RecipientPhone
,@RecipientFax
,@RecipientMobilePhone
,@RecipientEmail
,@RecipientUrl
,@RecipientCompanyRegistrationNumber
,@RecipientVATNumber
,@OrdererBankName
,@OrdererBankAccount
,@OrdererVATNumber2
,@RecipientVATNumber2
,@IsPrinted
,@PrintedDate
,@StornoDocument
,@StornoDocumentOriginID
,@CurrencyInCurrencyID
,@ExchangeRate
Notices
None.
