invantive documentation
Invantive Support ForumsLog In / Sign Up

GLAccountSchemes: Yuki GL Account Schemes

read only per partition XML

  • Catalog: Yuki
  • Schema: AccountingInfo
  • Label: GL Account Schemes

The data in this table is partitioned per value of the COMPANY_CODE column.

Can only retrieve data.

API Source

  • XML service: https://api.yukiworks.nl/ws/AccountingInfo.asmx
  • XML topic: GetGLAccountScheme
  • XML path: /tns:GetGLAccountSchemeResult/tns:GlAccount

Performance Characteristics

Characteristic Value
Average access latency (ms) 31

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
administrationID ``

Table Columns

The columns of the table GLAccountSchemes 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 /soap11:Envelope/soap11:Body/tns:GetGLAccountSchemeResponse/tns:GetGLAccountSchemeResult/tns:GlAccount/tns:code
COMPANY_CODE varchar2(36) Partition Code
COMPANY_NAME varchar2(240) Partition Name
DEDUCTABLEVATPERCENTAGE decimal itgen_yuki_deductablevatpercentage /soap11:Envelope/soap11:Body/tns:GetGLAccountSchemeResponse/tns:GetGLAccountSchemeResult/tns:GlAccount/tns:deductableVATPercentage
DESCRIPTION varchar2 Description /soap11:Envelope/soap11:Body/tns:GetGLAccountSchemeResponse/tns:GetGLAccountSchemeResult/tns:GlAccount/tns:descripton
DOMAINID varchar2(36) Domain ID
DOMAINNAME varchar2(240) Domain Name
ISENABLED char Is Enabled /soap11:Envelope/soap11:Body/tns:GetGLAccountSchemeResponse/tns:GetGLAccountSchemeResult/tns:GlAccount/tns:isEnabled
ISVATAPPLICABLE char itgen_yuki_isvatapplicable /soap11:Envelope/soap11:Body/tns:GetGLAccountSchemeResponse/tns:GetGLAccountSchemeResult/tns:GlAccount/tns:isVATApplicable
PROFESSIONALPERCENTAGE decimal itgen_yuki_professionalpercentage /soap11:Envelope/soap11:Body/tns:GetGLAccountSchemeResponse/tns:GetGLAccountSchemeResult/tns:GlAccount/tns:professionalPercentage
SUBTYPE varchar2 Subtype /soap11:Envelope/soap11:Body/tns:GetGLAccountSchemeResponse/tns:GetGLAccountSchemeResult/tns:GlAccount/tns:subtype
TYPE varchar2 Type /soap11:Envelope/soap11:Body/tns:GetGLAccountSchemeResponse/tns:GetGLAccountSchemeResult/tns:GlAccount/tns:type

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

  • + DEDUCTABLEVATPERCENTAGE (decimal)
  • + ISVATAPPLICABLE (char)
  • + PROFESSIONALPERCENTAGE (decimal)

All changes of the driver, 26.0 to 27.0