Table 7000005 "Bill Group" (ES)
ES country layer · Microsoft.Sales.Receivables
Across versions
- BC23-28not present
- BC29-30present
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 | 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 |
| 7 | Amount | Decimal | — | FlowField: sum(“Cartera Doc.”.“Remaining Amount” 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”), “Category Code” = field(“Category Filter”), “Due Date” = field(“Due Date Filter”), Typ…; 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 |
| 12 | Category Filter | Code[10] | — | TableRelation Category Code; FlowFilter |
| 13 | Due Date Filter | Date | — | FlowFilter |
| 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 | No. Series | Code[20] | — | TableRelation No. Series; not editable |
| 33 | Currency Code | Code[10] | — | TableRelation Currency |
| 34 | Amount (LCY) | Decimal | — | FlowField: sum(“Cartera Doc.”.“Remaining Amt. (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”), “Category Code” = field(“Category Filter”), “Due Date” = field(“Due Date Filter”),…; not editable |
| 39 | Factoring | Option | — | OptionCaption: ,Unrisked,Risked |
| 1200 | Partner Type | Enum “Partner Type” | — | enum Enum 134 “Partner Type” |
Keys
- Key1: No. (clustered)
- Key2: Bank Account No.
Procedures
AssistEdit(OldBillGr: Record "Bill Group"): BooleanResetPrinted()PrintRecords(ShowRequestForm: Boolean)Caption(): TextExportToFile()RunFileExportCodeunit(CodeunitID: Integer; DirectDebitCollectionNo: Integer; var DirectDebitCollectionEntry: Record "Direct Debit Collection Entry")DeleteDirectDebitCollection(DirectDebitCollectionNo: Integer)SelectDirectDebitFormatSilently(NewDirectDebitFormat: Option)
Plus 5 local procedures.
Triggers
OnDelete, OnInsert
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: "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.