"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 NameCell Name
CustomerIdoknWhoID
CustomerNameoknWhoName
AddressoknWhoAddress
PhoneoknWhoPhone
CountryoknWhoCountry
EmailoknWhoEmail
AccountBalanceoknAccountBalance
CityState, ZipoknWhoCityStateZip
CreditoknCredit
AccountBalanceoknAccountBalance
CategoryoknWhoCategory
(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 NameCell Name
ProductIDoknProductID_**
ProductNameoknProductName_**
PriceoknPrice_**
CostoknCost_**
TaxableoknTaxable_**
(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.

WorksheetCell Name Prefix
Invoiceokn
Sales ReportoknRs
Customer ReportoknRc
Product ReportoknRp
Customer StatementoknCs
Sales Rep. ReportoknRr
Payment ReportoknPr