API CreateDeliveryNote: Porovnání verzí
Z Podpora.nextis.cz
(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…“) |
|||
| Řádka 18: | Řádka 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 | ||
| Řádka 23: | Řádka 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 | ||
| Řádka 28: | Řádka 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 | ||
| Řádka 33: | Řádka 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 | ||
| Řádka 38: | Řádka 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 | ||
| Řádka 43: | Řádka 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 | ||
| Řádka 48: | Řádka 54: | ||
|PaymentTypeID | |PaymentTypeID | ||
|int | |int | ||
| + | | | ||
|Payment type ID. | |Payment type ID. | ||
-1 - _NA | -1 - _NA | ||
| Řádka 66: | Řádka 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 | ||
| Řádka 71: | Řádka 79: | ||
|_del_Kurz | |_del_Kurz | ||
|decimal(18,6) | |decimal(18,6) | ||
| + | | | ||
|Exchange Rate | |Exchange Rate | ||
| | | | ||
| Řádka 76: | Řádka 85: | ||
|Number | |Number | ||
|varchar(25) | |varchar(25) | ||
| + | | | ||
|Number | |Number | ||
| | | | ||
| Řádka 81: | Řádka 91: | ||
|Date | |Date | ||
|datetime | |datetime | ||
| + | | | ||
|Date | |Date | ||
| | | | ||
| Řádka 86: | Řádka 97: | ||
|OrdererName | |OrdererName | ||
|varchar(140) | |varchar(140) | ||
| + | | | ||
|Orderer name | |Orderer name | ||
| | | | ||
| Řádka 91: | Řádka 103: | ||
|OrdererStreet | |OrdererStreet | ||
|varchar(100) | |varchar(100) | ||
| + | | | ||
|Orderer street | |Orderer street | ||
| | | | ||
| Řádka 96: | Řádka 109: | ||
|OrdererCity | |OrdererCity | ||
|varchar(140) | |varchar(140) | ||
| + | | | ||
|Orderer city | |Orderer city | ||
| | | | ||
| Řádka 101: | Řádka 115: | ||
|OrdererZIPCode | |OrdererZIPCode | ||
|char(10) | |char(10) | ||
| + | | | ||
|Orderer ZIP code | |Orderer ZIP code | ||
| | | | ||
| Řádka 106: | Řádka 121: | ||
|OrdererCountry | |OrdererCountry | ||
|varchar(50) | |varchar(50) | ||
| + | | | ||
|Orderer country | |Orderer country | ||
| | | | ||
| Řádka 111: | Řádka 127: | ||
|OrdererRegion | |OrdererRegion | ||
|varchar(30) | |varchar(30) | ||
| + | | | ||
|Orderer region | |Orderer region | ||
| | | | ||
| Řádka 116: | Řádka 133: | ||
|OrdererState | |OrdererState | ||
|varchar(50) | |varchar(50) | ||
| + | | | ||
|Orderer state | |Orderer state | ||
| | | | ||
| Řádka 121: | Řádka 139: | ||
|CompanyRegistrationNumber | |CompanyRegistrationNumber | ||
|char(20) | |char(20) | ||
| + | | | ||
|Company registration number | |Company registration number | ||
| | | | ||
| Řádka 126: | Řádka 145: | ||
|VATNumber | |VATNumber | ||
|char(20) | |char(20) | ||
| + | | | ||
|VAT number | |VAT number | ||
| | | | ||
| Řádka 131: | Řádka 151: | ||
|RecipientName | |RecipientName | ||
|varchar(140) | |varchar(140) | ||
| + | | | ||
|Recipient name | |Recipient name | ||
| | | | ||
| Řádka 136: | Řádka 157: | ||
|RecipientStreet | |RecipientStreet | ||
|varchar(100) | |varchar(100) | ||
| + | | | ||
|Recipient street | |Recipient street | ||
| | | | ||
| Řádka 141: | Řádka 163: | ||
|RecipientCity | |RecipientCity | ||
|varchar(140) | |varchar(140) | ||
| + | | | ||
|Recipient city | |Recipient city | ||
| | | | ||
| Řádka 146: | Řádka 169: | ||
|RecipientZIPCode | |RecipientZIPCode | ||
|char(10) | |char(10) | ||
| + | | | ||
|Recipient ZIP code | |Recipient ZIP code | ||
| | | | ||
| Řádka 151: | Řádka 175: | ||
|RecipientCountry | |RecipientCountry | ||
|varchar(50) | |varchar(50) | ||
| + | | | ||
|Recipient country | |Recipient country | ||
| | | | ||
| Řádka 156: | Řádka 181: | ||
|RecipientRegion | |RecipientRegion | ||
|varchar(30) | |varchar(30) | ||
| + | | | ||
|Recipient region | |Recipient region | ||
| | | | ||
| Řádka 161: | Řádka 187: | ||
|RecipientState | |RecipientState | ||
|varchar(50) | |varchar(50) | ||
| + | | | ||
|Recipient state | |Recipient state | ||
| | | | ||
| Řádka 166: | Řádka 193: | ||
|RecipientNote | |RecipientNote | ||
|nvarchar(250) | |nvarchar(250) | ||
| + | | | ||
|Recipient note | |Recipient note | ||
| | | | ||
| Řádka 171: | Řádka 199: | ||
|IsCanceled | |IsCanceled | ||
|int | |int | ||
| + | | | ||
|Is canceled | |Is canceled | ||
| | | | ||
| Řádka 176: | Řádka 205: | ||
|IsCancelReason | |IsCancelReason | ||
|varchar(150) | |varchar(150) | ||
| + | | | ||
|Is cancel reason | |Is cancel reason | ||
| | | | ||
| Řádka 181: | Řádka 211: | ||
|IsCancelDate | |IsCancelDate | ||
|datetime | |datetime | ||
| + | | | ||
|Is cancel date | |Is cancel date | ||
| | | | ||
| Řádka 186: | Řádka 217: | ||
|Note | |Note | ||
|varchar(300) | |varchar(300) | ||
| + | | | ||
|Note | |Note | ||
| | | | ||
| Řádka 191: | Řádka 223: | ||
|OrdererPhone | |OrdererPhone | ||
|nvarchar(30) | |nvarchar(30) | ||
| + | | | ||
|Orderer phone | |Orderer phone | ||
| | | | ||
| Řádka 196: | Řádka 229: | ||
|OrdererFax | |OrdererFax | ||
|nvarchar(30) | |nvarchar(30) | ||
| + | | | ||
|Orderer fax | |Orderer fax | ||
| | | | ||
| Řádka 201: | Řádka 235: | ||
|OrdererMobilePhone | |OrdererMobilePhone | ||
|nvarchar(30) | |nvarchar(30) | ||
| + | | | ||
|Orderer mobile phone | |Orderer mobile phone | ||
| | | | ||
| Řádka 206: | Řádka 241: | ||
|OrdererEmail | |OrdererEmail | ||
|nvarchar(60) | |nvarchar(60) | ||
| + | | | ||
|Orderer email | |Orderer email | ||
| | | | ||
| Řádka 211: | Řádka 247: | ||
|OrdererUrl | |OrdererUrl | ||
|nvarchar(50) | |nvarchar(50) | ||
| + | | | ||
|Orderer url | |Orderer url | ||
| | | | ||
| Řádka 216: | Řádka 253: | ||
|RecipientPhone | |RecipientPhone | ||
|nvarchar(30) | |nvarchar(30) | ||
| + | | | ||
|Recipient phone | |Recipient phone | ||
| | | | ||
| Řádka 221: | Řádka 259: | ||
|RecipientFax | |RecipientFax | ||
|nvarchar(30) | |nvarchar(30) | ||
| + | | | ||
|Recipient fax | |Recipient fax | ||
| | | | ||
| Řádka 226: | Řádka 265: | ||
|RecipientMobilePhone | |RecipientMobilePhone | ||
|nvarchar(30) | |nvarchar(30) | ||
| + | | | ||
|Recipient mobile phone | |Recipient mobile phone | ||
| | | | ||
| Řádka 231: | Řádka 271: | ||
|Recipient email | |Recipient email | ||
|nvarchar(60) | |nvarchar(60) | ||
| + | | | ||
|Recipient email | |Recipient email | ||
| | | | ||
| Řádka 236: | Řádka 277: | ||
|RecipientUrl | |RecipientUrl | ||
|nvarchar(50) | |nvarchar(50) | ||
| + | | | ||
|Recipient url | |Recipient url | ||
| | | | ||
| Řádka 241: | Řádka 283: | ||
|RecipientCompanyRegistrationNumber | |RecipientCompanyRegistrationNumber | ||
|char(20) | |char(20) | ||
| + | | | ||
|Recipient company registration number | |Recipient company registration number | ||
| | | | ||
| Řádka 246: | Řádka 289: | ||
|RecipientVATNumber | |RecipientVATNumber | ||
|char(20) | |char(20) | ||
| + | | | ||
|Recipient VAT number | |Recipient VAT number | ||
| | | | ||
| Řádka 251: | Řádka 295: | ||
|OrdererBankName | |OrdererBankName | ||
|nvarchar(120) | |nvarchar(120) | ||
| + | | | ||
|Orderer bank name | |Orderer bank name | ||
| | | | ||
| Řádka 256: | Řádka 301: | ||
|OrdererBankAccount | |OrdererBankAccount | ||
|nvarchar(50) | |nvarchar(50) | ||
| + | | | ||
|Orderer bank account | |Orderer bank account | ||
| | | | ||
| Řádka 261: | Řádka 307: | ||
|OrdererVATNumber2 | |OrdererVATNumber2 | ||
|char(20) | |char(20) | ||
| + | | | ||
|Orderer VAT number 2 | |Orderer VAT number 2 | ||
| | | | ||
| Řádka 266: | Řádka 313: | ||
|RecipientVATNumber2 | |RecipientVATNumber2 | ||
|char(20) | |char(20) | ||
| + | | | ||
|Recipient VAT number 2 | |Recipient VAT number 2 | ||
| | | | ||
| Řádka 271: | Řádka 319: | ||
|IsPrinted | |IsPrinted | ||
|int | |int | ||
| + | | | ||
|Is printed | |Is printed | ||
| | | | ||
| Řádka 276: | Řádka 325: | ||
|PrintedDate | |PrintedDate | ||
|date | |date | ||
| + | | | ||
|Printed date | |Printed date | ||
| | | | ||
| Řádka 281: | Řádka 331: | ||
|StornoDocument | |StornoDocument | ||
|int | |int | ||
| + | | | ||
|Storno document | |Storno document | ||
| | | | ||
| Řádka 286: | Řádka 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 | ||
| Řádka 291: | Řádka 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 | ||
| Řádka 296: | Řádka 349: | ||
|ExchangeRate | |ExchangeRate | ||
|decimal(18,2) | |decimal(18,2) | ||
| + | | | ||
|Exchange rate | |Exchange rate | ||
| | | | ||
Verze z 4. 8. 2017, 15: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.
