json
{
"template_id": "tpl_john_tour_v1",
"template_name": "John Tour Standard Deal",
"deal_type": "guarantee_vs_percentage_nbor",
"description": "Guarantee vs 90% of Net Receipts after Expenses + Ticket Bonus + Merch Split",
"variable_definitions": [
{
"variable_key": "v_guarantee",
"name": "Artist Guarantee",
"type": "number",
"required": true,
"description": "Fixed guarantee amount"
},
{
"variable_key": "v_artist_percentage",
"name": "Artist Split Percentage",
"type": "number",
"required": true,
"default_value": 90
},
{
"variable_key": "v_bonus_per_ticket",
"name": "Bonus Amount Per Ticket",
"type": "number",
"required": true,
"default_value": 1.00
},
{
"variable_key": "v_bonus_cap_tickets",
"name": "Bonus Customer Cap",
"type": "number",
"required": true,
"description": "Max number of tickets for bonus calculation"
},
{
"variable_key": "v_merch_artist_percentage",
"name": "Merch Artist Percentage",
"type": "number",
"required": true,
"default_value": 85
}
],
"clause_block_templates": [
{
"clause_block_template_id": "cbt_john_show",
"name": "Show Performance",
"is_required": true,
"allow_multiple": true,
"state_templates": [
{
"state_key": "SHOW_FINANCIALS",
"state_type": "object",
"name": "Show Financial Summary",
"is_required": true,
"calculation_template": {
"gross_receipts": "BOX_OFFICE_INPUT.value.total_gross",
"taxes": "TAX_FEE_INPUT.value.total_taxes",
"fees": "TAX_FEE_INPUT.value.total_fees",
"net_receipts": "this.gross_receipts - this.taxes - this.fees",
"total_expenses": "EXPENSE_INPUT.value.total_fixed + EXPENSE_INPUT.value.total_variable + EXPENSE_INPUT.value.support_cost",
"adjusted_gross": "MAX(0, this.net_receipts - this.total_expenses)",
"artist_split_earnings": "this.adjusted_gross * v_artist_percentage / 100",
"tickets_sold": "BOX_OFFICE_INPUT.value.total_sold"
}
}
],
"input_templates": [
{
"input_key": "SHOW_METADATA_INPUT",
"input_type": "object",
"name": "Show Details",
"is_required": true,
"schema": {
"date": {
"type": "date"
},
"venue": {
"type": "string"
},
"city": {
"type": "string"
},
"state": {
"type": "string"
}
}
},
{
"input_key": "BOX_OFFICE_INPUT",
"input_type": "object",
"name": "Box Office Sales",
"is_required": true,
"schema": {
"total_gross": {
"type": "number"
},
"total_sold": {
"type": "number"
},
"tiers": {
"type": "array",
"items": {
"name": {
"type": "string"
},
"price": {
"type": "number"
},
"sold": {
"type": "number"
}
}
}
}
},
{
"input_key": "TAX_FEE_INPUT",
"input_type": "object",
"name": "Taxes and Fees",
"is_required": true,
"schema": {
"total_taxes": {
"type": "number"
},
"total_fees": {
"type": "number"
}
}
},
{
"input_key": "EXPENSE_INPUT",
"input_type": "object",
"name": "Expenses",
"is_required": true,
"schema": {
"total_fixed": {
"type": "number"
},
"total_variable": {
"type": "number"
},
"support_cost": {
"type": "number"
},
"breakdown": {
"type": "array"
}
}
},
{
"input_key": "MERCH_INPUT",
"input_type": "object",
"name": "Merchandise Sales",
"is_required": false,
"schema": {
"gross_sales": {
"type": "number"
}
}
}
],
"financial_clause_templates": [
{
"clause_template_id": "ct_primary_deal",
"name": "Guarantee vs Settlement",
"is_required": true,
"trigger_template": "true",
"calculation_template": "MAX(v_guarantee, SHOW_FINANCIALS.value.artist_split_earnings)",
"payment_terms_template": [
{
"payment_term_id": "pt_balance",
"payment_term_name": "Balance Payment",
"payment_type": "lump_sum",
"amount": {
"type": "remaining_balance"
},
"due_date": {
"type": "relative",
"trigger": "settlement",
"offset_days": 0
}
}
]
},
{
"clause_template_id": "ct_ticket_bonus",
"name": "Ticket Bonus",
"is_required": true,
"trigger_template": "SHOW_FINANCIALS.value.tickets_sold > 0",
"calculation_template": "MIN(SHOW_FINANCIALS.value.tickets_sold, v_bonus_cap_tickets) * v_bonus_per_ticket"
},
{
"clause_template_id": "ct_merch_settlement",
"name": "Merchandise Settlement",
"is_required": false,
"trigger_template": "EXISTS(MERCH_INPUT)",
"calculation_template": "MERCH_INPUT.value.gross_sales * v_merch_artist_percentage / 100"
}
]
}
]
}