Returns data from the EventBudgetItems table.

Table Specific Information

SELECT

The Cvent API allows you to filter by certain fields when querying for data. The following fields can be filtered by the API:

• Id supports =
• Deleted supports =,!=
• CostType supports =,!=
• Status supports =,!=
• Date supports >,<,>=,<=
• EventId supports =
• CategoryId supports =,!=
• CategoryName supports =,!=
• SubcategoryId supports =,!=
• SubcategoryName supports =,!=
• VendorId supports =,!=
• VendorName supports =,!=

All other filters are handled client-side.

The following is an example of a SELECT statement:

select * from EventBudgetItems where Id='cventId' or Date <= '06/11/2020'

INSERT

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 EventBudgetItems (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)

UPDATE

The following is an example of an UPDATE statement that uses an aggregate field:

Update EventBudgetItems 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 EventBudgetItems table.
Id [KEY]	String	False		The Id of the EventBudgetItems table.
CostType	String	False		The CostType of the EventBudgetItems table.
Name	String	False		The Name of the EventBudgetItems table.
Code	String	False		The Code of the EventBudgetItems table.
Status	String	False		The Status of the EventBudgetItems table.
Date	Datetime	False		The Date of the EventBudgetItems table.
LastModifiedDate	Datetime	False		The LastModifiedDate of the EventBudgetItems table.
CostIncludesTaxGratuity	Boolean	False		The CostIncludesTaxGratuity of the EventBudgetItems table.
CalculateTaxOnGratuity	Boolean	False		The CalculateTaxOnGratuity of the EventBudgetItems table.
GratuityType	String	False		The GratuityType of the EventBudgetItems table.
InternalNote	String	False		The InternalNote of the EventBudgetItems table.
Currency	String	False		The Currency of the EventBudgetItems table.
ConversionRateLocked	String	False		The ConversionRateLocked of the EventBudgetItems table.
ConversionRate	String	False		The ConversionRate of the EventBudgetItems table.
AssociatedSession	String	False		The AssociatedSession of the EventBudgetItems table.
CategoryId	String	False		The CategoryId of the EventBudgetItems table.
CategoryName	String	False		The CategoryName of the EventBudgetItems table.
SubCategoryId	String	False		The SubCategoryId of the EventBudgetItems table.
SubCategoryName	String	False		The SubCategoryName of the EventBudgetItems table.
VendorId	String	False		The VendorId of the EventBudgetItems table.
VendorName	String	False		The VendorName of the EventBudgetItems table.
VendorType	String	False		The VendorType of the EventBudgetItems table.
GeneralLedgerId	String	False		The GeneralLedgerId of the EventBudgetItems table.
GeneralLedgerCode	String	False		The GeneralLedgerCode of the EventBudgetItems table.
GeneralLedgerName	String	False		The GeneralLedgerName of the EventBudgetItems table.
CostAvoidanceAmount	Double	False		The CostAvoidanceAmount of the EventBudgetItems table.
CostAvoidanceDescription	String	False		The CostAvoidanceDescription of the EventBudgetItems table.
CostDetailAggregate	String	False		The CostDetailAggregate of the EventBudgetItems table.
SavingsAggregate	String	False		The SavingsAggregate of the EventBudgetItems table.
AssociatedRegistrantsAggregate	String	False		The AssociatedRegistrantsAggregate of the EventBudgetItems table.
EventId [KEY]	String	False	Events.Id	The EventId of the EventBudgetItems table.