Objects/Tables/Table 7002 Sales Price
Table 7002 Sales Price 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, 14Keys, 3Procedures, 1Events, 3
Versions171819202122232425262728latest
Source29
Fields, 14
| Id | Name | Type | Obsolete |
|---|
| 1 | Item No. | Code[20] | - |
| 2 | Sales Code | Code[20] | - |
| 3 | Currency Code | Code[10] | - |
| 4 | Starting Date | Date | - |
| 5 | 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 | - |
| 5400 | Unit of Measure Code | Code[10] | - |
| 5700 | Variant Code | Code[10] | - |
| 7001 | Allow Line Disc. | Boolean | - |
Keys, 3
| Name | Fields | Obsolete |
|---|
| Key1, clustered | Item No., Sales Type, Sales Code, Starting Date, Currency Code, Variant Code, Unit of Measure Code, Minimum Quantity | - |
| Key2 | Sales Type, Sales Code, Item No., Starting Date, Currency Code, Variant Code, Unit of Measure Code, Minimum Quantity | - |
| Key3 | SystemModifiedAt | - |
Procedures, 1
| Name | Parameters | Returns | Access | Obsolete |
|---|
| CopySalesPriceToCustomersSalesPrice | (var Record Sales Price, Code[20]) | | public | - |
Events, 3
| Kind | Name | Parameters | Obsolete |
|---|
| Integration event | OnBeforeItemNoOnValidate | (var Record Sales Price, var Record Sales Price, var Boolean) | - |
| Integration event | OnBeforeNewSalesPriceInsert | (var Record Sales Price, Record Sales Price) | - |
| Integration event | OnValidateSalesCodeOnAfterGetCustomerPriceGroup | (var Record Sales Price, Record Customer Price Group) | - |