Payment Registration Setup

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

Table Type: Company

Table Name: Payment Registration Setup
Database Table Name: CRONUS UK Ltd_$Payment Registration Setup$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 980

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 Payment Registration Setup can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Payment Registration Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [User ID]
   ,[Journal Template Name]
   ,[Journal Batch Name]
   ,[Bal_ Account Type]
   ,[Bal_ Account No_]
   ,[Use this Account as Def_]
   ,[Auto Fill Date Received]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Payment Registration Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Payment Registration Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Registration Setup]
LEFT JOIN
   [User] AS [User]
      ON
         [Payment Registration Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Payment Registration Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Payment Registration Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1User ID Primary Key SearchUser IDNormalCode50User IDnvarchar(100)
2Journal Template Name SearchJournal Template NameNormalCode10Journal Template Namenvarchar(20)
3Journal Batch Name SearchJournal Batch NameNormalCode10Journal Batch Namenvarchar(20)
4Bal. Account Type SearchBal. Account TypeNormalOption4Bal_ Account Typeint
Available options are:
  • ” “
  • “G/L Account”
  • “Bank Account”
5Bal. Account No. SearchBal. Account No.NormalCode20Bal_ Account No_nvarchar(40)
6Use this Account as Def. SearchUse this Account as Def.NormalBoolean4Use this Account as Def_tinyint
7Auto Fill Date Received SearchAuto Fill Date ReceivedNormalBoolean4Auto Fill Date Receivedtinyint
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
       [Payment Registration Setup].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Payment Registration Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Registration Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Payment Registration Setup].[$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
       [Payment Registration Setup].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Payment Registration Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Registration Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Payment Registration Setup].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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