Financial Transaction

Overview

A Financial Transaction is a monetary record in ORMB that represents an event impacting a customer account. It is the central object for financial processing and establishes the connection between service activities, customer accounts, and financial reporting.

A Financial Transaction subject area may represent a charge, adjustment, payment, or any other monetary event related to services. Each FT stores key attributes such as type, amount, status, date, and linked accounts. These attributes enable the system to process transactions, maintain account balances, and provide a reliable source for reconciliation and audit.

Conforming Layers

The Payment subject area has the following conforming layers:

FT_OBJ

Primary Key: FT_ID

Column Description Data Type Data Length
FT_ID Unique identifier assigned to each financial transaction in the system. VARCHAR 12
SIBLING_ID Identifier for other financial transactions that are part of the same group or category. VARCHAR 12
SA_ID Identifier for the service agreement under which the financial transaction was created. VARCHAR 10
PARENT_ID Identifier for the parent transaction or grouping to which the financial transaction belongs. VARCHAR 12
GL_DIVISION Division or organizational unit within the General Ledger (GL) of the financial transaction. VARCHAR 5
CIS_DIVISION Division within the Customer Information System (CIS) that is accountable for this transaction. VARCHAR 5
CURRENCY_CD ISO code for the currency in which this financial transaction is recorded. VARCHAR 3
FT_TYPE_FLG Type of financial transaction, such as a charge, credit, adjustment, or payment. VARCHAR 2
FT_CUR_AMT Current outstanding amount of the financial transaction. DECIMAL (15,2)
FT_TOT_AMT Total amount required to settle the financial transaction. DECIMAL (15,2)
CREATE_DTTM Date and time when the record was created in Talend. TIMESTAMP
FREEZE_SW Indicator whether the accrual is frozen. VARCHAR 1
FREEZE_USER_ID Identifier for the user or system that froze the transaction. VARCHAR 8
FREEZE_DTTM Date and time when the transaction was frozen. TIMESTAMP
ARS_DT Date used to determine whether the transaction is considered overdue or in arrears for payment. TIMESTAMP
CORRECTION_SW Indicator whether the financial transaction is a correction to a previously created transaction with errors. VARCHAR 1
REDUNDANT_SW Flag indicating whether the transaction is redundant and no longer active or relevant. VARCHAR 1
NEW_DEBIT_SW Indicator whether the transaction is a new debit or not. VARCHAR 1
SHOW_ON_BILL_SW Flag that determines whether this transaction will appear on the customer’s bill. Transactions hidden from the bill may still impact account balances. VARCHAR 1
NOT_IN_ARS_SW Indicator whether the transaction is excluded from arrears processing, meaning it does not contribute to overdue balances. VARCHAR 1
BILL_ID Identifier for a specific bill linked to the financial transaction. VARCHAR 12
ACCOUNTING_DT Date when the financial transaction is recognized for accounting purposes. TIMESTAMP
XFERRED_OUT_SW Indicator whether the financial transaction has been transferred out of its original system or process. VARCHAR 1
XFER_TO_GL_DT Date when the financial transaction was transferred to the General Ledger for financial reporting and reconciliation. TIMESTAMP
GL_DISTRIB_STATUS Distribution status of this transaction within the General Ledger system, such as pending, processed, or failed. VARCHAR 1
SCHED_DISTRIB_DT Future date when this transaction is scheduled to be distributed to the General Ledger. TIMESTAMP
BAL_CTL_GRP_ID Identifier for a specific balance control group used for reconciling account balances and validating financial accuracy. DECIMAL (10,0)
MATCH_EVT_ID Identifier for a match event linked to the financial transaction. VARCHAR 12
GL_SEQ_NBR Sequence number that identifies the order of General Ledger (GL) distribution lines associated with the financial transaction. DECIMAL (3,0)
DST_ID Code identifying the distribution or allocation rule applied to the financial transaction for accounting purposes. VARCHAR 10
GL_AMOUNT Monetary debit or credit value distributed to a GL account for used for reconciliation between the subledger and the General Ledger linked to the financial transaction. DECIMAL (15,2)
TOT_AMT_SW Indicator whether the distribution line represents the total amount for the transaction. If it is, all associated amounts will be consolidated. VARCHAR 1
GL_ACCT General Ledger account to which this distribution is posted. VARCHAR 254
STATISTIC_AMOUNT Non-monetary measure associated with this distribution, such as usage or count metrics. DECIMAL 36,18
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 Talend. TIMESTAMP
UPDATE_DTTM Date and time when the record was last updated in Talend. TIMESTAMP
COMPOSITE_KEY Unique identifier in the FT_ID || GL_SEQ_NBR format. VARCHAR 15

FT_PROC_OBJ

Column Description Data Type Data Length
FT_ID Unique identifier assigned to each financial transaction in the system. VARCHAR 12
SEQ_NUM Sequence number indicating the order of processing records related to the financial transaction. DECIMAL(3,0) (3,0)
BATCH_CD Code for the batch process or control group that processed the financial transaction. VARCHAR 8
BATCH_NBR Unique number identifying the specific batch to which this financial transaction belongs. DECIMAL(10,0) (10,0)
SPR_CD Code identifying the service provider or entity responsible for processing the transaction. VARCHAR 12
ADJ_ID Identifier linking the financial transaction to a specific adjustment, if applicable. VARCHAR 12
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 the FT_ID || SEQ_NBR format. VARCHAR 15