invantive documentation
Invantive Support ForumsLog In / Sign Up

CashTransactionDetailsByReferenceNumber: Visma.net Financials Cash Transaction Details by Reference Number

read only REST

  • Catalog: VismaNet
  • Schema: CashTransaction
  • Label: Cash Transaction 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
referenceNbr `` Returns data for the selected Cash transaction

Table Columns

The columns of the table CashTransactionDetailsByReferenceNumber 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 writable, amount Amount > The total amount for all units or items.
amount_2 double itgen_vnet_amount_2 filters on the platform, writable, ::ancestor.amount The top part > Amount > The amount of the transaction.
branch_name varchar2 Branch Name writable, branch.name Click the magnifier. > The name.
branch_number varchar2 Branch Number writable, branch.number Click the magnifier. > The identifier.
cashAccount_description varchar2 Cash Account Description filters on the platform, writable, ::ancestor.cashAccount.description Name of item/description
cashAccount_number varchar2 Cash Account Number filters on the platform, writable, ::ancestor.cashAccount.number Number of item
cashAccount_type varchar2 Cash Account Type filters on the platform, writable, ::ancestor.cashAccount.type
controlTotal double Total for Control filters on the platform, writable, ::ancestor.controlTotal Mandatory field: The top part > Control total > The control total of the transaction.
currency varchar2 Currency filters on the platform, writable, ::ancestor.currency The top part > Currency > The currency of the cash account.
description varchar2 Description writable, description Description > The description provided for the item.
description_2 varchar2 Description 2 filters on the platform, writable, ::ancestor.description The top part > Description > A detailed description of the transaction.
disbReceipt varchar2 itgen_vnet_disbreceipt filters on the platform, writable, ::ancestor.disbReceipt The top part > Disb./receipt > The basic type of the transaction.
documentRef varchar2 Document Reference filters on the platform, writable, ::ancestor.documentRef The top part > Document ref. > The external document reference number.
entryType_description varchar2 Entry Type Description filters on the platform, writable, ::ancestor.entryType.description Click on the magnifier. > The description.
entryType_id varchar2 Entry Type ID filters on the platform, writable, ::ancestor.entryType.id Click on the magnifier. > The identifier.
finPeriod varchar2 Financial Period filters on the platform, writable, ::ancestor.finPeriod The property is now considered obsolete. Use Financial Period instead
financialPeriod varchar2 Financial Period filters on the platform, writable, ::ancestor.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, ::ancestor.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, ::ancestor.financialsDetail.branch.name Click the magnifier. > The name.
financialsDetail_branch_number varchar2 Branch Number filters on the platform, writable, ::ancestor.financialsDetail.branch.number Click the magnifier. > The identifier.
financialsDetail_clearDate datetime Clear Date filters on the platform, writable, ::ancestor.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, ::ancestor.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, ::ancestor.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, ::ancestor.financialsDetail.taxZone.defaultTaxCategory.description Name of item/description
financialsDetail_taxZone_defaultTaxCategory_number varchar2 Tax Zone Default Tax Category Number filters on the platform, writable, ::ancestor.financialsDetail.taxZone.defaultTaxCategory.number Number of item
financialsDetail_taxZone_defaultVatCategory varchar2 Tax Zone Default VAT Category filters on the platform, writable, ::ancestor.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, ::ancestor.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, ::ancestor.financialsDetail.taxZone.errorInfo
financialsDetail_taxZone_id varchar2 Tax Zone ID filters on the platform, writable, ::ancestor.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, ::ancestor.financialsDetail.taxZone.metadata.maxPageSize
financialsDetail_taxZone_metadata_totalCount int64 itgen_vnet_financialsdetail_taxzone_metadata_totalcount filters on the platform, writable, ::ancestor.financialsDetail.taxZone.metadata.totalCount
hold char Hold filters on the platform, writable, ::ancestor.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.
item_description varchar2 itgen_vnet_item_description writable, item.description Name of item/description
item_number varchar2 itgen_vnet_item_number writable, item.number Number of item
lastModifiedDateTime datetime Last Modified filters on the platform, writable, ::ancestor.lastModifiedDateTime System generated information.
lineNumber int32 Line Number writable, lineNumber The line number in the table.
nonBillable char itgen_vnet_nonbillable writable, nonBillable Non-invoiceable > A check box that indicates (if selected) that this transaction is non-invoiceable in the project.
offsetAccount_description varchar2 itgen_vnet_offsetaccount_description writable, offsetAccount.description Name of item/description
offsetAccount_number varchar2 itgen_vnet_offsetaccount_number writable, offsetAccount.number Number of item
offsetAccount_type varchar2 itgen_vnet_offsetaccount_type writable, offsetAccount.type
offsetCashAccount_description varchar2 itgen_vnet_offsetcashaccount_description writable, offsetCashAccount.description Name of item/description
offsetCashAccount_number varchar2 itgen_vnet_offsetcashaccount_number writable, offsetCashAccount.number Number of item
offsetCashAccount_type varchar2 itgen_vnet_offsetcashaccount_type writable, offsetCashAccount.type
offsetSubAccount_active char itgen_vnet_offsetsubaccount_active writable, offsetSubAccount.active Active > The status of the identifier.
offsetSubAccount_description varchar2 itgen_vnet_offsetsubaccount_description writable, offsetSubAccount.description Description > The description of the identifier.
offsetSubAccount_errorInfo varchar2 itgen_vnet_offsetsubaccount_errorinfo writable, offsetSubAccount.errorInfo
offsetSubAccount_lastModifiedDateTime datetime itgen_vnet_offsetsubaccount_lastmodifieddatetime writable, offsetSubAccount.lastModifiedDateTime System generated information.
offsetSubAccount_metadata_maxPageSize int64 itgen_vnet_offsetsubaccount_metadata_maxpagesize writable, offsetSubAccount.metadata.maxPageSize
offsetSubAccount_metadata_totalCount int64 itgen_vnet_offsetsubaccount_metadata_totalcount writable, offsetSubAccount.metadata.totalCount
offsetSubAccount_subaccountId int32 itgen_vnet_offsetsubaccount_subaccountid writable, offsetSubAccount.subaccountId SubID > The identifier of the subaccount.
offsetSubAccount_subaccountNumber varchar2 itgen_vnet_offsetsubaccount_subaccountnumber writable, offsetSubAccount.subaccountNumber Mandatory field: Subaccount* > The subaccount number. Format 9-XX.
offsetSubAccount_timeStamp blob itgen_vnet_offsetsubaccount_timestamp writable, offsetSubAccount.timeStamp The timestamp of the subaccount, used for concurrency control.
owner_internalId varchar2 Owner Internal ID filters on the platform, writable, ::ancestor.owner.internalId
owner_name varchar2 Owner Name filters on the platform, writable, ::ancestor.owner.name The name of the particular destination of the selected type.
owner_number varchar2 Owner Number filters on the platform, writable, ::ancestor.owner.number The identifier of the particular destination of the selected type.
price double Price writable, price Price > The unit price for the item.
projectTask_description varchar2 Project Task Description writable, projectTask.description Click on the magnifier. > The description.
projectTask_id varchar2 Project Task ID writable, projectTask.id Click on the magnifier. > The identifier.
projectTask_internalId int32 itgen_vnet_projecttask_internalid writable, projectTask.internalId The internal identifier.
project_description varchar2 Project Description writable, project.description Click on the magnifier. > The description.
project_id varchar2 Project ID writable, project.id Click on the magnifier. > The identifier.
project_internalId int32 itgen_vnet_project_internalid writable, project.internalId The internal identifier.
quantity double Quantity writable, quantity Quantity > The quantity of the item.
referenceNbr varchar2 Reference Number filters on the platform, writable, ::ancestor.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, ::ancestor.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, ::ancestor.taxAmount The top part > VAT amount > The VAT amount to be paid for the document. A user enters this amount manually.
taxCategory_description varchar2 itgen_vnet_taxcategory_description writable, taxCategory.description Name of item/description
taxCategory_number varchar2 itgen_vnet_taxcategory_number writable, taxCategory.number Number of item
taxTotal double Tax Total filters on the platform, writable, ::ancestor.taxTotal The top part > VAT total > The total amount of tax paid in the document.
timeStamp blob Timestamp filters on the platform, writable, ::ancestor.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, ::ancestor.tranDate Mandatory field: The top part > Trans. date* > The date of the transaction.
tranType varchar2 Transaction Type filters on the platform, writable, ::ancestor.tranType The top part > Trans type > The type of cash transaction.
uom varchar2 Unit of Measure writable, uom UoM > The unit of measure of the item.
vatExemptTotal double VAT Exempt Total filters on the platform, writable, ::ancestor.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, ::ancestor.vatTaxableTotal 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: