Table 6902 "Expense Itemization"
ExpenseAgent · Microsoft.ExpenseAgent
Across versions
- BC23-28not present
- BC29-30present
Neighbourhood 5 connected objects and pages
ExpenseAgent · Microsoft.ExpenseAgent · BC29-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 6975 “Expense Itemizations” (1 Learn page).
Properties
| Property | Value |
|---|---|
| Caption | Expense Itemization |
| Access | Internal |
| DataClassification | CustomerContent |
| LookupPageId | Expense Itemizations |
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 | Expense No. | Code[20] | — | TableRelation Expense.“No.” |
| 2 | Line No. | Integer | — | |
| 4 | Expense Category Code | Code[20] | — | TableRelation Table 6921 “Expense Category” (“Expense Category”.Code where(Inactive = const(false))) |
| 5 | Expense Subcategory Code | Code[20] | Specifies the expense subcategory for this itemization. via Page 6975 “Expense Itemizations” | TableRelation Table 6929 “Expense Subcategory” (“Expense SubCategory”.Code where(“Expense Category Code” = field(“Expense Category Code”), Inactive = const(false))) |
| 6 | Description | Text[100] | Specifies a short description of the itemized charge. via Page 6975 “Expense Itemizations” | |
| 7 | Start Date | Date | Specifies the start date for this itemized expense. via Page 6975 “Expense Itemizations” | |
| 8 | Quantity | Decimal | Specifies the number of units for this itemization. via Page 6975 “Expense Itemizations” | |
| 9 | Daily Rate | Decimal | Specifies the daily rate used to calculate the amount. via Page 6975 “Expense Itemizations” | |
| 10 | Amount | Decimal | Specifies the calculated amount for this itemization. via Page 6975 “Expense Itemizations” | not editable |
| 11 | Refundable | Boolean | — | not editable |
Keys
- PK: Expense No., Line No. (clustered)
Procedures
2 local procedures, no public ones.
Triggers
OnInsert, OnDelete
Relations
- lookup page Page 6975 “Expense Itemizations”
- Expense Category Code: TableRelation Table 6921 “Expense Category”
- Expense Subcategory Code: TableRelation Table 6929 “Expense Subcategory”
Pages and codeunits on this table
- Page 6935 “Expense Itemizations API” (source table)
- Page 6975 “Expense Itemizations” (source table)
Recent changes
- 2026-08-04 #9859 [Master] - Move Expense Agent (Preview) app into BCApps (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: "Expense Itemization"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.