Item Charge Assignment (Purch)

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

Table Type: Company

Table Name: Item Charge Assignment (Purch)
Database Table Name: CRONUS UK Ltd_$Item Charge Assignment (Purch)$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5805

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 Item Charge Assignment (Purch) can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Item Charge Assignment (Purch)$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Document Type]
   ,[Document No_]
   ,[Document Line No_]
   ,[Line No_]
   ,[Item Charge No_]
   ,[Item No_]
   ,[Description]
   ,[Qty_ to Assign]
   ,[Qty_ Assigned]
   ,[Unit Cost]
   ,[Amount to Assign]
   ,[Applies-to Doc_ Type]
   ,[Applies-to Doc_ No_]
   ,[Applies-to Doc_ Line No_]
   ,[Applies-to Doc_ Line Amount]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Item Charge Assignment (Purch)$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Item Charge Assignment (Purch)$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Charge Assignment (Purch)]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Item Charge Assignment (Purch)].[Item No_] = [Item].[No_]

Show/hide columns in Item Charge Assignment (Purch) table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Document Type Primary Key Searchint
3Document No_ Primary Key Searchnvarchar(40)
4Document Line No_ Primary Key Searchint
5Line No_ Primary Key Searchint
6Item Charge No_ Searchnvarchar(40)
7Item No_ Searchnvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Item Charge Assignment (Purch)].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Item Charge Assignment (Purch)$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Charge Assignment (Purch)]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Item Charge Assignment (Purch)].[Item No_] = [Item].[No_]
8Description Searchnvarchar(200)
9Qty_ to Assign Searchdecimal(38,38)
10Qty_ Assigned Searchdecimal(38,38)
11Unit Cost Searchdecimal(38,38)
12Amount to Assign Searchdecimal(38,38)
13Applies-to Doc_ Type Searchint
14Applies-to Doc_ No_ Searchnvarchar(40)
15Applies-to Doc_ Line No_ Searchint
16Applies-to Doc_ Line Amount Searchdecimal(38,38)
17$systemId Searchuniqueidentifier
18$systemCreatedAt Searchdatetime
19$systemCreatedBy Searchuniqueidentifier
20$systemModifiedAt Searchdatetime
21$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Item Charge Assignment (Purch) table

Leave a Reply

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