invantive documentation
Invantive Support ForumsLog In / Sign Up

ArticleLines: Twinfield Item Lines

read only

  • Catalog: Twinfield
  • Schema: Views
  • Label: Item Lines

Can only retrieve data.

Performance Characteristics

Characteristic Value
Average access latency (ms) 54
Full scan rows per minute 1,690
Point query rows per minute 1,111
Write rows per minute 378

The result can be cached on the client.

Table Columns

The columns of the table ArticleLines 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 Company ID
COMPANY_CODE2 varchar2 Company ID
COMPANY_NAME varchar2 Company Name
FREETEXT1 varchar2 Free Text 1
FREETEXT2 varchar2 Free Text 2
FREETEXT3 varchar2 Free Text 3
NAME varchar2 Name
SHORTNAME varchar2 Short Name
SUBCODE varchar2 Sub-item Code
UNITS double Units
UNITSPRICEEXCL decimal Unit Price Excluding VAT
UNITSPRICEINC decimal Unit Price Including VAT
article_code varchar2 Code article_code

Release Notes

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

Changes of This Table, 26.0 to 27.0

View Twinfield.Views.ArticleLines is added

The view has 13 columns and can select.

  • importance 3

All changes of the driver, 26.0 to 27.0