DW_EWC_X_EWDI_CUST_CI_TNDR_CTL_D

Details

Module: Customer Analytics

Type: Dimension

Key Columns

TNDR_CTL_ID

Columns

Columns
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_DTTM TIMESTAMP 0 6 Balanced Date/Time
BATCH_NBR NUMBER 10 0 Batch Number
COMMENTS VARCHAR2 254 Comments
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
W$_INSERT_DT TIMESTAMP 0 6
W$_UPDATE_DT TIMESTAMP 0 6