invantive documentation
Invantive Support ForumsLog In / Sign Up

BrowseCodes: Twinfield Domain BrowseCodes

read only

  • Catalog: Twinfield
  • Schema: CodeValues
  • Label: Domain BrowseCodes

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

Can only retrieve data.

Example

The code value '000' means 'General ledger transactions'.

Performance Characteristics

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

Table Columns

The columns of the table BrowseCodes 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
000 itgen_twinfield_browsecodes_000
010 itgen_twinfield_browsecodes_010
020 itgen_twinfield_browsecodes_020
030_1 itgen_twinfield_browsecodes_030_1
030_2 itgen_twinfield_browsecodes_030_2
030_3 itgen_twinfield_browsecodes_030_3
031 itgen_twinfield_browsecodes_031
031_2 itgen_twinfield_browsecodes_031_2
040_1 itgen_twinfield_browsecodes_040_1
050_1 itgen_twinfield_browsecodes_050_1
060 itgen_twinfield_browsecodes_060
100 itgen_twinfield_browsecodes_100
130_1 itgen_twinfield_browsecodes_130_1
130_2 itgen_twinfield_browsecodes_130_2
130_3 itgen_twinfield_browsecodes_130_3
164 itgen_twinfield_browsecodes_164
200 itgen_twinfield_browsecodes_200
230_1 itgen_twinfield_browsecodes_230_1
230_2 itgen_twinfield_browsecodes_230_2
300 itgen_twinfield_browsecodes_300
301 itgen_twinfield_browsecodes_301
302_1 itgen_twinfield_browsecodes_302_1
400 itgen_twinfield_browsecodes_400
410 itgen_twinfield_browsecodes_410
610_1 itgen_twinfield_browsecodes_610_1
620 itgen_twinfield_browsecodes_620
650_1 itgen_twinfield_browsecodes_650_1
651_1 itgen_twinfield_browsecodes_651_1
652_1 itgen_twinfield_browsecodes_652_1
660_1 itgen_twinfield_browsecodes_660_1
661_1 itgen_twinfield_browsecodes_661_1
662_1 itgen_twinfield_browsecodes_662_1
670 itgen_twinfield_browsecodes_670
680 itgen_twinfield_browsecodes_680
680_2 itgen_twinfield_browsecodes_680_2
690 itgen_twinfield_browsecodes_690
700 itgen_twinfield_browsecodes_700
900 itgen_twinfield_browsecodes_900

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.CodeValues.BrowseCodes is added

The view has 4 columns and can select.

  • importance 3

All changes of the driver, 26.0 to 27.0