JDBC Driver for Cvent

Build 24.0.9062

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.

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