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.SELECT
[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:
- ” “
- “Payment”
- “Invoice”
- “Credit Memo”
- “Finance Charge Memo”
- “Reminder”
- “Refund”
|
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.SELECT
[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.SELECT
[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.SELECT
[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.SELECT
[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.SELECT
[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.SELECT
[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.SELECT
[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.SELECT
[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:
- “G/L Account”
- “Customer”
- “Vendor”
- “Bank Account”
- “Fixed Asset”
- “IC Partner”
- “Employee”
- “Allocation Account”
|
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:
- ” “
- “Purchase”
- “Sale”
- “Settlement”
|
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.SELECT
[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.SELECT
[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.SELECT
[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.SELECT
[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.SELECT
[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.SELECT
[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.SELECT
[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.SELECT
[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.SELECT
[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.SELECT
[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.SELECT
[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.SELECT
[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.SELECT
[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.SELECT
[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.SELECT
[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.SELECT
[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.SELECT
[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.SELECT
[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 |