Tender Control
Module: Customer Analytics
Type: Fact
TNDR_CTL_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| TNDR_CTL_ID | VARCHAR2 | 10 | True | Tender Control | |||
| SOURCE_RECORD_ID | VARCHAR2 | 10 | Source Record Id | ||||
| A1_TNDR_CTL_ARCHIVE_SW | VARCHAR2 | 38 | Archived Tenders | ||||
| ALL_OPERATORS_SW | VARCHAR2 | 1 | All Users | ||||
| BALANCED_DT | NUMBER | 38 | 0 | Balanced Date | |||
| BALANCED_TM | NUMBER | 38 | 0 | Balanced Time | |||
| BALANCED_USER_ID | VARCHAR2 | 38 | Balanced User | DW_EWB_X_EWDI_BASE_SC_USER_D | USER_ID | ||
| BATCH_CD | VARCHAR2 | 38 | Batch Control | DW_EWB_X_EWDI_BASE_CI_BATCH_CTRL_D | BATCH_CD | ||
| BATCH_NBR | NUMBER | 10 | 0 | Batch Number | |||
| COMMENTS | VARCHAR2 | 254 | Comments | ||||
| CRE_DT | NUMBER | 38 | 0 | Creation Date | |||
| CRE_TM | NUMBER | 38 | 0 | Creation Time | |||
| CURRENCY_CD | VARCHAR2 | 3 | Currency Code | DW_EWC_X_EWDI_CUST_CI_CURRENCY_CD_D | F1_BI_CURRENCY_CD | ||
| DEP_CTL_ID | VARCHAR2 | 10 | Deposit Control | DW_EWC_X_EWDI_CUST_CI_DEP_CTL_D | DEP_CTL_ID | ||
| END_BALANCE | NUMBER | 15 | 2 | Ending Balance | |||
| EXT_TRANSMIT_ID | VARCHAR2 | 50 | External Transmission ID | ||||
| START_BALANCE | NUMBER | 15 | 2 | Starting Balance | |||
| TNDR_CTL_ST_FLG | VARCHAR2 | 2 | Status | ||||
| TNDR_SOURCE_CD | VARCHAR2 | 8 | Tender Source | DW_EWC_X_EWDI_CUST_CI_TNDR_SRCE_D | TNDR_SOURCE_CD | ||
| USER_ID | VARCHAR2 | 38 | User | DW_EWB_X_EWDI_BASE_SC_USER_D | USER_ID | ||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |