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 |
|---|---|---|---|---|
created |
`` | 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- * yyyy- * yyyy- * yyyy- * yyyy- Note: CreatedDateTime and CreatedDateTimeCondition are mutually inclusive. |
||
created |
`` | 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. | ||
last |
`` | |||
last |
`` | System retrieved information for state/condition. | ||
terms |
`` |
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_ |
varchar2 |
Company Code | writable | Partition code, segmenting the data. | |
COMPANY_ |
varchar2 |
Company Name | writable | Name of the partition. | |
calculation |
varchar2 |
itgen_vnet_calculationtype | writable, calculation |
Calculation Type: G - Gross amount, N - Net amount | |
created |
datetime |
Created | writable, created |
||
delay |
int32 |
itgen_vnet_delaydays | writable, delay |
||
description |
varchar2 |
Description | writable, description |
||
discount |
int32 |
itgen_vnet_discountday | writable, discount |
||
discount |
double |
Discount Percent | writable, discount |
||
discount |
varchar2 |
itgen_vnet_discounttype | writable, discount |
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. | |
due |
varchar2 |
itgen_vnet_duedatetype | writable, due |
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. | |
due |
int32 |
itgen_vnet_dueday1 | writable, due |
||
due |
int32 |
itgen_vnet_dueday1dayfrom1 | writable, due |
||
due |
int32 |
itgen_vnet_dueday1dayto1 | writable, due |
||
due |
int32 |
itgen_vnet_dueday2 | writable, due |
||
due |
int32 |
itgen_vnet_dueday2dayfrom1 | writable, due |
||
due |
int32 |
itgen_vnet_dueday2dayto1 | writable, due |
||
instalment |
varchar2 |
itgen_vnet_instalmentfrequency | writable, instalment |
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). | |
instalment |
varchar2 |
itgen_vnet_instalmentmethod | writable, instalment |
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). | |
instalment |
varchar2 |
itgen_vnet_instalmenttype | writable, instalment |
Instalment Type: S - Simple, M - Multiple | |
last |
datetime |
Last Modified | writable, last |
||
move |
varchar2 |
itgen_vnet_moveduedateifontheweekend | writable, move |
Move Due Date If On The Weekend, values: 1 - Keep the exact date, 2 - Day before (Friday), 3 - Day after (Monday). | |
number |
int32 |
itgen_vnet_numberofinstalments | writable, number |
||
page |
int32 |
Page Number | filters on the platform, writable, ::ancestor. |
||
page |
int32 |
Pagesize | filters on the platform, writable, ::ancestor. |
||
terms |
varchar2 |
itgen_vnet_termsid | writable, terms |
||
total |
int64 |
Total Count | filters on the platform, writable, ::ancestor. |
||
visible |
varchar2 |
itgen_vnet_visibleto | writable, visible |
VisibleTo: AL - All, VE - Suppliers, CU - Customers, DS - Disabled |
Referenced By
- CashSaleApplications
creditTerms_id(Key) - CashSaleLines
creditTerms_id(Key) - CashSales
creditTerms_id(Key) - CustomerAttributes
creditTerms_id(Key) - CustomerDirectDebitLines
creditTerms_id(Key) - CustomerPaymentMethods
creditTerms_id(Key) - Customers
creditTerms_id(Key) - CustomerCreditNoteApplications
creditTerms_id(Key) - CustomerCreditNoteLines
creditTerms_id(Key) - CustomerCreditNoteTaxDetails
creditTerms_id(Key) - CustomerCreditNotes
creditTerms_id(Key) - CustomerDebitNoteApplications
creditTerms_id(Key) - CustomerDebitNoteLines
creditTerms_id(Key) - CustomerDebitNoteTaxDetails
creditTerms_id(Key) - CustomerDebitNotes
creditTerms_id(Key) - CustomerInvoiceApplications
creditTerms_id(Key) - CustomerInvoiceLineSubaccountSegments
creditTerms_id(Key) - CustomerInvoiceLines
creditTerms_id(Key) - CustomerInvoiceSubaccountSegments
creditTerms_id(Key) - CustomerInvoiceTaxDetails
creditTerms_id(Key) - CustomerInvoices
creditTerms_id(Key) - CustomerOverdueChargeApplications
creditTerms_id(Key) - CustomerOverdueChargeLines
creditTerms_id(Key) - CustomerOverdueChargeSubAccountSegmentLines
creditTerms_id(Key) - CustomerOverdueChargeTaxDetails
creditTerms_id(Key) - CustomerOverdueCharges
creditTerms_id(Key) - PurchaseOrderDiscountDetails
terms_id(Key) - PurchaseOrderLineSubsegments
terms_id(Key) - PurchaseOrderLines
terms_id(Key) - PurchaseOrderReceipts
terms_id(Key) - PurchaseOrderTaxDetails
terms_id(Key) - PurchaseOrders
terms_id(Key) - SalesOrders
terms_id(Key) - SupplierAttributes
creditTerms_id(Key) - SupplierPaymentMethodDetails
creditTerms_id(Key) - Suppliers
creditTerms_id(Key) - SupplierInvoiceLandedCosts
creditTerms_id(Key) - SupplierInvoiceLines
creditTerms_id(Key) - SupplierInvoiceTaxDetailLines
creditTerms_id(Key) - SupplierInvoices
creditTerms_id(Key)
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: