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
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
[timestamp]
,[User ID]
,[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 Parameters$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide columns in Copy Item Parameters table
| Column ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | User ID  | nvarchar(100) |
| 3 | Source Item No_ | nvarchar(40) |
| 4 | Target Item No_ | nvarchar(40) |
| 5 | Target No_ Series | nvarchar(40) |
| 6 | Number of Copies | int |
| 7 | General Item Information | tinyint |
| 8 | Units of Measure | tinyint |
| 9 | Dimensions | tinyint |
| 10 | Picture | tinyint |
| 11 | Comments | tinyint |
| 12 | Sales Prices | tinyint |
| 13 | Sales Line Discounts | tinyint |
| 14 | Purchase Prices | tinyint |
| 15 | Purchase Line Discounts | tinyint |
| 16 | Troubleshooting | tinyint |
| 17 | Resource Skills | tinyint |
| 18 | Item Variants | tinyint |
| 19 | Translations | tinyint |
| 20 | Extended Texts | tinyint |
| 21 | BOM Components | tinyint |
| 22 | Item Vendors | tinyint |
| 23 | Attributes | tinyint |
| 24 | Item Cross References | tinyint |
| 25 | Item References | tinyint |
| 26 | $systemId | uniqueidentifier |
| 27 | $systemCreatedAt | datetime |
| 28 | $systemCreatedBy | uniqueidentifier |
| 29 | $systemModifiedAt | datetime |
| 30 | $systemModifiedBy | uniqueidentifier |