Table "Price List Line"
ID 7001
Namespace: Microsoft.Pricing.PriceList
Properties
| Name |
Value |
| DataClassification |
CustomerContent
|
Fields
| Name |
Type |
Description |
| "Price List Code" |
Code[20]
|
Specifies the unique identifier of the price list.
|
| "Line No." |
Integer
|
|
| "Source Type" |
Enum Microsoft.Pricing.Source."Price Source Type"
|
Specifies the type of the entity that offers the price or the line discount on the product.
|
| "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]
|
Specifies the project to which the prices are assigned. If you choose an entity, the price list will be used only for that entity.
|
| "Source ID" |
Guid
|
|
| "Asset Type" |
Enum Microsoft.Pricing.Asset."Price Asset Type"
|
Specifies the type of the product.
|
| "Asset No." |
Code[20]
|
Specifies the identifier of the product. If no product is selected, the price and discount values will apply to all products of the selected product type for which those values are not specified. For example, if you choose Item as the product type but do not specify a specific item, the price will apply to all items for which a price is not specified.
|
| "Variant Code" |
Code[10]
|
Specifies the item variant.
|
| "Currency Code" |
Code[10]
|
Specifies the currency that is used for the prices on the price list. The currency can be the same for all prices on the price list, or you can specify a currency for individual lines.
|
| "Work Type Code" |
Code[10]
|
Specifies the work type code for the resource.
|
| "Starting Date" |
Date
|
Specifies the date from which the price is valid.
|
| "Ending Date" |
Date
|
Specifies the last date that the price is valid.
|
| "Minimum Quantity" |
Decimal
|
Specifies the minimum quantity of the product.
|
| "Unit of Measure Code" |
Code[10]
|
Specifies the unit of measure for the product.
|
| "Amount Type" |
Enum Microsoft.Pricing.PriceList."Price Amount Type"
|
Specifies whether the price list line defines prices, discounts, or both.
|
| "Unit Price" |
Decimal
|
Specifies the unit price of the product.
|
| "Cost Factor" |
Decimal
|
Specifies the unit cost factor for project-related prices, if you have agreed with your customer that he should pay certain item usage by cost value plus a certain percent value to cover your overhead expenses.
|
| "Unit Cost" |
Decimal
|
Specifies the unit cost of the resource.
|
| "Line Discount %" |
Decimal
|
Specifies the line discount percentage for the product.
|
| "Allow Line Disc." |
Boolean
|
Specifies if a line discount will be calculated when the price is offered.
|
| "Allow Invoice Disc." |
Boolean
|
Specifies if an invoice discount will be calculated when the price is offered.
|
| "Price Includes VAT" |
Boolean
|
Specifies if prices include VAT.
|
| "VAT Bus. Posting Gr. (Price)" |
Code[20]
|
|
| "VAT Prod. Posting Group" |
Code[20]
|
|
| "Asset ID" |
Guid
|
|
| "Line Amount" |
Decimal
|
|
| "Price Type" |
Enum Microsoft.Pricing.PriceList."Price Type"
|
Specifies the price type: sale or purchase price.
|
| Description |
Text[100]
|
Specifies the description of the product.
|
| Status |
Enum Microsoft.Pricing.PriceList."Price Status"
|
Specifies whether the price list line is in Draft status and can be edited, Inactive and cannot be edited or used, or Active and used for price calculations.
|
| "Direct Unit Cost" |
Decimal
|
Specifies the direct unit cost of the product.
|
| "Source Group" |
Enum Microsoft.Pricing.Source."Price Source Group"
|
|
| "Product No." |
Code[20]
|
Specifies the identifier of the product. If no product is selected, the price and discount values will apply to all products of the selected product type for which those values are not specified. For example, if you choose Item as the product type but do not specify a specific item, the price will apply to all items for which a price is not specified.
|
| "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 project to which the prices are assigned. If you choose an entity, the price list will be used only for that entity.
|
| "Variant Code Lookup" |
Code[10]
|
Specifies the item variant.
|
| "Unit of Measure Code Lookup" |
Code[10]
|
Specifies the unit of measure for the product.
|
| 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
SetNextLineNo
procedure SetNextLineNo()
IsAssetItem
procedure IsAssetItem(): Boolean
Returns
IsAssetResource
procedure IsAssetResource(): Boolean
Returns
IsEditable
procedure IsEditable(): Boolean
Returns
IsHeaderActive
procedure IsHeaderActive(): Boolean
Returns
IsLineToVerify
procedure IsLineToVerify(): Boolean
Returns
IsUOMSupported
procedure IsUOMSupported(): Boolean
Returns
IsAmountMandatory
procedure IsAmountMandatory(AmountType: Enum "Price Amount Type"): Boolean
Parameters
Returns
IsAmountSupported
procedure IsAmountSupported(): Boolean
Returns
IsRealLine
procedure IsRealLine(): Boolean
Returns
IsSourceNoAllowed
procedure IsSourceNoAllowed(): Boolean
Returns
CheckAmountType
procedure CheckAmountType(FldCaption: Text; AmountType: Enum "Price Amount Type")
Parameters
CopySourceFrom
procedure CopySourceFrom(PriceListHeader: Record "Price List Header")
Parameters
CopyFrom
procedure CopyFrom(PriceListHeader: Record "Price List Header")
Parameters
CopyFrom
procedure CopyFrom(PriceListHeader: Record "Price List Header"; ForceDefaults: Boolean)
Parameters
CopyFrom
procedure CopyFrom(PriceAsset: Record "Price Asset")
Parameters
CopyPriceFrom
procedure CopyPriceFrom(PriceAsset: Record "Price Asset")
Parameters
SetNewRecord
procedure SetNewRecord(NewRecord: Boolean)
Parameters
| Name |
Type |
Description |
|
NewRecord
|
Boolean |
|
CopyTo
procedure CopyTo(var PriceAsset: Record "Price Asset")
Parameters
CopyTo
procedure CopyTo(var PriceSource: Record "Price Source")
Parameters
CopyFilteredLinesToTemporaryBuffer
procedure CopyFilteredLinesToTemporaryBuffer(var TempPriceListLine: Record "Price List Line" temporary): Boolean
Parameters
Returns
SetHeader
procedure SetHeader(var NewPriceListHeader: Record "Price List Header")
Parameters
SetAssetNo
procedure SetAssetNo(AssetNo: Code[20])
Parameters
| Name |
Type |
Description |
|
AssetNo
|
Code[20] |
|
SyncDropDownLookupFields
procedure SyncDropDownLookupFields()
TestStatusDraft
procedure TestStatusDraft()
Verify
VerifySource
UseCustomizedLookup
procedure UseCustomizedLookup(): Boolean
Returns
RenameNo
procedure RenameNo(LineType: Enum "Price Asset Type"; OldNo: Code[20]; NewNo: Code[20])
Parameters
Events
OnAfterCopyFromForPriceAsset
[IntegrationEvent(True,False)]
local procedure OnAfterCopyFromForPriceAsset(PriceAsset: Record "Price Asset"; var PriceListLine: Record "Price List Line")
Parameters
OnAfterCopyFromPriceListHeader
[IntegrationEvent(True,False)]
local procedure OnAfterCopyFromPriceListHeader(PriceListHeader: Record "Price List Header"; ForceDefaults: Boolean)
Parameters
OnAfterCopyFromPriceSource
[IntegrationEvent(True,False)]
local procedure OnAfterCopyFromPriceSource(PriceSource: Record "Price Source"; var PriceListLine: Record "Price List Line")
Parameters
OnAfterCopyPriceFrom
[IntegrationEvent(False,False)]
local procedure OnAfterCopyPriceFrom(var PriceListLine: Record "Price List Line"; PriceAsset: Record "Price Asset")
Parameters
OnAfterCopySourceFrom
[IntegrationEvent(False,False)]
local procedure OnAfterCopySourceFrom(var PriceListLine: Record "Price List Line"; PriceListHeader: Record "Price List Header")
Parameters
OnAfterCopyToPriceAsset
[IntegrationEvent(True,False)]
local procedure OnAfterCopyToPriceAsset(var PriceAsset: Record "Price Asset")
Parameters
OnAfterCopyToPriceSource
[IntegrationEvent(True,False)]
local procedure OnAfterCopyToPriceSource(var PriceSource: Record "Price Source")
Parameters
OnAfterInitHeaderDefaults
[IntegrationEvent(True,False)]
local procedure OnAfterInitHeaderDefaults(PriceListHeader: Record "Price List Header")
Parameters
OnAfterIsAllowedEditingActivePrice
[IntegrationEvent(False,False)]
local procedure OnAfterIsAllowedEditingActivePrice(PriceListLine: Record "Price List Line"; var Result: Boolean)
Parameters
OnAfterIsUOMSupported
[IntegrationEvent(False,False)]
procedure OnAfterIsUOMSupported(PriceListLine: Record "Price List Line"; var Result: Boolean)
Parameters
OnAfterVerify
[IntegrationEvent(False,False)]
local procedure OnAfterVerify(var PriceListLine: Record "Price List Line")
Parameters
OnBeforeVerify
[IntegrationEvent(False,False)]
local procedure OnBeforeVerify(var PriceListLine: Record "Price List Line"; var IsHandled: Boolean)
Parameters
OnCopyFilteredLinesToTemporaryBufferOnBeforeInsert
[IntegrationEvent(False,False)]
local procedure OnCopyFilteredLinesToTemporaryBufferOnBeforeInsert(var TempPriceListLine: Record "Price List Line" temporary)
Parameters
OnBeforeCopyFromAssetType
[IntegrationEvent(False,False)]
local procedure OnBeforeCopyFromAssetType(var PriceListLine: Record "Price List Line"; var IsHandled: Boolean)
Parameters
OnBeforeSetNextLineNo
[IntegrationEvent(False,False)]
local procedure OnBeforeSetNextLineNo(var PriceListLine: Record "Price List Line"; var IsHandled: Boolean)
Parameters
OnCopyFromAssetTypeElseCase
[IntegrationEvent(False,False)]
local procedure OnCopyFromAssetTypeElseCase(var PriceListLine: Record "Price List Line"; var IsHandled: Boolean)
Parameters
OnCopyFromAssetTypeOnAfterCopyFromAssetTypeItem
[IntegrationEvent(False,False)]
local procedure OnCopyFromAssetTypeOnAfterCopyFromAssetTypeItem(Item: Record Item; var PriceListLine: Record "Price List Line")
Parameters
OnCopyFromAssetTypeOnAfterCopyFromAssetTypeGLAccount
[IntegrationEvent(False,False)]
local procedure OnCopyFromAssetTypeOnAfterCopyFromAssetTypeGLAccount(GLAccount: Record "G/L Account"; var PriceListLine: Record "Price List Line")
Parameters
OnCopyFromAssetTypeOnAfterCopyFromAssetTypeResource
[IntegrationEvent(False,False)]
local procedure OnCopyFromAssetTypeOnAfterCopyFromAssetTypeResource(Resource: Record Resource; var PriceListLine: Record "Price List Line")
Parameters
OnAfterCopyFilteredLinesToTemporaryBuffer
[IntegrationEvent(False,False)]
local procedure OnAfterCopyFilteredLinesToTemporaryBuffer(var TempPriceListLine: Record "Price List Line" temporary)
Parameters
OnBeforeCopyFilteredLinesToTemporaryBuffer
[IntegrationEvent(True,False)]
local procedure OnBeforeCopyFilteredLinesToTemporaryBuffer(var PriceListLine: Record "Price List Line"; var TempPriceListLine: Record "Price List Line" temporary; var Copied: Boolean; var IsHandled: Boolean)
Parameters
See also