Table 7000 "Price List Header"
Base Application · Microsoft.Pricing.PriceList
Across versions
- BC23present
- BC241 fields changed
- BC251 procedures removed
- BC26unchanged
- BC271 procedures added, 1 procedures removed
- BC2815 fields changed
- BC29-30unchanged
Neighbourhood 27 connected objects and pages
Base Application · Microsoft.Pricing.PriceList · captioned “Price List” · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 7017 “Purchase Price Lists” (2 Learn pages), Page 7018 “Purchase Price List” (2), Page 7015 “Sales Price Lists” (1), Page 7016 “Sales Price List” (1).
Properties
| Property | Value |
|---|---|
| Caption | Price List |
| 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 | Code Δ BC28 | Code[20] | Specifies the unique identifier of the price list. | |
| 2 | Description Δ BC28 | Text[250] | Specifies the description of the price list. | |
| 3 | Source Group Δ BC28 | Enum “Price Source Group” | Specifies whether the prices come from groups of customers, vendors or projects. | enum Enum 7002 “Price Source Group” |
| 4 | Source Type | Enum “Price Source Type” | Assign-to Type caption | enum Enum 7003 “Price Source Type” |
| 5 | Source No. Δ BC28 | Code[20] | Specifies the entity to which the prices are assigned. The options depend on the selection in the Assign-to Type field. If you choose an entity, the price list will be used only for that entity. | |
| 6 | Parent Source No. Δ BC24 | Code[20] | Assign-to Parent No. (projects) caption | |
| 7 | Source ID | Guid | Assign-to ID caption | |
| 8 | Price Type | Enum “Price Type” | — | enum Enum 7009 “Price Type” |
| 9 | Amount Type Δ BC28 | Enum “Price Amount Type” | Specifies whether the price list defines prices, discounts, or both. | enum Enum 7001 “Price Amount Type” |
| 10 | Currency Code Δ BC28 | Code[10] | Specifies the currency code of the price list. | TableRelation Table 4 “Currency” |
| 11 | Starting Date Δ BC28 | Date | Specifies the date from which the price is valid. | |
| 12 | Ending Date Δ BC28 | Date | Specifies the last date that the price is valid. | |
| 13 | Price Includes VAT Δ BC28 | Boolean | Specifies if prices include VAT. | |
| 14 | VAT Bus. Posting Gr. (Price) | Code[20] | Specifies the default VAT business posting group code. via Page 7013 “Price List Filters” | TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group) |
| 15 | Allow Line Disc. Δ BC28 | Boolean | Specifies whether line discounts are allowed. You can change this value on the lines. | |
| 16 | Allow Invoice Disc. Δ BC28 | Boolean | Specifies whether invoice discount is allowed. You can change this value on the lines. | |
| 17 | No. Series | Code[20] | — | TableRelation Table 308 “No. Series” (No. Series); not editable |
| 18 | Status Δ BC28 | Enum “Price Status” | Specifies whether the price list is in Draft status and can be edited, Inactive and cannot be edited or used, or Active and can be edited (when Allow Editing Active Price is enabled) and used for price calculations. | enum Enum 7005 “Price Status” |
| 19 | Filter Source No. | Code[20] | — | not editable |
| 20 | Allow Updating Defaults Δ BC28 | Boolean | Specifies whether users can change the values in the fields on the price list lines that contain default values from the header. This does not affect the ability to allow line or invoice discounts. | DataClassification SystemMetadata |
| 21 | Assign-to No. Δ BC28 | Code[20] | Specifies the entity to which the prices are assigned. The options depend on the selection in the Assign-to Type field. If you choose an entity, the price list will be used only for that entity. | TableRelation Table 18 “Customer”, Table 340 “Customer Discount Group”, Table 5050 “Contact” (if (“Source Type” = const(Campaign)) Campaign else if (“Source Type” = const(Contact)) Contact else if (“Source Type” = const(Customer)) Customer else if (“Source Type” = const(“Customer Disc. Group”)) “Customer Discount Group” else if (“Source Type” = const(“Customer Price Group”)) “Customer Price …) |
| 22 | Assign-to Parent No. Δ BC28 | Code[20] | Specifies the entity to which the prices are assigned. The options depend on the selection in the Assign-to Type field. If you choose an entity, the price list will be used only for that entity. | TableRelation Table 167 “Job” (if (“Source Type” = const(“Job Task”)) Job) |
Keys
- PK: Code
- Key1: Source Type, Source No., Starting Date, Currency Code
- Key2: Status, Price Type, Source Group, Source Type, Source No., Currency Code, Starting Date, Ending Date
Events published
OnAfterBlankDefaults(var PriceListHeader: Record "Price List Header")(integration)OnAfterCopyFromPriceSource(PriceSource: Record "Price Source")(integration)OnAfterCopyToPriceSource(var PriceSource: Record "Price Source")(integration)OnAfterGetNoSeries(var PriceListHeader: Record "Price List Header"; var Result: Code[20])(integration)OnBeforeHasDraftLines(var PriceListLine: Record "Price List Line"; var Result: Boolean; var IsHandled: Boolean; var PriceListHeader: Record "Price List Header")(integration)OnBeforeUpdateStatus(var PriceListHeader: Record "Price List Header"; var Updated: Boolean; var IsHandled: Boolean)(integration)OnUpdateStatusOnBeforeConfirmStatus(PriceListHeader: Record "Price List Header"; Updated: Boolean; var Confirmed: Boolean; var IsHandled: Boolean)(integration)OnUpdateDatesInLinesOnBeforePriceListLineModifyAllEndingDate(var PriceListLine: Record "Price List Line"; var PriceListHeader: Record "Price List Header")(integration)
Procedures
IsEditable(): BooleanIsCRMIntegrationAllowed(StatusActiveFilterApplied: Boolean; AllowUpdatingDefaultsFilterApplied: Boolean): Boolean− BC25AssistEditCode(xPriceListHeader: Record "Price List Header"): BooleanBlankDefaults()CheckIfLinesExist(Caption: Text)CopyFrom(PriceSource: Record "Price Source")CopyTo(var PriceSource: Record "Price Source")IsSourceNoAllowed(): BooleanUpdateAmountType()SyncDropDownLookupFields()TestStatusDraft()HasDraftLines(): BooleanHasDraftLines(var PriceListLine: Record "Price List Line"): BooleanLookupSourceNo(): Boolean
Plus 10 local procedures.
Triggers
OnInsert, OnDelete, OnRename
Relations
- Assign-to Parent No.: TableRelation Table 167 “Job”
- Assign-to No.: TableRelation Table 18 “Customer” (conditional)
- No. Series: TableRelation Table 308 “No. Series”
- VAT Bus. Posting Gr. (Price): TableRelation Table 323 “VAT Business Posting Group”
- Assign-to No.: TableRelation Table 340 “Customer Discount Group” (conditional)
- Currency Code: TableRelation Table 4 “Currency”
- Assign-to No.: TableRelation Table 5050 “Contact” (conditional)
- Assign-to No.: TableRelation Table 5071 “Campaign” (conditional)
Referenced by
9 fields in 7 objects relate to this table (TableRelation or CalcFormula).
- Table 315 “Jobs Setup”: Default Purch Price List Code, Default Sales Price List Code
- Table 7021 “Price Line Filters”: From Price List Code, To Price List Code
- Table 311 “Sales & Receivables Setup”: Default Price List Code
- Table 312 “Purchases & Payables Setup”: Default Price List Code
- Table 7001 “Price List Line”: Price List Code
- Table 7009 “Duplicate Price Line”: Price List Code
- Table 7022 “Price Worksheet Line”: Price List Code
Pages and codeunits on this table
- Page 7013 “Price List Filters” (source table)
- Page 7015 “Sales Price Lists” (source table)
- Page 7016 “Sales Price List” (source table)
- Page 7017 “Purchase Price Lists” (source table)
- Page 7018 “Purchase Price List” (source table)
- Page 7019 “Sales Job Price Lists” (source table)
- Page 7020 “Purchase Job Price Lists” (source table)
Calls
From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.
- Codeunit 7017 “Price List Management” (3 calls:
IsAllowedEditingActivePrice → IsAllowedEditingActivePrice,UpdateStatus → ResolveDuplicatePrices,UpdateStatus → VerifyLines) - Codeunit 27 “Confirm Management” (2 calls:
UpdateDatesInLines → GetResponse,UpdateStatus → GetResponseOrDefault) - Page 456 “No. Series” (2 calls:
AssistEditCode → (object),OnInsert → (object))
Ask your agent
Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. 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 List Header"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.