Table 6845 "Spend Request To G/L Link"

Base Application · Microsoft.Finance.SpendRequest · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Spend Request To G/L Link
DataClassification	CustomerContent
LookupPageId	Spend Request To G/L Link
DrillDownPageId	Spend Request To G/L Link

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]	Specifies the spend request no. that this link points to.	TableRelation Table 6840 “Spend Request” (Spend Request)
2	Spend Request Detail No.	Integer	Specifies the spend request line no. that this link points to.
3	G/L Entry No.	Integer	Specifies the spend g/l entry no. that this link points to.	TableRelation Table 17 “G/L Entry” (G/L Entry)
4	G/L Account No.	Code[20]	The G/L Account that the expenses were posted to.	TableRelation Table 15 “G/L Account” (G/L Account)
5	Amount	Decimal	Specifies the amount of the g/l entry that this record is linked to.
6	Posting Date	Date	Specifies the posting date of the g/l entry that this record is linked to.
7	Document No.	Code[20]	Specifies the document no. from the g/l entry that this record is linked to.	not editable
10	Detail Description	Text[100]	Specifies the description from the spend request detail.	FlowField: lookup(“Spend Request Detail”.Description where(“Spend Request No.” = field(“Spend Request No.”), “Line No.” = field(“Spend Request Detail No.”))); not editable
12	Posting Description	Text[100]	Specifies the posting description from the g/l entry that this record is linked to.	FlowField: lookup(“G/L Entry”.Description where(“Entry No.” = field(“G/L Entry No.”))); not editable

Keys

Key1: Spend Request No., Spend Request Detail No., G/L Entry No. (clustered)
Key2: G/L Account No., Posting Date
Key3: Document No., Posting Date

Trigger event subscribers

OnAfterInsertEvent: Codeunit 20 “Posting Preview Event Handler” OnInsertSpendRequestToGLLink
OnAfterModifyEvent: Codeunit 20 “Posting Preview Event Handler” OnModifySpendRequestToGLLink

Relations

drill-down page Page 6843 “Spend Request To G/L Link”
lookup page Page 6843 “Spend Request To G/L Link”
G/L Account No.: TableRelation Table 15 “G/L Account”
Posting Description: CalcFormula Table 17 “G/L Entry”
G/L Entry No.: TableRelation Table 17 “G/L Entry”
Spend Request No.: TableRelation Table 6840 “Spend Request”
Detail Description: CalcFormula Table 6841 “Spend Request Detail”

Referenced by

1 fields in 1 objects relate to this table (TableRelation or CalcFormula).

Table 6840 “Spend Request”: Total Spent Amount (LCY)

Pages and codeunits on this table

Page 6843 “Spend Request To G/L Link” (source table)
Page 6844 “Spend Req. To G/L Link Preview” (source table)

Recent changes

2026-08-12 #10049 Removed the ReplicateData=false property (main, BC30, fix)
2026-08-03 #9887 Exclude spend request G/L link from replication (main, BC30, fix)
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 To G/L Link"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.