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