JDBC Driver for Microsoft Dynamics NAV

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462