invantive documentation
Invantive Support ForumsLog In / Sign Up

Articles: Visma eAccounting Articles

read only

  • Catalog: VismaEAccounting
  • Schema: V2
  • Label: Articles

Can only retrieve data.

Table Columns

The columns of the table Articles 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
ChangedUtc varchar2 Changed UTC
CodingId varchar2 Coding ID Reference to Article Account Codings.
CodingName varchar2 Coding Name
GrossPrice decimal Gross Price
HouseWorkType int32 Housework Type
Id varchar2 ID Unique Id provided by eAccounting.
IsActive char Is Active
Name varchar2(50) Name
NameEnglish varchar2(50) Name English
NetPrice decimal Net Price
Number varchar2(40) Number
PurchasePrice decimal Purchase Price
PurchasePriceManuallyChangedUtc varchar2 Purchase Price Manually Changed UTC
SendToWebshop char Send to Webshop
StockBalance decimal Stock Balance
StockBalanceAvailable decimal Stock Balance Available
StockBalanceManuallyChangedUtc varchar2 Stock Balance Manually Changed UTC Set when the stock balance is changed manually.
StockBalanceReserved decimal Stock Balance Reserved
UnitAbbreviation varchar2 Unit Abbreviation
UnitId varchar2 Unit ID
UnitName varchar2 Unit Name Unit name entered from UnitId.
UsesMoss char Uses MOSS