CashTransactionTaxDetailsByReferenceNumber: Visma.net Financials Cash Transaction Tax Details by Reference Number
read only REST
- Catalog:
VismaNet - Schema:
CashTransaction - Label: Cash Transaction Tax Details by Reference Number
Get a specific Transaction - ScreenID=CA304000 Data for the Cash Transaction The response headers include an ETag after a successful GET operation.
Can only retrieve data.
Summary
Data for the Cash Transaction
The response headers include an ETag after a successful GET operation.
API Source
- Endpoint:
/v1/cashTransaction/{referenceNbr} - Operation:
get /v1/cashTransaction/{referenceNbr}
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 |
|---|---|---|---|---|
reference |
`` | Returns data for the selected Cash transaction |
Table Columns
The columns of the table CashTransactionTaxDetailsByReferenceNumber 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. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: