Copy Item Parameters – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables CCopy Item Parameters

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/728

Table Type: Company

Table Name: Copy Item Parameters
Database Table Name: CRONUS UK Ltd_$Copy Item Parameters$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 728

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Copy Item Parameters can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Copy Item Parameters$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Source Item No_]
   ,[Target Item No_]
   ,[Target No_ Series]
   ,[Number of Copies]
   ,[General Item Information]
   ,[Units of Measure]
   ,[Dimensions]
   ,[Picture]
   ,[Comments]
   ,[Sales Prices]
   ,[Sales Line Discounts]
   ,[Purchase Prices]
   ,[Purchase Line Discounts]
   ,[Troubleshooting]
   ,[Resource Skills]
   ,[Item Variants]
   ,[Translations]
   ,[Extended Texts]
   ,[BOM Components]
   ,[Item Vendors]
   ,[Attributes]
   ,[Item Cross References]
   ,[Item References]
   ,[User ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Copy Item Parameters$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Copy Item Parameters$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Copy Item Parameters]
LEFT JOIN
   [User] AS [User]
      ON
         [Copy Item Parameters].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Copy Item Parameters].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Copy Item Parameters table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
2	Source Item No.	Source Item No.	Normal	Code	20	Source Item No_	nvarchar(40)
	Key to join to the Item table. Show/hide example query SELECT [Copy Item Parameters].[Source Item No_] ,[Item].[No_] FROM [CRONUS UK Ltd_$Copy Item Parameters$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Copy Item Parameters] LEFT JOIN [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] ON [Copy Item Parameters].[Source Item No_] = [Item].[No_]
3	Target Item No.	Target Item No.	Normal	Code	20	Target Item No_	nvarchar(40)
4	Target No. Series	Target No. Series	Normal	Code	20	Target No_ Series	nvarchar(40)
5	Number of Copies	Number of Copies	Normal	Integer	4	Number of Copies	int
10	General Item Information	General Item Information	Normal	Boolean	4	General Item Information	tinyint
11	Units of Measure	Units of Measure	Normal	Boolean	4	Units of Measure	tinyint
12	Dimensions	Dimensions	Normal	Boolean	4	Dimensions	tinyint
13	Picture	Picture	Normal	Boolean	4	Picture	tinyint
14	Comments	Comments	Normal	Boolean	4	Comments	tinyint
15	Sales Prices	Sales Prices	Normal	Boolean	4	Sales Prices	tinyint
16	Sales Line Discounts	Sales Line Discounts	Normal	Boolean	4	Sales Line Discounts	tinyint
17	Purchase Prices	Purchase Prices	Normal	Boolean	4	Purchase Prices	tinyint
18	Purchase Line Discounts	Purchase Line Discounts	Normal	Boolean	4	Purchase Line Discounts	tinyint
19	Troubleshooting	Troubleshooting	Normal	Boolean	4	Troubleshooting	tinyint
20	Resource Skills	Resource Skills	Normal	Boolean	4	Resource Skills	tinyint
21	Item Variants	Item Variants	Normal	Boolean	4	Item Variants	tinyint
22	Translations	Translations	Normal	Boolean	4	Translations	tinyint
23	Extended Texts	Extended Text	Normal	Boolean	4	Extended Texts	tinyint
24	BOM Components	BOM Components	Normal	Boolean	4	BOM Components	tinyint
25	Item Vendors	Item Vendors	Normal	Boolean	4	Item Vendors	tinyint
26	Attributes	Attributes	Normal	Boolean	4	Attributes	tinyint
27	Item Cross References	Item Cross References	Normal	Boolean	4	Item Cross References	tinyint
28	Item References	Item References	Normal	Boolean	4	Item References	tinyint
1000	User ID	Primary Key	Normal	Code	50	User ID	nvarchar(100)
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Copy Item Parameters].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Copy Item Parameters$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Copy Item Parameters] LEFT JOIN [User] AS [User] ON [Copy Item Parameters].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier