Customer Posting Group

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

Table Type: Company

Table Name: Customer Posting Group
Database Table Name: CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 92

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 Customer Posting Group can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Code]
   ,[Receivables Account]
   ,[Service Charge Acc_]
   ,[Payment Disc_ Debit Acc_]
   ,[Invoice Rounding Account]
   ,[Additional Fee Account]
   ,[Interest Account]
   ,[Debit Curr_ Appln_ Rndg_ Acc_]
   ,[Credit Curr_ Appln_ Rndg_ Acc_]
   ,[Debit Rounding Account]
   ,[Credit Rounding Account]
   ,[Payment Disc_ Credit Acc_]
   ,[Payment Tolerance Debit Acc_]
   ,[Payment Tolerance Credit Acc_]
   ,[Add_ Fee per Line Account]
   ,[Description]
   ,[View All Accounts on Lookup]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Customer Posting Group table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(40)
3Receivables Account Searchnvarchar(40)
4Service Charge Acc_ Searchnvarchar(40)
5Payment Disc_ Debit Acc_ Searchnvarchar(40)
6Invoice Rounding Account Searchnvarchar(40)
7Additional Fee Account Searchnvarchar(40)
8Interest Account Searchnvarchar(40)
9Debit Curr_ Appln_ Rndg_ Acc_ Searchnvarchar(40)
10Credit Curr_ Appln_ Rndg_ Acc_ Searchnvarchar(40)
11Debit Rounding Account Searchnvarchar(40)
12Credit Rounding Account Searchnvarchar(40)
13Payment Disc_ Credit Acc_ Searchnvarchar(40)
14Payment Tolerance Debit Acc_ Searchnvarchar(40)
15Payment Tolerance Credit Acc_ Searchnvarchar(40)
16Add_ Fee per Line Account Searchnvarchar(40)
17Description Searchnvarchar(200)
18View All Accounts on Lookup Searchtinyint
19$systemId Searchuniqueidentifier
20$systemCreatedAt Searchdatetime
21$systemCreatedBy Searchuniqueidentifier
22$systemModifiedAt Searchdatetime
23$systemModifiedBy Searchuniqueidentifier

Show/hide tables related to Customer Posting Group table

Leave a Reply

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