Table 6841 "Spend Request Detail"
Base Application · Microsoft.Finance.SpendRequest
Across versions
- BC23-28not present
- BC29added
- BC30unchanged
Neighbourhood 11 connected objects and pages
Base Application · Microsoft.Finance.SpendRequest · captioned “Spend Request Document Detail” · BC29-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 7137 “Travel Request Subform” (1 Learn page).
Properties
| Property | Value |
|---|---|
| Caption | Spend Request Document Detail |
| DataClassification | CustomerContent |
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 | Spend Request No. | Code[20] | — | TableRelation Table 6840 “Spend Request” (Spend Request) |
| 3 | Line No. | Integer | Specifies the line number of the spend request detail. | |
| 4 | Description | Text[100] | Specifies a description of the spend request detail. | |
| 5 | Currency Code | Code[10] | Specifies the currency used for estimation. The currency amount will automatically be converted into Total Expected Amount (LCY) | TableRelation Table 4 “Currency” |
| 6 | Expected Amount | Decimal | Specifies the expected amount of the spend request detail. | |
| 7 | Currency Exchange Rate | Decimal | Specifies the most recent exchange rate for the specified currency (1 = pari). | not editable |
| 8 | Expected Amount (LCY) | Decimal | Specifies the expected amount of the spend request detail. Automatically calculated from the Amount field. | not editable |
| 10 | G/L Account No. | Code[20] | The G/L Account that the expenses will be posted to. | TableRelation Table 15 “G/L Account” (G/L Account) |
Keys
- Key1: Spend Request No., Line No. (clustered)
- Key2: G/L Account No.
Procedures
ChangeCurrency(xCurrencyCode: Code[10])(internal)UpdateCurrencyExchangeRate()(internal)
Plus 3 local procedures.
Triggers
OnInsert, OnDelete
Relations
- G/L Account No.: TableRelation Table 15 “G/L Account”
- Currency Code: TableRelation Table 4 “Currency”
- Spend Request No.: TableRelation Table 6840 “Spend Request”
Referenced by
2 fields in 2 objects relate to this table (TableRelation or CalcFormula).
- Table 6840 “Spend Request”: Total Line Amount (LCY)
- Table 6845 “Spend Request To G/L Link”: Detail Description
Pages and codeunits on this table
- Page 6842 “Spend Request Subform” (source table)
- Page 7102 “Spend Request Details API” (source table)
- Page 7135 “Travel Request Details API” (source table)
- Page 7137 “Travel Request Subform” (source table)
Extended by
Recent changes
- 2026-08-12 #10049 Removed the ReplicateData=false property (main, BC30, fix)
- 2026-08-10 #9391 [Master] - Slice 616928: [Expense Management] [App part] Expense Managements Travel Requisitions 💸 (main, BC30, feature)
- 2026-07-31 #8959 Deliverable 638799: Spend Requests in Base App (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: "Spend Request Detail"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.