Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5621
Table Type: Company
Table Name: FA Journal Line
Database Table Name: CRONUS UK Ltd_$FA Journal Line$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 FA Journal Line can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$FA Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[timestamp]
,[Journal Template Name]
,[Journal Batch Name]
,[Line No_]
,[Depreciation Book Code]
,[FA Posting Type]
,[FA No_]
,[FA Posting Date]
,[Posting Date]
,[Document Type]
,[Document Date]
,[Document No_]
,[External Document No_]
,[Description]
,[Amount]
,[Debit Amount]
,[Credit Amount]
,[Salvage Value]
,[Quantity]
,[Correction]
,[No_ of Depreciation Days]
,[Depr_ until FA Posting Date]
,[Depr_ Acquisition Cost]
,[FA Posting Group]
,[Maintenance Code]
,[Shortcut Dimension 1 Code]
,[Shortcut Dimension 2 Code]
,[Insurance No_]
,[Budgeted FA No_]
,[Use Duplication List]
,[Duplicate in Depreciation Book]
,[FA Reclassification Entry]
,[FA Error Entry No_]
,[Reason Code]
,[Source Code]
,[Recurring Method]
,[Recurring Frequency]
,[Expiration Date]
,[Index Entry]
,[Posting No_ Series]
,[Dimension Set ID]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$FA Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide columns in FA Journal Line table
| Column ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | Journal Template Name  | nvarchar(20) |
| 3 | Journal Batch Name | nvarchar(20) |
| 4 | Line No_ | int |
| 5 | Depreciation Book Code | nvarchar(20) |
| 6 | FA Posting Type | int |
| 7 | FA No_ | nvarchar(40) |
| 8 | FA Posting Date | datetime |
| 9 | Posting Date | datetime |
| 10 | Document Type | int |
| 11 | Document Date | datetime |
| 12 | Document No_ | nvarchar(40) |
| 13 | External Document No_ | nvarchar(70) |
| 14 | Description | nvarchar(200) |
| 15 | Amount | decimal(38,38) |
| 16 | Debit Amount | decimal(38,38) |
| 17 | Credit Amount | decimal(38,38) |
| 18 | Salvage Value | decimal(38,38) |
| 19 | Quantity | decimal(38,38) |
| 20 | Correction | tinyint |
| 21 | No_ of Depreciation Days | int |
| 22 | Depr_ until FA Posting Date | tinyint |
| 23 | Depr_ Acquisition Cost | tinyint |
| 24 | FA Posting Group | nvarchar(40) |
| 25 | Maintenance Code | nvarchar(20) |
| 26 | Shortcut Dimension 1 Code | nvarchar(40) |
| 27 | Shortcut Dimension 2 Code | nvarchar(40) |
| 28 | Insurance No_ | nvarchar(40) |
| 29 | Budgeted FA No_ | nvarchar(40) |
| 30 | Use Duplication List | tinyint |
| 31 | Duplicate in Depreciation Book | nvarchar(20) |
| 32 | FA Reclassification Entry | tinyint |
| 33 | FA Error Entry No_ | int |
| 34 | Reason Code | nvarchar(20) |
| 35 | Source Code | nvarchar(20) |
| 36 | Recurring Method | int |
| 37 | Recurring Frequency | varchar(32) |
| 38 | Expiration Date | datetime |
| 39 | Index Entry | tinyint |
| 40 | Posting No_ Series | nvarchar(40) |
| 41 | Dimension Set ID | int |
| 42 | $systemId | uniqueidentifier |
| 43 | $systemCreatedAt | datetime |
| 44 | $systemCreatedBy | uniqueidentifier |
| 45 | $systemModifiedAt | datetime |
| 46 | $systemModifiedBy | uniqueidentifier |