--- id: object/table/6845 type: object title: Table 6845 "Spend Request To G/L Link" summary: Table 6845 "Spend Request To G/L Link" in Base Application (Microsoft.Finance.SpendRequest). 9 fields. Introduced in BC29, still in BC30. tier: official language: en tags: - table - base application versions: introduced: "29" last_changed: null deprecated: null review: state: derived by: null at: null flags: [] generated: at: "2026-10-11T00:31:51.816Z" pipeline: 0.2.0 prompts: {} input_hash: 6015d577b277906b90bbad9c850edce1507297c91daaf5865d089e661de2fa8f evidence: - kind: code url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Finance/SpendRequest/SpendRequestToGLLink.Table.al title: src/Layers/W1/BaseApp/Finance/SpendRequest/SpendRequestToGLLink.Table.al (releases/29.x) date: null commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220 t: null quote: null links: learn: [] objects: [] features: [] topics: [] localizations: [] videos: [] posts: [] guidelines: [] changes: - change/bcapps/10049 - change/bcapps/9887 - change/bcapps/8959 object_type: table object_id: 6845 name: Spend Request To G/L Link namespace: Microsoft.Finance.SpendRequest app: Base Application extends: null first_version: "29" last_version: "30" present_in: - "29" - "30" changed_in: [] source_major: "29" obsolete: null countries: [] ms_search_form_ids: [] counts: fields: 9 procedures: 0 events: 0 subscribers: 0 relations: out: 7 referenced_by: 1 pages: 2 extended_by: 0 event_subscribers: 2 calls: 0 called_by: 0 implements: 0 --- # Table 6845 "Spend Request To G/L Link" > Table 6845 "Spend Request To G/L Link" in Base Application (Microsoft.Finance.SpendRequest). 9 fields. Introduced in BC29, still in BC30. Base Application · Microsoft.Finance.SpendRequest · BC29-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Finance/SpendRequest/SpendRequestToGLLink.Table.al) · 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"](../table/6840.md) (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"](../table/17.md) (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"](../table/15.md) (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"](../codeunit/20.md) OnInsertSpendRequestToGLLink - OnAfterModifyEvent: [Codeunit 20 "Posting Preview Event Handler"](../codeunit/20.md) OnModifySpendRequestToGLLink ## Relations - drill-down page [Page 6843 "Spend Request To G/L Link"](../page/6843.md) - lookup page [Page 6843 "Spend Request To G/L Link"](../page/6843.md) - G/L Account No.: TableRelation [Table 15 "G/L Account"](../table/15.md) - Posting Description: CalcFormula [Table 17 "G/L Entry"](../table/17.md) - G/L Entry No.: TableRelation [Table 17 "G/L Entry"](../table/17.md) - Spend Request No.: TableRelation [Table 6840 "Spend Request"](../table/6840.md) - Detail Description: CalcFormula [Table 6841 "Spend Request Detail"](../table/6841.md) ## Referenced by 1 fields in 1 objects relate to this table (TableRelation or CalcFormula). - [Table 6840 "Spend Request"](../table/6840.md): Total Spent Amount (LCY) ## Pages and codeunits on this table - [Page 6843 "Spend Request To G/L Link"](../page/6843.md) (source table) - [Page 6844 "Spend Req. To G/L Link Preview"](../page/6844.md) (source table) ## Recent changes - 2026-08-12 [#10049 Removed the ReplicateData=false property](../../changes/bcapps/10049.md) (main, BC30, fix) - 2026-08-03 [#9887 Exclude spend request G/L link from replication](../../changes/bcapps/9887.md) (main, BC30, fix) - 2026-07-31 [#8959 Deliverable 638799: Spend Requests in Base App](../../changes/bcapps/8959.md) (main, BC30, feature, added) ## Across versions - Present in: BC29-30 - Changed (declaration) in: none Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10). ## 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.