Table of Contents

Table "Price List Header"

ID 7000
Namespace: Microsoft.Pricing.PriceList

Properties

Name Value
Caption Price List
DataClassification CustomerContent

Fields

Name Type Description
Code Code[20]

Specifies the unique identifier of the price list.

Description Text[250]

Specifies the description of the price list.

"Source Group" Enum Microsoft.Pricing.Source."Price Source Group"

Specifies whether the prices come from groups of customers, vendors or projects.

"Source Type" Enum Microsoft.Pricing.Source."Price Source Type"
"Source No." 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.

"Parent Source No." Code[20]
"Source ID" Guid
"Price Type" Enum Microsoft.Pricing.PriceList."Price Type"
"Amount Type" Enum Microsoft.Pricing.PriceList."Price Amount Type"

Specifies whether the price list defines prices, discounts, or both.

"Currency Code" Code[10]

Specifies the currency code of the price list.

"Starting Date" Date

Specifies the date from which the price is valid.

"Ending Date" Date

Specifies the last date that the price is valid.

"Price Includes VAT" Boolean

Specifies if prices include VAT.

"VAT Bus. Posting Gr. (Price)" Code[20]
"Allow Line Disc." Boolean

Specifies whether line discounts are allowed. You can change this value on the lines.

"Allow Invoice Disc." Boolean

Specifies whether invoice discount is allowed. You can change this value on the lines.

"No. Series" Code[20]
Status Enum Microsoft.Pricing.PriceList."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.

"Filter Source No." Code[20]
"Allow Updating Defaults" 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.

"Assign-to No." 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.

"Assign-to Parent No." 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.

SystemId Guid
SystemCreatedAt DateTime
SystemCreatedBy Guid
SystemModifiedAt DateTime
SystemModifiedBy Guid
SystemCreatedByUserName Text[50]
SystemCreatedByFullName Text[80]
SystemModifiedByUserName Text[50]
SystemModifiedByFullName Text[80]
SystemRowVersion BigInteger

Methods

IsEditable

procedure IsEditable(): Boolean

Returns

Type Description
Boolean

IsCRMIntegrationAllowed

procedure IsCRMIntegrationAllowed(StatusActiveFilterApplied: Boolean; AllowUpdatingDefaultsFilterApplied: Boolean): Boolean

Parameters

Name Type Description
StatusActiveFilterApplied Boolean
AllowUpdatingDefaultsFilterApplied Boolean

Returns

Type Description
Boolean

AssistEditCode

procedure AssistEditCode(xPriceListHeader: Record "Price List Header"): Boolean

Parameters

Name Type Description
xPriceListHeader Table Microsoft.Pricing.PriceList."Price List Header"

Returns

Type Description
Boolean

BlankDefaults

procedure BlankDefaults()

CheckIfLinesExist

procedure CheckIfLinesExist(Caption: Text)

Parameters

Name Type Description
Caption Text

CopyFrom

procedure CopyFrom(PriceSource: Record "Price Source")

Parameters

Name Type Description
PriceSource Table Microsoft.Pricing.Source."Price Source"

CopyTo

procedure CopyTo(var PriceSource: Record "Price Source")

Parameters

Name Type Description
PriceSource Table Microsoft.Pricing.Source."Price Source"

IsSourceNoAllowed

procedure IsSourceNoAllowed(): Boolean

Returns

Type Description
Boolean

UpdateAmountType

procedure UpdateAmountType()

SyncDropDownLookupFields

procedure SyncDropDownLookupFields()

TestStatusDraft

procedure TestStatusDraft()

HasDraftLines

procedure HasDraftLines(): Boolean

Returns

Type Description
Boolean

HasDraftLines

procedure HasDraftLines(var PriceListLine: Record "Price List Line"): Boolean

Parameters

Name Type Description
PriceListLine Table Microsoft.Pricing.PriceList."Price List Line"

Returns

Type Description
Boolean

LookupSourceNo

procedure LookupSourceNo(): Boolean

Returns

Type Description
Boolean

Events

OnAfterBlankDefaults

[IntegrationEvent(False,False)]
local procedure OnAfterBlankDefaults(var PriceListHeader: Record "Price List Header")

Parameters

Name Type Description
PriceListHeader Table Microsoft.Pricing.PriceList."Price List Header"

OnAfterCopyFromPriceSource

[IntegrationEvent(True,False)]
local procedure OnAfterCopyFromPriceSource(PriceSource: Record "Price Source")

Parameters

Name Type Description
PriceSource Table Microsoft.Pricing.Source."Price Source"

OnAfterCopyToPriceSource

[IntegrationEvent(True,False)]
local procedure OnAfterCopyToPriceSource(var PriceSource: Record "Price Source")

Parameters

Name Type Description
PriceSource Table Microsoft.Pricing.Source."Price Source"

OnAfterGetNoSeries

[IntegrationEvent(False,False)]
local procedure OnAfterGetNoSeries(var PriceListHeader: Record "Price List Header"; var Result: Code[20])

Parameters

Name Type Description
PriceListHeader Table Microsoft.Pricing.PriceList."Price List Header"
Result Code[20]

OnBeforeHasDraftLines

[IntegrationEvent(False,False)]
local procedure OnBeforeHasDraftLines(var PriceListLine: Record "Price List Line"; var Result: Boolean; var IsHandled: Boolean; var PriceListHeader: Record "Price List Header")

Parameters

Name Type Description
PriceListLine Table Microsoft.Pricing.PriceList."Price List Line"
Result Boolean
IsHandled Boolean
PriceListHeader Table Microsoft.Pricing.PriceList."Price List Header"

OnBeforeUpdateStatus

[IntegrationEvent(False,False)]
local procedure OnBeforeUpdateStatus(var PriceListHeader: Record "Price List Header"; var Updated: Boolean; var IsHandled: Boolean)

Parameters

Name Type Description
PriceListHeader Table Microsoft.Pricing.PriceList."Price List Header"
Updated Boolean
IsHandled Boolean

OnUpdateStatusOnBeforeConfirmStatus

[IntegrationEvent(False,False)]
local procedure OnUpdateStatusOnBeforeConfirmStatus(PriceListHeader: Record "Price List Header"; Updated: Boolean; var Confirmed: Boolean; var IsHandled: Boolean)

Parameters

Name Type Description
PriceListHeader Table Microsoft.Pricing.PriceList."Price List Header"
Updated Boolean
Confirmed Boolean
IsHandled Boolean

OnUpdateDatesInLinesOnBeforePriceListLineModifyAllEndingDate

[IntegrationEvent(False,False)]
local procedure OnUpdateDatesInLinesOnBeforePriceListLineModifyAllEndingDate(var PriceListLine: Record "Price List Line"; var PriceListHeader: Record "Price List Header")

Parameters

Name Type Description
PriceListLine Table Microsoft.Pricing.PriceList."Price List Line"
PriceListHeader Table Microsoft.Pricing.PriceList."Price List Header"

See also