API GetDocumentVAT: Porovnání verzí
Skočit na navigaci
Skočit na vyhledává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…“ |
Bez shrnutí editace |
||
| Řádek 12: | Řádek 12: | ||
!Relation | !Relation | ||
|- | |- | ||
| | |DocumentID | ||
|int | |int | ||
|Internal system id | |Internal system id | ||
| | | | ||
|- | |- | ||
| | |RateName | ||
|nvarchar( | |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 | |||
| | | | ||
|} | |} | ||
Verze z 26. 7. 2017, 11: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.