Section 11
Address Capture Lookup Table
This table is used to store
information you enter on a special screen during the transaction
entry process. It allows you to have a database (contained in the
table)
of names that will be able to be retrieved via the account number
and
which will pre-fill the entry form. The data in the table can be
loaded
via another external system or imported from other databases that
your
system has access to.
The
transaction codes table contains
the field called
field_types.
This field defines a link to a record the
Address
Field
names table which in turn contains a list of
fields that you provide a name for. For example, you
might need to collect special information when someone applies for
a building permit. When you enter the information during
transaction entry, the
Address Capture table is where
the data are stored.
Each field in the table is listed, along with a short
description, below:
-
FIELD_TYPES
This is the name of the field_types value that is used
to define the additional field names y
|
|
|
ou can enter in the
non-address portion of the address entry screen.
It links directly to a record in the
Address Field Names table, which in turn defines the
screen prompts
that appear when you use the address capture
feature.
-
APPLICATION_NUMBER
This is the value that defines a specific set of
name/address
data within the table. It could be a value such as an
account or
application number (or any other numeric value.)
-
CUST_NAME
This is the name you enter on the address entry screen,
which is carried back to the payment entry screen
automatically.
-
ADDRESS1
This is the first line of the address you enter on the
address entry screen.
-
ADDRESS2
This is the second line of the address you enter on the
address entry screen.
-
CITY
This is the city portion of the address you enter on the
address entry screen.
This value can be preset to a default
value you specify via theADDRESS-DEFAULT-CITY
setting in the
MiscParms
table.
-
STATE
This is the state portion of the address you enter on the
address entry screen.
This value can be preset to a default
value you specify via theADDRESS-DEFAULT-STATE
setting in the
MiscParms
table.
-
ZIP
This is the zip-code portion of the address you enter on the
address entry screen.
This value can be preset to a default
value you specify via theADDRESS-DEFAULT-ZIP
setting in the
MiscParms
table.
-
PHONE_NUMBER
This is the phone_number you enter on the
address entry screen.
This value can be preset to a default
value you specify via the
ADDRESS-DEFAULT-PHONE
setting in the
MiscParms
table.
Usually this would be an area code.
-
F01 through F30
These fields store the text you entered on the address
entry screen (below the address portion at the top of the
screen.) The values are stored as plain text in the
address capture table.