Table "Item Analysis View"
Properties
| Name | Value |
|---|---|
| Caption | Item Analysis View |
| DataCaptionFields | 1,2,3 |
| LookupPageID | Page Microsoft.Inventory.Analysis."Item Analysis View List" |
| Permissions | TableData "Item Analysis View Entry" = rimd, TableData "Item Analysis View Budg. Entry" = rimd |
| DataClassification | CustomerContent |
Fields
| Name | Type | Description |
|---|---|---|
| "Analysis Area" | Enum Microsoft.Inventory.Analysis."Analysis Area Type" | |
| Code | Code[10] | Specifies a code for the analysis view. |
| Name | Text[50] | Specifies the name of the analysis view. |
| "Last Entry No." | Integer | Specifies the number of the last item ledger entry you posted, prior to updating the analysis view. |
| "Last Budget Entry No." | Integer | Specifies the number of the last item budget entry you entered prior to updating the analysis view. |
| "Last Date Updated" | Date | Specifies the date on which the analysis view was last updated. |
| "Update on Posting" | Boolean | Specifies if the analysis view is updated every time that you post an item ledger entry, for example from a sales invoice. |
| Blocked | Boolean | Specifies that the related record is blocked from being posted in transactions, for example a customer that is declared insolvent or an item that is placed in quarantine. |
| "Item Filter" | Code[250] | Specifies a filter to specify the items that will be included in an analysis view. |
| "Location Filter" | Code[250] | Specifies a location filter to specify that only entries posted to a particular location are to be included in an analysis view. |
| "Starting Date" | Date | Specifies the date from which item ledger entries will be included in an analysis view. |
| "Date Compression" | Option | Specifies the period that the program will combine entries for, in order to create a single entry for that time period. |
| "Dimension 1 Code" | Code[20] | Specifies one of the four dimensions that you can include in an analysis view. |
| "Dimension 2 Code" | Code[20] | Specifies one of the four dimensions that you can include in an analysis view. |
| "Dimension 3 Code" | Code[20] | Specifies one of the four dimensions that you can include in an analysis view. |
| "Include Budgets" | Boolean | Specifies whether to include an update of analysis view budget entries, when updating an analysis view. |
| "Refresh When Unblocked" | Boolean | |
| SystemId | Guid | |
| SystemCreatedAt | DateTime | |
| SystemCreatedBy | Guid | |
| SystemModifiedAt | DateTime | |
| SystemModifiedBy | Guid | |
| SystemCreatedByUserName | Text[50] | |
| SystemCreatedByFullName | Text[80] | |
| SystemModifiedByUserName | Text[50] | |
| SystemModifiedByFullName | Text[80] | |
| SystemRowVersion | BigInteger |
Methods
ItemAnalysisViewReset
procedure ItemAnalysisViewReset()CheckDimensionsAreRetained
procedure CheckDimensionsAreRetained(ObjectType: Integer; ObjectID: Integer; OnlyIfIncludeBudgets: Boolean)Parameters
| Name | Type | Description |
|---|---|---|
| ObjectType | Integer | |
| ObjectID | Integer | |
| OnlyIfIncludeBudgets | Boolean |
CheckViewsAreUpdated
procedure CheckViewsAreUpdated()ValidateDelete
procedure ValidateDelete(FieldName: Text)Parameters
| Name | Type | Description |
|---|---|---|
| FieldName | Text |
CopyAnalysisViewFilters
procedure CopyAnalysisViewFilters(ObjectType: Integer; ObjectID: Integer; AnalysisArea: Integer; AnalysisViewCode: Code[10])Parameters
| Name | Type | Description |
|---|---|---|
| ObjectType | Integer | |
| ObjectID | Integer | |
| AnalysisArea | Integer | |
| AnalysisViewCode | Code[10] |
SetUpdateOnPosting
procedure SetUpdateOnPosting(NewUpdateOnPosting: Boolean)Parameters
| Name | Type | Description |
|---|---|---|
| NewUpdateOnPosting | Boolean |