invantive documentation
Invantive Support ForumsLog In / Sign Up

CashTransactionDetailOffsetSubAccountSegments: Visma.net Financials Cash Transaction Detail Offset Subaccount Segments

read only REST

  • Catalog: VismaNet
  • Schema: CashTransaction
  • Label: Cash Transaction Detail Offset Subaccount Segments

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
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 CashTransactionDetailOffsetSubAccountSegments 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.
active char Active writable, ::ancestor.active Active > The status of the identifier.
amount double Amount writable, ::ancestor.::ancestor.amount Amount > The total amount for all units or items.
amount_2 double itgen_vnet_amount_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.amount The top part > Amount > The amount of the transaction.
branch_name varchar2 Branch Name writable, ::ancestor.::ancestor.branch.name Click the magnifier. > The name.
branch_number varchar2 Branch Number writable, ::ancestor.::ancestor.branch.number Click the magnifier. > The identifier.
cashAccount_description varchar2 Cash Account Description filters on the platform, writable, ::ancestor.::ancestor.::ancestor.cashAccount.description Name of item/description
cashAccount_number varchar2 Cash Account Number filters on the platform, writable, ::ancestor.::ancestor.::ancestor.cashAccount.number Number of item
cashAccount_type varchar2 Cash Account Type filters on the platform, writable, ::ancestor.::ancestor.::ancestor.cashAccount.type
controlTotal double Total for Control filters on the platform, writable, ::ancestor.::ancestor.::ancestor.controlTotal Mandatory field: The top part > Control total > The control total of the transaction.
currency varchar2 Currency filters on the platform, writable, ::ancestor.::ancestor.::ancestor.currency The top part > Currency > The currency of the cash account.
description varchar2 Description writable, ::ancestor.description Description > The description of the identifier.
description_2 varchar2 Description 2 writable, ::ancestor.::ancestor.description Description > The description provided for the item.
description_3 varchar2 itgen_vnet_description_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.description The top part > Description > A detailed description of the transaction.
disbReceipt varchar2 itgen_vnet_disbreceipt filters on the platform, writable, ::ancestor.::ancestor.::ancestor.disbReceipt The top part > Disb./receipt > The basic type of the transaction.
documentRef varchar2 Document Reference filters on the platform, writable, ::ancestor.::ancestor.::ancestor.documentRef The top part > Document ref. > The external document reference number.
entryType_description varchar2 Entry Type Description filters on the platform, writable, ::ancestor.::ancestor.::ancestor.entryType.description Click on the magnifier. > The description.
entryType_id varchar2 Entry Type ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.entryType.id Click on the magnifier. > The identifier.
errorInfo varchar2 Error Message writable, ::ancestor.errorInfo
finPeriod varchar2 Financial Period filters on the platform, writable, ::ancestor.::ancestor.::ancestor.finPeriod The property is now considered obsolete. Use Financial Period instead
financialPeriod varchar2 Financial Period filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::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.::ancestor.::ancestor.financialsDetail.branch.name Click the magnifier. > The name.
financialsDetail_branch_number varchar2 Branch Number filters on the platform, writable, ::ancestor.::ancestor.::ancestor.financialsDetail.branch.number Click the magnifier. > The identifier.
financialsDetail_clearDate datetime Clear Date filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::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.::ancestor.::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.::ancestor.::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.::ancestor.::ancestor.financialsDetail.taxZone.defaultTaxCategory.number Number of item
financialsDetail_taxZone_defaultVatCategory varchar2 Tax Zone Default VAT Category filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::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.::ancestor.::ancestor.financialsDetail.taxZone.errorInfo
financialsDetail_taxZone_id varchar2 Tax Zone ID filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::ancestor.financialsDetail.taxZone.metadata.maxPageSize
financialsDetail_taxZone_metadata_totalCount int64 itgen_vnet_financialsdetail_taxzone_metadata_totalcount filters on the platform, writable, ::ancestor.::ancestor.::ancestor.financialsDetail.taxZone.metadata.totalCount
hold char Hold filters on the platform, writable, ::ancestor.::ancestor.::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, ::ancestor.::ancestor.item.description Name of item/description
item_number varchar2 itgen_vnet_item_number writable, ::ancestor.::ancestor.item.number Number of item
lastModifiedDateTime datetime Last Modified writable, ::ancestor.lastModifiedDateTime System generated information.
lastModifiedDateTime_2 datetime Last Modified Date/Time 2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.lastModifiedDateTime System generated information.
lineNumber int32 Line Number writable, ::ancestor.::ancestor.lineNumber The line number in the table.
metadata_maxPageSize int64 Metadata Max Pagesize writable, ::ancestor.metadata.maxPageSize
metadata_totalCount int64 Total Count writable, ::ancestor.metadata.totalCount
nonBillable char itgen_vnet_nonbillable writable, ::ancestor.::ancestor.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, ::ancestor.::ancestor.offsetAccount.description Name of item/description
offsetAccount_number varchar2 itgen_vnet_offsetaccount_number writable, ::ancestor.::ancestor.offsetAccount.number Number of item
offsetAccount_type varchar2 itgen_vnet_offsetaccount_type writable, ::ancestor.::ancestor.offsetAccount.type
offsetCashAccount_description varchar2 itgen_vnet_offsetcashaccount_description writable, ::ancestor.::ancestor.offsetCashAccount.description Name of item/description
offsetCashAccount_number varchar2 itgen_vnet_offsetcashaccount_number writable, ::ancestor.::ancestor.offsetCashAccount.number Number of item
offsetCashAccount_type varchar2 itgen_vnet_offsetcashaccount_type writable, ::ancestor.::ancestor.offsetCashAccount.type
owner_internalId varchar2 Owner Internal ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.owner.internalId
owner_name varchar2 Owner Name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.owner.name The name of the particular destination of the selected type.
owner_number varchar2 Owner Number filters on the platform, writable, ::ancestor.::ancestor.::ancestor.owner.number The identifier of the particular destination of the selected type.
price double Price writable, ::ancestor.::ancestor.price Price > The unit price for the item.
projectTask_description varchar2 Project Task Description writable, ::ancestor.::ancestor.projectTask.description Click on the magnifier. > The description.
projectTask_id varchar2 Project Task ID writable, ::ancestor.::ancestor.projectTask.id Click on the magnifier. > The identifier.
projectTask_internalId int32 itgen_vnet_projecttask_internalid writable, ::ancestor.::ancestor.projectTask.internalId The internal identifier.
project_description varchar2 Project Description writable, ::ancestor.::ancestor.project.description Click on the magnifier. > The description.
project_id varchar2 Project ID writable, ::ancestor.::ancestor.project.id Click on the magnifier. > The identifier.
project_internalId int32 itgen_vnet_project_internalid writable, ::ancestor.::ancestor.project.internalId The internal identifier.
quantity double Quantity writable, ::ancestor.::ancestor.quantity Quantity > The quantity of the item.
referenceNbr varchar2 Reference Number filters on the platform, writable, ::ancestor.::ancestor.::ancestor.referenceNbr The top part > Ref. no. > The unique identifier assigned to the cash transaction in accordance with the numbering sequence.
segmentDescription varchar2 itgen_vnet_segmentdescription writable, segmentDescription The Segment values window > The Top part > The description of the segment.
segmentId int32 Segment ID writable, segmentId The Segment values window > The Top part > The ID of the segment.
segmentValue varchar2 Segment Value writable, segmentValue The Segment values window > The table > The value of the segment, alphanumeric.
segmentValueDescription varchar2 Segment Value Description writable, segmentValueDescription The Segment values window > The table > The description of the segment value.
status varchar2 Status filters on the platform, writable, ::ancestor.::ancestor.::ancestor.status The top part > Status > The status of the transaction, which is automatically assigned by the system.
subaccountId int32 itgen_vnet_subaccountid writable, ::ancestor.subaccountId SubID > The identifier of the subaccount.
subaccountNumber varchar2 itgen_vnet_subaccountnumber writable, ::ancestor.subaccountNumber Mandatory field: Subaccount* > The subaccount number. Format 9-XX.
taxAmount double Tax Amount filters on the platform, writable, ::ancestor.::ancestor.::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, ::ancestor.::ancestor.taxCategory.description Name of item/description
taxCategory_number varchar2 itgen_vnet_taxcategory_number writable, ::ancestor.::ancestor.taxCategory.number Number of item
taxTotal double Tax Total filters on the platform, writable, ::ancestor.::ancestor.::ancestor.taxTotal The top part > VAT total > The total amount of tax paid in the document.
timeStamp blob Timestamp writable, ::ancestor.timeStamp The timestamp of the subaccount, used for concurrency control.
timeStamp_2 blob itgen_vnet_timestamp_2 filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::ancestor.tranDate Mandatory field: The top part > Trans. date* > The date of the transaction.
tranType varchar2 Transaction Type filters on the platform, writable, ::ancestor.::ancestor.::ancestor.tranType The top part > Trans type > The type of cash transaction.
uom varchar2 Unit of Measure writable, ::ancestor.::ancestor.uom UoM > The unit of measure of the item.
vatExemptTotal double VAT Exempt Total filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::ancestor.vatTaxableTotal The top part > VAT taxable total > The document total that is subjected to VAT.

Keys

Key Column Refers to Kind Description
CashTransactionDetailOffsetSubAccountSegments_project_id_txt project_id Projects.projectID Textual The project, or the code for no project when the document is not associated with a project; that code has no row in Projects.

Release Notes

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