FCM_COSTING

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 COSTING_UNIQUE INTEGER 4
7 COSTING_STATUS CHARACTER VARYING(3) 3
8 COSTING_NTS_FLAG CHARACTER VARYING(1) 1
9 COSTING_TRAVEL_TYPE CHARACTER VARYING(4) 4
10 COSTING_TRAVEL_TYPE_DESCRIPTION CHARACTER VARYING(30) 30
11 COSTING_CHARGEABLE_FLAG CHARACTER VARYING(1) 1
12 COSTING_SERVICE_RATE_LOCAL DOUBLE PRECISION 8
13 COSTING_RATE_BASIS CHARACTER VARYING(10) 10
14 PUBLISHED_FARE DOUBLE PRECISION 8
15 BEST_FARE DOUBLE PRECISION 8
16 SERVICE_SELL_LOCAL DOUBLE PRECISION 8
17 COSTING_EXTRAS_LOCAL DOUBLE PRECISION 8
18 COSTING_FARE_CHARGED DOUBLE PRECISION 8
19 GST_LOCAL DOUBLE PRECISION 8
20 TICKET_CC_FEE DOUBLE PRECISION 8
21 CURRENCY_CODE CHARACTER VARYING(3) 3
22 CCCF_CREDIT_CARD_TYPE CHARACTER VARYING(3) 3
23 CCCF_CREDIT_CARD_NUMBER CHARACTER VARYING(24) 24
24 AIRLINE_NUMBER CHARACTER VARYING(5) 5
25 COSTING_TICKET_NUMBER CHARACTER VARYING(20) 20
26 COSTING_TICKET_ORIGINAL CHARACTER VARYING(20) 20
27 COSTING_DEAL_CODE CHARACTER VARYING(15) 15
28 SUPPLIER_ACCOUNT_CODE CHARACTER VARYING(10) 10
29 SUPPLIER_ACCOUNT_NAME CHARACTER VARYING(60) 60
30 COSTING_COST_CENTRE_CODE CHARACTER VARYING(20) 20
31 COSTING_COST_CENTRE_GROUP_CODE CHARACTER VARYING(20) 20
32 COSTING_COST_CENTRE_CATEGORY CHARACTER VARYING(20) 20
33 REASON_FOR_NOT_CHOOSING_BEST_FARE_CODE CHARACTER VARYING(10) 10
34 REASON_FOR_NOT_CHOOSING_BEST_FARE_DESC CHARACTER VARYING(60) 60
35 CREATED_STAMP TIMESTAMP 8
36 UPDATED_STAMP TIMESTAMP 8
37 EFFECTIVE_STRT_DT TIMESTAMP 8
38 EFFECTIVE_END_DT TIMESTAMP 8
39 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
40 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
41 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
42 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8