Table "Price Worksheet Line"

ID 7022

Namespace: Microsoft.Pricing.Worksheet

Properties

Name	Value
DataClassification	CustomerContent

Fields

Name	Type	Description
"Price List Code"	Code[20]
"Line No."	Integer
"Source Type"	Enum Microsoft.Pricing.Source."Price Source Type"
"Source No."	Code[20]
"Parent Source No."	Code[20]
"Source ID"	Guid
"Asset Type"	Enum Microsoft.Pricing.Asset."Price Asset Type"
"Asset No."	Code[20]
"Variant Code"	Code[10]
"Currency Code"	Code[10]
"Work Type Code"	Code[10]
"Starting Date"	Date
"Ending Date"	Date
"Minimum Quantity"	Decimal
"Unit of Measure Code"	Code[10]
"Amount Type"	Enum Microsoft.Pricing.PriceList."Price Amount Type"
"Unit Price"	Decimal
"Cost Factor"	Decimal
"Unit Cost"	Decimal
"Line Discount %"	Decimal
"Allow Line Disc."	Boolean
"Allow Invoice Disc."	Boolean
"Price Includes VAT"	Boolean
"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"
Description	Text[100]
Status	Enum Microsoft.Pricing.PriceList."Price Status"
"Direct Unit Cost"	Decimal
"Source Group"	Enum Microsoft.Pricing.Source."Price Source Group"
"Product No."	Code[20]
"Assign-to No."	Code[20]
"Assign-to Parent No."	Code[20]
"Variant Code Lookup"	Code[10]
"Unit of Measure Code Lookup"	Code[10]
"Existing Line"	Boolean
"Existing Unit Price"	Decimal
"Existing Direct Unit Cost"	Decimal
"Existing Unit Cost"	Decimal
SystemId	Guid
SystemCreatedAt	DateTime
SystemCreatedBy	Guid
SystemModifiedAt	DateTime
SystemModifiedBy	Guid
SystemRowVersion	BigInteger

Methods

IsAssetItem

procedure IsAssetItem(): Boolean

Returns

Type	Description
Boolean

IsAssetResource

procedure IsAssetResource(): Boolean

Returns

Type	Description
Boolean

IsEditable

procedure IsEditable(): Boolean

Returns

Type	Description
Boolean

IsHeaderActive

procedure IsHeaderActive(): Boolean

Returns

Type	Description
Boolean

IsLineToVerify

procedure IsLineToVerify(): Boolean

Returns

Type	Description
Boolean

IsUOMSupported

procedure IsUOMSupported(): Boolean

Returns

Type	Description
Boolean

IsAmountMandatory

procedure IsAmountMandatory(AmountType: Enum "Price Amount Type"): Boolean

Parameters

Name	Type	Description
AmountType	Enum Microsoft.Pricing.PriceList."Price Amount Type"

Returns

Type	Description
Boolean

IsAmountSupported

procedure IsAmountSupported(): Boolean

Returns

Type	Description
Boolean

IsRealLine

procedure IsRealLine(): Boolean

Returns

Type	Description
Boolean

IsSourceNoAllowed

procedure IsSourceNoAllowed(): Boolean

Returns

Type	Description
Boolean

CopyExistingPrices

procedure CopyExistingPrices(PriceListLine: Record "Price List Line")

Parameters

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

CopySourceFrom

procedure CopySourceFrom(PriceListHeader: Record "Price List Header")

Parameters

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

CopyFrom

procedure CopyFrom(PriceListHeader: Record "Price List Header")

Parameters

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

CopyFrom

procedure CopyFrom(PriceAsset: Record "Price Asset" temporary)

Parameters

Name	Type	Description
PriceAsset	Table Microsoft.Pricing.Asset."Price Asset"

SetNewRecord

procedure SetNewRecord(NewRecord: Boolean)

Parameters

Name	Type	Description
NewRecord	Boolean

CopyTo

procedure CopyTo(var PriceAsset: Record "Price Asset" temporary)

Parameters

Name	Type	Description
PriceAsset	Table Microsoft.Pricing.Asset."Price Asset"

CopyTo

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

Parameters

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

SyncDropDownLookupFields

procedure SyncDropDownLookupFields()

Verify

procedure Verify(): Boolean

Returns

Type	Description
Boolean

TryVerify

[TryFunction]
procedure TryVerify(): Boolean

Returns

Type	Description
Boolean

Events

OnAfterCopyFromPriceAsset

[IntegrationEvent(True,False)]
local procedure OnAfterCopyFromPriceAsset(PriceAsset: Record "Price Asset" temporary, var PriceWorksheetLine: Record "Price Worksheet Line")

Parameters

Name	Type	Description
PriceAsset	Table Microsoft.Pricing.Asset."Price Asset"
PriceWorksheetLine	Table Microsoft.Pricing.Worksheet."Price Worksheet Line"

OnAfterCopyFromPriceListHeader

[IntegrationEvent(True,False)]
local procedure OnAfterCopyFromPriceListHeader(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" temporary)

Parameters

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

OnAfterCopyExistingPrices

[IntegrationEvent(False,False)]
local procedure OnAfterCopyExistingPrices(var PriceWorksheetLine: Record "Price Worksheet Line", PriceListLine: Record "Price List Line")

Parameters

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

OnAfterCopyToPriceAsset

[IntegrationEvent(True,False)]
local procedure OnAfterCopyToPriceAsset(var PriceAsset: Record "Price Asset" temporary)

Parameters

Name	Type	Description
PriceAsset	Table Microsoft.Pricing.Asset."Price Asset"

OnAfterCopyToPriceSource

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

Parameters

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

OnAfterCopySourceFrom

[IntegrationEvent(False,False)]
local procedure OnAfterCopySourceFrom(var PriceWorksheetLine: Record "Price Worksheet Line", PriceListHeader: Record "Price List Header")

Parameters

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

OnAfterInitHeaderDefaults

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

Parameters

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

OnAfterIsUOMSupported

[IntegrationEvent(False,False)]
procedure OnAfterIsUOMSupported(PriceWorksheetLine: Record "Price Worksheet Line", var Result: Boolean)

Parameters

Name	Type	Description
PriceWorksheetLine	Table Microsoft.Pricing.Worksheet."Price Worksheet Line"
Result	Boolean

See also

• Table