Bank Export_Import Setup

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

Table Type: Company

Table Name: Bank Export_Import Setup
Database Table Name: CRONUS UK Ltd_$Bank Export_Import Setup$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 1200

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 Bank Export_Import Setup can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Bank Export_Import Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Code]
   ,[Name]
   ,[Direction]
   ,[Processing Codeunit ID]
   ,[Processing XMLport ID]
   ,[Data Exch_ Def_ Code]
   ,[Preserve Non-Latin Characters]
   ,[Check Export Codeunit]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Bank Export_Import Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Bank Export_Import Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(40)
3Name Searchnvarchar(200)
4Direction Searchint
5Processing Codeunit ID Searchint
6Processing XMLport ID Searchint
7Data Exch_ Def_ Code Searchnvarchar(40)
8Preserve Non-Latin Characters Searchtinyint
9Check Export Codeunit Searchint
10$systemId Searchuniqueidentifier
11$systemCreatedAt Searchdatetime
12$systemCreatedBy Searchuniqueidentifier
13$systemModifiedAt Searchdatetime
14$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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