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
IsCRMIntegrationAllowed
procedure IsCRMIntegrationAllowed(StatusActiveFilterApplied: Boolean; AllowUpdatingDefaultsFilterApplied: Boolean): Boolean
Parameters
| Name |
Type |
Description |
|
StatusActiveFilterApplied
|
Boolean |
|
|
AllowUpdatingDefaultsFilterApplied
|
Boolean |
|
Returns
AssistEditCode
procedure AssistEditCode(xPriceListHeader: Record "Price List Header"): Boolean
Parameters
Returns
BlankDefaults
procedure BlankDefaults()
CheckIfLinesExist
procedure CheckIfLinesExist(Caption: Text)
Parameters
| Name |
Type |
Description |
|
Caption
|
Text |
|
CopyFrom
procedure CopyFrom(PriceSource: Record "Price Source")
Parameters
CopyTo
procedure CopyTo(var PriceSource: Record "Price Source")
Parameters
IsSourceNoAllowed
procedure IsSourceNoAllowed(): Boolean
Returns
UpdateAmountType
procedure UpdateAmountType()
SyncDropDownLookupFields
procedure SyncDropDownLookupFields()
TestStatusDraft
procedure TestStatusDraft()
HasDraftLines
procedure HasDraftLines(): Boolean
Returns
HasDraftLines
procedure HasDraftLines(var PriceListLine: Record "Price List Line"): Boolean
Parameters
Returns
LookupSourceNo
procedure LookupSourceNo(): Boolean
Returns
Events
OnAfterBlankDefaults
[IntegrationEvent(False,False)]
local procedure OnAfterBlankDefaults(var PriceListHeader: Record "Price List Header")
Parameters
OnAfterCopyFromPriceSource
[IntegrationEvent(True,False)]
local procedure OnAfterCopyFromPriceSource(PriceSource: Record "Price Source")
Parameters
OnAfterCopyToPriceSource
[IntegrationEvent(True,False)]
local procedure OnAfterCopyToPriceSource(var PriceSource: Record "Price Source")
Parameters
OnAfterGetNoSeries
[IntegrationEvent(False,False)]
local procedure OnAfterGetNoSeries(var PriceListHeader: Record "Price List Header"; var Result: Code[20])
Parameters
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
OnBeforeUpdateStatus
[IntegrationEvent(False,False)]
local procedure OnBeforeUpdateStatus(var PriceListHeader: Record "Price List Header"; var Updated: Boolean; var IsHandled: Boolean)
Parameters
OnUpdateStatusOnBeforeConfirmStatus
[IntegrationEvent(False,False)]
local procedure OnUpdateStatusOnBeforeConfirmStatus(PriceListHeader: Record "Price List Header"; Updated: Boolean; var Confirmed: Boolean; var IsHandled: Boolean)
Parameters
OnUpdateDatesInLinesOnBeforePriceListLineModifyAllEndingDate
[IntegrationEvent(False,False)]
local procedure OnUpdateDatesInLinesOnBeforePriceListLineModifyAllEndingDate(var PriceListLine: Record "Price List Line"; var PriceListHeader: Record "Price List Header")
Parameters
See also