Finance Settings
Home
Finance Settings
Spreadsheet Fields (Finance)
BRAND
*
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 2 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Place / CS Number
*
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 1 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Company
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 7 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Dealer
*
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 8 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Customer Mobile
*
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 4 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Customer Email
*
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 5 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Customer Fullname
*
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 3 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Customer Full Address
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 6 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Insurance Company
*
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 9 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Policy No.
*
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 10 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Policy Issue Date
*
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 11 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Policy Start Date
*
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 12 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Policy End Date
*
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 13 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Insurance Type
*
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 14 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Bank
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 15 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
SC Fullname
*
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 16 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Locked In
*
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 17 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Locked In Years
*
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 18 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Paid Amount
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 19 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Terms
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 20 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>