yuhan

Tables (428)

TB_FPIS_MODULE

  • CL_COMP_BSNS_NUM — varchar(30)
  • CONT_GROUP — varchar(100)
  • CONT_AGENCY_USR_MST_KEY — varchar(20)
  • CONT_FROM — varchar(8)
  • CONT_DEPOSIT — varchar(30)
  • CAR_REG_NUM — varchar(30)
  • CAR_END_TIME — varchar(8)
  • CAR_CHARGE — varchar(30)
  • TRU_COMP_BSNS_NUM — varchar(30)
  • TRU_CONT_FROM — varchar(8)
  • TRU_DEPOSIT — varchar(30)
  • TRU_MANG_TYPE — varchar(1)
  • CREATE_DATE — datetime
  • MAC_INFO — varchar(20)
  • COMPLATE_DATE — datetime
  • RefNo — varchar(20)
  • Seq — int
  • CONT_DEL_TYPE — varchar(2)
  • CONT_TRANS_TYPE — varchar(2)
  • CAR_ORDER_CNT — varchar(30)

TCA_BL

  • JobNo — varchar(20) — Primary key — NOT NULL — Job번호
  • BoundSystem — varchar(2) — Bound구분_시스템
  • Bound — varchar(2) — Bound구분
  • RefNo — varchar(30) — 내부관리번호
  • MBLNo — varchar(20) — 마스타빌번호
  • HBLNo — varchar(20) — 하우스빌번호
  • BLTypeIncoterms — varchar(10) — BL구분_결재조건
  • BLTypeOriginal — varchar(20) — BL구분_종류_Original
  • IssueDate — smalldatetime — 발행일자
  • CustomerCode — varchar(20) — 고객코드
  • CustomerName — varchar(60) — 고객명
  • ShipperCode — varchar(20) — 화주코드
  • ConsigneeCode — varchar(20) — 수하인코드
  • OrigCode — varchar(5) — 출발지코드
  • DestCode — varchar(5) — 도착지코드
  • FlightNo — varchar(10) — 편명
  • VesselName — varchar(30) — 선명_Vsl
  • Voyage — varchar(10) — 항차_vyg
  • CallSign — varchar(4) — 선박호출부호
  • Pieces — numeric(9, 0) — 수량_Pieces
  • PiecesUnit — varchar(20) — 수량_단위
  • GWT — numeric(12, 2) — 중량_총
  • KgUnit — varchar(10) — 중량_단위
  • CWT — numeric(12, 3) — 중량_순
  • CBM — numeric(12, 3) — 용적
  • EDI_CommodityItem — varchar(200) — EDI_CommodityItem_품목
  • LCNo — varchar(20) — L/C번호
  • PONo — varchar(200) — P/O번호
  • INVOICENO — varchar(100) — INVOICE번호_N개
  • LicenseDate — datetime — 면허일자
  • LicenseNo — varchar(20) — 면허번호
  • AgentCode — varchar(20) — NOT NULL — 관세사코드
  • CustomsCode — varchar(3) — 세관코드
  • Notice_CurrencyCode — varchar(3) — 신고가격_통화단위
  • Notice_ExRate — numeric(10, 4) — 신고가격_환율
  • Notice_AmountCur — numeric(12, 2) — 신고가격_외화
  • Notice_Amount — numeric(12, 2) — 신고가격
  • Notice_Amount_BL — numeric(18, 2) — 신고가격_BL표기금액
  • CustomsDuties_Ratio — numeric(10, 4) — 관세율
  • CustomsDuties — numeric(12, 2) — 관세
  • Vat_Ratio — numeric(10, 4) — 과세율
  • Vat_Amount — numeric(12, 2) — 과세가격
  • TransportDate — smalldatetime — 운송일자
  • AssignmentCode — varchar(1) — 배정구분
  • AssignmentName — varchar(20) — 배정명_내역
  • AssignmentWH — varchar(10) — 배정창고
  • Remark — varchar(500) — 비고사항_설명
  • RevenueAcctCode — varchar(20) — 매출_정산처코드
  • RevenueCurrency — varchar(3) — 매출_통화단위
  • RevenueExDate — smalldatetime — 매출_환율일자
  • RevenueExRate — numeric(12, 7) — 매출_적용환율
  • ExpenseAcctCode — varchar(20) — 매입_정산처코드
  • ExpenseCurrency — varchar(3) — 매입_통화단위
  • ExpenseExDate — smalldatetime — 매출_환율일자
  • ExpenseExRate — numeric(12, 7) — 매출_적용환율
  • Puncher — varchar(15) — 입력자
  • PuncherDate — smalldatetime — 입력일자
  • BranchCode — varchar(20) — 관리지점
  • ModifyUser — varchar(15) — 수정자
  • ModifyDate — smalldatetime — 수정일자
  • … +57

TCA_BL_Additional

  • JobNo — varchar(20) — Primary key — NOT NULL
  • Remark_Revenue — varchar(450)
  • Remark_Expense — varchar(450)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TCA_BL_ExpenseCharge

  • JobNo — varchar(20) — Primary key — NOT NULL — Job번호
  • SeqNo — int — Primary key — NOT NULL — 순번
  • BoundSystem — varchar(2) — Bound구분_시스템
  • Bound — varchar(2) — Bound구분
  • InvoiceSeqNo — varchar(30) — 이련번호_지출시키록사용
  • InvoiceNo — varchar(20) — 지출번호_지출시기록
  • ChargeType — char(1) — 운임발생구분
  • ChargeCode — varchar(10) — Charge_운임코드
  • ChargeName — varchar(100) — Charge_운임명
  • PC — varchar(1) — P/C구분
  • CurrencyCode — varchar(3) — 통화단위
  • ExRate — numeric(12, 2) — 환율
  • RateType — varchar(10) — 계산구분
  • RateQty — numeric(12, 2) — 계산구분_단가_수량
  • Rate — numeric(12, 2) — Rate_단가
  • AmountCur — numeric(12, 2) — AmountCur_운임외화
  • Amount — numeric(12, 2) — Amount_운임
  • AmountVat — numeric(12, 2) — AmountVat_부가세
  • AmountTotal — numeric(12, 2) — AmountTotal_운임합계
  • AcctCode — varchar(20) — 정산처코드
  • VatYNO — varchar(1) — 부가세YNO
  • AcctForeignYN — varchar(1) — 정산_외화그룹YN
  • AcctPartnerYN — varchar(1) — 정산_파트너정산YN
  • PrePayYN — varchar(1) — 선급여부YN
  • ChargeWeight — numeric(12, 3)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TCA_BL_ExpenseCharge_Estimate

  • JobNo — varchar(20) — Primary key — NOT NULL
  • SeqNo — int — Primary key — NOT NULL
  • ChargeType — char(1)
  • ChargeCode — varchar(10)
  • ChargeName — varchar(100)
  • PC — varchar(1)
  • AC — varchar(1)
  • CurrencyCode — varchar(3)
  • ExRate — numeric(12, 7)
  • RateType — varchar(10)
  • RateQty — numeric(12, 2)
  • Rate — numeric(12, 2)
  • AmountCur — numeric(12, 2)
  • Amount — numeric(12, 2)
  • AmountVat — numeric(12, 2)
  • AmountTotal — numeric(12, 2)
  • AcctCode — varchar(20)
  • Confirm_YN — char(1)
  • Confirm_Attn — varchar(50)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TCA_BL_RevenueCharge

  • JobNo — varchar(20) — Primary key — NOT NULL — Job번호
  • SeqNo — int — Primary key — NOT NULL — 순번
  • BoundSystem — varchar(2) —
  • Bound — varchar(2) — Bound구분
  • InvoiceSeqNo — varchar(30) — 일련번호_청구시키로사용
  • InvoiceNo — varchar(20) — 청구번호_청구시기록
  • ChargeType — char(1) — 운임발생구분
  • ChargeCode — varchar(10) — Charge_운임코드
  • ChargeName — varchar(100) — Charge_운임명
  • PC — varchar(1) — P/C구분
  • AC — varchar(1) — A/C구분
  • CurrencyCode — varchar(3) — 통화단위
  • ExRate — numeric(12, 7) — 환율
  • RateType — varchar(10) — 계산구분
  • RateQty — numeric(12, 2) — 계산구분_단가_수량
  • Rate — numeric(12, 2) — Rate_단가
  • AmountCur — numeric(12, 2) — AmountCur_운임외화
  • Amount — numeric(12, 2) — Amount_운임
  • AmountVat — numeric(12, 2) — AmountVat_부가세
  • AmountTotal — numeric(12, 2) — AmountTotal_운임합계
  • AcctCode — varchar(20) — 정산처코드
  • VatYNO — varchar(1) — 부가세YNO
  • AcctForeignYN — varchar(1) — 정산_외화그룹YN
  • AcctPartnerYN — varchar(1) — 정산_파트너정산YN
  • ChargeWeight — numeric(12, 3)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TCA_BL_RevenueCharge_Estimate

  • JobNo — varchar(20) — Primary key — NOT NULL
  • SeqNo — int — Primary key — NOT NULL
  • ChargeType — char(1)
  • ChargeCode — varchar(10)
  • ChargeName — varchar(100)
  • PC — varchar(1)
  • AC — varchar(1)
  • CurrencyCode — varchar(3)
  • ExRate — numeric(12, 7)
  • RateType — varchar(10)
  • RateQty — numeric(12, 2)
  • Rate — numeric(12, 2)
  • AmountCur — numeric(12, 2)
  • Amount — numeric(12, 2)
  • AmountVat — numeric(12, 2)
  • AmountTotal — numeric(12, 2)
  • AcctCode — varchar(20)
  • Confirm_YN — char(1)
  • Confirm_Attn — varchar(50)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEC_Order

  • Bound — varchar(2) — Primary key — NOT NULL
  • OrderJobNo — varchar(20) — Primary key — NOT NULL
  • ProjectNo — varchar(20)
  • ProjectName — varchar(30)
  • ProjectAttn — varchar(20)
  • ProjectTo — smalldatetime
  • ProjectFrom — smalldatetime
  • ExhibitionPlace — varchar(30)
  • Salesman — varchar(15)
  • CountryCode — varchar(2)
  • OrderState — varchar(20)
  • OrderHBLNo — varchar(20)
  • OrderJobNo_BL — varchar(20)
  • InDate — smalldatetime
  • OutDate — smalldatetime
  • InOut — varchar(50)
  • OrigCode — varchar(5)
  • DestCode — varchar(5)
  • ReturnCode — varchar(5)
  • CustomerCode — varchar(20)
  • CustomerAttn — varchar(20)
  • CustomerEmail — varchar(30)
  • CustomerTel — varchar(20)
  • CustomerCellPhone — varchar(20)
  • PartnerCode — varchar(20)
  • PartnerAttn — varchar(20)
  • PartnerEmail — varchar(30)
  • PartnerTel — varchar(20)
  • PartnerCellPhone — varchar(20)
  • Customs — varchar(10)
  • ItemStatus — varchar(4)
  • DispatchStaff — varchar(20)
  • Remark — varchar(1000)
  • Puncher — varchar(20)
  • PuncherDate — smalldatetime
  • ModifyUser — varchar(20)
  • ModifyDate — smalldatetime
  • BranchCode — varchar(20)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEC_Order_BLInfo

  • Bound — varchar(2) — Primary key — NOT NULL
  • OrderJobNo — varchar(20) — Primary key — NOT NULL
  • BL_OBDate — smalldatetime
  • BL_OBTime — varchar(5)
  • BL_ARDate — smalldatetime
  • BL_ARTime — varchar(5)
  • BL_BookingNo — varchar(30)
  • BL_FreightTerm — varchar(2)
  • BL_PartnerCode — varchar(20)
  • BL_CarrierType — varchar(1)
  • BL_CarrierCode — varchar(20)
  • BL_CarrierAttn — varchar(20)
  • BL_CarrierTel — varchar(30)
  • BL_FlightVesselName — varchar(30)
  • BL_Voyage — varchar(10)
  • BL_LclFcl — varchar(1)
  • BL_ContainerCode_20 — varchar(10)
  • BL_ContainerQty_20 — int
  • BL_ContainerCode_40 — varchar(10)
  • BL_ContainerQty_40 — int
  • BL_ContainerNo — varchar(11)
  • BL_SealNo — varchar(10)
  • BL_Pieces — int
  • BL_PiecesUnit — varchar(10)
  • BL_GWT — numeric(12, 2)
  • BL_CBM — numeric(12, 3)
  • BL_CWT — numeric(12, 2)
  • BL_OrigCode — varchar(5)
  • BL_DestCode — varchar(5)
  • BL_FinalDestCode — varchar(5)
  • BL_CustomsCode — varchar(20)
  • BL_CustomsDepart — varchar(2)
  • BL_CustomsInDate — smalldatetime
  • BL_ClearanceDate — smalldatetime
  • BL_ClearanceAgency_YN — varchar(1)
  • BL_ClearanceNo — varchar(20)
  • BL_CustomsGoodsCode — varchar(5)
  • BL_DV_CustomerCode — varchar(20)
  • BL_TR_CustomerCode — varchar(20)
  • BL_PickUpLoc — varchar(120)
  • BL_CTime — varchar(60)
  • BL_InCY — varchar(60)
  • BL_CustomsRemark — varchar(200)
  • BL_DeliveryDate — smalldatetime
  • BL_Delivery_YN — varchar(1)
  • BL_DeliveryAttn — varchar(20)
  • BL_DeliveryTel — varchar(30)
  • BL_Remark — varchar(500)
  • BL_ClearanceType — varchar(20)
  • BL_Partial_YN — varchar(1)
  • BL_DeclarationDate — smalldatetime
  • BL_LicenseNo — varchar(20)
  • BL_Team — varchar(5)
  • BL_Division — varchar(5)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEC_Order_ES

  • Bound — varchar(2) — Primary key — NOT NULL
  • OrderJobNo — varchar(20) — Primary key — NOT NULL
  • EstimateNo — varchar(20) — Primary key — NOT NULL
  • EstimateDate — smalldatetime
  • ExDate — smalldatetime
  • CurrencyCode — varchar(3)
  • ExRate — numeric(12, 7)
  • Pieces — int
  • CBM — numeric(12, 3)
  • GWT — numeric(12, 2)
  • CWT — numeric(12, 2)
  • ServiceType — varchar(8)
  • ItemCurrency — varchar(3)
  • ItemAmount — numeric(12, 2)
  • Remark — varchar(300)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEC_Order_ESCharge

  • Bound — varchar(2) — Primary key — NOT NULL
  • OrderJobNo — varchar(20) — Primary key — NOT NULL
  • EstimateNo — varchar(20) — Primary key — NOT NULL
  • SeqNo — int — Primary key — NOT NULL
  • InvoiceNo — varchar(20)
  • ChargeType — varchar(12)
  • ChargeCode — varchar(10)
  • ChargeName — varchar(100)
  • CurrencyCode — varchar(3)
  • ExRate — numeric(12, 7)
  • RateType — varchar(10)
  • RateQty — numeric(12, 3)
  • Rate — numeric(14, 4)
  • AmountCur — numeric(12, 2)
  • Amount — numeric(12, 2)
  • AmountVat — numeric(12, 2)
  • AmountTotal — numeric(12, 2)
  • Remark — varchar(100)
  • SortType — varchar(1)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEC_Order_Insurance

  • Bound — varchar(2) — Primary key — NOT NULL
  • OrderJobNo — varchar(20) — Primary key — NOT NULL
  • WriteDate — smalldatetime
  • WriteAttn — varchar(20)
  • InsuranceDate — smalldatetime
  • InsuranceNo — varchar(50)
  • InsuranceCustomerCode — varchar(20)
  • InsuranceCustomerAttn — varchar(20)
  • InsuranceCustomerTel — varchar(30)
  • ContractCode — varchar(20)
  • ContractName — varchar(60)
  • ContractAddress — varchar(60)
  • Customer — varchar(20)
  • ExhibitionAddress — varchar(60)
  • ExhibitionTitle — varchar(20)
  • GoodsOnExbition — varchar(20)
  • InsuranceConditions — varchar(500)
  • TransitRoute — varchar(200)
  • ExhibitionPlace — varchar(30)
  • ExhibitionTo — smalldatetime
  • ExhibitionFrom — smalldatetime
  • InsuranceCurreny — varchar(3)
  • InsuranceValue — numeric(12, 2)
  • MaxiumValuation — int
  • OBDate — smalldatetime
  • FlightVesselName — varchar(30)
  • PackingDeails — varchar(10)
  • LossHistory — varchar(100)
  • AcceptDate — smalldatetime
  • AcceptAttn — varchar(20)
  • ResultDate — smalldatetime
  • ResultAttn — varchar(20)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEC_Order_MF

  • Bound — varchar(2) — Primary key — NOT NULL
  • OrderJobNo — varchar(20) — Primary key — NOT NULL
  • SeqNo — int — Primary key — NOT NULL
  • CustomerName — varchar(20)
  • BoothNo — varchar(4)
  • Pieces — int
  • Package — int
  • Size_L — int
  • Size_W — int
  • Size_H — int
  • CBM — numeric(12, 3)
  • GWT — numeric(12, 2)
  • Item — varchar(20)
  • MoveInDate — smalldatetime
  • Customs — varchar(10)
  • Remark — varchar(100)
  • Disposal — varchar(10)
  • VacuumPacking — varchar(10)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEC_Order_Truck

  • Bound — varchar(2) — Primary key — NOT NULL
  • OrderJobNo — varchar(20) — Primary key — NOT NULL
  • SeqNo — int — Primary key — NOT NULL
  • CustomerName — varchar(20)
  • MoveInDate — smalldatetime
  • Hall — varchar(4)
  • Booth — varchar(4)
  • TruckType — varchar(10)
  • Pieces — int
  • GWT — numeric(12, 2)
  • Size_L — int
  • Size_W — int
  • Size_H — int
  • CBM — numeric(12, 3)
  • Attn — varchar(20)
  • Tel — varchar(20)
  • BoothNo — varchar(4)
  • Remark — varchar(100)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAI_BarCode_Scan

  • RefNo — varchar(20) — Primary key — NOT NULL
  • SeqNo — int — Primary key — NOT NULL
  • Voice_File — varchar(10)
  • Remark1 — varchar(100)
  • Remark2 — varchar(100)
  • ScanDate — datetime
  • PuncherDate — datetime
  • Stock_YN — varchar(1)
  • Delivery — varchar(4)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAI_Bonded

  • RefNo — varchar(20) — Primary key — NOT NULL
  • BodMRN — varchar(11) — NOT NULL
  • BodMSN — varchar(4) — NOT NULL
  • BodBLNo — varchar(20) — NOT NULL
  • AssignmentWH — varchar(10)
  • Customs — varchar(3)
  • CustomsDepart — varchar(2)
  • BodDate — smalldatetime
  • ShipperCode — varchar(20)
  • ShipperName — varchar(100)
  • ShipperAddress — varchar(60)
  • ShipperAddressA — varchar(60)
  • ShipperAddressB — varchar(60)
  • ShipperAddressC — varchar(60)
  • ShipperAddressD — varchar(60)
  • ShipperBusinessID — varchar(20)
  • ConsigneeCode — varchar(20)
  • ConsigneeName — varchar(100)
  • ConsigneeAddress — varchar(60)
  • ConsigneeAddressA — varchar(60)
  • ConsigneeAddressB — varchar(60)
  • ConsigneeAddressC — varchar(60)
  • ConsigneeAddressD — varchar(60)
  • ConsigneeBusinessID — varchar(20)
  • Verification — varchar(1)
  • BOD_SendType — varchar(10)
  • BOD_SendDateTime — varchar(20)
  • BOD_SendAttn — varchar(15)
  • BOD_RecvType — varchar(10)
  • BOD_RecvDateTime — varchar(20)
  • BOD_RecvAttn — varchar(15)
  • BOD_ResultType — varchar(10)
  • BOD_ResultDateTime — varchar(20)
  • BOD_ResultAttn — varchar(15)
  • Last_SendType — varchar(10)
  • Last_SendDateTime — varchar(20)
  • Puncher — varchar(15)
  • PuncherDate — smalldatetime
  • ModifyUser — varchar(15)
  • ModifyDate — smalldatetime
  • BodHSN — varchar(4)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAI_Bonded_Detail

  • RefNo — varchar(20) — Primary key — NOT NULL
  • SubMRN — varchar(11) — NOT NULL
  • SubMSN — varchar(4) — NOT NULL
  • SubHSN — varchar(4)
  • SubBLNo — varchar(20) — NOT NULL
  • MRefNo — varchar(20) — NOT NULL
  • SpecialCargo — varchar(3)
  • CommodityItem — varchar(200)
  • CiDate — smalldatetime
  • CiPieces — int
  • CiGWT — numeric(16, 3)
  • StPieces — int
  • StGWT — numeric(16, 3)
  • CoPieces — int
  • CoGWT — numeric(16, 3)
  • Puncher — varchar(15)
  • PuncherDate — smalldatetime
  • ModifyUser — varchar(15)
  • ModifyDate — smalldatetime
  • ShipperAdd_ZipCode — varchar(6)
  • ShipperAdd_RoadCode — varchar(12)
  • ShipperAdd_BuildingNo — varchar(25)
  • Consignee_ZipCode — varchar(6)
  • Consignee_RoadCode — varchar(12)
  • Consignee_BuildingNo — varchar(25)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAI_CS_Main

  • RefNo — varchar(20) — Primary key — NOT NULL
  • Puncher — varchar(15)
  • PuncherDate — smalldatetime
  • ModifyUser — varchar(15)
  • Modifydate — smalldatetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAI_CS_Sub

  • RefNo — varchar(20) — Primary key — NOT NULL
  • SeqNo — int — Primary key — NOT NULL
  • Puncher — varchar(15)
  • PuncherDate — smalldatetime
  • CSType — varchar(10)
  • CSContents — varchar(1000)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAI_CUSTOMS_HBL

  • RefNo — varchar(26) — Primary key — NOT NULL
  • HBLNo — varchar(20) — NOT NULL
  • MBLNo — varchar(20)
  • MRefNo — varchar(20)
  • HSN — varchar(4)
  • Pieces — numeric(10, 0)
  • RealPieces — numeric(10, 0)
  • GWT — numeric(16, 3)
  • CommodityItem — varchar(200)
  • AssignmentWH — varchar(10)
  • ElectronicYN — varchar(1)
  • CheckReqYN — varchar(1)
  • SelectGoods — varchar(10)
  • HoldNotice — varchar(10)
  • CustomsUseType — varchar(1)
  • CurrencyCode — varchar(3)
  • AmountCur — numeric(16, 2)
  • CountryCode — varchar(2)
  • Special_ShipperCode — varchar(20)
  • FWDCode — varchar(10)
  • ShipperCode — varchar(20)
  • ShipperName — varchar(100)
  • ShipperAddress — varchar(60)
  • ShipperAddressA — varchar(60)
  • ShipperAddressB — varchar(60)
  • ShipperAddressC — varchar(60)
  • ShipperAddressD — varchar(60)
  • ConsigneeCode — varchar(20)
  • ConsigneeName — varchar(100)
  • ConsigneeAddress — varchar(60)
  • ConsigneeAddressA — varchar(60)
  • ConsigneeAddressB — varchar(60)
  • ConsigneeAddressC — varchar(60)
  • ConsigneeAddressD — varchar(60)
  • ConsigneeTel — varchar(40)
  • Auto_CreateType — varchar(20)
  • Auto_CreateDateTime — varchar(20)
  • Auto_CreateAttn — varchar(15)
  • Puncher — varchar(15)
  • PuncherDate — smalldatetime
  • ModifyUser — varchar(15)
  • ModifyDate — smalldatetime
  • ElectronicURL — varchar(100)
  • ItemCode — varchar(6)
  • AllowExc — varchar(10)
  • DeliveryDate — datetime
  • DeliveryBusinessCode — varchar(20)
  • DeliveryBusiness — varchar(100)
  • ConsigneeAddress_A — varchar(200)
  • DeliveryRemark — varchar(200)
  • Delivery_SendType — varchar(10)
  • Delivery_SendDateTime — datetime
  • Delivery_SendAttn — varchar(15)
  • ConsigneeZipcode — varchar(10)
  • CarrierID — varchar(6)
  • CRefNo — numeric(12, 0)
  • ClearanceYN — varchar(10)
  • SelectGoods_Code — varchar(10)
  • HoldNotice_Code — varchar(10)
  • Result_RecvDateTime — datetime
  • … +36

TEDAI_CUSTOMS_HBL_GoodsItem

  • RefNo — varchar(26) — Primary key — NOT NULL
  • SeqNo — int — Primary key — NOT NULL
  • Description — varchar(200)
  • Grade — varchar(100)
  • NumberID — varchar(2) — NOT NULL
  • Amount — numeric(16, 2)
  • Pieces — numeric(12, 0)
  • PiecesUnit — varchar(3)
  • ItemCode — varchar(5)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAI_CUSTOMS_HBL_PONo

  • RefNo — varchar(26) — Primary key — NOT NULL
  • SeqNo — int — Primary key — NOT NULL
  • PONo — varchar(35)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAI_CUSTOMS_MBL

  • RefNo — varchar(20) — Primary key — NOT NULL
  • RefNo_Doc — varchar(16) — NOT NULL
  • MRN — varchar(11)
  • MSN — varchar(4)
  • MBLNo — varchar(20) — NOT NULL
  • AirLineCode — varchar(20)
  • AirlineUserCode — varchar(20)
  • AirlineCustomerID — varchar(20)
  • FlightNo — varchar(10)
  • DeclareDate — smalldatetime
  • ARDate — smalldatetime
  • OrigCode — varchar(5)
  • Sendflag — varchar(1)
  • AssignmentWH — varchar(10)
  • Customs — varchar(3)
  • CustomsDepart — varchar(2)
  • Remark — varchar(500)
  • Verification — varchar(1)
  • RecvDocType — varchar(3)
  • Customs_SendType — varchar(10)
  • Customs_SendDateTime — varchar(20)
  • Customs_SendAttn — varchar(15)
  • Customs_RecvType — varchar(10)
  • Customs_RecvDateTime — varchar(20)
  • Customs_RecvAttn — varchar(15)
  • Customs_ResultType — varchar(10)
  • Customs_ResultDateTime — varchar(20)
  • Customs_ResultAttn — varchar(15)
  • Auto_CreateType — varchar(20)
  • Auto_CreateDateTime — varchar(20)
  • Auto_CreateAttn — varchar(15)
  • Last_SendType — varchar(10)
  • Last_SendDateTime — varchar(20)
  • Puncher — varchar(15)
  • PuncherDate — smalldatetime
  • ModifyUser — varchar(15)
  • ModifyDate — smalldatetime
  • SingleYN — char(1)
  • Delivery_RefNo — varchar(20)
  • Delivery_RecvType — varchar(10)
  • Delivery_RecvDateTime — datetime
  • CommodityAttn — nvarchar(35)
  • XRayAttnA — nvarchar(35)
  • XRayAttnB — nvarchar(35)
  • XRayAttnC — nvarchar(35)
  • XRayAttnD — nvarchar(35)
  • ClearanceAttn — nvarchar(35)
  • CustomsStatusCode — varchar(5)
  • GW_SendType — varchar(10)
  • GW_SendDateTime — varchar(20)
  • GW_SendAttn — varchar(15)
  • ARDate_GW — varchar(20)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAI_ChargeInfo

  • RefNo — varchar(20) — Primary key — NOT NULL
  • Duty_Amount — numeric(12, 2)
  • Vat_Amount — numeric(12, 2)
  • ETC_Amount — numeric(12, 2)
  • Customs_Amount — numeric(12, 2)
  • Quarantine_Amount — numeric(12, 2)
  • Collect_Amount — numeric(12, 2)
  • Collect_Date — smalldatetime
  • ExchangeRate_Amount — numeric(12, 2)
  • Fare_Amount — numeric(12, 2)
  • CIF_Amount — numeric(12, 2)
  • SpecialExcise_Amount — numeric(12, 2)
  • Liquor_Amount — numeric(12, 2)
  • Education_Amount — numeric(12, 2)
  • RuralDevelopment_Amount — numeric(12, 2)
  • Tax_Proxy — varchar(1)
  • Fee_Charge — numeric(12, 2)
  • Licnesee — varchar(1)
  • Food_Claim — varchar(1)
  • Quarantine — varchar(1)
  • Division_Disposal — varchar(1)
  • Overseas_Charge — varchar(1)
  • Remark — varchar(200)
  • Collect_YN — varchar(1)
  • Wh_Amount — numeric(12, 2)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAI_ChargeInfo_ETC

  • RefNo — varchar(20) — Primary key — NOT NULL
  • SeqNo — int — Primary key — NOT NULL
  • ChargeDate — smalldatetime
  • ChargeCode — varchar(20)
  • Amount — numeric(12, 2)
  • PuncherName — varchar(50)
  • CsutomerName — varchar(20)
  • CostAmount — numeric(12, 2)
  • AccountType — varchar(10)
  • Remark — varchar(50)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAI_CommodityItem

  • Description — varchar(200) — Primary key — NOT NULL
  • ItemCode — varchar(6)
  • CustomsTypeA — int
  • CustomsTypeB — int
  • CustomsTypeC — int
  • CustomsTypeD — int
  • CustomsTypeE — int
  • Etc1 — varchar(1)
  • Etc2 — varchar(1)
  • Etc3 — varchar(1)
  • Etc4 — varchar(1)
  • Etc5 — varchar(1)
  • ModifyDate — datetime
  • ModifyUser — varchar(15)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAI_HBL

  • RefNo — varchar(20) — Primary key — NOT NULL
  • HBLNo — varchar(20) — NOT NULL
  • MBLNo — varchar(20)
  • MRefNo — varchar(20)
  • BLTypeIE — varchar(1)
  • HSN — varchar(4)
  • EDIFlag — varchar(1)
  • Pieces — numeric(10, 0)
  • RealPieces — numeric(10, 0)
  • GWT — numeric(16, 3)
  • CommodityItem — varchar(200)
  • AssignmentCode — varchar(1)
  • AssignmentName — varchar(20)
  • AssignmentWH — varchar(10)
  • AssignmentWH_T — varchar(10)
  • DOSendYN — varchar(1)
  • DONumber — varchar(18)
  • ElectronicYN — varchar(1)
  • CustomsUseType — varchar(1)
  • CurrencyCode — varchar(3)
  • AmountTotal — numeric(16, 2)
  • CustomsTypeYN — varchar(1)
  • FWDCode — varchar(10)
  • Remark — varchar(500)
  • ShipperCode — varchar(20)
  • ShipperName — varchar(100)
  • ShipperAddress — varchar(60)
  • ShipperAddressA — varchar(60)
  • ShipperAddressB — varchar(60)
  • ShipperAddressC — varchar(60)
  • ShipperAddressD — varchar(60)
  • ShipperTel — varchar(40)
  • ShipperFax — varchar(20)
  • ShipperBusinessID — varchar(20)
  • ShipperZipcode — varchar(10)
  • ShipperCountryCode — varchar(2)
  • ShipperState — varchar(9)
  • ShipperCity — varchar(5)
  • ConsigneeCode — varchar(20)
  • ConsigneeName — varchar(100)
  • ConsigneeAddress — varchar(60)
  • ConsigneeAddressA — varchar(60)
  • ConsigneeAddressB — varchar(60)
  • ConsigneeAddressC — varchar(60)
  • ConsigneeAddressD — varchar(60)
  • ConsigneeTel — varchar(40)
  • ConsigneeFax — varchar(20)
  • ConsigneeBusinessID — varchar(20)
  • ConsigneeZipcode — varchar(10)
  • ConsigneeCountryCode — varchar(2)
  • ConsigneeState — varchar(9)
  • ConsigneeCity — varchar(5)
  • NotifyCode — varchar(20)
  • NotifyName — varchar(100)
  • NotifyAddress — varchar(60)
  • NotifyAddressA — varchar(60)
  • NotifyAddressB — varchar(60)
  • NotifyAddressC — varchar(60)
  • NotifyAddressD — varchar(60)
  • NotifyTel — varchar(40)
  • … +129

TEDAI_HBL_Additional

  • RefNo — varchar(20) — Primary key — NOT NULL
  • IR_IRRECode — varchar(3)
  • IR_Pieces — numeric(10, 0)
  • IR_GWT — numeric(16, 3)
  • IR_DischargingPort — varchar(3)
  • IR_SendDateTime — varchar(30)
  • IR_Pieces_2 — int
  • IR_GWT_2 — numeric(13, 3)
  • IR_ARDate — datetime
  • IR_MRN — varchar(20)
  • IR_MSN — varchar(4)
  • WebCustomerCode — varchar(20)
  • CustomsDate — datetime
  • CNameError_YN — varchar(1)
  • CommodityError_YN — varchar(1)
  • CNameWarning_YN — varchar(100)
  • CommodityWarning_YN — varchar(1)
  • CAddrError_YN — varchar(1)
  • CAddrWarning_YN — varchar(1)
  • ErrorDesc — varchar(500)
  • C_ReceiveDate — datetime
  • C_ConfirmDate — datetime
  • D_ReceiveDate — datetime
  • D_ConfirmDate — datetime
  • D_ChangeDate — datetime
  • C_NotReceiveDate — datetime
  • D_NotReceiveDate — datetime
  • C_NotReceiveRemark — varchar(100)
  • D_NotReceiveRemark — varchar(100)
  • D_ChangeBLNo — varchar(200)
  • PONo — varchar(60)
  • FrtDvCd — varchar(2)
  • DeliveryPayment — numeric(12, 2)
  • CustomsTypeGW_Contents — varchar(200)
  • DimWidth — numeric(6, 1)
  • DimLength — numeric(6, 1)
  • DimHeight — numeric(6, 1)
  • ChangeDeliveryCode — varchar(20)
  • eTradeType — varchar(1)
  • PurChaseAgencyName — varchar(150)
  • OverseasSellerNo — varchar(9)
  • OverseasSellerName — varchar(150)
  • SalseBrokerNo — varchar(9)
  • SalseBrokerName — varchar(150)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAI_HBL_CheckSeq

  • RefNo — varchar(20) — Primary key — NOT NULL
  • CheckSeqNo — int — Primary key — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAI_HBL_DAX

  • RefNo — varchar(20) — Primary key — NOT NULL
  • SeqNo — int — Primary key — NOT NULL
  • Type_DAX — varchar(1)
  • ARDate — datetime
  • FlightNo — varchar(7)
  • OrigCode — varchar(5)
  • Description — varchar(200)
  • Pieces — numeric(10, 0)
  • GWT — numeric(16, 3)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAI_HBL_EMS

  • RefNo — varchar(20) — Primary key — NOT NULL
  • EmsTypeCode — varchar(1)
  • GoodsDivision — varchar(3)
  • GoodsTypeCode — varchar(2)
  • EMS_No — varchar(13)
  • ShipperName — varchar(35)
  • ShipperAddress — varchar(140)
  • ShipperAddressA — varchar(140)
  • ShipperZipCode — varchar(20)
  • ShipperCountryCode — varchar(2)
  • ShipperTel_A — varchar(4)
  • ShipperTel_B — varchar(4)
  • ShipperTel_C — varchar(4)
  • ShipperTel — varchar(40)
  • ShipperEmail — varchar(40)
  • ShipperHP1 — varchar(20)
  • ShipperHP2 — varchar(20)
  • ShipperHP3 — varchar(20)
  • ConsigneeName — varchar(35)
  • ConsigneeAddress — varchar(300)
  • ConsigneeZipCode — varchar(20)
  • ConsigneeCountryCode — varchar(2)
  • ConsigneeCity — varchar(200)
  • ConsigneeState — varchar(140)
  • ConsigneeTel_A — varchar(4)
  • ConsigneeTel_B — varchar(4)
  • ConsigneeTel_C — varchar(4)
  • ConsigneeTel — varchar(40)
  • ConsigneeEmail — varchar(40)
  • ConsigneeHP1 — varchar(20)
  • ConsigneeHP2 — varchar(20)
  • ConsigneeHP3 — varchar(20)
  • GWT — numeric(12, 2)
  • InsureYN — varchar(1)
  • InsureAmount — numeric(12, 2)
  • EMS_SendType — varchar(10)
  • EMS_SendDateTime — datetime
  • ConcurrentPackagingID — varchar(20)
  • Bound — varchar(2)
  • EMS_SendFlag — varchar(1)
  • Order_No — varchar(50)
  • Office_Seq — varchar(50)
  • ConsigneeTel_full — varchar(40)
  • PONo — varchar(60)
  • DeliveryCenterCode — varchar(3)
  • InTransit_YN — varchar(1)
  • Exception — varchar(10)
  • EMS_SendAttn — varchar(15)
  • ContractClass — varchar(2)
  • CustomsDeclarRemark — varchar(100)
  • EMS_Width — numeric(12, 2)
  • EMS_Length — numeric(12, 2)
  • EMS_Height — numeric(12, 2)
  • VolumnExcluded_YN — varchar(1)
  • TaxIdNo — varchar(50)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAI_HBL_EMSGoodsItem

  • RefNo — varchar(20) — Primary key — NOT NULL
  • SeqNo — int — Primary key — NOT NULL
  • CommodityItem — varchar(200)
  • Pieces — int
  • GWT — numeric(12, 2)
  • Amount — numeric(12, 2)
  • HSCode — varchar(20)
  • Origin — varchar(2)
  • CurrencyCode — varchar(3)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAI_HBL_GoodsItem

  • RefNo — varchar(20) — Primary key — NOT NULL
  • SeqNo — int — Primary key — NOT NULL
  • Description — varchar(200)
  • Grade — varchar(100)
  • NumberID — varchar(2) — NOT NULL
  • Amount — numeric(16, 2)
  • Pieces — numeric(12, 0)
  • PiecesUnit — varchar(3)
  • ItemCode — varchar(5)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAI_HBL_HJTC

  • RefNo — varchar(20) — Primary key — NOT NULL
  • HBLNo_Origin — varchar(20)
  • SelectGoods_WCH — varchar(2)
  • SelectGoods_WCHDate — datetime
  • SelectGoods_WCH_W — varchar(2)
  • SelectGoods_WCHDate_W — datetime
  • Check_A — varchar(1)
  • Check_B — varchar(1)
  • Check_C — varchar(1)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAI_HBL_IRREStock

  • RefNo — int — Primary key — NOT NULL
  • PuncherDate — datetime
  • HblFrom — varchar(12)
  • HblTo — varchar(12)
  • Count — int
  • Used — int
  • NotUsed — int
  • CurrentNo — varchar(12)
  • BranchCode — varchar(20)
  • Puncher — varchar(15)
  • UseYN — varchar(1)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAI_HBL_Multi

  • RefNo — varchar(20) — Primary key — NOT NULL
  • SeqNo — int — Primary key — NOT NULL
  • Multi_HBLNo — varchar(20)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAI_HBL_PONo

  • RefNo — varchar(20) — Primary key — NOT NULL
  • SeqNo — int — Primary key — NOT NULL
  • PONo — varchar(35)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAI_HBL_ReasonDesc

  • RefNo — varchar(20) — Primary key — NOT NULL
  • ReasonCode — varchar(10) — Primary key — NOT NULL
  • ReasonText — varchar(100)
  • PuncherDate — datetime
  • ModifyDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAI_HBL_Status

  • RefNo — varchar(30) — Primary key — NOT NULL
  • SeqNo — int — Primary key — NOT NULL
  • Type — varchar(1) — Primary key — NOT NULL
  • Puncher — varchar(30)
  • PuncherDate — datetime
  • Etc1 — varchar(10)
  • Etc2 — varchar(10)
  • Etc3 — varchar(10)
  • Etc4 — varchar(10)
  • Etc5 — varchar(10)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAI_HBL_Tracing

  • RefNo — varchar(20) — Primary key — NOT NULL
  • SeqNo — int — Primary key — NOT NULL
  • OrderNo — varchar(30)
  • EventType — varchar(40)
  • EventCode — varchar(3)
  • EventDateTime — datetime
  • PuncherDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAI_MBL

  • RefNo — varchar(20) — Primary key — NOT NULL
  • MRN — varchar(11)
  • MSN — varchar(4)
  • MBLNo — varchar(20) — NOT NULL
  • MDischarge — varchar(10)
  • AirLineCode — varchar(20)
  • AirlineUserCode — varchar(20)
  • AirlineCustomerID — varchar(20)
  • FlightNo — varchar(10)
  • OBDate — smalldatetime
  • ARDate — smalldatetime
  • OrigCode — varchar(5)
  • DestCode — varchar(5)
  • Verification — varchar(1)
  • VerificationDO — varchar(1)
  • MF_SendType — varchar(10)
  • MF_SendDateTime — varchar(20)
  • MF_SendAttn — varchar(15)
  • DO_SendType — varchar(10)
  • DO_SendDateTime — varchar(20)
  • DO_SendAttn — varchar(15)
  • GW_SendType — varchar(10)
  • GW_SendDateTime — varchar(20)
  • GW_SendAttn — varchar(15)
  • Auto_CreateType — varchar(10)
  • Auto_CreateDateTime — varchar(20)
  • Auto_CreateAttn — varchar(15)
  • Customs_CreateType — varchar(10)
  • Customs_CreateDateTime — varchar(20)
  • Customs_CreateAttn — varchar(15)
  • Last_SendType — varchar(10)
  • Last_SendDateTime — varchar(20)
  • Puncher — varchar(15)
  • PuncherDate — smalldatetime
  • ModifyUser — varchar(15)
  • ModifyDate — smalldatetime
  • VerificationDC — char(1)
  • DC_SendType — varchar(10)
  • DC_SendDateTime — varchar(20)
  • DC_SendAttn — varchar(15)
  • BranchCode — varchar(20)
  • VerificationFHL — varchar(1)
  • FHL_SendType — varchar(10)
  • FHL_SendDateTime — datetime
  • FHL_SendAttn — varchar(15)
  • EdiHost — varchar(10)
  • MDischarge_Item — varchar(2)
  • JobStatus — varchar(10)
  • Customs_RefNo — varchar(16)
  • Customs — varchar(3)
  • CustomsDepart — varchar(2)
  • DeclareDate — datetime
  • AssignmentWH — varchar(10)
  • SingleYN — varchar(1)
  • Verification_Customs — varchar(1)
  • Customs_SendType — varchar(10)
  • Customs_SendDateTime — varchar(20)
  • Customs_SendAttn — varchar(15)
  • Customs_RecvType — varchar(10)
  • Customs_RecvDateTime — varchar(20)
  • … +47

TEDAI_MOD_HBL

  • RefNo — varchar(20) — Primary key — NOT NULL
  • HSN — varchar(4)
  • HBLNo — varchar(20) — NOT NULL
  • MBLNo — varchar(20) — NOT NULL
  • MRefNo — varchar(20) — NOT NULL
  • ModiCode — varchar(1)
  • ModiReason — varchar(40)
  • BLTypeIE — varchar(1)
  • Pieces — int
  • PiecesUnit — varchar(20)
  • GWT — numeric(16, 3)
  • AssignmentWH — varchar(10)
  • DestCode — varchar(5)
  • HSCode — varchar(6)
  • CommodityItem — varchar(200)
  • ShipperCode — varchar(20)
  • ShipperName — varchar(100)
  • ShipperAddress — varchar(60)
  • ShipperAddressA — varchar(60)
  • ShipperAddressB — varchar(60)
  • ShipperAddressC — varchar(60)
  • ShipperAddressD — varchar(60)
  • ShipperTel — varchar(40)
  • ShipperFax — varchar(20)
  • ShipperBusinessID — varchar(20)
  • ShipperZipCode — varchar(10)
  • ShipperCountryCode — varchar(2)
  • ShipperState — varchar(2)
  • ShipperCity — varchar(5)
  • ConsigneeCode — varchar(20)
  • ConsigneeName — varchar(100)
  • ConsigneeAddress — varchar(60)
  • ConsigneeAddressA — varchar(60)
  • ConsigneeAddressB — varchar(60)
  • ConsigneeAddressC — varchar(60)
  • ConsigneeAddressD — varchar(60)
  • ConsigneeTel — varchar(40)
  • ConsigneeFax — varchar(20)
  • ConsigneeBusinessID — varchar(20)
  • ConsigneeZipcode — varchar(10)
  • ConsigneeCountryCode — varchar(2)
  • ConsigneeState — varchar(2)
  • ConsigneeCity — varchar(5)
  • NotifyCode — varchar(20)
  • NotifyName — varchar(100)
  • NotifyAddress — varchar(60)
  • NotifyAddressA — varchar(60)
  • NotifyAddressB — varchar(60)
  • NotifyAddressC — varchar(60)
  • NotifyAddressD — varchar(60)
  • NotifyTel — varchar(40)
  • NotifyFax — varchar(20)
  • NotifyBusinessID — varchar(20)
  • NotifyZipCode — varchar(10)
  • NotifyCountryCode — varchar(2)
  • NotifyState — varchar(2)
  • NotifyCity — varchar(5)
  • Puncher — varchar(15)
  • PuncherDate — smalldatetime
  • ModifyUser — varchar(15)
  • … +12

TEDAI_MOD_HBL_BaseSingle

  • RefNo — varchar(20) — Primary key — NOT NULL
  • SeqNo — int — Primary key — NOT NULL
  • ModiCode — varchar(3)
  • ModiReason — varchar(40)
  • BeforeModiDecs — varchar(200)
  • AfterModiDecs — varchar(200)
  • ModiCodeIndex — int
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAI_MOD_MBL

  • RefNo — varchar(20) — Primary key — NOT NULL
  • MRN — varchar(11) — NOT NULL
  • ModifySerialNo — varchar(4) — NOT NULL
  • MSN — varchar(4)
  • MBLNO — varchar(20) — NOT NULL
  • DeclarerDate — smalldatetime
  • Customs — varchar(3)
  • CustomsDepart — varchar(2)
  • Verification — varchar(1)
  • MOD_SendType — varchar(10)
  • MOD_SendDateTime — varchar(20)
  • MOD_SendAttn — varchar(15)
  • MOD_RecvType — varchar(10)
  • MOD_RecvDateTime — varchar(20)
  • MOD_RecvAttn — varchar(15)
  • MOD_ResultType — varchar(10)
  • MOD_ResultDateTime — varchar(20)
  • MOD_ResultAttn — varchar(15)
  • Last_SendType — varchar(10)
  • Last_SendDateTime — varchar(20)
  • Puncher — varchar(15)
  • PuncherDate — smalldatetime
  • ModifyUser — varchar(50)
  • Modifydate — smalldatetime
  • EdiHost — varchar(10)
  • SendAirline_YN — char(1)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAI_ManifestClearanceList

  • RefNo — varchar(20) — Primary key — NOT NULL
  • UserID — varchar(15) — Primary key — NOT NULL
  • ResultMessage — varchar(500)
  • HBLNo — varchar(20)
  • Pieces — numeric(10, 0)
  • GWT — numeric(16, 3)
  • AmountTotal — numeric(16, 2)
  • CustomsTypeYN — varchar(1)
  • CheckReqYN — varchar(1)
  • CustomsUseType — varchar(1)
  • ElectronicYN — varchar(1)
  • CommodityItem — varchar(200)
  • ITEMCODE — varchar(5)
  • SubMBLNo — varchar(255)
  • ConsigneeName — varchar(100)
  • ConsigneeAddress — varchar(255)
  • pCustomsNumber — varchar(20)
  • ConsigneeTel — varchar(40)
  • ShipperName — varchar(100)
  • ShipperAddress — varchar(255)
  • ShipperTel — varchar(40)
  • ElectronicURL — varchar(100)
  • ShipperCountryCode — varchar(2)
  • DestCode — varchar(5)
  • BLTypeIE — varchar(1)
  • DocYN — varchar(1)
  • LCNo — varchar(20)
  • OffenderYN — varchar(1)
  • FineYN — varchar(1)
  • MBLNo — varchar(20)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAI_PART_MAIN

  • RefNo — varchar(20) — Primary key — NOT NULL
  • AWBNO — varchar(20) — NOT NULL
  • MRN — varchar(11) — NOT NULL
  • MSN — varchar(4) — NOT NULL
  • HSN — varchar(4)
  • InputDate — smalldatetime
  • WorkType — varchar(1)
  • DeclareNo — varchar(3)
  • CarryType — varchar(1)
  • MDischarge — varchar(10)
  • Customs — varchar(3)
  • CustomsDepart — varchar(2)
  • ReqReason — varchar(50)
  • ReqPersonCode — varchar(20)
  • ReqPersonName — varchar(100)
  • ReqPersonTel — varchar(20)
  • Verification — varchar(1)
  • PART_SendType — varchar(10)
  • PART_SendDateTime — varchar(20)
  • PART_SendAttn — varchar(15)
  • PART_RecvType — varchar(10)
  • PART_RecvDateTime — varchar(20)
  • PART_RecvAttn — varchar(15)
  • PART_ResultType — varchar(10)
  • PART_ResultDateTime — varchar(20)
  • PART_ResultAttn — varchar(15)
  • Last_SendType — varchar(10)
  • Last_SendDateTime — varchar(20)
  • Puncher — varchar(15)
  • PuncherDate — smalldatetime
  • ModifyUser — varchar(50)
  • Modifydate — smalldatetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAI_PART_SUB

  • RefNo — varchar(20) — Primary key — NOT NULL
  • AWBNo — varchar(20) — NOT NULL
  • MRefNo — varchar(20) — NOT NULL
  • HSN — varchar(4)
  • Pieces — int
  • PiecesUnit — varchar(20)
  • GWT — numeric(16, 3)
  • ConsigneeCode — varchar(20)
  • ConsigneeName — varchar(100)
  • ConsigneeAddress — varchar(60)
  • ConsigneeAddressA — varchar(60)
  • ConsigneeAddressB — varchar(60)
  • ConsigneeAddressC — varchar(60)
  • ConsigneeAddressD — varchar(60)
  • ConsigneeTel — varchar(40)
  • ConsigneeFax — varchar(20)
  • ConsigneeBusinessID — varchar(20)
  • ConsigneeZipcode — varchar(10)
  • ConsigneeCountryCode — varchar(2)
  • ConsigneeState — varchar(2)
  • ConsigneeCity — varchar(3)
  • Puncher — varchar(15)
  • PuncherDate — smalldatetime
  • ModifyUser — varchar(15)
  • ModifyDate — smalldatetime
  • Consignee_ZipCode — varchar(6)
  • Consignee_RoadCode — varchar(12)
  • Consignee_BuildingNo — varchar(25)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAO_CUSTOMS_HBL

  • RefNo — varchar(26) — Primary key — NOT NULL
  • HBLNo — varchar(20) — NOT NULL
  • MBLNo — varchar(20)
  • MRefNo — varchar(20)
  • RefNo_Doc — varchar(20)
  • Pieces — numeric(10, 0)
  • GWT — numeric(16, 3)
  • CommodityItem — varchar(200)
  • SendYN — varchar(1)
  • CurrencyCode — varchar(3)
  • ExRate — numeric(12, 2)
  • Amount — numeric(18, 2)
  • AmountCur — numeric(18, 2)
  • ShipperCode — varchar(20)
  • ShipperName — varchar(100)
  • ShipperAddress — varchar(60)
  • ShipperAddressA — varchar(60)
  • ShipperAddressB — varchar(60)
  • ShipperAddressC — varchar(60)
  • ShipperAddressD — varchar(60)
  • ConsigneeCode — varchar(20)
  • ConsigneeName — varchar(100)
  • ConsigneeAddress — varchar(60)
  • ConsigneeAddressA — varchar(60)
  • ConsigneeAddressB — varchar(60)
  • ConsigneeAddressC — varchar(60)
  • ConsigneeAddressD — varchar(60)
  • RecvDocType — varchar(3)
  • Customs_SendType — varchar(10)
  • Customs_SendDateTime — varchar(20)
  • Customs_SendAttn — varchar(15)
  • Customs_RecvType — varchar(10)
  • Customs_RecvDateTime — varchar(20)
  • Customs_RecvAttn — varchar(15)
  • Customs_ResultType — varchar(10)
  • Customs_ResultDateTime — varchar(20)
  • Customs_ResultAttn — varchar(15)
  • Auto_CreateType — varchar(20)
  • Auto_CreateDateTime — varchar(20)
  • Auto_CreateAttn — varchar(15)
  • Last_SendType — varchar(10)
  • Last_SendDateTime — varchar(20)
  • Puncher — varchar(15)
  • PuncherDate — smalldatetime
  • ModifyUser — varchar(15)
  • ModifyDate — smalldatetime
  • CheckReqYN — char(1)
  • CheckResult — char(2)
  • ElectronicYn — varchar(1)
  • ItemCode — varchar(10)
  • ShipperBusinessID — varchar(20)
  • ShipperType — varchar(2)
  • PiecesUnit — varchar(20)
  • RealPieces — int
  • CustomsStatusCode — varchar(5)
  • DestCode — varchar(5)
  • ShipperCountryCode — varchar(2)
  • DocProcessStatus — varchar(2)
  • OrigCode_H — varchar(5)
  • Customs_H — varchar(3)
  • … +10

TEDAO_CUSTOMS_HBL_Additional

  • RefNo — varchar(26) — Primary key — NOT NULL
  • ShipperAdd_Line — varchar(150)
  • ShipperAdd_ZipCode — varchar(6)
  • ShipperAdd_RoadCode — varchar(12)
  • ShipperAdd_BuildingNo — varchar(25)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAO_CUSTOMS_MBL

  • RefNo — varchar(20) — Primary key — NOT NULL
  • MBLNo — varchar(20) — NOT NULL
  • AirLineCode — varchar(20)
  • AirlineUserCode — varchar(20)
  • AirlineCustomerID — varchar(20)
  • FlightNo — varchar(10)
  • DeclareDate — smalldatetime
  • OBDate — smalldatetime
  • OBTime — varchar(5)
  • CountryCode — varchar(2)
  • DestCode — varchar(5)
  • OutReason — varchar(2)
  • DeclareType — varchar(1)
  • Customs — varchar(3)
  • CustomsDepart — varchar(2)
  • Remark — varchar(500)
  • Verification — varchar(1)
  • SendFlag — varchar(1)
  • Customs_SendType — varchar(10)
  • Customs_SendDateTime — varchar(20)
  • Customs_SendAttn — varchar(15)
  • Customs_RecvType — varchar(10)
  • Customs_RecvDateTime — varchar(20)
  • Customs_RecvAttn — varchar(15)
  • Customs_ResultType — varchar(10)
  • Customs_ResultDateTime — varchar(20)
  • Customs_ResultAttn — varchar(15)
  • Auto_CreateType — varchar(20)
  • Auto_CreateDateTime — varchar(20)
  • Auto_CreateAttn — varchar(15)
  • Last_SendType — varchar(10)
  • Last_SendDateTime — varchar(20)
  • Puncher — varchar(15)
  • PuncherDate — smalldatetime
  • ModifyUser — varchar(15)
  • ModifyDate — smalldatetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAO_ExportNo

  • RefNoID — numeric(12, 0)
  • 1) — NOT — NOT NULL
  • HBLNo — varchar(20)
  • LicenseNo — varchar(20)
  • LicenseDate — datetime
  • MBLNo — varchar(20)
  • OBDate — datetime
  • CarryInDate — datetime
  • Pieces — int
  • Unit — varchar(10)
  • Weight — numeric(18, 1)
  • CombineType — varchar(1)
  • CombineSeq — int
  • PartialYN — varchar(1)
  • PartialSeq — int
  • EpLocationCode — varchar(20)
  • LoadLocationCode — varchar(20)
  • CustomsType — varchar(1)
  • CustomerCode — varchar(10)
  • CustomerName — varchar(60)
  • Manufacturer — varchar(60)
  • Buyer — varchar(60)
  • CommodityItem — varchar(200)
  • CommodityItem_Trade — varchar(200)
  • HSCode — varchar(10)
  • InvoiceValueCur — numeric(12, 2)
  • InvoiceValue — numeric(12, 2)
  • InvoiceValueCur_Total — numeric(12, 2)
  • InvoiceValue_Total — numeric(12, 2)
  • FreightCharge — numeric(12, 2)
  • Insurance — numeric(12, 2)
  • PayAmount — numeric(12, 2)
  • TradeType — varchar(2)
  • CountryCode — varchar(2)
  • RegisterSign — varchar(20)
  • IF_Customs_YN — varchar(1)
  • IF_Manifest_YN — varchar(1)
  • H_RefNo — varchar(20)
  • Remark — varchar(200)
  • CreateRemark — varchar(50)
  • BranchCode — varchar(20)
  • Puncher — varchar(15)
  • PuncherDate — datetime
  • PuncherTime — varchar(15)
  • ModifyUser — varchar(15)
  • ModifyDate — datetime
  • CustomsAcceptDateTime — varchar(20)
  • CustomsConfirmDateTime — varchar(20)
  • CustomerBusinessID — varchar(10)
  • CustomsTypeA — varchar(20)
  • Urgent_YN — varchar(1)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAO_ExportNo_CS_SendRecv

  • RefNoID — numeric(12, 0)
  • 1) — NOT — NOT NULL
  • LicenseNo — varchar(20)
  • HBLNo — varchar(20)
  • EdiHost — varchar(10)
  • Search_Request_Doc — varchar(16)
  • Search_Request_DateTime — datetime
  • Search_Request_Attn — varchar(15)
  • Search_Result — varchar(1)
  • Search_Result_DateTime — datetime
  • Search_Result_Customs — varchar(3)
  • CS_Request_Doc — varchar(16)
  • CS_Request_DateTime — datetime
  • CS_Request_Attn — varchar(15)
  • CS_Result — varchar(1)
  • CS_Result_DateTime — datetime
  • CS_Result_Customs — varchar(3)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAO_ExportNo_Customs

  • HBLNo — varchar(20) — Primary key — NOT NULL
  • LicenseNo — varchar(20) — Primary key — NOT NULL
  • RefID — numeric(12, 0)
  • 1) — NOT — NOT NULL
  • LicenseDate — datetime
  • Pieces — int
  • Weight — numeric(18, 1)
  • CombineType — varchar(1)
  • CombineSeq — int
  • PartialYN — varchar(1)
  • PartialSeq — int
  • CustomerName — varchar(60)
  • Manufacturer — varchar(60)
  • Buyer — varchar(60)
  • CommodityItem — varchar(200)
  • CommodityItem_Trade — varchar(200)
  • HSCode — varchar(10)
  • InvoiceValueCur — numeric(12, 2)
  • InvoiceValue — numeric(12, 2)
  • InvoiceValueCur_Total — numeric(12, 2)
  • InvoiceValue_Total — numeric(12, 2)
  • FreightCharge — numeric(12, 2)
  • Insurance — numeric(12, 2)
  • PayAmount — numeric(12, 2)
  • TradeType — varchar(2)
  • CountryCode — varchar(2)
  • RegisterSign — varchar(20)
  • Confirm_YN — char(1)
  • Puncher — varchar(15)
  • PuncherDate — datetime
  • ModifyUser — varchar(15)
  • ModifyDate — datetime
  • CustomsAcceptDateTime — varchar(20)
  • CustomsConfirmDateTime — varchar(20)
  • CustomerBusinessID — varchar(10)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAO_HBL

  • RefNo — varchar(20) — Primary key — NOT NULL
  • HBLNo — varchar(20) — NOT NULL
  • MBLNo — varchar(20) — NOT NULL
  • MRefNo — varchar(20)
  • BLTypeIE — varchar(1)
  • HSN — varchar(4)
  • EDIFlag — varchar(1)
  • CommodityItem — varchar(200)
  • Remark — varchar(500)
  • CustomsTypeYN — varchar(1)
  • CurrencyCode — varchar(3)
  • AmountTotal — numeric(18, 2)
  • STPPort — varchar(5)
  • Pieces — int
  • GWT — numeric(18, 3)
  • ShipperCode — varchar(20)
  • ShipperName — varchar(100)
  • ShipperAddress — varchar(60)
  • ShipperAddressA — varchar(60)
  • ShipperAddressB — varchar(60)
  • ShipperAddressC — varchar(60)
  • ShipperAddressD — varchar(60)
  • ShipperTel — varchar(40)
  • ShipperFax — varchar(20)
  • ShipperBusinessID — varchar(30)
  • ShipperZipCode — varchar(10)
  • ConsigneeCode — varchar(20)
  • ConsigneeName — varchar(100)
  • ConsigneeAddress — varchar(60)
  • ConsigneeAddressA — varchar(60)
  • ConsigneeAddressB — varchar(60)
  • ConsigneeAddressC — varchar(60)
  • ConsigneeAddressD — varchar(60)
  • ConsigneeTel — varchar(40)
  • ConsigneeFax — varchar(20)
  • ConsigneeBusinessID — varchar(30)
  • ConsigneeZipCode — varchar(10)
  • NotifyCode — varchar(20)
  • NotifyName — varchar(100)
  • NotifyAddress — varchar(60)
  • NotifyAddressA — varchar(60)
  • NotifyAddressB — varchar(60)
  • NotifyAddressC — varchar(60)
  • NotifyAddressD — varchar(60)
  • NotifyTel — varchar(40)
  • NotifyFax — varchar(20)
  • NotifyBusinessID — varchar(30)
  • NotifyZipCode — varchar(10)
  • AMSSendYN — varchar(1)
  • AMSCommodityItem — varchar(200)
  • AMSPort — varchar(5)
  • ShipperCountryCode — varchar(2)
  • ShipperState — varchar(9)
  • ShipperCity — varchar(5)
  • ShipperPlace — varchar(17)
  • ShipperStreet — varchar(35)
  • ConsigneeCountryCode — varchar(2)
  • ConsigneeState — varchar(9)
  • ConsigneeCity — varchar(5)
  • ConsigneePlace — varchar(17)
  • … +84

TEDAO_HBL_Additional

  • RefNo — varchar(20) — Primary key — NOT NULL
  • ShipperAdd_Line — varchar(150)
  • ShipperAdd_ZipCode — varchar(6)
  • ShipperAdd_RoadCode — varchar(12)
  • ShipperAdd_BuildingNo — varchar(25)
  • ShipperAttn — varchar(35)
  • ConsigneeAttn — varchar(35)
  • NotifyAttn — varchar(35)
  • NotifyEoriNo — varchar(20)
  • SHP_ID — varchar(25)
  • CNE_ID — varchar(25)
  • NFY_ID — varchar(25)
  • WebCustomerCode — varchar(20)
  • PONo — varchar(60)
  • EtcRefNo — varchar(20)
  • EPN_SendType — varchar(10)
  • EPN_SendDateTime — datetime
  • EPN_SendAttn — varchar(15)
  • ShipperCustomsNo — varchar(15)
  • OrigCode_H — varchar(5)
  • Customs_H — varchar(3)
  • CustomsDepart_H — varchar(2)
  • GoodsLocation_ZipCode — varchar(5)
  • GoodsLocation_Address — varchar(150)
  • GoodsWarehouse — varchar(70)
  • GoodsCheckReqYN — varchar(1)
  • GoodsCheckReqReason — varchar(300)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAO_HBL_BaseLicenseNo

  • RefNo — varchar(20) — Primary key — NOT NULL
  • SeqNo — int — Primary key — NOT NULL
  • LicenseNo — varchar(20) — NOT NULL
  • Pieces — int
  • Unit — varchar(10)
  • Weight — numeric(18, 3)
  • CombineType — varchar(1)
  • CombineSeq — int
  • PartialYN — varchar(1)
  • PartialSeq — int
  • CustomsDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TEDAO_HBL_GoodsItem

  • RefNo — varchar(20) — Primary key — NOT NULL
  • SeqNo — int — Primary key — NOT NULL
  • Description — varchar(100)
  • HSCode — varchar(10)
  • CurrencyCode — varchar(3)
  • ExRate — numeric(12, 2)
  • ExDate — datetime
  • Rate — numeric(12, 0)
  • Pieces — numeric(12, 0)
  • PiecesUnit — varchar(3)
  • AmountCur — numeric(12, 2)
  • Amount — numeric(12, 2)
  • GWT — numeric(10, 3)
  • Manufacturer — nvarchar(20)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

and 348 more tables