Tender Source
Overview
The Tender Source subject area manages the origin of customer payments. It defines the payment methods or channels used to settle bills, such as cash, credit card, bank transfer, mobile payment, or automated external payments. Each tender source is configured in the system and linked to transactions to ensure that payments are processed according to predefined rules.
The Tender Source subject area supports the full payment lifecycle by capturing payment details, validating entries, and applying reconciliation and posting logic. It also enables tracking and reporting of payments by source, allowing integration with financial systems and ensuring alignment with accounting requirements.
Conforming Layers
The only conforming layer of this subject area is TNDR_SRC_OBJ.
TNDR_SRC_OBJ
| Column | Description | Data Type | Data Length |
|---|---|---|---|
| TNDR_SOURCE_CD | Unique identifier for the tender source. | VARCHAR | 8 |
| DESCR | Descriptive name of the tender source. | VARCHAR | 60 |
| TNDR_SRCE_TYPE_FLG | Flag specifying the type category of the tender source. | VARCHAR | 4 |
| SA_ID | Unique identifier for the service agreement linked to a tender source. | VARCHAR | 10 |
| CURRENCY_CD | ISO code for the currency in which the tender is recorded. | VARCHAR | 3 |
| EXT_SOURCE_ID | Identifier from an external system associated with the tender source. It is used to map internal tender sources with external references such as bank systems. | VARCHAR | 30 |
| BANK_ACCT_KEY | Bank account key tied to the tender source. | VARCHAR | 4 |
| BANK_CD | Bank code related to the tender source. It helps the system recognize which bank the tender belongs to. | VARCHAR | 5 | CDC_FLAG | Flag specifying the type of data change captured in the record during the Change Data Capture (CDC) process. | VARCHAR | 1 |
| CDC_LOAD_DTTM | Timestamp when the record was loaded into the data warehouse. | 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 TNDR_SRC_CD format. This is the primary key. |
VARCHAR | 8 |