invantive documentation
Invantive Support ForumsLog In / Sign Up

CashTransactions: Visma.net Financials Cash Transactions

insert update REST

  • Catalog: VismaNet
  • Schema: CashTransaction
  • Primary Keys: referenceNbr
  • Label: Cash Transactions

Get all Transaction - ScreenID=CA304000 Data for the Cash Transaction

Can retrieve data and change data using insert and update.

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
lastModifiedDateTime `` 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-MM-dd * yyyy-MM-dd HH:mm:ss * yyyy-MM-dd HH:mm:ss.FFF * yyyy-MM-ddTHH:mm:ss * yyyy-MM-ddTHH:mm:ss.FFF Note: LastModifiedDateTime and LastModifiedDateTimeCondition are mutually inclusive.
lastModifiedDateTimeCondition `` 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 CashTransactions 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_CODE varchar2(30) Company Code writable Partition code, segmenting the data.
COMPANY_NAME varchar2(240) Company Name writable Name of the partition.
amount double Amount filters on the platform, writable, amount The top part > Amount > The amount of the transaction.
cashAccount_description varchar2 Cash Account Description filters on the platform, writable, cashAccount.description Name of item/description
cashAccount_number varchar2 Cash Account Number filters on the platform, writable, cashAccount.number Number of item
cashAccount_type varchar2 Cash Account Type filters on the platform, writable, cashAccount.type
controlTotal double Total for Control filters on the platform, writable, controlTotal Mandatory field: The top part > Control total > The control total of the transaction.
currency varchar2 Currency filters on the platform, writable, currency The top part > Currency > The currency of the cash account.
description varchar2 Description filters on the platform, writable, description The top part > Description > A detailed description of the transaction.
disbReceipt varchar2 itgen_vnet_disbreceipt filters on the platform, writable, disbReceipt The top part > Disb./receipt > The basic type of the transaction.
documentRef varchar2 Document Reference filters on the platform, writable, documentRef The top part > Document ref. > The external document reference number.
entryType_description varchar2 Entry Type Description filters on the platform, writable, entryType.description Click on the magnifier. > The description.
entryType_id varchar2 Entry Type ID filters on the platform, writable, entryType.id Click on the magnifier. > The identifier.
finPeriod varchar2 Financial Period filters on the platform, writable, finPeriod The property is now considered obsolete. Use Financial Period instead
financialPeriod varchar2 Financial Period filters on the platform, writable, financialPeriod Mandatory field: The top part > Period* > The financial period to which the transaction should be posted.
financialsDetail_batchNumber varchar2 Financials Detail Batch Number filters on the platform, writable, financialsDetail.batchNumber Link to general ledger section > Batch number > The number of the batch generated to implement the cash transaction.
financialsDetail_branch_name varchar2 Branch Name filters on the platform, writable, financialsDetail.branch.name Click the magnifier. > The name.
financialsDetail_branch_number varchar2 Branch Number filters on the platform, writable, financialsDetail.branch.number Click the magnifier. > The identifier.
financialsDetail_clearDate datetime Clear Date filters on the platform, writable, financialsDetail.clearDate Link to general ledger section > Clear date > The date when the transaction was cleared.
financialsDetail_cleared char Cleared? filters on the platform, writable, financialsDetail.cleared Link to general ledger section > Cleared > A check box that indicates (if selected) that the transaction was cleared.
financialsDetail_taxCalcMode varchar2 Tax Calculation Mode filters on the platform, writable, financialsDetail.taxCalcMode 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.
financialsDetail_taxZone_defaultTaxCategory_description varchar2 Tax Zone Default Tax Category Description filters on the platform, writable, financialsDetail.taxZone.defaultTaxCategory.description Name of item/description
financialsDetail_taxZone_defaultTaxCategory_number varchar2 Tax Zone Default Tax Category Number filters on the platform, writable, financialsDetail.taxZone.defaultTaxCategory.number Number of item
financialsDetail_taxZone_defaultVatCategory varchar2 Tax Zone Default VAT Category filters on the platform, writable, financialsDetail.taxZone.defaultVatCategory Click the magnifier. The Default VAT category for the VAT zone of the supplier, which is specified in the AP303000 window.
financialsDetail_taxZone_description varchar2 Tax Zone Description filters on the platform, writable, financialsDetail.taxZone.description Click the magnifier. The description for the VAT zone of the supplier, which is specified in the AP303000 window.
financialsDetail_taxZone_errorInfo varchar2 itgen_vnet_financialsdetail_taxzone_errorinfo filters on the platform, writable, financialsDetail.taxZone.errorInfo
financialsDetail_taxZone_id varchar2 Tax Zone ID filters on the platform, writable, financialsDetail.taxZone.id Click the magnifier. The identifier for the VAT zone of the supplier, which is specified in the AP303000 window.
financialsDetail_taxZone_metadata_maxPageSize int64 itgen_vnet_financialsdetail_taxzone_metadata_maxpagesize filters on the platform, writable, financialsDetail.taxZone.metadata.maxPageSize
financialsDetail_taxZone_metadata_totalCount int64 itgen_vnet_financialsdetail_taxzone_metadata_totalcount filters on the platform, writable, financialsDetail.taxZone.metadata.totalCount
hold char Hold filters on the platform, writable, hold 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.
lastModifiedDateTime datetime Last Modified filters on the platform, writable, lastModifiedDateTime System generated information.
owner_internalId varchar2 Owner Internal ID filters on the platform, writable, owner.internalId
owner_name varchar2 Owner Name filters on the platform, writable, owner.name The name of the particular destination of the selected type.
owner_number varchar2 Owner Number filters on the platform, writable, owner.number The identifier of the particular destination of the selected type.
referenceNbr varchar2 Reference Number filters on the platform, writable, referenceNbr The top part > Ref. no. > The unique identifier assigned to the cash transaction in accordance with the numbering sequence.
status varchar2 Status filters on the platform, writable, status The top part > Status > The status of the transaction, which is automatically assigned by the system.
taxAmount double Tax Amount filters on the platform, writable, taxAmount The top part > VAT amount > The VAT amount to be paid for the document. A user enters this amount manually.
taxTotal double Tax Total filters on the platform, writable, taxTotal The top part > VAT total > The total amount of tax paid in the document.
timeStamp blob Timestamp filters on the platform, writable, timeStamp 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)
tranDate datetime Transaction Date filters on the platform, writable, tranDate Mandatory field: The top part > Trans. date* > The date of the transaction.
tranType varchar2 Transaction Type filters on the platform, writable, tranType The top part > Trans type > The type of cash transaction.
vatExemptTotal double VAT Exempt Total filters on the platform, writable, vatExemptTotal The top part > VAT exempt total > The document total that is exempt from VAT.
vatTaxableTotal double VAT Taxable Total filters on the platform, writable, vatTaxableTotal The top part > VAT taxable total > The document total that is subjected to VAT.

Keys

Key Column Refers to Kind Description
CashTransactions_cashAccount_number_fk cashAccount_number Accounts.accountCD Key

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: