Table 7000007 "Closed Bill Group" (ES)

ES country layer · Microsoft.Sales.Receivables · BC29-30 · source at ea08af5e · facts from BC29

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

Properties

Property	Value
Caption	Closed Bill Group
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]	—
6	Dealing Type	Enum “Cartera Dealing Type”	—	enum Cartera Dealing Type; not editable
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(Receivable))); 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(Receivable))); not editable
18	Status Filter	Enum “Cartera Document Status”	—	FlowFilter; enum Cartera Document Status; not editable
20	Closing Date	Date	—
29	Collection Expenses Amt.	Decimal	—
30	Discount Expenses Amt.	Decimal	—
31	Discount Interests Amt.	Decimal	—
32	Rejection 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(Receivable))); not editable
37	Risked Factoring Exp. Amt.	Decimal	—
38	Unrisked Factoring Exp. Amt.	Decimal	—
39	Factoring	Option	—	OptionCaption: ,Unrisked,Risked; not editable
1200	Partner Type	Option	—	OptionCaption: ,Company,Person

Keys

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

Procedures

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 Bill Group"), 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.