You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need a sql query to get the expense details for the mentioned columns

edited Nov 22, 2024 1:22PM in Expenses 1 comment

Summary:

I am new to this expenses module , I need a sql query for the below columns

Content (please ensure you mask any confidential information):

Need a sql query to get the details of below columns. please provide the sql query or tables in 24C expenses module.

Expense_Accommodation_Number_of Days
Expense_Accommodation_Location
Expense_Mileage_Number_of_Miles
Expense_Mileage_Starting_Location
Expense_Mileage_Destination
Expense_Toll_Location
Expense_Parking_Type
Expense_Vehicle_Type
Expense_Gift_Type
Expense_Medical_Type
Expense_Training_Nature
Expense_Training_VAT
Expense_Publication_Type
Expense_Professional_Body
Expense_Office_Supplies
Expense_Mobile_Telecom_Type

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!