Table 5310 Item Statistics Cache

Base Application, Microsoft.Inventory.Analysis

Source AL, 256 lines

src/Layers/W1/BaseApp/Inventory/Analysis/ItemStatisticsCache.Table.allines 10 to 25 of 256, Copyright (c) Microsoft Corporation. MIT

table 5310 "Item Statistics Cache"{    Caption = 'Item Statistics Cache';    DataClassification = CustomerContent;    ReplicateData = false;    InherentEntitlements = RIMD;    InherentPermissions = RIMD;    DataCaptionFields = "Item No.", Description;    fields    {        field(1; "Item No."; Code[20])        {        }        field(22; Description; Text[100])

All 256 lines

Fields 22 in 29

1Item No.Code[20]17-25, 28-29
2ItemLedgerEntryNoLatestInteger17-25, 28-29
3ValueEntryNoLatestInteger17-25, 28-29
4LastUpdatedDate17-25, 28-29
5CurrentInventoryValueDecimal17-25, 28-29
6ExpiredStockValueDecimalnew in 28
7SalesGrowthRateThisPeriodDecimalnew in 28
8NetSalesLCYThisPeriodDecimalnew in 28
9GrossMarginThisPeriodDecimalnew in 28

All 22 fields

Public procedures 3 in 29

InitAndInsert(ItemNo: Code[20])new in 28
Pending, tag 29.0, obsolete since 28: Use InitAndInsert with ItemNo and ItemDescription parameters instead.
InitAndInsert(ItemNo: Code[20]; ItemDescription: Text[100])new in 28
UpdateIfNeeded(Item: Record Item; CurrentDate: Date; ItemDateFilters: array[4] of Text[30]; PriorPeriodItemDateFilters: array[4] of Text[30])new in 28

All 5 procedures in 17-25, 28-29

Trigger events 10

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

Changes 28 in 28

List17181920212223242526272829
Object111
Fields22
Keys2
Procedures23
table 5310 "Item Statistics Cache"17-25, 28-29
no longer obsolete, was table 5310 "Outlook Synch. Setup Detail"
field(1; "Item No."; Code[20])17-25, 28-29
changed, was field(1; "User ID"; Code[50])
field(2; ItemLedgerEntryNoLatest; Integer)17-25, 28-29
changed, was field(2; "Synch. Entity Code"; Code[10])
field(3; ValueEntryNoLatest; Integer)17-25, 28-29
changed, was field(3; "Element No."; Integer)
field(4; LastUpdated; Date)17-25, 28-29
changed, was field(4; "Outlook Collection"; Text[80])
field(5; CurrentInventoryValue; Decimal)17-25, 28-29
changed, was field(5; "Table No."; Integer)

All 32 changes in 17-25, 28-29