Expense Type Id- a unique identifier of an expense type- Max size 20 characters.

Applies to expense with a format type F (meals per diem) and P (max per diem) only and if pdFulldayenabled field is enabled. A preferred label assigned to the 'full day out of office' option. Max size 500 characters

Full-Text Search Lookup typically returns matches of name or ID.

The default out of office value for single day travel or for the days of travel in between the 1st and last day. This would indicate what portion of the day an employee was travelling. Typically this would be se to value '1'-Full Day, but other potential values are '2'-3/4 day, '3' - 1/2 day, '4' - 1/4 Day. Applies to expense with a format type F (meals per diem) and P (max per diem) only

Online Help text- Max size 500 Characters

Tax Code ID if a tax field is assigned to an expense, otherwise can be left blank. Max 10 characters. A valid tax code ID must exist in the XpTaxCode table

Label for meals provided field. e.g. 'Meals Provided' 'Meals Taken'. Max size 500 characters

Mileage Unit rate type. Values: 'M' Rate based on monthly number of units or miles. 'N' Rate not based on number of units or miles, 'Y' Rate based on yearly number of units or miles. Year starts in January, 'Y2' Rate based on yearly number of units or miles - Year start in February, 'Y3' Rate based on yearly number of units or miles - Year start in March, 'Y4' Rate based on yearly number of units or miles - Year start in April.

Applies to expense with a format type F (meals per diem) and P (max per diem) only and if pdHalfdayenabled field is enabled. A preferred label assigned to the half day out of office' option. Max size 500 characters

Compute Tax Optional. Values: '0'-No, '1' - Yes

For format type F (meals per diem) and P (max per diem) an indicator if a ''3/4 Day' out of office option is enabled. Values 'Y'-enabled, 'N'-disabled

Enable attachment option. Values: 'Y'- Yes, 'N'-No

Sets a default icon for the expense type. Default 'other.svg'. Max size 100 characters

Tip field. Values: 'Y'- enabled, 'N' - disabled

Enable Meals Provided fields for additional per diem deductions by meal category, Applies to expense types where Format type is F (Meals Per Diem) or P(Max Per Diem). Values: 'Y' -enabled, 'N'-Disabled.

Restrict Access - Values Y - Restricted and only available by assignment and N - Not restricted.

Daily Group - Not Currently Used

Applies to expense with a format type F (meals per diem) and P (max per diem) only and if pdThreefourthdayenabled field is enabled. A preferred label assigned to the '3/4 day out of office' option. Max size 500 characters

Enables expense entry over a range of dates. Values: 'Y' - Yes Date Range, 'N'-No, 'U'- Yes Number of Units

Expense Type Name - Max size is 2000 Characters

Template Expense Type. Max 3 characters

Expense Unit Options. Applies to expense with format type M(Mileage/fixed rate). Values: '1'- Default Unit Amount equal 1 Only, 'N' - Disabled, 'Y'- Enable Unit Entry, 'M' - Mileage/KM based on user. Default value 'Y'

Expense format type- determines how an expense appears to the end user. Values: 'O'-Other, 'A'- Advance, 'M'-Mileage, 'F'-Meals Per Diem Only, 'L'-Lodging Per Diem Only, 'P'- Max Per Diem

Indicates if alcohol should be tracked in a separate amount field. Values: '0'- Disabled, '1'- Enabled and reimbursable, '2'-Enabled but not reimbursable. This field is only applicable if ExpenseTypeFlag is 'U'- Lunch, 'D'-Dinner, 'B'- Breakfast or 'F'-Meals

Require itemization of an expense. Values 'Y'- Optional (typically the default), 'N' - Disabled, 'R'-Required

Enable Odometer Tracking. Applies to expense types where format type is 'M'-Mileage. Values 'Y'- yes enable, 'N'-No do not enable

A flag to indicate if per diem allowance to be tracked based on the number of hours traveled. Values: 'Y'- Yes, 'N'-No

For format type F (meals per diem) and P (max per diem) an indicator if a ''Half Day' out of office option is enabled. Values 'Y'-enabled, 'N'-disabled

Allows modifying expense type name on the end user interface. Values: 'Y'-Yes, 'N' - No

Description - Max size 255 Characters

Attendee Group Enable. Values 'Y' - enabled, 'N' - disabled.

Tracking attendee amount field. Values: 'N'-Disabled, 'Y'-Optional, 'R'- Required. Only applies to expenses where RequireAttendee field is enabled.

Reimbursable flag of an expense. Values: 'Y'-Always Reimbursable, 'N'-Never Reimbursable, 'P'- reimbursable flag depend on the payment type

Enable City field for travel location tracking. Values 'Y'-enabled, 'N'- Disable

Enabled Commute tracking. Values 'Y''-Yes, 'N'-No. Only applicable if FormatType is 'M'-Mileage

For format type F (meals per diem) and P (max per diem) an indicator if a 'Full Day' out of office option is enabled. Values 'Y'-enabled, 'N'-disabled

Active Status. Use Y for Active and N for Inactive.

Display 'Personal' field for tracking business vs personal charges on an expense. Values 'Y'-Yes only for credit card payment type, 'N'-No, 'R' - Always On

The default out of office value for the first day of travel. This would indicate what portion of the day an employee was travelling on the first day of travel. Typically this would be se to value '2'-3/4 day, ' but other potential values are '1'-Full Day,, '3' - 1/2 day, '4' - 1/4 Day. Applies to expense with a format type F (meals per diem) and P (max per diem) only

The default out of office value for the last day of travel. This would indicate what portion of the day an employee was travelling on the last day of travel. Typically this would be se to value '2'-3/4 day, ' but other potential values are '1'-Full Day,, '3' - 1/2 day, '4' - 1/4 Day. Applies to expense with a format type F (meals per diem) and P (max per diem) only

Expense Type flag to identify if it is general, meals or lodging expense. Selection of this flag will drive the visibility of the other fields on the expense setup. Also necessary for per diem rules setup. Values: 'O'- General, 'L'-Lodging, 'U'- Lunch, 'D'-Dinner, 'B'- Breakfast or 'F'-Meals

For format type F (meals per diem) and P (max per diem) an indicator if a ''1/4 Day' out of office option is enabled. Values 'Y'-enabled, 'N'-disabled

Unit Labe, free text l. Typically to define the unit label for mileage/fixed rate expense type e.g. "Miles", "Kilometers". Max size 100 characters

Tax 2 Code ID if a tax 2 field is assigned to an expense, otherwise can be left blank. Max 10 characters. A valid tax code ID must exist in the XpTaxCode table

Display currency flag. Values 'Y'-Yes, 'N'-No

Require Attendee. Values: 'N' - Disabled, 'Y' - Optional, 'A' - Required All Fields, 'P' - Required Attendee and Company, 'R' - Required Attendee Only, 'T' - Required Attendee, Title and Company

Require notes for an expense. Values: 'Y'- Yes, 'N'-No

Expense Type Group ID - Max size 20 Characters. Must have a valid value in the XpExpenseTypeGrp table

Applies to expense with a format type F (meals per diem) and P (max per diem) only and if pdOnefourthdayenabled field is enabled. A preferred label assigned to the '1/4 day out of office' option. Max size 500 characters