Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/434
Table Type: Company
Table Name: IC Inbox Sales Header
Database Table Name: CRONUS UK Ltd_$IC Inbox Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972
Table Number: 434Due 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 IC Inbox Sales Header can be queried.
SELECT
*
FROM
[CRONUS UK Ltd_$IC Inbox Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
[Document Type]
,[Sell-to Customer No_]
,[No_]
,[Bill-to Customer No_]
,[Ship-to Name]
,[Ship-to Address]
,[Ship-to Address 2]
,[Ship-to City]
,[Posting Date]
,[Due Date]
,[Payment Discount _]
,[Pmt_ Discount Date]
,[Currency Code]
,[Prices Including VAT]
,[Ship-to Post Code]
,[Ship-to County]
,[Ship-to Country_Region Code]
,[Document Date]
,[External Document No_]
,[IC Partner Code]
,[IC Transaction No_]
,[Transaction Source]
,[Requested Delivery Date]
,[Promised Delivery Date]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$IC Inbox Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
*
FROM
[CRONUS UK Ltd_$IC Inbox Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Inbox Sales Header]
LEFT JOIN
[CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
ON
[IC Inbox Sales Header].[Document Type] = [Sales Header].[Document Type]
AND
[IC Inbox Sales Header].[Document No_] = [Sales Header].[No_]
LEFT JOIN
[CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
ON
[IC Inbox Sales Header].[Document Type] = [Sales Header Archive].[Document Type]
AND
[IC Inbox Sales Header].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
[CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
ON
[IC Inbox Sales Header].[Ship-to City] = [Post Code].[City]
LEFT JOIN
[CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
ON
[IC Inbox Sales Header].[Currency Code] = [Currency].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
ON
[IC Inbox Sales Header].[Ship-to Post Code] = [Post Code].[Code]
LEFT JOIN
[CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
ON
[IC Inbox Sales Header].[IC Partner Code] = [IC Partner].[Code]
LEFT JOIN
[User] AS [User]
ON
[IC Inbox Sales Header].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[IC Inbox Sales Header].[SystemModifiedBy] = [User].[User Security ID]
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|
| 1 | Document Type  | Document Type | Normal | Option | 4 | Document Type | int |
| Available options are:
- ” “
- “Order”
- “Invoice”
- “Credit Memo”
- “Return Order”
|
| 2 | Sell-to Customer No. | Sell-to Customer No. | Normal | Code | 20 | Sell-to Customer No_ | nvarchar(40) |
| Key to join to the Customer table.SELECT
[IC Inbox Sales Header].[Sell-to Customer No_]
,[Customer].[No_]
FROM
[CRONUS UK Ltd_$IC Inbox Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Inbox Sales Header]
LEFT JOIN
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
ON
[IC Inbox Sales Header].[Sell-to Customer No_] = [Customer].[No_] |
| 3 | No. | No. | Normal | Code | 20 | No_ | nvarchar(40) |
| 4 | Bill-to Customer No. | Bill-to Customer No. | Normal | Code | 20 | Bill-to Customer No_ | nvarchar(40) |
| Key to join to the Customer table.SELECT
[IC Inbox Sales Header].[Bill-to Customer No_]
,[Customer].[No_]
FROM
[CRONUS UK Ltd_$IC Inbox Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Inbox Sales Header]
LEFT JOIN
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
ON
[IC Inbox Sales Header].[Bill-to Customer No_] = [Customer].[No_] |
| 13 | Ship-to Name | Ship-to Name | Normal | Text | 100 | Ship-to Name | nvarchar(200) |
| 15 | Ship-to Address | Ship-to Address | Normal | Text | 100 | Ship-to Address | nvarchar(200) |
| 16 | Ship-to Address 2 | Ship-to Address 2 | Normal | Text | 50 | Ship-to Address 2 | nvarchar(100) |
| 17 | Ship-to City | Ship-to City | Normal | Text | 30 | Ship-to City | nvarchar(60) |
| Key to join to the Post Code table.SELECT
[IC Inbox Sales Header].[Ship-to City]
,[Post Code].[City]
FROM
[CRONUS UK Ltd_$IC Inbox Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Inbox Sales Header]
LEFT JOIN
[CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
ON
[IC Inbox Sales Header].[Ship-to City] = [Post Code].[City] |
| 20 | Posting Date | Posting Date | Normal | Date | 4 | Posting Date | datetime |
| 24 | Due Date | Due Date | Normal | Date | 4 | Due Date | datetime |
| 25 | Payment Discount % | Payment Discount % | Normal | Decimal | 12 | Payment Discount _ | decimal(38,38) |
| 26 | Pmt. Discount Date | Pmt. Discount Date | Normal | Date | 4 | Pmt_ Discount Date | datetime |
| 32 | Currency Code | Currency Code | Normal | Code | 10 | Currency Code | nvarchar(20) |
| Key to join to the Currency table.SELECT
[IC Inbox Sales Header].[Currency Code]
,[Currency].[Code]
FROM
[CRONUS UK Ltd_$IC Inbox Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Inbox Sales Header]
LEFT JOIN
[CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
ON
[IC Inbox Sales Header].[Currency Code] = [Currency].[Code] |
| 35 | Prices Including VAT | Prices Including Tax | Normal | Boolean | 4 | Prices Including VAT | tinyint |
| 91 | Ship-to Post Code | Ship-to ZIP Code | Normal | Code | 20 | Ship-to Post Code | nvarchar(40) |
| Key to join to the Post Code table.SELECT
[IC Inbox Sales Header].[Ship-to Post Code]
,[Post Code].[Code]
FROM
[CRONUS UK Ltd_$IC Inbox Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Inbox Sales Header]
LEFT JOIN
[CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
ON
[IC Inbox Sales Header].[Ship-to Post Code] = [Post Code].[Code] |
| 92 | Ship-to County | Ship-to State | Normal | Text | 30 | Ship-to County | nvarchar(60) |
| 93 | Ship-to Country/Region Code | Ship-to Country/Region Code | Normal | Code | 10 | Ship-to Country_Region Code | nvarchar(20) |
| 99 | Document Date | Document Date | Normal | Date | 4 | Document Date | datetime |
| 100 | External Document No. | External Document No. | Normal | Code | 35 | External Document No_ | nvarchar(70) |
| 125 | IC Partner Code | IC Partner Code | Normal | Code | 20 | IC Partner Code | nvarchar(40) |
| Key to join to the IC Partner table.SELECT
[IC Inbox Sales Header].[IC Partner Code]
,[IC Partner].[Code]
FROM
[CRONUS UK Ltd_$IC Inbox Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Inbox Sales Header]
LEFT JOIN
[CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
ON
[IC Inbox Sales Header].[IC Partner Code] = [IC Partner].[Code] |
| 201 | IC Transaction No.  | IC Transaction No. | Normal | Integer | 4 | IC Transaction No_ | int |
| 202 | Transaction Source | Transaction Source | Normal | Option | 4 | Transaction Source | int |
| Available options are:
- “Returned by Partner”
- “Created by Partner”
|
| 5790 | Requested Delivery Date | Requested Delivery Date | Normal | Date | 4 | Requested Delivery Date | datetime |
| 5791 | Promised Delivery Date | Promised Delivery Date | Normal | Date | 4 | Promised Delivery Date | datetime |
| 2000000000 | $systemId | System ID | Normal | GUID | 16 | $systemId | uniqueidentifier |
| 2000000001 | SystemCreatedAt | Created At | Normal | DateTime | 8 | $systemCreatedAt | datetime |
| 2000000002 | SystemCreatedBy | Created By | Normal | GUID | 16 | $systemCreatedBy | uniqueidentifier |
| Key to join to the User table.SELECT
[IC Inbox Sales Header].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$IC Inbox Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Inbox Sales Header]
LEFT JOIN
[User] AS [User]
ON
[IC Inbox Sales Header].[$systemCreatedBy] = [User].[User Security ID] |
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
