FCM_IATA_CITY_PAIR

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SEQ_FCM_FILES_REC_ID INTEGER 4
2 IATA_CITY_FROM CHARACTER VARYING(10) 10
3 IATA_CITY_TO CHARACTER VARYING(10) 10
4 CUMULATIVE INTEGER 4
5 DELTA_TYPE CHARACTER VARYING(1) 1
6 EFFECTIVE_STRT_DT TIMESTAMP 8
7 EFFECTIVE_END_DT TIMESTAMP 8
8 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
9 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
10 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
11 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8