Tender Control

Overview

The Tender Control subject area manages customer payment transactions within the system. It defines the control record for each tender, capturing information such as the payment amount, tender source, currency, and status. Each tender record tracks its lifecycle, including creation, posting, cancellation, or reversal, and enforces business rules to ensure proper handling of payments.

This subject area provides the structure for recording, validating, and reconciling tenders against bills and customer accounts. It also maintains audit information such as user actions and timestamps, supporting traceability and compliance with financial policies.

Conforming Layers

The conforming layers of this subject area are the following:

TNDR_CTL_OBJ

Column Description Data Type Data Length
TNDR_CTL_ID Unique identifier for the tender control record. VARCHAR 10
CURRENCY_CD ISO code for the currency in which the tender is recorded. VARCHAR 3
TNDR_SOURCE_CD Code identifying the tender source linked to this control record. VARCHAR 8
TNDR_CTL_ST_FLG Status flag that represents the current state of the tender control. VARCHAR 2
USER_ID Identifier for the user responsible for the tender control record. VARCHAR 8
CRE_DTTM Timestamp when the record was created. TIMESTAMP
DEP_CTL_ID Identifier referencing the related deposit control. VARCHAR 10
BALANCED_USER_ID Identifier for the user who balanced the tender control. VARCHAR 8
BALANCED_DTTM Timestamp when the tender control was balanced. TIMESTAMP
START_BALANCE Amount recorded as the starting balance for the tender control. DECIMAL(15,2) 15,2
END_BALANCE Amount recorded as the ending balance for the tender control. DECIMAL(15,2) 15,2
ALL_OPERATORS_SW Switch indicating whether all operators are included under this control. VARCHAR 1
ARCHIVE_SW Switch specifying if the tender control record is archived. VARCHAR 1
BATCH_CD Code representing the batch linked with the tender control. VARCHAR 8
BATCH_NBR Number identifying the batch associated with the tender control. DECIMAL(10,0) 10
EXT_TRANSMIT_ID External transmission identifier used for integration or reporting. VARCHAR 30
CDC_FLAG Type of data change captured in the record during the Change Data Capture (CDC) process. VARCHAR 1
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 TNDR_CTL_ID format. This is the primary key. VARCHAR 10
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

TNDR_END_BAL_OBJ

Column Description Data Type Data Length
TNDR_CTL_ID Unique identifier linking the tender control record to its associated ending balance entry. VARCHAR 10
TENDER_TYPE_CD Code representing the specific tender type for which the balance is maintained. VARCHAR 4
ENDING_AMT Amount recorded as the final balance for the given tender type and control ID. DECIMAL(15,2) 15,2
CDC_FLAG Indicates whether the record is marked for change data capture. VARCHAR 1
CDC_LOAD_DTTM Timestamp when the record was captured through CDC processing. TIMESTAMP
CREATE_DTTM Timestamp when the record was initially created in the system. TIMESTAMP
UPDATE_DTTM Timestamp when the record was last updated in the system. TIMESTAMP
COMPOSITE_KEY Unique identifier in TNDR_CTL_ID || TENDER_TYPE_CD format. This is the primary key. VARCHAR 14