Table 7023 Sales Price Worksheet

Base Application, Microsoft.Sales.Pricing

Source AL, 405 lines

src/Layers/W1/BaseApp/Sales/Pricing/SalesPriceWorksheet.Table.allines 16 to 31 of 405, Copyright (c) Microsoft Corporation. MIT

table 7023 "Sales Price Worksheet"{    Caption = 'Sales Price Worksheet';    DataClassification = CustomerContent;    fields    {        /// <summary>        /// Specifies the item that the worksheet price entry applies to.        /// </summary>        field(1; "Item No."; Code[20])        {            Caption = 'Item No.';            ToolTip = 'Specifies the number of the item for which sales prices are being changed or set up.';            NotBlank = true;            TableRelation = Item;

All 405 lines

Fields 17 in 29

1Item No.Code[20]17-29
2Sales CodeCode[20]17-29
3Currency CodeCode[10]17-29
4Starting DateDate17-29
5Current Unit PriceDecimal17-29
6New Unit PriceDecimal17-29
7Price Includes VATBoolean17-29
10Allow Invoice Disc.Boolean17-29
11VAT Bus. Posting Gr. (Price)Code[20]17-29

All 17 fields

Events 3 in 29

[IntegrationEvent] OnAfterCalcCurrentPriceFound(var SalesPriceWorksheet: Record "Sales Price Worksheet"; SalesPrice: Record "Sales Price")17-29
[IntegrationEvent] OnCalcCurrentPriceOnAfterSetFilters(var SalesPrice: Record "Sales Price"; SalesPriceWorksheet: Record "Sales Price Worksheet")17-29
[IntegrationEvent] OnCalcCurrentPriceOnPriceNotFound(var SalesPriceWorksheet: Record "Sales Price Worksheet")17-29

Public procedures 2 in 29

CalcCurrentPrice(var PriceAlreadyExists: Boolean)17-29
SetSalesDescription()17-29

Trigger events 10

OnBeforeInsertEvent(var Rec: Record "Sales Price Worksheet"; RunTrigger: Boolean)
OnAfterInsertEvent(var Rec: Record "Sales Price Worksheet"; RunTrigger: Boolean)
OnBeforeModifyEvent(var Rec: Record "Sales Price Worksheet"; var xRec: Record "Sales Price Worksheet"; RunTrigger: Boolean)
OnAfterModifyEvent(var Rec: Record "Sales Price Worksheet"; var xRec: Record "Sales Price Worksheet"; RunTrigger: Boolean)
OnBeforeDeleteEvent(var Rec: Record "Sales Price Worksheet"; RunTrigger: Boolean)
OnAfterDeleteEvent(var Rec: Record "Sales Price Worksheet"; RunTrigger: Boolean)
OnBeforeRenameEvent(var Rec: Record "Sales Price Worksheet"; var xRec: Record "Sales Price Worksheet"; RunTrigger: Boolean)
OnAfterRenameEvent(var Rec: Record "Sales Price Worksheet"; var xRec: Record "Sales Price Worksheet"; RunTrigger: Boolean)
OnBeforeValidateEvent(var Rec: Record "Sales Price Worksheet"; var xRec: Record "Sales Price Worksheet"; CurrFieldNo: Integer)
per field, ElementName: field name
OnAfterValidateEvent(var Rec: Record "Sales Price Worksheet"; var xRec: Record "Sales Price Worksheet"; CurrFieldNo: Integer)
per field, ElementName: field name

Changes 1 in 28

List17181920212223242526272829
Object1
table 7023 "Sales Price Worksheet"17-29
no longer obsolete

All 1 changes in 17-29