API CreateDeliveryNote: Porovnání verzí
Z Podpora.nextis.cz
| Řádka 16: | Řádka 16: | ||
!Relation | !Relation | ||
|- | |- | ||
| − | |StockID | + | |@StockID |
|int | |int | ||
| | | | ||
| Řádka 22: | Řádka 22: | ||
| API_GetStocks.ID | | API_GetStocks.ID | ||
|- | |- | ||
| − | |BranchID | + | |@BranchID |
|int | |int | ||
| | | | ||
| Řádka 28: | Řádka 28: | ||
| API_GetBranches.ID | | API_GetBranches.ID | ||
|- | |- | ||
| − | |SupplierID | + | |@SupplierID |
|int | |int | ||
| | | | ||
| Řádka 34: | Řádka 34: | ||
| API_GetCustomers.ID | | API_GetCustomers.ID | ||
|- | |- | ||
| − | |OrdererID | + | |@OrdererID |
|int | |int | ||
| | | | ||
| Řádka 40: | Řádka 40: | ||
| API_GetCustomers.ID | | API_GetCustomers.ID | ||
|- | |- | ||
| − | |RecipientID | + | |@RecipientID |
|int | |int | ||
| | | | ||
| Řádka 46: | Řádka 46: | ||
| API_GetCustomers.ID | | API_GetCustomers.ID | ||
|- | |- | ||
| − | |TransportID | + | |@TransportID |
|int | |int | ||
| | | | ||
| Řádka 52: | Řádka 52: | ||
| API_GetTransports.ID | | API_GetTransports.ID | ||
|- | |- | ||
| − | |PaymentTypeID | + | |@PaymentTypeID |
|int | |int | ||
| | | | ||
| Řádka 71: | Řádka 71: | ||
| | | | ||
|- | |- | ||
| − | |CurrencyID | + | |@CurrencyID |
|int | |int | ||
| | | | ||
| Řádka 77: | Řádka 77: | ||
| API_GetCurrency.ID | | API_GetCurrency.ID | ||
|- | |- | ||
| − | | | + | |@Number |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|varchar(25) | |varchar(25) | ||
| | | | ||
| Řádka 89: | Řádka 83: | ||
| | | | ||
|- | |- | ||
| − | |Date | + | |@Date |
|datetime | |datetime | ||
| | | | ||
| Řádka 95: | Řádka 89: | ||
| | | | ||
|- | |- | ||
| − | |OrdererName | + | |@OrdererName |
|varchar(140) | |varchar(140) | ||
| | | | ||
| Řádka 101: | Řádka 95: | ||
| | | | ||
|- | |- | ||
| − | |OrdererStreet | + | |@OrdererStreet |
|varchar(100) | |varchar(100) | ||
| | | | ||
| Řádka 107: | Řádka 101: | ||
| | | | ||
|- | |- | ||
| − | |OrdererCity | + | |@OrdererCity |
|varchar(140) | |varchar(140) | ||
| | | | ||
| Řádka 113: | Řádka 107: | ||
| | | | ||
|- | |- | ||
| − | |OrdererZIPCode | + | |@OrdererZIPCode |
|char(10) | |char(10) | ||
| | | | ||
| Řádka 119: | Řádka 113: | ||
| | | | ||
|- | |- | ||
| − | |OrdererCountry | + | |@OrdererCountry |
|varchar(50) | |varchar(50) | ||
| | | | ||
| Řádka 125: | Řádka 119: | ||
| | | | ||
|- | |- | ||
| − | |OrdererRegion | + | |@OrdererRegion |
|varchar(30) | |varchar(30) | ||
| | | | ||
| Řádka 131: | Řádka 125: | ||
| | | | ||
|- | |- | ||
| − | |OrdererState | + | |@OrdererState |
|varchar(50) | |varchar(50) | ||
| | | | ||
| Řádka 137: | Řádka 131: | ||
| | | | ||
|- | |- | ||
| − | |CompanyRegistrationNumber | + | |@CompanyRegistrationNumber |
|char(20) | |char(20) | ||
| | | | ||
| Řádka 143: | Řádka 137: | ||
| | | | ||
|- | |- | ||
| − | |VATNumber | + | |@VATNumber |
|char(20) | |char(20) | ||
| | | | ||
| Řádka 149: | Řádka 143: | ||
| | | | ||
|- | |- | ||
| − | |RecipientName | + | |@RecipientName |
|varchar(140) | |varchar(140) | ||
| | | | ||
| Řádka 155: | Řádka 149: | ||
| | | | ||
|- | |- | ||
| − | |RecipientStreet | + | |@RecipientStreet |
|varchar(100) | |varchar(100) | ||
| | | | ||
| Řádka 161: | Řádka 155: | ||
| | | | ||
|- | |- | ||
| − | |RecipientCity | + | |@RecipientCity |
|varchar(140) | |varchar(140) | ||
| | | | ||
| Řádka 167: | Řádka 161: | ||
| | | | ||
|- | |- | ||
| − | |RecipientZIPCode | + | |@RecipientZIPCode |
|char(10) | |char(10) | ||
| | | | ||
| Řádka 173: | Řádka 167: | ||
| | | | ||
|- | |- | ||
| − | |RecipientCountry | + | |@RecipientCountry |
|varchar(50) | |varchar(50) | ||
| | | | ||
| Řádka 179: | Řádka 173: | ||
| | | | ||
|- | |- | ||
| − | |RecipientRegion | + | |@RecipientRegion |
|varchar(30) | |varchar(30) | ||
| | | | ||
| Řádka 185: | Řádka 179: | ||
| | | | ||
|- | |- | ||
| − | |RecipientState | + | |@RecipientState |
|varchar(50) | |varchar(50) | ||
| | | | ||
| Řádka 191: | Řádka 185: | ||
| | | | ||
|- | |- | ||
| − | |RecipientNote | + | |@RecipientNote |
|nvarchar(250) | |nvarchar(250) | ||
| | | | ||
| Řádka 197: | Řádka 191: | ||
| | | | ||
|- | |- | ||
| − | |IsCanceled | + | |@IsCanceled |
|int | |int | ||
| | | | ||
| Řádka 203: | Řádka 197: | ||
| | | | ||
|- | |- | ||
| − | |IsCancelReason | + | |@IsCancelReason |
|varchar(150) | |varchar(150) | ||
| | | | ||
| Řádka 209: | Řádka 203: | ||
| | | | ||
|- | |- | ||
| − | |IsCancelDate | + | |@IsCancelDate |
|datetime | |datetime | ||
| | | | ||
| Řádka 215: | Řádka 209: | ||
| | | | ||
|- | |- | ||
| − | |Note | + | |@Note |
|varchar(300) | |varchar(300) | ||
| | | | ||
| Řádka 221: | Řádka 215: | ||
| | | | ||
|- | |- | ||
| − | |OrdererPhone | + | |@OrdererPhone |
|nvarchar(30) | |nvarchar(30) | ||
| | | | ||
| Řádka 227: | Řádka 221: | ||
| | | | ||
|- | |- | ||
| − | |OrdererFax | + | |@OrdererFax |
|nvarchar(30) | |nvarchar(30) | ||
| | | | ||
| Řádka 233: | Řádka 227: | ||
| | | | ||
|- | |- | ||
| − | |OrdererMobilePhone | + | |@OrdererMobilePhone |
|nvarchar(30) | |nvarchar(30) | ||
| | | | ||
| Řádka 239: | Řádka 233: | ||
| | | | ||
|- | |- | ||
| − | |OrdererEmail | + | |@OrdererEmail |
|nvarchar(60) | |nvarchar(60) | ||
| | | | ||
| Řádka 245: | Řádka 239: | ||
| | | | ||
|- | |- | ||
| − | |OrdererUrl | + | |@OrdererUrl |
|nvarchar(50) | |nvarchar(50) | ||
| | | | ||
| Řádka 251: | Řádka 245: | ||
| | | | ||
|- | |- | ||
| − | |RecipientPhone | + | |@RecipientPhone |
|nvarchar(30) | |nvarchar(30) | ||
| | | | ||
| Řádka 257: | Řádka 251: | ||
| | | | ||
|- | |- | ||
| − | |RecipientFax | + | |@RecipientFax |
|nvarchar(30) | |nvarchar(30) | ||
| | | | ||
| Řádka 263: | Řádka 257: | ||
| | | | ||
|- | |- | ||
| − | |RecipientMobilePhone | + | |@RecipientMobilePhone |
|nvarchar(30) | |nvarchar(30) | ||
| | | | ||
| Řádka 269: | Řádka 263: | ||
| | | | ||
|- | |- | ||
| − | |Recipient email | + | |@Recipient email |
|nvarchar(60) | |nvarchar(60) | ||
| | | | ||
| Řádka 275: | Řádka 269: | ||
| | | | ||
|- | |- | ||
| − | |RecipientUrl | + | |@RecipientUrl |
|nvarchar(50) | |nvarchar(50) | ||
| | | | ||
| Řádka 281: | Řádka 275: | ||
| | | | ||
|- | |- | ||
| − | |RecipientCompanyRegistrationNumber | + | |@RecipientCompanyRegistrationNumber |
|char(20) | |char(20) | ||
| | | | ||
| Řádka 287: | Řádka 281: | ||
| | | | ||
|- | |- | ||
| − | |RecipientVATNumber | + | |@RecipientVATNumber |
|char(20) | |char(20) | ||
| | | | ||
| Řádka 293: | Řádka 287: | ||
| | | | ||
|- | |- | ||
| − | |OrdererBankName | + | |@OrdererBankName |
|nvarchar(120) | |nvarchar(120) | ||
| | | | ||
| Řádka 299: | Řádka 293: | ||
| | | | ||
|- | |- | ||
| − | |OrdererBankAccount | + | |@OrdererBankAccount |
|nvarchar(50) | |nvarchar(50) | ||
| | | | ||
| Řádka 305: | Řádka 299: | ||
| | | | ||
|- | |- | ||
| − | |OrdererVATNumber2 | + | |@OrdererVATNumber2 |
|char(20) | |char(20) | ||
| | | | ||
| Řádka 311: | Řádka 305: | ||
| | | | ||
|- | |- | ||
| − | |RecipientVATNumber2 | + | |@RecipientVATNumber2 |
|char(20) | |char(20) | ||
| | | | ||
| Řádka 317: | Řádka 311: | ||
| | | | ||
|- | |- | ||
| − | |IsPrinted | + | |@IsPrinted |
|int | |int | ||
| | | | ||
| Řádka 323: | Řádka 317: | ||
| | | | ||
|- | |- | ||
| − | |PrintedDate | + | |@PrintedDate |
|date | |date | ||
| | | | ||
| Řádka 329: | Řádka 323: | ||
| | | | ||
|- | |- | ||
| − | |StornoDocument | + | |@StornoDocument |
|int | |int | ||
| | | | ||
| Řádka 335: | Řádka 329: | ||
| | | | ||
|- | |- | ||
| − | |StornoDocumentOriginID | + | |@StornoDocumentOriginID |
|int | |int | ||
| | | | ||
| Řádka 341: | Řádka 335: | ||
| API_GetDeliveryNote.ID | | API_GetDeliveryNote.ID | ||
|- | |- | ||
| − | |CurrencyInCurrencyID | + | |@CurrencyInCurrencyID |
|int | |int | ||
| | | | ||
| Řádka 347: | Řádka 341: | ||
| API_GetCurrency.ID | | API_GetCurrency.ID | ||
|- | |- | ||
| − | |ExchangeRate | + | |@ExchangeRate |
|decimal(18,2) | |decimal(18,2) | ||
| | | | ||
Verze z 4. 8. 2017, 15:40
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 | |
| @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.
