Table 7022 Price Worksheet Line in 28

App
Base Application
Namespace
Microsoft.Pricing.Worksheet

Fields, 41Keys, 2Procedures, 20Events, 9

Versions171819202122232425262728latest

Source29

Fields, 41

IdNameTypeObsolete
1Price List CodeCode[20]-
2Line No.Integer-
3Source TypeEnum Price Source Type-
4Source No.Code[20]-
5Parent Source No.Code[20]-
6Source IDGuid-
7Asset TypeEnum Price Asset Type-
8Asset No.Code[20]-
9Variant CodeCode[10]-
10Currency CodeCode[10]-
11Work Type CodeCode[10]-
12Starting DateDate-
13Ending DateDate-
14Minimum QuantityDecimal-
15Unit of Measure CodeCode[10]-
16Amount TypeEnum Price Amount Type-
17Unit PriceDecimal-
18Cost FactorDecimal-
19Unit CostDecimal-
20Line Discount %Decimal-
21Allow Line Disc.Boolean-
22Allow Invoice Disc.Boolean-
23Price Includes VATBoolean-
24VAT Bus. Posting Gr. (Price)Code[20]-
25VAT Prod. Posting GroupCode[20]-
26Asset IDGuid-
27Line AmountDecimal-
28Price TypeEnum Price Type-
29DescriptionText[100]-
30StatusEnum Price Status-
31Direct Unit CostDecimal-
32Source GroupEnum Price Source Group-
33Product No.Code[20]-
34Assign-to No.Code[20]-
35Assign-to Parent No.Code[20]-
36Variant Code LookupCode[10]-
37Unit of Measure Code LookupCode[10]-
100Existing LineBoolean-
101Existing Unit PriceDecimal-
102Existing Direct Unit CostDecimal-
103Existing Unit CostDecimal-

Keys, 2

NameFieldsObsolete
PK, clusteredPrice List Code, Existing Line, Line No.-
Key1Price Type, Source Group-

Procedures, 20

NameParametersReturnsAccessObsolete
IsAssetItem()Booleanpublic-
IsAssetResource()Booleanpublic-
IsEditable()Booleanpublic-
IsHeaderActive()Booleanpublic-
IsLineToVerify()Booleanpublic-
IsUOMSupported()Booleanpublic-
IsAmountMandatory(Enum Price Amount Type)Booleanpublic-
IsAmountSupported()Booleanpublic-
IsRealLine()Booleanpublic-
IsSourceNoAllowed()Booleanpublic-
CopyExistingPrices(Record Price List Line)public-
CopySourceFrom(Record Price List Header)public-
CopyFrom(Record Price List Header)public-
CopyFrom(Record Price Asset)public-
SetNewRecord(Boolean)public-
CopyTo(var Record Price Asset)public-
CopyTo(var Record Price Source)public-
Verify()Booleanpublic-
TryVerify()Booleanpublic-
SyncDropDownLookupFields()public-

Events, 9

KindNameParametersObsolete
Integration eventOnAfterCopyFromPriceListHeader(Record Price List Header)-
Integration eventOnAfterCopyFromPriceSource(Record Price Source)-
Integration eventOnAfterCopyToPriceAsset(var Record Price Asset)-
Integration eventOnAfterCopyToPriceSource(var Record Price Source)-
Integration eventOnAfterInitHeaderDefaults(Record Price List Header)-
Integration eventOnAfterCopyExistingPrices(var Record Price Worksheet Line, Record Price List Line)-
Integration eventOnAfterIsUOMSupported(Record Price Worksheet Line, var Boolean)-
Integration eventOnAfterCopyFromPriceAsset(Record Price Asset, var Record Price Worksheet Line)-
Integration eventOnAfterCopySourceFrom(var Record Price Worksheet Line, Record Price List Header)-