Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5625
Table Type: Company
Table Name: Maintenance Ledger Entry
Database Table Name: CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972
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 Maintenance Ledger Entry can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]
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_]
,[External Document No_]
,[Description]
,[Amount]
,[Debit Amount]
,[Credit Amount]
,[Quantity]
,[FA No__Budgeted FA No_]
,[FA Subclass Code]
,[FA Location Code]
,[FA Posting Group]
,[Global Dimension 1 Code]
,[Global Dimension 2 Code]
,[Location Code]
,[User ID]
,[Journal Batch Name]
,[Source Code]
,[Reason Code]
,[Transaction No_]
,[Bal_ Account Type]
,[Bal_ Account No_]
,[VAT Amount]
,[Gen_ Posting Type]
,[Gen_ Bus_ Posting Group]
,[Gen_ Prod_ Posting Group]
,[FA Class Code]
,[Depreciation Book Code]
,[FA Exchange Rate]
,[Amount (LCY)]
,[Maintenance Code]
,[Correction]
,[Index Entry]
,[Automatic Entry]
,[No_ Series]
,[Tax Area Code]
,[Tax Liable]
,[Tax Group Code]
,[Use Tax]
,[VAT Bus_ Posting Group]
,[VAT Prod_ Posting Group]
,[Reversed]
,[Reversed by Entry No_]
,[Reversed Entry No_]
,[Dimension Set ID]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]
Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry]
LEFT JOIN
[CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
ON
[Maintenance Ledger Entry].[Document Type] = [Sales Header Archive].[Document Type]
AND
[Maintenance Ledger Entry].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
[CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
ON
[Maintenance Ledger Entry].[Document Type] = [Sales Header].[Document Type]
AND
[Maintenance Ledger Entry].[Document No_] = [Sales Header].[No_]
LEFT JOIN
[CRONUS UK Ltd_$FA Subclass$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Subclass]
ON
[Maintenance Ledger Entry].[FA Subclass Code] = [FA Subclass].[Code]
LEFT JOIN
[CRONUS UK Ltd_$FA Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Location]
ON
[Maintenance Ledger Entry].[FA Location Code] = [FA Location].[Code]
LEFT JOIN
[CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
ON
[Maintenance Ledger Entry].[FA Posting Group] = [FA Posting Group].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Maintenance Ledger Entry].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Maintenance Ledger Entry].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
ON
[Maintenance Ledger Entry].[Location Code] = [Location].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
ON
[Maintenance Ledger Entry].[Source Code] = [Source Code].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
ON
[Maintenance Ledger Entry].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
[CRONUS UK Ltd_$FA Class$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Class]
ON
[Maintenance Ledger Entry].[FA Class Code] = [FA Class].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
ON
[Maintenance Ledger Entry].[Depreciation Book Code] = [Depreciation Book].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Maintenance$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance]
ON
[Maintenance Ledger Entry].[Maintenance Code] = [Maintenance].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
ON
[Maintenance Ledger Entry].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
ON
[Maintenance Ledger Entry].[Tax Group Code] = [Tax Group].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
ON
[Maintenance Ledger Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Maintenance Ledger Entry].[Shortcut Dimension 3 Code] = [Dimension].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Maintenance Ledger Entry].[Shortcut Dimension 4 Code] = [Dimension].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Maintenance Ledger Entry].[Shortcut Dimension 5 Code] = [Dimension].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Maintenance Ledger Entry].[Shortcut Dimension 6 Code] = [Dimension].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Maintenance Ledger Entry].[Shortcut Dimension 7 Code] = [Dimension].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Maintenance Ledger Entry].[Shortcut Dimension 8 Code] = [Dimension].[Code]
LEFT JOIN
[User] AS [User]
ON
[Maintenance Ledger Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Maintenance Ledger Entry].[SystemModifiedBy] = [User].[User Security ID]
Show/hide columns in Maintenance Ledger Entry 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 |
3 | FA No. | FA No. | Normal | Code | 20 | FA No_ | nvarchar(40) |
Key to join to the Fixed Asset table.Show/hide example querySELECT [Maintenance Ledger Entry].[FA No_] ,[Fixed Asset].[No_] FROM [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset] ON [Maintenance Ledger Entry].[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) |
9 | External Document No. | External Document No. | Normal | Code | 35 | External Document No_ | nvarchar(70) |
10 | Description | Description | Normal | Text | 100 | Description | nvarchar(200) |
12 | Amount | Amount | Normal | Decimal | 12 | Amount | decimal(38,38) |
13 | Debit Amount | Debit Amount | Normal | Decimal | 12 | Debit Amount | decimal(38,38) |
14 | Credit Amount | Credit Amount | Normal | Decimal | 12 | Credit Amount | decimal(38,38) |
15 | Quantity | Quantity | Normal | Decimal | 12 | Quantity | decimal(38,38) |
16 | FA No./Budgeted FA No. | FA No./Budgeted FA No. | Normal | Code | 20 | FA No__Budgeted FA No_ | nvarchar(40) |
17 | FA Subclass Code | FA Subclass Code | Normal | Code | 10 | FA Subclass Code | nvarchar(20) |
Key to join to the FA Subclass table.Show/hide example querySELECT [Maintenance Ledger Entry].[FA Subclass Code] ,[FA Subclass].[Code] FROM [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$FA Subclass$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Subclass] ON [Maintenance Ledger Entry].[FA Subclass Code] = [FA Subclass].[Code] | |||||||
18 | FA Location Code | FA Location Code | Normal | Code | 10 | FA Location Code | nvarchar(20) |
Key to join to the FA Location table.Show/hide example querySELECT [Maintenance Ledger Entry].[FA Location Code] ,[FA Location].[Code] FROM [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$FA Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Location] ON [Maintenance Ledger Entry].[FA Location Code] = [FA Location].[Code] | |||||||
19 | FA Posting Group | FA Posting Group | Normal | Code | 20 | FA Posting Group | nvarchar(40) |
Key to join to the FA Posting Group table.Show/hide example querySELECT [Maintenance Ledger Entry].[FA Posting Group] ,[FA Posting Group].[Code] FROM [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group] ON [Maintenance Ledger Entry].[FA Posting Group] = [FA Posting Group].[Code] | |||||||
20 | Global Dimension 1 Code | Global Dimension 1 Code | Normal | Code | 20 | Global Dimension 1 Code | nvarchar(40) |
Key to join to the Dimension table.Show/hide example querySELECT [Maintenance Ledger Entry].[Global Dimension 1 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Maintenance Ledger Entry].[Global Dimension 1 Code] = [Dimension].[Code] | |||||||
21 | Global Dimension 2 Code | Global Dimension 2 Code | Normal | Code | 20 | Global Dimension 2 Code | nvarchar(40) |
Key to join to the Dimension table.Show/hide example querySELECT [Maintenance Ledger Entry].[Global Dimension 2 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Maintenance Ledger Entry].[Global Dimension 2 Code] = [Dimension].[Code] | |||||||
22 | Location Code | Location Code | Normal | Code | 10 | Location Code | nvarchar(20) |
Key to join to the Location table.Show/hide example querySELECT [Maintenance Ledger Entry].[Location Code] ,[Location].[Code] FROM [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Maintenance Ledger Entry].[Location Code] = [Location].[Code] | |||||||
24 | User ID | User ID | Normal | Code | 50 | User ID | nvarchar(100) |
25 | Journal Batch Name | Journal Batch Name | Normal | Code | 10 | Journal Batch Name | nvarchar(20) |
26 | Source Code | Source Code | Normal | Code | 10 | Source Code | nvarchar(20) |
Key to join to the Source Code table.Show/hide example querySELECT [Maintenance Ledger Entry].[Source Code] ,[Source Code].[Code] FROM [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code] ON [Maintenance Ledger Entry].[Source Code] = [Source Code].[Code] | |||||||
27 | Reason Code | Reason Code | Normal | Code | 10 | Reason Code | nvarchar(20) |
Key to join to the Reason Code table.Show/hide example querySELECT [Maintenance Ledger Entry].[Reason Code] ,[Reason Code].[Code] FROM [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code] ON [Maintenance Ledger Entry].[Reason Code] = [Reason Code].[Code] | |||||||
28 | Transaction No. | Transaction No. | Normal | Integer | 4 | Transaction No_ | int |
29 | Bal. Account Type | Bal. Account Type | Normal | Option | 4 | Bal_ Account Type | int |
Available options are:
| |||||||
30 | Bal. Account No. | Bal. Account No. | Normal | Code | 20 | Bal_ Account No_ | nvarchar(40) |
31 | VAT Amount | Tax Amount | Normal | Decimal | 12 | VAT Amount | decimal(38,38) |
32 | Gen. Posting Type | Gen. Posting Type | Normal | Option | 4 | Gen_ Posting Type | int |
Available options are:
| |||||||
33 | Gen. Bus. Posting Group | Gen. Bus. Posting Group | Normal | Code | 20 | Gen_ Bus_ Posting Group | nvarchar(40) |
Key to join to the Gen. Business Posting Group table.Show/hide example querySELECT [Maintenance Ledger Entry].[Gen_ Bus_ Posting Group] ,[Gen. Business Posting Group].[Code] FROM [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group] ON [Maintenance Ledger Entry].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code] | |||||||
34 | Gen. Prod. Posting Group | Gen. Prod. Posting Group | Normal | Code | 20 | Gen_ Prod_ Posting Group | nvarchar(40) |
Key to join to the Gen. Product Posting Group table.Show/hide example querySELECT [Maintenance Ledger Entry].[Gen_ Prod_ Posting Group] ,[Gen. Product Posting Group].[Code] FROM [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group] ON [Maintenance Ledger Entry].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code] | |||||||
35 | FA Class Code | FA Class Code | Normal | Code | 10 | FA Class Code | nvarchar(20) |
Key to join to the FA Class table.Show/hide example querySELECT [Maintenance Ledger Entry].[FA Class Code] ,[FA Class].[Code] FROM [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$FA Class$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Class] ON [Maintenance Ledger Entry].[FA Class Code] = [FA Class].[Code] | |||||||
36 | Depreciation Book Code | Depreciation Book Code | Normal | Code | 10 | Depreciation Book Code | nvarchar(20) |
Key to join to the Depreciation Book table.Show/hide example querySELECT [Maintenance Ledger Entry].[Depreciation Book Code] ,[Depreciation Book].[Code] FROM [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book] ON [Maintenance Ledger Entry].[Depreciation Book Code] = [Depreciation Book].[Code] | |||||||
37 | FA Exchange Rate | FA Exchange Rate | Normal | Decimal | 12 | FA Exchange Rate | decimal(38,38) |
38 | Amount (LCY) | Amount ($) | Normal | Decimal | 12 | Amount (LCY) | decimal(38,38) |
39 | Maintenance Code | Maintenance Code | Normal | Code | 10 | Maintenance Code | nvarchar(20) |
Key to join to the Maintenance table.Show/hide example querySELECT [Maintenance Ledger Entry].[Maintenance Code] ,[Maintenance].[Code] FROM [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Maintenance$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance] ON [Maintenance Ledger Entry].[Maintenance Code] = [Maintenance].[Code] | |||||||
40 | Correction | Correction | Normal | Boolean | 4 | Correction | tinyint |
41 | Index Entry | Index Entry | Normal | Boolean | 4 | Index Entry | tinyint |
42 | Automatic Entry | Automatic Entry | Normal | Boolean | 4 | Automatic Entry | tinyint |
43 | No. Series | No. Series | Normal | Code | 20 | No_ Series | nvarchar(40) |
Key to join to the No. Series table.Show/hide example querySELECT [Maintenance Ledger Entry].[No_ Series] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Maintenance Ledger Entry].[No_ Series] = [No. Series].[Code] | |||||||
44 | Tax Area Code | Tax Area Code | Normal | Code | 20 | Tax Area Code | nvarchar(40) |
Key to join to the Tax Area table.Show/hide example querySELECT [Maintenance Ledger Entry].[Tax Area Code] ,[Tax Area].[Code] FROM [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area] ON [Maintenance Ledger Entry].[Tax Area Code] = [Tax Area].[Code] | |||||||
45 | Tax Liable | Tax Liable | Normal | Boolean | 4 | Tax Liable | tinyint |
46 | Tax Group Code | Tax Group Code | Normal | Code | 20 | Tax Group Code | nvarchar(40) |
Key to join to the Tax Group table.Show/hide example querySELECT [Maintenance Ledger Entry].[Tax Group Code] ,[Tax Group].[Code] FROM [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group] ON [Maintenance Ledger Entry].[Tax Group Code] = [Tax Group].[Code] | |||||||
47 | Use Tax | Use Tax | Normal | Boolean | 4 | Use Tax | tinyint |
48 | VAT Bus. Posting Group | VAT Bus. Posting Group | Normal | Code | 20 | VAT Bus_ Posting Group | nvarchar(40) |
Key to join to the VAT Business Posting Group table.Show/hide example querySELECT [Maintenance Ledger Entry].[VAT Bus_ Posting Group] ,[VAT Business Posting Group].[Code] FROM [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group] ON [Maintenance Ledger Entry].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code] | |||||||
49 | VAT Prod. Posting Group | VAT Prod. Posting Group | Normal | Code | 20 | VAT Prod_ Posting Group | nvarchar(40) |
Key to join to the VAT Product Posting Group table.Show/hide example querySELECT [Maintenance Ledger Entry].[VAT Prod_ Posting Group] ,[VAT Product Posting Group].[Code] FROM [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group] ON [Maintenance Ledger Entry].[VAT Prod_ Posting Group] = [VAT Product Posting Group].[Code] | |||||||
50 | Reversed | Reversed | Normal | Boolean | 4 | Reversed | tinyint |
51 | Reversed by Entry No. | Reversed by Entry No. | Normal | Integer | 4 | Reversed by Entry No_ | int |
52 | Reversed Entry No. | Reversed Entry No. | Normal | Integer | 4 | Reversed Entry No_ | int |
480 | Dimension Set ID | Dimension Set ID | Normal | Integer | 4 | Dimension Set ID | int |
Key to join to the Dimension Set Entry table.Show/hide example querySELECT [Maintenance Ledger Entry].[Dimension Set ID] ,[Dimension Set Entry].[Dimension Set ID] FROM [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry] ON [Maintenance Ledger Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID] | |||||||
481 | Shortcut Dimension 3 Code | Shortcut Dimension 3 Code | FlowField | Code | 20 | ||
Key to join to the Dimension table.Show/hide example querySELECT [Maintenance Ledger Entry].[] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Maintenance Ledger Entry].[] = [Dimension].[Code] | |||||||
482 | Shortcut Dimension 4 Code | Shortcut Dimension 4 Code | FlowField | Code | 20 | ||
Key to join to the Dimension table.Show/hide example querySELECT [Maintenance Ledger Entry].[] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Maintenance Ledger Entry].[] = [Dimension].[Code] | |||||||
483 | Shortcut Dimension 5 Code | Shortcut Dimension 5 Code | FlowField | Code | 20 | ||
Key to join to the Dimension table.Show/hide example querySELECT [Maintenance Ledger Entry].[] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Maintenance Ledger Entry].[] = [Dimension].[Code] | |||||||
484 | Shortcut Dimension 6 Code | Shortcut Dimension 6 Code | FlowField | Code | 20 | ||
Key to join to the Dimension table.Show/hide example querySELECT [Maintenance Ledger Entry].[] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Maintenance Ledger Entry].[] = [Dimension].[Code] | |||||||
485 | Shortcut Dimension 7 Code | Shortcut Dimension 7 Code | FlowField | Code | 20 | ||
Key to join to the Dimension table.Show/hide example querySELECT [Maintenance Ledger Entry].[] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Maintenance Ledger Entry].[] = [Dimension].[Code] | |||||||
486 | Shortcut Dimension 8 Code | Shortcut Dimension 8 Code | FlowField | Code | 20 | ||
Key to join to the Dimension table.Show/hide example querySELECT [Maintenance Ledger Entry].[] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Maintenance Ledger Entry].[] = [Dimension].[Code] | |||||||
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 [Maintenance Ledger Entry].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry] LEFT JOIN [User] AS [User] ON [Maintenance Ledger Entry].[$systemCreatedBy] = [User].[User Security ID] | |||||||
2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |