Table 8003 "Price Update Template"
Subscription Billing · Microsoft.SubscriptionBilling
Across versions
- BC23-28not present
- BC29-30present
Neighbourhood 2 connected objects and pages
Subscription Billing · Microsoft.SubscriptionBilling · BC29-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Price Update Template |
| DataClassification | CustomerContent |
| LookupPageId | Price Update Templates |
| DrillDownPageId | Price Update Templates |
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 | Code | Code[20] | Specifies the unique code of the Price Update Template. via Page 8026 “Price Update Templates” | NotBlank |
| 2 | Description | Text[80] | Specifies the description of the template. via Page 8026 “Price Update Templates” | |
| 3 | Partner | Enum “Service Partner” | Specifies whether the template applies to customer or Vendor Subscription Contracts. via Page 8026 “Price Update Templates” | enum Enum 8053 “Service Partner” |
| 4 | Subscription Contract Filter | Blob | — | |
| 5 | Subscription Line Filter | Blob | — | |
| 6 | Subscription Filter | Blob | — | |
| 7 | Price Update Method | Enum “Price Update Method” | Specifies the method to update prices. The method determines which field will be updated by which value. via Page 8026 “Price Update Templates” | enum Enum 8003 “Price Update Method” |
| 8 | Update Value % | Decimal | Specifies the value, the price or Calculation Base % will be changed by. via Page 8026 “Price Update Templates” | |
| 9 | Perform Update on Formula | DateFormula | Specifies the optional formula to set Perform Price on Formula. via Page 8026 “Price Update Templates” | |
| 10 | InclContrLinesUpToDateFormula | DateFormula | Specifies the optional formula to set the Include Contract lines up to date. via Page 8026 “Price Update Templates” | |
| 11 | Price Binding Period | DateFormula | Specifies the period the price will not be changed after the price update. It sets a new “Next Price Update” in the contract line after the price update has been performed. via Page 8026 “Price Update Templates” | |
| 12 | Group by | Enum “Contract Billing Grouping” | Specifies the option for grouping contract billing lines. via Page 8026 “Price Update Templates” | enum Enum 8059 “Contract Billing Grouping” |
Keys
- PK: Code (clustered)
Procedures
ReadFilter(FieldNumber: Integer): Text(internal)EditFilter(FieldNumber: Integer): Boolean(internal)WriteFilter(FieldNumber: Integer; FilterText: Text)(internal)
Plus 3 local procedures.
Relations
- drill-down page Page 8026 “Price Update Templates”
- lookup page Page 8026 “Price Update Templates”
Referenced by
1 fields in 1 objects relate to this table (TableRelation or CalcFormula).
- Table 8004 “Sub. Contr. Price Update Line”: Price Update Template Code
Pages and codeunits on this table
- Page 8026 “Price Update Templates” (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: "Price Update Template"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.