Payment Terms

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

Table Type: Company

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

Table Number: 3

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Code]
   ,[Due Date Calculation]
   ,[Discount Date Calculation]
   ,[Discount _]
   ,[Description]
   ,[Calc_ Pmt_ Disc_ on Cr_ Memos]
   ,[Last Modified Date Time]
   ,[Coupled to CRM]
   ,[Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Payment Terms table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(20)
3Due Date Calculation Searchvarchar(32)
4Discount Date Calculation Searchvarchar(32)
5Discount _ Searchdecimal(38,38)
6Description Searchnvarchar(200)
7Calc_ Pmt_ Disc_ on Cr_ Memos Searchtinyint
8Last Modified Date Time Searchdatetime
9Coupled to CRM Searchtinyint
10Id Searchuniqueidentifier
11$systemId Searchuniqueidentifier
12$systemCreatedAt Searchdatetime
13$systemCreatedBy Searchuniqueidentifier
14$systemModifiedAt Searchdatetime
15$systemModifiedBy Searchuniqueidentifier

Show/hide tables related to Payment Terms table

Leave a Reply

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