Objects/Tables/Table 7023 Sales Price Worksheet
Table 7023 Sales Price Worksheet in 17
Jonas Paprotka, Base Application 17.5.22499.32099, checked
- App
- Base Application
- Obsolete
- Pending 16.0. Replaced by the new implementation (V16) of price calculation.
Fields, 17Keys, 2Procedures, 2Events, 3
Versions171819202122232425262728latest
Source29
Fields, 17
| Id | Name | Type | Obsolete |
|---|
| 1 | Item No. | Code[20] | - |
| 2 | Sales Code | Code[20] | - |
| 3 | Currency Code | Code[10] | - |
| 4 | Starting Date | Date | - |
| 5 | Current Unit Price | Decimal | - |
| 6 | New Unit Price | Decimal | - |
| 7 | Price Includes VAT | Boolean | - |
| 10 | Allow Invoice Disc. | Boolean | - |
| 11 | VAT Bus. Posting Gr. (Price) | Code[20] | - |
| 13 | Sales Type | Enum Sales Price Type | - |
| 14 | Minimum Quantity | Decimal | - |
| 15 | Ending Date | Date | - |
| 20 | Item Description | Text[100] | - |
| 21 | Sales Description | Text[100] | - |
| 5400 | Unit of Measure Code | Code[10] | - |
| 5700 | Variant Code | Code[10] | - |
| 7001 | Allow Line Disc. | Boolean | - |
Keys, 2
| Name | Fields | Obsolete |
|---|
| Key1, clustered | Starting Date, Ending Date, Sales Type, Sales Code, Currency Code, Item No., Variant Code, Unit of Measure Code, Minimum Quantity | - |
| Key2 | Item No., Variant Code, Unit of Measure Code, Minimum Quantity, Starting Date, Ending Date, Sales Type, Sales Code, Currency Code | - |
Procedures, 2
| Name | Parameters | Returns | Access | Obsolete |
|---|
| CalcCurrentPrice | (var Boolean) | | public | - |
| SetSalesDescription | () | | public | - |
Events, 3
| Kind | Name | Parameters | Obsolete |
|---|
| Integration event | OnAfterCalcCurrentPriceFound | (var Record Sales Price Worksheet, Record Sales Price) | - |
| Integration event | OnCalcCurrentPriceOnAfterSetFilters | (var Record Sales Price, Record Sales Price Worksheet) | - |
| Integration event | OnCalcCurrentPriceOnPriceNotFound | (var Record Sales Price Worksheet) | - |