invantive documentation
Invantive Support ForumsLog In / Sign Up

CreditTermRecords: Visma.net Financials Credit Term Records

read only REST

  • Catalog: VismaNet
  • Schema: CreditTerm
  • Label: Credit Term Records

Get a range of credit terms - ScreenId=CS206500

Can only retrieve data.

API Source

  • Endpoint: /v1/creditTerm
  • Operation: get /v1/creditTerm

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
createdDateTime `` This value, generated by the system, indicates the creation date and time. Use it to retrieve all records that have been created 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: CreatedDateTime and CreatedDateTimeCondition are mutually inclusive.
createdDateTimeCondition `` 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: CreatedDateTime and CreatedDateTimeCondition are mutually inclusive.
lastModifiedDateTime ``
lastModifiedDateTimeCondition `` System retrieved information for state/condition.
termsId ``

Table Columns

The columns of the table CreditTermRecords 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.
calculationType varchar2 itgen_vnet_calculationtype writable, calculationType Calculation Type: G - Gross amount, N - Net amount
createdDateTime datetime Created writable, createdDateTime
delayDays int32 itgen_vnet_delaydays writable, delayDays
description varchar2 Description writable, description
discountDay int32 itgen_vnet_discountday writable, discountDay
discountPercent double Discount Percent writable, discountPercent
discountType varchar2 itgen_vnet_discounttype writable, discountType Discount Type , values: N - Fixed Number of Days, D - Day of Next Month, E - End of the Month, M - End of Next Month, T - Day of the Month, P - Fixed Number of Days starting Next Month.
dueDateType varchar2 itgen_vnet_duedatetype writable, dueDateType Due Date Type , values: N - Fixed Number of Days, D - Day of Next Month, E - End of the Month, M - End of Next Month, T - Day of the Month, P - Fixed Number of Days starting Next Month, C - Custom.
dueDay1 int32 itgen_vnet_dueday1 writable, dueDay1
dueDay1DayFrom1 int32 itgen_vnet_dueday1dayfrom1 writable, dueDay1DayFrom1
dueDay1DayTo1 int32 itgen_vnet_dueday1dayto1 writable, dueDay1DayTo1
dueDay2 int32 itgen_vnet_dueday2 writable, dueDay2
dueDay2DayFrom1 int32 itgen_vnet_dueday2dayfrom1 writable, dueDay2DayFrom1
dueDay2DayTo1 int32 itgen_vnet_dueday2dayto1 writable, dueDay2DayTo1
instalmentFrequency varchar2 itgen_vnet_instalmentfrequency writable, instalmentFrequency Instalment Frequency, values: W - Weekly, M - Monthly, B - Semi-monthly (the second installment comes a half a month after the first one, and so on).
instalmentMethod varchar2 itgen_vnet_instalmentmethod writable, instalmentMethod Instalment Method, values: E - Equal Parts, A - All Tax in First Installment (the total amount before tax is split equally between installments and the entire amount of tax is added to the first installment), S - Split by Percents in Table (the days and amounts of installments are defined by the related Instalments Schedule records).
instalmentType varchar2 itgen_vnet_instalmenttype writable, instalmentType Instalment Type: S - Simple, M - Multiple
lastModifiedDateTime datetime Last Modified writable, lastModifiedDateTime
moveDueDateIfOnTheWeekend varchar2 itgen_vnet_moveduedateifontheweekend writable, moveDueDateIfOnTheWeekend Move Due Date If On The Weekend, values: 1 - Keep the exact date, 2 - Day before (Friday), 3 - Day after (Monday).
numberOfInstalments int32 itgen_vnet_numberofinstalments writable, numberOfInstalments
pageNumber int32 Page Number filters on the platform, writable, ::ancestor.pageNumber
pageSize int32 Pagesize filters on the platform, writable, ::ancestor.pageSize
termsId varchar2 itgen_vnet_termsid writable, termsId
totalCount int64 Total Count filters on the platform, writable, ::ancestor.totalCount
visibleTo varchar2 itgen_vnet_visibleto writable, visibleTo VisibleTo: AL - All, VE - Suppliers, CU - Customers, DS - Disabled

Referenced By

Release Notes

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