CData Power BI Connector for SugarCRM 2019 - Online Help
Questions / Feedback?

Quotes

CData Power BI Connector for SugarCRM 2019 - Build 19.0.7354

Create, update, delete, and query the Quotes module in SugarCRM.

Columns

Name Type ReadOnly Description
My_Favorite Bool False

Whether the record is the favorite for the user.

Following Bool False

Whether the user is following this record.

Id [KEY] String False

The unique identifier of the quote.

Name String False

The name of the quote.

Date_Entered Datetime True

Date the record was created.

Date_Modified Datetime True

Date the record was last modified.

Modified_User_Id String True

The Id of the user who last modified the record.

Modified_By_Name String True

The user name of the user who last modified the record.

Created_By String True

The Id of the user who created the record.

Created_By_Name String True

The user name of the user who created the record

Doc_Owner String False

The document owner.

User_Favorites String False

The favorites of the user.

Description String False

The full text of the note.

Deleted Bool False

The record deletion indicator.

Assigned_User_Id String False

The user Id assigned to the record.

Assigned_User_Name String False

The name of the user assigned to the record.

Team_Id String False

The Id of the primary team.

Team_Set_Id String False

The Id of the team set.

Team_Count String False

The count of the team set.

Team_Name String False

The name of the primary team.

Shipper_Id String False

The Id of the shipper.

Shipper_Name String False

The name of the shipper.

Currency_Id String False

The Id of the currency.

Base_Rate Decimal False

The base rate.

Taxrate_Id String False

The Id of the tax rate.

Show_Line_Nums Bool False

Whether to show the line numbers of the quote.

Calc_Grand_Total Bool False

The grand total of the quote.

Quote_Type String False

The type of the quote.

Date_Quote_Expected_Closed Datetime False

The expected close date of the quote.

Original_Po_Date Datetime False

The original PO date

Payment_Terms String False

The payment terms.

Date_Quote_Closed Datetime False

The close date of the quote.

Date_Order_Shipped Datetime False

The ship date of the order.

Order_Stage String False

The stage of the order

Quote_Stage String False

The stage of the quote.

Purchase_Order_Num String False

The purchase order number.

Quote_Num Int True

The quote number.

Subtotal Double False

The subtotal of the quote.

Subtotal_Usdollar Double False

The subtotal of the quote in USD.

Shipping Double False

The shipping cost.

Shipping_Usdollar Double False

The shipping cost in USD.

Discount Double False

The discount amount.

Deal_Tot Double False

The deal total.

Deal_Tot_Usdollar Double False

The deal total in USD.

New_Sub Double False

The new subtotal.

New_Sub_Usdollar Double False

The new subtotal in USD.

Tax Double False

The tax amount.

Tax_Usdollar Double False

The tax amount in USD.

Total Double False

The total.

Total_Usdollar Double False

The total in USD.

Billing_Address_Street String False

The street of the billing address.

Billing_Address_City String False

The city used for the billing address.

Billing_Address_State String False

The state used for the billing address.

Billing_Address_Postalcode String False

The postal code used for the billing address.

Billing_Address_Country String False

The country used for the billing address.

Shipping_Address_Street String False

The street address used for for shipping purposes.

Shipping_Address_City String False

The city used for the shipping address.

Shipping_Address_State String False

The state used for the shipping address.

Shipping_Address_Postalcode String False

The ZIP code used for the shipping address.

Shipping_Address_Country String False

The country used for the shipping address.

System_Id Int False

The system Id.

Shipping_Account_Name String False

The shipping account name.

Shipping_Account_Id String False

The shipping account Id.

Shipping_Contact_Name String False

The shipping contact name.

Shipping_Contact_Id String False

The shipping contact Id.

Account_Name String False

The account name.

Account_Id String False

The account Id.

Billing_Account_Name String False

The billing account name.

Billing_Account_Id String False

The billing account Id.

Billing_Contact_Name String False

The billing contact name.

Billing_Contact_Id String False

The billing contact Id.

Opportunity_Name String False

The opportunity name.

Opportunity_Id String False

The opportunity Id.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0