Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/6090
Table Type: Company
Table Name: FA Ledg. Entry w. Issue
Database Table Name: CRONUS UK Ltd_$FA Ledg_ Entry w_ Issue$7961e9dc-a8e5-49b1-839b-3a78803a4cb8
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 FA Ledg. Entry w. Issue can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$FA Ledg_ Entry w_ Issue$7961e9dc-a8e5-49b1-839b-3a78803a4cb8]
Show/hide an example select of all columns by name
SELECT
[Entry No_]
,[G_L Entry No_]
,[FA No_]
,[FA Posting Date]
,[Posting Date]
,[Document Type]
,[Document Date]
,[Document No_]
,[Description]
,[FA Posting Type]
,[Amount]
,[Corrected]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$FA Ledg_ Entry w_ Issue$7961e9dc-a8e5-49b1-839b-3a78803a4cb8]
Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$FA Ledg_ Entry w_ Issue$7961e9dc-a8e5-49b1-839b-3a78803a4cb8] AS [FA Ledg. Entry w. Issue]
LEFT JOIN
[CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
ON
[FA Ledg. Entry w. Issue].[Document Type] = [Sales Header].[Document Type]
AND
[FA Ledg. Entry w. Issue].[Document No_] = [Sales Header].[No_]
LEFT JOIN
[CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
ON
[FA Ledg. Entry w. Issue].[Document Type] = [Sales Header Archive].[Document Type]
AND
[FA Ledg. Entry w. Issue].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
[User] AS [User]
ON
[FA Ledg. Entry w. Issue].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[FA Ledg. Entry w. Issue].[SystemModifiedBy] = [User].[User Security ID]
Show/hide columns in FA Ledg. Entry w. Issue table
Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
---|---|---|---|---|---|---|---|
1 | Entry No. | Entry No. | Normal | Integer | 4 | Entry No_ | int |
2 | G/L Entry No. | G/L Entry No. | Normal | Integer | 4 | G_L Entry No_ | int |
Key to join to the G/L Entry table.Show/hide example querySELECT
[FA Ledg. Entry w. Issue].[G_L Entry No_]
,[G/L Entry].[Entry No_]
FROM
[CRONUS UK Ltd_$FA Ledg_ Entry w_ Issue$7961e9dc-a8e5-49b1-839b-3a78803a4cb8] AS [FA Ledg. Entry w. Issue]
LEFT JOIN
[CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry]
ON
[FA Ledg. Entry w. Issue].[G_L Entry No_] = [G/L Entry].[Entry No_] | |||||||
3 | FA No. | FA No. | Normal | Code | 20 | FA No_ | nvarchar(40) |
Key to join to the Fixed Asset table.Show/hide example querySELECT
[FA Ledg. Entry w. Issue].[FA No_]
,[Fixed Asset].[No_]
FROM
[CRONUS UK Ltd_$FA Ledg_ Entry w_ Issue$7961e9dc-a8e5-49b1-839b-3a78803a4cb8] AS [FA Ledg. Entry w. Issue]
LEFT JOIN
[CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
ON
[FA Ledg. Entry w. Issue].[FA No_] = [Fixed Asset].[No_] | |||||||
4 | FA Posting Date | FA Posting Date | Normal | Date | 4 | FA Posting Date | datetime |
5 | Posting Date | Posting Date | Normal | Date | 4 | Posting Date | datetime |
6 | Document Type | Document Type | Normal | Option | 4 | Document Type | int |
Available options are:
| |||||||
7 | Document Date | Document Date | Normal | Date | 4 | Document Date | datetime |
8 | Document No. | Document No. | Normal | Code | 20 | Document No_ | nvarchar(40) |
10 | Description | Description | Normal | Text | 100 | Description | nvarchar(200) |
13 | FA Posting Type | FA Posting Type | Normal | Option | 4 | FA Posting Type | int |
Available options are:
| |||||||
14 | Amount | Amount | Normal | Decimal | 12 | Amount | decimal(38,38) |
6090 | Corrected | Corrected | Normal | Boolean | 4 | Corrected | tinyint |
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.Show/hide example querySELECT
[FA Ledg. Entry w. Issue].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$FA Ledg_ Entry w_ Issue$7961e9dc-a8e5-49b1-839b-3a78803a4cb8] AS [FA Ledg. Entry w. Issue]
LEFT JOIN
[User] AS [User]
ON
[FA Ledg. Entry w. Issue].[$systemCreatedBy] = [User].[User Security ID] | |||||||
2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT
[FA Ledg. Entry w. Issue].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$FA Ledg_ Entry w_ Issue$7961e9dc-a8e5-49b1-839b-3a78803a4cb8] AS [FA Ledg. Entry w. Issue]
LEFT JOIN
[User] AS [User]
ON
[FA Ledg. Entry w. Issue].[$systemModifiedBy] = [User].[User Security ID] |