FCT_TRVL_V

Database

INSNZP01_R12

Schema

R12PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 COMPANY_CODE CHARACTER VARYING(10) 10
2 BOOKING_ID INTEGER 4
3 SEGMENT_ID INTEGER 4
4 COSTING_UNIQUE INTEGER 4
5 NTS_FLAG CHARACTER VARYING(1) 1
6 SEGMENT_TYPE_FLAG CHARACTER VARYING(20) 20
7 SEGMENT_HISTORY_STATUS_FLAG CHARACTER VARYING(1) 1
8 SEGMENT_STATUS_FLAG CHARACTER VARYING(3) 3
9 PROVIDER_CODE CHARACTER VARYING(10) 10
10 PROVIDER_NAME CHARACTER VARYING(60) 60
11 PROVIDER_PREFERRED CHARACTER VARYING(1) 1
12 CLASS_CODE CHARACTER VARYING(5) 5
13 CLASS_NAME CHARACTER VARYING(30) 30
14 GROUPED_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_CODE CHARACTER VARYING(10) 10
20 FINAL_LOCATION_CODE CHARACTER VARYING(10) 10
21 FIRST_DATE_DATETIME TIMESTAMP 8
22 TRAVEL_DATE_DATETIME TIMESTAMP 8
23 FINAL_DATE_DATETIME TIMESTAMP 8
24 REASON_CODE CHARACTER VARYING(10) 10
25 REASON_DESC CHARACTER VARYING(60) 60
26 COSTING_SERVICE_RATE_LOCAL_AMOUNT DOUBLE PRECISION 8
27 SERVICE_SELL_LOCAL_AMOUNT DOUBLE PRECISION 8
28 COSTING_EXTRAS_LOCAL_AMOUNT DOUBLE PRECISION 8
29 COSTING_FARE_CHARGED_AMOUNT DOUBLE PRECISION 8
30 TICKET_CC_FEE_AMOUNT DOUBLE PRECISION 8
31 IN_POLICY_OPTION_AVAILABLE_FLAG CHARACTER VARYING(1) 1
32 SEGMENT_RATE_CURRENCY_CODE CHARACTER VARYING(3) 3
33 FLIGHT_HOURS INTEGER 4
34 CREATED_TIMESTAMP TIMESTAMP 8
35 UPDATED_TIMESTAMP TIMESTAMP 8
36 NTS_SERVICE_CODE CHARACTER VARYING(15) 15
37 FEE_TYPE_NAME_CALCULATED CHARACTER VARYING(100) 100
38 FEE_TYPE_NAME CHARACTER VARYING(100) 100
39 NTS_COMMENT CHARACTER VARYING(70) 70
40 NTS_SELL_AMOUNT DOUBLE PRECISION 8
41 REASON_SUBCODE CHARACTER VARYING(3) 3
42 BOOKING_TYPE CHARACTER VARYING(20) 20
43 ORDERED_METHOD CHARACTER VARYING(15) 15
44 BOOKING_DATE DATE 4
45 BOOKING_INT_FLAG CHARACTER VARYING(1) 1
46 BOOKING_EX_STATUS CHARACTER VARYING(20) 20
47 APPROVING_MANAGERS_NAME CHARACTER VARYING(60) 60
48 SEGMENT_TYPE_DESC CHARACTER VARYING(33) 33
49 QANTAS_MONOPOLY_FLAG CHARACTER VARYING(1) 1
50 EVENT_NAME CHARACTER VARYING(43) 43
51 SPECIAL_DATES_CITY_CODE CHARACTER VARYING(3) 3
52 CORP_RATE NUMERIC(6,1) 19
53 COST_AMOUNT DOUBLE PRECISION 8
54 MILEAGE NUMERIC(38,0) 19
55 CUMULATIVE_DISTANCE INTEGER 4
56 DIST_RATIO DOUBLE PRECISION 8
57 PROFILE_UNIQUE INTEGER 4
58 PROFILE_NAME CHARACTER VARYING(43) 43
59 U_NUMBER CHARACTER VARYING(55) 55
60 PROFILE_UNIQUE_NUMBER BIGINT 8
61 PROFILE_SEX CHARACTER(1) 1
62 PROFILE_VIP CHARACTER VARYING(6) 6
63 TERMINATED_FLAG CHARACTER VARYING(10) 10
64 LEADER_PROFILE_DESCRIPTION CHARACTER VARYING(128) 128
65 ORGANISATIONAL_UNIT_ID BIGINT 8
66 ORGANISATIONAL_UNIT_LEVEL_NAME CHARACTER VARYING(100) 100
67 BUSINESS_UNIT_CODE CHARACTER VARYING(100) 100
68 BUSINESS_UNIT_NAME CHARACTER VARYING(100) 100
69 DIVISION_CODE CHARACTER VARYING(100) 100
70 DIVISION_NAME CHARACTER VARYING(100) 100
71 DEPARTMENT_CODE CHARACTER VARYING(100) 100
72 DEPARTMENT_NAME CHARACTER VARYING(100) 100
73 SECTION_CODE CHARACTER VARYING(100) 100
74 SECTION_NAME CHARACTER VARYING(100) 100
75 TEAM_CODE CHARACTER VARYING(100) 100
76 TEAM_NAME CHARACTER VARYING(100) 100
77 DEPARTMENT_COST_CENTRE CHARACTER VARYING(100) 100
78 FLIGHT_COUNT INTEGER 4
79 NIGHT_COUNT BIGINT 8
80 ITEM_COUNT BIGINT 8
81 BOOKED_DAYS_IN_ADVANCE BIGINT 8
82 LATE_BOOKING_FLAG CHARACTER VARYING(1) 1
83 QF_MONOPOLY_ROUTE_FLAG CHARACTER VARYING(1) 1
84 PREFERRED_AIRLINE_FLAG CHARACTER VARYING(1) 1
85 BEST_FARE_FLAG CHARACTER VARYING(1) 1
86 OUT_OF_POLICY_CLASS_FLAG CHARACTER VARYING(1) 1
87 NIGHTLY_RATE_CALC DOUBLE PRECISION 8
88 ABOVE_300_RATE_FLAG CHARACTER VARYING(1) 1
89 ABOVE_CORP_RATE_FLAG CHARACTER VARYING(1) 1
90 ACCOMMODATION_POLICY_COMPLIANCE CHARACTER VARYING(27) 27
91 SPECIAL_DATE_TRAVEL_FLAG CHARACTER VARYING(1) 1
92 WEEKEND_TRAVEL_FLAG CHARACTER VARYING(1) 1
93 TOTAL_COST DOUBLE PRECISION 8
94 MILEAGE_RATIO DOUBLE PRECISION 8
95 COST_PER_TRIP DOUBLE PRECISION 8
96 FCM_HR_UNUMBER_MATCH CHARACTER VARYING(48) 48
97 FCM_HR_NAME_MATCH CHARACTER VARYING(16) 16
98 FCM_EMP_CODE CHARACTER VARYING(20) 20
99 UNUMBER_MATCH_CNT BIGINT 8
100 POSSIBLE_UNUMBERS CHARACTER VARYING(593) 593
101 HR_EMP_NAME CHARACTER VARYING(201) 201
102 HR_EMP_NAME_PREF CHARACTER VARYING(201) 201