API GetInvoices: Porovnání verzí
Z Podpora.nextis.cz
| Řádka 44: | Řádka 44: | ||
|DocumentTypeID | |DocumentTypeID | ||
|int | |int | ||
| − | | | + | | Document type ID |
| + | |||
| + | 1- Faktura | ||
| + | |||
| + | 14 - Faktura_Zalohova | ||
| + | |||
| + | 16 - Faktura_Za_Body | ||
| + | |||
| + | 6 - Paragon | ||
| + | |||
| + | 8 - Dobropis | ||
| + | |||
| + | 15 - DodaciList | ||
| | | | ||
|- | |- | ||
| Řádka 56: | Řádka 68: | ||
| Payment type ID. | | Payment type ID. | ||
| − | + | _NA = -1 | |
| − | 1 | + | Hotove = 1 |
| − | 2 | + | Prevodem = 2 |
| + | |||
| + | Kartou = 3 | ||
| + | |||
| + | Predem = 4 | ||
| + | |||
| + | Poukazkou = 5 | ||
| + | |||
| + | Dobirkou = 6 | ||
| | | | ||
|- | |- | ||
|PriceTypeID | |PriceTypeID | ||
|int | |int | ||
| − | | | + | | Price type ID |
| + | |||
| + | VcetneDPH = 0 | ||
| + | |||
| + | BezDPH = 1 | ||
| + | |||
| + | PrenosDPH = 2 | ||
| | | | ||
|- | |- | ||
| Řádka 186: | Řádka 212: | ||
|int | |int | ||
|Round style. | |Round style. | ||
| − | -1 - | + | -1 - not selected, |
0 - round off, | 0 - round off, | ||
| Řádka 208: | Řádka 234: | ||
|int | |int | ||
|Round type | |Round type | ||
| − | -1- | + | -1 - not selected, |
| − | 1-Up, | + | 1 - Up, |
| − | 2- Down, | + | 2 - Down, |
| − | 3-Mathematical | + | 3 - Mathematical |
| | | | ||
|- | |- | ||
Verze z 27. 7. 2017, 12:22
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- Faktura 14 - Faktura_Zalohova 16 - Faktura_Za_Body 6 - Paragon 8 - Dobropis 15 - DodaciList |
|
| TransportID | int | ID of transport from transport list (see relation) | API_GetTransports.ID |
| PaymentTypeID | int | Payment type ID.
_NA = -1 Hotove = 1 Prevodem = 2 Kartou = 3 Predem = 4 Poukazkou = 5 Dobirkou = 6 |
|
| PriceTypeID | int | Price type ID
VcetneDPH = 0 BezDPH = 1 PrenosDPH = 2 |
|
| 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 | varchar(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 | char(10) | Supplier ZIP code | |
| SupplierCountry | nvarchar(50) | Supplier country | |
| SupplierRegion | nvarchar(30) | Supplier region | |
| SupplierState | nvarchar(50) | Supplier state | |
| SupplierCompanyRegistrationNumber | char(20) | Supplier company registration number | |
| SupplierVATNumber2 | char(20) | Supplier VAT number 2 | |
| SupplierVATNumber | char(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 | char(10) | Orderer ZIP code | |
| OrdererCountry | nvarchar(50) | Orderer country | |
| OrdererRegion | nvarchar(30) | Orderer region | |
| OrdererState | nvarchar(50) | Orderer state | |
| OrdererCompanyRegistrationNumber | char(20) | Orderer company registration number | |
| OrdererVATNumber2 | char(20) | Orderer VAT number 2 | |
| OrdererVATNumber | char(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 | char(10) | Recipient ZIP code | |
| RecipientCountry | nvarchar(50) | Recipient country | |
| RecipientRegion | nvarchar(30) | Recipient region | |
| RecipientState | nvarchar(50) | Recipient state | |
| RecipientCompanyRegistrationNumber | char(20) | Recipient company registration number | |
| RecipientVATNumber | char(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 | varchar(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 | Cancel document origin ID | |
| FiskalPrintDate | date | Fiskal print date | |
| FiskalPrintOrder | int | Fiskal print order |
Example
SELECT TOP 1000 * FROM [API_GetInvoices]
Notices
None.
