Table 687 "Payment Practice Header"
PaymentPractices · Microsoft.Finance.Analysis
Across versions
- BC23-28not present
- BC29-30present
Neighbourhood 5 connected objects and pages
PaymentPractices · Microsoft.Finance.Analysis · BC29-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 687 “Payment Practice Card” (1 Learn page), Page 689 “Payment Practice List” (1).
Properties
| Property | Value |
|---|---|
| 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 | No. | Integer | Specifies the number of the payment practice header. via Page 687 “Payment Practice Card” | AutoIncrement |
| 2 | Starting Date | Date | Specifies the starting date of the payment practice. via Page 687 “Payment Practice Card” | |
| 3 | Ending Date | Date | Specifies the ending date of the payment practice. via Page 687 “Payment Practice Card” | |
| 4 | Aggregation Type | Enum “Paym. Prac. Aggregation Type” | Specifies the aggregation type of the payment practice. via Page 687 “Payment Practice Card” | enum Enum 685 “Paym. Prac. Aggregation Type” |
| 5 | Header Type | Enum “Paym. Prac. Header Type” | Specifies the source for entries in the payment practice. via Page 687 “Payment Practice Card” | enum Enum 686 “Paym. Prac. Header Type” |
| 6 | Average Agreed Payment Period | Integer | Specifies the average agreed payment period. via Page 687 “Payment Practice Card” | |
| 7 | Average Actual Payment Period | Integer | Specifies the average actual payment period. via Page 687 “Payment Practice Card” | |
| 8 | Pct Paid on Time | Decimal | Specifies the percentage paid on time. via Page 687 “Payment Practice Card” | |
| 9 | Generated On | DateTime | Specifies the date and time when the payment practice was generated. via Page 687 “Payment Practice Card” | |
| 10 | Generated By | Code[20] | Specifies the user who generated the payment practice. via Page 687 “Payment Practice Card” | |
| 11 | Lines Exist | Boolean | Specifies whether the payment practice has lines. via Page 687 “Payment Practice Card” | FlowField: exist(“Payment Practice Line” where(“Header No.” = field(“No.”))) |
| 12 | Modified Manually | Boolean | Specifies whether the payment practice was modified manually. via Page 687 “Payment Practice Card” | |
| 15 | Reporting Scheme | Enum “Paym. Prac. Reporting Scheme” | Specifies which reporting scheme is used, such as Standard, Dispute & Retention, or Small Business. Controls which fields and calculations apply. | enum Enum 680 “Paym. Prac. Reporting Scheme”; not editable |
| 20 | Total Number of Payments | Integer | Specifies the total number of payments made during the reporting period. | not editable |
| 21 | Total Amount of Payments | Decimal | Specifies the total value of payments made during the reporting period. | not editable |
| 22 | Total Amt. of Overdue Payments | Decimal | Specifies the total value of payments not made within the agreed payment terms. | not editable |
| 23 | Pct Overdue Due to Dispute | Decimal | Specifies the percentage of payments not made within agreed terms that are due to disputes. | not editable |
| 24 | Mode Payment Time | Integer | Specifies the most frequently occurring number of days taken to pay invoices during the reporting period. | |
| 25 | Mode Payment Time Min. | Integer | Specifies the lowest mode payment time, in days, found across all vendors in the reporting period. The value is calculated by determining the mode payment time for each vendor, which is the most frequently occurring number of days taken to pay invoices for that vendor during the reporting period, an… | |
| 26 | Mode Payment Time Max. | Integer | Specifies the highest mode payment time, in days, found across all vendors in the reporting period. The value is calculated by determining the mode payment time for each vendor, which is the most frequently occurring number of days taken to pay invoices for that vendor during the reporting period, a… | |
| 27 | Median Payment Time | Decimal | Specifies the median number of days taken to pay invoices during the reporting period. | |
| 28 | 80th Percentile Payment Time | Integer | Specifies the number of days within which 80 percent of invoices were paid during the reporting period. | |
| 29 | 95th Percentile Payment Time | Integer | Specifies the number of days within which 95 percent of invoices were paid during the reporting period. | |
| 30 | Pct Peppol Enabled | Decimal | Specifies the percentage of invoices that were PEPPOL enabled. An invoice is considered PEPPOL enabled if the vendor has a GLN. | |
| 31 | Pct Small Business Payments | Decimal | Specifies the value of payments made to small business vendors as a percentage of total payments in the reporting period, including partial payments. A vendor is classified as a small business based on the company size code on the vendor record. |
Keys
- Key1: No. (clustered)
Procedures
UpdateNo(): IntegerClearHeader()
Plus 4 local procedures.
Triggers
OnInsert, OnDelete
Relations
- Lines Exist: CalcFormula Table 688 “Payment Practice Line”
Referenced by
1 fields in 1 objects relate to this table (TableRelation or CalcFormula).
- Table 688 “Payment Practice Line”: Header No.
Pages and codeunits on this table
- Page 687 “Payment Practice Card” (source table)
- Page 689 “Payment Practice List” (source table)
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: "Payment Practice Header"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.