Payment Registration Buffer

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

Table Type: Company

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

Table Number: 981

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 Buffer can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Ledger Entry No_]
   ,[Source No_]
   ,[Document Type]
   ,[Document No_]
   ,[Description]
   ,[Due Date]
   ,[Name]
   ,[Remaining Amount]
   ,[Payment Made]
   ,[Date Received]
   ,[Amount Received]
   ,[Original Remaining Amount]
   ,[Rem_ Amt_ after Discount]
   ,[Pmt_ Discount Date]
   ,[Limit Amount Received]
   ,[Payment Method Code]
   ,[Bal_ Account Type]
   ,[Bal_ Account No_]
   ,[External Document No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Payment Registration Buffer$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 Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Registration Buffer]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
      ON
         [Payment Registration Buffer].[Payment Method Code] = [Payment Method].[Code]

Show/hide columns in Payment Registration Buffer table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Ledger Entry No_ Primary Key Searchint
3Source No_ Searchnvarchar(40)
4Document Type Searchint
5Document No_ Searchnvarchar(40)
6Description Searchnvarchar(200)
7Due Date Searchdatetime
8Name Searchnvarchar(200)
9Remaining Amount Searchdecimal(38,38)
10Payment Made Searchtinyint
11Date Received Searchdatetime
12Amount Received Searchdecimal(38,38)
13Original Remaining Amount Searchdecimal(38,38)
14Rem_ Amt_ after Discount Searchdecimal(38,38)
15Pmt_ Discount Date Searchdatetime
16Limit Amount Received Searchtinyint
17Payment Method Code Searchnvarchar(20)
Key to join to the Payment Method table.

Show/hide example query

SELECT
       [Payment Registration Buffer].[Payment Method Code]
       ,[Payment Method].[Code]
FROM
       [CRONUS UK Ltd_$Payment Registration Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Registration Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
              ON
                     [Payment Registration Buffer].[Payment Method Code] = [Payment Method].[Code]
18Bal_ Account Type Searchint
19Bal_ Account No_ Searchnvarchar(40)
20External Document No_ Searchnvarchar(70)
21$systemId Searchuniqueidentifier
22$systemCreatedAt Searchdatetime
23$systemCreatedBy Searchuniqueidentifier
24$systemModifiedAt Searchdatetime
25$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Payment Registration Buffer table

Leave a Reply

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