Table 9054 Finance Cue

Base Application, Microsoft.Finance.RoleCenters

Source AL, 306 lines

src/Layers/W1/BaseApp/Finance/RoleCenters/FinanceCue.Table.allines 21 to 36 of 306, Copyright (c) Microsoft Corporation. MIT

table 9054 "Finance Cue"{    Caption = 'Finance Cue';    DataClassification = CustomerContent;    fields    {        field(1; "Primary Key"; Code[10])        {            AllowInCustomizations = Never;            Caption = 'Primary Key';        }        field(2; "Overdue Sales Documents"; Integer)        {            CalcFormula = count("Cust. Ledger Entry" where("Document Type" = filter(Invoice | "Credit Memo"),                                                            "Due Date" = field("Overdue Date Filter"),

All 306 lines

Fields 34 in 29

1Primary KeyCode[10]17-29
2Overdue Sales DocumentsInteger17-29
3Purchase Documents Due TodayInteger17-29
4POs Pending ApprovalInteger17-29
5SOs Pending ApprovalInteger17-29
6Approved Sales OrdersInteger17-29
7Approved Purchase OrdersInteger17-29
8Vendors - Payment on HoldInteger17-29
9Purchase Return OrdersInteger17-29

All 37 fields in 17-29

Trigger events 10

OnBeforeInsertEvent(var Rec: Record "Finance Cue"; RunTrigger: Boolean)
OnAfterInsertEvent(var Rec: Record "Finance Cue"; RunTrigger: Boolean)
OnBeforeModifyEvent(var Rec: Record "Finance Cue"; var xRec: Record "Finance Cue"; RunTrigger: Boolean)
OnAfterModifyEvent(var Rec: Record "Finance Cue"; var xRec: Record "Finance Cue"; RunTrigger: Boolean)
OnBeforeDeleteEvent(var Rec: Record "Finance Cue"; RunTrigger: Boolean)
OnAfterDeleteEvent(var Rec: Record "Finance Cue"; RunTrigger: Boolean)
OnBeforeRenameEvent(var Rec: Record "Finance Cue"; var xRec: Record "Finance Cue"; RunTrigger: Boolean)
OnAfterRenameEvent(var Rec: Record "Finance Cue"; var xRec: Record "Finance Cue"; RunTrigger: Boolean)
OnBeforeValidateEvent(var Rec: Record "Finance Cue"; var xRec: Record "Finance Cue"; CurrFieldNo: Integer)
per field, ElementName: field name
OnAfterValidateEvent(var Rec: Record "Finance Cue"; var xRec: Record "Finance Cue"; CurrFieldNo: Integer)
per field, ElementName: field name

Changes 9 in 24

List17181920212223242526272829
Fields39
field(34; "Total Overdue (LCY)"; Decimal)new in 24
added
field(35; "Total Outstanding (LCY)"; Decimal)new in 24
added
field(36; "Non Issued Reminders"; Integer)new in 24
added
field(37; "Date Filter"; Date)new in 24
added
field(38; "AR Accounts Balance"; Decimal)new in 24
added
field(39; "Active Reminders"; Integer)new in 24
added

All 12 changes in 17-29