Copy Item Parameters

Easily find this page again using the shortlink:

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

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

Show/hide an example select of all columns by name

   ,[User ID]
   ,[Source Item No_]
   ,[Target Item No_]
   ,[Target No_ Series]
   ,[Number of Copies]
   ,[General Item Information]
   ,[Units of Measure]
   ,[Sales Prices]
   ,[Sales Line Discounts]
   ,[Purchase Prices]
   ,[Purchase Line Discounts]
   ,[Resource Skills]
   ,[Item Variants]
   ,[Extended Texts]
   ,[BOM Components]
   ,[Item Vendors]
   ,[Item Cross References]
   ,[Item References]
   [CRONUS UK Ltd_$Copy Item Parameters$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Copy Item Parameters table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2User ID Primary Key Searchnvarchar(100)
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 *