Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/1691
Table Type: Company
Table Name: Posted Bank Deposit Header
Database Table Name: CRONUS UK Ltd_$Posted Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0
Table Number: 1691Due 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 Posted Bank Deposit Header can be queried.
SELECT
*
FROM
[CRONUS UK Ltd_$Posted Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0]
SELECT
[No_]
,[Bank Account No_]
,[Currency Code]
,[Currency Factor]
,[Posting Date]
,[Total Deposit Amount]
,[Document Date]
,[Shortcut Dimension 1 Code]
,[Shortcut Dimension 2 Code]
,[Bank Acc_ Posting Group]
,[Language Code]
,[No_ Printed]
,[Reason Code]
,[Correction]
,[No_ Series]
,[Posting Description]
,[Format Region]
,[Dimension Set ID]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Posted Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0]
SELECT
*
FROM
[CRONUS UK Ltd_$Posted Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Header]
LEFT JOIN
[CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
ON
[Posted Bank Deposit Header].[Currency Code] = [Currency].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Posted Bank Deposit Header].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Posted Bank Deposit Header].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
ON
[Posted Bank Deposit Header].[Language Code] = [Language].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
ON
[Posted Bank Deposit Header].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
ON
[Posted Bank Deposit Header].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
[User] AS [User]
ON
[Posted Bank Deposit Header].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Posted Bank Deposit Header].[SystemModifiedBy] = [User].[User Security ID]
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|
| 1 | No.  | No. | Normal | Code | 20 | No_ | nvarchar(40) |
| 2 | Bank Account No.  | Bank Account No. | Normal | Code | 20 | Bank Account No_ | nvarchar(40) |
| Key to join to the Bank Account table.SELECT
[Posted Bank Deposit Header].[Bank Account No_]
,[Bank Account].[No_]
FROM
[CRONUS UK Ltd_$Posted Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Header]
LEFT JOIN
[CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account]
ON
[Posted Bank Deposit Header].[Bank Account No_] = [Bank Account].[No_] |
| 3 | Currency Code | Currency Code | Normal | Code | 10 | Currency Code | nvarchar(20) |
| Key to join to the Currency table.SELECT
[Posted Bank Deposit Header].[Currency Code]
,[Currency].[Code]
FROM
[CRONUS UK Ltd_$Posted Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Header]
LEFT JOIN
[CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
ON
[Posted Bank Deposit Header].[Currency Code] = [Currency].[Code] |
| 4 | Currency Factor | Currency Factor | Normal | Decimal | 12 | Currency Factor | decimal(38,38) |
| 5 | Posting Date | Posting Date | Normal | Date | 4 | Posting Date | datetime |
| 6 | Total Deposit Amount | Total Deposit Amount | Normal | Decimal | 12 | Total Deposit Amount | decimal(38,38) |
| 7 | Document Date | Document Date | Normal | Date | 4 | Document Date | datetime |
| 8 | Shortcut Dimension 1 Code | Shortcut Dimension 1 Code | Normal | Code | 20 | Shortcut Dimension 1 Code | nvarchar(40) |
| Key to join to the Dimension table.SELECT
[Posted Bank Deposit Header].[Shortcut Dimension 1 Code]
,[Dimension].[Code]
FROM
[CRONUS UK Ltd_$Posted Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Header]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Posted Bank Deposit Header].[Shortcut Dimension 1 Code] = [Dimension].[Code] |
| 9 | Shortcut Dimension 2 Code | Shortcut Dimension 2 Code | Normal | Code | 20 | Shortcut Dimension 2 Code | nvarchar(40) |
| Key to join to the Dimension table.SELECT
[Posted Bank Deposit Header].[Shortcut Dimension 2 Code]
,[Dimension].[Code]
FROM
[CRONUS UK Ltd_$Posted Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Header]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Posted Bank Deposit Header].[Shortcut Dimension 2 Code] = [Dimension].[Code] |
| 10 | Bank Acc. Posting Group | Bank Acc. Posting Group | Normal | Code | 20 | Bank Acc_ Posting Group | nvarchar(40) |
| Key to join to the Bank Account Posting Group table.SELECT
[Posted Bank Deposit Header].[Bank Acc_ Posting Group]
,[Bank Account Posting Group].[Code]
FROM
[CRONUS UK Ltd_$Posted Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Header]
LEFT JOIN
[CRONUS UK Ltd_$Bank Account Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account Posting Group]
ON
[Posted Bank Deposit Header].[Bank Acc_ Posting Group] = [Bank Account Posting Group].[Code] |
| 11 | Language Code | Language Code | Normal | Code | 10 | Language Code | nvarchar(20) |
| Key to join to the Language table.SELECT
[Posted Bank Deposit Header].[Language Code]
,[Language].[Code]
FROM
[CRONUS UK Ltd_$Posted Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Header]
LEFT JOIN
[CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
ON
[Posted Bank Deposit Header].[Language Code] = [Language].[Code] |
| 12 | No. Printed | No. Printed | Normal | Integer | 4 | No_ Printed | int |
| 13 | Reason Code | Reason Code | Normal | Code | 10 | Reason Code | nvarchar(20) |
| Key to join to the Reason Code table.SELECT
[Posted Bank Deposit Header].[Reason Code]
,[Reason Code].[Code]
FROM
[CRONUS UK Ltd_$Posted Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Header]
LEFT JOIN
[CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
ON
[Posted Bank Deposit Header].[Reason Code] = [Reason Code].[Code] |
| 14 | Correction | Correction | Normal | Boolean | 4 | Correction | tinyint |
| 15 | No. Series | No. Series | Normal | Code | 20 | No_ Series | nvarchar(40) |
| Key to join to the No. Series table.SELECT
[Posted Bank Deposit Header].[No_ Series]
,[No. Series].[Code]
FROM
[CRONUS UK Ltd_$Posted Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Header]
LEFT JOIN
[CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
ON
[Posted Bank Deposit Header].[No_ Series] = [No. Series].[Code] |
| 16 | Posting Description | Posting Description | Normal | Text | 100 | Posting Description | nvarchar(200) |
| 21 | Comment | Comment | FlowField | Boolean | 4 | | |
| 22 | Total Deposit Lines | Total Deposit Lines | FlowField | Decimal | 12 | | |
| 24 | Format Region | Format Region | Normal | Text | 80 | Format Region | nvarchar(160) |
| 480 | Dimension Set ID | Dimension Set ID | Normal | Integer | 4 | Dimension Set ID | int |
| Key to join to the Dimension Set Entry table.SELECT
[Posted Bank Deposit Header].[Dimension Set ID]
,[Dimension Set Entry].[Dimension Set ID]
FROM
[CRONUS UK Ltd_$Posted Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Header]
LEFT JOIN
[CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
ON
[Posted Bank Deposit Header].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID] |
| 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
[Posted Bank Deposit Header].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Posted Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Header]
LEFT JOIN
[User] AS [User]
ON
[Posted Bank Deposit Header].[$systemCreatedBy] = [User].[User Security ID] |
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
