Table 1242 "Positive Pay Footer"

Base Application · Microsoft.Bank.PositivePay · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Positive Pay Footer
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	Data Exch. Entry No.	Integer	—	TableRelation Table 1220 “Data Exch.” (“Data Exch.”.“Entry No.”)
2	Data Exch. Detail Entry No.	Integer	—	TableRelation Table 1241 “Positive Pay Detail” (“Positive Pay Detail”.“Data Exch. Entry No.”)
3	Account Number	Text[30]	—
4	Check Count Δ BC24	Integer	—	FlowField: count(“Positive Pay Detail” where(“Void Check Indicator” = const(‘’), “Data Exch. Entry No.” = field(“Data Exch. Detail Entry No.”)))
5	Check Total Δ BC24 Δ BC28	Decimal	—	FlowField: sum(“Positive Pay Detail”.Amount where(“Void Check Indicator” = const(‘’), “Data Exch. Entry No.” = field(“Data Exch. Detail Entry No.”)))
6	Void Count Δ BC24	Integer	—	FlowField: count(“Positive Pay Detail” where(“Void Check Indicator” = const(‘V’), “Data Exch. Entry No.” = field(“Data Exch. Detail Entry No.”)))
7	Void Total Δ BC24 Δ BC28	Decimal	—	FlowField: sum(“Positive Pay Detail”.Amount where(“Void Check Indicator” = const(‘V’), “Data Exch. Entry No.” = field(“Data Exch. Detail Entry No.”)))
8	Total Count Δ BC24	Integer	—	FlowField: count(“Positive Pay Detail” where(“Data Exch. Entry No.” = field(“Data Exch. Detail Entry No.”)))
9	Grand Total Δ BC24 Δ BC28	Decimal	—	FlowField: sum(“Positive Pay Detail”.Amount where(“Data Exch. Entry No.” = field(“Data Exch. Detail Entry No.”)))

Keys

Key1: Data Exch. Entry No. (clustered)

Relations

Data Exch. Entry No.: TableRelation Table 1220 “Data Exch.”
Check Count: CalcFormula Table 1241 “Positive Pay Detail”
Check Total: CalcFormula Table 1241 “Positive Pay Detail”
Grand Total: CalcFormula Table 1241 “Positive Pay Detail”
Total Count: CalcFormula Table 1241 “Positive Pay Detail”
Void Count: CalcFormula Table 1241 “Positive Pay Detail”
Void Total: CalcFormula Table 1241 “Positive Pay Detail”
Data Exch. Detail Entry No.: TableRelation Table 1241 “Positive Pay Detail”

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