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