Table 6939 "Mileage Rate Setup"
ExpenseAgent · Microsoft.ExpenseAgent
Across versions
- BC23-28not present
- BC29-30present
Neighbourhood 6 connected objects and pages
ExpenseAgent · Microsoft.ExpenseAgent · BC29-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 7128 “Mileage Rate Setup” (2 Learn pages).
Properties
| Property | Value |
|---|---|
| Caption | Mileage Rate Setup |
| Access | Internal |
| DataClassification | CustomerContent |
| LookupPageId | Mileage Rate Setup |
| DrillDownPageId | Mileage Rate Setup |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Code | Code[20] | Specifies the unique code that identifies the mileage rate. | NotBlank |
| 2 | Currency Code | Code[10] | Specifies the currency the mileage rate is expressed in. Leave blank to use the local currency. | TableRelation Table 4 “Currency” |
| 3 | Rate | Decimal | Specifies the reimbursement amount per unit of distance for this mileage rate. | |
| 4 | Starting Date | Date | Specifies the first date the mileage rate is effective. | NotBlank |
| 5 | Ending Date | Date | Specifies the last date the mileage rate is effective. Leave blank for an open-ended rate. | |
| 6 | Vehicle Type | Code[20] | Specifies the vehicle type this mileage rate applies to. Leave blank to define a generic rate that is used when no rate matches the vehicle type on the expense. | TableRelation Table 7108 “Expense Vehicle Type” (Expense Vehicle Type) |
Keys
- PK: Code (clustered)
- Effective: Vehicle Type, Currency Code, Starting Date
Procedures
FindEffectiveRate(TransactionDate: Date; CurrencyCode: Code[10]; VehicleType: Code[20]): Boolean
Plus 5 local procedures.
Triggers
OnInsert, OnModify
Relations
- drill-down page Page 7128 “Mileage Rate Setup”
- lookup page Page 7128 “Mileage Rate Setup”
- Currency Code: TableRelation Table 4 “Currency”
- Vehicle Type: TableRelation Table 7108 “Expense Vehicle Type”
Pages and codeunits on this table
- Page 7128 “Mileage Rate Setup” (source table)
- Page 7131 “Mileage Rate Setup API” (source table)
Recent changes
- 2026-08-27 #10561 Mileage Rate Setup (main, BC30, feature, added)
Ask your agent
Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Mileage Rate Setup"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.