BudgetItems
Returns data from the BudgetItems table.
Table Specific Information
The Cvent API allows you to filter by certain fields when querying for data.
The following is an example of a SELECT statement:
select * from BudgetItems where Id='cventId' or Date <= '06/11/2020'The following is an example of an INSERT statement that uses an aggregate field:
String costDetail = '[ { \id\: \281d7a8b-f525-4658-9268-5ea73c97a54e\, ame\: \Budgeted\, \units\: 1.0, \cost\: 500.0, \gratuityDetail\: { \gratuity\: 0.0, \appliedGratuityValue\: 0.0 }, \taxDetail\: [], \totalCost\: 500.0 }, { \id\: \d8cbab1a-e370-43b9-afde-a097c81e20e1\, ame\: egotiated\, \units\: 1.0, \cost\: 400.0, \gratuityDetail\: { \gratuity\: 0.0, \appliedGratuityValue\: 0.0 }, \taxDetail\: [], \totalCost\: 400.0 }, { \id\: \0ca4467a-5843-4204-8c26-452680b04b27\, ame\: \Revision1\, \units\: 1.0, \cost\: 424.0, \gratuityDetail\: { \gratuity\: 0.0, \appliedGratuityValue\: 0.0 }, \taxDetail\: [], \totalCost\: 424.0 }, { \id\: \10cc5cef-a4f3-4474-bb9d-0c0c7110b351\, ame\: \Revision2\, \units\: 1.0, \cost\: 455.0, \gratuityDetail\: { \gratuity\: 0.0, \appliedGratuityValue\: 0.0 }, \taxDetail\: [], \totalCost\: 455.0 }, { \id\: \2eec2b68-808d-4bab-a061-b4fafc3300dc\, ame\: \Actual\, \units\: 1.0, \cost\: 455.0, \gratuityDetail\: { \gratuity\: 0.0, \appliedGratuityValue\: 0.0 }, \taxDetail\: [], \totalCost\: 455.0 } ]';
INSERT INTO budgetitems (EventId, costType, name, Status, Date, costIncludesTaxGratuity, calculateTaxOnGratuity, gratuityType, currency, conversionRate, CategoryId, CategoryName, costDetailAggregate) VALUES('0ac85e1d-ef51-43a0-a4cf-773b64b1c6f9', 'FIXED', 'Airport Transportation', 'ESTIMATED', '2020-02-07T00:00:00.00Z', false, true, 'PERCENTAGE', 'USD', '5.2', '3', 'Travel', costDetail)The following is an example of an UPDATE statement that uses an aggregate field:
Update BudgetItems SET costType='FIXED', name='Airport Transportation', CategoryId='3', CategoryName='Travel', status='PAID', date='2024-02-07T00:00:00.00Z', costIncludesTaxGratuity='false', calculateTaxOnGratuity='true' , gratuityType='PERCENTAGE', currency='USD', conversionRate='5.2',costDetailAggregate=costDetail where EventId='0ac85e1d-ef51-43a0-a4cf-773b64b1c6f9' and id='eb07a054-71a5-49a5-9773-064c3b9ec507'
Columns
Name | Type | ReadOnly | References | Description |
Deleted | Boolean | False |
The Deleted of the BudgetItems table. | |
Id [KEY] | String | False |
The Id of the BudgetItems table. | |
CostType | String | False |
The CostType of the BudgetItems table. | |
Name | String | False |
The Name of the BudgetItems table. | |
Code | String | False |
The Code of the BudgetItems table. | |
Status | String | False |
The Status of the BudgetItems table. | |
Date | Datetime | False |
The Date of the BudgetItems table. | |
LastModifiedDate | Datetime | False |
The LastModifiedDate of the BudgetItems table. | |
CostIncludesTaxGratuity | Boolean | False |
The CostIncludesTaxGratuity of the BudgetItems table. | |
CalculateTaxOnGratuity | Boolean | False |
The CalculateTaxOnGratuity of the BudgetItems table. | |
GratuityType | String | False |
The GratuityType of the BudgetItems table. | |
InternalNote | String | False |
The InternalNote of the BudgetItems table. | |
Currency | String | False |
The Currency of the BudgetItems table. | |
ConversionRateLocked | String | False |
The ConversionRateLocked of the BudgetItems table. | |
ConversionRate | String | False |
The ConversionRate of the BudgetItems table. | |
AssociatedSession | String | False |
The AssociatedSession of the BudgetItems table. | |
CategoryId | String | False |
The CategoryId of the BudgetItems table. | |
CategoryName | String | False |
The CategoryName of the BudgetItems table. | |
SubCategoryId | String | False |
The SubCategoryId of the BudgetItems table. | |
SubCategoryName | String | False |
The SubCategoryName of the BudgetItems table. | |
VendorId | String | False |
The VendorId of the BudgetItems table. | |
VendorName | String | False |
The VendorName of the BudgetItems table. | |
VendorType | String | False |
The VendorType of the BudgetItems table. | |
GeneralLedgerId | String | False |
The GeneralLedgerId of the BudgetItems table. | |
GeneralLedgerCode | String | False |
The GeneralLedgerCode of the BudgetItems table. | |
GeneralLedgerName | String | False |
The GeneralLedgerName of the BudgetItems table. | |
CostAvoidanceAmount | Double | False |
The CostAvoidanceAmount of the BudgetItems table. | |
CostAvoidanceDescription | String | False |
The CostAvoidanceDescription of the BudgetItems table. | |
CostDetailAggregate | String | False |
The CostDetailAggregate of the BudgetItems table. | |
SavingsAggregate | String | False |
The SavingsAggregate of the BudgetItems table. | |
AssociatedRegistrantsAggregate | String | False |
The AssociatedRegistrantsAggregate of the BudgetItems table. | |
EventId [KEY] | String | False |
Events.Id |
The EventId of the BudgetItems table. |