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

Table 11744 "Cash Desk CZP" (CZ)

CZ country layer · Microsoft.Finance.CashDesk

Open in Claude11744-cz.mdSource on GitHub

Across versions

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

CZ country layer · Microsoft.Finance.CashDesk · captioned “Cash Desk” · BC29-30 · source at ea08af5e · facts from BC29

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

Properties

Property Value
Caption Cash Desk
DataClassification CustomerContent
Permissions tabledata “Bank Account Ledger Entry” = r

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 No. Code[20] —
2 Name Text[100] —
3 Search Name Code[100] —
4 Name 2 Text[50] —
5 Address Text[100] —
6 Address 2 Text[50] —
7 City Text[30] — TableRelation if (“Country/Region Code” = const(‘’)) “Post Code”.City else if (“Country/Region Code” = filter(<> ‘’)) “Post Code”.City where(“Country/Region Code” = field(“Country/Region Code”))
8 Contact Text[100] —
9 Phone No. Text[30] —
16 Global Dimension 1 Code Code[20] — TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(1))
17 Global Dimension 2 Code Code[20] — TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(2))
21 Bank Acc. Posting Group Code[20] — TableRelation Bank Account Posting Group
22 Currency Code Code[10] — TableRelation Currency
24 Language Code Code[10] — TableRelation Language
35 Country/Region Code Code[10] — TableRelation Country/Region
41 Post Code Code[20] — TableRelation if (“Country/Region Code” = const(‘’)) “Post Code” else if (“Country/Region Code” = filter(<> ‘’)) “Post Code” where(“Country/Region Code” = field(“Country/Region Code”))
42 County Text[30] —
45 E-Mail Text[80] Email caption
48 Comment Boolean — FlowField: Exist(“Comment Line” where(“Table Name” = const(“Cash Desk CZP”), “No.” = field(“No.”))); not editable
49 Blocked Boolean —
55 Date Filter Date — FlowFilter
56 Global Dimension 1 Filter Code[20] — TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(1)); FlowFilter
57 Global Dimension 2 Filter Code[20] — TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(2)); FlowFilter
58 Balance Decimal — FlowField: Sum(“Bank Account Ledger Entry”.Amount where(“Bank Account No.” = field(“No.”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”))); not editable
59 Balance (LCY) Decimal — FlowField: Sum(“Bank Account Ledger Entry”.“Amount (LCY)” where(“Bank Account No.” = field(“No.”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”))); not editable
60 Net Change Decimal — FlowField: Sum(“Bank Account Ledger Entry”.Amount where(“Bank Account No.” = field(“No.”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Posting Date” = field(“Date Filter”))); not editable
61 Net Change (LCY) Decimal — FlowField: Sum(“Bank Account Ledger Entry”.“Amount (LCY)” where(“Bank Account No.” = field(“No.”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Posting Date” = field(“Date Filter”))); not editable
95 Balance at Date Decimal — FlowField: Sum(“Bank Account Ledger Entry”.Amount where(“Bank Account No.” = field(“No.”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Posting Date” = field(UPPERLIMIT(“Date Filter”)))); not editable
96 Balance at Date (LCY) Decimal — FlowField: Sum(“Bank Account Ledger Entry”.“Amount (LCY)” where(“Bank Account No.” = field(“No.”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Posting Date” = field(UPPERLIMIT(“Date Filter”)))); not editable
97 Debit Amount Decimal — FlowField: Sum(“Bank Account Ledger Entry”.“Debit Amount” where(“Bank Account No.” = field(“No.”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Posting Date” = field(“Date Filter”))); not editable
98 Credit Amount Decimal — FlowField: Sum(“Bank Account Ledger Entry”.“Credit Amount” where(“Bank Account No.” = field(“No.”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Posting Date” = field(“Date Filter”))); not editable
99 Debit Amount (LCY) Decimal — FlowField: Sum(“Bank Account Ledger Entry”.“Debit Amount (LCY)” where(“Bank Account No.” = field(“No.”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Posting Date” = field(“Date Filter”))); not editable
100 Credit Amount (LCY) Decimal — FlowField: Sum(“Bank Account Ledger Entry”.“Credit Amount (LCY)” where(“Bank Account No.” = field(“No.”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Posting Date” = field(“Date Filter”))); not editable
107 No. Series Code[20] — TableRelation No. Series; not editable
120 Min. Balance Decimal —
121 Min. Balance Checking Option — OptionCaption: No Checking,Warning,Blocking
122 Max. Balance Decimal —
123 Max. Balance Checking Option — OptionCaption: No Checking,Warning,Blocking
232 Allow VAT Difference Boolean —
233 Payed To/By Checking Option — OptionCaption: No Checking,Warning,Blocking
234 Reason Code Code[10] — TableRelation Reason Code
236 Amounts Including VAT Boolean —
237 Confirm Inserting of Document Boolean —
238 Debit Rounding Account Code[20] — TableRelation “G/L Account”.“No.” where(“Account Type” = const(Posting))
239 Credit Rounding Account Code[20] — TableRelation “G/L Account”.“No.” where(“Account Type” = const(Posting))
240 Rounding Method Code Code[10] — TableRelation Rounding Method
241 Responsibility ID (Release) Code[50] — TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation
242 Responsibility ID (Post) Code[50] — TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation
243 Responsibility Center Code[10] — TableRelation Responsibility Center
260 Amount Rounding Precision Decimal —
265 Cash Document Receipt Nos. Code[20] — TableRelation No. Series
266 Cash Document Withdrawal Nos. Code[20] — TableRelation No. Series
267 Cash Receipt Limit Decimal —
268 Cash Withdrawal Limit Decimal —
269 Exclude from Exch. Rate Adj. Boolean —
270 Cashier No. Code[20] — TableRelation Employee

Keys

  • Key1: No. (clustered)
  • Key2: Search Name
  • Key3: Bank Acc. Posting Group
  • Key4: Currency Code

Events published

  • OnBeforeValidateShortcutDimCode(var CashDeskCZP: Record "Cash Desk CZP"; var xCashDeskCZP: Record "Cash Desk CZP"; FieldNumber: Integer; var ShortcutDimCode: Code[20]) (integration)
  • OnAfterValidateShortcutDimCode(var CashDeskCZP: Record "Cash Desk CZP"; var xCashDeskCZP: Record "Cash Desk CZP"; FieldNumber: Integer; var ShortcutDimCode: Code[20]) (integration)
  • OnAfterIsEETCashRegister(CashDeskCZP: Record "Cash Desk CZP"; var EETCashRegister: Boolean) (integration)

Procedures

  • AssistEdit(OldCashDeskCZP: Record "Cash Desk CZP"): Boolean
  • ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])
  • DisplayMap()
  • TestZeroBalance()
  • CalcBalance(): Decimal
  • CalcOpenedWithdrawals(): Decimal
  • CalcOpenedReceipts(): Decimal
  • CalcPostedWithdrawals(): Decimal
  • CalcPostedReceipts(): Decimal
  • IsInLocalCurrency(): Boolean
  • CheckCurrExchRateExist(Date: Date)
  • IsEETCashRegister(): Boolean

Plus 3 local procedures.

Triggers

OnDelete, OnInsert, OnModify, OnRename

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

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