Column Attribute Codes

ID

Attribute Name

Format

R/W

Notes

DVAR

Data Name

C(16)

R

Database variable. Maintained by Barista.

DTAL

Source Alias

C(16)

R

Database alias. Maintained by Barista.

CSEQ

Column Seq

C(3)

R

Column sequence. Maintained by Barista.

VTYP

Variable Type

C(1)

R

Variable Type. Maintained by Barista.

• C = Defined Column

• A = Auxiliary Column

• L = Auxiliary Label

• D = Derived Data Element

CTLI

GUI Control ID

C(5)

R

GUI control id. Maintained by Barista.

CTLN

GUI Control Name

C(16)

R

GUI Control Name. Maintained by Barista.

CTLC

GUI Control Context

C(5)

R

GUI control context. Maintained by Barista.

DCHN

Data Table Channel

C(5)

R

Opened channel for DTAB. Maintained by Barista.

TIND

Tab Order Idx

C(3)

R

Tab order index of an entry object on its parent form.

RKEY

Primary Key?

C(1)

R

Included in primary key definition.

• Y=Yes

• N=No

CPGM

Callpoint Program

C(60)

R

Callpoint program to run for selected processes.

CPRO

Callpoint Process

C(20)

R

Semicolon-delimited string of process codes that trigger the callpoint program (e.g.: "BINP;AVAL;").

• BINP=Before Column Input

• BINQ=Before Column Inquiry

• AINP=After Column Input

• AINQ=After Column Inquiry

• AVAL=After Column Validation

• AVEC=After Grid Vector Update

BTNS

Form Buttons

C(5)

R

Form function buttons. Maintained by Barista. May contain one or more of the following:

• F=Find

• D=Drilldown

• C=Calendar

• L=Document Link

ETYP

Element Type

C(16)

R

Element Type. Maintained by Barista

DESC

Description

C(30)

R

Column description

LABL

Window Label

C(30)

R

Control label text to display on form

LABS

Column Header

C(20)

R

Column header to display on reports and grid style forms

DTYP

Data Type

C(1)

R

Data type

• C=Character

• N=Numeric

• I=Integer

• U=Unsigned Integer

• B=Business Math

• O=BLOB

STYP

Data SubType

C(1)

R

Subtype definition for data types

• 1=Date (YYYYMMDD)

• 2=Date (YYYYMM)

• 3=Date (YYYY)

• 4=Date (YYMMDD)

• 5=Date (MMDD)

• 6=Created Date Stamp

• 7=Revised Date Stamp

• 8=Created Time Stamp

• 9=Revised Time Stamp

• A=Time (HHMMSS)

• B=Time (HHMM)

• C=Time (MMSS)

• S=Sequence Counter

• I=Image Path

CTYP

Control Type

C(1)

R

Type of control to display on the form

• E=CharacterEdit (InputE)

• e=CharacterSpinner (InputESpinner)

• N=NumericEdit (InputN)

• n=NumericSpinner (InputNSpinner)

• D=DateEdit (InputD)

• d=DateSpinner (InputDSpinner)

• U=MultiLineEdit (CEDIT)

• C=CheckBox

• L=ListButton

• O=ListBox

• I=Slider

• R=RadioButton Group

• H=None (Hidden)

• X=None (Ref Only)

ABLC

Enable Column

C(40)

R

Enable/disable column. Specifies the <table.column_id> containing the data to use when calculating if the current column should be enabled or disabled. Value is specified in "ABLV"

ABLV

Enable Value

C(30)

R

Value trigger to enable/disable column. May contain one or more semi-colon delimited values to search when testing if current column should be disabled.

CDAT

Check Box Values

C(20)

R

CheckBox on/off value definition in the format "checked value;unchecked value" (e.g.: "Y;N").

CTLX

Ctrl Left (X)

N(4)

R

Entry control left edge fixed location (in pixels)

CTLY

Ctrl Top (Y)

N(4)

R

Entry control top edge fixed location (in rows)

CTLW

Fixed Width

N(4)

R

Entry control fixed width (in pixels)

CTLH

Fixed Height

N(4)

R

Entry control fixed height (in pixels)

DKEY

Data Key

C(40)

R

Special validation key for non standard record find

DTAB

Data Table

C(16)

R

Validation/display table

DCOL

Data Column

C(16)

R

Validation/display column

DKNM

Data Key Name

C(16)

R

Key name to use for validation

CALC

Data Calc

C(99)

R

Display data calculation. Calculation expression is defined in Form Manager à Form Designer à Derived Data Elements.

DCOM

Data Compress

C(12)

R

Data compression formula record ID.

DEXP

Data Expand

C(12)

R

Data expansion formula record ID.

DFLT

Default Value

C(80)

R/W

Default column value

DRLE

Drilldown Def

C(16)

R

Drill down definition ID

GHDR

Group Heading

C(30)

R

Header text for control entry group

HELP

Help Tag ID

C(10)

R

Help tag linking to system help

LDAT

List Data

C(10)

R

Semicolon-delimited list of values to display in a list control, specified in the format:

• List item description (30) + "~" + List item ID (4)

For example:

Product Level                ~P   ;

Item Level                   ~I   ;

No Sales Analysis            ~N   ;

MINL

Min Length

N(3)

R/W

Minimum data input length

MAXL

Max Length

N(3)

R/W

Maximum data input length

MAXR

Max Rows

N(2)

R

Maximum number of rows for entry

MINV

Min Value

C(20)

R/W

Minimum data entry value

MAXV

Max Value

C(20)

R/W

Maximum data entry value

MSKI

Input Mask

C(20)

R

Mask used during data entry

MSKO

Output Mask

C(20)

R

Mask used during data display

MSKS

Mask System

C(3)

R

System ID for defined mask

MSKT

Mask Type

C(2)

R

Mask type to use from system record

OPTS

Optional Defs

C(1)

R

Semicolon-delimited list of column definition options taken from the following list (e.g.: "I;N;O;U;").

• W=Hide data in maintenance form

• G=Hide data in maintenance grid

• I=Hide data in inquiry system

• O=Hide data in all forms

• P=Hide data in 'Print All' option

• R=Hide data in 'Print Record' option

• L=Hide corresponding control label

• +=Create total for inquiry column

• V=Display description in grid

• E=Save contents on conditional disable

• Y=Period/year entry control

• 1=From/to entry control set

• 2=Null entry='First' or 'Last'

• 3=Null entry='All'

• T=Limit to variable naming rules

• X=Resize control on window resize

• ?=Wildcard data entry

• S=Validate entries on save only

• N=Control contains external link

• D=Use last valid entry as default

• F=Do not resolve STBL reference

• U=Grid entry value must be unique

• C=Display only-all cases

• A=Display only-new records only

• B=Display only-existing records only

• Z=Value must be zero for record delete

• p=Password entry control

• s=Spellcheck control

• 0=Zero based sequence number control

• #=Assign next sequence on null entry

• M=Multiple language data control

PADC

Pad Character

C(2)

R

Pad character.

• 20=Space

• 22=Quote

• 23=Pound (#)

• 2A=Asterisk (*)

• 2E=Period (.)

• 30=Zero (0)

• 5E=Caret (^)

• 5F=Underscore (_)

PADJ

Pad Alignment

C(1)

R

Entry data alignment

• L=Left

• R=Right

PREC

Precision

N (1)

R

Numeric precision

PROM

User Prompt

C(80)

R/W

User help text to display on status bar

PVAL

Preset Value

C(30)

R

Preset (locked) value

SDLG

System Dialog

C(1)

R

System dialog allowed for inquiry

• O=File Open

• S=File Save

• P=Printer

TABG

Tab Location

C(1)

R

Numeric tab location counter for this and subsequent controls.