BoostExcel main content

"Customer" database table

This "Cell Name Reference" document was written for Excel Invoice Manager. It is also useful for Invoice Manager for Excel users who want to customize our template by following Customize Invoice Template.

When you click the Customer-Selection icon button on the Excel sheet and select a customer, certain fields in the Customer table are written to the Invoice worksheet. The following chart shows you all field names and their matching cell names.

Field Name Cell Name
CustomerId oknWhoID
CustomerName oknWhoName
Address oknWhoAddress
Phone oknWhoPhone
Country oknWhoCountry
Email oknWhoEmail
AccountBalance oknAccountBalance
CityState, Zip oknWhoCityStateZip
Credit oknCredit
AccountBalance oknAccountBalance
Category oknWhoCategory
(All custom fields) okn(Field Name)

"Product" table

When you click the Product-Selection icon button and select a product, certain fields in the Product table are written to the Invoice worksheet. The following chart shows you all field names and their matching cell names. ("**" in the chart indicates line number in the invoide body.)

Field Name Cell Name
ProductID oknProductID_**
ProductName oknProductName_**
Price oknPrice_**
Cost oknCost_**
Taxable oknTaxable_**
(All custom fields) okn(Field Name)_**

Cell name prefixes

In Excel Invoice Manager, cells on the worksheets are identified by names. This design allows you to move the cells to a proper position you like. Each worksheet has its own predefined cell name prefix.

Worksheet Cell Name Prefix
Invoice okn
Sales Report oknRs
Customer Report oknRc
Product Report oknRp
Customer Statement oknCs
Sales Rep. Report oknRr
Payment Report oknPr