Table 5367 CRM Account Statistics, source in 29
Source29
src/Layers/W1/BaseApp/Integration/D365Sales/CRMAccountStatistics.Table.al476 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------
// Copyright (c) Microsoft Corporation. All rights reserved.
// Licensed under the MIT License. See License.txt in the project root for license information.
// ------------------------------------------------------------------------------------------------
namespace Microsoft.Integration.D365Sales;
table 5367 "CRM Account Statistics"
{
Caption = 'CRM Account Statistics';
Description = 'An entity to store aggregate statistics from Dynamics NAV about an account.';
ExternalName = 'nav_accountstatistics';
TableType = CRM;
DataClassification = CustomerContent;
fields
{
field(1; AccountStatisticsId; Guid)
{
Caption = 'Account Statistics';
Description = 'Unique identifier for entity instances';
ExternalAccess = Insert;
ExternalName = 'nav_accountstatisticsid';
ExternalType = 'Uniqueidentifier';
}
field(2; CreatedOn; DateTime)
{
Caption = 'Created On';
Description = 'Date and time when the record was created.';
ExternalAccess = Read;
ExternalName = 'createdon';
ExternalType = 'DateTime';
}
field(3; CreatedBy; Guid)
{
Caption = 'Created By';
Description = 'Unique identifier of the user who created the record.';
ExternalAccess = Read;
ExternalName = 'createdby';
ExternalType = 'Lookup';
TableRelation = "CRM Systemuser".SystemUserId;
}
field(4; ModifiedOn; DateTime)
{
Caption = 'Modified On';
Description = 'Date and time when the record was modified.';
ExternalAccess = Read;
ExternalName = 'modifiedon';
ExternalType = 'DateTime';
}
field(5; ModifiedBy; Guid)
{
Caption = 'Modified By';
Description = 'Unique identifier of the user who modified the record.';
ExternalAccess = Read;
ExternalName = 'modifiedby';
ExternalType = 'Lookup';
TableRelation = "CRM Systemuser".SystemUserId;
}
field(6; CreatedOnBehalfBy; Guid)
{
Caption = 'Created By (Delegate)';
Description = 'Unique identifier of the delegate user who created the record.';
ExternalAccess = Read;
ExternalName = 'createdonbehalfby';
ExternalType = 'Lookup';
TableRelation = "CRM Systemuser".SystemUserId;
}
field(7; ModifiedOnBehalfBy; Guid)
{
Caption = 'Modified By (Delegate)';
Description = 'Unique identifier of the delegate user who modified the record.';
ExternalAccess = Read;
ExternalName = 'modifiedonbehalfby';
ExternalType = 'Lookup';
TableRelation = "CRM Systemuser".SystemUserId;
}
field(8; CreatedByName; Text[200])
{
CalcFormula = lookup("CRM Systemuser".FullName where(SystemUserId = field(CreatedBy)));
Caption = 'CreatedByName';
ExternalAccess = Read;
ExternalName = 'createdbyname';
ExternalType = 'String';
FieldClass = FlowField;
}
field(9; CreatedOnBehalfByName; Text[200])
{
CalcFormula = lookup("CRM Systemuser".FullName where(SystemUserId = field(CreatedOnBehalfBy)));
Caption = 'CreatedOnBehalfByName';
ExternalAccess = Read;
ExternalName = 'createdonbehalfbyname';
ExternalType = 'String';
FieldClass = FlowField;
}
field(10; ModifiedByName; Text[200])
{
CalcFormula = lookup("CRM Systemuser".FullName where(SystemUserId = field(ModifiedBy)));
Caption = 'ModifiedByName';
ExternalAccess = Read;
ExternalName = 'modifiedbyname';
ExternalType = 'String';
FieldClass = FlowField;
}
field(11; ModifiedOnBehalfByName; Text[200])
{
CalcFormula = lookup("CRM Systemuser".FullName where(SystemUserId = field(ModifiedOnBehalfBy)));
Caption = 'ModifiedOnBehalfByName';
ExternalAccess = Read;
ExternalName = 'modifiedonbehalfbyname';
ExternalType = 'String';
FieldClass = FlowField;
}
field(12; OrganizationId; Guid)
{
Caption = 'Organization Id';
Description = 'Unique identifier for the organization';
ExternalAccess = Read;
ExternalName = 'organizationid';
ExternalType = 'Lookup';
TableRelation = "CRM Organization".OrganizationId;
}
field(13; OrganizationIdName; Text[160])
{
CalcFormula = lookup("CRM Organization".Name where(OrganizationId = field(OrganizationId)));
Caption = 'OrganizationIdName';
ExternalAccess = Read;
ExternalName = 'organizationidname';
ExternalType = 'String';
FieldClass = FlowField;
}
field(14; statecode; Option)
{
Caption = 'Status';
Description = 'Status of the Account Statistics';
ExternalAccess = Modify;
ExternalName = 'statecode';
ExternalType = 'State';
InitValue = " ";
OptionCaption = ' ,Active,Inactive';
OptionOrdinalValues = -1, 0, 1;
OptionMembers = " ",Active,Inactive;
}
field(15; statuscode; Option)
{
Caption = 'Status Reason';
Description = 'Reason for the status of the Account Statistics';
ExternalName = 'statuscode';
ExternalType = 'Status';
InitValue = " ";
OptionCaption = ' ,Active,Inactive';
OptionOrdinalValues = -1, 1, 2;
OptionMembers = " ",Active,Inactive;
}
field(16; VersionNumber; BigInteger)
{
Caption = 'VersionNumber';
ExternalAccess = Read;
ExternalName = 'versionnumber';
ExternalType = 'BigInt';
}
field(17; ImportSequenceNumber; Integer)
{
Caption = 'Import Sequence Number';
Description = 'Sequence number of the import that created this record.';
ExternalAccess = Insert;
ExternalName = 'importsequencenumber';
ExternalType = 'Integer';
}
field(18; OverriddenCreatedOn; Date)
{
Caption = 'Record Created On';
Description = 'Date and time that the record was migrated.';
ExternalAccess = Insert;
ExternalName = 'overriddencreatedon';
ExternalType = 'DateTime';
}
field(19; TimeZoneRuleVersionNumber; Integer)
{
Caption = 'Time Zone Rule Version Number';
Description = 'For internal use only.';
ExternalName = 'timezoneruleversionnumber';
ExternalType = 'Integer';
MinValue = -1;
}
field(20; UTCConversionTimeZoneCode; Integer)
{
Caption = 'UTC Conversion Time Zone Code';
Description = 'Time zone code that was in use when the record was created.';
ExternalName = 'utcconversiontimezonecode';
ExternalType = 'Integer';
MinValue = -1;
}
field(21; Name; Text[160])
{
Caption = 'Account Name';
ExternalName = 'nav_name';
ExternalType = 'String';
}
field(22; "Customer No"; Text[20])
{
Caption = 'Customer No.';
Description = 'Dynamics NAV Customer Number';
ExternalName = 'nav_customerno';
ExternalType = 'String';
}
field(23; "Balance (LCY)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Balance (LCY)';
Description = 'Account Balance at the last known date';
ExternalName = 'nav_balancelcy';
ExternalType = 'Money';
}
field(24; TransactionCurrencyId; Guid)
{
Caption = 'Currency';
Description = 'Unique identifier of the currency associated with the entity.';
ExternalName = 'transactioncurrencyid';
ExternalType = 'Lookup';
TableRelation = "CRM Transactioncurrency".TransactionCurrencyId;
}
field(25; TransactionCurrencyIdName; Text[100])
{
CalcFormula = lookup("CRM Transactioncurrency".CurrencyName where(TransactionCurrencyId = field(TransactionCurrencyId)));
Caption = 'TransactionCurrencyIdName';
ExternalAccess = Read;
ExternalName = 'transactioncurrencyidname';
ExternalType = 'String';
FieldClass = FlowField;
}
field(26; ExchangeRate; Decimal)
{
AutoFormatType = 0;
Caption = 'Exchange Rate';
Description = 'Exchange rate for the currency associated with the entity with respect to the base currency.';
ExternalAccess = Read;
ExternalName = 'exchangerate';
ExternalType = 'Decimal';
}
field(27; "Balance (Base)"; Decimal)
{
AutoFormatType = 0;
Caption = 'Balance (LCY) (Base)';
Description = 'Value of the Balance (LCY) in base currency.';
ExternalAccess = Read;
ExternalName = 'nav_balancelcy_base';
ExternalType = 'Money';
}
field(28; "Outstanding Orders (LCY)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Outstanding Orders (LCY)';
Description = '';
ExternalName = 'nav_outstandingorderslcy';
ExternalType = 'Money';
}
field(29; "Outstanding Orders (Base)"; Decimal)
{
AutoFormatType = 0;
Caption = 'Outstanding Orders (LCY) (Base)';
Description = 'Value of the Outstanding Orders (LCY) in base currency.';
ExternalAccess = Read;
ExternalName = 'nav_outstandingorderslcy_base';
ExternalType = 'Money';
}
field(30; "Shipped Not Invoiced (LCY)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Shipped Not Invd. (LCY)';
Description = '';
ExternalName = 'nav_shippednotinvoicedlcy';
ExternalType = 'Money';
}
field(31; "Shipped Not Invoiced (Base)"; Decimal)
{
AutoFormatType = 0;
Caption = 'Shipped Not Invd. (LCY) (Base)';
Description = 'Value of the Shipped Not Invd. (LCY) in base currency.';
ExternalAccess = Read;
ExternalName = 'nav_shippednotinvoicedlcy_base';
ExternalType = 'Money';
}
field(32; "Outstanding Invoices (LCY)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Outstanding Invoices (LCY)';
Description = '';
ExternalName = 'nav_outstandinginvoiceslcy';
ExternalType = 'Money';
}
field(33; "Outstanding Invoices (Base)"; Decimal)
{
AutoFormatType = 0;
Caption = 'Outstanding Invoices (LCY) (Base)';
Description = 'Value of the Outstanding Invoices (LCY) in base currency.';
ExternalAccess = Read;
ExternalName = 'nav_outstandinginvoiceslcy_base';
ExternalType = 'Money';
}
field(34; "Outstanding Serv Orders (LCY)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Outstanding Serv. Orders (LCY)';
Description = '';
ExternalName = 'nav_outstandingserviceorderslcy';
ExternalType = 'Money';
}
field(35; "Outstanding Serv Orders (Base)"; Decimal)
{
AutoFormatType = 0;
Caption = 'Outstanding Serv. Orders (LCY) (Base)';
Description = 'Value of the Outstanding Serv. Orders (LCY) in base currency.';
ExternalAccess = Read;
ExternalName = 'nav_outstandingserviceorderslcy_base';
ExternalType = 'Money';
}
field(36; "Serv Shipped Not Invd (LCY)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Serv. Shipped Not Invd. (LCY)';
Description = '';
ExternalName = 'nav_servshippednotinvoicedlcy';
ExternalType = 'Money';
}
field(37; "Serv Shipped Not Invd (Base)"; Decimal)
{
AutoFormatType = 0;
Caption = 'Serv. Shipped Not Invd. (LCY) (Base)';
Description = 'Value of the Serv. Shipped Not Invd. (LCY) in base currency.';
ExternalAccess = Read;
ExternalName = 'nav_servshippednotinvoicedlcy_base';
ExternalType = 'Money';
}
field(38; "Outstd Serv Invoices (LCY)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Outstanding Serv. Invoices (LCY)';
Description = '';
ExternalName = 'nav_outstandingservinvoiceslcy';
ExternalType = 'Money';
}
field(39; "Outstd Serv Invoices (Base)"; Decimal)
{
AutoFormatType = 0;
Caption = 'Outstanding Serv. Invoices (LCY) (Base)';
Description = 'Value of the Outstanding Serv. Invoices (LCY) in base currency.';
ExternalAccess = Read;
ExternalName = 'nav_outstandingservinvoiceslcy_base';
ExternalType = 'Money';
}
field(40; "Total (LCY)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Total (LCY)';
Description = '';
ExternalName = 'nav_totallcy';
ExternalType = 'Money';
}
field(41; "Total (Base)"; Decimal)
{
AutoFormatType = 0;
Caption = 'Total (LCY) (Base)';
Description = 'Value of the Total (LCY) in base currency.';
ExternalAccess = Read;
ExternalName = 'nav_totallcy_base';
ExternalType = 'Money';
}
field(42; "Credit Limit (LCY)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Credit Limit (LCY)';
Description = '';
ExternalName = 'nav_creditlimitlcy';
ExternalType = 'Money';
}
field(43; "Credit Limit (Base)"; Decimal)
{
AutoFormatType = 0;
Caption = 'Credit Limit (LCY) (Base)';
Description = 'Value of the Credit Limit (LCY) in base currency.';
ExternalAccess = Read;
ExternalName = 'nav_creditlimitlcy_base';
ExternalType = 'Money';
}
field(44; "Overdue Amounts (LCY)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Overdue Amounts (LCY)';
Description = '';
ExternalName = 'nav_overdueamountslcy';
ExternalType = 'Money';
}
field(45; "Overdue Amounts (Base)"; Decimal)
{
AutoFormatType = 0;
Caption = 'Overdue Amounts (LCY) (Base)';
Description = 'Value of the Overdue Amounts (LCY) in base currency.';
ExternalAccess = Read;
ExternalName = 'nav_overdueamountslcy_base';
ExternalType = 'Money';
}
field(46; "Overdue Amounts As Of Date"; Date)
{
Caption = 'Overdue Amounts as of';
Description = 'The date as of which the Overdue Amounts (LCY) are measured.';
ExternalName = 'nav_overdueamountsasof';
ExternalType = 'DateTime';
}
field(47; "Total Sales (LCY)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Total Sales (LCY)';
Description = '';
ExternalName = 'nav_totalsaleslcy';
ExternalType = 'Money';
}
field(48; "Total Sales (Base)"; Decimal)
{
AutoFormatType = 0;
Caption = 'Total Sales (LCY) (Base)';
Description = 'Value of the Total Sales (LCY) in base currency.';
ExternalAccess = Read;
ExternalName = 'nav_totalsaleslcy_base';
ExternalType = 'Money';
}
field(49; "Invd Prepayment Amount (LCY)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Invoiced Prepayment Amount (LCY)';
Description = '';
ExternalName = 'nav_invoicedprepaymentamountlcy';
ExternalType = 'Money';
}
field(50; "Invd Prepayment Amount (Base)"; Decimal)
{
AutoFormatType = 0;
Caption = 'Invoiced Prepayment Amount (LCY) (Base)';
Description = 'Value of the Invoiced Prepayment Amount (LCY) in base currency.';
ExternalAccess = Read;
ExternalName = 'nav_invoicedprepaymentamountlcy_base';
ExternalType = 'Money';
}
}
keys
{
key(Key1; AccountStatisticsId)
{
Clustered = true;
}
key(Key2; Name)
{
}
}
fieldgroups
{
fieldgroup(DropDown; Name)
{
}
}
}