Field Naming Scheme

The naming scheme is as follows:

Agency basic field example:
Mobile: agency_basic_field_543_mobile
Routing Number: agency_basic_field_6995_routing_number
Banking/Account Number: agency_basic_field_6996_banking/account_number
Tax ID: agency_basic_field_6993_tax_id

This also applies to the parent object's basic fields as well. For example, columns for the agency basic fields on the rep table:

Mobile: rep_agency_basic_field_543_mobile
Routing Number: rep_agency_basic_field_6995_routing_number
Banking/Account Number: rep_agency_basic_field_6996_banking/account_number
Tax ID: rep_agency_basic_field_6993_tax_id

Commission variable example:

BAN: commission_item_variable_2514_ban
Billing Month: commission_item_variable_2507_billing_month
BTN: commission_item_variable_2513_btn
City: commission_item_variable_2511_city
Commission date: commission_item_variable_2526_commission_date
Contract End Date: commission_item_variable_2530_contract_end_date
Contact Start Date: commission_item_variable_2515_contract_start_date

Product variable example:

Product code: product_product_code → product_variable_2208_product_code