Copy 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
   [timestamp]
   ,[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 columns in Copy Item Buffer table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Primary Key Primary Key Searchnvarchar(20)
3Source Item No_ Searchnvarchar(40)
4Target Item No_ Searchnvarchar(40)
5Target No_ Series Searchnvarchar(40)
6Number of Copies Searchint
7General Item Information Searchtinyint
8Units of Measure Searchtinyint
9Dimensions Searchtinyint
10Picture Searchtinyint
11Comments Searchtinyint
12Sales Prices Searchtinyint
13Sales Line Discounts Searchtinyint
14Purchase Prices Searchtinyint
15Purchase Line Discounts Searchtinyint
16Troubleshooting Searchtinyint
17Resource Skills Searchtinyint
18Item Variants Searchtinyint
19Translations Searchtinyint
20Extended Texts Searchtinyint
21BOM Components Searchtinyint
22Item Vendors Searchtinyint
23Attributes Searchtinyint
24Item Cross References Searchtinyint
25Item References Searchtinyint
26$systemId Searchuniqueidentifier
27$systemCreatedAt Searchdatetime
28$systemCreatedBy Searchuniqueidentifier
29$systemModifiedAt Searchdatetime
30$systemModifiedBy Searchuniqueidentifier

Leave a Reply

Your email address will not be published. Required fields are marked *