`

Matillion ETL Data Model for DynamicsNAV
Version - 16.0.6375

Note: Data models are true for the latest version of Matillion ETL. If you are on an older version or using a component from an old job, your experience may differ.




Connection String OptionsBack To Top

  1. Auth Scheme
  2. Auto Cache
  3. Cache Connection
  4. Cache Driver
  5. Cache Location
  6. Cache Metadata
  7. Cache Query Result
  8. Company
  9. Connect On Open
  10. Continue On Error
  11. Firewall Password
  12. Firewall Port
  13. Firewall Server
  14. Firewall Type
  15. Firewall User
  16. Location
  17. Logfile
  18. Max Log File Size
  19. Offline
  20. Other
  21. Password
  22. Proxy Auth Scheme
  23. Proxy Auto Detect
  24. Proxy Password
  25. Proxy Port
  26. Proxy Server
  27. Proxy SSL Type
  28. Proxy User
  29. Pseudo Columns
  30. Query Cache
  31. Readonly
  32. RTK
  33. Server Instance
  34. SSL Server Cert
  35. Support Enhanced SQL
  36. Tables
  37. Tenant
  38. Timeout
  39. Url
  40. User
  41. Verbosity
  42. Views



Auth Scheme

The scheme used for authentication. Accepted entries are NTLM, BASIC, DIGEST, NONE, or NEGOTIATE. NEGOTIATE is the default option.
Data Type

string

Default Value

"NEGOTIATE"

Remarks

Together with Password and User, this field is used to authenticate against the server. NEGOTIATE is the default option. Use the following options to select your authentication scheme:





Auto Cache

Persists the results of SELECT queries, allowing real-time reporting while online and use while offline.
Data Type

bool

Default Value

false

Remarks

When AutoCache is set, the driver maintains a cache in the background. The driver can update the cache when you execute a SELECT query to the remote DynamicsNAV data.

This functionality gives you the option to query a persistent, up-to-date cache or execute real-time queries with a failover solution for connectivity loss.

Caching on Every SELECT

CacheQueryResult is a way to query DynamicsNAV in real time while maintaining a cache for offline use. Set CacheQueryResult to update the cache whenever you execute a SELECT statement. When you execute a SELECT statement with AutoCache and CacheQueryResult set, the driver executes the query to the remote data and persists the results; rows that already exist are overwritten. That is, SELECT statements are used to create and refresh the cache, not to query it. Data manipulation commands are executed to the remote data as well.

To query the cached data, set the Offline property. If you need to query the cached data in an online connection, you can append #CACHE to the table name. For example:

SELECT * FROM [Customer#CACHE]

Setting the Caching Database

When AutoCache is set, the driver caches to a simple, file-based cache. You can configure its location or cache to a different database with the following properties:

See Also





Cache Connection

The connection string for the cache database.
Data Type

string

Default Value

""

Remarks

The cache database is determined based on the CacheDriver and CacheConnection properties. You will need at least the following information to connect to one of the caching databases below. To load the caching database's driver, refer to CacheDriver.

The connection string specified in the CacheConnection property is passed directly to the underlying CacheDriver. The documentation for the underlying JDBC driver will have all of the available properties.

Derby and Java DB

In most caching scenarios, you need to set only the following:

For other Java DB configurations, you will need to use CacheDriver and CacheConnection. Below is the Derby JDBC URL syntax:

jdbc:derby:[subsubprotocol:][databaseName][;attribute=value[;attribute=value] ... ]
For example, to cache to an in-memory database, use the following:
jdbc:derby:memory

SQLite

To cache to SQLite, you can use the SQLite JDBC driver. Below is the syntax of the JDBC URL:

jdbc:sqlite:dataSource

MySQL

The installation includes the CData JDBC Driver for MySQL. Below is an example JDBC URL:

jdbc:mysql:User=root;Password=root;Server=localhost;Port=3306;Database=cache
Below are typical connection properties:

SQL Server

The JDBC URL for the Microsoft JDBC Driver for SQL Server has the following syntax:

jdbc:sqlserver://[serverName[\instance][:port]][;database=databaseName][;property=value[;property=value] ... ]
For example:
jdbc:sqlserver://localhost\sqlexpress:1433;integratedSecurity=true
Below are typical SQL Server connection properties:
Oracle

Below is the conventional JDBC URL syntax for the Oracle JDBC Thin driver:

jdbc:oracle:thin:[userId/password]@[//]host[[:port][:sid]]
For example:
jdbc:oracle:thin:scott/tiger@myhost:1521:orcl
Below are typical connection properties:
PostgreSQL

Below is the JDBC URL syntax for the official PostgreSQL JDBC driver:

jdbc:postgresql:[//[host[:port]]/]database[[?option=value][[&option=value][&option=value] ... ]]
For example, the following connection string connects to a database on the default host (localhost) and port (5432):
jdbc:postgresql:postgres
Below are typical connection properties:





Cache Driver

The database driver to be used to cache data.
Data Type

string

Default Value

""

Remarks

You can cache to any database that you have a JDBC driver for, including CData JDBC drivers.

The cache database is determined based on the CacheDriver and CacheConnection properties. The CacheDriver is the name of the JDBC driver class that you would like to use to cache data.

Note that you must also add the CacheDriver JAR to the classpath.

The following examples show how to cache to several major databases. Refer to CacheConnection for more information on the JDBC URL syntax and typical connection properties.

Derby and Java DB

The driver simplifies Java DB configuration. Java DB is the Oracle distribution of Derby. The JAR is shipped in the JDK. You can find the JAR, derby.jar, in the db subfolder of the JDK installation. In most caching scenarios, you need to specify only the following, after adding derby.jar to the classpath.

jdbc:dynamicsnav:CacheLocation='c:/Temp/cachedir';URL=http://myserver:7048;User=myserver\Administrator;Password=admin;ServerInstance=DYNAMICSNAV71;
To customize the Java DB JDBC URL, use CacheProvider and CacheConnection. For example, to cache to an in-memory database, use a JDBC URL like the following:
jdbc:dynamicsnav:CacheDriver=org.apache.derby.jdbc.EmbeddedDriver;CacheConnection='jdbc:derby:memory';URL=http://myserver:7048;User=myserver\Administrator;Password=admin;ServerInstance=DYNAMICSNAV71;
SQLite

Below is a JDBC URL for the SQLite JDBC driver:

jdbc:dynamicsnav:CacheDriver=org.sqlite.JDBC;CacheConnection='jdbc:sqlite:C:/Temp/sqlite.db';URL=http://myserver:7048;User=myserver\Administrator;Password=admin;ServerInstance=DYNAMICSNAV71;
MySQL

Below is a JDBC URL for the included CData JDBC Driver for MySQL:

jdbc:dynamicsnav:Cache Driver=cdata.jdbc.mysql.MySQLDriver;Cache Connection='jdbc:mysql:Server=localhost;Port=3306;Database=cache;User=root;Password=123456';URL=http://myserver:7048;User=myserver\Administrator;Password=admin;ServerInstance=DYNAMICSNAV71;
The CData JDBC Driver for MySQL is located in the lib subfolder of the CData JDBC Driver for DynamicsNAV 2016 installation directory.
SQL Server

The following JDBC URL uses the Microsoft JDBC Driver for SQL Server:

jdbc:dynamicsnav:Cache Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver;Cache Connection='jdbc:sqlserver://localhost\sqlexpress:7437;user=sa;password=123456;databaseName=Cache';URL=http://myserver:7048;User=myserver\Administrator;Password=admin;ServerInstance=DYNAMICSNAV71;
Oracle

Below is a JDBC URL for the Oracle Thin Client:

jdbc:dynamicsnav:Cache Driver=oracle.jdbc.driver.OracleDriver;CacheConnection='jdbc:oracle:thin:scott/tiger@localhost:1521:orcldb';URL=http://myserver:7048;User=myserver\Administrator;Password=admin;ServerInstance=DYNAMICSNAV71;
PostgreSQL

The following JDBC URL uses the official PostgreSQL JDBC driver:

jdbc:dynamicsnav:CacheDriver=org.postgresql.Driver;CacheConnection='jdbc:postgresql://localhost:5433/postgres?user=postgres&password=admin';URL=http://myserver:7048;User=myserver\Administrator;Password=admin;ServerInstance=DYNAMICSNAV71;





Cache Location

Specifies the path to the cache when caching to a file.
Data Type

string

Default Value

""

Remarks

The CacheLocation is a simple, file-based cache. The driver uses Java DB, Oracle's distribution of the Derby database. To cache to Java DB, you will need to add the Java DB JAR to the classpath. The JAR, derby.jar, is shipped in the JDK and located in the db subfolder of the JDK installation.

CacheLocation defaults to the directory specified by the Location setting.

See Also





Cache Metadata

Whether or not to cache the table metadata to a file store.
Data Type

bool

Default Value

false

Remarks

As you execute queries with this property set, the relevant system tables in the DynamicsNAV catalog are cached to the file store specified by CacheLocation.

Setting CacheMetadata and CacheLocation will retrieve metadata only once over multiple connections. For example, metadata will be retrieved only when a connection pool is initialized.

When to Use CacheMetadata

The driver automatically caches metadata in memory when you open a connection, so within the same connection schema discovery is only expensive on the first query. QueryCache only becomes useful when retrieving the system catalog on every connection open becomes expensive. For example, when you are working with large amounts of metadata or when you have many simultaneous, short-lived connections.

When Not to Use CacheMetadata





Cache Query Result

When CacheQueryResult and AutoCache is set, the entire result of every SELECT query is cached in the cache database.
Data Type

bool

Default Value

false

Remarks

When CacheQueryResult and AutoCache is set, the entire result of every SELECT query is cached in the cache database. Note that the performance can be significantly impacted when using AutoCache when the DynamicsNAV API does not support the REPLICATE Statements statement.





Company

The company to submit queries against. For example, 'CRONUS Canada, Inc.'.
Data Type

string

Default Value

""

Remarks

The company to submit queries against. For example, 'CRONUS Canada, Inc.'. This property is required if the Service Default Company has not been specified for the ServerInstance in question. If blank, the driver will submit queries to the server and attempt to use the Service Default Company.





Connect On Open

Species whether to connect to the DynamicsNAV when the connection is opened.
Data Type

bool

Default Value

false

Remarks

When set to 'true', a connection will be made to DynamicsNAV when the connection is opened. This property enables the 'Test Connection' feature available in various database tools.

This feature acts as a NOOP command as it is used to verify a connection can be made to DynamicsNAV and nothing from this initial connection is maintained.

Setting this property to 'false' may provide performance improvements (depending upon the number of times a connection is opened).





Continue On Error

Whether or not to continue after encountering an error on a batch request.
Data Type

bool

Default Value

false

Remarks

This connection property is only supported on servers with OData version 4.0 and higher. However, individual servers may choose to ignore this setting. Setting ContinueOnError to true will cause exceptions to be returned in the temporary table instead of being thrown when a batch request is attempted.





Firewall Password

A password used to authenticate to a proxy-based firewall.
Data Type

string

Default Value

""

Remarks

This property is passed to the proxy specified by FirewallServer and FirewallPort, following the authentication method specified by FirewallType.





Firewall Port

The TCP port for a proxy-based firewall.
Data Type

string

Default Value

""

Remarks

This specifies the TCP port for a proxy allowing traversal of a firewall. Use FirewallServer to specify the name or IP address. Specify the protocol with FirewallType.





Firewall Server

The name or IP address of a proxy-based firewall.
Data Type

string

Default Value

""

Remarks

This property specifies the IP address, DNS name, or host name of a proxy allowing traversal of a firewall. The protocol is specified by FirewallType: Use FirewallServer with this property to connect through SOCKS or do tunneling. Use ProxyServer to connect to an HTTP proxy.

Note that the driver uses the system proxy by default. To use a different proxy, set ProxyAutoDetect to false.





Firewall Type

The protocol used by a proxy-based firewall.
Data Type

string

Default Value

"NONE"

Remarks

This property specifies the protocol that the driver will use to tunnel traffic through the FirewallServer proxy. Note that by default the driver connects to the system proxy; to disable this behavior and connect to one of the following proxy types, set ProxyAutoDetect to false.

Type Default Port Description
TUNNEL 80 When this is set, the driver opens a connection to DynamicsNAV and traffic flows back and forth through the proxy.
SOCKS4 1080 When this is set, the driver sends data through the SOCKS 4 proxy specified by FirewallServer and FirewallPort and passes the FirewallUser value to the proxy, which determines if the connection request should be granted.
SOCKS5 1080 When this is set, the driver sends data through the SOCKS 5 proxy specified by FirewallServer and FirewallPort. If your proxy requires authentication, set FirewallUser and FirewallPassword to credentials the proxy recognizes.

To connect to HTTP proxies, use ProxyServer and ProxyPort. To authenticate to HTTP proxies, use ProxyAuthScheme, ProxyUser, and ProxyPassword.





Firewall User

The user name to use to authenticate with a proxy-based firewall.
Data Type

string

Default Value

""

Remarks

The FirewallUser and FirewallPassword properties are used to authenticate against the proxy specified in FirewallServer and FirewallPort, following the authentication type specified in FirewallType.





Location

A path to the directory that contains the schema files defining tables, views, and stored procedures.
Data Type

string

Default Value

""

Remarks

The path to a directory which contains the schema files for the driver (.rsd files for tables and views, .rsb files for stored procedures). The Location property is only needed if you would like to customize definitions (e.g., change a column name, ignore a column, etc.) or extend the data model with new tables, views, or stored procedures.

The schema files used in your application must be deployed with other assemblies. You must also ensure that Location points to the folder that contains the schema files. The folder location can be a relative path from the location of the executable.





Logfile

A path to the log file.
Data Type

string

Default Value

""

Remarks

For more control over what is written to the log file, take a look at Verbosity.





Max Log File Size

A string specifying the maximum size in bytes for a log file (ex: 10MB). When the limit is hit, a new log is created in the same folder with the date and time appended to the end.
Data Type

string

Default Value

""

Remarks

A string specifying the maximum size in bytes for a log file (ex: 10MB). When the limit is hit, a new log is created in the same folder with the date and time appended to the end. There is no limit by default. Values lower than 100kB will use 100kB as the value instead.





Offline

Use offline mode to get the data from the cache instead of the live source.
Data Type

bool

Default Value

false

Remarks

When Offline is set to TRUE, all queries execute against the cache as opposed to the live data source. In this mode, certain queries like INSERT, UPDATE, DELETE, and CACHE are not allowed.





Other

The other parameters necessary to connect to a data source, such as username and password, when applicable.
Data Type

string

Default Value

""

Remarks

The Other property is a semicolon-separated list of name-value pairs used in connection parameters specific to a data source.

Caching Configuration

CachePartial=TrueCaches only a subset of columns, which you can specify in your query.
QueryPassthrough=TruePasses the specified query to the cache database instead of using the SQL parser of the driver.

Integration and Formatting

SupportAccessLinkedModeIn Access' linked mode, it is generally a good idea to always use a cache as most data sources do not support multiple Id queries. However if you want to use the driver in Access but not in linked mode, this property must be set to False to avoid using a cache of a SELECT * query for the given table.
ConvertDateTimeToGMTWhether to convert date-time values to GMT, instead of the local time of the machine.
RecordToFile=filenameRecords the underlying socket data transfer to the specified file.
ClientCultureThis property can be used to specify the format of data (e.g., currency values) that is accepted by the client application. This property can be used when the client application does not support the machine's culture settings. For example, Microsoft Access requires 'en-US'.
CultureThis setting can be used to specify culture settings that determine how the driver interprets certain data types that are passed into the driver. For example, setting Culture='de-DE' will output German formats even on an American machine.





Password

The password used to authenticate to the Dynamics NAV server.
Data Type

string

Default Value

""

Remarks

The password used to authenticate to the Dynamics NAV server.





Proxy Auth Scheme

The authentication type to use to authenticate to the ProxyServer proxy.
Data Type

string

Default Value

"BASIC"

Remarks

This value specifies the authentication type to use to authenticate to the HTTP proxy specified by ProxyServer and ProxyPort.

Note that the driver will use the system proxy settings by default, without further configuration needed; if you want to connect to another proxy, you will need to set ProxyAutoDetect to false, in addition to ProxyServer and ProxyPort. To authenticate, set ProxyAuthScheme and set ProxyUser and ProxyPassword, if needed.

The authentication type can be one of the following:

If you need to use another authentication type, such as SOCKS 5 authentication, see FirewallType.





Proxy Auto Detect

This indicates whether to use the system proxy settings or not. Set ProxyAutoDetect to FALSE to use custom proxy settings. This takes precedence over other proxy settings.
Data Type

bool

Default Value

true

Remarks

By default, the driver uses the system HTTP proxy. Set this to false if you want to connect to another proxy.

To connect to an HTTP proxy, see ProxyServer.

For other proxies, such as SOCKS or tunneling, see FirewallType.





Proxy Password

A password to be used to authenticate to the ProxyServer proxy.
Data Type

string

Default Value

""

Remarks

This property is used to authenticate to an HTTP proxy server that supports NTLM (Windows), Kerberos, or HTTP authentication. To specify the HTTP proxy, you can set ProxyServer and ProxyPort. To specify the authentication type, set ProxyAuthScheme.

If you are using HTTP authentication, additionally set ProxyUser and ProxyPassword to HTTP proxy.

If you are using NTLM authentication, set ProxyUser and ProxyPassword to your Windows password. You may also need these to complete Kerberos authentication.

For SOCKS 5 authentication or tunneling, see FirewallType.

By default, the driver uses the system proxy. If you want to connect to another proxy, set ProxyAutoDetect to false.





Proxy Port

The TCP port the ProxyServer proxy is running on.
Data Type

string

Default Value

"80"

Remarks

The port the HTTP proxy is running on that you want to redirect HTTP traffic through. Specify the HTTP proxy in ProxyServer. For other proxy types, see FirewallType.





Proxy Server

The hostname or IP address of a proxy to route HTTP traffic through.
Data Type

string

Default Value

""

Remarks

The hostname or IP address of a proxy to route HTTP traffic through. The driver can use the HTTP, Windows (NTLM), or Kerberos authentication types to authenticate to an HTTP proxy.

If you need to connect through a SOCKS proxy or tunnel the connection, see FirewallType.

By default, the driver uses the system proxy. If you need to use another proxy, set ProxyAutoDetect to false.





Proxy SSL Type

The SSL type to use when connecting to the ProxyServer proxy.
Data Type

string

Default Value

"AUTO"

Remarks

This property determines when to use SSL for the connection to an HTTP proxy specified by ProxyServer. This value can be AUTO, ALWAYS, NEVER, or TUNNEL. The applicable values are the following:

AUTODefault setting. If the URL is an HTTPS URL, the driver will use the TUNNEL option. If the URL is an HTTP URL, the component will use the NEVER option.
ALWAYSThe connection is always SSL enabled.
NEVERThe connection is not SSL enabled.
TUNNELThe connection is through a tunneling proxy: The proxy server opens a connection to the remote host and traffic flows back and forth through the proxy.





Proxy User

A user name to be used to authenticate to the ProxyServer proxy.
Data Type

string

Default Value

""

Remarks

The ProxyUser and ProxyPassword options are used to connect and authenticate against the HTTP proxy specified in ProxyServer.

You can select one of the available authentication types in ProxyAuthScheme. If you are using HTTP authentication, set this to the username of a user recognized by the HTTP proxy. If you are using Windows or Kerberos authentication, set this property to a username in one of the following formats:

user@domain
domain\user





Pseudo Columns

Indicates whether or not to include pseudo columns as columns to the table.
Data Type

string

Default Value

""

Remarks

This setting is particularly helpful in Entity Framework, which does not allow you to set a value for a pseudo column unless it is a table column. The value of this connection setting is of the format "Table1=Column1, Table1=Column2, Table2=Column3". You can use the "*" character to include all tables and all columns; i.e., "*=*".





Query Cache

The time duration, in seconds, for which data is cached in memory and reused.
Data Type

string

Default Value

""

Remarks

The QueryCache property allows you to cache the results of a query in memory and use them until the cache expires. The cache expires after the seconds specified in this property. The in-memory query cache is shared across connections, so it can help with performance even if more than one connection is being used.

How QueryCache Works

The cache manager for QueryCache will not only use the cache for exactly the same query, but also use the cache for queries that represent a subset of data in the cached query. For example, in the following queries, the cache created while executing Query A will be used to obtain the results for both Query B and Query C.

SELECT * FROM Account; // Query A
SELECT * FROM Account WHERE Name LIKE '%John'; // Query B
SELECT Id, Name FROM Account LIMIT 10; // Query C

When to Use QueryCache

Setting the QueryCache property can improve performance in the following scenarios:

When Not to Use QueryCache





Readonly

You can use this property to enforce read-only access to DynamicsNAV from the provider.
Data Type

bool

Default Value

false

Remarks

If this property is set to true, the driver will allow only SELECT queries. INSERT, UPDATE, DELETE, and stored procedure queries will cause an error to be thrown.





RTK

The runtime key used for licensing.
Data Type

string

Default Value

""

Remarks

The RTK property may be used to license a build. Please see the included licensing file to see how to set this property. The runtime key is only available if you purchased an OEM license.





Server Instance

The instance of the Dynamics NAV server. For example, DynamicsNAV71.
Data Type

string

Default Value

""

Remarks

The instance of the Dynamics NAV server. For example, DynamicsNAV71.





SSL Server Cert

The certificate to be accepted from the server when connecting using TLS/SSL.
Data Type

string

Default Value

""

Remarks

If using a TLS/SSL connection, this property can be used to specify the TLS/SSL certificate to be accepted from the server. Any other certificate that is not trusted by the machine will be rejected.

This property can take the forms:

Description Example
A full PEM Certificate (example shortened for brevity) -----BEGIN CERTIFICATE----- MIIChTCCAe4CAQAwDQYJKoZIhv......Qw== -----END CERTIFICATE-----
A path to a local file containing the certificate C:\cert.cer
The public key (example shortened for brevity) -----BEGIN RSA PUBLIC KEY----- MIGfMA0GCSq......AQAB -----END RSA PUBLIC KEY-----
The MD5 Thumbprint (hex values can also be either space or colon separated) ecadbdda5a1529c58a1e9e09828d70e4
The SHA1 Thumbprint (hex values can also be either space or colon separated) 34a929226ae0819f2ec14b4a3d904f801cbb150d

If not specified, any certificate trusted by the machine will be accepted. Use '*' to signify to accept all certificates (not recommended for security concerns).





Support Enhanced SQL

If set to true, the provider will cache the entire table in memory and issue the current query against the memory cache. Allows queries with aggregate functions that are otherwise unsupported. The entire memory cache is discarded after the query is executed, unlike QueryCache.
Data Type

bool

Default Value

true

Remarks

Use QueryCache to cache memory for a given time in seconds or to disable in-memory caching.

Use QueryCache to cache in memory for a given time in seconds or to disable in-memory caching.





Tables

Comma-separated list of tables to be listed. For example: Tables=TableA,TableB,TableC.
Data Type

string

Default Value

""

Remarks

Listing the tables from some databases can be expensive. Providing a list of tables in the connection string improves the performance of the driver.





Tenant

Use this value to connect to a specific Tenant in a multitenant installation of DynamicsNAV.
Data Type

string

Default Value

""

Remarks

Specify the tenant Id to connect to a specific tenant in a multitenant installation of DynamicsNAV. For example, "Cronus1".





Timeout

The value in seconds until the timeout error is thrown, canceling the operation.
Data Type

string

Default Value

"60"

Remarks

If the Timeout property is set to 0, operations do not time out: They run until they complete successfully or encounter an error condition.

If Timeout expires and the operation is not yet complete, the driver throws an exception.





Url

URL to the DynamicsNAV server organization root. For example, http://MyServer:7048.
Data Type

string

Default Value

""

Remarks

URL to the DynamicsNAV server organization root. For example, http://MyServer:7048.





User

The user who is authenticating to the Dynamics NAV server.
Data Type

string

Default Value

""

Remarks

The user who is authenticating to the Dynamics NAV server.





Verbosity

The verbosity level that determines the amount of detail included in the log file.
Data Type

string

Default Value

"1"

Remarks

The verbosity level determines the amount of detail that the driver reports to the Logfile. Verbosity levels from 1 to 5 are supported. These are described below:

1Setting Verbosity to 1 will log the query, the number of rows returned by it, the start of execution and the time taken, and any errors.
2Setting Verbosity to 2 will log everything included in Verbosity 1, cache queries, and HTTP headers.
3Setting Verbosity to 3 will additionally log the body of the HTTP requests.
4Setting Verbosity to 4 will additionally log transport-level communication with the data source. This includes SSL negotiation.
5Setting Verbosity to 5 will additionally log communication with the data source and additional details that may be helpful in troubleshooting problems. This includes interface commands.

The Verbosity should not be set to greater than 1 for normal operation. Substantial amounts of data can be logged at higher verbosities, which can delay execution times.





Views

Comma-separated list of Views to be listed. For example: Views=ViewsA,ViewsB,ViewsC.
Data Type

string

Default Value

""

Remarks

Listing the Views from some databases can be expensive. Providing a list of Views in the connection string improves the performance of the driver.





TablesBack To Top

  1. Company
  2. Country
  3. Currency
  4. Customer
  5. GeneralProductPosting
  6. PurchaseLines
  7. PurchaseOrder
  8. PurchaseOrderPurchLines
  9. PurchaseOrders
  10. ResourceCard
  11. SalesOrder



Company

The DynamicsNAV table Company.

Columns

Name Type ReadOnly Description
Name [KEY] String False

The Name column for the table Company.

LinkedCountry String False

The LinkedCountry column for the table Company.

LinkedCurrency String False

The LinkedCurrency column for the table Company.

LinkedCustomer String False

The LinkedCustomer column for the table Company.

LinkedGeneralProductPosting String False

The LinkedGeneralProductPosting column for the table Company.

LinkedPurchaseLines String False

The LinkedPurchaseLines column for the table Company.

LinkedPurchaseOrder String False

The LinkedPurchaseOrder column for the table Company.

LinkedPurchaseOrderPurchLines String False

The LinkedPurchaseOrderPurchLines column for the table Company.

LinkedPurchaseOrders String False

The LinkedPurchaseOrders column for the table Company.

LinkedResourceCard String False

The LinkedResourceCard column for the table Company.

LinkedSalesOrder String False

The LinkedSalesOrder column for the table Company.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.





Country

The DynamicsNAV table Country.

Columns

Name Type ReadOnly Description
Code [KEY] String False

The Code column for the table Country.

Address_Format String False

The Address_Format column for the table Country.

Contact_Address_Format String False

The Contact_Address_Format column for the table Country.

ETag String False

The ETag column for the table Country.

EU_Country_Region_Code String False

The EU_Country_Region_Code column for the table Country.

Intrastat_Code String False

The Intrastat_Code column for the table Country.

Name String False

The Name column for the table Country.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.





Currency

The DynamicsNAV table Currency.

Columns

Name Type ReadOnly Description
Code [KEY] String False

The Code column for the table Currency.

Amount_Decimal_Places String False

The Amount_Decimal_Places column for the table Currency.

Amount_Rounding_Precision Decimal False

The Amount_Rounding_Precision column for the table Currency.

Appln_Rounding_Precision Decimal False

The Appln_Rounding_Precision column for the table Currency.

Conv_LCY_Rndg_Credit_Acc String False

The Conv_LCY_Rndg_Credit_Acc column for the table Currency.

Conv_LCY_Rndg_Debit_Acc String False

The Conv_LCY_Rndg_Debit_Acc column for the table Currency.

CurrencyFactor Decimal False

The CurrencyFactor column for the table Currency.

Description String False

The Description column for the table Currency.

EMU_Currency Boolean False

The EMU_Currency column for the table Currency.

ETag String False

The ETag column for the table Currency.

Invoice_Rounding_Precision Decimal False

The Invoice_Rounding_Precision column for the table Currency.

Invoice_Rounding_Type String False

The Invoice_Rounding_Type column for the table Currency.

Last_Date_Adjusted Datetime False

The Last_Date_Adjusted column for the table Currency.

Last_Date_Modified Datetime False

The Last_Date_Modified column for the table Currency.

Max_Payment_Tolerance_Amount Decimal False

The Max_Payment_Tolerance_Amount column for the table Currency.

Max_VAT_Difference_Allowed Decimal False

The Max_VAT_Difference_Allowed column for the table Currency.

Payment_Tolerance_Percent Decimal False

The Payment_Tolerance_Percent column for the table Currency.

Realized_G_L_Gains_Account String False

The Realized_G_L_Gains_Account column for the table Currency.

Realized_G_L_Losses_Account String False

The Realized_G_L_Losses_Account column for the table Currency.

Realized_Gains_Acc String False

The Realized_Gains_Acc column for the table Currency.

Realized_Losses_Acc String False

The Realized_Losses_Acc column for the table Currency.

Residual_Gains_Account String False

The Residual_Gains_Account column for the table Currency.

Residual_Losses_Account String False

The Residual_Losses_Account column for the table Currency.

Symbol String False

The Symbol column for the table Currency.

Unit_Amount_Decimal_Places String False

The Unit_Amount_Decimal_Places column for the table Currency.

Unit_Amount_Rounding_Precision Decimal False

The Unit_Amount_Rounding_Precision column for the table Currency.

Unrealized_Gains_Acc String False

The Unrealized_Gains_Acc column for the table Currency.

Unrealized_Losses_Acc String False

The Unrealized_Losses_Acc column for the table Currency.

VAT_Rounding_Type String False

The VAT_Rounding_Type column for the table Currency.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.





Customer

The DynamicsNAV table Customer.

Columns

Name Type ReadOnly Description
No [KEY] String False

The No column for the table Customer.

Address String False

The Address column for the table Customer.

Address_2 String False

The Address_2 column for the table Customer.

Allow_Line_Disc Boolean False

The Allow_Line_Disc column for the table Customer.

Application_Method String False

The Application_Method column for the table Customer.

Balance_LCY Decimal False

The Balance_LCY column for the table Customer.

Bank_Communication String False

The Bank_Communication column for the table Customer.

Base_Calendar_Code String False

The Base_Calendar_Code column for the table Customer.

Bill_to_Customer_No String False

The Bill_to_Customer_No column for the table Customer.

Block_Payment_Tolerance Boolean False

The Block_Payment_Tolerance column for the table Customer.

Blocked String False

The Blocked column for the table Customer.

Cash_Flow_Payment_Terms_Code String False

The Cash_Flow_Payment_Terms_Code column for the table Customer.

Check_Date_Format String False

The Check_Date_Format column for the table Customer.

Check_Date_Separator String False

The Check_Date_Separator column for the table Customer.

City String False

The City column for the table Customer.

Combine_Shipments Boolean False

The Combine_Shipments column for the table Customer.

Contact String False

The Contact column for the table Customer.

Copy_Sell_to_Addr_to_Qte_From String False

The Copy_Sell_to_Addr_to_Qte_From column for the table Customer.

Country_Region_Code String False

The Country_Region_Code column for the table Customer.

County String False

The County column for the table Customer.

Credit_Limit_LCY Decimal False

The Credit_Limit_LCY column for the table Customer.

CURP_No String False

The CURP_No column for the table Customer.

Currency_Code String False

The Currency_Code column for the table Customer.

Currency_Filter String False

The Currency_Filter column for the table Customer.

Customer_Disc_Group String False

The Customer_Disc_Group column for the table Customer.

Customer_Posting_Group String False

The Customer_Posting_Group column for the table Customer.

Customer_Price_Group String False

The Customer_Price_Group column for the table Customer.

Customized_Calendar String False

The Customized_Calendar column for the table Customer.

E_Mail String False

The E_Mail column for the table Customer.

ETag String False

The ETag column for the table Customer.

Fax_No String False

The Fax_No column for the table Customer.

Fin_Charge_Terms_Code String False

The Fin_Charge_Terms_Code column for the table Customer.

Gen_Bus_Posting_Group String False

The Gen_Bus_Posting_Group column for the table Customer.

Global_Dimension_1_Filter String False

The Global_Dimension_1_Filter column for the table Customer.

Global_Dimension_2_Filter String False

The Global_Dimension_2_Filter column for the table Customer.

Home_Page String False

The Home_Page column for the table Customer.

IC_Partner_Code String False

The IC_Partner_Code column for the table Customer.

Invoice_Copies Int32 False

The Invoice_Copies column for the table Customer.

Invoice_Disc_Code String False

The Invoice_Disc_Code column for the table Customer.

Language_Code String False

The Language_Code column for the table Customer.

Last_Date_Modified Datetime False

The Last_Date_Modified column for the table Customer.

Last_Statement_No Int32 False

The Last_Statement_No column for the table Customer.

Location_Code String False

The Location_Code column for the table Customer.

Name String False

The Name column for the table Customer.

Partner_Type String False

The Partner_Type column for the table Customer.

Payment_Method_Code String False

The Payment_Method_Code column for the table Customer.

Payment_Terms_Code String False

The Payment_Terms_Code column for the table Customer.

Phone_No String False

The Phone_No column for the table Customer.

Post_Code String False

The Post_Code column for the table Customer.

Preferred_Bank_Account String False

The Preferred_Bank_Account column for the table Customer.

Prepayment_Percent Decimal False

The Prepayment_Percent column for the table Customer.

Prices_Including_VAT Boolean False

The Prices_Including_VAT column for the table Customer.

Primary_Contact_No String False

The Primary_Contact_No column for the table Customer.

Print_Statements Boolean False

The Print_Statements column for the table Customer.

Reminder_Terms_Code String False

The Reminder_Terms_Code column for the table Customer.

Reserve String False

The Reserve column for the table Customer.

Responsibility_Center String False

The Responsibility_Center column for the table Customer.

RFC_No String False

The RFC_No column for the table Customer.

Salesperson_Code String False

The Salesperson_Code column for the table Customer.

Search_Name String False

The Search_Name column for the table Customer.

Service_Zone_Code String False

The Service_Zone_Code column for the table Customer.

Shipment_Method_Code String False

The Shipment_Method_Code column for the table Customer.

Shipping_Advice String False

The Shipping_Advice column for the table Customer.

Shipping_Agent_Code String False

The Shipping_Agent_Code column for the table Customer.

Shipping_Agent_Service_Code String False

The Shipping_Agent_Service_Code column for the table Customer.

Shipping_Time String False

The Shipping_Time column for the table Customer.

State_Inscription String False

The State_Inscription column for the table Customer.

Tax_Area_Code String False

The Tax_Area_Code column for the table Customer.

Tax_Exemption_No String False

The Tax_Exemption_No column for the table Customer.

Tax_Identification_Type String False

The Tax_Identification_Type column for the table Customer.

Tax_Liable Boolean False

The Tax_Liable column for the table Customer.

VAT_Bus_Posting_Group String False

The VAT_Bus_Posting_Group column for the table Customer.

VAT_Registration_No String False

The VAT_Registration_No column for the table Customer.

LinkedCountry_Region_Code_Link String False

The LinkedCountry_Region_Code_Link column for the table Customer.

LinkedCurrency_Code_Link String False

The LinkedCurrency_Code_Link column for the table Customer.

LinkedCurrency_Filter_Link String False

The LinkedCurrency_Filter_Link column for the table Customer.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.





GeneralProductPosting

The DynamicsNAV table GeneralProductPosting.

Columns

Name Type ReadOnly Description
Code [KEY] String False

The Code column for the table GeneralProductPosting.

Auto_Insert_Default Boolean False

The Auto_Insert_Default column for the table GeneralProductPosting.

Def_VAT_Prod_Posting_Group String False

The Def_VAT_Prod_Posting_Group column for the table GeneralProductPosting.

Description String False

The Description column for the table GeneralProductPosting.

ETag String False

The ETag column for the table GeneralProductPosting.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.





PurchaseLines

The DynamicsNAV table PurchaseLines.

Columns

Name Type ReadOnly Description
Document_No [KEY] String False

The Document_No column for the table PurchaseLines.

Document_Type [KEY] String False

The Document_Type column for the table PurchaseLines.

Line_No [KEY] Int32 False

The Line_No column for the table PurchaseLines.

Amt_Rcd_Not_Invoiced_LCY Decimal False

The Amt_Rcd_Not_Invoiced_LCY column for the table PurchaseLines.

Buy_from_Vendor_No String False

The Buy_from_Vendor_No column for the table PurchaseLines.

Description String False

The Description column for the table PurchaseLines.

Direct_Unit_Cost Decimal False

The Direct_Unit_Cost column for the table PurchaseLines.

ETag String False

The ETag column for the table PurchaseLines.

Expected_Receipt_Date Datetime False

The Expected_Receipt_Date column for the table PurchaseLines.

Indirect_Cost_Percent Decimal False

The Indirect_Cost_Percent column for the table PurchaseLines.

Job_Line_Type String False

The Job_Line_Type column for the table PurchaseLines.

Job_No String False

The Job_No column for the table PurchaseLines.

Job_Task_No String False

The Job_Task_No column for the table PurchaseLines.

Line_Amount Decimal False

The Line_Amount column for the table PurchaseLines.

Location_Code String False

The Location_Code column for the table PurchaseLines.

No String False

The No column for the table PurchaseLines.

Outstanding_Amount_LCY Decimal False

The Outstanding_Amount_LCY column for the table PurchaseLines.

Outstanding_Quantity Decimal False

The Outstanding_Quantity column for the table PurchaseLines.

Quantity Decimal False

The Quantity column for the table PurchaseLines.

Reserved_Qty_Base Decimal False

The Reserved_Qty_Base column for the table PurchaseLines.

Shortcut_Dimension_1_Code String False

The Shortcut_Dimension_1_Code column for the table PurchaseLines.

Shortcut_Dimension_2_Code String False

The Shortcut_Dimension_2_Code column for the table PurchaseLines.

ShortcutDimCode_x005B_3_x005D_ String False

The ShortcutDimCode_x005B_3_x005D_ column for the table PurchaseLines.

ShortcutDimCode_x005B_4_x005D_ String False

The ShortcutDimCode_x005B_4_x005D_ column for the table PurchaseLines.

ShortcutDimCode_x005B_5_x005D_ String False

The ShortcutDimCode_x005B_5_x005D_ column for the table PurchaseLines.

ShortcutDimCode_x005B_6_x005D_ String False

The ShortcutDimCode_x005B_6_x005D_ column for the table PurchaseLines.

ShortcutDimCode_x005B_7_x005D_ String False

The ShortcutDimCode_x005B_7_x005D_ column for the table PurchaseLines.

ShortcutDimCode_x005B_8_x005D_ String False

The ShortcutDimCode_x005B_8_x005D_ column for the table PurchaseLines.

Type String False

The Type column for the table PurchaseLines.

Unit_Cost_LCY Decimal False

The Unit_Cost_LCY column for the table PurchaseLines.

Unit_of_Measure_Code String False

The Unit_of_Measure_Code column for the table PurchaseLines.

Unit_Price_LCY Decimal False

The Unit_Price_LCY column for the table PurchaseLines.

Variant_Code String False

The Variant_Code column for the table PurchaseLines.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.





PurchaseOrder

The DynamicsNAV table PurchaseOrder.

Columns

Name Type ReadOnly Description
Document_Type [KEY] String False

The Document_Type column for the table PurchaseOrder.

No [KEY] String False

The No column for the table PurchaseOrder.

Area String False

The Area column for the table PurchaseOrder.

Assigned_User_ID String False

The Assigned_User_ID column for the table PurchaseOrder.

Buy_from_Address String False

The Buy_from_Address column for the table PurchaseOrder.

Buy_from_Address_2 String False

The Buy_from_Address_2 column for the table PurchaseOrder.

Buy_from_City String False

The Buy_from_City column for the table PurchaseOrder.

Buy_from_Contact String False

The Buy_from_Contact column for the table PurchaseOrder.

Buy_from_Contact_No String False

The Buy_from_Contact_No column for the table PurchaseOrder.

Buy_from_County String False

The Buy_from_County column for the table PurchaseOrder.

Buy_from_Post_Code String False

The Buy_from_Post_Code column for the table PurchaseOrder.

Buy_from_Vendor_Name String False

The Buy_from_Vendor_Name column for the table PurchaseOrder.

Buy_from_Vendor_No String False

The Buy_from_Vendor_No column for the table PurchaseOrder.

Compress_Prepayment Boolean False

The Compress_Prepayment column for the table PurchaseOrder.

Creditor_No String False

The Creditor_No column for the table PurchaseOrder.

Currency_Code String False

The Currency_Code column for the table PurchaseOrder.

Document_Date Datetime False

The Document_Date column for the table PurchaseOrder.

Due_Date Datetime False

The Due_Date column for the table PurchaseOrder.

Entry_Point String False

The Entry_Point column for the table PurchaseOrder.

ETag String False

The ETag column for the table PurchaseOrder.

Expected_Receipt_Date Datetime False

The Expected_Receipt_Date column for the table PurchaseOrder.

Inbound_Whse_Handling_Time String False

The Inbound_Whse_Handling_Time column for the table PurchaseOrder.

IRS_1099_Code String False

The IRS_1099_Code column for the table PurchaseOrder.

Job_Queue_Status String False

The Job_Queue_Status column for the table PurchaseOrder.

Lead_Time_Calculation String False

The Lead_Time_Calculation column for the table PurchaseOrder.

Location_Code String False

The Location_Code column for the table PurchaseOrder.

No_of_Archived_Versions Int32 False

The No_of_Archived_Versions column for the table PurchaseOrder.

On_Hold String False

The On_Hold column for the table PurchaseOrder.

Order_Address_Code String False

The Order_Address_Code column for the table PurchaseOrder.

Order_Date Datetime False

The Order_Date column for the table PurchaseOrder.

Pay_to_Address String False

The Pay_to_Address column for the table PurchaseOrder.

Pay_to_Address_2 String False

The Pay_to_Address_2 column for the table PurchaseOrder.

Pay_to_City String False

The Pay_to_City column for the table PurchaseOrder.

Pay_to_Contact String False

The Pay_to_Contact column for the table PurchaseOrder.

Pay_to_Contact_No String False

The Pay_to_Contact_No column for the table PurchaseOrder.

Pay_to_County String False

The Pay_to_County column for the table PurchaseOrder.

Pay_to_Name String False

The Pay_to_Name column for the table PurchaseOrder.

Pay_to_Post_Code String False

The Pay_to_Post_Code column for the table PurchaseOrder.

Pay_to_Vendor_No String False

The Pay_to_Vendor_No column for the table PurchaseOrder.

Payment_Discount_Percent Decimal False

The Payment_Discount_Percent column for the table PurchaseOrder.

Payment_Reference String False

The Payment_Reference column for the table PurchaseOrder.

Payment_Terms_Code String False

The Payment_Terms_Code column for the table PurchaseOrder.

Pmt_Discount_Date Datetime False

The Pmt_Discount_Date column for the table PurchaseOrder.

Posting_Date Datetime False

The Posting_Date column for the table PurchaseOrder.

Posting_Description String False

The Posting_Description column for the table PurchaseOrder.

Prepayment_Due_Date Datetime False

The Prepayment_Due_Date column for the table PurchaseOrder.

Prepayment_Percent Decimal False

The Prepayment_Percent column for the table PurchaseOrder.

Prepmt_Include_Tax Boolean False

The Prepmt_Include_Tax column for the table PurchaseOrder.

Prepmt_Payment_Discount_Percent Decimal False

The Prepmt_Payment_Discount_Percent column for the table PurchaseOrder.

Prepmt_Payment_Terms_Code String False

The Prepmt_Payment_Terms_Code column for the table PurchaseOrder.

Prepmt_Pmt_Discount_Date Datetime False

The Prepmt_Pmt_Discount_Date column for the table PurchaseOrder.

Promised_Receipt_Date Datetime False

The Promised_Receipt_Date column for the table PurchaseOrder.

Provincial_Tax_Area_Code String False

The Provincial_Tax_Area_Code column for the table PurchaseOrder.

Purchaser_Code String False

The Purchaser_Code column for the table PurchaseOrder.

Quote_No String False

The Quote_No column for the table PurchaseOrder.

Requested_Receipt_Date Datetime False

The Requested_Receipt_Date column for the table PurchaseOrder.

Responsibility_Center String False

The Responsibility_Center column for the table PurchaseOrder.

Sell_to_Customer_No String False

The Sell_to_Customer_No column for the table PurchaseOrder.

Ship_to_Address String False

The Ship_to_Address column for the table PurchaseOrder.

Ship_to_Address_2 String False

The Ship_to_Address_2 column for the table PurchaseOrder.

Ship_to_City String False

The Ship_to_City column for the table PurchaseOrder.

Ship_to_Code String False

The Ship_to_Code column for the table PurchaseOrder.

Ship_to_Contact String False

The Ship_to_Contact column for the table PurchaseOrder.

Ship_to_County String False

The Ship_to_County column for the table PurchaseOrder.

Ship_to_Name String False

The Ship_to_Name column for the table PurchaseOrder.

Ship_to_Post_Code String False

The Ship_to_Post_Code column for the table PurchaseOrder.

Ship_to_UPS_Zone String False

The Ship_to_UPS_Zone column for the table PurchaseOrder.

Shipment_Method_Code String False

The Shipment_Method_Code column for the table PurchaseOrder.

Shortcut_Dimension_1_Code String False

The Shortcut_Dimension_1_Code column for the table PurchaseOrder.

Shortcut_Dimension_2_Code String False

The Shortcut_Dimension_2_Code column for the table PurchaseOrder.

Status String False

The Status column for the table PurchaseOrder.

Tax_Area_Code String False

The Tax_Area_Code column for the table PurchaseOrder.

Tax_Exemption_No String False

The Tax_Exemption_No column for the table PurchaseOrder.

Tax_Liable Boolean False

The Tax_Liable column for the table PurchaseOrder.

Transaction_Specification String False

The Transaction_Specification column for the table PurchaseOrder.

Transaction_Type String False

The Transaction_Type column for the table PurchaseOrder.

Transport_Method String False

The Transport_Method column for the table PurchaseOrder.

Vendor_Cr_Memo_No String False

The Vendor_Cr_Memo_No column for the table PurchaseOrder.

Vendor_Invoice_No String False

The Vendor_Invoice_No column for the table PurchaseOrder.

Vendor_Order_No String False

The Vendor_Order_No column for the table PurchaseOrder.

Vendor_Shipment_No String False

The Vendor_Shipment_No column for the table PurchaseOrder.

LinkedPurchaseOrderPurchLines String False

The LinkedPurchaseOrderPurchLines column for the table PurchaseOrder.

LinkedCurrency_Code_Link String False

The LinkedCurrency_Code_Link column for the table PurchaseOrder.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.





PurchaseOrderPurchLines

The DynamicsNAV table PurchaseOrderPurchLines.

Columns

Name Type ReadOnly Description
Document_No [KEY] String False

The Document_No column for the table PurchaseOrderPurchLines.

Document_Type [KEY] String False

The Document_Type column for the table PurchaseOrderPurchLines.

Line_No [KEY] Int32 False

The Line_No column for the table PurchaseOrderPurchLines.

Allow_Invoice_Disc Boolean False

The Allow_Invoice_Disc column for the table PurchaseOrderPurchLines.

Allow_Item_Charge_Assignment Boolean False

The Allow_Item_Charge_Assignment column for the table PurchaseOrderPurchLines.

Appl_to_Item_Entry Int32 False

The Appl_to_Item_Entry column for the table PurchaseOrderPurchLines.

Bin_Code String False

The Bin_Code column for the table PurchaseOrderPurchLines.

Blanket_Order_Line_No Int32 False

The Blanket_Order_Line_No column for the table PurchaseOrderPurchLines.

Blanket_Order_No String False

The Blanket_Order_No column for the table PurchaseOrderPurchLines.

Cross_Reference_No String False

The Cross_Reference_No column for the table PurchaseOrderPurchLines.

Description String False

The Description column for the table PurchaseOrderPurchLines.

Direct_Unit_Cost Decimal False

The Direct_Unit_Cost column for the table PurchaseOrderPurchLines.

Drop_Shipment Boolean False

The Drop_Shipment column for the table PurchaseOrderPurchLines.

ETag String False

The ETag column for the table PurchaseOrderPurchLines.

Expected_Receipt_Date Datetime False

The Expected_Receipt_Date column for the table PurchaseOrderPurchLines.

Finished Boolean False

The Finished column for the table PurchaseOrderPurchLines.

GST_HST String False

The GST_HST column for the table PurchaseOrderPurchLines.

IC_Partner_Code String False

The IC_Partner_Code column for the table PurchaseOrderPurchLines.

IC_Partner_Ref_Type String False

The IC_Partner_Ref_Type column for the table PurchaseOrderPurchLines.

IC_Partner_Reference String False

The IC_Partner_Reference column for the table PurchaseOrderPurchLines.

Inbound_Whse_Handling_Time String False

The Inbound_Whse_Handling_Time column for the table PurchaseOrderPurchLines.

Indirect_Cost_Percent Decimal False

The Indirect_Cost_Percent column for the table PurchaseOrderPurchLines.

Inv_Discount_Amount Decimal False

The Inv_Discount_Amount column for the table PurchaseOrderPurchLines.

IRS_1099_Liable Boolean False

The IRS_1099_Liable column for the table PurchaseOrderPurchLines.

Job_Line_Amount Decimal False

The Job_Line_Amount column for the table PurchaseOrderPurchLines.

Job_Line_Amount_LCY Decimal False

The Job_Line_Amount_LCY column for the table PurchaseOrderPurchLines.

Job_Line_Disc_Amount_LCY Decimal False

The Job_Line_Disc_Amount_LCY column for the table PurchaseOrderPurchLines.

Job_Line_Discount_Amount Decimal False

The Job_Line_Discount_Amount column for the table PurchaseOrderPurchLines.

Job_Line_Discount_Percent Decimal False

The Job_Line_Discount_Percent column for the table PurchaseOrderPurchLines.

Job_Line_Type String False

The Job_Line_Type column for the table PurchaseOrderPurchLines.

Job_No String False

The Job_No column for the table PurchaseOrderPurchLines.

Job_Planning_Line_No Int32 False

The Job_Planning_Line_No column for the table PurchaseOrderPurchLines.

Job_Remaining_Qty Decimal False

The Job_Remaining_Qty column for the table PurchaseOrderPurchLines.

Job_Task_No String False

The Job_Task_No column for the table PurchaseOrderPurchLines.

Job_Total_Price Decimal False

The Job_Total_Price column for the table PurchaseOrderPurchLines.

Job_Total_Price_LCY Decimal False

The Job_Total_Price_LCY column for the table PurchaseOrderPurchLines.

Job_Unit_Price Decimal False

The Job_Unit_Price column for the table PurchaseOrderPurchLines.

Job_Unit_Price_LCY Decimal False

The Job_Unit_Price_LCY column for the table PurchaseOrderPurchLines.

Lead_Time_Calculation String False

The Lead_Time_Calculation column for the table PurchaseOrderPurchLines.

Line_Amount Decimal False

The Line_Amount column for the table PurchaseOrderPurchLines.

Line_Discount_Amount Decimal False

The Line_Discount_Amount column for the table PurchaseOrderPurchLines.

Line_Discount_Percent Decimal False

The Line_Discount_Percent column for the table PurchaseOrderPurchLines.

Location_Code String False

The Location_Code column for the table PurchaseOrderPurchLines.

No String False

The No column for the table PurchaseOrderPurchLines.

Nonstock Boolean False

The Nonstock column for the table PurchaseOrderPurchLines.

Operation_No String False

The Operation_No column for the table PurchaseOrderPurchLines.

Order_Date Datetime False

The Order_Date column for the table PurchaseOrderPurchLines.

Planned_Receipt_Date Datetime False

The Planned_Receipt_Date column for the table PurchaseOrderPurchLines.

Planning_Flexibility String False

The Planning_Flexibility column for the table PurchaseOrderPurchLines.

Prepayment_Percent Decimal False

The Prepayment_Percent column for the table PurchaseOrderPurchLines.

Prepmt_Amt_Deducted Decimal False

The Prepmt_Amt_Deducted column for the table PurchaseOrderPurchLines.

Prepmt_Amt_Inv Decimal False

The Prepmt_Amt_Inv column for the table PurchaseOrderPurchLines.

Prepmt_Amt_to_Deduct Decimal False

The Prepmt_Amt_to_Deduct column for the table PurchaseOrderPurchLines.

Prepmt_Line_Amount Decimal False

The Prepmt_Line_Amount column for the table PurchaseOrderPurchLines.

Prod_Order_Line_No Int32 False

The Prod_Order_Line_No column for the table PurchaseOrderPurchLines.

Prod_Order_No String False

The Prod_Order_No column for the table PurchaseOrderPurchLines.

Promised_Receipt_Date Datetime False

The Promised_Receipt_Date column for the table PurchaseOrderPurchLines.

Provincial_Tax_Area_Code String False

The Provincial_Tax_Area_Code column for the table PurchaseOrderPurchLines.

Qty_Assigned Decimal False

The Qty_Assigned column for the table PurchaseOrderPurchLines.

Qty_to_Assign Decimal False

The Qty_to_Assign column for the table PurchaseOrderPurchLines.

Qty_to_Invoice Decimal False

The Qty_to_Invoice column for the table PurchaseOrderPurchLines.

Qty_to_Receive Decimal False

The Qty_to_Receive column for the table PurchaseOrderPurchLines.

Quantity Decimal False

The Quantity column for the table PurchaseOrderPurchLines.

Quantity_Invoiced Decimal False

The Quantity_Invoiced column for the table PurchaseOrderPurchLines.

Quantity_Received Decimal False

The Quantity_Received column for the table PurchaseOrderPurchLines.

Requested_Receipt_Date Datetime False

The Requested_Receipt_Date column for the table PurchaseOrderPurchLines.

Reserved_Quantity Decimal False

The Reserved_Quantity column for the table PurchaseOrderPurchLines.

Return_Reason_Code String False

The Return_Reason_Code column for the table PurchaseOrderPurchLines.

Shortcut_Dimension_1_Code String False

The Shortcut_Dimension_1_Code column for the table PurchaseOrderPurchLines.

Shortcut_Dimension_2_Code String False

The Shortcut_Dimension_2_Code column for the table PurchaseOrderPurchLines.

ShortcutDimCode_x005B_3_x005D_ String False

The ShortcutDimCode_x005B_3_x005D_ column for the table PurchaseOrderPurchLines.

ShortcutDimCode_x005B_4_x005D_ String False

The ShortcutDimCode_x005B_4_x005D_ column for the table PurchaseOrderPurchLines.

ShortcutDimCode_x005B_5_x005D_ String False

The ShortcutDimCode_x005B_5_x005D_ column for the table PurchaseOrderPurchLines.

ShortcutDimCode_x005B_6_x005D_ String False

The ShortcutDimCode_x005B_6_x005D_ column for the table PurchaseOrderPurchLines.

ShortcutDimCode_x005B_7_x005D_ String False

The ShortcutDimCode_x005B_7_x005D_ column for the table PurchaseOrderPurchLines.

ShortcutDimCode_x005B_8_x005D_ String False

The ShortcutDimCode_x005B_8_x005D_ column for the table PurchaseOrderPurchLines.

Tax_Area_Code String False

The Tax_Area_Code column for the table PurchaseOrderPurchLines.

Tax_Group_Code String False

The Tax_Group_Code column for the table PurchaseOrderPurchLines.

Tax_Liable Boolean False

The Tax_Liable column for the table PurchaseOrderPurchLines.

Type String False

The Type column for the table PurchaseOrderPurchLines.

Unit_Cost_LCY Decimal False

The Unit_Cost_LCY column for the table PurchaseOrderPurchLines.

Unit_of_Measure String False

The Unit_of_Measure column for the table PurchaseOrderPurchLines.

Unit_of_Measure_Code String False

The Unit_of_Measure_Code column for the table PurchaseOrderPurchLines.

Unit_Price_LCY Decimal False

The Unit_Price_LCY column for the table PurchaseOrderPurchLines.

Use_Tax Boolean False

The Use_Tax column for the table PurchaseOrderPurchLines.

Variant_Code String False

The Variant_Code column for the table PurchaseOrderPurchLines.

VAT_Prod_Posting_Group String False

The VAT_Prod_Posting_Group column for the table PurchaseOrderPurchLines.

Whse_Outstanding_Qty_Base Decimal False

The Whse_Outstanding_Qty_Base column for the table PurchaseOrderPurchLines.

Work_Center_No String False

The Work_Center_No column for the table PurchaseOrderPurchLines.

LinkedBlanket_Order_Line_No_Link String False

The LinkedBlanket_Order_Line_No_Link column for the table PurchaseOrderPurchLines.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.





PurchaseOrders

The DynamicsNAV table PurchaseOrders.

Columns

Name Type ReadOnly Description
Document_No [KEY] String False

The Document_No column for the table PurchaseOrders.

Document_Type [KEY] String False

The Document_Type column for the table PurchaseOrders.

Line_No [KEY] Int32 False

The Line_No column for the table PurchaseOrders.

Amount Decimal False

The Amount column for the table PurchaseOrders.

Buy_from_Vendor_No String False

The Buy_from_Vendor_No column for the table PurchaseOrders.

Currency_Code String False

The Currency_Code column for the table PurchaseOrders.

Description String False

The Description column for the table PurchaseOrders.

Direct_Unit_Cost Decimal False

The Direct_Unit_Cost column for the table PurchaseOrders.

ETag String False

The ETag column for the table PurchaseOrders.

Expected_Receipt_Date Datetime False

The Expected_Receipt_Date column for the table PurchaseOrders.

Line_Discount_Percent Decimal False

The Line_Discount_Percent column for the table PurchaseOrders.

No String False

The No column for the table PurchaseOrders.

Outstanding_Quantity Decimal False

The Outstanding_Quantity column for the table PurchaseOrders.

Quantity Decimal False

The Quantity column for the table PurchaseOrders.

Type String False

The Type column for the table PurchaseOrders.

Unit_of_Measure_Code String False

The Unit_of_Measure_Code column for the table PurchaseOrders.

LinkedCurrency_Code_Link String False

The LinkedCurrency_Code_Link column for the table PurchaseOrders.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.





ResourceCard

The DynamicsNAV table ResourceCard.

Columns

Name Type ReadOnly Description
No [KEY] String False

The No column for the table ResourceCard.

Address String False

The Address column for the table ResourceCard.

Address_2 String False

The Address_2 column for the table ResourceCard.

Automatic_Ext_Texts Boolean False

The Automatic_Ext_Texts column for the table ResourceCard.

Base_Unit_of_Measure String False

The Base_Unit_of_Measure column for the table ResourceCard.

Blocked Boolean False

The Blocked column for the table ResourceCard.

City String False

The City column for the table ResourceCard.

Contract_Class String False

The Contract_Class column for the table ResourceCard.

County String False

The County column for the table ResourceCard.

Direct_Unit_Cost Decimal False

The Direct_Unit_Cost column for the table ResourceCard.

Education String False

The Education column for the table ResourceCard.

Employment_Date Datetime False

The Employment_Date column for the table ResourceCard.

ETag String False

The ETag column for the table ResourceCard.

Gen_Prod_Posting_Group String False

The Gen_Prod_Posting_Group column for the table ResourceCard.

IC_Partner_Purch_G_L_Acc_No String False

The IC_Partner_Purch_G_L_Acc_No column for the table ResourceCard.

Indirect_Cost_Percent Decimal False

The Indirect_Cost_Percent column for the table ResourceCard.

Job_Title String False

The Job_Title column for the table ResourceCard.

Last_Date_Modified Datetime False

The Last_Date_Modified column for the table ResourceCard.

Name String False

The Name column for the table ResourceCard.

Post_Code String False

The Post_Code column for the table ResourceCard.

Price_Profit_Calculation String False

The Price_Profit_Calculation column for the table ResourceCard.

Profit_Percent Decimal False

The Profit_Percent column for the table ResourceCard.

Resource_Group_No String False

The Resource_Group_No column for the table ResourceCard.

Search_Name String False

The Search_Name column for the table ResourceCard.

Social_Security_No String False

The Social_Security_No column for the table ResourceCard.

Tax_Group_Code String False

The Tax_Group_Code column for the table ResourceCard.

Time_Sheet_Approver_User_ID String False

The Time_Sheet_Approver_User_ID column for the table ResourceCard.

Time_Sheet_Owner_User_ID String False

The Time_Sheet_Owner_User_ID column for the table ResourceCard.

Type String False

The Type column for the table ResourceCard.

Unit_Cost Decimal False

The Unit_Cost column for the table ResourceCard.

Unit_Price Decimal False

The Unit_Price column for the table ResourceCard.

Use_Time_Sheet Boolean False

The Use_Time_Sheet column for the table ResourceCard.

VAT_Prod_Posting_Group String False

The VAT_Prod_Posting_Group column for the table ResourceCard.

LinkedGen_Prod_Posting_Group_Link String False

The LinkedGen_Prod_Posting_Group_Link column for the table ResourceCard.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.





SalesOrder

The DynamicsNAV table SalesOrder.

Columns

Name Type ReadOnly Description
Document_No [KEY] String False

The Document_No column for the table SalesOrder.

Document_Type [KEY] String False

The Document_Type column for the table SalesOrder.

Line_No [KEY] Int32 False

The Line_No column for the table SalesOrder.

Amount Decimal False

The Amount column for the table SalesOrder.

Currency_Code String False

The Currency_Code column for the table SalesOrder.

Description String False

The Description column for the table SalesOrder.

ETag String False

The ETag column for the table SalesOrder.

Line_Discount_Percent Decimal False

The Line_Discount_Percent column for the table SalesOrder.

No String False

The No column for the table SalesOrder.

Outstanding_Quantity Decimal False

The Outstanding_Quantity column for the table SalesOrder.

Quantity Decimal False

The Quantity column for the table SalesOrder.

Sell_to_Customer_No String False

The Sell_to_Customer_No column for the table SalesOrder.

Shipment_Date Datetime False

The Shipment_Date column for the table SalesOrder.

Type String False

The Type column for the table SalesOrder.

Unit_of_Measure_Code String False

The Unit_of_Measure_Code column for the table SalesOrder.

Unit_Price Decimal False

The Unit_Price column for the table SalesOrder.

Work_Type_Code String False

The Work_Type_Code column for the table SalesOrder.

LinkedCurrency_Code_Link String False

The LinkedCurrency_Code_Link column for the table SalesOrder.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.