| number |
|
| entdate |
|
| enttime |
|
| empl |
|
| lastmodempl |
|
| sortorder |
|
| state |
Availability
- 0 - Available
- 1 - Discontinued - No non-Closed Services reference the Definition
- 2 - No New Users - not available to be added.
|
| name |
Billing Display |
| descr |
Name |
| startdate |
The first date a Product will be available for Sale. |
| enddate |
|
| price |
Second Price |
| setup |
Set up Price |
| taxable |
- 1 - taxable
- 0 - not taxable
- -1 - not applicable
|
| renewable |
- 0 - Bill one set of applicable First, Second and Third prices through time.
- 1 - Bill one set of applicable First Second and Third prices through time. When
one set finished, continue to bill last applicable price.
- 2 - Bill one set of applicable First, Second and Third prices, repeat cycle in
definitely.
|
| duration |
Second Duration - positive integer for months, negative integer for days |
| resources |
Resources (using in Provisioning) |
| d01 |
Customizable Provisioning Field Label |
| d02 |
Customizable Provisioning Field Label |
| d03 |
Customizable Provisioning Field Label |
| d04 |
Customizable Provisioning Field Label |
| d05 |
Customizable Provisioning Field Label |
| d06 |
Customizable Provisioning Field Label |
| d07 |
Customizable Provisioning Field Label |
| d08 |
Customizable Provisioning Field Label |
| d09 |
Customizable Provisioning Field Label |
| d10 |
Customizable Provisioning Field Label |
| cd01 |
Constraint or List of d01 |
| cd02 |
not used |
| cd03 |
Constraint or List of d03 |
| cd04 |
Constraint or List of d04 |
| cd05 |
Constraint or List of d05 |
| cd06 |
Constraint or List of d06 |
| cd07 |
Constraint or List of d07 |
| cd08 |
Constraint or List of d08 |
| cd09 |
Constraint or List of d09 |
| cd10 |
Constraint or List of d10 |
| def02 |
not used |
| def03 |
Default for d03 |
| def04 |
Default for d04 |
| def05 |
Default for d05 |
| def06 |
Default for d06 |
| def07 |
Default for d07 |
| def08 |
Default for d08 |
| def09 |
Default for d09 |
| def10 |
Default for d10 |
| ou_notice |
|
| ou_susp |
|
| ouprime_notice |
|
| ouprime_susp |
|
| basehours |
|
| hourlyprice |
|
| charge_type |
Generally used for designated Accounting bucket. |
| iprice |
First Price |
| refamt |
Referral Amount |
| misc01 |
|
| misc02 |
|
| misc03 |
|
| misc04 |
|
| serviceclass |
Generally used for Provisioning. |
| company |
deprecated |
| tierplan |
Usage Pricing Plan |
| hourlyprice_peak |
deprecated |
| basehours_peak |
deprecated |
| setup_taxable |
- 1 - taxable
- 0 - not taxable
- -1 - not applicable
|
| deposit |
Money held for Deposit |
| taxrule |
Tax rule table |
| iduration |
First Duration |
| nosync |
Do not prorate dates/amounts |
| prepaid |
Denotes that this is a prepaid service definition. Managed using Prepaid
Cards |
| d01conflict |
Manages name space of Package/Service d01 fields where a name
space is defined by Resources and Service Definitions that have a common Resource.
- 0 - All d01 values in the name space for non-closed Services
must be unique.
- 1 - d01 values in the name space are not checked for
uniqueness.
- 2 - d01 values within a User may be duplicated, but must be
unique in the name space if belonging to different Users
|
| pwautogen |
- 0 - do not auto-generate a password
- 1 - auto-generate a password
|
| free |
Denotes is a Service is free. Free is defined as no billing activity for either
recurring or usage billing. From an accounting perspective, this is different than
billing while giving a 100% discount. The latter has associated billing activity.
|
| icnt |
Number of times to bill First Price (iprice). Must be
non-zero. |
| billinarrears |
deprecated |
| useplaintextpass |
Store the submitted password (Service/Package d02 value which
is encrypted) in the Service/Package plaintextpass field. This
might be done if needed for provisioning.
|
| usageinvday |
Day of month usage billing should occur. See usageoptions for
use. |
| usageduration |
Duration between usage billings. See usageoptions for
use. |
| usageoptions |
Specifies Usage timing
- 1 - Bill on the Service invday (Day of Month to Bill - Same
as Account Day of Month for synchronized Services)
- 2 - Bill on the Service invdate (Next Bill Date)
- 4 - Bill Monthly on the Package/Service Definition
usageinvday
- 8 - Bill using both the Package Service Definition
usageinvday and usageduration
|
| printzerocharge |
Display zero dollar sales on a Bill
|
| quantity |
Default quantity to sell. Sale is price multiplied by (quantity minus
quantityfree) |
| quantityfree |
Default amount of quantity that should not be billed |
| taxincluded |
Tax included in sales price
|
| cnt |
Number of times to bill Second Price. If 0, no billing takes place and First
Price is the last available price. |
| initialstate |
Initial Status for a newly created Service
- 0 - Open
- 3 - Waiting for Payment
- 5 - Prospective
|
| initialreason |
Initial reason for why a Service is not Open
- 0 - Not Applicable
- 10 - Future Start Date
- 11 - Service Definition Setting
- 12 - Wait for Qualification
- 13 - Wait for Activation
|
| lprice |
Third Price |
| lcnt |
Number of times to bill Third Price. If 0, no billing takes place and the
setting of cnt determines billing. |
| lduration |
Third Duration |
| billnexterm |
In addition to a prorated term, bill an unprorated term |
| refwait |
Number of days to wait before giving referral credit |
| waitcredit |
Give Store Credit for time when Service Status was Wait for Payment |
| flags |
Bit Field
| Bit Position |
Bit Value |
Description |
| 0 |
1 |
Must have a POP (Point of Presence) selected. |
| 1 |
2 |
Bill setup even if Service is in Prospective Status
upon Service creation |
| 2 |
4 |
Bill deposit even if Service is in Prospective
Status upon Service creation |
| 3 |
8 |
Do not execute Service Hook for Provisioning |
| 4 |
16 |
Do not display Dates of Service on the customer's Bill |
| 5 |
32 |
If prorate should occur, prorate date only, not billed amount |
| 6 |
64 |
Denotes a Recurring Service Fee with Provisioning Variables |
| 7 |
128 |
Denotes a One Time Item |
| 8 |
256 |
Denotes a Package |
| 9 |
512 |
Ignore Account Profile Service Offset Days |
| 10 |
1024 |
Create a Transaction for a Zero Dollar billing |
| 11 |
2048 |
unused |
| 12 |
4096 |
Automatically generate Store Credit for Recurring Sales |
| 13 |
8192 |
Automatically generate Store Credit for Usage Based Sales |
| 14 |
16384 |
Available only to a Package |
| 15 |
32768 |
Uses MAC Authentication |
| 16 |
65536 |
Denotes a Bundle |
| 17 |
131072 |
Bill iprice even if Service is in Prospective Status
upon Service creation |
| 18 |
262144 |
Setup billing is Setup price multiplied by quantity |
| 19 |
524288 |
Used to display Package/Service Definitions available for online
Customer Sale. |
| 20 |
1048576 |
Roll up/Combine all billings to a single line on bill for
Packages |
| 21 |
2097152 |
Display the Package/Service Name ( service.d01) on
bill. |
| 22 |
4194304 |
Use to preview a subset of Package/Service Definitions available for
online Customer Sale. |
| 23 |
8388608 |
Display the Package/Service Definition Name ( descr)
on bill. |
| 24 |
16777216 |
Allow billing of Services associated with a Virtual Company different
than those to which this Service Definition is associated. |
| 25 |
33554432 |
Must have an AP (Access Point) selected. |
| 27 |
134217728 |
A Recurring Service Fee will use the fccservice
value of the parent Package/Service |
| 28 |
268435456 |
Ignore discounting settings. |
| 29 |
536870912 |
Do not use prorate setting of parent Package/Service |
|
| servicetemplate |
deprecated |
| generation |
|
| meterdrounding |
|
| warnexpirationdays |
|
| invoicediplaygroup |
Used to group like billing together on a bill |
| useuser |
Bit Field
| Bit Position |
Bit Value |
Description |
| 0 |
1 |
Copy user loginid to Service d01
field on creation |
| 1 |
2 |
Copy user password to Service d02
field on creation |
|
| taxclass |
Setting from List "taxclasses" |
| billingclass |
Setting from List "billingclasses" |
| f01 |
Bit fields used to specify setting for d01-d10 fields
| Bit Field |
Bit Value |
Description |
| 0 |
1 |
Value required |
| 1 |
2 |
Value is a password |
| 3 |
8 |
Value must be unique |
| 5 |
32 |
Append the Virtual Company domain |
| 10 |
1024 |
Display value on Bill |
| 11 |
2048 |
Uses List for values |
| 14 |
16384 |
Prorate value to subordinate Services with the same provisioning
Label |
|
| f02 |
See f01 |
| f03 |
See f01 |
| f04 |
See f01 |
| f05 |
See f01 |
| f06 |
See f01 |
| f07 |
See f01 |
| f08 |
See f01 |
| f09 |
See f01 |
| f10 |
See f01 |
| e01 |
Explanation for d01 |
| e02 |
Explanation for d01 |
| e03 |
Explanation for d01 |
| e04 |
Explanation for d01 |
| e05 |
Explanation for d01 |
| e06 |
Explanation for d01 |
| e07 |
Explanation for d01 |
| e08 |
Explanation for d01 |
| e09 |
Explanation for d01 |
| e10 |
Explanation for d01 |
| saledescr |
Item Name |
| saledetail |
|
| saleimage |
|
| overduefee |
Fee assessed when a Service is Suspended for being Overdue |
| fcctechcode |
Value from List fcctechcodes3 |
| fccuprate |
Advertised maximum upload rate - Mbps |
| fccdownraate |
Advertised maximum download rate - Mbps |
| fcclloop |
deprecated |
| fccvoip |
deprecated |
| fccwhsale |
deprecated |
| fccother |
deprecated |
| fccservice |
Value from List fccservice |
| a01 |
Asset Class for d01 |
| a02 |
not used |
| a03 |
Asset Class for d03 |
| a04 |
Asset Class for d04 |
| a05 |
Asset Class for d05 |
| a06 |
Asset Class for d06 |
| a07 |
Asset Class for d07 |
| a08 |
Asset Class for d08 |
| a09 |
Asset Class for d09 |
| a10 |
Asset Class for d10 |
| etfee |
Early Termination Fee |
| etfeetaxable |
- 1 - taxable
- 0 - not taxable
- -1 - not applicable
|
| feeselectgroup |
Selectable Fee Group (Recurring Service Fee) |
| county |
County(Recurring Service Fee) |
| changeclass |
Value from List "changeclasses" |
| notebilldetail |
Reference to Note table containing additional Billing Detail for Bill |
| technology |
Value from List "infrastructuretechs" |
| accountclass |
Value from List "accountclasses" |
| features |
Value from List "features" |
| excludetaxtype |
not used |
| feetype |
Fee Type(Recurring Service Fee) |
