Item Charge Assignment (Sales)

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

Table Type: Company

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

Table Number: 5809

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 (Sales) can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [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]
   ,[Qty_ to Handle]
   ,[Amount to Handle]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Item Charge Assignment (Sales)$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 (Sales)$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Charge Assignment (Sales)]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Item Charge Assignment (Sales)].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Item Charge Assignment (Sales)].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Item Charge Assignment (Sales)].[Document Type] = [Sales Header].[Document Type]
      AND
         [Item Charge Assignment (Sales)].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [User] AS [User]
      ON
         [Item Charge Assignment (Sales)].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Item Charge Assignment (Sales)].[SystemModifiedBy] = [User].[User Security ID]

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

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Document Type Primary Key SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • “Quote”
  • “Order”
  • “Invoice”
  • “Credit Memo”
  • “Blanket Order”
  • “Return Order”
2Document No. Primary Key SearchDocument No.NormalCode20Document No_nvarchar(40)
3Document Line No. Primary Key SearchDocument Line No.NormalInteger4Document Line No_int
4Line No. Primary Key SearchLine No.NormalInteger4Line No_int
5Item Charge No. SearchItem Charge No.NormalCode20Item Charge No_nvarchar(40)
Key to join to the Item Charge table.

Show/hide example query

SELECT
       [Item Charge Assignment (Sales)].[Item Charge No_]
       ,[Item Charge].[No_]
FROM
       [CRONUS UK Ltd_$Item Charge Assignment (Sales)$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Charge Assignment (Sales)]
LEFT JOIN
       [CRONUS UK Ltd_$Item Charge$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Charge]
              ON
                     [Item Charge Assignment (Sales)].[Item Charge No_] = [Item Charge].[No_]
6Item No. SearchItem No.NormalCode20Item No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Item Charge Assignment (Sales)].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Item Charge Assignment (Sales)$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Charge Assignment (Sales)]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Item Charge Assignment (Sales)].[Item No_] = [Item].[No_]
7Description SearchDescriptionNormalText100Descriptionnvarchar(200)
8Qty. to Assign SearchQty. to AssignNormalDecimal12Qty_ to Assigndecimal(38,38)
9Qty. Assigned SearchQty. AssignedNormalDecimal12Qty_ Assigneddecimal(38,38)
10Unit Cost SearchUnit CostNormalDecimal12Unit Costdecimal(38,38)
11Amount to Assign SearchAmount to AssignNormalDecimal12Amount to Assigndecimal(38,38)
12Applies-to Doc. Type SearchApplies-to Doc. TypeNormalOption4Applies-to Doc_ Typeint
Available options are:
  • “Quote”
  • “Order”
  • “Invoice”
  • “Credit Memo”
  • “Blanket Order”
  • “Return Order”
  • “Shipment”
  • “Return Receipt”
13Applies-to Doc. No. SearchApplies-to Doc. No.NormalCode20Applies-to Doc_ No_nvarchar(40)
14Applies-to Doc. Line No. SearchApplies-to Doc. Line No.NormalInteger4Applies-to Doc_ Line No_int
15Applies-to Doc. Line Amount SearchApplies-to Doc. Line AmountNormalDecimal12Applies-to Doc_ Line Amountdecimal(38,38)
16Qty. to Handle SearchQty. to HandleNormalDecimal12Qty_ to Handledecimal(38,38)
17Amount to Handle SearchAmount to HandleNormalDecimal12Amount to Handledecimal(38,38)
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Item Charge Assignment (Sales)].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Item Charge Assignment (Sales)$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Charge Assignment (Sales)]
LEFT JOIN
       [User] AS [User]
              ON
                     [Item Charge Assignment (Sales)].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Item Charge Assignment (Sales)].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Item Charge Assignment (Sales)$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Charge Assignment (Sales)]
LEFT JOIN
       [User] AS [User]
              ON
                     [Item Charge Assignment (Sales)].[$systemModifiedBy] = [User].[User Security ID]

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

Leave a Reply

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