Table 7022 Price Worksheet Line

Base Application, Microsoft.Pricing.Worksheet

41 fields

IdNameTypeVersions
1Price List CodeCode[20]new in 18
2Line No.Integernew in 18
3Source TypeEnum "Price Source Type"new in 18
4Source No.Code[20]new in 18
5Parent Source No.Code[20]new in 18
6Source IDGuidnew in 18
7Asset TypeEnum "Price Asset Type"new in 18
8Asset No.Code[20]new in 18
9Variant CodeCode[10]new in 18
10Currency CodeCode[10]new in 18
11Work Type CodeCode[10]new in 18
12Starting DateDatenew in 18
13Ending DateDatenew in 18
14Minimum QuantityDecimalnew in 18
15Unit of Measure CodeCode[10]new in 18
16Amount TypeEnum "Price Amount Type"new in 18
17Unit PriceDecimalnew in 18
18Cost FactorDecimalnew in 18
19Unit CostDecimalnew in 18
20Line Discount %Decimalnew in 18
21Allow Line Disc.Booleannew in 18
22Allow Invoice Disc.Booleannew in 18
23Price Includes VATBooleannew in 18
24VAT Bus. Posting Gr. (Price)Code[20]new in 18
25VAT Prod. Posting GroupCode[20]new in 18
26Asset IDGuidnew in 18
27Line AmountDecimalnew in 18
28Price TypeEnum "Price Type"new in 18
29DescriptionText[100]new in 18
30StatusEnum "Price Status"new in 18
31Direct Unit CostDecimalnew in 18
32Source GroupEnum "Price Source Group"new in 18
33Product No.Code[20]new in 20
34Assign-to No.Code[20]new in 20
35Assign-to Parent No.Code[20]new in 20
36Variant Code LookupCode[10]new in 20
37Unit of Measure Code LookupCode[10]new in 20
100Existing LineBooleannew in 18
101Existing Unit PriceDecimalnew in 18
102Existing Direct Unit CostDecimalnew in 18
103Existing Unit CostDecimalnew in 18