Deposit Tender Control

Overview

The Deposit Tender Control subject area is used to track and manage tender deposits collected from customers. It records information about the tender type, deposit amount, deposit date, and the customer or account it is associated with. It also links the initial deposit with subsequent financial activities, such as applying the deposit against bills, refunds, or adjustments.

Conforming Layers

The only conforming layer of this subject area is DEP_TNDR_CTL_STG_OBJ.

DEP_TNDR_CTL_STG_OBJ

Column Source Column Descriptions Data Type Data Length
EXT_SOURCE_ID Identifier for the external system or source from which the deposit control data originates. VARCHAR 30
EXT_TRANSMIT_ID Unique identifier for each transmission of deposit control data from an external system. VARCHAR 30
EXT_BATCH_ID Unique identifier for the batch assigned to the tender control records by the external system. VARCHAR 30
DEP_CTL_STG_ST_FLG Status of the deposit control record. VARCHAR 2
DEP_CTL_ID Unique identifier for the deposit control record that will be created once the staged data is validated and successfully processed. VARCHAR 10
TRANSMIT_DTTM Date and time when the deposit control data was transmitted from the external source to ORMB. TIMESTAMP
CURRENCY_CD ISO code for the currency in which the deposit control transaction is recorded. VARCHAR 3
TNDR_CTL_ID Unique identifier for the tender control record. VARCHAR 10
TND_CTL_STG_ST_FLG Status of the tender control record. VARCHAR 2
TOT_TNDR_CTL_AMT Total amount of all tender controls associated with the deposit control record. DECIMAL (15,2)
TOT_TNDR_CTL_CNT Count of individual tender control records linked to a deposit control record. DECIMAL (10,0)
TOT_TNDR_AMT Total monetary value of all tenders included in the batch. DECIMAL (15,2)
TOT_TNDR_CNT Total count of individual tender transactions, such as cash, checks, or electronic payments, included in the batch. DECIMAL (10,0)
LAST_UPDATE_INST Date and time of the last update made to the deposit control record. DECIMAL (10,0)
CDC_LOAD_DTTM Date and time when the record was loaded into the system through the Change Data Capture (CDC) process. TIMESTAMP
CDC_FLAG Type of data change captured in the record during the Change Data Capture (CDC) process. VARCHAR 1
COMPOSITE_KEY
 Unique identifier in EXT_SOURCE_ID|EXT_TRANSMIT_ID|EXT_BATCH_ID format. This is the primary key. VARCHAR 30
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