Table 5348 CRM Product
src/Layers/W1/BaseApp/Integration/D365Sales/CRMProduct.Table.al566 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 5348 "CRM Product"{ // Dynamics CRM Version: 7.1.0.2040 Caption = 'CRM Product'; Description = 'Information about products and their pricing information.'; ExternalName = 'product'; TableType = CRM; DataClassification = CustomerContent; fields { field(1; ProductId; Guid) { Caption = 'Product'; Description = 'Unique identifier of the product.'; ExternalAccess = Insert; ExternalName = 'productid'; ExternalType = 'Uniqueidentifier'; } field(2; DefaultUoMScheduleId; Guid) { Caption = 'Unit Group'; Description = 'Default unit group for the product.'; ExternalName = 'defaultuomscheduleid'; ExternalType = 'Lookup'; TableRelation = "CRM Uomschedule".UoMScheduleId; } field(3; OrganizationId; Guid) { Caption = 'Organization'; Description = 'Unique identifier of the organization associated with the product.'; ExternalAccess = Read; ExternalName = 'organizationid'; ExternalType = 'Lookup'; TableRelation = "CRM Organization".OrganizationId; } field(4; Name; Text[100]) { Caption = 'Name'; ToolTip = 'Specifies the name of the record.'; Description = 'Name of the product.'; ExternalName = 'name'; ExternalType = 'String'; } field(5; DefaultUoMId; Guid) { Caption = 'Default Unit'; Description = 'Default unit for the product.'; ExternalName = 'defaultuomid'; ExternalType = 'Lookup'; TableRelation = "CRM Uom".UoMId; } field(6; PriceLevelId; Guid) { Caption = 'Default Price List'; Description = 'Select the default price list for the product.'; ExternalAccess = Modify; ExternalName = 'pricelevelid'; ExternalType = 'Lookup'; TableRelation = "CRM Pricelevel".PriceLevelId; } field(7; Description; BLOB) { Caption = 'Description'; Description = 'Description of the product.'; ExternalName = 'description'; ExternalType = 'Memo'; SubType = Memo; } field(8; ProductTypeCode; Option) { Caption = 'Product Type'; Description = 'Type of product.'; ExternalName = 'producttypecode'; ExternalType = 'Picklist'; InitValue = SalesInventory; OptionCaption = 'Sales Inventory,Miscellaneous Charges,Services,Flat Fees'; OptionOrdinalValues = 1, 2, 3, 4; OptionMembers = SalesInventory,MiscellaneousCharges,Services,FlatFees; } field(9; ProductUrl; Text[250]) { Caption = 'URL'; Description = 'URL for the Website associated with the product.'; ExtendedDatatype = URL; ExternalName = 'producturl'; ExternalType = 'String'; } field(10; Price; Decimal) { AutoFormatType = 0; Caption = 'List Price'; ToolTip = 'Specifies information related to the Dynamics 365 Sales connection.'; Description = 'List price of the product.'; ExternalName = 'price'; ExternalType = 'Money'; } field(11; IsKit; Boolean) { Caption = 'Is Kit'; Description = 'Information that specifies whether the product is a kit.'; ExternalName = 'iskit'; ExternalType = 'Boolean'; } field(12; ProductNumber; Text[100]) { Caption = 'Product ID'; ToolTip = 'Specifies information related to the Dynamics 365 Sales connection.'; Description = 'User-defined product ID.'; ExternalName = 'productnumber'; ExternalType = 'String'; } field(13; Size; Text[200]) { Caption = 'Size'; Description = 'Product size.'; ExternalName = 'size'; ExternalType = 'String'; } field(14; CurrentCost; Decimal) { AutoFormatType = 0; Caption = 'Current Cost'; ToolTip = 'Specifies the item''s unit cost.'; Description = 'Current cost for the product item. Used in price calculations.'; ExternalName = 'currentcost'; ExternalType = 'Money'; } field(15; StockVolume; Decimal) { AutoFormatType = 0; Caption = 'Stock Volume'; Description = 'Stock volume of the product.'; ExternalName = 'stockvolume'; ExternalType = 'Decimal'; } field(16; StandardCost; Decimal) { AutoFormatType = 0; Caption = 'Standard Cost'; ToolTip = 'Specifies information related to the Dynamics 365 Sales connection.'; Description = 'Standard cost of the product.'; ExternalName = 'standardcost'; ExternalType = 'Money'; } field(17; StockWeight; Decimal) { AutoFormatType = 0; Caption = 'Stock Weight'; Description = 'Stock weight of the product.'; ExternalName = 'stockweight'; ExternalType = 'Decimal'; } field(18; QuantityDecimal; Integer) { Caption = 'Decimals Supported'; Description = 'Number of decimal places that can be used in monetary amounts for the product.'; ExternalName = 'quantitydecimal'; ExternalType = 'Integer'; MaxValue = 5; MinValue = 0; } field(19; QuantityOnHand; Decimal) { AutoFormatType = 0; Caption = 'Quantity On Hand'; Description = 'Quantity of the product in stock.'; ExternalName = 'quantityonhand'; ExternalType = 'Decimal'; } field(20; IsStockItem; Boolean) { Caption = 'Stock Item'; Description = 'Information about whether the product is a stock item.'; ExternalName = 'isstockitem'; ExternalType = 'Boolean'; } field(21; SupplierName; Text[100]) { Caption = 'Supplier Name'; Description = 'Name of the product''s supplier.'; ExternalName = 'suppliername'; ExternalType = 'String'; } field(22; VendorName; Text[100]) { Caption = 'Vendor'; Description = 'Name of the product vendor.'; ExternalName = 'vendorname'; ExternalType = 'String'; } field(23; VendorPartNumber; Text[100]) { Caption = 'Vendor Name'; Description = 'Unique part identifier in vendor catalog of this product.'; ExternalName = 'vendorpartnumber'; ExternalType = 'String'; } field(24; CreatedOn; DateTime) { Caption = 'Created On'; Description = 'Date and time when the product was created.'; ExternalAccess = Read; ExternalName = 'createdon'; ExternalType = 'DateTime'; } field(25; ModifiedOn; DateTime) { Caption = 'Modified On'; Description = 'Date and time when the product was last modified.'; ExternalAccess = Read; ExternalName = 'modifiedon'; ExternalType = 'DateTime'; } field(26; CreatedBy; Guid) { Caption = 'Created By'; Description = 'Unique identifier of the user who created the product.'; ExternalAccess = Read; ExternalName = 'createdby'; ExternalType = 'Lookup'; TableRelation = "CRM Systemuser".SystemUserId; } field(27; StateCode; Option) { Caption = 'Status'; Description = 'Status of the product.'; ExternalAccess = Modify; ExternalName = 'statecode'; ExternalType = 'State'; InitValue = Draft; OptionCaption = 'Active,Retired,Draft,Under Revision'; OptionOrdinalValues = 0, 1, 2, 3; OptionMembers = Active,Retired,Draft,UnderRevision; } field(28; ModifiedBy; Guid) { Caption = 'Modified By'; Description = 'Unique identifier of the user who last modified the product.'; ExternalAccess = Read; ExternalName = 'modifiedby'; ExternalType = 'Lookup'; TableRelation = "CRM Systemuser".SystemUserId; } field(29; StatusCode; Option) { Caption = 'Status Reason'; Description = 'Reason for the status of the product.'; ExternalName = 'statuscode'; ExternalType = 'Status'; InitValue = " "; OptionCaption = ' ,Active,Retired,Draft,Under Revision'; OptionOrdinalValues = -1, 1, 2, 0, 3; OptionMembers = " ",Active,Retired,Draft,UnderRevision; } field(30; VersionNumber; BigInteger) { Caption = 'Version Number'; Description = 'Version number of the product.'; ExternalAccess = Read; ExternalName = 'versionnumber'; ExternalType = 'BigInt'; } field(31; DefaultUoMIdName; Text[100]) { CalcFormula = lookup("CRM Uom".Name where(UoMId = field(DefaultUoMId))); Caption = 'DefaultUoMIdName'; ExternalAccess = Read; ExternalName = 'defaultuomidname'; ExternalType = 'String'; FieldClass = FlowField; } field(32; DefaultUoMScheduleIdName; Text[200]) { CalcFormula = lookup("CRM Uomschedule".Name where(UoMScheduleId = field(DefaultUoMScheduleId))); Caption = 'DefaultUoMScheduleIdName'; ExternalAccess = Read; ExternalName = 'defaultuomscheduleidname'; ExternalType = 'String'; FieldClass = FlowField; } field(33; PriceLevelIdName; Text[100]) { CalcFormula = lookup("CRM Pricelevel".Name where(PriceLevelId = field(PriceLevelId))); Caption = 'PriceLevelIdName'; ExternalAccess = Read; ExternalName = 'pricelevelidname'; ExternalType = 'String'; FieldClass = FlowField; } field(34; CreatedByName; Text[200]) { CalcFormula = lookup("CRM Systemuser".FullName where(SystemUserId = field(CreatedBy))); Caption = 'CreatedByName'; ExternalAccess = Read; ExternalName = 'createdbyname'; ExternalType = 'String'; FieldClass = FlowField; } field(35; ModifiedByName; Text[200]) { CalcFormula = lookup("CRM Systemuser".FullName where(SystemUserId = field(ModifiedBy))); Caption = 'ModifiedByName'; ExternalAccess = Read; ExternalName = 'modifiedbyname'; ExternalType = 'String'; FieldClass = FlowField; } field(36; OrganizationIdName; Text[160]) { CalcFormula = lookup("CRM Organization".Name where(OrganizationId = field(OrganizationId))); Caption = 'OrganizationIdName'; ExternalAccess = Read; ExternalName = 'organizationidname'; ExternalType = 'String'; FieldClass = FlowField; } field(37; OverriddenCreatedOn; Date) { Caption = 'Record Created On'; Description = 'Date and time that the record was migrated.'; ExternalAccess = Insert; ExternalName = 'overriddencreatedon'; ExternalType = 'DateTime'; } field(38; TransactionCurrencyId; Guid) { Caption = 'Currency'; Description = 'Unique identifier of the currency associated with the product.'; ExternalName = 'transactioncurrencyid'; ExternalType = 'Lookup'; TableRelation = "CRM Transactioncurrency".TransactionCurrencyId; } field(39; ExchangeRate; Decimal) { AutoFormatType = 0; Caption = 'Exchange Rate'; Description = 'Exchange rate for the currency associated with the product with respect to the base currency.'; ExternalAccess = Read; ExternalName = 'exchangerate'; ExternalType = 'Decimal'; } field(40; 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(41; ImportSequenceNumber; Integer) { Caption = 'Import Sequence Number'; Description = 'Unique identifier of the data import or data migration that created this record.'; ExternalAccess = Insert; ExternalName = 'importsequencenumber'; ExternalType = 'Integer'; } field(42; TimeZoneRuleVersionNumber; Integer) { Caption = 'Time Zone Rule Version Number'; Description = 'For internal use only.'; ExternalName = 'timezoneruleversionnumber'; ExternalType = 'Integer'; MinValue = -1; } field(43; TransactionCurrencyIdName; Text[100]) { CalcFormula = lookup("CRM Transactioncurrency".CurrencyName where(TransactionCurrencyId = field(TransactionCurrencyId))); Caption = 'TransactionCurrencyIdName'; ExternalAccess = Read; ExternalName = 'transactioncurrencyidname'; ExternalType = 'String'; FieldClass = FlowField; } field(44; CurrentCost_Base; Decimal) { AutoFormatType = 0; Caption = 'Current Cost (Base)'; Description = 'Base currency equivalent of the current cost for the product item.'; ExternalAccess = Read; ExternalName = 'currentcost_base'; ExternalType = 'Money'; } field(45; Price_Base; Decimal) { AutoFormatType = 0; Caption = 'List Price (Base)'; Description = 'Base currency equivalent of the list price of the product'; ExternalAccess = Read; ExternalName = 'price_base'; ExternalType = 'Money'; } field(46; StandardCost_Base; Decimal) { AutoFormatType = 0; Caption = 'Standard Cost (Base)'; Description = 'Base currency equivalent of the standard cost of the product.'; ExternalAccess = Read; ExternalName = 'standardcost_base'; ExternalType = 'Money'; } field(47; CreatedOnBehalfBy; Guid) { Caption = 'Created By (Delegate)'; Description = 'Unique identifier of the delegate user who created the product.'; ExternalAccess = Read; ExternalName = 'createdonbehalfby'; ExternalType = 'Lookup'; TableRelation = "CRM Systemuser".SystemUserId; } field(48; CreatedOnBehalfByName; Text[200]) { CalcFormula = lookup("CRM Systemuser".FullName where(SystemUserId = field(CreatedOnBehalfBy))); Caption = 'CreatedOnBehalfByName'; ExternalAccess = Read; ExternalName = 'createdonbehalfbyname'; ExternalType = 'String'; FieldClass = FlowField; } field(49; ModifiedOnBehalfBy; Guid) { Caption = 'Modified By (Delegate)'; Description = 'Unique identifier of the delegate user who last modified the product.'; ExternalAccess = Read; ExternalName = 'modifiedonbehalfby'; ExternalType = 'Lookup'; TableRelation = "CRM Systemuser".SystemUserId; } field(50; ModifiedOnBehalfByName; Text[200]) { CalcFormula = lookup("CRM Systemuser".FullName where(SystemUserId = field(ModifiedOnBehalfBy))); Caption = 'ModifiedOnBehalfByName'; ExternalAccess = Read; ExternalName = 'modifiedonbehalfbyname'; ExternalType = 'String'; FieldClass = FlowField; } field(51; EntityImageId; Guid) { Caption = 'Entity Image Id'; Description = 'For internal use only.'; ExternalAccess = Read; ExternalName = 'entityimageid'; ExternalType = 'Uniqueidentifier'; } field(52; ProcessId; Guid) { Caption = 'Process'; Description = 'Shows the ID of the process.'; ExternalName = 'processid'; ExternalType = 'Uniqueidentifier'; } field(53; StageId; Guid) { Caption = 'Process Stage'; Description = 'Shows the ID of the stage.'; ExternalName = 'stageid'; ExternalType = 'Uniqueidentifier'; } field(54; ParentProductId; Guid) { Caption = 'Parent'; Description = 'Specifies the parent product family hierarchy.'; ExternalAccess = Insert; ExternalName = 'parentproductid'; ExternalType = 'Lookup'; TableRelation = "CRM Product".ProductId; } field(55; ParentProductIdName; Text[100]) { CalcFormula = lookup("CRM Product".Name where(ProductId = field(ParentProductId))); Caption = 'ParentProductIdName'; ExternalAccess = Read; ExternalName = 'parentproductidname'; ExternalType = 'String'; FieldClass = FlowField; } field(56; ProductStructure; Option) { Caption = 'Product Structure'; Description = 'Product Structure.'; ExternalAccess = Insert; ExternalName = 'productstructure'; ExternalType = 'Picklist'; InitValue = Product; OptionCaption = 'Product,Product Family,Product Bundle'; OptionOrdinalValues = 1, 2, 3; OptionMembers = Product,ProductFamily,ProductBundle; } field(57; VendorID; Text[100]) { Caption = 'Vendor ID'; Description = 'Unique identifier of vendor supplying the product.'; ExternalName = 'vendorid'; ExternalType = 'String'; } field(58; TraversedPath; Text[250]) { Caption = 'Traversed Path'; Description = 'For internal use only.'; ExternalName = 'traversedpath'; ExternalType = 'String'; } field(59; ValidFromDate; Date) { Caption = 'Valid From'; Description = 'Date from which this product is valid.'; ExternalName = 'validfromdate'; ExternalType = 'DateTime'; } field(60; ValidToDate; Date) { Caption = 'Valid To'; Description = 'Date to which this product is valid.'; ExternalName = 'validtodate'; ExternalType = 'DateTime'; } field(61; HierarchyPath; Text[250]) { Caption = 'Hierarchy Path'; Description = 'Hierarchy path of the product.'; ExternalAccess = Read; ExternalName = 'hierarchypath'; ExternalType = 'String'; } field(62; CompanyId; Guid) { Caption = 'Company Id'; Description = 'Unique identifier of the company that owns the product.'; ExternalName = 'bcbi_companyid'; ExternalType = 'Lookup'; TableRelation = "CDS Company".CompanyId; } } keys { key(Key1; ProductId) { Clustered = true; } key(Key2; Name) { } key(Key3; ProductNumber) { } } fieldgroups { fieldgroup(DropDown; Name) { } }}