Dynamics NAV Data Model

Connection String Options

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

Auth Scheme

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:

  • NTLM: Set this to use your Windows credentials to authenticate.
  • BASIC: Set this to use HTTP Basic authentication.
  • NEGOTIATE: If AuthScheme is set to NEGOTIATE, the driver will negotiate an authentication mechanism with the server. Set AuthScheme to NEGOTIATE to use Kerberos authentication.
  • DIGEST: Set this to use HTTP Digest authentication.



Auto Cache

Data Type

bool

Default Value

false

Remarks

When AutoCache is set, the driver automatically caches the results of SELECT queries to a cache specified by the CacheLocation option. CacheLocation defines the path to a simple, file-based cache.

AutoCache is the simplest caching configuration available, however, like any caching scheme, using a cache is not without pitfalls such as reporting on stale data. The driver is designed to be fully functional without relying on caching.

The following sections outline how and when to use AutoCache. Understanding how AutoCache works and its limitations will help you choose an effective caching strategy. For more information on deploying other caching strategies, see Caching Data.

How AutoCaching Works

When you execute a SELECT statement with AutoCache set, the driver executes the query to the remote data and persists the results; rows and columns that already exist are overwritten. That is, SELECT statements are used to create and refresh the cache, not to query it.

Non-queries (such as UPDATE/INSERT/DELETE statements) are executed to the remote data as well; these statements will not modify the data in the cache at all, regardless of the value set for AutoCache.

To work with the local data, append #CACHE to the table name. For example:

SELECT * FROM [Customer#CACHE]
Limitations of AutoCache

In the following scenarios, consider the alternatives listed below:

  • When you need to work with the cache transparently: Because AutoCache requires a special syntax to utilize the cache, it is not suitable for use with BI, analytics, and reporting. Many of these tools generate SQL statements for you; these generated statements will still be executed to DynamicsNAV instead of the cache.

    In these situations, one solution is to use the Offline property. When this is set, all queries are executed locally. See Caching: Best Practices for examples.

    One downside of this approach is that it requires a separate connection. As an alternative, consider using the CData Sync tool to maintain a local database that is kept fresh with scheduled updates.

  • When you need more control over cached data: The AutoCache feature does not have the ability to remove rows from the cache that were deleted from the remote data. It also does not support dropping a table from the cache or more advanced cache maintenance such as changing the cached table schemas.

    In this scenario, consider CACHE Statements. CACHE statements can remove cached rows that no longer exist in DynamicsNAV.

    See Caching Explicitly for more information on how to use CACHE statements.

  • When you need to work with an RDBMS: AutoCache can only be used with the default database, JavaDB or SQLite. Many enterprises will need to use an RDBMS to support more concurrent writes or integrate with existing infrastructure. You can specify a database driver with CacheConnection and CacheDriver.



Cache Connection

Data Type

string

Default Value

""

Remarks

The cache database is determined based on the CacheDriver and CacheConnection properties. The CacheConnection defines the connection properties necessary to connect to the cache database.

Cache Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver;Cache Connection='jdbc:sqlserver://localhost:7437;user=sa;password=123456;databaseName=Cache'



Cache Driver

Data Type

string

Default Value

""

Remarks

You can cache to any database that you have a JDBC driver for. The driver has been tested with SQL Server, Derby and Java DB, MySQL, Oracle, and SQLite.

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

Cache Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver;Cache Connection='jdbc:sqlserver://localhost:7437;user=sa;password=123456;databaseName=Cache'
Note that the driver JAR must be specified on the classpath.



Cache Location

Data Type

string

Default Value

""

Remarks

If AutoCache is set but the cache location is not specified, CacheLocation defaults to the cache folder on the directory specified by the Location setting.

The CacheLocation is a simple, file-based cache. See the CacheConnection and CacheDriver properties to cache to other databases.



Cache Metadata

Data Type

bool

Default Value

false

Remarks

The cache.db file will be created in the location specified by the CacheConnection or if that is not set, the CacheLocation.



Company

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

Data Type

bool

Default Value

true

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

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

Data Type

string

Default Value

""

Remarks

If FirewallServer is specified, the FirewallUser and FirewallPassword properties are used to connect and authenticate to the given firewall.



Firewall Port

Data Type

string

Default Value

""

Remarks

Note that the driver sets the FirewallPort to the default port associated with the specified FirewallType. See the description of the FirewallType option for details.



Firewall Server

Data Type

string

Default Value

""

Remarks

If this property is set to a domain name, a DNS request is initiated and the name is translated to the corresponding IP address.



Firewall Type

Data Type

string

Default Value

"NONE"

Remarks

The applicable values are:

Firewall Type Default FirewallPort
TUNNEL 80
SOCKS4 1080
SOCKS5 1080



Firewall User

Data Type

string

Default Value

""

Remarks

If the FirewallServer is specified, the FirewallUser and FirewallPassword properties are used to connect and authenticate against the firewall.



Location

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

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

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

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

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.
ConvertDateTimesToGMTWhether 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

Data Type

string

Default Value

""

Remarks

The password used to authenticate to the Dynamics NAV server.



Proxy Auth Scheme

Data Type

string

Default Value

"BASIC"

Remarks

This value may be BASIC, DIGEST, NONE, NTLM, NEGOTIATE or PROPRIETARY.



Proxy Auto Detect

Data Type

bool

Default Value

true

Remarks

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



Proxy Password

Data Type

string

Default Value

""

Remarks

If the ProxyServer is specified, the ProxyUser and ProxyPassword properties are used to connect and authenticate against the firewall.



Proxy Port

Data Type

string

Default Value

"80"

Remarks

See the description of the ProxyServer field for details.



Proxy Server

Data Type

string

Default Value

""

Remarks

If this property is set to a domain name, a DNS request is initiated and the name is translated to the corresponding address.



Proxy SSL Type

Data Type

string

Default Value

"AUTO"

Remarks

This value may be AUTO, ALWAYS, NEVER, or TUNNEL.



Proxy User

Data Type

string

Default Value

""

Remarks

If a ProxyServer is specified, the ProxyUser and ProxyPassword options are used to connect and authenticate against the firewall.



Pseudo Columns

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

Data Type

string

Default Value

""

Remarks

The QueryCache allows you to cache the results of a query in-memory and use them until the cache expires. Setting the QueryCache can improve performance if the same or similar (see below) queries are executed often. The in-memory query cache is shared across connections, so it can help with performance even if more than one connection is being used.

The cache manager for QueryCache will not only use the results in the cache for exactly the same query, but also 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 from Account LIMIT 10; // Query C

Setting the QueryCache to zero disables in-memory caching.



Readonly

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

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

Data Type

string

Default Value

""

Remarks

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



SSL Server Cert

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 can take the form of a full PEM certificate, the path to a file containing the certificate, the public key, the MD5 thumbprint, or the SHA1 thumbprint. If not specified, any trusted certificate will be accepted. Use '*' to signify to accept all certificates (not recommended for security concerns).



Support Enhanced SQL

Data Type

bool

Default Value

true

Remarks

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



Tables

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

Data Type

string

Default Value

""

Remarks

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



Timeout

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

Data Type

string

Default Value

""

Remarks

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



User

Data Type

string

Default Value

""

Remarks

The user who is authenticating to the Dynamics NAV server.



Verbosity

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.





Tables

  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.