ARAP

Tables (14)

tac_arap_freight

  • PERSON_NO — varchar(10) — Primary key — NOT NULL — PERSON NO
  • ARAP_DTL_SID — decimal(18, 0) — Primary key — NOT NULL
  • PERSON_NO (PERSON_NO2) — varchar(10) — Foreign key → tac_arap_master.PERSON_NO — NOT NULL — PERSON NO
  • ARAP_SID (ARAP_SID2) — decimal(18, 0) — Foreign key → tac_arap_master.ARAP_SID — NOT NULL
  • ARAP_SID — decimal(18, 0) — NOT NULL
  • ARAP_SEQ — decimal(18, 0) — NOT NULL
  • AMT_ACTCD — varchar(8)
  • AMT_SUBNO — varchar(5)
  • BRF_ACTCD — varchar(8)
  • BRF_SUBNO — varchar(5)
  • BRFNO — varchar(18)
  • ETAX_SID — decimal(18, 0)
  • SELL_BUY_FLAG — varchar(1) — NOT NULL
  • SYSLINE_CD — varchar(10) — NOT NULL
  • ETAX_SEQ — int(11)
  • ARAP_REMARK — varchar(100)
  • MBL_NO — varchar(40)
  • SETTLE_SID — decimal(18, 0)
  • BL_NO — varchar(40)
  • FREIGHT_SID — varchar(18)
  • FREIGHT_CD — varchar(5)
  • FREIGHT_INIT_CD — varchar(5)
  • FREIGHT_NAME — varchar(50)
  • VESSEL_CD — varchar(10)
  • VESSEL_NAME — varchar(35)
  • VOYAGE_NO — varchar(12)
  • IO_FLAG — varchar(1)
  • POL_LOCATION_CD — varchar(50)
  • POD_LOCATION_CD — varchar(50)
  • PREPAID_COLLECT_CD — varchar(1)
  • CURRENCY_CD — varchar(3)
  • PER_CD — varchar(10)
  • RATE_AMT — decimal(15, 2) — NOT NULL
  • BASE_QTY — decimal(15, 3) — NOT NULL
  • FREIGHT_AMT — decimal(15, 2) — NOT NULL
  • FREIGHT_KRW — decimal(15, 2) — NOT NULL
  • FREIGHT_USD — decimal(15, 2) — NOT NULL
  • EXCHANGE_DATE — varchar(8)
  • EXCHANGE_RATE — decimal(8, 3) — NOT NULL
  • SAILING_DATE — date
  • CUSTOMER_CD — varchar(20)
  • CUSTOMER_NAME — varchar(100)
  • VAT_RATE — decimal(15, 2) — NOT NULL
  • VAT_AMT — decimal(15, 2) — NOT NULL
  • VAT_KRW — decimal(15, 2) — NOT NULL
  • VAT_USD — decimal(15, 2) — NOT NULL
  • OFF_FLAG — varchar(1) — NOT NULL
  • OFF_AMT — decimal(15, 2) — NOT NULL
  • OFF_KRW — decimal(15, 2) — NOT NULL
  • OFF_USD — decimal(15, 2) — NOT NULL
  • CREATED_USER_ID — varchar(50)
  • CREATED_PROGRAM_ID — varchar(50)
  • CREATED_TIME — datetime
  • UPDATED_USER_ID — varchar(50)
  • UPDATED_PROGRAM_ID — varchar(50)
  • UPDATED_TIME — datetime
  • ERP_GROUP — varchar(10)
  • EXCHANGE_UNIT — decimal(10, 5) — NOT NULL

tac_arap_master

  • PERSON_NO — varchar(10) — Primary key — NOT NULL — PERSON NO
  • ARAP_SID — decimal(18, 0) — Primary key — NOT NULL
  • AUTH_CUSTOMER — varchar(10)
  • COMP_NO — varchar(10) — NOT NULL
  • ARAP_NO — varchar(20) — NOT NULL
  • RECEIPT_SYSTEM — varchar(10)
  • DELETE_TYPE — varchar(1)
  • ARAP_FLAG — varchar(2) — NOT NULL
  • ARAP_SYSTEM — varchar(10) — NOT NULL
  • PARTNER_CD_NO — varchar(30)
  • MBL_NO — varchar(20)
  • ORIGIN_ARAP_NO — varchar(20)
  • SETOFF_DATE — varchar(8)
  • EXCHANGE_RATE — decimal(10, 4)
  • DELETE_ORG_SID — decimal(18, 0)
  • DELETE_ORG_NO — varchar(20)
  • SAILING_DATE — varchar(8)
  • SETOFF_FLAG — varchar(1)
  • ARAP_DATE — varchar(8)
  • DUEDATE — varchar(8)
  • DUECURR — varchar(4)
  • SYSLINE_CD — varchar(10)
  • BL_NO — varchar(40)
  • VESSEL_CD — varchar(10)
  • VESSEL_NAME — varchar(35)
  • VOYAGE_NO — varchar(11)
  • IO_FLAG — varchar(1)
  • CUSTOMER_CD — varchar(20)
  • CUSTOMER_NAME — varchar(100)
  • REGISTRATION_NO — varchar(20)
  • REGISTRATION_SUB — varchar(10)
  • REPRESENTATIVE_NAME — varchar(50)
  • BUSINESS_ADDRESS — varchar(100)
  • AMOUNT_KRW — decimal(15, 3)
  • AMOUNT_USD — decimal(15, 3)
  • AMOUNT_OTH — decimal(15, 3)
  • CURRENCY_OTH — varchar(3)
  • AMOUNT_SLIP — decimal(15, 3)
  • REMARK — varchar(200)
  • BSLIP_NO — varchar(20)
  • CUST_DOCU_TYPE — varchar(10)
  • ETAX_VANCD — varchar(10)
  • BUSINESS_TYPE — varchar(100)
  • BUSINESS_ITEM — varchar(100)
  • PIC_DEPT — varchar(50)
  • PIC_NAME — varchar(50)
  • PIC_EMAIL — varchar(50)
  • PIC_PHONE_NO — varchar(50)
  • PIC_PHONE_HP — varchar(50)
  • MOD_REASON_CODE — varchar(2)
  • RECEIPT_TYPE — varchar(10)
  • CREATED_USER_ID — varchar(50)
  • CREATED_PROGRAM_ID — varchar(50)
  • CREATED_TIME — datetime
  • UPDATED_USER_ID — varchar(50)
  • UPDATED_PROGRAM_ID — varchar(50)
  • UPDATED_TIME — datetime
  • ERP_PAY_GROUP — varchar(20) — 지급그룹(한라 ERP 용)
  • ERP_PAY_COND — varchar(20) — 결재조건(한라 ERP 용)
  • ERP_REC_COND — varchar(20) — 수금조건(한라 ERP 용)
  • … +7

tac_receipt_dtl

  • RECEIPT_SID — decimal(15,0) — Primary key — NOT NULL
  • SETOFF_SID — decimal(15,0) — Primary key — NOT NULL
  • RECEIPT_SID (RECEIPT_SID2) — decimal(15, 0) — Foreign key → tac_receipt_mst.RECEIPT_SID — NOT NULL
  • SETOFF_DATE — varchar(8)
  • SETOFF_AMT — decimal(15,2)
  • SETOFF_KRW — decimal(15,0)
  • CREATED_USER_ID — varchar(50)
  • CREATED_PROGRAM_ID — varchar(20)
  • CREATED_TIME — datetime
  • UPDATED_USER_ID — varchar(50)
  • UPDATED_PROGRAM_ID — varchar(20)
  • UPDATED_TIME — datetime

tac_receipt_mst

  • RECEIPT_SID — decimal(15, 0) — Primary key — NOT NULL
  • PERSON_NO — varchar(10) — NOT NULL — PERSON NO
  • RECEIPT_NO — varchar(20) — NOT NULL
  • COMP_NO — varchar(10)
  • DEPT_NO — varchar(10)
  • RECEIPT_DATE — varchar(8)
  • CURR_CD — varchar(20)
  • RECEIPT_AMT — decimal(15, 2)
  • EXDATE — varchar(8)
  • EXRATE — decimal(10, 4)
  • RECEIPT_KRW — decimal(15, 0)
  • CUST_REMARK — varchar(200)
  • CUST_CD — varchar(20)
  • SLIP_NO — varchar(20)
  • SETOFF_AMT — decimal(15, 2)
  • SETOFF_KRW — decimal(15, 0)
  • CREATED_USER_ID — varchar(50)
  • CREATED_PROGRAM_ID — varchar(20)
  • CREATED_TIME — datetime
  • UPDATED_USER_ID — varchar(50)
  • UPDATED_PROGRAM_ID — varchar(20)
  • UPDATED_TIME — datetime
  • BRF_ACTCD — varchar(10)
  • BRF_ACTNM — varchar(50)
  • BRF_SUBNO — varchar(10)
  • BRF_SUBNM — varchar(50)
  • BRF_BRFNO — varchar(20)
  • BRF_SUBGBN — varchar(10)

tac_setoff_actcd

  • PERSON_NO — varchar(10) — Primary key — NOT NULL — PERSON NO
  • SETOFF_NO — varchar(14) — Primary key — NOT NULL
  • SETOFF_SEQ — decimal(15, 0) — Primary key — NOT NULL
  • PERSON_NO (PERSON_NO2) — varchar(10) — Foreign key → tac_setoff_mst.PERSON_NO — NOT NULL — PERSON NO
  • SETOFF_SID (SETOFF_SID2) — decimal(18, 0) — Foreign key → tac_setoff_mst.SETOFF_SID — NOT NULL
  • SETOFF_SID — decimal(18, 0) — NOT NULL
  • ACTCD — varchar(8)
  • ACTNM — varchar(50)
  • SUBGBN — varchar(2)
  • SUBNO — varchar(5)
  • REFNO — varchar(20)
  • BRFNO — varchar(17)
  • SUBNM — varchar(30)
  • CUST_CD — varchar(20)
  • CUST_NM — varchar(100)
  • CUCD — varchar(4)
  • UDEBIT — decimal(15, 2)
  • EXRATE — decimal(10, 4)
  • DEBIT — decimal(17, 2)
  • UCREDIT — decimal(15, 2)
  • CREDIT — decimal(15, 0)
  • MARK — varchar(100)
  • CREATED_USER_ID — varchar(50)
  • CREATED_PROGRAM_ID — varchar(20)
  • CREATED_TIME — datetime
  • UPDATED_USER_ID — varchar(50)
  • UPDATED_PROGRAM_ID — varchar(20)
  • UPDATED_TIME — datetime
  • RECEIPT_SID — decimal(18, 0)

tac_setoff_ap

  • PERSON_NO — varchar(10) — Primary key — NOT NULL — PERSON NO
  • SETOFF_SID — decimal(18, 0) — Primary key — NOT NULL
  • SETOFF_SEQ — decimal(15, 0) — Primary key — NOT NULL
  • PERSON_NO (PERSON_NO2) — varchar(10) — Foreign key → tac_setoff_mst.PERSON_NO — NOT NULL — PERSON NO
  • SETOFF_SID (SETOFF_SID2) — decimal(18, 0) — Foreign key → tac_setoff_mst.SETOFF_SID — NOT NULL
  • SET_TYPE — varchar(2)
  • JICHUL_SID — decimal(18, 0)
  • JICHUL_NO — varchar(24)
  • JICHUL_SEQ — varchar(4)
  • CUST_CD — varchar(8)
  • CUST_NM — varchar(50)
  • EXPENSE_CD — varchar(6)
  • EXPENSE_NM — varchar(50)
  • CUCD — varchar(3)
  • AMOUNTU — decimal(15, 2)
  • EXRATE — decimal(10, 4)
  • AMOUNTK — decimal(15, 0)
  • REMARKS — varchar(50)
  • ACTCD — varchar(8)
  • SUBNO — varchar(5)
  • BRFNO — varchar(17)
  • VESSEL_CD — varchar(6)
  • VOYAGE_NO — varchar(11)
  • VESSEL_NM — varchar(35)
  • PROGRESS_GUID — varchar(36)
  • PROCESS_GUID — varchar(36)
  • AMOUNTP — decimal(12, 2)
  • PAYCUR — varchar(3)
  • CREATED_USER_ID — varchar(50)
  • CREATED_PROGRAM_ID — varchar(20)
  • CREATED_TIME — date
  • UPDATED_USER_ID — varchar(50)
  • UPDATED_PROGRAM_ID — varchar(20)
  • UPDATED_TIME — date

tac_setoff_ar

  • PERSON_NO — varchar(10) — Primary key — NOT NULL — PERSON NO
  • SETOFF_NO — varchar(14) — Primary key — NOT NULL
  • SETOFF_SEQ — decimal(15, 0) — Primary key — NOT NULL
  • PERSON_NO (PERSON_NO2) — varchar(10) — Foreign key → tac_setoff_mst.PERSON_NO — NOT NULL — PERSON NO
  • SETOFF_SID (SETOFF_SID2) — decimal(18, 0) — Foreign key → tac_setoff_mst.SETOFF_SID — NOT NULL
  • SETOFF_SID — decimal(18, 0) — NOT NULL
  • REF_TABLE — varchar(10)
  • IO_FLAG — varchar(1)
  • BL_NO — varchar(30)
  • REF_SID — decimal(18, 0) — NOT NULL
  • REF_NO — varchar(30)
  • CUST_CD — varchar(20)
  • CUST_NM — varchar(100)
  • FREIGHT_CD — varchar(5)
  • LCUR — varchar(3)
  • EXRATE — decimal(10, 4)
  • TAX_EXRATE — decimal(10, 4)
  • LOC_AMT — decimal(15, 2)
  • STL_AMT — decimal(15, 2)
  • USD_AMT — decimal(15, 2)
  • KRW_AMT — decimal(15, 0)
  • ARAP_AMT — decimal(15, 0)
  • TCUR — varchar(3)
  • SYSLINE_CD — varchar(10)
  • VESSEL_CD — varchar(20)
  • VOYAGE_NO — varchar(11)
  • VESSEL_NM — varchar(35)
  • FREIGHT_INIT — varchar(5)
  • SCUR — varchar(3)
  • ACTCD — varchar(8)
  • SUBNO — varchar(5)
  • BRFNO — varchar(17)
  • SLIP_SEQ — varchar(4)
  • FREIGHT_KIND — varchar(1)
  • BLSUBNO — varchar(5)
  • FREIGHT_NM — varchar(50)
  • ARAP_FLAG — varchar(2) — NOT NULL
  • CREATED_USER_ID — varchar(50)
  • CREATED_PROGRAM_ID — varchar(20)
  • CREATED_TIME — datetime
  • UPDATED_USER_ID — varchar(50)
  • UPDATED_PROGRAM_ID — varchar(20)
  • UPDATED_TIME — datetime

tac_setoff_mst

  • PERSON_NO — varchar(10) — Primary key — NOT NULL — PERSON NO
  • SETOFF_SID — decimal(18, 0) — Primary key — NOT NULL
  • SETOFF_NO — varchar(14) — NOT NULL
  • SETOFF_DATE — varchar(8)
  • SETOFF_SYSTEM — varchar(10)
  • INVNO — varchar(16)
  • SCUR — varchar(3)
  • CUST_CD — varchar(20)
  • CUST_NM — varchar(100)
  • LOC_TOT_AR — decimal(15, 2)
  • STL_TOT_AR — decimal(15, 2)
  • USD_TOT_AR — decimal(15, 2)
  • KRW_TOT_AR — decimal(15, 0)
  • ARAP_TOT_AR — decimal(15, 0)
  • INAMT — decimal(15, 2)
  • EXRATE — decimal(10, 4)
  • INKRW — decimal(15, 0)
  • EMP_NO — varchar(20)
  • BSLIP_NO — varchar(16)
  • DEPT_NO — varchar(5)
  • COMP_NO — varchar(10)
  • DETAIL_CNT — decimal(4, 0)
  • PRINT_DATE — varchar(8)
  • SYSLINE_CD — varchar(10)
  • ORG_SETOFF_NO — varchar(14)
  • IPGM_GUBUN — varchar(4)
  • SIL_NM — varchar(35)
  • PROGRESS_GUID — varchar(36)
  • PROCESS_GUID — varchar(36)
  • ACTCUST_CD — varchar(20)
  • SETOFF_DISP — varchar(20)
  • ACTCUST_NM — varchar(100)
  • LOC_TOT_AP — decimal(15, 2)
  • STL_TOT_AP — decimal(15, 2)
  • USD_TOT_AP — decimal(15, 2)
  • KRW_TOT_AP — decimal(15, 0)
  • ARAP_TOT_AP — decimal(15, 0)
  • DELETE_TYPE — varchar(1)
  • DELETE_ORG_SID — decimal(18, 0)
  • DELETE_ORG_NO — varchar(20)
  • DELETE_USER_ID — varchar(50)
  • DELETED_TIME — date
  • DEPT_NM — varchar(50)
  • PIC_EMAIL — varchar(50)
  • PIC_NAME — varchar(50)
  • PIC_PHONE_NO — varchar(50)
  • PIC_PHONE_HP — varchar(50)
  • TAX_REMARK — varchar(200)
  • CREATED_USER_ID — varchar(50)
  • CREATED_PROGRAM_ID — varchar(20)
  • CREATED_TIME — datetime
  • UPDATED_USER_ID — varchar(50)
  • UPDATED_PROGRAM_ID — varchar(20)
  • UPDATED_TIME — datetime

tac_settle_freight

  • PERSON_NO — varchar(10) — Primary key — NOT NULL — PERSON NO
  • FREIGHT_SID — decimal(18, 0) — Primary key — NOT NULL — FREIGHT PK
  • SETTLE_SID (SETTLE_SID2) — decimal(18, 0) — Foreign key → tac_settle_master.SETTLE_SID — NOT NULL
  • SETTLE_SID — decimal(18, 0) — NOT NULL — MASTER PK
  • SELL_BUY_FLAG — varchar(1) — NOT NULL — S: SELL B:BUY
  • REG_SEQ — decimal(5, 0) — NOT NULL
  • PREPAID_COLLECT_CD — varchar(1) — NOT NULL — P/C
  • FREIGHT_CD — varchar(5) — NOT NULL — FREIGHT CODE
  • FREIGHT_INIT_CD — varchar(5) — FREIGHT INIT
  • FREIGHT_NAME — varchar(50) — FREIGHT CODE NAME
  • CURRENCY_CD — varchar(3) — NOT NULL — CURRENCY CODE
  • PER_CD — varchar(10) — NOT NULL — UNIT CODE
  • POP_CD — varchar(5) — NOT NULL — OUTSTANDING PLACE(NATION)
  • CUSTOMER_CD — varchar(20) — CUSTOMER CODE
  • CUSTOMER_NAME — varchar(70) — CUSTOMER NAME
  • INVOICE_SID — decimal(18, 0) — NOT NULL — INVOICE SID
  • INVOICE_DATE — varchar(8) — INVOICE DATE
  • MISU_DATE — varchar(8) — 미수 일자
  • BASE_QTY — decimal(15, 3) — NOT NULL — 수량
  • RATE_AMT — decimal(15, 2) — NOT NULL — 단가
  • FREIGHT_AMT — decimal(15, 2) — NOT NULL — 금액(CURRENCY_CD)
  • FREIGHT_AMT_U — decimal(15, 2) — NOT NULL — 금액(USD)
  • FREIGHT_AMT_K — decimal(15, 2) — NOT NULL — 금액(KRW)
  • VAT_RATE — decimal(15, 2) — NOT NULL — VAT RATER
  • VAT_AMT — decimal(15, 2) — NOT NULL — VAT(CURRENCY_CD)
  • VAT_AMT_U — decimal(15, 2) — NOT NULL — VAT(USD)
  • VAT_AMT_K — decimal(15, 2) — NOT NULL — VAT(KRW)
  • AUTO_RATE_FLAG — varchar(1) — NOT NULL
  • AUTO_RATE_AMT — decimal(15, 2) — NOT NULL
  • EXCHANGE_RATE — decimal(8, 3) — NOT NULL — 환율
  • EXCHANGE_DATE — varchar(8) — 환율 일자
  • OFF_FLAG — varchar(1) — NOT NULL — 입금 여부
  • OFF_AMT — decimal(15, 2) — NOT NULL — 입금액(CURRENCY)
  • OFF_AMT_U — decimal(15, 2) — NOT NULL — 입금액(USD)
  • OFF_AMT_K — decimal(15, 2) — NOT NULL — 입금액(KRW)
  • ARAP_SID — decimal(18, 0) — NOT NULL — TAX SID
  • ARAP_FLAG — varchar(1) — NOT NULL — TAX CREATED FLAG
  • ARAP_AMT — decimal(15, 2) — NOT NULL — TAX AMOUNT(CURRENCY)
  • ARAP_AMT_U — decimal(15, 2) — NOT NULL — TAX AMOUNT(USD)
  • ARAP_AMT_K — decimal(18, 0) — NOT NULL — TAX AMOUNT(KRW)
  • FREIGHT_REMARK — varchar(100) — REMARK
  • USABLE_FLAG — varchar(1) — NOT NULL
  • INVOICE_NO — varchar(20)
  • ARAP_SYSTEM — varchar(10) — NOT NULL
  • AUTO_QUERY_ID — varchar(36)
  • TARIFFSHEET_SID — decimal(18, 0)
  • TARIFFITEM_SID — decimal(18, 0)
  • PERIOD_START — varchar(8)
  • PERIOD_END — varchar(8)
  • PARTY_SID — decimal(18, 0)
  • CREATED_USER_ID — varchar(50) — NOT NULL
  • CREATED_PROGRAM_ID — varchar(50) — NOT NULL
  • CREATED_TIME — datetime — NOT NULL
  • UPDATED_USER_ID — varchar(50) — NOT NULL
  • UPDATED_PROGRAM_ID — varchar(50) — NOT NULL
  • UPDATED_TIME — datetime — NOT NULL
  • INV_CURR_CD — varchar(3)
  • INV_EXRATE — decimal(8, 3) — NOT NULL
  • FREIGHT_INV — decimal(15, 2) — NOT NULL
  • VAT_INV — decimal(15, 2) — NOT NULL
  • … +4

tac_settle_master

  • SETTLE_SID — decimal(18, 0) — Primary key — NOT NULL
  • PERSON_NO — varchar(10) — NOT NULL — PERSON NO
  • AUTH_CUSTOMER — varchar(10)
  • BL_NO — varchar(20) — NOT NULL
  • SYSLINE_CD — varchar(10) — NOT NULL
  • SYSTYPE_CD — varchar(20) — NOT NULL — IN : 입고 OUT : 출고
  • FREIGHT_TYPE — varchar(10) — NOT NULL — STOCKIN : 입고 / STOCKOUT : 출고
  • IO_FLAG — varchar(1)
  • VESSEL_CD — varchar(10)
  • VOYAGE_NO — varchar(12)
  • LEG_CD — varchar(1)
  • POL_LOCATION_CD — varchar(50)
  • POL_LOCATION_NM — varchar(200)
  • CALL_SEQ — decimal(1, 0)
  • POD_LOCATION_CD — varchar(50)
  • POD_LOCATION_NM — varchar(200)
  • ETA — varchar(8)
  • ETD — varchar(8)
  • SAILING_DATE — varchar(8)
  • ACTUAL_SHIPPER_CD — varchar(20)
  • CLOSING_FLAG — varchar(1)
  • USABLE_FLAG — varchar(1)
  • SR_SETTLE_SID — decimal(18, 0)
  • MBL_NO — varchar(20)
  • VESSEL_NAME — varchar(50)
  • SALES_USER_ID — varchar(50)
  • ISSUE_USER_ID — varchar(50)
  • PARTNER_CD — varchar(20)
  • PC_CD — varchar(1)
  • MANUAL_FLAG_SAILING — varchar(1) — NOT NULL
  • CREATED_USER_ID — varchar(50)
  • CREATED_PROGRAM_ID — varchar(20)
  • CREATED_TIME — date
  • UPDATED_USER_ID — varchar(50)
  • UPDATED_PROGRAM_ID — varchar(20)
  • UPDATED_TIME — date
  • ERP_GROUP — varchar(10)
  • CONTAINER_NO — varchar(20)
  • PARENT_ORDER_SID — decimal(18, 0)
  • PL_DATE — varchar(8)
  • REF_TABLE — varchar(50) — 저장된 TABLE NAME

tcm_customer_person

  • PERSON_NO — varchar(10) — Primary key — NOT NULL — PERSON NO
  • CUSTOMER_SID — decimal(18, 0) — Primary key — NOT NULL — 거래처(Customer) SID
  • USER_SID — decimal(18, 0) — Foreign key → tcm_user_master.USER_SID — NOT NULL — 사용자 SID
  • CLASS_SID — decimal(18, 0) — NOT NULL — 공통 코드 그룹 SID
  • CLASS_CODE — varchar(5) — NOT NULL — 공통 코드 그룹 코드
  • CUSTOMER_CODE — varchar(20) — NOT NULL — 거래처(Customer) Code
  • CUSTOMER_NAME — varchar(100) — NOT NULL — 거래처(Customer) 한글명
  • REGISTRATION_NO — varchar(20) — 사업자 등록증 - 사업자번호
  • SUB_REGISTRATION_NO — varchar(20) — 사업자 등록증 - 종사업자번호
  • REPRESENTATIVE_ID_NO — varchar(20) — 대표자 주민등록번호/법인등록번호
  • REPRESENTATIVE_POSITION — varchar(50)
  • REPRESENTATIVE_NAME — varchar(50) — 사업자 등록증 - 대표자 명
  • REPRESENTATIVE_POSITION2 — varchar(50)
  • REPRESENTATIVE_NAME2 — varchar(50)
  • ZIP_CODE — varchar(10) — 우편번호
  • NEW_BUSINESS_ADDRESS1 — varchar(200)
  • NEW_BUSINESS_ADDRESS2 — varchar(100)
  • COUNTRY_CODE — varchar(2) — 국가 Code
  • CITY_CODE — varchar(5) — 거래처(Customer) 도시 Code
  • BUSINESS_ADDRESS — varchar(200) — 사업자 등록증 - 사업장 주소
  • BUSINESS_TYPE — varchar(100) — 사업자 등록증 - 업태
  • BUSINESS_ITEM — varchar(100) — 사업자 등록증 - 업종
  • REGISTRATION_TYPE_CODE — varchar(5) — 사업자 구분(법인,개인,외국인)
  • MAIN_TELEPHONE_NO — varchar(50) — 대표 전화 번호
  • TELEPHONE_NO2 — varchar(50) — 전화 번호 2
  • TELEPHONE_NO3 — varchar(50) — 전화 번호 3
  • MAIN_FAX_NO — varchar(50) — 대표 Fax 번호
  • FAX_NO2 — varchar(50) — 팩스 번호 2
  • FAX_NO3 — varchar(50) — 팩스 번호 3
  • DUZON_CODE — varchar(10) — 더존 거래처 Code
  • IATA_CODE — varchar(14) — IATA Code
  • AGENCY_CODE — varchar(4) — 대리점 Code
  • ACCOUNT_NO — varchar(14) — IATA Account No.
  • DUNS_NO — varchar(10) — KKLU:DUNS No
  • HQ_COMPANY_ID — decimal(10, 0) — KKLU:본사 Customer Code
  • TAX_PIC_NAME — varchar(50) — 전자 세금 계산서 용 - 담당자 명
  • TAX_PHONE_NO — varchar(50) — 전자 세금 계산서 용 - 담당자 연락처
  • TAX_EMAIL_ADDRESS — varchar(50) — 전자 세금 계산서 용 - eMail
  • VENDOR_CATEGORY — varchar(40) — KKLU:
  • SYSTEM_FLAG — varchar(1) — NOT NULL — 시스템 여부
  • IATA_FLAG — varchar(1) — NOT NULL — IATA가입여부(YN)
  • CREDIT_FLAG — varchar(1) — NOT NULL — 미수 거래처 여부
  • CREDIT_LIMIT_CUR — varchar(3) — 미수 한도 통화 코드
  • CREDIT_LIMIT_AMOUNT — decimal(18, 0) — NOT NULL — 미수 한도 금액
  • CREDIT_PERIOD — varchar(5) — 미수 기간
  • DEFAULT_ASSIGN_CODE — varchar(20) — 기본 배정 장소 코드
  • HO_COMPANY_CODE — varchar(20) — 본사코드
  • CUSTOMER_TYPE — varchar(50)
  • KLNET_VATDEC_ID — varchar(10)
  • EMAIL — varchar(50)
  • BUSINESS_ADDRESS_ENG1 — varchar(50) — B/L ADDRESS1
  • BUSINESS_ADDRESS_ENG2 — varchar(50) — B/L ADDRESS2
  • BUSINESS_ADDRESS_ENG3 — varchar(50) — B/L ADDRESS3
  • BUSINESS_ADDRESS_ENG4 — varchar(50) — B/L ADDRESS4
  • BUSINESS_ADDRESS_ENG5 — varchar(50) — B/L ADDRESS5
  • CUSTOMER_NAME_ENG — varchar(100)
  • MAIN_EMAIL_ADDRESS — varchar(50) — 대표 이메일 주소
  • EMAIL_ADDRESS2 — varchar(50) — 이메일 주소2
  • MOF_CUSTOMER_NAME — varchar(100) — 해수부 업체 명
  • JOIN_DATE — varchar(10)
  • … +40

tcm_freight_acct

  • PERSON_NO — varchar(10) — Primary key — NOT NULL — PERSON NO
  • FREIGHT_CD — varchar(5) — Primary key — NOT NULL
  • SYSTEM_TYPE — varchar(10) — Primary key — NOT NULL
  • PERSON_NO (PERSON_NO2) — varchar(10) — Foreign key → tcm_freight_cod.PERSON_NO — NOT NULL — PERSON NO
  • FREIGHT_CD (FREIGHT_CD2) — varchar(5) — Foreign key → tcm_freight_cod.FREIGHT_CD — NOT NULL
  • S_AMT_ACCT — varchar(8)
  • S_AMT_SUB — varchar(5)
  • S_BRF_ACCT — varchar(8)
  • S_BRF_SUB — varchar(5)
  • B_AMT_ACCT — varchar(8)
  • B_AMT_SUB — varchar(5)
  • B_BRF_ACCT — varchar(8)
  • B_BRF_SUB — varchar(5)
  • PS_AMT_ACCT — varchar(8)
  • PS_AMT_SUB — varchar(5)
  • PS_BRF_ACCT — varchar(8)
  • PS_BRF_SUB — varchar(5)
  • PB_AMT_ACCT — varchar(8)
  • PB_AMT_SUB — varchar(5)
  • PB_BRF_ACCT — varchar(8)
  • PB_BRF_SUB — varchar(5)
  • DEFAULT_CURRENCY — varchar(4)
  • DEFAULT_AMOUNT — decimal(10, 0)
  • CREATED_USER_ID — varchar(50) — NOT NULL
  • CREATED_PROGRAM_ID — varchar(50) — NOT NULL
  • CREATED_TIME — datetime — NOT NULL
  • FREIGHT_NAME — varchar(50)
  • SELL_FLAG — varchar(1)
  • UPDATED_USER_ID — varchar(50) — NOT NULL
  • UPDATED_PROGRAM_ID — varchar(50) — NOT NULL
  • UPDATED_TIME — datetime — NOT NULL
  • BUY_FLAG — varchar(1)
  • FREIGHT_INIT — varchar(4)
  • VAT_FLAG — varchar(1)
  • VAT_RATE — int(11)

tcm_freight_cod

  • PERSON_NO — varchar(10) — Primary key — NOT NULL — PERSON NO
  • FREIGHT_CD — varchar(5) — Primary key — NOT NULL
  • FREIGHT_NAME — varchar(50) — NOT NULL
  • FREIGHT_INIT — varchar(5) — NOT NULL
  • VAT_RATE — int(11)
  • USABLE_FLAG — varchar(1)
  • MANIFEST_FLAG — varchar(1)
  • VAT_FLAG — varchar(1)
  • EDI_CD — varchar(6)
  • CREATED_USER_ID — varchar(50) — NOT NULL
  • CREATED_PROGRAM_ID — varchar(50) — NOT NULL
  • CREATED_TIME — datetime — NOT NULL
  • UPDATED_USER_ID — varchar(50) — NOT NULL
  • UPDATED_PROGRAM_ID — varchar(50) — NOT NULL
  • UPDATED_TIME — datetime — NOT NULL
  • FREIGHT_CHARGE — varchar(1)
  • CHARGE_TYPE_AIR — varchar(2)
  • CHARGE_TYPE_AIR_H — varchar(1)
  • CHARGE_TYPE_AIR_M — varchar(1)

tcm_user_master

  • USER_SID — decimal(18, 0) — Primary key — NOT NULL — 사용자 SID
  • PERSON_NO — varchar(10) — NOT NULL — PERSON NO
  • USER_ID — varchar(50) — NOT NULL — 사용자 ID
  • USER_PASSWORD — varchar(200) — NOT NULL
  • EMP_NO — varchar(10)
  • USER_NAME — varchar(50) — 사용자 자국어 명
  • COMPANY_CODE — varchar(20) — NOT NULL — 회사 Code, Customer Code
  • DEPARTMENT_CODE — varchar(10) — 부서 Code
  • TEL_NO — varchar(50)
  • MOBILE_NO — varchar(50)
  • FAX_NO — varchar(50)
  • EMAIL_ADDRESS — varchar(50) — 담당자(PIC) eMail 주소
  • DEFAULT_LANGUAGE_CODE — varchar(5) — NOT NULL — 기본 사용 언어
  • LOGIN_FAIL_COUNT — decimal(3, 0) — NOT NULL — 로그인 실패 횟수
  • LAST_LOGIN_TIME — datetime — 최종 로그인 일시
  • LAST_PASSWORD_TIME — datetime — 최종 패스워드 변경 일시
  • RETIRE_FLAG — varchar(1) — NOT NULL — 퇴사 여부
  • USABLE_FLAG — varchar(1) — NOT NULL
  • PROGRESS_GUID — varchar(36)
  • PROCESS_GUID — varchar(36)
  • API_USER_ID — decimal(18, 0)
  • CREATED_USER_ID — varchar(50) — NOT NULL — 최초 등록 사용자 ID
  • CREATED_PROGRAM_ID — varchar(50) — NOT NULL — 최초 등록 프로그램 ID
  • CREATED_TIME — datetime — NOT NULL — 최초 등록 일시
  • UPDATED_USER_ID — varchar(50) — NOT NULL — 최종 수정 사용자 ID
  • UPDATED_PROGRAM_ID — varchar(50) — NOT NULL — 최종 수정 프로그램 ID
  • UPDATED_TIME — datetime — NOT NULL — 최종 수정 일
  • USER_REMARK — text
  • REPRESENT_FLAG — varchar(1) — 대표자 FLAG
  • USER_SESSION — varchar(50)
  • USER_CUSTOMER_CD — varchar(20)
  • USER_DEL_REASON — varchar(2000)
  • RECOMMENDER_ID — varchar(36)
  • GROUP_CD — varchar(20)
  • DEPT_CD — varchar(10)
  • SECTION_CD — varchar(10)
  • USER_COMPANY_NAME — varchar(50)
  • REGISTRATION_NO — varchar(10)
  • ADMIN_FLAG — varchar(1)
  • USER_TOKEN — varchar(200)
  • TRUCKER_GROUP_CD — varchar(20)
  • TRUCKER_SHOW_GROUP — varchar(20)
  • USED_INVEN_FLAG — varchar(1)
  • USED_TMS_FLAG — varchar(1)
  • CONCERN_OFFER_TYPE — varchar(100)
  • CONNECT_STR — varchar(200)
  • TITLE_CODE — varchar(25)
  • CS_USABLE_FLAG — varchar(1)
  • CUSTOMER_SID — decimal(18, 0) — CUSTOMER에서 사용자생성
  • ISSUE_PLACE_CD — varchar(5)
  • ISSUE_PLACE_NM — varchar(20)
  • FREIGHT_PAYTABLE_CD — varchar(5)
  • FREIGHT_PAYTABLE_NM — varchar(20)