invantive documentation
Invantive Support ForumsLog In / Sign Up

ContactFinancials: Bouw7 Contact Financials

read only REST

  • Catalog: Bouw7
  • Schema: Contact
  • Label: Contact Financials

Returns a list of financial contact details associated with the organization. Returns a list of financial contact details associated with the organization.

Can only retrieve data.

Summary

Returns a list of financial contact details associated with the organization.

API Source

  • Endpoint: /list/contact/financial
  • Operation: get /list/contact/financial

Performance Characteristics

Characteristic Value
Average access latency (ms) 90
Full scan rows per minute 1,230,000
Point query rows per minute 666

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
q `` A Heimdall Query Language string.

Table Columns

The columns of the table ContactFinancials 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
code varchar2 Code filters on the platform, writable, code The code of the financial contact details.
contactId int64 Contact ID filters on the platform, writable, contactId The contact ID of the financial contact details.
divisionId int64 Division ID filters on the platform, writable, divisionId The division ID of the financial contact details.
glAccountCode varchar2 General Ledger Account Code filters on the platform, writable, glAccountCode The general ledger account code of the financial contact details.
glAccountCodePurchase varchar2 General Ledger Account Code Purchase filters on the platform, writable, glAccountCodePurchase The purchase general ledger account code of the financial contact details.
id int64 ID filters on the platform, writable, id The ID of the financial contact details.
paymentConditionPurchase varchar2 Payment Condition Purchase filters on the platform, writable, paymentConditionPurchase The default payment condition to use for purchase related items.
paymentConditionSales varchar2 Payment Condition Sales filters on the platform, writable, paymentConditionSales The default payment condition to use for sales related items.

Release Notes

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