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