This page allows you to enter destinations comprising of City, County, State/Province and Country. The Destination (DSTN) table is used to predefine different locations so that the system may infer related data (for example, per diem rates) to the Travel transactions. This table comes preloaded with over 29,000 records. You may need to analyze these records to determine if additional records must be added to this table for your site.
When adding records to this table, there are a few recommended guidelines:
The Country value in the reference file (the United States Geological Survey’s Populated Places list) may not match the value in Advantage Financial’s Country (CTRY) table (for example, USA versus US). Before the records are loaded to DSTN, the Country values must be fixed to match what exists in Advantage Financial. The same applies to the State/Province codes and County codes.
The field values in the DSTN record must be consistent with the field values in the Travel Per Diem (TRPDM) table in order for the system to find a correct match during Travel transaction processing.
The Destination Name field value should be a concatenation of “City, State/Province, Country” (in that order and comma-separated). This is needed in order to support type-ahead functionality within the Advantage Employee Self Service (ESS) application. The purpose of type-ahead input fields is to improve the user experience. When a user starts entering a value in specific fields, the system can return a list of values that begin with the same entered values. Within the Travel transactions created via ESS specifically, the type-ahead feature is found in the Destination Name field.