Purchases
The Purchases table.
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | String | False |
Unique identifier |
Name | String | False | |
Date_Entered | Datetime | True |
Date record created |
Date_Modified | Datetime | True |
Date record last modified |
Modified_User_Id | String | True |
User who last modified record |
Modified_By_Name | String | True | |
Created_By | String | True |
User who created record |
Created_By_Name | String | True | |
Description | String | False |
Full text of the note |
Deleted | Bool | False |
Record deletion indicator |
Start_Date | Date | True |
Start date of the purchase |
End_Date | Date | True |
End date of the purchase |
Service | Bool | False |
Indicates whether the purchase is a service |
Total_Revenue | Decimal | True | |
Total_Quantity | Decimal | True | |
Pli_Count | Int | True | |
Renewable | Bool | False |
Indicates whether the purchase is renewable |
Product_Template_Id | String | False | |
Product_Template_Name | String | True | |
Account_Name | String | False | |
Account_Id | String | False | |
Type_Id | String | False |
Product type (ex: hardware, software] |
Type_Name | String | True | |
Category_Id | String | False |
Product category |
Category_Name | String | True | |
Pli_Collection | String | True | |
Following | Bool | False |
Is user following this record |
My_Favorite | Bool | False |
Favorite for the user |
Tag | String | False | |
Commentlog | String | True | |
Locked_Fields | String | True | |
Sync_Key | String | True | |
Assigned_User_Id | String | False |
User ID assigned to record |
Assigned_User_Name | String | True | |
Team_Id | String | False |
Team ID for the account |
Team_Set_Id | String | False | |
Acl_Team_Set_Id | String | False | |
Team_Count | String | False | |
Team_Name | String | False | |
Acl_Team_Names | String | True | |
Currency_Id | String | False | |
Base_Rate | String | False | |
Currency_Name | String | True | |
Currency_Symbol | String | True | |
Purchases_Contacts_1_Name | String | True | |
Purchases_Contacts_1contacts_Idb | String | False |