service Table (Products)

Pricing is in cents.

Name Description Type
number   int(11)
user Foreign key to user.number int(11)
state Status
  • 0 - Open
  • 1 - Closed
  • 2 - Suspended
  • 3 - Waiting for Payment
  • 5 - Prospective
 tinyint(4)
startdate   date
enddate   date
servdef Foreign key to servdef.number int(11)
free   tinyint(4)
wsetup
  • 0- Yes
  • 1 - No
  • 2 - On Open
 tinyint(4)
entdate   date
enttime   time
empl   mediumint(8)
lastmodempl   mediumint(8)
d01 Customizable Provisioning Field Label char(100)
d02 Customizable Provisioning Field Label char(100)
d03 Customizable Provisioning Field Label char(100)
d04 Customizable Provisioning Field Label char(100)
d05 Customizable Provisioning Field Label char(100)
d06 Customizable Provisioning Field Label char(100)
d07 Customizable Provisioning Field Label char(100)
d08 Customizable Provisioning Field Label char(100)
d09 Customizable Provisioning Field Label char(100)
d10 Customizable Provisioning Field Label char(100)
invdate Next Bill Date date
taxable
  • 1 - taxable
  • 0 - not taxable
  • -1 - not applicable
 tinyint(4)
taxrule   int(11)
iprice First Price decimal(30,10)
iduration First Duration - positive integer for months, negative integer for days int(11)
icnt Number of Times to Bill First Price int(11)
price Second Price decimal(30,10)
duration Second Duration - positive integer for months, negative integer for days int(11)
cnt Number of Times to Bill Second Price int(11)
lprice Third Price decimal(30,10)
lduration Third Duration - positive integer for months, negative integer for days int(11)
lcnt Number of Times to Bill Third Price int(11)
tot_seconds used for metered billing int(11)
prime_seconds used for metered billing int(11)
ponumber P.O. Number char(30)
refaccount Referral Account Number int(11)
refdate Referral Credit Date date
misc01 Integer Field through misc05 int(11)
misc02   int(11)
misc03   int(11)
misc04   int(11)
misc05   int(11)
misc06 Character (50) Field through misc10 char(50)
misc07   char(50)
misc08   char(50)
misc09   char(50)
misc10   char(50)
misc11 Date Field through misc15 date
misc12   date
misc13   date
misc14   date
misc15   date
misc16 Time Field through misc20 time
misc17   time
misc18   time
misc19   time
misc20   time
generation   timestamp
reason Reason for why a Service is not Open
  • 0 - Not Applicable
  • 1- Overdue
  • 2- AUP Violation
  • 3- Administrative
  • 4 - Expired
  • 5 - Over Usage
  • 8 - Customer Request
  • 9 - No Time Left
  • 10 - Future Start Date
  • 11 - Service Definition Setting
  • 12 - Wait for Qualification
  • 13 - Wait for Activation
 mediumint(8)
reasonbyuser   tinyint(4)
cleardate Last date for metered billing the totals were zeroed out date
bwreportdate Last date for metered billing fields were updated date
tiervalue Last date for metered billing the totals were zeroed out decimal(20,8)
suspdate Date service was suspended date
setup_taxable
  • 1 - taxable
  • 0 - not taxable
  • -1 - not applicable
 tinyint(4)
wdeposit
  • 0 - it has not been collected
  • 1 - do not collect
  • 2 - collect on open
  • 3 - it has been collected
 tinyint(4)
resources Provisioning resources that should match the Service Definition Resources int(11)
quantity   decimal(14,6)
invcnt Number of times an item has been billed not counting proration int(11)
changetocnt Number of times a Service has gone through a Service Change int(11)
plaintextpass Number of times a Service has gone through a Service Change char(50)
invday Billing/Prorate Day from an Account tinyint(4)
nextusagedate Next Usage Bill Date date
quantityfree   decimal(14,6)
cyclept Where you are in the cycle int(11)
salesrep No longer used - now in serviceagenttable int(11)
tiercost   bigint(20)
prevstate   tinyint(4)
prevreason   mediumint(8)
package The Package a Service belongs to if needed int(11)
flags
Bit Position Bit Value Description
0 1
1 2 Sales Return of Future Billed Service when closing a Service
2 4 Deposit Return of $xx
3 8 Reopen Services
4 16 Sales Return to be given when opening
5 32  
6 64 Bill an additional term in additon to the prorated term
7 128  
8 256 Package
9 512  
10 1024 Display zero priced Usage
11 2048 Ignore Discounts
12 4096 Auto Store Credit Recurring Sales
13 8192 Auto Store Credit Usage Sales
bitmask
datetoreopen Date to Reopen/Date to Resume Billing date
enddatereason   tinyint(4)
importid Import id of the sytem that the service was imported from char(100)
service If a fee, this is the service it belongs to int(11)
pctdiscout Discount Percentage decimal(10,6)
pctdiscountexpdate Date Discount Expires date
usagepctdiscout Usage Discount Percentage decimal(10,6)
usagepctdiscountexpdate Date Usage Discount Expires date
discountamount Discount Amount bigint(20)
prepaidtime Prepaid card usage int(11)
prepaidexpire Prepaid card expiration char(19)
etfee Early Termination Fee bigint(20)
contractenddate Contract End Date date
locationuser Location - Used for mapping and timezone purposes int(11)
setup Setup Fee bigint(20)
recurbillnote Additional Billing Text - Note that will appear on bill int(11)
descr Description char(100)
promotion Referral Amount int(11)
ap   int(11)
creditreason Credit Reason int(11)
disctype Discount Type tinyint(4)
creditbillingdisplay Credit Billing Display - will show with discount on bill char(100)
cnttf1 count for tax feature mediumint(8)
cnttf2 count for tax feature mediumint(8)
cnttf3 count for tax feature mediumint(8)
plsp   decimal(10,6)