Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/1705
Table Type: Company
Table Name: Posted Deferral Line
Database Table Name: CRONUS UK Ltd_$Posted Deferral Line$437dbf0e-84ff-417a-965d-ed2bb9650972
Table Number: 1705Due 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 Deferral Line can be queried.
SELECT
*
FROM
[CRONUS UK Ltd_$Posted Deferral Line$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
[Deferral Doc_ Type]
,[Gen_ Jnl_ Document No_]
,[Account No_]
,[Document Type]
,[Document No_]
,[Line No_]
,[Posting Date]
,[Description]
,[Amount]
,[Amount (LCY)]
,[Currency Code]
,[Deferral Account]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Posted Deferral Line$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
*
FROM
[CRONUS UK Ltd_$Posted Deferral Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Deferral Line]
LEFT JOIN
[CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
ON
[Posted Deferral Line].[Document Type] = [Sales Header Archive].[Document Type]
AND
[Posted Deferral Line].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
[CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
ON
[Posted Deferral Line].[Document Type] = [Sales Header].[Document Type]
AND
[Posted Deferral Line].[Document No_] = [Sales Header].[No_]
LEFT JOIN
[CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
ON
[Posted Deferral Line].[Currency Code] = [Currency].[Code]
LEFT JOIN
[User] AS [User]
ON
[Posted Deferral Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Posted Deferral Line].[SystemModifiedBy] = [User].[User Security ID]
Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
---|
1 | Deferral Doc. Type | Deferral Doc. Type | Normal | Option | 4 | Deferral Doc_ Type | int |
| Available options are:
|
2 | Gen. Jnl. Document No. | Gen. Jnl. Document No. | Normal | Code | 20 | Gen_ Jnl_ Document No_ | nvarchar(40) |
| Key to join to the Posted Deferral Header table.SELECT
[Posted Deferral Line].[Gen_ Jnl_ Document No_]
,[Posted Deferral Header].[Gen_ Jnl_ Document No_]
FROM
[CRONUS UK Ltd_$Posted Deferral Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Deferral Line]
LEFT JOIN
[CRONUS UK Ltd_$Posted Deferral Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Deferral Header]
ON
[Posted Deferral Line].[Gen_ Jnl_ Document No_] = [Posted Deferral Header].[Gen_ Jnl_ Document No_] |
3 | Account No. | Account No. | Normal | Code | 20 | Account No_ | nvarchar(40) |
| Key to join to the G/L Account table.SELECT
[Posted Deferral Line].[Account No_]
,[G/L Account].[No_]
FROM
[CRONUS UK Ltd_$Posted Deferral Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Deferral Line]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Posted Deferral Line].[Account No_] = [G/L Account].[No_] |
4 | Document Type | Document Type | Normal | Integer | 4 | Document Type | int |
5 | Document No. | Document No. | Normal | Code | 20 | Document No_ | nvarchar(40) |
6 | Line No. | Line No. | Normal | Integer | 4 | Line No_ | int |
7 | Posting Date | Posting Date | Normal | Date | 4 | Posting Date | datetime |
8 | Description | Description | Normal | Text | 100 | Description | nvarchar(200) |
9 | Amount | Amount | Normal | Decimal | 12 | Amount | decimal(38,38) |
10 | Amount (LCY) | Amount ($) | Normal | Decimal | 12 | Amount (LCY) | decimal(38,38) |
11 | Currency Code | Currency Code | Normal | Code | 10 | Currency Code | nvarchar(20) |
| Key to join to the Currency table.SELECT
[Posted Deferral Line].[Currency Code]
,[Currency].[Code]
FROM
[CRONUS UK Ltd_$Posted Deferral Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Deferral Line]
LEFT JOIN
[CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
ON
[Posted Deferral Line].[Currency Code] = [Currency].[Code] |
12 | Deferral Account | Deferral Account | Normal | Code | 20 | Deferral Account | nvarchar(40) |
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 Deferral Line].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Posted Deferral Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Deferral Line]
LEFT JOIN
[User] AS [User]
ON
[Posted Deferral Line].[$systemCreatedBy] = [User].[User Security ID] |
2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |