usm_billing_group

Defines a billing group, billing group is a grouping of billing_accounts to achieve a billing related task, such as bill run, batch invoice printing etc

Column Name Column Datatype Column Null Option Column Comment
group_id integer not null Unique id assigned to the group.
domain varchar(50) not null The domain to which the group belongs.
time_zone_code varchar(64) not null Timezone shared by all associated accounts.
report_data_id varchar(128) with null Unique identifier for the report data object. The unique identifier is assigned when the report data is saved.
name nvarchar(64) with null Display name for the group.
type integer1 with null 0=account lists are statically generated. 1=account lists are dynamically generated.
automatic_invoicing integer1 with null 0=inactive 1=active
billing_cycle nvarchar(50) with null The billing cycle shared by all associated accounts.
billing_cycle_interval integer with null The interval between cycles.
last_invoice_date date with null The period start date.
billing_cycle_date date with null The period end date.
bill_date date with null Bill run date.
days_due_default integer with null Default days due for associated accounts.
comment nvarchar(128) with null Text area for description.

Product Name: Unicenter Service Management

Table Type: Table

Relationships:

Primary Key Related Table Related Column
group_id usm_link_billing_account_group group_id


Copyright © 2006 CA. All rights reserved.