Filter
Top Products
B-4 Oracle Telecommunications Billing Integrator Implementation Guide
Specifications for BILL_SUMMARIES_REC
Attribute Name Data Type Description
Mandatory attributes
account_number VARCHAR2(30) Account Number of the
customer that must exist in
Oracle E-Business Suite. This
field is mandatory for insert
record.
The foreign key is
hz_cust_accounts.account_nu
mber.
bill_number VARCHAR2(30) Bill reference number. This
field is for insert and update
record and must be unique.
billing_vendor_name VARCHAR2 (240) Name of the billing vendor.
bill_cycle_end_date DATE Billing cycle contains an end
date of the cycle. This is
required for insert API only
(not for update API).
Optional Attributes - -
total_amount_due VARCHAR2 (30) Total amount due for all open
bills.
adjustments VARCHAR2 (30) Unapplied adjustments or
payments up to this bill cycle.
unresolved_disputes VARCHAR2 (30) Total amount of open
disputes.
bill_cycle_start_date DATE Start date of the billing cycle.
due_date DATE Timestamp indicating when
the bill is due.
new_charges VARCHAR2 (30) New charges for this bill.