API GetDocumentVAT: 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 document VAT in system. ====Exact name==== <code>API_GetDocumentVAT</code> ====Type==== Standard…“)
 
Řádka 12: Řádka 12:
 
!Relation
 
!Relation
 
|-
 
|-
|ID
+
|DocumentID
 
|int
 
|int
 
|Internal system id
 
|Internal system id
 
|
 
|
 
|-
 
|-
|UrlName
+
|RateName
|nvarchar(50)
+
|nvarchar(80)
|Url name
+
|Rate name
 +
|
 +
|-
 +
|Rate
 +
|numeric(5,2)
 +
|Rate
 +
|
 +
|-
 +
|Basis
 +
|numeric(18,4)
 +
|Basis
 +
|
 +
|-
 +
|Tax
 +
|numeric(18,4)
 +
|Tax
 +
|
 +
|-
 +
|WithTax
 +
|numeric(18,4)
 +
|With tax
 +
|
 +
|-
 +
|BasisInCurrency
 +
|decimal(18,6)
 +
|Basis in currency
 +
|
 +
|-
 +
|TaxInCurrency
 +
|decimal(18,6)
 +
|Tax in currency
 +
|
 +
|-
 +
|WithTaxInCurrency
 +
|decimal(18,6)
 +
|With tax in currency
 +
|
 +
|-
 +
|VATRound
 +
|decimal(18,2)
 +
|VAT round
 +
|
 +
|-
 +
|VATRoundForeign
 +
|decimal(18,2)
 +
|VAT round foreign
 +
|
 +
|-
 +
|IsRounding
 +
|int
 +
|Is rounding
 
|
 
|
 
|}
 
|}

Verze z 26. 7. 2017, 12:50

Description

Method gives You overview of existing document VAT in system.

Exact name

API_GetDocumentVAT

Type

Standard view.

Specification

Column Data type Description Relation
DocumentID int Internal system id
RateName nvarchar(80) Rate name
Rate numeric(5,2) Rate
Basis numeric(18,4) Basis
Tax numeric(18,4) Tax
WithTax numeric(18,4) With tax
BasisInCurrency decimal(18,6) Basis in currency
TaxInCurrency decimal(18,6) Tax in currency
WithTaxInCurrency decimal(18,6) With tax in currency
VATRound decimal(18,2) VAT round
VATRoundForeign decimal(18,2) VAT round foreign
IsRounding int Is rounding

Example

SELECT TOP 1000 * FROM [API_GetDocumentVAT]

Notices

None.