Concur

SAP Concur expense-management integration with pre-defined Expenses, Reports, Receipts, Trips, Users, Projects, Itemizations, Per Diem Days, and Finance Team Assignments tables. Mirrors company expense data into local tables. Requires a configured Concur API connection (the Concur Two-Legged or Concur Three-Legged API provider; see those for settings).

• API category: Concur
• Schema: managed by the service provider.

Configuration parameters

This provider takes no configuration parameters.

Tables provisioned

This service provisions the following local tables when imported. Columns marked (key) form the primary key.

• Users

  • Email : text (key)
  • Name : text
  • Concur ID : text
  • Admin : true/false

• Expenses

  • Nectry ID : text (key)
  • User Email : Users
  • Transaction Date : time
  • Amount : money
  • Currency : text
  • Payment Type : text
  • Expense Type : text
  • Report ID : Reports (optional)
  • City : text
  • State : text
  • Comments : text
  • Personal Expense : true/false
  • Project : text (optional)
  • Vendor Name : text
  • Last Updated : time
  • Status : text
  • Receipt File : file(image/jpeg,image/png,image/webp,image/gif,application/pdf) (optional)
  • From Concur : true/false
  • Rejection Comments : text (optional)
  • Billing Date : time (optional)

• Itemizations

  • Nectry ID : text (key)
  • Expense ID : Expenses
  • Project : text (optional)
  • Amount : money
  • Comments : text
  • Personal Expense : true/false
  • Last Modified : time (optional)

• Reports

  • Nectry ID : text (key)
  • Report Name : text
  • Create Date : time
  • Submit Date : time (optional)
  • Employee Email : Users (optional)
  • Finance Owner : Users (optional)

• Trips

  • Nectry ID : text (key)
  • User Email : Users
  • Multi-Project : true/false
  • Project : text (optional)
  • Start Date : time
  • End Date : time
  • City : text
  • State : text
  • Comments : text
  • Per Diem Lodging : integer (optional)
  • Per Diem Meals : integer (optional)
  • Status : text
  • Rejection Comments : text (optional)
  • Receipt File : file(image/jpeg,image/png,image/webp,image/gif,application/pdf) (optional)

• Projects

  • Name : text (key)
  • Status : text
  • Type : text

• Receipts

  • Concur ID : text (key)
  • User Email : Users (optional)
  • Receipt File : file(image/jpeg,image/png,image/webp,image/gif,application/pdf) (optional)

• Finance Team Assignments

  • Reviewer Email : Users
  • Employee Email : Users

• perDiemDays

  • Trip Nectry ID : Trips
  • Day Number : integer
  • Project : text (optional)
  • Breakfast : true/false
  • Lunch : true/false
  • Dinner : true/false
  • PTO : true/false