Payment
Overview
The Payment subject area encompasses various aspects of the payment lifecycle within the system. It includes the processes and data related to receiving, processing, and managing payments from customers or clients. The following are its core components:
- Payment Processing — Supports diverse payment methods (cash, checks, EFT, online) and batch processing for high-volume transactions.
- Payment Allocation — Automates invoice matching, handles partial/overpayments, and applies funds to charges based on utility-specific rules.
- Adjustments and Corrections: Resolves payment errors, disputes, or policy changes, and processes reversals/refunds.
- Reconciliation — Ensures system records align with bank deposits through daily/monthly reconciliation.
- Integration with Billing and Customer Care — Syncs payment data with billing systems, updates customer accounts, and communicates payment status and discrepancies.
Conforming Layers
The Payment subject area has the following conforming layers:
PAY_OBJ
| Column | Description | Data Type | Data Length |
|---|---|---|---|
| PAY_ID | Unique identifier for the payment record. | VARCHAR | 17 |
| PAY_EVENT_ID | Identifier for the payment event associated with this payment. | VARCHAR | 17 |
| CAN_RSN_CD | Code indicating the reason for payment cancellation. | VARCHAR | 6 |
| ACCT_ID | Identifier for the account associated with the payment. | VARCHAR | 14 |
| PAY_STATUS_FLG | Flag indicating the current status of the payment. | VARCHAR | 3 |
| MATCH_TYPE_CD | Code representing the type of match for the payment. | VARCHAR | 12 |
| MATCH_VAL | Value used to match the payment. | VARCHAR | 42 |
| PAY_SEG_ID | Unique identifier for the payment segment. | VARCHAR | 17 |
| CURRENCY_CD | ISO code for the currency in which the payment is recorded. | VARCHAR | 5 |
| SA_ID | Identifier for the service agreement associated with the payment segment. | VARCHAR | 14 |
| PAY_SEG_AMT | Amount distributed in the payment segment. | DECIMAL | (21,2) |
| MATCH_EVT_ID | Identifier for the match event associated with the payment segment. | VARCHAR | 17 |
| CDC_LOAD_DTTM | Date and time when the record was loaded into the system through the Change Data Capture (CDC) process. | TIMESTAMP | |
| CREATE_DTTM | Date and time when the record was created in the system. | TIMESTAMP | |
| UPDATE_DTTM | Date and time when the record was last updated. | TIMESTAMP | |
| COMPOSITE_KEY | Unique identifier in PAY_ID format. This is the primary key. |
VARCHAR | 17 |
| CDF1_CD CDF2_CD CDF3_CD CDF4_CD CDF5_CD CDF6_CD CDF7_CD CDF8_CD CDF9_CD CDF10_CD CDF11_CD CDF12_CD CDF13_CD CDF14_CD CDF15_CD |
Placeholders for future implementation of ORMB characteristics. | VARCHAR | 70 |
| CDF1_VAL CDF2_VAL CDF3_VAL CDF4_VAL CDF5_VAL CDF6_VAL CDF7_VAL CDF8_VAL CDF9_VAL CDF10_VAL CDF11_VAL CDF12_VAL CDF13_VAL CDF14_VAL CDF15_VAL |
Placeholders for values of future implementation of ORMB characteristics. | VARCHAR | 70 |
PAY_EXCP_OBJ
| Column | Description | Data Type | Data Length |
|---|---|---|---|
| PAY_ID | Unique identifier for the payment record. | VARCHAR | 17 |
| MSG_CAT_NBR | Specifies the message category number. | DECIMAL(7,0) | (7,0) |
| MSG_NBR | Specifies the message number. | DECIMAL(7,0) | (7,0) |
| PAY_EXCP_FLG | Flag indicating the type of payment exception. | VARCHAR | 3 |
| EXP_MSG | Message detailing the exception. | VARCHAR | 356 |
| CALL_SEQ | Sequence number of the calling program. | VARCHAR | 356 |
| USER_ID | Identifier for the user. | VARCHAR | 12 |
| REVIEW_COMP | Indicator of whether the exception has been reviewed. | VARCHAR | 2 |
| REVIEW_USER_ID | Identifier for the user who reviewed the exception. | VARCHAR | 12 |
| REVIEW_DT | Date when the exception was reviewed. | TIMESTAMP | |
| COMMENTS | Additional comments about the exception. | VARCHAR | 356 |
| CRE_DTTM | Date and time when the record was created. | TIMESTAMP | |
| CDC_LOAD_DTTM | Date and time when the record was loaded into the system through the Change Data Capture (CDC) process. | TIMESTAMP | |
| CREATE_DTTM | Date and time when the record was created in the system. | TIMESTAMP | |
| UPDATE_DTTM | Date and time when the record was last updated. | TIMESTAMP | |
| COMPOSITE_KEY | Unique identifier in PAY_ID format. This is the primary key. |
VARCHAR | 17 |
| MESSAGE_PARM1 MESSAGE_PARM2 MESSAGE_PARM3 MESSAGE_PARM4 MESSAGE_PARM5 MESSAGE_PARM6 MESSAGE_PARM7 MESSAGE_PARM8 MESSAGE_PARM9 |
Placeholder for future message parameters. | VARCHAR | 2800 |