Table 5348 CRM Product
- App
- Base Application
- Namespace
- Microsoft.Integration.D365Sales
- Versions
- 17-28
Versions171819202122232425262728
Source29
Source in 29
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)
{
}
}
}