The Teamleader Focus formulas provides access from within Excel to data contained in Teamleader Focus.
The formulas are only available when connected to Teamleader Focus.
The following Excel formulas are available for Teamleader Focus:
%% Begin Waypoint %%
- [[I_TLR_COMPANY_ACCOUNT_MANAGER_ID]]
- [[I_TLR_COMPANY_BIC_NUMBER]]
- [[I_TLR_COMPANY_CITY]]
- [[I_TLR_COMPANY_COC_NUMBER]]
- [[I_TLR_COMPANY_COUNTRY]]
- [[I_TLR_COMPANY_DELIVERY_ADDRESS_NAME]]
- [[I_TLR_COMPANY_DELIVERY_CITY]]
- [[I_TLR_COMPANY_DELIVERY_COUNTRY]]
- [[I_TLR_COMPANY_DELIVERY_STREET_NAME]]
- [[I_TLR_COMPANY_DELIVERY_STREET_NUMBER]]
- [[I_TLR_COMPANY_DELIVERY_ZIPCODE]]
- [[I_TLR_COMPANY_EMAIL]]
- [[I_TLR_COMPANY_EXTERNAL_CUSTOMER_ID]]
- [[I_TLR_COMPANY_FAX]]
- [[I_TLR_COMPANY_IBAN_NUMBER]]
- [[I_TLR_COMPANY_INVOICE_EMAIL_ADDRESS]]
- [[I_TLR_COMPANY_INVOICING_ADRESS_NAME]]
- [[I_TLR_COMPANY_INVOICING_CITY]]
- [[I_TLR_COMPANY_INVOICING_COUNTRY]]
- [[I_TLR_COMPANY_INVOICING_STREET_NAME]]
- [[I_TLR_COMPANY_INVOICING_STREET_NUMBER]]
- [[I_TLR_COMPANY_INVOICING_ZIPCODE]]
- [[I_TLR_COMPANY_LANGUAGE_CODE]]
- [[I_TLR_COMPANY_LOCAL_BUSINESS_NUMBER]]
- [[I_TLR_COMPANY_NAME]]
- [[I_TLR_COMPANY_PAYMENT_TERM]]
- [[I_TLR_COMPANY_PHONE]]
- [[I_TLR_COMPANY_PRICELIST_ID]]
- [[I_TLR_COMPANY_SECTOR_NAME]]
- [[I_TLR_COMPANY_STREET_NAME]]
- [[I_TLR_COMPANY_TAX_CODE]]
- [[I_TLR_COMPANY_VAT_LIABILITY]]
- [[I_TLR_COMPANY_VISITING_ADDRESS_NAME]]
- [[I_TLR_COMPANY_VISITING_CITY]]
- [[I_TLR_COMPANY_VISITING_COUNTRY]]
- [[I_TLR_COMPANY_VISITING_STREET_NAME]]
- [[I_TLR_COMPANY_VISITING_STREET_NUMBER]]
- [[I_TLR_COMPANY_VISITING_ZIPCODE]]
- [[I_TLR_COMPANY_WEBSITE]]
- [[I_TLR_COMPANY_ZIP_CODE]]
%% End Waypoint %%