Objects/Tables/Table 7002 Sales Price
Table 7002 Sales Price in 28
Jonas Paprotka, Base Application 28.5.54151.54365, checked
- App
- Base Application
- Namespace
- Microsoft.Sales.Pricing
Fields, 16Keys, 3Procedures, 1Events, 3
Versions171819202122232425262728latest
Source29
Fields, 16
| 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 | - |
| 720 | Coupled to CRM | Boolean | Removed 26.0 |
| Replaced by flow field Coupled to Dataverse |
| 721 | Coupled to Dataverse | Boolean | - |
| 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) | - |