ODBC Driver for SugarCRM

Build 24.0.9062

Purchases

The Purchases table.

Columns

Name Type ReadOnly Description
Account_Id String False

Account_Name String False

Acl_Team_Names String True

Acl_Team_Set_Id String False

Assigned_User_Id String False

User ID assigned to record

Assigned_User_Name String True

Base_Rate String False

Category_Id String False

Product category

Category_Name String True

Commentlog String True

Created_By String True

User who created record

Created_By_Name String True

Currency_Id String False

Currency_Name String True

Currency_Symbol String True

Date_Entered Datetime True

Date record created

Date_Modified Datetime True

Date record last modified

Deleted Bool False

Record deletion indicator

Description String False

Full text of the note

End_Date Date True

End date of the purchase

Following Bool False

Is user following this record

Id [KEY] String True

Unique identifier

Locked_Fields String True

Modified_By_Name String True

Modified_User_Id String True

User who last modified record

My_Favorite Bool False

Favorite for the user

Name String False

Pli_Collection String True

Pli_Count Int True

Product_Template_Id String False

Product_Template_Name String True

Renewable Bool False

Indicates whether the purchase is renewable

Service Bool False

Indicates whether the purchase is a service

Start_Date Date True

Start date of the purchase

Sync_Key String True

Tag String False

Team_Count String False

Team_Id String False

Team ID for the account

Team_Name String False

Team_Set_Id String False

Total_Quantity Decimal True

Total_Revenue Decimal True

Type_Id String False

Product type (ex: hardware, software]

Type_Name String True

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062