Native – Payment

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

Table Type: Company

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

Table Number: 2831

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 Native – Payment can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT

FROM
   [CRONUS UK Ltd_$Native - Payment$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Native - Payment$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Native - Payment]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Native - Payment].[Customer Id] = [Customer].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Header]
      ON
         [Native - Payment].[Applies-to Invoice Id] = [Sales Invoice Header].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
      ON
         [Native - Payment].[Payment Method Id] = [Payment Method].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
      ON
         [Native - Payment].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Native - Payment].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Native - Payment].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Native – Payment table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Ledger Entry No. SearchLedger Entry No.NormalInteger4Ledger Entry No_int
Key to join to the G/L Entry table.

Show/hide example query

SELECT
       [Native - Payment].[Ledger Entry No_]
       ,[G/L Entry].[Entry No_]
FROM
       [CRONUS UK Ltd_$Native - Payment$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Native - Payment]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry]
              ON
                     [Native - Payment].[Ledger Entry No_] = [G/L Entry].[Entry No_]
2Payment No. Primary Key SearchPayment No.NormalInteger4Payment No_int
3Customer Id SearchCustomer IdNormalGUID16Customer Iduniqueidentifier
Key to join to the Customer table.

Show/hide example query

SELECT
       [Native - Payment].[Customer Id]
       ,[Customer].[$systemId]
FROM
       [CRONUS UK Ltd_$Native - Payment$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Native - Payment]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Native - Payment].[Customer Id] = [Customer].[$systemId]
4Customer No. SearchCustomer No.NormalCode20Customer No_nvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Native - Payment].[Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Native - Payment$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Native - Payment]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Native - Payment].[Customer No_] = [Customer].[No_]
5Payment Date SearchPayment DateNormalDate4Payment Datedatetime
6Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
7Applies-to Invoice Id Primary Key SearchApplies-to Invoice IdNormalGUID16Applies-to Invoice Iduniqueidentifier
Key to join to the Sales Invoice Header table.

Show/hide example query

SELECT
       [Native - Payment].[Applies-to Invoice Id]
       ,[Sales Invoice Header].[$systemId]
FROM
       [CRONUS UK Ltd_$Native - Payment$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Native - Payment]
LEFT JOIN
       [CRONUS UK Ltd_$Sales Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Header]
              ON
                     [Native - Payment].[Applies-to Invoice Id] = [Sales Invoice Header].[$systemId]
8Applies-to Invoice No. SearchApplies-to Invoice No.NormalCode20Applies-to Invoice No_nvarchar(40)
9Payment Method Id SearchPayment Method IdNormalGUID16Payment Method Iduniqueidentifier
Key to join to the Payment Method table.

Show/hide example query

SELECT
       [Native - Payment].[Payment Method Id]
       ,[Payment Method].[$systemId]
FROM
       [CRONUS UK Ltd_$Native - Payment$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Native - Payment]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
              ON
                     [Native - Payment].[Payment Method Id] = [Payment Method].[$systemId]
10Payment Method Code SearchPayment Method CodeNormalCode10Payment Method Codenvarchar(20)
Key to join to the Payment Method table.

Show/hide example query

SELECT
       [Native - Payment].[Payment Method Code]
       ,[Payment Method].[Code]
FROM
       [CRONUS UK Ltd_$Native - Payment$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Native - Payment]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
              ON
                     [Native - Payment].[Payment Method Code] = [Payment Method].[Code]
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
       [Native - Payment].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Native - Payment$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Native - Payment]
LEFT JOIN
       [User] AS [User]
              ON
                     [Native - Payment].[$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
       [Native - Payment].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Native - Payment$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Native - Payment]
LEFT JOIN
       [User] AS [User]
              ON
                     [Native - Payment].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Native – Payment table

Leave a Reply

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