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 PO 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 addition 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
bit-mask
datetoreopen Date to Reopen/Date to Resume Billing date
enddatereason tinyint(4)
importid Import id of the system 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)