CashTransactionTaxDetails: Visma.net Financials Cash Transaction Tax Details
read only REST
- Catalog:
VismaNet - Schema:
CashTransaction - Label: Cash Transaction Tax Details
Get all Transaction - ScreenID=CA304000 Data for the Cash Transaction
Can only retrieve data.
Summary
Data for the Cash Transaction
API Source
- Endpoint:
/v1/cashTransaction - Operation:
get /v1/cashTransaction
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 155 |
| Full scan rows per minute | 29,100 |
| Point query rows per minute | 387 |
The result can be cached on the client.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
last |
`` | This value, generated by the system, indicates the last time the record was modified. Use it to retrieve all records that have been modified since that time, up to the present. Accepted format: * yyyy- * yyyy- * yyyy- * yyyy- * yyyy- Note: LastModifiedDateTime and LastModifiedDateTimeCondition are mutually inclusive. |
||
last |
`` | This value represents the condition to be applied when retrieving records. Accepted values (without the single quotes): * '>' for greater than * '<' for less than * '>=' for greater than or equal * '<=' for less than or equal Note: LastModifiedDateTime and LastModifiedDateTimeCondition are mutually inclusive. |
Table Columns
The columns of the table CashTransactionTaxDetails are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
COMPANY_ |
varchar2 |
Company Code | writable | Partition code, segmenting the data. | |
COMPANY_ |
varchar2 |
Company Name | writable | Name of the partition. | |
amount |
double |
Amount | filters on the platform, writable, ::ancestor. |
The top part > Amount > The amount of the transaction. | |
cash |
varchar2 |
Cash Account Description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
cash |
varchar2 |
Cash Account Number | filters on the platform, writable, ::ancestor. |
Number of item | |
cash |
varchar2 |
Cash Account Type | filters on the platform, writable, ::ancestor. |
||
control |
double |
Total for Control | filters on the platform, writable, ::ancestor. |
Mandatory field: The top part > Control total > The control total of the transaction. | |
currency |
varchar2 |
Currency | filters on the platform, writable, ::ancestor. |
The top part > Currency > The currency of the cash account. | |
deductible |
double |
itgen_vnet_deductibletaxrate | writable, deductible |
Deductible VAT rate > The percent of deduction that applies to the VAT amount paid to the supplier for specific purchases. | |
description |
varchar2 |
Description | filters on the platform, writable, ::ancestor. |
The top part > Description > A detailed description of the transaction. | |
disb |
varchar2 |
itgen_vnet_disbreceipt | filters on the platform, writable, ::ancestor. |
The top part > Disb./receipt > The basic type of the transaction. | |
document |
varchar2 |
Document Reference | filters on the platform, writable, ::ancestor. |
The top part > Document ref. > The external document reference number. | |
entry |
varchar2 |
Entry Type Description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
entry |
varchar2 |
Entry Type ID | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
expense |
double |
itgen_vnet_expenseamount | writable, expense |
Expense amount > The percentage that is deducted from the VAT amount paid to the supplier for specific purchases. | |
fin |
varchar2 |
Financial Period | filters on the platform, writable, ::ancestor. |
The property is now considered obsolete. Use Financial Period instead | |
financial |
varchar2 |
Financial Period | filters on the platform, writable, ::ancestor. |
Mandatory field: The top part > Period* > The financial period to which the transaction should be posted. | |
financials |
varchar2 |
Financials Detail Batch Number | filters on the platform, writable, ::ancestor. |
Link to general ledger section > Batch number > The number of the batch generated to implement the cash transaction. | |
financials |
varchar2 |
Branch Name | filters on the platform, writable, ::ancestor. |
Click the magnifier. > The name. | |
financials |
varchar2 |
Branch Number | filters on the platform, writable, ::ancestor. |
Click the magnifier. > The identifier. | |
financials |
datetime |
Clear Date | filters on the platform, writable, ::ancestor. |
Link to general ledger section > Clear date > The date when the transaction was cleared. | |
financials |
char |
Cleared? | filters on the platform, writable, ::ancestor. |
Link to general ledger section > Cleared > A check box that indicates (if selected) that the transaction was cleared. | |
financials |
varchar2 |
Tax Calculation Mode | filters on the platform, writable, ::ancestor. |
VAT settings section > VAT calculation > The VAT calculation mode, which defines which amounts (VAT-inclusive or VAT-exclusive) should be entered in the detail lines of a document. | |
financials |
varchar2 |
Tax Zone Default Tax Category Description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
financials |
varchar2 |
Tax Zone Default Tax Category Number | filters on the platform, writable, ::ancestor. |
Number of item | |
financials |
varchar2 |
Tax Zone Default VAT Category | filters on the platform, writable, ::ancestor. |
Click the magnifier. The Default VAT category for the VAT zone of the supplier, which is specified in the AP303000 window. | |
financials |
varchar2 |
Tax Zone Description | filters on the platform, writable, ::ancestor. |
Click the magnifier. The description for the VAT zone of the supplier, which is specified in the AP303000 window. | |
financials |
varchar2 |
itgen_vnet_financialsdetail_taxzone_errorinfo | filters on the platform, writable, ::ancestor. |
||
financials |
varchar2 |
Tax Zone ID | filters on the platform, writable, ::ancestor. |
Click the magnifier. The identifier for the VAT zone of the supplier, which is specified in the AP303000 window. | |
financials |
int64 |
itgen_vnet_financialsdetail_taxzone_metadata_maxpagesize | filters on the platform, writable, ::ancestor. |
||
financials |
int64 |
itgen_vnet_financialsdetail_taxzone_metadata_totalcount | filters on the platform, writable, ::ancestor. |
||
hold |
char |
Hold | filters on the platform, writable, ::ancestor. |
The top part > Hold > A check box that, if selected, indicates that the transaction is on hold, which means it may be edited but cannot be released. | |
include |
char |
itgen_vnet_includeinvatexempttotal | writable, include |
Include in VAT exempt total > A check box that indicates (if selected) that this value-added VAT has a zero rate and is used to calculate a document subtotal that is actually exempt from VAT. | |
last |
datetime |
Last Modified | filters on the platform, writable, ::ancestor. |
System generated information. | |
owner_ |
varchar2 |
Owner Internal ID | filters on the platform, writable, ::ancestor. |
||
owner_ |
varchar2 |
Owner Name | filters on the platform, writable, ::ancestor. |
The name of the particular destination of the selected type. | |
owner_ |
varchar2 |
Owner Number | filters on the platform, writable, ::ancestor. |
The identifier of the particular destination of the selected type. | |
pending |
char |
itgen_vnet_pendingvat | writable, pending |
Pending VAT > A check box that indicates (if selected) that the VAT that should be calculated in documents, but should not be recorded to the VAT report until the VAT invoice is received. | |
reference |
varchar2 |
Reference Number | filters on the platform, writable, ::ancestor. |
The top part > Ref. no. > The unique identifier assigned to the cash transaction in accordance with the numbering sequence. | |
reverse |
char |
Reverse VAT | writable, reverse |
Reverse VAT > A check box that indicates (if selected) that this is a reverse VAT. | |
statistical |
char |
Statistical VAT | writable, statistical |
Statistical VAT > A check box that indicates (if selected) that the VAT on documents will be calculated only for statistical purposes or will be reported only but not actually paid. | |
status |
varchar2 |
Status | filters on the platform, writable, ::ancestor. |
The top part > Status > The status of the transaction, which is automatically assigned by the system. | |
tax |
double |
Tax Amount | writable, tax |
VAT amount > The VAT amount calculated for the transaction. | |
tax |
double |
itgen_vnet_taxamount_2 | filters on the platform, writable, ::ancestor. |
The top part > VAT amount > The VAT amount to be paid for the document. A user enters this amount manually. | |
tax |
double |
Tax Rate | writable, tax |
VAT rate > The rate of the VAT. | |
tax |
double |
Tax Total | filters on the platform, writable, ::ancestor. |
The top part > VAT total > The total amount of tax paid in the document. | |
tax |
varchar2 |
Tax Type | writable, tax |
VAT type > The type of VAT. | |
tax_ |
varchar2 |
Tax Description | writable, tax. |
Name of item/description | |
tax_ |
varchar2 |
Tax Number | writable, tax. |
Number of item | |
taxable |
double |
Taxable Amount | writable, taxable |
Taxable amount > The taxable amount of the transaction. | |
time |
blob |
Timestamp | filters on the platform, writable, ::ancestor. |
Identifier that represents a specific version of the resource. It helps to prevent simultaneous updates of the resource from overwriting each other (by using ETags and If-Match headers) | |
tran |
datetime |
Transaction Date | filters on the platform, writable, ::ancestor. |
Mandatory field: The top part > Trans. date* > The date of the transaction. | |
tran |
varchar2 |
Transaction Type | filters on the platform, writable, ::ancestor. |
The top part > Trans type > The type of cash transaction. | |
vat |
double |
VAT Exempt Total | filters on the platform, writable, ::ancestor. |
The top part > VAT exempt total > The document total that is exempt from VAT. | |
vat |
double |
VAT Taxable Total | filters on the platform, writable, ::ancestor. |
The top part > VAT taxable total > The document total that is subjected to VAT. |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
Cash |
cash |
Accounts. |
Key |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: