Table 7008 "Dtld. Price Calculation Setup"

Base Application · Microsoft.Pricing.Calculation · captioned “Detailed Price Calculation Setup” · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Detailed Price Calculation Setup
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	Line No.	Integer	—	AutoIncrement
2	Setup Code Δ BC28	Code[100]	Specifies a price calculation setup code.	TableRelation Table 7006 “Price Calculation Setup” (“Price Calculation Setup”.Code where(Enabled = const(true)))
3	Method Δ BC28	Enum “Price Calculation Method”	Specifies a price calculation method.	enum Enum 7000 “Price Calculation Method”; not editable
4	Type Δ BC28	Enum “Price Type”	Specifies what type of amount to calculate - sale or purchase.	enum Enum 7009 “Price Type”; not editable
5	Asset Type Δ BC28	Enum “Price Asset Type”	Specifies a product type.	enum Enum 7004 “Price Asset Type”; not editable
6	Asset No. Δ BC28	Code[20]	Specifies a product number.
7	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”
8	Source Type	Enum “Price Source Type”	Assign-to Type caption	enum Enum 7003 “Price Source Type”; not editable
9	Source No. Δ BC28	Code[20]	Specifies the unique identifier of the source of the price on the price list line.
10	Implementation Δ BC28	Enum “Price Calculation Handler”	Specifies a price calculation implementation name.	enum Enum 7011 “Price Calculation Handler”; not editable
11	Group Id	Code[100]	—	DataClassification SystemMetadata
12	Enabled Δ BC28	Boolean	Specifies whether the implementation codeunit is enabled.
13	Product No. Δ BC28	Code[20]	Specifies a product number.	TableRelation Table 15 “G/L Account”, Table 152 “Resource Group”, Table 156 “Resource” (if (“Asset Type” = const(Item)) Item where(“No.” = field(“Product No.”)) else if (“Asset Type” = const(“G/L Account”)) “G/L Account” else if (“Asset Type” = const(Resource)) Resource else if (“Asset Type” = const(“Resource Group”)) “Resource Group” else if (“Asset Type” = const(“Item Discount Group”…)
14	Assign-to No. Δ BC28	Code[20]	Specifies the unique identifier of the source of the price on the price list line.	TableRelation Table 167 “Job”, Table 18 “Customer”, Table 23 “Vendor” (if (“Source Type” = const(Customer)) Customer else if (“Source Type” = const(Job)) Job else if (“Source Type” = const(Vendor)) Vendor)

Keys

PK: Line No. (clustered)
Key2: Group Id, Enabled

Procedures

CopyTo(var PriceAsset: Record "Price Asset")
CopyTo(var PriceSource: Record "Price Source")

Plus 5 local procedures.

Triggers

OnInsert

Relations

drill-down page Page 7008 “Dtld. Price Calculation Setup”
lookup page Page 7008 “Dtld. Price Calculation Setup”
Product No.: TableRelation Table 15 “G/L Account” (conditional)
Product No.: TableRelation Table 152 “Resource Group” (conditional)
Product No.: TableRelation Table 156 “Resource” (conditional)
Assign-to No.: TableRelation Table 167 “Job” (conditional)
Assign-to No.: TableRelation Table 18 “Customer” (conditional)
Assign-to No.: TableRelation Table 23 “Vendor” (conditional)
Product No.: TableRelation Table 27 “Item” (conditional)
Setup Code: TableRelation Table 7006 “Price Calculation Setup”

Referenced by

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

Table 7006 “Price Calculation Setup”: Details

Pages and codeunits on this table

Page 7008 “Dtld. Price Calculation Setup” (source table)

Extended by

Table extension 6473 “Serv. Dtld. Price Calc. Setup”

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: "Dtld. Price Calculation Setup"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.