FCM_TRAVEL_SEGMENT

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SEQ_FCM_FILES_REC_ID INTEGER 4
2 ROW_STATUS CHARACTER VARYING(1) 1
3 COMPANY_CODE CHARACTER VARYING(10) 10
4 COMPANY_NAME CHARACTER VARYING(60) 60
5 BOOKING_ID INTEGER 4
6 SEGMENT_ID INTEGER 4
7 SEGMENT_TYPE CHARACTER VARYING(20) 20
8 SEGMENT_HISTORY_STATUS CHARACTER VARYING(1) 1
9 SEGMENT_STATUS CHARACTER VARYING(3) 3
10 PROVIDER_CODE CHARACTER VARYING(10) 10
11 PROVIDER_NAME CHARACTER VARYING(60) 60
12 PROVIDER_PREFERRED CHARACTER VARYING(1) 1
13 CLASS_CODE CHARACTER VARYING(5) 5
14 CLASS_NAME CHARACTER VARYING(30) 30
15 SERVICE_CODE CHARACTER VARYING(10) 10
16 SERVICE_DESCRIPTION CHARACTER VARYING(30) 30
17 NO_ROOMS_CARS INTEGER 4
18 FLIGHT_NUMBER CHARACTER VARYING(5) 5
19 FIRST_LOCATION CHARACTER VARYING(10) 10
20 FINAL_LOCATION CHARACTER VARYING(10) 10
21 FIRST_DATE TIMESTAMP 8
22 FINAL_DATE TIMESTAMP 8
23 SOLD_TOTAL_FARE DOUBLE PRECISION 8
24 SOLD_BASE_FARE DOUBLE PRECISION 8
25 SOLD_TOTAL_TAXES DOUBLE PRECISION 8
26 SOLD_TOTAL_GST DOUBLE PRECISION 8
27 SOLD_FARE_BASIS_CODE CHARACTER VARYING(10) 10
28 BEST_FARE_PRICE DOUBLE PRECISION 8
29 BEST_FARE_CLASS CHARACTER VARYING(5) 5
30 BEST_FARE_BASIS CHARACTER VARYING(10) 10
31 BEST_FARE_AIRLINE_CODE CHARACTER VARYING(5) 5
32 BEST_FARE_DEPART TIMESTAMP 8
33 BEST_FARE_ARRIVE TIMESTAMP 8
34 LOWEST_FARE_PRICE DOUBLE PRECISION 8
35 LOWEST_FARE_CLASS CHARACTER VARYING(5) 5
36 LOWEST_FARE_BASIS CHARACTER VARYING(10) 10
37 LOWEST_FARE_AIRLINE_CODE CHARACTER VARYING(5) 5
38 LOWEST_FARE_DEPART TIMESTAMP 8
39 LOWEST_FARE_ARRIVE TIMESTAMP 8
40 BENCHMARK DOUBLE PRECISION 8
41 REASON_FOR_NOT_CHOOSING_BEST_FARE_CODE CHARACTER VARYING(10) 10
42 REASON_FOR_NOT_CHOOSING_BEST_FARE_DESC CHARACTER VARYING(60) 60
43 IN_POLICY_OPTION_AVAILABLE CHARACTER VARYING(1) 1
44 SOLD_RATE_VALUE DOUBLE PRECISION 8
45 SEGMENT_RATE_BASIS CHARACTER VARYING(3) 3
46 GST_INCLUSIVE CHARACTER VARYING(1) 1
47 SOLD_RATE_TAX DOUBLE PRECISION 8
48 GST_RATE DOUBLE PRECISION 8
49 BROD_RATE DOUBLE PRECISION 8
50 BROD_RATE_TYPE CHARACTER VARYING(3) 3
51 SEGMENT_REFERENCE CHARACTER VARYING(30) 30
52 SEGMENT_RATE_CURRENCY CHARACTER VARYING(3) 3
53 FARE_FAMILY_NAME CHARACTER VARYING(50) 50
54 CRS_CODE CHARACTER VARYING(3) 3
55 FLIGHT_HOURS INTEGER 4
56 FLIGHT_MINUTES INTEGER 4
57 FLIGHT_VIA CHARACTER VARYING(30) 30
58 FLIGHT_STOPS SMALLINT 2
59 EQUIPMENT_CODE CHARACTER VARYING(30) 30
60 FLIGHT_CODESHARE CHARACTER VARYING(5) 5
61 SEGMENT_LINE INTEGER 4
62 CREATED_STAMP TIMESTAMP 8
63 UPDATED_STAMP TIMESTAMP 8
64 EFFECTIVE_STRT_DT TIMESTAMP 8
65 EFFECTIVE_END_DT TIMESTAMP 8
66 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
67 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
68 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
69 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8