Issued Fin. Charge Memo Header

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/304

Table Type: Company

Table Name: Issued Fin. Charge Memo Header
Database Table Name: CRONUS UK Ltd_$Issued Fin_ Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 304

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 Issued Fin. Charge Memo Header can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Issued Fin_ Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [No_]
   ,[Customer No_]
   ,[Name]
   ,[Name 2]
   ,[Address]
   ,[Address 2]
   ,[Post Code]
   ,[City]
   ,[County]
   ,[Country_Region Code]
   ,[Language Code]
   ,[Currency Code]
   ,[Contact]
   ,[Your Reference]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Customer Posting Group]
   ,[Gen_ Bus_ Posting Group]
   ,[VAT Registration No_]
   ,[Reason Code]
   ,[Posting Date]
   ,[Document Date]
   ,[Due Date]
   ,[Fin_ Charge Terms Code]
   ,[Interest Posted]
   ,[Additional Fee Posted]
   ,[Posting Description]
   ,[No_ Printed]
   ,[User ID]
   ,[No_ Series]
   ,[Pre-Assigned No_ Series]
   ,[Pre-Assigned No_]
   ,[Source Code]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[VAT Bus_ Posting Group]
   ,[VAT Reporting Date]
   ,[Canceled]
   ,[Canceled By]
   ,[Canceled Date]
   ,[Canceled By Document No_]
   ,[Format Region]
   ,[Company Bank Account Code]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Issued Fin_ Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Issued Fin_ Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Issued Fin. Charge Memo Header]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Issued Fin. Charge Memo Header].[Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Issued Fin. Charge Memo Header].[City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Issued Fin. Charge Memo Header].[Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Issued Fin. Charge Memo Header].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Issued Fin. Charge Memo Header].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Issued Fin. Charge Memo Header].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
      ON
         [Issued Fin. Charge Memo Header].[Customer Posting Group] = [Customer Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Issued Fin. Charge Memo Header].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Issued Fin. Charge Memo Header].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Issued Fin. Charge Memo Header].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Issued Fin. Charge Memo Header].[Canceled By] = [User].[User Name]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Issued Fin. Charge Memo Header].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Issued Fin. Charge Memo Header].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Issued Fin. Charge Memo Header].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Issued Fin. Charge Memo Header table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
2Customer No. SearchCustomer No.NormalCode20Customer No_nvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Issued Fin. Charge Memo Header].[Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Issued Fin_ Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Issued Fin. Charge Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Issued Fin. Charge Memo Header].[Customer No_] = [Customer].[No_]
3Name SearchNameNormalText100Namenvarchar(200)
4Name 2 SearchName 2NormalText50Name 2nvarchar(100)
5Address SearchAddressNormalText100Addressnvarchar(200)
6Address 2 SearchAddress 2NormalText50Address 2nvarchar(100)
7Post Code SearchZIP CodeNormalCode20Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Issued Fin. Charge Memo Header].[Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Issued Fin_ Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Issued Fin. Charge Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Issued Fin. Charge Memo Header].[Post Code] = [Post Code].[Code]
8City SearchCityNormalText30Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Issued Fin. Charge Memo Header].[City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Issued Fin_ Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Issued Fin. Charge Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Issued Fin. Charge Memo Header].[City] = [Post Code].[City]
9County SearchStateNormalText30Countynvarchar(60)
10Country/Region Code SearchCountry/Region CodeNormalCode10Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Issued Fin. Charge Memo Header].[Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Issued Fin_ Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Issued Fin. Charge Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Issued Fin. Charge Memo Header].[Country_Region Code] = [Country/Region].[Code]
11Language Code SearchLanguage CodeNormalCode10Language Codenvarchar(20)
Key to join to the Language table.

Show/hide example query

SELECT
       [Issued Fin. Charge Memo Header].[Language Code]
       ,[Language].[Code]
FROM
       [CRONUS UK Ltd_$Issued Fin_ Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Issued Fin. Charge Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
              ON
                     [Issued Fin. Charge Memo Header].[Language Code] = [Language].[Code]
12Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Issued Fin. Charge Memo Header].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Issued Fin_ Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Issued Fin. Charge Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Issued Fin. Charge Memo Header].[Currency Code] = [Currency].[Code]
13Contact SearchContactNormalText100Contactnvarchar(200)
14Your Reference SearchYour ReferenceNormalText35Your Referencenvarchar(70)
15Shortcut Dimension 1 Code SearchShortcut Dimension 1 CodeNormalCode20Shortcut Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Issued Fin. Charge Memo Header].[Shortcut Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Issued Fin_ Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Issued Fin. Charge Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Issued Fin. Charge Memo Header].[Shortcut Dimension 1 Code] = [Dimension].[Code]
16Shortcut Dimension 2 Code SearchShortcut Dimension 2 CodeNormalCode20Shortcut Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Issued Fin. Charge Memo Header].[Shortcut Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Issued Fin_ Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Issued Fin. Charge Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Issued Fin. Charge Memo Header].[Shortcut Dimension 2 Code] = [Dimension].[Code]
17Customer Posting Group SearchCustomer Posting GroupNormalCode20Customer Posting Groupnvarchar(40)
Key to join to the Customer Posting Group table.

Show/hide example query

SELECT
       [Issued Fin. Charge Memo Header].[Customer Posting Group]
       ,[Customer Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Issued Fin_ Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Issued Fin. Charge Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
              ON
                     [Issued Fin. Charge Memo Header].[Customer Posting Group] = [Customer Posting Group].[Code]
18Gen. Bus. Posting Group SearchGen. Bus. Posting GroupNormalCode20Gen_ Bus_ Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

SELECT
       [Issued Fin. Charge Memo Header].[Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Issued Fin_ Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Issued Fin. Charge Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Issued Fin. Charge Memo Header].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
19VAT Registration No. SearchTax Registration No.NormalText20VAT Registration No_nvarchar(40)
20Reason Code SearchReason CodeNormalCode10Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

SELECT
       [Issued Fin. Charge Memo Header].[Reason Code]
       ,[Reason Code].[Code]
FROM
       [CRONUS UK Ltd_$Issued Fin_ Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Issued Fin. Charge Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
              ON
                     [Issued Fin. Charge Memo Header].[Reason Code] = [Reason Code].[Code]
21Posting Date SearchPosting DateNormalDate4Posting Datedatetime
22Document Date SearchDocument DateNormalDate4Document Datedatetime
23Due Date SearchDue DateNormalDate4Due Datedatetime
25Fin. Charge Terms Code SearchFin. Charge Terms CodeNormalCode10Fin_ Charge Terms Codenvarchar(20)
Key to join to the Finance Charge Terms table.

Show/hide example query

SELECT
       [Issued Fin. Charge Memo Header].[Fin_ Charge Terms Code]
       ,[Finance Charge Terms].[Code]
FROM
       [CRONUS UK Ltd_$Issued Fin_ Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Issued Fin. Charge Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Finance Charge Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Finance Charge Terms]
              ON
                     [Issued Fin. Charge Memo Header].[Fin_ Charge Terms Code] = [Finance Charge Terms].[Code]
26Interest Posted SearchInterest PostedNormalBoolean4Interest Postedtinyint
27Additional Fee Posted SearchAdditional Fee PostedNormalBoolean4Additional Fee Postedtinyint
29Posting Description SearchPosting DescriptionNormalText100Posting Descriptionnvarchar(200)
30Comment SearchCommentFlowFieldBoolean4
31Remaining Amount SearchRemaining AmountFlowFieldDecimal12
32Interest Amount SearchInterest AmountFlowFieldDecimal12
33Additional Fee SearchAdditional FeeFlowFieldDecimal12
34VAT Amount SearchTax AmountFlowFieldDecimal12
35No. Printed SearchNo. PrintedNormalInteger4No_ Printedint
36User ID SearchUser IDNormalCode50User IDnvarchar(100)
37No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Issued Fin. Charge Memo Header].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Issued Fin_ Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Issued Fin. Charge Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Issued Fin. Charge Memo Header].[No_ Series] = [No. Series].[Code]
38Pre-Assigned No. Series SearchPre-Assigned No. SeriesNormalCode20Pre-Assigned No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Issued Fin. Charge Memo Header].[Pre-Assigned No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Issued Fin_ Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Issued Fin. Charge Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Issued Fin. Charge Memo Header].[Pre-Assigned No_ Series] = [No. Series].[Code]
39Pre-Assigned No. SearchPre-Assigned No.NormalCode20Pre-Assigned No_nvarchar(40)
40Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Issued Fin. Charge Memo Header].[Source Code]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Issued Fin_ Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Issued Fin. Charge Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Issued Fin. Charge Memo Header].[Source Code] = [Source Code].[Code]
41Tax Area Code SearchTax Area CodeNormalCode20Tax Area Codenvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
       [Issued Fin. Charge Memo Header].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Issued Fin_ Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Issued Fin. Charge Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Issued Fin. Charge Memo Header].[Tax Area Code] = [Tax Area].[Code]
42Tax Liable SearchTax LiableNormalBoolean4Tax Liabletinyint
43VAT Bus. Posting Group SearchVAT Bus. Posting GroupNormalCode20VAT Bus_ Posting Groupnvarchar(40)
Key to join to the VAT Business Posting Group table.

Show/hide example query

SELECT
       [Issued Fin. Charge Memo Header].[VAT Bus_ Posting Group]
       ,[VAT Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Issued Fin_ Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Issued Fin. Charge Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
              ON
                     [Issued Fin. Charge Memo Header].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
44VAT Reporting Date SearchTax DateNormalDate4VAT Reporting Datedatetime
50Canceled SearchCanceledNormalBoolean4Canceledtinyint
51Canceled By SearchCanceled ByNormalCode50Canceled Bynvarchar(100)
Key to join to the User table.

Show/hide example query

SELECT
       [Issued Fin. Charge Memo Header].[Canceled By]
       ,[User].[User Name]
FROM
       [CRONUS UK Ltd_$Issued Fin_ Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Issued Fin. Charge Memo Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Issued Fin. Charge Memo Header].[Canceled By] = [User].[User Name]
52Canceled Date SearchCanceled DateNormalDate4Canceled Datedatetime
53Canceled By Document No. SearchCanceled By Document No.NormalCode20Canceled By Document No_nvarchar(40)
54Format Region SearchFormat RegionNormalText80Format Regionnvarchar(160)
163Company Bank Account Code SearchCompany Bank Account CodeNormalCode20Company Bank Account Codenvarchar(40)
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Issued Fin. Charge Memo Header].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Issued Fin_ Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Issued Fin. Charge Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Issued Fin. Charge Memo Header].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Issued Fin. Charge Memo Header].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Issued Fin_ Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Issued Fin. Charge Memo Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Issued Fin. Charge Memo Header].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Issued Fin. Charge Memo Header].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Issued Fin_ Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Issued Fin. Charge Memo Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Issued Fin. Charge Memo Header].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Issued Fin. Charge Memo Header table

Leave a Reply

Your email address will not be published. Required fields are marked *