Data File Display and Maintenance

Enter the path and file name for the file you want to examine. The first two characters of the path name represent the module code; the final three characters represent the company code.

Select a character to separate the fields that comprise multi-column keys in Business Framework tables. The character is used to identify the individual fields that make up the key, and to account for any null values in the fields when searching for records.

For example, the vendor number field is defined as 10 characters. If your vendor number consists of less than 10 characters, the remaining characters are defined as nulls. If a key column separator is selected, the nulls are accounted for when performing a search if, in the Key/Search field, you add the key column separator at the end of the vendor number.

If the key is comprised of a single column, enter the separator as the last character in the Key/Search field. Use the key column separator to navigate to a specific record for the key entered, or when filtering records using the Key Scan Filter feature.

Select this check box to filter search results in the Key Scan window based on the key entered in the Key/Search field.

Select this check box to display the data file with field names next to the field numbers. Clear this check box to display the data file in RAW format.

Select from the secondary keys available. Records will sort in the file being displayed according to the key selected.

The following examples use the AP_OpenInvoice.m4t table:

To view records beginning with 02 in this window, type 02 in this field, and then press ENTER. The first record beginning with 02 will be the current record; you can use the navigation buttons to view additional records.
To view all records beginning with 02 in the Key Scan window, type 02 in this field, and then click the Key Scan button. All records will appear in the Key Scan window, and the first record beginning with 02 will be highlighted.
To filter records so that only those beginning with 02 appear in the Key Scan window, select a character in the Key Column Separator field (this example uses a colon), and select the Key Scan Filter check box. Next, type 02: in this field, and click the Key Scan button. Only those records beginning with 02 will appear in the Key Scan window.
To search for key 02PACTEL.2010043000010 in the AP_OpenInvoice.m4t table using a colon (:) as the key column separator, type 02:PACTEL:20100430:0001043090 in this field, and then click the Key Scan button.

The following example shows the structure of a key in the AP_OpenInvoice.m4t table.

Key = 02PACTEL.2010043000010

APDivsionNo = 02
VendorNo = PACTEL
InvoiceDate = 20100430
InvoiceNo = 0001043090

The dot in the key indicates that the VendorNo field contains nulls.