BILLINGSUMMARY
The BILLINGSUMMARY table represents a summary bill for a CONTRACT or a CONTRACTCOMPONENT.
This table is used by the following domains.
| Name | Comment | Datatype | Null Option | Is PK |
|---|---|---|---|---|
| BILLING_SUMMARY_ID | A unique, system-generated key that identifies a billing summary in the system. | BIGINT | Not Null | Yes |
| BILLING_ST_TP_CD | A unique type code which uniquely defines a billing status value. For example, closed, paid, and so forth. | BIGINT | Not Null | No |
| PYMT_MTHD_TP_CD | A type code which uniquely identifies a payment method value in the system. This represents the next payment method type. Some examples are bank account, charge card, cash, and so forth. | BIGINT | Null | No |
| LAST_PY_MD_TP_CD | A type code which uniquely identifies a payment method value in the system. This represents the last payment method type. Some examples are bank account, charge card, cash, and so forth. | BIGINT | Null | No |
| EFFECTIVE_DATE | The date from which this billing summary is effective. | TIMESTAMP | Null | No |
| DUE_DATE | The due date for this billing summary. | TIMESTAMP | Null | No |
| ACCOUNT_BALANCE | The total outstanding balance. | DECIMAL(17,3) | Not Null | No |
| MIN_PAYMENT | The minimum payment required for this billing summary. | DECIMAL(17,3) | Null | No |
| MAX_PAYMENT | The maximum payment allowed for this billing summary. | DECIMAL(17,3) | Null | No |
| PAID_TO_DATE | The date up to which the account or contract has been paid. | TIMESTAMP | Null | No |
| INVOICE_ID | Links this billing summary to an invoice; external to the system. | VARCHAR(50) | Null | No |
| BILL_FROM_DATE | The start date of the billing period of this billing summary. | TIMESTAMP | Null | No |
| BILL_TO_DATE | The end date of the billing period of this billing summary. | TIMESTAMP | Null | No |
| ACCOUNT_ID | An account ID is a free form specific means by which the account can be distinguished from all other accounts. | VARCHAR(50) | Null | No |
| PAYMENT_SOURCE_ID | A unique, system-generated key that identifies a payment source in the system. | BIGINT | Null | No |
| WITHDRAWAL_DATE | The date on which payment will be withdrawn from a payment source for this billing summary. | TIMESTAMP | Null | No |
| LAST_PAYMENT_AMT | The amount paid or withdrawn against the last billing summary. | DECIMAL(17,3) | Null | No |
| LAST_PAYMENT_DT | The date when payment was last received. | TIMESTAMP | Null | No |
| PAYMENTS_REMAINING | The number of payments remaining. | INTEGER | Null | No |
| LAST_UPDATE_DT | When a record is added or updated, this field is updated with the date and time. On subsequent updates, the system uses this information to ensure that the update request includes a matching date and time on this field; if it does not, the update fails. | TIMESTAMP | Not Null | No |
| LAST_UPDATE_USER | The ID of the user who last updated the data. | VARCHAR(20) | Null | No |
| LAST_UPDATE_TX_ID | A unique, system-generated key that identifies the specific transaction within the log system that either created, updated, or deleted the data row. | BIGINT | Null | No |
| FREQ_MODE_TP_CD | The frequency of the payments made on the contract. For example, monthly or annual. | BIGINT | Null | No |
| CONTRACT_ID | A unique, system-generated key that identifies a contract in the system. | BIGINT | Null | No |
| CONTR_COMPONENT_ID | A unique, system-generated key that identifies a contract component in the system. | BIGINT | Null | No |
| ACCBALA_CUR_TP | The currency type for the account balance. | BIGINT | Null | No |
| MINPAYM_CUR_TP | The currency type for the minimum payment. | BIGINT | Null | No |
| MAXPAYM_CUR_TP | The currency type for the maximum payment. | BIGINT | Null | No |
| LASTPAY_CUR_TP | The currency type for the last payment. | BIGINT | Null | No |