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 |
|
| 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. |
|
|
|
