invantive documentation
Invantive Support ForumsLog In / Sign Up

FinderTypeCodes: Twinfield Domain FinderTypeCodes

read only

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

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

Can only retrieve data.

Example

The code value 'ART' means 'Items'.

Performance Characteristics

Characteristic Value
Estimated rows 45
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 FinderTypeCodes 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
ART itgen_twinfield_findertypecodes_art
ASM itgen_twinfield_findertypecodes_asm
BDS itgen_twinfield_findertypecodes_bds
BNK itgen_twinfield_findertypecodes_bnk
BSN itgen_twinfield_findertypecodes_bsn
CDA itgen_twinfield_findertypecodes_cda
CER itgen_twinfield_findertypecodes_cer
CQT itgen_twinfield_findertypecodes_cqt
CTR itgen_twinfield_findertypecodes_ctr
CUR itgen_twinfield_findertypecodes_cur
DIM itgen_twinfield_findertypecodes_dim
DMT itgen_twinfield_findertypecodes_dmt
DVT itgen_twinfield_findertypecodes_dvt
FLT itgen_twinfield_findertypecodes_flt
FMT itgen_twinfield_findertypecodes_fmt
GRP itgen_twinfield_findertypecodes_grp
GWY itgen_twinfield_findertypecodes_gwy
HIE itgen_twinfield_findertypecodes_hie
HND itgen_twinfield_findertypecodes_hnd
ICTCOUNTRY itgen_twinfield_findertypecodes_ictcountry
INV itgen_twinfield_findertypecodes_inv
IVT itgen_twinfield_findertypecodes_ivt
MAT itgen_twinfield_findertypecodes_mat
OFF itgen_twinfield_findertypecodes_off
OFG itgen_twinfield_findertypecodes_ofg
OIC itgen_twinfield_findertypecodes_oic
PAY itgen_twinfield_findertypecodes_pay
PIS itgen_twinfield_findertypecodes_pis
PRD itgen_twinfield_findertypecodes_prd
REP itgen_twinfield_findertypecodes_rep
REW itgen_twinfield_findertypecodes_rew
RMD itgen_twinfield_findertypecodes_rmd
ROL itgen_twinfield_findertypecodes_rol
SAR itgen_twinfield_findertypecodes_sar
SPM itgen_twinfield_findertypecodes_spm
TEQ itgen_twinfield_findertypecodes_teq
TRS itgen_twinfield_findertypecodes_trs
TRT itgen_twinfield_findertypecodes_trt
TXG itgen_twinfield_findertypecodes_txg
USR itgen_twinfield_findertypecodes_usr
VAT itgen_twinfield_findertypecodes_vat
VATN itgen_twinfield_findertypecodes_vatn
VGM itgen_twinfield_findertypecodes_vgm
VTB itgen_twinfield_findertypecodes_vtb
XLT itgen_twinfield_findertypecodes_xlt

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.FinderTypeCodes is added

The view has 4 columns and can select.

  • importance 3

All changes of the driver, 26.0 to 27.0