invantive documentation
Invantive Support ForumsLog In / Sign Up

GLAccountTypes: Exact Online Domain GLAccountTypes

read only

  • Catalog: ExactOnlineREST
  • Schema: CodeValues
  • Label: Domain GLAccountTypes

Lookup-table that translates code values of the domain 'GLAccountTypes' into descriptions.

Can only retrieve data.

Example

The code value '10' means 'Cash'.

Performance Characteristics

Characteristic Value
Estimated rows 33
Average access latency (ms) 432
Full scan rows per minute 50,300
Point query rows per minute 138

Table Columns

The columns of the table GLAccountTypes 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(240) Code fetched only when named Unique code within the domain.
description varchar2(4000) Description fetched only when named Meaning of the unique code within the domain.
domain varchar2(240) Domain fetched only when named Each domain defines a map of codes to values.
resource_code varchar2(240) Resource Code fetched only when named Resource code for internationalization.

Code Values

Code Description
10 itgen_eol_glaccounttypes_10
100 itgen_eol_glaccounttypes_100
110 itgen_eol_glaccounttypes_110
111 itgen_eol_glaccounttypes_111
12 itgen_eol_glaccounttypes_12
120 itgen_eol_glaccounttypes_120
121 itgen_eol_glaccounttypes_121
122 itgen_eol_glaccounttypes_122
123 itgen_eol_glaccounttypes_123
125 itgen_eol_glaccounttypes_125
126 itgen_eol_glaccounttypes_126
130 itgen_eol_glaccounttypes_130
14 itgen_eol_glaccounttypes_14
140 itgen_eol_glaccounttypes_140
150 itgen_eol_glaccounttypes_150
16 itgen_eol_glaccounttypes_16
160 itgen_eol_glaccounttypes_160
20 itgen_eol_glaccounttypes_20
22 itgen_eol_glaccounttypes_22
24 itgen_eol_glaccounttypes_24
25 itgen_eol_glaccounttypes_25
26 itgen_eol_glaccounttypes_26
27 itgen_eol_glaccounttypes_27
29 itgen_eol_glaccounttypes_29
30 itgen_eol_glaccounttypes_30
32 itgen_eol_glaccounttypes_32
35 itgen_eol_glaccounttypes_35
40 itgen_eol_glaccounttypes_40
50 itgen_eol_glaccounttypes_50
52 itgen_eol_glaccounttypes_52
55 itgen_eol_glaccounttypes_55
60 itgen_eol_glaccounttypes_60
90 itgen_eol_glaccounttypes_90

Release Notes

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