BC Observatoryunofficial, made by waldo
tableFinanceofficial - Microsoftderived - from the source, no model text

Table 11400 "CBG Statement" (NL)

NL country layer · Microsoft.Bank.Statement

Open in Claude11400-nl.mdSource on GitHub

Across versions

  1. BC23-27not present
  2. BC28-30present

NL country layer · Microsoft.Bank.Statement · BC28-30 · source at ea08af5e · facts from BC29

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

Properties

Property Value
Caption CBG Statement
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 Journal Template Name Code[10] — TableRelation “Gen. Journal Template”.Name; NotBlank
2 No. Integer —
3 Type Option — OptionCaption: Bank/Giro,Cash
4 Account Type Option — OptionCaption: G/L Account,Bank Account
5 Account No. Code[20] — TableRelation if (“Account Type” = const(“G/L Account”)) “G/L Account”.“No.” else if (“Account Type” = const(“Bank Account”)) “Bank Account”.“No.”; NotBlank
6 Document No. Code[20] — NotBlank
10 Date Date — NotBlank
11 Currency Code[10] — TableRelation Currency
12 Opening Balance Decimal —
13 Closing Balance Decimal —
14 No. Series Code[20] —
15 Net Change Debit Decimal — FlowField: sum(“CBG Statement Line”.“Debit Incl. VAT” where(“Journal Template Name” = field(“Journal Template Name”), “No.” = field(“No.”))); not editable
16 Net Change Credit Decimal — FlowField: sum(“CBG Statement Line”.“Credit Incl. VAT” where(“Journal Template Name” = field(“Journal Template Name”), “No.” = field(“No.”))); not editable
17 Shortcut Dimension 1 Code Code[20] — TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(1))
18 Shortcut Dimension 2 Code Code[20] — TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(2))
480 Dimension Set ID Integer — TableRelation Dimension Set Entry; not editable

Keys

  • Key1: Journal Template Name, No. (clustered)
  • Key2: Type

Events published

  • OnAfterInitRecord(var CBGStatement: Record "CBG Statement"; var Rec: Record "CBG Statement") (integration)
  • OnAfterInsertGenJnlLine(var CBGStatement: Record "CBG Statement"; var CBGStatementLine: Record "CBG Statement Line"; var GenJournalLine: Record "Gen. Journal Line") (integration)
  • OnAfterMakeGenJournalLine(CBGStatement: Record "CBG Statement"; var GenJournalLine: Record "Gen. Journal Line"; ForEachDocumentNo: Code[20]; ForEachDate: Date; TotAmountVV: Decimal; TotAmountLV: Decimal) (integration)
  • OnAfterProcessStatementASGenJournal(var CBGStatement: Record "CBG Statement") (integration)
  • OnBeforeCheckBalance(var CBGStatement: Record "CBG Statement"; var IsHandled: Boolean) (integration)
  • OnBeforeProcessStatementASGenJournal(var CBGStatement: Record "CBG Statement") (integration)
  • OnBeforeMakeGenJournalLine(var GenJnlLine: Record "Gen. Journal Line"; ForEachDocumentNo: Code[20]; ForEachDate: Date; TotAmountVV: Decimal; TotAmountLV: Decimal) (integration)
  • OnProcessStatementASGenJournalOnAfterGenJnlLineInsert(var GenJnlLine: Record "Gen. Journal Line"; CBGStatementLine: Record "CBG Statement Line"; CBGStatement: Record "CBG Statement") (integration)

Procedures

  • InitRecord(UseTemplate: Code[10])
  • CLAccountNo(): Text[80]
  • GetName(): Text[100]
  • AssistEdit(OldCBGStatement: Record "CBG Statement"): Boolean
  • LineFilter(var CBGStatementLine: Record "CBG Statement Line")
  • MakeGenJournalLine(var GenJnlLine: Record "Gen. Journal Line"; ForEachDocumentNo: Code[20]; ForEachDate: Date; TotAmountVV: Decimal; TotAmountLV: Decimal)
  • CheckBalance()
  • ProcessStatementASGenJournal()
  • CreateDim(DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])
  • UpdateCBGStatementLine(ChangedFieldName: Text[100]; AskQuestion: Boolean)
  • CBGStatementLinesExist(): Boolean
  • ShowDimensions()

Plus 2 local procedures.

Triggers

OnDelete, OnInsert

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

A NL 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