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. If the expense category is AIR, the value that you enter must exist in UDC 09E/PA. If the expense category is HTL, the value that you enter must exist in UDC 09E/PH. If the expense category is CAR, the value that you enter must exist in UDC 09E/PC. If you have set up a preferred supplier for an additional expense category, the value that you enter must exist in UDC 09E/PS.
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.