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
   [timestamp]
   ,[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 columns in Payment Registration Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2User ID Primary Key Searchnvarchar(100)
3Journal Template Name Searchnvarchar(20)
4Journal Batch Name Searchnvarchar(20)
5Bal_ Account Type Searchint
6Bal_ Account No_ Searchnvarchar(40)
7Use this Account as Def_ Searchtinyint
8Auto Fill Date Received Searchtinyint
9$systemId Searchuniqueidentifier
10$systemCreatedAt Searchdatetime
11$systemCreatedBy Searchuniqueidentifier
12$systemModifiedAt Searchdatetime
13$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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