Table 7000022 "Closed Payment Order" (ES)

ES country layer · Microsoft.Purchases.Payables · BC29-30 · source at ea08af5e · facts from BC29

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

Properties

Property	Value
Caption	Closed Payment Order
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
2	No.	Code[20]	—
3	Bank Account No.	Code[20]	—	TableRelation Bank Account
4	Bank Account Name	Text[100]	—	FlowField: lookup(“Bank Account”.Name where(“No.” = field(“Bank Account No.”))); not editable
5	Posting Description	Text[100]	—
8	Reason Code	Code[10]	—	TableRelation Reason Code
9	No. Printed	Integer	—
10	Posting Date	Date	—
11	Comment	Boolean	—	FlowField: exist(“BG/PO Comment Line” where(“BG/PO No.” = field(“No.”), Type = filter(Payable))); not editable
14	Global Dimension 1 Filter	Code[20]	—	TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(1)); FlowFilter
15	Global Dimension 2 Filter	Code[20]	—	TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(2)); FlowFilter
16	Amount Grouped	Decimal	—	FlowField: sum(“Closed Cartera Doc.”.“Amount for Collection” where(“Bill Gr./Pmt. Order No.” = field(“No.”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), Status = field(“Status Filter”), Type = const(Payable))); not editable
18	Status Filter	Enum “Cartera Document Status”	—	FlowFilter; enum Cartera Document Status; not editable
20	Closing Date	Date	—
29	Payment Order Expenses Amt.	Decimal	—
33	Currency Code	Code[10]	—	TableRelation Currency; not editable
35	Amount Grouped (LCY)	Decimal	—	FlowField: sum(“Closed Cartera Doc.”.“Amt. for Collection (LCY)” where(“Bill Gr./Pmt. Order No.” = field(“No.”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), Status = field(“Status Filter”), Type = const(Payable))); not editable

Keys

Key1: No. (clustered)
Key2: Bank Account No., Posting Date

Procedures

PrintRecords(ShowRequestForm: Boolean)
Caption(): Text

Triggers

OnDelete

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

A ES country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.