Table 9046 "Account Payable Cue"

Base Application · Microsoft.Finance.RoleCenters · BC27-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Account Payable Cue
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	Primary Key	Code[10]	—
20	Purchase This Month	Decimal	Specifies the total amount of purchase invoices for the current month.	FlowField: - sum(“Vendor Ledger Entry”.“Purchase (LCY)” where(“Document Type” = filter(Invoice \| “Credit Memo”), “Posting Date” = field(“Posting Date Filter”), Open = const(true))); not editable
21	Posting Date Filter	Date	—	FlowFilter
22	Overdue Purchase Documents	Integer	Specifies the number of purchase invoices where your payment is late.	FlowField: count(“Vendor Ledger Entry” where(“Document Type” = filter(Invoice \| “Credit Memo”), “Due Date” = field(“Overdue Date Filter”), Open = const(true))); not editable
23	Overdue Date Filter	Date	—	FlowFilter
24	POs Pending Approval	Integer	Specifies the number of purchase orders that are pending approval.	FlowField: count(“Purchase Header” where(“Document Type” = const(Order), Status = filter(“Pending Approval”))); not editable
25	Approved Purchase Orders	Integer	Specifies the number of purchase orders that are approved.	FlowField: count(“Purchase Header” where(“Document Type” = const(Order), Status = filter(Released \| “Pending Prepayment”))); not editable
26	Purchase Quotes	Integer	Specifies the number of purchase quotes.	FlowField: count(“Purchase Header” where(“Document Type” = const(Quote), Status = filter(Open))); not editable
27	Purchase Orders	Integer	Specifies the number of purchase orders.	FlowField: count(“Purchase Header” where(“Document Type” = const(Order), Status = filter(Open))); not editable
28	Ongoing Purchase Invoices	Integer	Specifies the number of ongoing purchase invoices.	FlowField: count(“Purchase Header” where(“Document Type” = filter(Invoice))); not editable
29	Purch. Invoices Due Next Week	Integer	Specifies the number of purchase invoices that are due next week.	FlowField: count(“Vendor Ledger Entry” where(“Document Type” = filter(Invoice \| “Credit Memo”), “Due Date” = field(“Due Next Week Filter”), Open = const(true))); not editable
30	Due Next Week Filter	Date	—	FlowFilter
31	Posted Purch. Inv. This Month	Integer	Specifies the number of posted purchase invoices for the current month.	FlowField: count(“Purch. Inv. Header” where(“Posting Date” = field(“Posting Date Filter”))); not editable
32	Posted Purch. Cr. Memo TM	Integer	Specifies the number of posted purchase credit memos for the current month.	FlowField: count(“Purch. Cr. Memo Hdr.” where(“Posting Date” = field(“Posting Date Filter”))); not editable
33	Purchase Documents Due Today	Integer	Specifies the number of purchase invoices that are due today.	FlowField: count(“Vendor Ledger Entry” where(“Document Type” = filter(Invoice \| “Credit Memo”), “Due Date” = field(“Overdue Date Filter”), Open = const(true))); not editable
34	Purch. Documents Due Next Week	Integer	Specifies the number of purchase invoices that are due next week.	FlowField: count(“Vendor Ledger Entry” where(“Document Type” = filter(Invoice \| “Credit Memo”), “Due Date” = field(“Due Next Week Filter”), Open = const(true))); not editable
35	Purchase Discounts Next Week	Integer	Specifies the number of purchase invoices that are due next week and have a payment discount.	FlowField: count(“Vendor Ledger Entry” where(“Document Type” = filter(Invoice \| “Credit Memo”), “Pmt. Discount Date” = field(“Due Next Week Filter”), Open = const(true))); not editable
36	Unprocessed Payments	Integer	Specifies the number of unprocessed payments.	FlowField: count(“Bank Acc. Reconciliation” where(“Statement Type” = const(“Payment Application”))); not editable
37	Outstanding Vendor Invoices	Integer	Specifies the number of invoices from your vendors that have not been paid yet.	FlowField: count(“Vendor Ledger Entry” where(“Document Type” = filter(Invoice), “Remaining Amount” = filter(< 0), “Applies-to ID” = filter(‘’))); not editable
110	Last Date/Time Modified	DateTime	—

Keys

PK: Primary Key (clustered)

Procedures

GetAmountFormat(): Text (internal)
GetDefaultWorkDate(): Date (internal)

Relations

Posted Purch. Inv. This Month: CalcFormula Table 122 “Purch. Inv. Header”
Posted Purch. Cr. Memo TM: CalcFormula Table 124 “Purch. Cr. Memo Hdr.”
Outstanding Vendor Invoices: CalcFormula Table 25 “Vendor Ledger Entry”
Overdue Purchase Documents: CalcFormula Table 25 “Vendor Ledger Entry”
Purch. Documents Due Next Week: CalcFormula Table 25 “Vendor Ledger Entry”
Purch. Invoices Due Next Week: CalcFormula Table 25 “Vendor Ledger Entry”
Purchase Discounts Next Week: CalcFormula Table 25 “Vendor Ledger Entry”
Purchase Documents Due Today: CalcFormula Table 25 “Vendor Ledger Entry”
Purchase This Month: CalcFormula Table 25 “Vendor Ledger Entry”
Unprocessed Payments: CalcFormula Table 273 “Bank Acc. Reconciliation”
Approved Purchase Orders: CalcFormula Table 38 “Purchase Header”
Ongoing Purchase Invoices: CalcFormula Table 38 “Purchase Header”
POs Pending Approval: CalcFormula Table 38 “Purchase Header”
Purchase Orders: CalcFormula Table 38 “Purchase Header”
Purchase Quotes: CalcFormula Table 38 “Purchase Header”

Pages and codeunits on this table

Page 9048 “Acc. Payable Activities” (source table)

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

Codeunit 10 “Type Helper” (1 call: GetAmountFormat → GetAmountFormatLCYWithUserLocale)
Codeunit 40 “LogInManagement” (1 call: GetDefaultWorkDate → GetDefaultWorkDate)

Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. 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: "Account Payable Cue"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.