To view all data fields as a list press F4. This list is in Sequence # which is an attribute that can be manually changed to ensure that the list is maintained in whatever order that works best for your company. Some System Administrators like to keep all of the System Protected Fields at the top of the list in order as they first appeared and alphabetize their own custom data field ID's with all the A's, D's, H's, N's, T's & Z's in strict order. Others have grouped various field ID's by department use or common value. The can of course elect to continue with the Sequence # assigned by ActionWare. Each new field will appear at the end of the listing, etc.
We encourage the System Administrator, though, to consider manually resequencing the file so that when you do reports using an external program such as IBM's Query for the iSeries, finding the field ID you want is simple and straight forward. It is also helpful to have the field ID's in some order (other than random) when creating or maintaining Shell or template letters using our Microsoft Word Interface (MSWI).
The following sample list starts with many of the System Protected Fields (but not all) and continues with custom designed Fields following. It is only a sample list and may not look like yours. Please note that in this sample list the System Administrator physically changed the Sequence #'s so that they were in order by type of Field.
. . . . . . . . . . . . . . . . .Database Definition Module |
List order: Sequence # |
|||||||||||
Type options,
press Enter. |
Position to Seq#: _____ |
|||||||||||
O |
Seq# |
Field |
Layout 1 |
Layout 2 |
Layout 3 |
lgth |
a/n |
dec |
edit |
u/l |
entry |
protect code |
_ |
10 |
PID |
Primary ID |
Primary ID |
Primary ID |
10 |
A |
0 |
U |
Y |
K |
|
_ |
20 |
SID |
Secondary |
Secondary |
Secondary |
10 |
A |
0 |
U |
Y |
K |
|
_ |
30 |
RCL |
Tertiary I |
Tertiary I |
Tertiary I |
15 |
A |
0 |
U |
Y |
K |
|
_ |
40 |
COM |
Company |
Company |
Company |
30 |
T |
0 |
L |
Y |
L |
|
_ |
50 |
CON |
Contact |
Contact |
Contact |
30 |
A |
0 |
L |
Y |
L |
|
_ |
60 |
AD1 |
Address |
Address |
Address |
30 |
A |
0 |
L |
Y |
L |
|
_ |
70 |
AD2 |
Address |
Address |
Address |
30 |
A |
0 |
L |
Y |
L |
|
_ |
80 |
CIT |
City |
City |
City |
20 |
N |
0 |
L |
Y |
L |
|
_ |
90 |
TL1 |
Phone |
Phone |
Phone |
20 |
N |
0 |
L |
Y |
L |
|
_ |
100 |
TL2 |
Phone |
Phone |
Phone |
20 |
N |
0 |
L |
Y |
L |
|
_ |
110 |
TL3 |
|
|
|
20 |
N |
0 |
L |
Y |
||
_ |
120 |
TL4 |
Phone |
Phone |
Phone |
20 |
A |
0 |
L |
Y |
||
_ |
130 |
OWN |
Owner |
Owner |
Owner |
10 |
A |
0 |
L |
Y |
S |
|
_ |
140 |
ZIP |
Zip Code |
Zip Code |
Zip Code |
10 |
A |
0 |
U |
Y |
L |
|
_ |
150 |
RC2 |
Tertiary # |
Tertiary # |
Tertiary # |
8 |
A |
0 |
U |
Y |
||
_ |
160 |
A01 |
Industry T |
*BLANK |
Notes: |
22 |
A |
0 |
L |
Y |
||
_ |
170 |
A02 |
Type* |
*BLANK |
CPUSerial# |
10 |
A |
0 |
L |
Y |
||
_ |
180 |
A03 |
Claim # |
*BLANK |
*BLANK |
10 |
A |
0 |
L |
N |
||
_ |
190 |
A04 |
DELETE? |
DELETE? |
DELETE? |
1 |
A |
0 |
U |
Y |
||
_ |
200 |
D01 |
*BLANK |
Closing Date |
Service Da |
10 |
D |
0 |
L |
Y |
||
_ |
210 |
D02 |
W-9 Rcvd |
*BLANK |
Birthdate |
10 |
D |
0 |
L |
Y |
||
_ |
220 |
D03 |
Renewal |
Final QA |
*BLANK |
10 |
D |
0 |
L |
Y |
||
_ |
230 |
D04 |
Customer |
*BLANK |
Prospect |
10 |
D |
0 |
L |
Y |
||
_ |
240 |
H01 |
LEAD INFO |
PROJECTS: |
INTERES |
0 |
A |
0 |
U |
N |
||
_ |
250 |
H02 |
*BLANK |
WORK COD |
*BLANK |
0 |
A |
0 |
U |
N |
||
_ |
260 |
H03 |
BANK INFO |
SALES CYC |
*BLANK |
0 |
A |
0 |
U |
N |
||
_ |
270 |
H04 |
COMMENTS |
*BLANK |
COMMENTS |
0 |
A |
0 |
U |
N |
||
_ |
280 |
H05 |
OPPORTUN |
*BLANK |
*BLANK |
0 |
A |
0 |
U |
N |
||
_ |
290 |
H06 |
OPEN |
OPEN |
*BLANK |
0 |
A |
0 |
L |
N |
||
_ |
300 |
H07 |
*BLANK |
*BLANK |
OPEN |
0 |
A |
0 |
L |
N |
||
_ |
310 |
H08 |
*BLANK |
*BLANK |
OTHER |
0 |
A |
0 |
U |
N |
||
_ |
320 |
H09 |
*BLANK |
OPEN |
*BLANK |
0 |
A |
0 |
U |
N |
||
_ |
330 |
H10 |
STATUS |
OPEN |
STATUS |
0 |
A |
0 |
L |
N |
||
_ |
340 |
N01 |
*BLANK |
Discount |
*BLANK |
7 |
N |
0 |
J |
$ |
N |
|
_ |
350 |
N02 |
Referral Fee |
*BLANK |
*BLANK |
9 |
N |
0 |
J |
$ |
Y |
|
_ |
360 |
N03 |
% To Close |
*BLANK |
Satisfacti |
3 |
N |
0 |
3 |
Y |
||
_ |
370 |
N04 |
Total Deal |
Service |
Amount |
7 |
N |
0 |
J |
$ |
Y |
Alternate Method of Changing a Field ID:
You need to be very careful when you change existing fields because of the data that might be in the field and or how the field might be used on another Data Layout. If the change is to shorten the length of field you should check the data first by using an external query product to view the data. If you shorten the field will it eliminate any of the data in any of the Data Layouts? Perhaps it would be better to create a new field rather than shorten an existing field. Another consideration is Copy Clear and Propagate attribute values. Is the field being used on another Data Layout where those properties might be important? If so you should not change the existing field.
To change a field, position to that field ID key a 2 next to it and press enter. Change desired attributes carefully as explained and press enter to save.
Alternate Method of Adding a Field ID:
Another method of creating a new Field ID is to copy an existing Field ID by positioning to the Field ID to be copied, key a 3 next to it and press enter. The Add a New Field screen appears with the following prompts:
Add a New Field |
Key data, press Enter |
Sequence#: 2170 ................. Field Name: ___ ............. Type: __ (A N D T Z) |
Field being copied: ... ___ .......label.;.label.;.label.; |
The default Field being copied will be the Field ID where you keyed 3 for Copy. The labels displayed will be for field being copied as well. The default for the Type is also the field being copied. To add a new field you need to key a new Field ID (Field name) and press enter and the new field will be added. The attributes will be identical to that of the copied field. To change the attributes you will need to change the new field. See related topic: