테스트제목

테이블 (4)

PNR_COMMON_DATA

  • PCD_ID — NUMBER — 기본 키 — NOT NULL — 시퀀스
  • PCD_MASTER_YN — CHAR — MASTER
  • PCD_TRL_HREV_CODE — CHAR — NOT NULL — H예약코드
  • PCD_SS_CODE — VARCHAR2 — NOT NULL — 판매사이트코드
  • PCD_HANA_SS_CODE — VARCHAR2 — 하나투어
  • PCD_PKG_TYPE — CHAR — NOT NULL — 예약속성
  • PCD_SVC_TYPE — CHAR — 서비스
  • PCD_RV_IND — CHAR — NOT NULL — 인벤토리
  • PCD_PASSAVE_IND — CHAR — 패시브
  • PCD_DOM_IND — CHAR — 국내선
  • PCD_INH_ID — VARCHAR2 — 공급
  • PCD_INV_L_FARE_ID — NUMBER — 인벤토리
  • PCD_REV_CRE_SRC — CHAR — NOT NULL — 예약생성방법
  • PCD_FAREQQ_KEY — NUMBER — 요금문의로
  • PCD_REV_FARE_TYPE — CHAR — NOT NULL — 사용운임종류(C:공통MSP
  • PCD_BPGI_ID — NUMBER — 출장요청인경우
  • PCD_BZ_KIND — CHAR — 출장타입
  • PCD_INCENTIVE_L_FARE_ID — NUMBER — 인센티브예약일
  • PCD_PATTERN_ID — VARCHAR2 — 패턴정보
  • PCD_SKD_CHANGE_IND — CHAR — 스케줄변경
  • PCD_CU_NATY — CHAR — 예약자
  • PCD_CUS_TYPE — CHAR — NOT NULL — 예약고객구분
  • PCD_NON_MBR — CHAR — 비회원예약인지여부
  • PCD_CU_ID — VARCHAR2 — 예약자ID
  • PCD_CU_LCL_NAME — VARCHAR2 — 예약자이름
  • PCD_CU_LCL_ID — VARCHAR2 — 예약자
  • PCD_CU_SEQ — VARCHAR2 — 예약자
  • PCD_REV_CU_GRADE — VARCHAR2 — 예약자회원등급
  • PCD_PHONE_HOME — VARCHAR2 — 예약자
  • PCD_PHONE_OFFICE — VARCHAR2 — 예약자
  • PCD_MOBILE — VARCHAR2 — 예약자
  • PCD_EMAIL_CTC1 — VARCHAR2 — 예약자
  • PCD_AUTH_IND — CHAR — AUTH
  • PCD_AUTH_STATUS — CHAR — AUTH신청상태
  • PCD_AUTH_REQ_DATE — DATE — AUTH
  • PCD_AUTH_REQ_ID — VARCHAR2 — AUTH신청자
  • PCD_AUTH_NO — VARCHAR2 — AUTH
  • PCD_1ST_SEG_MK_CAR_FLT_NO — VARCHAR2
  • PCD_CRS_PNR1_LOC — CHAR — CRS
  • PCD_CRS_PNR1_ADDR — VARCHAR2 — CRS
  • PCD_CRS_PNR2_LOC — CHAR — CRS
  • PCD_CRS_PNR2_ADDR — VARCHAR2 — CRS
  • PCD_CRS_PNR3_LOC — CHAR — CRS
  • PCD_CRS_PNR3_ADDR — VARCHAR2 — CRS
  • PCD_CRE_TIME — DATE — NOT NULL — 예약일시
  • PCD_TRIP_TYPE — CHAR — 여정타입
  • PCD_TKT_CAR — VARCHAR2 — Ticketing
  • PCD_TKT_DEP — CHAR — Ticketing
  • PCD_TKT_ARR — CHAR — Ticketing
  • PCD_DEP_DATE — CHAR — 출발일
  • PCD_RET_DATE — VARCHAR2 — 리턴일
  • PCD_VALIDITY — VARCHAR2 — 항공권유효기간
  • PCD_COMPARTMENT — CHAR — 좌석등급
  • PCD_ITINERARY — VARCHAR2 — 여정요약
  • PCD_TKTG_TYPE — VARCHAR2 — 공급사의
  • PCD_CURRENCY_LCL — CHAR — NOT NULL — 로컬
  • PCD_CURRENCY_ORG — CHAR — NOT NULL — 공급
  • PCD_CURRENCY_RATE — NUMBER — NOT NULL — 예약
  • PCD_TKT_TIME_LIMIT_DATE — CHAR — 고객결제시한(날짜)
  • PCD_TKT_TIME_LIMIT_TIME — CHAR — 고객결제시한(시간)
  • … +129

PNR_CRE_LOG

  • PCL_ID — NUMBER — NOT NULL
  • PCL_PSL_ID — NUMBER — NOT NULL
  • PCL_QUERY — VARCHAR2
  • PCL_PNR_ADDR — VARCHAR2
  • PCL_RESPONSE — VARCHAR2
  • PCL_LAST_DATE — DATE

PNR_FARE_DATA

  • PFD_ID — NUMBER — NOT NULL — 시퀀스ID
  • PFD_PND_ID — NUMBER — NOT NULL — PND
  • PFD_PCD_ID — NUMBER
  • PFD_H_CODE — VARCHAR2 — NOT NULL — H_CODE
  • PFD_S_AGT_CODE — VARCHAR2 — 공급사
  • PFD_L_AGT_CODE — VARCHAR2 — 판매사
  • PFD_IDT_CODE — VARCHAR2 — NOT NULL — 운임조건
  • PFD_REV_FARE_TYPE — CHAR — 사용운임종류(C:공통MSP
  • PFD_AUTH_REQ_IND — CHAR — AUTH
  • PFD_MANUAL_ADD_IND — CHAR — 관리자
  • PFD_PUB_FARE — NUMBER — 성인
  • PFD_MSP_FARE — NUMBER — 성인
  • PFD_SALES_FARE — NUMBER — NOT NULL — 공급사
  • PFD_FARE_APPLY_RATE — NUMBER — NOT NULL — SALES
  • PFD_HIDDEN_SALES_FARE — NUMBER — 히든판매가
  • PFD_COMM_STD — CHAR — NOT NULL — 원천
  • PFD_COMM_RATE — NUMBER — 원천
  • PFD_COMM_AMOUNT — NUMBER — 원천
  • PFD_TAX — NUMBER — Tax
  • PFD_Q — NUMBER — Q
  • PFD_SL_COMM_STD — CHAR — NOT NULL — 공급사
  • PFD_SL_COMM_RATE — NUMBER — 공급사
  • PFD_SL_COMM_AMOUNT — NUMBER — 공급사
  • PFD_SL_AMOUNT — NUMBER — 공급사
  • PFD_SL_AMOUNT_NET — NUMBER — 공급사
  • PFD_L_MKUP_STD — CHAR — NOT NULL — 판매사L1
  • PFD_L_MKUP_RATE — NUMBER — 판매사L1
  • PFD_L_MKUP_AMOUNT — NUMBER — 판매사L1
  • PFD_LM_COMM_STD — CHAR — NOT NULL — 판매사L1
  • PFD_LM_COMM_RATE — NUMBER — 판매사L1
  • PFD_LM_COMM_AMOUNT — NUMBER — 판매사L1
  • PFD_LM_DSC_STD — CHAR — NOT NULL — 판매사L1
  • PFD_LM_DSC_RATE — NUMBER — 판매사L1
  • PFD_LM_DSC_AMOUNT — NUMBER — 판매사L1
  • PFD_LM_AMOUNT — NUMBER — 판매사
  • PFD_LM_AMOUNT_NET — NUMBER — 판매사
  • PFD_MC_MKUP_STD — CHAR — NOT NULL — 판매사L2
  • PFD_MC_MKUP_RATE — NUMBER — 판매사L2
  • PFD_MC_MKUP_AMOUNT — NUMBER — 판매사L2
  • PFD_C_DSC_STD — CHAR — NOT NULL — 고객할인
  • PFD_C_DSC_RATE — NUMBER — 고객할인율(%)
  • PFD_C_DSC_AMOUNT — NUMBER — 고객할인금액
  • PFD_PAY_AMOUNT — NUMBER — 결제대상금액
  • PFD_PAY_AMOUNT_NET — NUMBER
  • PFD_S_RSU_PANELTY — NUMBER — 원천공급사에
  • PFD_CERTI_IND — CHAR — 증빙핑요유무
  • PFD_CERTI_CHECK — CHAR — 증빙확인상태
  • PFD_PUR_CONFIRM_TYPE — CHAR — 구매확정타입
  • PFD_PUR_CONFIRM — CHAR — 구매확정상태
  • PFD_PUR_CONFIRM_ID — VARCHAR2 — 구매확정상태변경자ID
  • PFD_PUR_CONFIRM_NAME — VARCHAR2 — 구매확정상태변경자이름
  • PFD_PUR_CONFIRM_DATE — DATE — 구매확정일
  • PFD_ALL_CC_IND — CHAR
  • PFD_TRL_ID — NUMBER — 발권요청마스터키
  • PFD_REISSUE_IND — CHAR — 리이슈여부
  • PFD_ORG_PFD_ID — NUMBER — 리이슈
  • PFD_TKTG_STATUS — CHAR
  • PFD_TKTG_STATUS_AGT_CODE — VARCHAR2 — 발권진행상태변경자
  • PFD_TKTG_STATUS_ID — VARCHAR2 — 발권진행상태변경자ID
  • PFD_TKTG_STATUS_NAME — VARCHAR2 — 발권진행상태변경자이름
  • … +76

PNR_NAME_DATA

  • PND_ID — NUMBER — 기본 키 — NOT NULL — 시퀀스
  • PND_PCD_ID — NUMBER — NOT NULL — PCD
  • PND_NAME_SEQ — NUMBER — NOT NULL — Name
  • PND_REV_NAME_SEQ — NUMBER — NOT NULL — 순번
  • PND_H_CODE — VARCHAR2 — NOT NULL — H_CODE
  • PND_S_AGT_CODE — VARCHAR2 — 공급사
  • PND_L_AGT_CODE — VARCHAR2 — 판매사
  • PND_LCL_ID — VARCHAR2 — 주민번호
  • PND_LCL_NAME — VARCHAR2 — 현지이름
  • PND_LAST_NAME_EN — VARCHAR2 — NOT NULL — 영문성
  • PND_FIRST_NAME_EN — VARCHAR2 — NOT NULL — 영문이름
  • PND_TITLE — VARCHAR2 — TITLE
  • PND_IDT_CODE — CHAR — 나이구분
  • PND_BIRTH_DATE — VARCHAR2 — 생년월일
  • PND_GENDER — CHAR — 성별:M/F
  • PND_NATIONALITY_CODE — CHAR — 국적
  • PND_ISSUE_NATIONALITY_CODE — CHAR — 여권발행국
  • PND_PASSPORT_NO — VARCHAR2 — 여권번호
  • PND_PASSPORT_EXPIR — CHAR — 여권만료일
  • PND_WITH_PASS_IND — CHAR — 동반여권(소아
  • PND_MOBILE — VARCHAR2 — 핸드폰
  • PND_PHONE — VARCHAR2 — 연락처
  • PND_EMAIL — VARCHAR2 — 이메일
  • PND_SPCMEAL_TITLE — VARCHAR2 — 스페셜밀
  • PND_SPCMEAL_TYPE — VARCHAR2 — 스페셜밀
  • PND_SPCMEAL_DETAIL — VARCHAR2 — 스페셜밀
  • PND_MILAGE_CRD_NUM1 — VARCHAR2 — 항공사
  • PND_MILAGE_CRD_NUM2 — VARCHAR2 — 항공사
  • PND_MILAGE_CRD_NUM3 — VARCHAR2 — 항공사
  • PND_MILAGE_OP_CAR1 — CHAR — 마일리지
  • PND_MILAGE_SAVE_CAR1 — CHAR — 마일리지
  • PND_MILAGE_OP_CAR2 — CHAR — 마일리지
  • PND_MILAGE_SAVE_CAR2 — CHAR — 마일리지
  • PND_MILAGE_OP_CAR3 — CHAR — 마일리지
  • PND_MILAGE_SAVE_CAR3 — CHAR — 마일리지
  • PND_UPGRADE_MILAGE_NUM — VARCHAR2 — 업그레이드
  • PND_UPGRADE_SEG — VARCHAR2 — 업그레이드
  • PND_UPGRADE_DETAIL — VARCHAR2 — 업그레이드
  • PND_CURRENT_NAT_CODE — CHAR — 현거주지
  • PND_CURRENT_ADDRESS — VARCHAR2 — 현거주지
  • PND_CURRENT_PHONE — VARCHAR2 — 현거주지연락처
  • PND_ADDRESS_TO_STAY_CITY — VARCHAR2 — 체류
  • PND_ADDRESS_TO_STAY_ZIP — VARCHAR2 — 체류지
  • PND_ADDRESS_TO_STAY_STATE — VARCHAR2 — 체류
  • PND_ADDRESS_TO_STAY — VARCHAR2
  • PND_PHONE_TO_STAY — VARCHAR2 — 체류지
  • PND_STAY_NATIONALITY_CODE — CHAR — 체류국가코드
  • PND_DEP_CHECK_IND — CHAR — NOT NULL — 상용
  • PND_DEP_CHECK_ID — VARCHAR2 — 상용
  • PND_DEP_CHECK_DATE — DATE — 상용
  • PND_RMI_ID — VARCHAR2 — 상용
  • PND_TEAM_CODE — VARCHAR2 — 상용
  • PND_TEAM_DESC — VARCHAR2 — 상용
  • PND_RANK_CODE — VARCHAR2 — 상용
  • PND_RANK_DESC — VARCHAR2 — 상용
  • PND_REGULATION — CHAR — 규정위반여부
  • PND_REGULATION_DESC — VARCHAR2 — 규정위반내용
  • PND_CU_MAPPING_ID — VARCHAR2 — 하나투어
  • PND_INPUT_DV — VARCHAR2 — INPUT
  • PND_SR_NO — VARCHAR2 — 하나투어
  • … +22