billmax documentation   BillMax Billing Solutions
  877.245.5629
  sales@billmax.com
 

Name

config table — table for Virtual Company data

config Field Definitions

During installation, BillMax inserts a record with the set of defaults listing here. Normal practice is to use one Virtual Company as a template for a new Virtual Company

Name

Description

Data Type BillMax Default
Name

Description

Data Type BillMax Default
acemail

Administrative Contact email address. This email address is used as the "To:" for daily processing emails. A value for this field is required.

varchar(100) No default. User input required.
acfname

Administrative Contact first name.

varchar(30) BLANK
aclname

Administrative Contact last name.

varchar(30) BLANK
addr1

Address field.

varchar(30) BLANK
addr2

Address field.

varchar(30) BLANK
addr3

Address field.

varchar(30) BLANK
addr4

Address field.

varchar(30) BLANK
autocredit

When the Service end date is specified using the Staff Interface, this option defines what to do for Sales that have Payhist Enddates in the future relative to the Service end date. The value supplied may be overridden on a Service by Service basis.

int(11) 0
bcemail

Billing Contact email address. This email address is used as the "From:" address when BillMax sends emails to customers. This address receives daily processing emails. A value for this field is required.

varchar(100) No default. User input required.
bcfname

Billing Contact first name.

varchar(30) BLANK
bclname

Billing Contact last name.

varchar(30) BLANK
billnextterm

Defines billing if a partial service term is billed a prorated amount. If this occurs, the setting of billnextterm determines whether an additional complete service term is billed in addition to the prorated term?

  • 0 - No - Additional complete service term not billed during Service creation.

  • 1 - Yes - Additional complete service term billed during Service creation.

  • 2 - Ask - Prompts Customer Service Representative when a new Service is added.

int(11) 1
billtaxable

Defines tax status of postal and fax surcharges.

  • 0 - No - postal and fax surcharges are not taxable.

  • 1 - Yes - postal and fax surcharges are taxable.

int(11) 0
ccdecipher

The Permissions needed to view the full credit card number.

int(11) 0
ccexpwarn

Defines how long in days before an Account's credit card expiration date an email may be sent to the Account notifying the Account holder of the impending credit card expiration. See Email Template Files.

int(11) 30
ccfailcharge

Defines the amount to bill an Account when the Account credit card is declined.

int(11) 0
ccspan

The number of days to wait between re-trying a declined credit card.

int(11) 4
cctries

The maximum number of consecutive unsuccessful attempts to charge a credit card.

int(11) 3
chargemax

The default maximum Account balance that will be charged to a credit card through nightly processing. If the Account balance is greater than this amount and this amount is non-zero, credit card processing will not occur for the Account.

int(11) 0
chargemin

The default minimum Account balance that will be charged to a credit card through nightly processing. If the Account balance is less than this amount and this amount is non-zero, credit card processing will not occur for the Account.

int(11) 500(5.00 in USD)
city

Address field.

varchar(30) BLANK
company

Company name.

varchar(30) BLANK
country

Address field.

varchar(30) BLANK
creditdue

The default minimum Account balance (specified as a small negative value) that will be refunded to a credit card through nightly processing. Ignoring the negative sign, if the Account balance is refundable and the amount is less than this amount and this amount is non-zero, credit card processing will not occur for the Account

int(11) -2000(-20.00 in USD)
defdomain

Default domain used when creating an email address for a User or Account. If a User or Account does not have an email address, when a Service is created, the Service d01 field is combined with defdomain to create an email address for the User and/or Account. The Customer Service Representative is prompted whether to use the value to populate the Account and/or User data.

varchar(65) BLANK
definvday

The default used for populating the Invday of a new Account

  • 0 - The day of month of the current date is used to populate the Invday of a new Account.

  • 1 through 28 - used to populate the Invday of a new Account.

int(11) 0
epaydays

Default epaydays for an Account. When an invoice is created through automated processing, this value is added to the invoice date to set the invoice's epaydate. Epaydate is the first date an attempt will be made to collect payment for an unpaid invoice through automated payment processing.

int(11) 0
expiredclose

Defines the number of days a Account, User or Service remains in a Suspended State before being changed to a Closed State.

int(11) 7
fax

Virtual Company's fax number.

varchar(30) BLANK
faxcost

Default monthly charge for sending an Account fax statements.

int(11) 0
gracewarn

Specifies how many days before the expiration of a Grace Date an email is sent. Once emails are started, an email is sent daily until Grace Date is reached. See Email Template Files.

int(11) 0
lateamt

A surcharge billed to an Account when the Account becomes overdue. If latepct is specified, the larger of the two is billed. These surcharges are billed monthly every invday without regards to p-rebilldays.

int(11) 0
lateclosed

Determines whether or not Accounts in the Closed State are billed late fees.

  • 0 - No - late fees are not billed.

  • 1 - Yes - late fees are billed.

int(11) 0
latepct

A percentage used to calculate the surcharge billed to an Account when the Account becomes overdue. The surcharge is the amount overdue multiplied by the percentage. If lateamt is specified, the larger of the two is billed. These surcharges are billed monthly every invday without regards to prebilldays.

float(10,2) 0
latetaxable

Defines whether or not late fees are taxable charges.

  • 0 - No - late fees are not taxable.

  • 1 - Yes - late fees are taxable.

int(11) 0
newservice

The default state of a new Service.

  • 0 - OPEN

  • 3 - WAIT_FOR_PAYMENT - This default is not used if the amount billed for the service does not cause the Account to have a positive balance.

The state of a service will be changed from WAIT_FOR_PAYMENT to OPEN if either a payment is received or 30 days elapse.

int(11) 0
number

System Identifier for a database row. In most cases automatically generated. Allowable range is 1-2147483647.

int(11) System Identifier for a database row. In most cases automatically generated. Allowable range is 1-2147483647.
odinterval

How often overdue notices are sent. Number of days between overdue notices is odinterval - 1.

Examples

  • 0 - No overdue notice sent.

  • 1 - Overdue notice sent every day.

  • 2 - Overdue notice sent every other day. 1 day in between overdue notices.

int(11) 1
odmax

Maximum number of overdue notices sent to an overdue Account.

  • 0 - Overdue notices sent until the Account State is not Open State.

  • 1 or more - Maximum number.

int(11) 0
overduemin

Minimum amount owed by a Account that will trigger Overdue Processing.

int(11) 2000(20.00 in USD)
overduenotice

Number of days an amount is overdue before overdue notices are sent to an Account. If 0, no notices are sent.

int(11) 5
overduesusp

Number of days an amount is overdue before an Account gets suspended. If 0, Accounts are not suspended.

int(11) 10
phone

Virtual Company phone number.

varchar(30) BLANK
postalcost

Default postal cost for Accounts that receive postal statements.

int(11) 0
prebilldays

A renewable service will be pre-billed this many days before it expires. Statements will be sent to customers this many days before their Invday also.

int(11) 0
primeend

24 hour clock time specifying the end of Prime Time used in Metered Billing.

time 23:00:00(24 hour clock)
primestart

24 hour clock time specifying the start of Prime Time used in Metered Billing.

time 18:00:00(24 hour clock)
refundmax

The default maximum Account balance (specified as a large negative value) that will be refunded to a credit card through nightly processing. Ignoring the negative sign, if the Account balance is refundable and the amount is greater than this amount and this amount is non-zero, credit card processing will not occur for the Account

int(11) 0
refwait

Number of days that a service must be open before referral Store Credit will be issued to the referring Account.

int(11) 30
sendnullstmt

A bitmask.

Blank Statement

Send a blank Statement monthly to Accounts even if there has been no financial activity.

Non-zero Balance

Send a Statement monthly to Accounts that have a non-zero balance.

Activity Monthly

Send a Statement to Accounts that have had financial activity in the past month regardless of money owed or not. A Statement is sent only if the customer has not already received a Statement detailing the financial activity.

Monthly(money owed)

Send a Statement to Accounts at least monthly that owe money.

Monthly(money owed greater than overduemin)

Send a Statement to Accounts at least monthly that owe an amount greater than config.overduemin.

Activity Daily

Send a Statement to Accounts any day there is financial activity. If this option is chosen, it is recommended that the -g be specified when running make_statements and send_statements.

Activity Daily(money owed)

Send a Statement to Accounts any day there is financial activity and money is owed at the end of processing. If this option is chosen, it is recommended that the -g be specified when running make_statements and send_statements.

int(11) 0
state

Address Field.

varchar(30) BLANK
stmtnote

The message that appears at the end of customer statements. Each line will be centered when printed on the statement.

mediumtext BLANK
taxid

Placeholder for the Federal Tax ID.

varchar(15) BLANK
termscheck

Default payment terms for Accounts paying via the check or cash Payment Method.

int(11) 15
termscredit

Default payment terms for Accounts paying via the credit card Payment Method.

int(11) 15
termsecash

Default payment terms for Accounts paying via the ecash Payment Method.

int(11) 15
termseft

Default payment terms for Accounts paying via the EFT Payment Method.

int(11) 15
usageepaydays

Choose whether or not timing for collecting funds for usage data should take into account epaydays.

int(11) 0
usageprebilldays

Specified whether to-date usage will be billed this config.prebilldays days before the next usage billing period as specified by usage billing options of a Service Definition.

int(11) 0
waitcredit

When a Service State is changed from Wait_For_Payment State to Open State, should BillMax automatically issue Store Credit for the time the Service State was Wait_For_Payment State?

tinyint(4) 0
zip

Address Field.

varchar(30) BLANK

SEE ALSO

Relevant Interfaces

  1. Library Routines

    BillMax_ConfigGet
    BillMax_ConfigGetNext
    BillMax_ConfigGetWhere
    BillMax_ConfigPutIntoEnviron
  2. Command Line Routines - NONE

  3. CGI Routines - NONE

  4. Web Forms - the section called “Configuring a Virtual Company”

SEE ALSO

Relevant Interfaces

  1. Library Routines

    BillMax_ConfigGet
    BillMax_ConfigGetNext
    BillMax_ConfigGetWhere
    BillMax_ConfigPutIntoEnviron
  2. Command Line Routines - NONE

  3. CGI Routines - NONE

  4. Web Forms - the section called “Configuring a Virtual Company”


Document Revision A for BillMax 2.2.0   -   Copyright © 1997-2006 The iSpark Group, Inc.

All rights reserved. No part of this documentation may be reproduced or transmitted in any fashion without written permission by The iSpark Group, Inc. This documentation is for the sole use of licensees of the BillMax billing software created by The iSpark Group, Inc. Making the documentation available to a non-licensee of BillMax without written permission of The iSpark Group, Inc. is a violation of the use of this documentation.

While precautions have been taken in the preparation of this documentation, The iSpark Group, Inc. assumes neither liability nor responsibility for errors or omissions, or for damages resulting from the use of the information contained herein.

All terms mentioned that are known to be trademarks have been appropriately capitalized. Use of the a trademark does not affect the validity of any trademark or service mark.

Links to third-party Web sites are provided for convenience. The iSpark Group, Inc. is not responsible for any content contained in the third-party Web sites.

Comments about this documentation may be sent to doc@billmax.com