API GetInvoices: 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 invoices in system. ====Exact name==== <code>API_GetInvoices</code> ====Type==== Standard view. =…“)
 
 
(Není zobrazeno 5 mezilehlých verzí od stejného uživatele.)
Řádka 19: Řádka 19:
 
|ContactID  
 
|ContactID  
 
|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
 
|-  
 
|-  
 
|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
 
|-  
 
|-  
 
|DocumentTypeID  
 
|DocumentTypeID  
 
|int  
 
|int  
−
|  
+
| Document type ID
 +
 
 +
1 - Invoice
 +
 
 +
14 - InvoiceProforma
 +
 
 +
16 - InvoiceForPoints
 +
 
 +
6 - Chit
 +
 
 +
8 - CreditNote
 +
 
 +
15 - DeliveryNote
 
|
 
|
 
|-  
 
|-  
 
|TransportID  
 
|TransportID  
 
|int  
 
|int  
−
|  
+
|ID of transport from transport list (see relation)
−
|
+
|API_GetTransports.ID
 
|-  
 
|-  
 
|PaymentTypeID  
 
|PaymentTypeID  
 
|int  
 
|int  
−
|  
+
| Payment type ID.
 +
 
 +
-1 - _NA
 +
 
 +
1 - Cash
 +
 
 +
2 - WireTransfer
 +
 
 +
3 - CreditCard
 +
 
 +
4 - Before
 +
 
 +
5 - Voucher
 +
 
 +
6 - CashOnDelivery
 
|
 
|
 
|-  
 
|-  
 
|PriceTypeID  
 
|PriceTypeID  
 
|int  
 
|int  
−
|  
+
| Price type ID
 +
 
 +
0 - WithVAT
 +
 
 +
1 - WithoutVAT
 +
 
 +
2 - VATTransfer
 
|
 
|
 
|-  
 
|-  
Řádka 138: Řádka 170:
 
|-  
 
|-  
 
|Currency  
 
|Currency  
−
|varchar(5)  
+
|nvarchar(5)  
 
|Currency  
 
|Currency  
 
|
 
|
Řádka 144: Řádka 176:
 
|CurrencyID  
 
|CurrencyID  
 
|int  
 
|int  
−
|CurrencyID
+
|ID of currency from currency list (see relation)
−
|
+
|API_GetCurrency.ID
 
|-  
 
|-  
 
|CurrencyIDInCurrency  
 
|CurrencyIDInCurrency  
 
|int  
 
|int  
−
|CurrencyIDInCurrency
+
|ID of currency from currency list (see relation)
−
|
+
|API_GetCurrency.ID
 
|-  
 
|-  
 
|ExchangeRate  
 
|ExchangeRate  
Řádka 179: Řádka 211:
 
|RoundStyle  
 
|RoundStyle  
 
|int  
 
|int  
−
|Round style  
+
|Round style.
 +
-1        - not selected,
 +
 
 +
0        - round off,
 +
 
 +
-1000  - 0,0001,
 +
 
 +
-100    - 0,001
 +
 
 +
1        - 0,01
 +
 
 +
3        - 1
 +
 
 +
4        - 10
 +
 
 +
5        - 100
 +
 
 +
6        - 1000
 
|
 
|
 
|-  
 
|-  
 
|RoundType  
 
|RoundType  
 
|int  
 
|int  
−
|Round type  
+
|Round type
 +
-1 - not selected,
 +
 
 +
1 - Up,
 +
 
 +
2 - Down,
 +
 
 +
3 - Mathematical
 
|
 
|
 
|-  
 
|-  
Řádka 203: Řádka 259:
 
|-  
 
|-  
 
|SupplierZIPCode  
 
|SupplierZIPCode  
−
|char(10)  
+
|nvarchar(10)  
 
|Supplier ZIP code  
 
|Supplier ZIP code  
 
|
 
|
Řádka 223: Řádka 279:
 
|-  
 
|-  
 
|SupplierCompanyRegistrationNumber  
 
|SupplierCompanyRegistrationNumber  
−
|char(20)  
+
|nvarchar(20)  
 
|Supplier company registration number  
 
|Supplier company registration number  
 
|
 
|
 
|-  
 
|-  
 
|SupplierVATNumber2  
 
|SupplierVATNumber2  
−
|char(20)  
+
|nvarchar(20)  
 
|Supplier VAT number 2  
 
|Supplier VAT number 2  
 
|
 
|
 
|-  
 
|-  
 
|SupplierVATNumber  
 
|SupplierVATNumber  
−
|char(20)  
+
|nvarchar(20)  
 
|Supplier VAT number  
 
|Supplier VAT number  
 
|
 
|
Řádka 293: Řádka 349:
 
|-  
 
|-  
 
|OrdererZIPCode  
 
|OrdererZIPCode  
−
|char(10)  
+
|nvarchar(10)  
 
|Orderer ZIP code  
 
|Orderer ZIP code  
 
|
 
|
Řádka 313: Řádka 369:
 
|-  
 
|-  
 
|OrdererCompanyRegistrationNumber  
 
|OrdererCompanyRegistrationNumber  
−
|char(20)  
+
|nvarchar(20)  
 
|Orderer company registration number  
 
|Orderer company registration number  
 
|
 
|
 
|-  
 
|-  
 
|OrdererVATNumber2  
 
|OrdererVATNumber2  
−
|char(20)  
+
|nvarchar(20)  
 
|Orderer VAT number 2  
 
|Orderer VAT number 2  
 
|
 
|
 
|-  
 
|-  
 
|OrdererVATNumber  
 
|OrdererVATNumber  
−
|char(20)  
+
|nvarchar(20)  
 
|Orderer VAT number  
 
|Orderer VAT number  
 
|
 
|
Řádka 378: Řádka 434:
 
|-  
 
|-  
 
|RecipientZIPCode  
 
|RecipientZIPCode  
−
|char(10)  
+
|nvarchar(10)  
 
|Recipient ZIP code  
 
|Recipient ZIP code  
 
|
 
|
Řádka 398: Řádka 454:
 
|-  
 
|-  
 
|RecipientCompanyRegistrationNumber  
 
|RecipientCompanyRegistrationNumber  
−
|char(20)  
+
|nvarchar(20)  
 
|Recipient company registration number  
 
|Recipient company registration number  
 
|
 
|
 
|-  
 
|-  
 
|RecipientVATNumber  
 
|RecipientVATNumber  
−
|char(20)  
+
|nvarchar(20)  
 
|Recipient VAT number  
 
|Recipient VAT number  
 
|
 
|
Řádka 478: Řádka 534:
 
|-  
 
|-  
 
|Note2  
 
|Note2  
−
|varchar(120)  
+
|nvarchar(120)  
 
|Note 2  
 
|Note 2  
 
|
 
|
Řádka 504: Řádka 560:
 
|CancelDocumentOriginID  
 
|CancelDocumentOriginID  
 
|int  
 
|int  
−
|Cancel document origin ID  
+
|ID of invoice from invoice list (see relation)
−
|
+
|API_GetInvoices.ID
 
|-  
 
|-  
 
|FiskalPrintDate  
 
|FiskalPrintDate  

Aktuální verze z 9. 11. 2018, 14:06

Description

Method gives You overview of existing invoices in system.

Exact name

API_GetInvoices

Type

Standard view.

Specification

Column Data type Description Relation
ID int Internal system id
ContactID 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
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
DocumentTypeID int Document type ID

1 - Invoice

14 - InvoiceProforma

16 - InvoiceForPoints

6 - Chit

8 - CreditNote

15 - DeliveryNote

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

PriceTypeID int Price type ID

0 - WithVAT

1 - WithoutVAT

2 - VATTransfer

DocumentNumber nvarchar(40) Document number
Date datetime Date
TaxableSupplyDate datetime Taxable supply date
DueDate datetime Due date
VariableSymbol bigint Variable symbol
BasicPrice decimal(18,6) Basic price
BasicPriceInCurrency decimal(18,6) Basic price in currency
VATPrice decimal(18,6) VAT price
VATPriceInCurrency decimal(18,6) VAT price in currency
TotalPrice decimal(18,6) Total price
TotalPriceInCurrency decimal(18,6) Total price in currency
RoundPrice decimal(18,4) Round price
RoundPriceInCurrency decimal(18,4) Round price in currency
Price decimal(19,6) Price
PriceInCurrency decimal(19,6) Price in currency
Currency nvarchar(5) Currency
CurrencyID int ID of currency from currency list (see relation) API_GetCurrency.ID
CurrencyIDInCurrency int ID of currency from currency list (see relation) API_GetCurrency.ID
ExchangeRate decimal(19,4) Exchange rate
ExchangeRate2 decimal(18,4) Exchange rate 2
AccountingExchangeRate decimal(18,6) Accounting exchange rate
VATExchangeRate decimal(18,4) VAT exchange rate
AccountingExchangeRate2 decimal(18,6) Accounting exchange rate 2
RoundStyle int Round style.

-1 - not selected,

0 - round off,

-1000 - 0,0001,

-100 - 0,001

1 - 0,01

3 - 1

4 - 10

5 - 100

6 - 1000

RoundType int Round type

-1 - not selected,

1 - Up,

2 - Down,

3 - Mathematical

SupplierName nvarchar(140) Supplier name
SupplierStreet nvarchar(100) Supplier street
SupplierCity nvarchar(140) Supplier city
SupplierZIPCode nvarchar(10) Supplier ZIP code
SupplierCountry nvarchar(50) Supplier country
SupplierRegion nvarchar(30) Supplier region
SupplierState nvarchar(50) Supplier state
SupplierCompanyRegistrationNumber nvarchar(20) Supplier company registration number
SupplierVATNumber2 nvarchar(20) Supplier VAT number 2
SupplierVATNumber nvarchar(20) Supplier VAT number
SupplierPhone nvarchar(30) Supplier phone
SupplierFax nvarchar(30) Supplier fax
SupplierMobilePhone nvarchar(30) Supplier mobile phone
SupplierEmail nvarchar(60) Supplier email
SupplierWeb nvarchar(50) Supplier web
SupplierBankName nvarchar(120) Supplier bank name
SupplierBankAccount nvarchar(50) Supplier bank account
SupplierBankSwift nvarchar(50) Supplier bank swift
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
OrdererCompanyRegistrationNumber nvarchar(20) Orderer company registration number
OrdererVATNumber2 nvarchar(20) Orderer VAT number 2
OrdererVATNumber nvarchar(20) Orderer VAT number
OrdererPhone nvarchar(30) Orderer phone
OrdererFax nvarchar(30) Orderer fax
OrdererMobilePhone nvarchar(30) Orderer mobile phone
OrdererEmail nvarchar(60) Orderer email
OrdererWeb nvarchar(50) Orderer web
OrdererBankName nvarchar(120) Orderer bank name
OrdererBankAccount nvarchar(50) Orderer bank account
RecipientName nvarchar(120) 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
RecipientCompanyRegistrationNumber nvarchar(20) Recipient company registration number
RecipientVATNumber nvarchar(20) Recipient VAT number
RecipientPhone nvarchar(30) Recipient phone
RecipientFax nvarchar(30) Recipient fax
RecipientMobilePhone nvarchar(30) Recipient mobile phone
RecipientEmail nvarchar(60) Recipient email
RecipientWeb nvarchar(50) Recipient web
RecipientBankName nvarchar(120) Recipient bank name
RecipientBankAccount nvarchar(50) Recipient bank account
IsCanceled int Is canceled
CancelationReason nvarchar(100) Cancelation reason
CancelationDate datetime Cancelation date
IsForeign int Is foreign
FinancialYear int Financial year
FinancialMonth int Financial month
Note nvarchar(500) Note
Note2 nvarchar(120) Note 2
IsPrintedOnFiscal int Is printed on fiscal
FiskalComputerName nvarchar(255) Fiskal computer name
IsPrinted int Is printed
CancelDocument int Cancel document
CancelDocumentOriginID int ID of invoice from invoice list (see relation) API_GetInvoices.ID
FiskalPrintDate date Fiskal print date
FiskalPrintOrder int Fiskal print order

Example

SELECT TOP 1000 * FROM [API_GetInvoices]

Notices

None.

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