API CreateDeliveryNote: Porovnání verzí

Z Podpora.nextis.cz
Skočit na navigaci Skočit na vyhledávání
Porovnání s novější verzí →

Chrzaszcz (diskuse | příspěvky)

2 uživatelské skupiny
542 editací
VizuálníWikitext
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…“
 
Bez shrnutí editace
Řádek 18: Řádek 18:
|StockID
|StockID
|int  
|int  
|
|ID of stock from stock list (see relation)
|ID of stock from stock list (see relation)
| API_GetStocks.ID
| API_GetStocks.ID
Řádek 23: Řádek 24:
|BranchID
|BranchID
|int  
|int  
|
|ID of branch from branch list (see relation)
|ID of branch from branch list (see relation)
| API_GetBranches.ID
| API_GetBranches.ID
Řádek 28: Řádek 30:
|SupplierID
|SupplierID
|int  
|int  
|
|ID of customer from customer list (see relation)
|ID of customer from customer list (see relation)
| API_GetCustomers.ID
| API_GetCustomers.ID
Řádek 33: Řádek 36:
|OrdererID
|OrdererID
|int  
|int  
|
|ID of customer from customer list (see relation)
|ID of customer from customer list (see relation)
| API_GetCustomers.ID
| API_GetCustomers.ID
Řádek 38: Řádek 42:
|RecipientID
|RecipientID
|int  
|int  
|
|ID of customer from customer list (see relation)
|ID of customer from customer list (see relation)
| API_GetCustomers.ID
| API_GetCustomers.ID
Řádek 43: Řádek 48:
|TransportID
|TransportID
|int  
|int  
|
|ID of transport from transport list (see relation)
|ID of transport from transport list (see relation)
| API_GetTransports.ID
| API_GetTransports.ID
Řádek 48: Řádek 54:
|PaymentTypeID
|PaymentTypeID
|int  
|int  
|
|Payment type ID.
|Payment type ID.
-1 - _NA
-1 - _NA
Řádek 66: Řádek 73:
|CurrencyID
|CurrencyID
|int  
|int  
|
|ID of currency from currency list (see relation)
|ID of currency from currency list (see relation)
| API_GetCurrency.ID
| API_GetCurrency.ID
Řádek 71: Řádek 79:
|_del_Kurz
|_del_Kurz
|decimal(18,6)  
|decimal(18,6)  
|
|Exchange Rate
|Exchange Rate
|  
|  
Řádek 76: Řádek 85:
|Number
|Number
|varchar(25)  
|varchar(25)  
|
|Number
|Number
|  
|  
Řádek 81: Řádek 91:
|Date
|Date
|datetime  
|datetime  
|
|Date
|Date
|  
|  
Řádek 86: Řádek 97:
|OrdererName
|OrdererName
|varchar(140)  
|varchar(140)  
|
|Orderer name
|Orderer name
|  
|  
Řádek 91: Řádek 103:
|OrdererStreet
|OrdererStreet
|varchar(100)  
|varchar(100)  
|
|Orderer street
|Orderer street
|  
|  
Řádek 96: Řádek 109:
|OrdererCity
|OrdererCity
|varchar(140)  
|varchar(140)  
|
|Orderer city
|Orderer city
|  
|  
Řádek 101: Řádek 115:
|OrdererZIPCode
|OrdererZIPCode
|char(10)  
|char(10)  
|
|Orderer ZIP code
|Orderer ZIP code
|  
|  
Řádek 106: Řádek 121:
|OrdererCountry
|OrdererCountry
|varchar(50)  
|varchar(50)  
|
|Orderer country
|Orderer country
|  
|  
Řádek 111: Řádek 127:
|OrdererRegion
|OrdererRegion
|varchar(30)  
|varchar(30)  
|
|Orderer region
|Orderer region
|  
|  
Řádek 116: Řádek 133:
|OrdererState
|OrdererState
|varchar(50)  
|varchar(50)  
|
|Orderer state
|Orderer state
|  
|  
Řádek 121: Řádek 139:
|CompanyRegistrationNumber
|CompanyRegistrationNumber
|char(20)  
|char(20)  
|
|Company registration number
|Company registration number
|  
|  
Řádek 126: Řádek 145:
|VATNumber
|VATNumber
|char(20)  
|char(20)  
|
|VAT number
|VAT number
|  
|  
Řádek 131: Řádek 151:
|RecipientName
|RecipientName
|varchar(140)  
|varchar(140)  
|
|Recipient name
|Recipient name
|  
|  
Řádek 136: Řádek 157:
|RecipientStreet
|RecipientStreet
|varchar(100)  
|varchar(100)  
|
|Recipient street
|Recipient street
|  
|  
Řádek 141: Řádek 163:
|RecipientCity
|RecipientCity
|varchar(140)  
|varchar(140)  
|
|Recipient city
|Recipient city
|  
|  
Řádek 146: Řádek 169:
|RecipientZIPCode
|RecipientZIPCode
|char(10)  
|char(10)  
|
|Recipient ZIP code
|Recipient ZIP code
|  
|  
Řádek 151: Řádek 175:
|RecipientCountry
|RecipientCountry
|varchar(50)  
|varchar(50)  
|
|Recipient country
|Recipient country
|  
|  
Řádek 156: Řádek 181:
|RecipientRegion
|RecipientRegion
|varchar(30)  
|varchar(30)  
|
|Recipient region
|Recipient region
|  
|  
Řádek 161: Řádek 187:
|RecipientState
|RecipientState
|varchar(50)  
|varchar(50)  
|
|Recipient state
|Recipient state
|  
|  
Řádek 166: Řádek 193:
|RecipientNote
|RecipientNote
|nvarchar(250)  
|nvarchar(250)  
|
|Recipient note
|Recipient note
|  
|  
Řádek 171: Řádek 199:
|IsCanceled
|IsCanceled
|int  
|int  
|
|Is canceled
|Is canceled
|  
|  
Řádek 176: Řádek 205:
|IsCancelReason
|IsCancelReason
|varchar(150)  
|varchar(150)  
|
|Is cancel reason
|Is cancel reason
|  
|  
Řádek 181: Řádek 211:
|IsCancelDate
|IsCancelDate
|datetime  
|datetime  
|
|Is cancel date
|Is cancel date
|  
|  
Řádek 186: Řádek 217:
|Note
|Note
|varchar(300)  
|varchar(300)  
|
|Note
|Note
|  
|  
Řádek 191: Řádek 223:
|OrdererPhone
|OrdererPhone
|nvarchar(30)  
|nvarchar(30)  
|
|Orderer phone
|Orderer phone
|  
|  
Řádek 196: Řádek 229:
|OrdererFax
|OrdererFax
|nvarchar(30)  
|nvarchar(30)  
|
|Orderer fax
|Orderer fax
|  
|  
Řádek 201: Řádek 235:
|OrdererMobilePhone
|OrdererMobilePhone
|nvarchar(30)  
|nvarchar(30)  
|
|Orderer mobile phone
|Orderer mobile phone
|  
|  
Řádek 206: Řádek 241:
|OrdererEmail
|OrdererEmail
|nvarchar(60)  
|nvarchar(60)  
|
|Orderer email
|Orderer email
|  
|  
Řádek 211: Řádek 247:
|OrdererUrl
|OrdererUrl
|nvarchar(50)  
|nvarchar(50)  
|
|Orderer url
|Orderer url
|  
|  
Řádek 216: Řádek 253:
|RecipientPhone
|RecipientPhone
|nvarchar(30)  
|nvarchar(30)  
|
|Recipient phone
|Recipient phone
|  
|  
Řádek 221: Řádek 259:
|RecipientFax
|RecipientFax
|nvarchar(30)  
|nvarchar(30)  
|
|Recipient fax
|Recipient fax
|  
|  
Řádek 226: Řádek 265:
|RecipientMobilePhone
|RecipientMobilePhone
|nvarchar(30)  
|nvarchar(30)  
|
|Recipient mobile phone
|Recipient mobile phone
|  
|  
Řádek 231: Řádek 271:
|Recipient email
|Recipient email
|nvarchar(60)  
|nvarchar(60)  
|
|Recipient email
|Recipient email
|  
|  
Řádek 236: Řádek 277:
|RecipientUrl
|RecipientUrl
|nvarchar(50)  
|nvarchar(50)  
|
|Recipient url
|Recipient url
|  
|  
Řádek 241: Řádek 283:
|RecipientCompanyRegistrationNumber
|RecipientCompanyRegistrationNumber
|char(20)  
|char(20)  
|
|Recipient company registration number
|Recipient company registration number
|  
|  
Řádek 246: Řádek 289:
|RecipientVATNumber
|RecipientVATNumber
|char(20)  
|char(20)  
|
|Recipient VAT number
|Recipient VAT number
|  
|  
Řádek 251: Řádek 295:
|OrdererBankName
|OrdererBankName
|nvarchar(120)  
|nvarchar(120)  
|
|Orderer bank name
|Orderer bank name
|  
|  
Řádek 256: Řádek 301:
|OrdererBankAccount
|OrdererBankAccount
|nvarchar(50)  
|nvarchar(50)  
|
|Orderer bank account
|Orderer bank account
|  
|  
Řádek 261: Řádek 307:
|OrdererVATNumber2
|OrdererVATNumber2
|char(20)  
|char(20)  
|
|Orderer VAT number 2
|Orderer VAT number 2
|  
|  
Řádek 266: Řádek 313:
|RecipientVATNumber2
|RecipientVATNumber2
|char(20)  
|char(20)  
|
|Recipient VAT number 2
|Recipient VAT number 2
|  
|  
Řádek 271: Řádek 319:
|IsPrinted
|IsPrinted
|int  
|int  
|
|Is printed
|Is printed
|  
|  
Řádek 276: Řádek 325:
|PrintedDate
|PrintedDate
|date  
|date  
|
|Printed date
|Printed date
|  
|  
Řádek 281: Řádek 331:
|StornoDocument
|StornoDocument
|int  
|int  
|
|Storno document
|Storno document
|  
|  
Řádek 286: Řádek 337:
|StornoDocumentOriginID
|StornoDocumentOriginID
|int  
|int  
|
|ID of delivery note from delivery note list (see relation)
|ID of delivery note from delivery note list (see relation)
| API_GetDeliveryNote.ID
| API_GetDeliveryNote.ID
Řádek 291: Řádek 343:
|CurrencyInCurrencyID
|CurrencyInCurrencyID
|int  
|int  
|
|ID of currency from currency list (see relation)
|ID of currency from currency list (see relation)
| API_GetCurrency.ID
| API_GetCurrency.ID
Řádek 296: Řádek 349:
|ExchangeRate
|ExchangeRate
|decimal(18,2)  
|decimal(18,2)  
|
|Exchange rate
|Exchange rate
|  
|  

Verze z 4. 8. 2017, 13:31

Description

Method allows You to create new delivery note in system.

Exact name

API_CreateDeliveryNote

Type

Standard executable stored procedure.

Specification

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

EXEC [API_CreateDeliveryNote] @Name = 'Name' ,@Description= 'Description'

Notices

None.

Citováno z „https://podpora.nextis.cz/index.php?title=API_CreateDeliveryNote&oldid=433“