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)