Copy Item Buffer – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables CCopy Item Buffer

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

Table Type: Company

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

Table Number: 729

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 Buffer can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Primary Key]
   ,[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]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Copy Item Buffer$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 Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Copy Item Buffer]
LEFT JOIN
   [User] AS [User]
      ON
         [Copy Item Buffer].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Copy Item Buffer].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Copy Item Buffer table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Primary Key	Primary Key	Normal	Code	10	Primary Key	nvarchar(20)
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 Buffer].[Source Item No_] ,[Item].[No_] FROM [CRONUS UK Ltd_$Copy Item Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Copy Item Buffer] LEFT JOIN [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] ON [Copy Item Buffer].[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	Assembly 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
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 Buffer].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Copy Item Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Copy Item Buffer] LEFT JOIN [User] AS [User] ON [Copy Item Buffer].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier