API GetDeliveryNote: Porovnání verzí

Z Podpora.nextis.cz
Přejít na: navigace, hledání
(Založena nová stránka s textem „====Description==== Method gives You overview of existing delivery note in system. ====Exact name==== <code>API_GetDeliveryNote</code> ====Type==== Standar…“)
 
 
(Nejsou zobrazeny 4 mezilehlé verze od stejného uživatele.)
Řádka 19: Řádka 19:
 
|StockID
 
|StockID
 
|int  
 
|int  
−
|
+
|ID of stock from stock list (see relation)
−
|  
+
| API_GetStocks.ID
 
|-  
 
|-  
 
|BranchID
 
|BranchID
 
|int  
 
|int  
−
|
+
|ID of branch from branch list (see relation)
−
|  
+
| API_GetBranches.ID
 
|-  
 
|-  
 
|SupplierID
 
|SupplierID
 
|int  
 
|int  
−
|
+
|ID of customer from customer list (see relation)
−
|  
+
| API_GetCustomers.ID
 
|-  
 
|-  
 
|OrdererID
 
|OrdererID
 
|int  
 
|int  
−
|
+
|ID of customer from customer list (see relation)
−
|  
+
| API_GetCustomers.ID
 
|-  
 
|-  
 
|RecipientID
 
|RecipientID
 
|int  
 
|int  
−
|
+
|ID of customer from customer list (see relation)
−
|  
+
| API_GetCustomers.ID
 
|-  
 
|-  
 
|TransportID
 
|TransportID
 
|int  
 
|int  
−
|
+
|ID of transport from transport list (see relation)
−
|  
+
| API_GetTransports.ID
 
|-  
 
|-  
 
|PaymentTypeID
 
|PaymentTypeID
 
|int  
 
|int  
−
|PaymentTypeID
+
|Payment type ID.
 +
-1 - _NA
 +
 
 +
1 - Cash
 +
 
 +
2 - WireTransfer
 +
 
 +
3 - CreditCard
 +
 
 +
4 - Before
 +
 
 +
5 - Voucher
 +
 
 +
6 - CashOnDelivery
 
|  
 
|  
 
|-  
 
|-  
 
|CurrencyID
 
|CurrencyID
 
|int  
 
|int  
−
|
+
|ID of currency from currency list (see relation)
−
|
+
| API_GetCurrency.ID
−
|-
 
−
|_del_Kurz
 
−
|decimal(18,6)  
 
−
|_del_Kurz
 
−
|
 
 
|-  
 
|-  
 
|Number
 
|Number
−
|varchar(25)  
+
|nvarchar(25)  
 
|Number
 
|Number
 
|  
 
|  
Řádka 73: Řádka 81:
 
|-  
 
|-  
 
|OrdererName
 
|OrdererName
−
|varchar(140)  
+
|nvarchar(140)  
−
|OrdererName
+
|Orderer name
 
|  
 
|  
 
|-  
 
|-  
 
|OrdererStreet
 
|OrdererStreet
−
|varchar(100)  
+
|nvarchar(100)  
−
|OrdererStreet
+
|Orderer street
 
|  
 
|  
 
|-  
 
|-  
 
|OrdererCity
 
|OrdererCity
−
|varchar(140)  
+
|nvarchar(140)  
−
|OrdererCity
+
|Orderer city
 
|  
 
|  
 
|-  
 
|-  
 
|OrdererZIPCode
 
|OrdererZIPCode
−
|char(10)  
+
|nvarchar(10)  
−
|OrdererZIPCode
+
|Orderer ZIP code
 
|  
 
|  
 
|-  
 
|-  
 
|OrdererCountry
 
|OrdererCountry
−
|varchar(50)  
+
|nvarchar(50)  
−
|OrdererCountry
+
|Orderer country
 
|  
 
|  
 
|-  
 
|-  
 
|OrdererRegion
 
|OrdererRegion
−
|varchar(30)  
+
|nvarchar(30)  
−
|OrdererRegion
+
|Orderer region
 
|  
 
|  
 
|-  
 
|-  
 
|OrdererState
 
|OrdererState
−
|varchar(50)  
+
|nvarchar(50)  
−
|OrdererState
+
|Orderer state
 
|  
 
|  
 
|-  
 
|-  
 
|CompanyRegistrationNumber
 
|CompanyRegistrationNumber
−
|char(20)  
+
|nvarchar(20)  
−
|CompanyRegistrationNumber
+
|Company registration number
 
|  
 
|  
 
|-  
 
|-  
 
|VATNumber
 
|VATNumber
−
|char(20)  
+
|nvarchar(20)  
−
|VATNumber
+
|VAT number
 
|  
 
|  
 
|-  
 
|-  
 
|RecipientName
 
|RecipientName
−
|varchar(140)  
+
|nvarchar(140)  
−
|RecipientName
+
|Recipient name
 
|  
 
|  
 
|-  
 
|-  
 
|RecipientStreet
 
|RecipientStreet
−
|varchar(100)  
+
|nvarchar(100)  
−
|RecipientStreet
+
|Recipient street
 
|  
 
|  
 
|-  
 
|-  
 
|RecipientCity
 
|RecipientCity
−
|varchar(140)  
+
|nvarchar(140)  
−
|RecipientCity
+
|Recipient city
 
|  
 
|  
 
|-  
 
|-  
 
|RecipientZIPCode
 
|RecipientZIPCode
−
|char(10)  
+
|nvarchar(10)  
−
|RecipientZIPCode
+
|Recipient ZIP code
 
|  
 
|  
 
|-  
 
|-  
 
|RecipientCountry
 
|RecipientCountry
−
|varchar(50)  
+
|nvarchar(50)  
−
|RecipientCountry
+
|Recipient country
 
|  
 
|  
 
|-  
 
|-  
 
|RecipientRegion
 
|RecipientRegion
−
|varchar(30)  
+
|nvarchar(30)  
−
|RecipientRegion
+
|Recipient region
 
|  
 
|  
 
|-  
 
|-  
 
|RecipientState
 
|RecipientState
−
|varchar(50)  
+
|nvarchar(50)  
−
|RecipientState
+
|Recipient state
 
|  
 
|  
 
|-  
 
|-  
 
|RecipientNote
 
|RecipientNote
 
|nvarchar(250)  
 
|nvarchar(250)  
−
|RecipientNote
+
|Recipient note
 
|  
 
|  
 
|-  
 
|-  
 
|IsCanceled
 
|IsCanceled
 
|int  
 
|int  
−
|IsCanceled
+
|Is canceled
 
|  
 
|  
 
|-  
 
|-  
 
|IsCancelReason
 
|IsCancelReason
−
|varchar(150)  
+
|nvarchar(150)  
−
|IsCancelReason
+
|Is cancel reason
 
|  
 
|  
 
|-  
 
|-  
 
|IsCancelDate
 
|IsCancelDate
 
|datetime  
 
|datetime  
−
|IsCancelDate
+
|Is cancel date
 
|  
 
|  
 
|-  
 
|-  
 
|Note
 
|Note
−
|varchar(300)  
+
|nvarchar(300)  
 
|Note
 
|Note
 
|  
 
|  
Řádka 179: Řádka 187:
 
|OrdererPhone
 
|OrdererPhone
 
|nvarchar(30)  
 
|nvarchar(30)  
−
|OrdererPhone
+
|Orderer phone
 
|  
 
|  
 
|-  
 
|-  
 
|OrdererFax
 
|OrdererFax
 
|nvarchar(30)  
 
|nvarchar(30)  
−
|OrdererFax
+
|Orderer fax
 
|  
 
|  
 
|-  
 
|-  
 
|OrdererMobilePhone
 
|OrdererMobilePhone
 
|nvarchar(30)  
 
|nvarchar(30)  
−
|OrdererMobilePhone
+
|Orderer mobile phone
 
|  
 
|  
 
|-  
 
|-  
 
|OrdererEmail
 
|OrdererEmail
 
|nvarchar(60)  
 
|nvarchar(60)  
−
|OrdererEmail
+
|Orderer email
 
|  
 
|  
 
|-  
 
|-  
 
|OrdererUrl
 
|OrdererUrl
 
|nvarchar(50)  
 
|nvarchar(50)  
−
|OrdererUrl
+
|Orderer url
 
|  
 
|  
 
|-  
 
|-  
 
|RecipientPhone
 
|RecipientPhone
 
|nvarchar(30)  
 
|nvarchar(30)  
−
|RecipientPhone
+
|Recipient phone
 
|  
 
|  
 
|-  
 
|-  
 
|RecipientFax
 
|RecipientFax
 
|nvarchar(30)  
 
|nvarchar(30)  
−
|RecipientFax
+
|Recipient fax
 
|  
 
|  
 
|-  
 
|-  
 
|RecipientMobilePhone
 
|RecipientMobilePhone
 
|nvarchar(30)  
 
|nvarchar(30)  
−
|RecipientMobilePhone
+
|Recipient mobile phone
 
|  
 
|  
 
|-  
 
|-  
−
|RecipientEmail
+
|Recipient email
 
|nvarchar(60)  
 
|nvarchar(60)  
−
|RecipientEmail
+
|Recipient email
 
|  
 
|  
 
|-  
 
|-  
 
|RecipientUrl
 
|RecipientUrl
 
|nvarchar(50)  
 
|nvarchar(50)  
−
|RecipientUrl
+
|Recipient url
 
|  
 
|  
 
|-  
 
|-  
 
|RecipientCompanyRegistrationNumber
 
|RecipientCompanyRegistrationNumber
−
|char(20)  
+
|nvarchar(20)  
−
|RecipientCompanyRegistrationNumber
+
|Recipient company registration number
 
|  
 
|  
 
|-  
 
|-  
 
|RecipientVATNumber
 
|RecipientVATNumber
−
|char(20)  
+
|nvarchar(20)  
−
|RecipientVATNumber
+
|Recipient VAT number
 
|  
 
|  
 
|-  
 
|-  
 
|OrdererBankName
 
|OrdererBankName
 
|nvarchar(120)  
 
|nvarchar(120)  
−
|OrdererBankName
+
|Orderer bank name
 
|  
 
|  
 
|-  
 
|-  
 
|OrdererBankAccount
 
|OrdererBankAccount
 
|nvarchar(50)  
 
|nvarchar(50)  
−
|OrdererBankAccount
+
|Orderer bank account
 
|  
 
|  
 
|-  
 
|-  
 
|OrdererVATNumber2
 
|OrdererVATNumber2
−
|char(20)  
+
|nvarchar(20)  
−
|OrdererVATNumber2
+
|Orderer VAT number 2
 
|  
 
|  
 
|-  
 
|-  
 
|RecipientVATNumber2
 
|RecipientVATNumber2
−
|char(20)  
+
|nvarchar(20)  
−
|RecipientVATNumber2
+
|Recipient VAT number 2
 
|  
 
|  
 
|-  
 
|-  
 
|IsPrinted
 
|IsPrinted
 
|int  
 
|int  
−
|IsPrinted
+
|Is printed
 
|  
 
|  
 
|-  
 
|-  
 
|PrintedDate
 
|PrintedDate
 
|date  
 
|date  
−
|PrintedDate
+
|Printed date
 
|  
 
|  
 
|-  
 
|-  
 
|StornoDocument
 
|StornoDocument
 
|int  
 
|int  
−
|StornoDocument
+
|Storno document
 
|  
 
|  
 
|-  
 
|-  
 
|StornoDocumentOriginID
 
|StornoDocumentOriginID
 
|int  
 
|int  
−
|StornoDocumentOriginID
+
|ID of delivery note from delivery note list (see relation)
−
|  
+
| API_GetDeliveryNote.ID
 
|-  
 
|-  
 
|CurrencyInCurrencyID
 
|CurrencyInCurrencyID
 
|int  
 
|int  
−
|CurrencyInCurrencyID
+
|ID of currency from currency list (see relation)
−
|  
+
| API_GetCurrency.ID
 
|-  
 
|-  
 
|ExchangeRate
 
|ExchangeRate
 
|decimal(18,2)  
 
|decimal(18,2)  
−
|ExchangeRate
+
|Exchange rate
 
|  
 
|  
 
|}
 
|}

Aktuální verze z 9. 11. 2018, 12:32

Description

Method gives You overview of existing delivery note in system.

Exact name

API_GetDeliveryNote

Type

Standard view.

Specification

Column Data type Description Relation
ID int Internal system 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
Recipient email 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

Example

SELECT TOP 1000 * FROM [API_GetDeliveryNote]

Notices

None.

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