tableFinanceofficial - Microsoftderived - from the source, no model textobsolete - pending

Table 10550 "BACS Ledger Entry" (GB)

GB country layer · Microsoft.Bank.Ledger

Across versionsobsolete pending since 28.0

  1. BC23-28not present
  2. BC29-30present

GB country layer · Microsoft.Bank.Ledger · BC29-30 · source at ea08af5e · facts from BC29

An object of the GB localization, not part of W1.

Properties

Property Value
Caption BACS Ledger Entry
DataClassification CustomerContent
ObsoleteState Pending
ObsoleteTag 28.0
ObsoleteReason No longer required

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 Entry No. Integer —
2 Bank Account No. Code[20] — TableRelation Vendor Bank Account
3 Bank Account Ledger Entry No. Integer — TableRelation Bank Account Ledger Entry
4 Posting Date Date —
5 Document Type Option — OptionCaption: ,Payment,Invoice,Credit Memo,Finance Charge Memo,Reminder
6 Document No. Code[20] —
7 Description Text[50] —
8 Amount Decimal —
9 BACS Date Date —
13 Entry Status Option — OptionCaption: ,Exported,Voided,Posted,Financially Voided
14 Original Entry Status Option — OptionCaption: ,Exported,Voided,Posted,Financially Voided
15 Bal. Account Type enum “Gen. Journal Account Type” — enum Enum 81 “Gen. Journal Account Type”
16 Bal. Account No. Code[20] — TableRelation if (“Bal. Account Type” = const(“G/L Account”)) “G/L Account” else if (“Bal. Account Type” = const(Customer)) Customer else if (“Bal. Account Type” = const(Vendor)) Vendor else if (“Bal. Account Type” = const(“Bank Account”)) “Bank Account” else if (“Bal. Account Type” = const(“Fixed Asset”)) “Fixed…
17 Open Boolean —
18 Statement Status Option — OptionCaption: Open,Bank Acc. Entry Applied,Check Entry Applied,Closed,BACS Entry Applied
19 Statement No. Code[20] — TableRelation “Bank Acc. Reconciliation Line”.“Statement No.” where(“Bank Account No.” = field(“Bank Account No.”))
20 Statement Line No. Integer — TableRelation “Bank Acc. Reconciliation Line”.“Statement Line No.” where(“Bank Account No.” = field(“Bank Account No.”), “Statement No.” = field(“Statement No.”))
21 User ID Code[50] — DataClassification EndUserIdentifiableInformation
22 External Document No. Code[35] —
23 Account Type enum “Gen. Journal Account Type” — enum Enum 81 “Gen. Journal Account Type”
24 Account No. Code[20] — TableRelation if (“Account Type” = const(“G/L Account”)) “G/L Account” else if (“Account Type” = const(Customer)) Customer else if (“Account Type” = const(Vendor)) Vendor else if (“Account Type” = const(“Bank Account”)) “Bank Account” else if (“Account Type” = const(“Fixed Asset”)) “Fixed Asset”
35 Journal Batch Name Code[10] —
36 Register No. Integer — TableRelation BACS Register

Keys

  • Key1: Entry No. (clustered)
  • Key2: Bank Account No., Entry Status
  • Key3: Bank Account Ledger Entry No., Entry Status
  • Key4: Bank Account No., BACS Date
  • Key5: Bank Account No., Open
  • Key6: Document No., Posting Date
  • Key7: Entry Status
  • Key8: Bal. Account No., Entry Status
  • Key9: Bal. Account No., Open
  • Key10: Bal. Account No., BACS Date
  • Key11: Register No., Bal. Account No., Statement Status, Statement No.

Procedures

  • GetCurrencyCodeFromBank(): Code[10]

Deprecations

  • object: Pending 28.0 (#if not CLEANSCHEMA31), “No longer required”

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: "BACS Ledger Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

A GB country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.

Evidence 1 sources