Optional Fields for Reporting Purposes
Depending on the expense category attributes that you set up, some of these fields might appear on the Additional tab on the Edit Expense Detail Information form or on the forms used to apply the credit card expense to an expense report; otherwise, the fields reside in the database only for reporting purposes.
Alias |
Field Name |
Type |
Length |
Definition |
---|---|---|---|---|
BUSPURP |
Business Purpose |
Alpha |
40 |
Text describing the purpose for the expense report. |
VENDCODE |
Vendor Code |
Alpha |
8 |
A user-defined code that identifies the preferred supplier and corresponds directly to the expense category.
|
VENDNAME |
Vendor Name |
Alpha |
35 |
The name of the vendor from which the expense was incurred. |
VSTREET |
Street |
Alpha |
40 |
The street in the vendor's address where the expense was incurred. |
VCITY |
City |
Alpha |
30 |
The city in the vendor's address where the expense was incurred. |
VSTATE |
State |
Alpha |
2 |
The state in the vendor's address where the expense was incurred. |
VZIPCODE |
Zip |
Alpha |
12 |
The zip code (postal code) in the vendor's address where the expense was incurred. |
VCOUNTRY |
Country |
Alpha |
30 |
The country in the vendor's address where the expense was incurred. |
TICKNUMB |
Ticket Number |
Alpha |
15 |
A number assigned to the airline ticket for tracking purposes. |
CLASSERV |
Class of Service |
Alpha |
15 |
The type of service that corresponds to the mode of travel. For example, First Class, Business Class, Coach. |
DESTIN1 |
First Destination |
Alpha |
20 |
The location of the first stop in a series of stops, or the From location of a car rental agency. |
DESTIN2 |
Second Destination |
Alpha |
20 |
The location of the second stop in a series of stops, or the To location of a car rental agency. |
DESTIN3 |
Third Destination |
Alpha |
20 |
The location of the third stop in a series of stops. |
FMDATE |
From Date |
Date |
6 |
The beginning date in a date range that might be used to describe the period of time during which a car was rented or a room was occupied. |
TODATE |
To Date |
Date |
6 |
The ending date in a date range that might be used to describe the period of time during which a car was rented or a room occupied. |
NUMBDAYS |
Number of Days |
Number |
3 |
The number of days or nights that were expended during a stay at a hotel or for which a car was rented. |
SBL |
Subledger |
Alpha |
8 |
The subledger to which the expense should be charged if the field is used. |
SBLT |
Subledger Type |
Alpha |
1 |
A code that identifies the type of subledger. The value that you specify must exist in UDC 00/ST. |
TEXT1 |
Text Field 001 |
Alpha |
40 |
Fields that the system updates, in conjunction with the expense category, when you set up expense category attributes that use fields from the data dictionary. |
TEXT2 |
Text Field 002 |
Alpha |
40 |
Blank |
TEXT3 |
Text Field 003 |
Alpha |
40 |
Blank |
NUMERIC1 |
Numeric 01 |
Number |
15 |
Blank |
NUMERIC2 |
Numeric 02 |
Number |
15 |
Blank |
NUMERIC3 |
Numeric 03 |
Number |
15 |
Blank |
DATE1 |
Date Field 1 |
Date |
6 |
Blank |
DATE2 |
Date Field 2 |
Date |
6 |
Blank |
DATE3 |
Date Field 3 |
Date |
6 |
Blank |
TELNUMB |
Telephone Number Called |
Alpha |
20 |
The telephone number for which charges were expensed. |
UNITS |
Units |
Number |
6 |
The quantity of an item, such as the number of miles. |
RATE1 |
Rate |
Number |
15 |
The cost per unit, such as the nightly cost for a hotel room or the amount per mile that could be reimbursed. |