enter_account.cgi

Used to create or modify an Account record. If creating an Account, a User record is also created.

Usage

/usr/local/billmax/cgi-bin/enter_account.cgi

Environment

All data is passed via environment variables of the form FORM_variablename with the following exceptions:
  • Dates are passed as FORM_variablename_year, FORM_variablename_month and FORM_variablename_day. A four digit year is required. Two digits for month and day respectively are required.
  • Times are passed as FORM_variablename_hour, FORM_variablename_minute and FORM_variablename_second. Two digits are required for each.
Name Type Description Required
srchnumber Integer If non zero, the number of an existing Account. Yes
number Integer The number to use for the Account. Recommended to use 0 for a new Account. Yes
state Integer Status of the Account.
0
Open
1
Closed
2
Suspended
4
Collections
Yes if a new Account.
startdate Date   Yes if a new Account
enddate Date    
adcode Integer

Advertising Code

0 or a value from the adcodes List.
 
cancelreason Integer

Cancel Reason

0 or a value from the cancelreasons List.
 
referredby String    
cfname String First Name  
cmname String Middle Name  
clname String Last Name  
company String    
cphone String Phone Number  
fphone String Fax Number  
email String    
textmessage String Email address equivalent for a cell phone.  
taxable Integer
-1
Tax Not Applicable
0
Tax Exempt for all taxes
1
Taxable
Yes if a new Account.
taxregion Integer
-1
Tax Region Not Applicable
>0
A reference to the number field in the taxregion table.
Yes if a new Account.
reseller String    
paytype Integer

Default Payment Method

1
Cash/Check
2
Credit
3
Electronic Check
4
EFT
5
Credit Once, then change to Cash/Check
Yes if a new Account.
invmethod String

Automated Billing Methods.

This is contextual depending on the Account Profile. A "0" indicates no automated method is selected. Otherwise, a comma separated list such as "1,2,4,16..." indicates which Document Delivery Methods from the Account Profile should be used. Note each entry in the comma separated list is a power of 2.
Yes if a new Account.
addr1 String    
addr2 String    
addr3 String    
addr4 String    
city String    
statename String    
zip String    
country String    
county String    
invday Integer Billing/Prorate Day of Month. If 0, then the setting from the Virtual Company will be used.  
gracedate Date Date an overdue Account has until Overdue processing is started.  
misc01 Integer    
misc02 Integer    
misc03 Integer    
misc04 Integer    
misc05 Integer    
misc06 String    
misc07 String    
misc08 String    
misc09 String    
misc10 String    
misc11 Date    
misc12 Date    
misc13 Date    
misc14 Date    
misc15 Date    
misc16 Time    
misc17 Time    
misc18 Time    
misc19 Time    
misc20 Time    
customerof Integer

Virtual Company.

A reference to the number field in the config table.
Yes if a new Account.
generation Time stamp
Blank
Used for new Account
YYYY-MM-DD HH:MM:SS
The time stamp of the existing Account record.
Yes
reason Integer The reason an Account is not open. 0 or a value from the reasons List.  
title Integer 0 or a value from the titles List.  
bmui Integer Portal Access.
0
Portal Access disallowed.
1
Portal Access allowed.
 
useradmin Integer

Account Administrative Portal User

0
No User specified
-1
Set to the first User created under this Account
>1
An existing User of this Account.
 
immune String Comma separate list of values, each value a power of 2.
1
Immune from automated suspension
2
Immune from Late Fees.
4
Will not receive overdue emails
 
profile Integer

Account Profile.

A reference to the number field in the profile table.
 
vataxid String Value Added Tax ID  
datetoreopen Date If an account is not Open, the date in the future to reopen the account automatically.  
flags String Comma separate list of values, each value a power of 2.
1
Issue Sales Returns for services billed in the future when Closing the Account.
4
Issue Deposit Returns when Closing the Account.
8
Reopen Users and Services that where Suspended or Closed when the Account was Suspended or Closed.
16
Issue Sales Returns for period billed but Account was Suspended or Closed.
 
enddatereason Integer Reason that the End Date has been set.
4
The End Date was set because the Account is closing. Normal Suspend then Close will take place.
8
The End Date was set at the customer's request. The Account will be Suspended indefinitely until further action is taken.
 
autoeft Integer

Automated Payment Processing modifiers.

Comma separate list of values, each value a power of 2.
1
Disable all automate Collections and Refunds.
2
Disable Automated Refunds
4
Allow one Automated Refund, then disable.
 
importid String If imported from another billing system, the key in the old system for the account  
pctdiscount Decimal Percent discount that all non-Usage Sales to the Account will get. Implemented as a Store Credit for each Sale. Supply "2.5" for a 2.5 percent discount.  
pctdiscountexpdate Date Date that the discount expires.  
usagepctdiscount Decimal Percent discount that all Usage Sales to the Account will get. Implemented as a Store Credit for each Sale.  
usagepctdiscountexpdate Date Date that the Usage discount expires.  
loginid String Portal Login Name for the Administrative User.  
password String Portal Password for the Administrative User.  
guarantor Integer Another Account that will pay the bills for this Account. If non-zero, a reference to the number field in the account table.  
timezone Integer Value from the timezones List.