Configuring the Custom Freight Bill Properties Window

Relative to release 421

To configure the Custom Freight Bill Properties Window:

1 Open the CUSTSYS.MDB.

2 Open the CUST_EVNT table.

3 Type the required entry in the following fields:

In This Field
Type This
OWNER_KEY
The Owner_Key of the Customer being configured.
EVNT
The event name of the screen being configured. These are documented below.
EVNT_SEQ_NUM
An unused unique integer, which must be present to satisfy the keys of the CUST_EVNT table.
EVNT_CLASS
The name of the EVNT_CLASS or, in this case, PROPERTY being set.
IN_USE_FLAG
A Flag which must be True (Yes) for this property to be set (if false, the record is ignored).
EVNT_TYPE
Possible values are:
Text A string value which is literally set.
Eval An expression which is evaluated as the property is set.
Boolean A Flag, which can be True or False, or Yes or No.
Number A number.
EVNT_MEMO
The actual value of the property.

Notes

All properties of this window share these fields:

OWNER_KEY = <owner_key>

EVNT = ‘FRGHT_BL Custom Properties Setup’

If no properties are defined, then the Custom Freight Bill Properties window will assume a default configuration, using labels such as %T001, etc. If any property is defined, then only %T000 fields that have defined settings will be used.

All %T001 properties exist for %T001 through %T010. Any %T0nn label may be freely substituted for %T001.

Properties (EVNT_CLASS)

Caption: Controls the caption that appears on the title bar of the form.

EVNT_TYPE: Text

EVNT_MEMO: <desired screen caption>

Default Value: ’Custom Properties’

Field_Width: Controls the width of the Text Value portion of the screen. The value is xpressed in inches.

EVNT_TYPE: Number

EVNT_MEMO: <desired button caption>

Default: 1

%T001_Caption: Text that appears as the Caption for field FRGHT_BL![%T001].

EVNT_TYPE: Text

EVNT_MEMO: <desired field caption>

Default: ‘Text 1‘

%T001_StatusBarText: Text that appears on the Status Bar for field FRGHT_BL![%T001].

EVNT_TYPE: Text

EVNT_MEMO: <desired field Status Bar Text>

Default: <The value of %T001_Caption>

%T001_Format: Any valid MSAccess defined format in which data is to be displayed, such as ‘Percent’, ‘Standard’, ‘yy/mm/dd’, etc.

EVNT_TYPE: Text

EVNT_MEMO: <The format to use>

Default: Null

%T001_AllowUpdating: A Flag which controls whether the field can be updated when it is being viewed as part of a Checked-Out exception batch.

EVNT_TYPE: Boolean

EVNT_MEMO: True or False

Default: False

%T001_ValidationRule: A valid MSAccess control Validation Rule setting. This can be used to do rudimentary field level validation if %T001_AllowUpdating = True. It is typically used in conjunction with %T001_ValidationText.

EVNT_TYPE: Text

EVNT_MEMO: <A valid MSAccess ValidationRule setting>

Default: Null

%T001_ValidationText: An error message which is displayed if T001_ValidationRule fails.

EVNT_TYPE: Text

EVNT_MEMO: <The desired error message>

Default: Null

In This Field	Type This
OWNER_KEY	The Owner_Key of the Customer being configured.
EVNT	The event name of the screen being configured. These are documented below.
EVNT_SEQ_NUM	An unused unique integer, which must be present to satisfy the keys of the CUST_EVNT table.
EVNT_CLASS	The name of the EVNT_CLASS or, in this case, PROPERTY being set.
IN_USE_FLAG	A Flag which must be True (Yes) for this property to be set (if false, the record is ignored).
EVNT_TYPE	Possible values are: Text A string value which is literally set. Eval An expression which is evaluated as the property is set. Boolean A Flag, which can be True or False, or Yes or No. Number A number.
EVNT_MEMO	The actual value of the property.