tableFinanceofficial - Microsoftderived - from the source, no model text

Table 687 "Payment Practice Header"

PaymentPractices · Microsoft.Finance.Analysis

Across versions

  1. BC23-28not present
  2. BC29-30present

Neighbourhood 5 connected objects and pages

Table 688 "Payment Practice Line" (relates to)Payment Practice LinePage 687 "Payment Practice Card" (pages and codeunits on it)Payment Practice CardPage 689 "Payment Practice List" (pages and codeunits on it)Payment Practice ListTable 688 "Payment Practice Line" (referenced by)Payment Practice LinePayment practices report (Learn pages)Payment practices report

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

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(): Integer
  • ClearHeader()

Plus 4 local procedures.

Triggers

OnInsert, OnDelete

Relations

Referenced by

1 fields in 1 objects relate to this table (TableRelation or CalcFormula).

Pages and codeunits on this 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.

Evidence 1 sources