WinSABIS
테이블 (12)
AF_AWB_Chargeable
- Seq — numeric(4, 0) — 기본 키 — NOT NULL
- Piece — numeric(5, 0)
- Gross_Weight — numeric(10, 2)
- Kgs_Lbs — char(1)
- Rate_Class — varchar(2)
- Item_No — varchar(5)
- Chargeable_Weight — numeric(10, 2)
- Rate_Charge — numeric(12, 2)
- Chargeable_Weight_Total — numeric(12, 2)
- Remark — varchar(30)
- CBM — numeric(10, 3)
AF_AWB_Issue
- AWB_No — varchar(30) — 기본 키 — NOT NULL
- AWB_IO — char(1)
- AWB_Type — char(1)
- Cargo_Type — char(1)
- LC_Sample — char(1)
- Coload_Class — char(1)
- Ref_Mawb_No — varchar(30)
- CrDr_No — varchar(30)
- Shipper_Code — varchar(15)
- Shipper_No — varchar(35)
- Shipper_Name — varchar(50)
- Shipper_Address — varchar(255)
- Consignee_Code — varchar(15)
- Consignee_No — varchar(35)
- Consignee_To_Order — numeric(1, 0)
- Consignee_Name — varchar(50)
- Consignee_Address — varchar(255)
- Notify_Code — varchar(15)
- Notify_No — varchar(35)
- Same_As_Consignee — numeric(1, 0)
- Notify_Name — varchar(50)
- Notify_Address — varchar(255)
- Departure_Code — char(5)
- Departure_Name — varchar(50)
- To_City_1 — char(5)
- By_Carrier_1 — char(2)
- Flight_1 — varchar(10)
- Flight_Date_1 — char(8)
- ETD_Time_1 — char(5)
- ETA_Time_1 — char(10)
- To_City_2 — char(5)
- By_Carrier_2 — char(2)
- Flight_2 — varchar(10)
- Flight_Date_2 — char(8)
- ETD_Time_2 — char(5)
- ETA_Time_2 — char(10)
- To_City_3 — char(5)
- By_Carrier_3 — char(2)
- Flight_3 — varchar(10)
- Flight_Date_3 — char(8)
- ETD_Time_3 — char(5)
- ETA_Time_3 — char(10)
- Destination_Code — char(5)
- Destination_Name — varchar(50)
- Account_Information — varchar(255)
- Freight_Term — char(1)
- Other_Charge_Term — char(1)
- Declared_Value_Carrier — varchar(50)
- Declared_Value_Customs — varchar(50)
- Amount_Insurance — varchar(50)
- Handling_Information — varchar(255)
- Mark — text
- LC_No — varchar(30)
- LC_Date — char(8)
- PO_No — varchar(30)
- Shipper_Invoice_No — varchar(30)
- Shipper_Invoice_Value — varchar(30)
- Shippers_Load_Count — varchar(50)
- Said_To_Contain — varchar(50)
- Description — text
- … +130
Quotation(frmSCQuotation2) (SC_Quotation_New)
- Quotation_No — varchar(55) — 기본 키 — NOT NULL — 견적번호
- JOB_CLASS — char(1) — 기본 키 — NOT NULL
- Quotation_Date — varchar(12)
- Q_IO — char(1)
- Customer — varchar(15)
- Customer_Name — varchar(100)
- Customer_Attn — varchar(50)
- Customer_TEL — varchar(30)
- Customer_FAX — varchar(30)
- SalesMan — varchar(10) — 영업사원
- Status — varchar(1)
- Status_Date — varchar(14)
- CD_POL — varchar(5)
- NM_POL — varchar(50)
- CD_POD — varchar(5)
- NM_POD — varchar(50)
- CD_CARRIER — varchar(15)
- VOLUME — varchar(255)
- COMMODITY — varchar(255)
- INFORMATION — varchar(255)
- REMARK — text — 비고
- OTHER — text
- FROM_DATE — varchar(8)
- TO_DATE — varchar(8)
- Q_CONFIRM — varchar(8)
- In_Date — varchar(8) — 입력일
- In_Person — varchar(10) — 입력자
- Up_Date — varchar(8) — 수정일
- Up_Person — varchar(10) — 수정자
- Commodity_Code — varchar(20)
- Incoterms — char(3)
- FreeTime — numeric(3, 0)
- TransTime — numeric(3, 0)
- Contract_Code — varchar(15)
- WriteFlg — char(1)
- POD_Code — varchar(5) — 도착지코드
- POD_Name — varchar(50) — 도착지명
- Amendment_No — varchar(30)
- Customer_Attn_Ref — varchar(50)
- Service_Term — varchar(50)
Quotation(frmSCQuotation2) (SC_Quotation_Freight_New)
- 견적번호 (Quotation_No) — varchar(55) — 기본 키 — NOT NULL
- JOB_CLASS — char(1) — 기본 키 — NOT NULL
- CD_FRT — varchar(3) — 기본 키 — NOT NULL
- SEQ_FRT — int — 기본 키 — NOT NULL
- NM_FRT — varchar(30)
- CURR — varchar(3)
- Rate_ID — varchar(20)
Quotation(frmSCQuotation2) (SC_Quotation_Rate_New)
- Quotation_No — varchar(55) — 기본 키 — NOT NULL
- JOB_CLASS — char(1) — 기본 키 — NOT NULL
- CD_FRT — varchar(3) — 기본 키 — NOT NULL
- RATE_Seq — int — 기본 키 — NOT NULL
- UNIT — varchar(10)
- RATE — varchar(50)
- Remark — varchar(255)
- Weight — numeric(10, 2)
frmSFBookingNote (SF_Booking)
- Booking_No — varchar(20) — 기본 키 — NOT NULL
- Booking_Date — smalldatetime
- IO — char(1)
- ShprCnee_Code — varchar(15)
- ShprCnee_Name — varchar(50)
- ShprCnee_Attn — varchar(50)
- ShprCnee_Tel — varchar(30)
- ShprCnee_Fax — varchar(30)
- Factory_Name — varchar(50)
- Factory_Attn — varchar(20)
- Factory_Tel — varchar(30)
- Door_Datetime — smalldatetime
- Origin_Port_Code — varchar(5)
- Origin_Port — varchar(60)
- Discharging_Port_Code — varchar(5)
- Discharging_Port — varchar(60)
- Final_Destination_Code — varchar(5)
- Final_Destination — varchar(60)
- Closing_Datetime — smalldatetime
- ETD — smalldatetime
- ETA — smalldatetime
- Vessel — varchar(40)
- Voyage — varchar(40)
- Carrier_Code — varchar(15)
- Carrier_Name — varchar(50)
- Exp_Loading_Datetime — smalldatetime
- Carrier_Attn — varchar(20)
- Carrier_Tel — varchar(30)
- Cntr_20 — int
- Cntr_40 — int
- Cntr_40HC — int
- Cntr_Other — int
- Cntr_Total — int
- CBM — numeric(14, 3)
- Weight — numeric(14, 3)
- Item_Name — varchar(50)
- Partner_Code — varchar(15)
- Partner_Name — varchar(50)
- Term — varchar(20)
- INV_Amount — numeric(18, 4)
- Transport — varchar(40)
- Attention_YN — char(1)
- Insurance_YN — char(1)
- OTHERS — text
- HBL_No — varchar(30)
- MBL_No — varchar(30)
- BKG_YN — char(1)
- SalesMan_Code — char(10)
- SalesMan — varchar(20)
- Input_Date — smalldatetime
- Update_Date — smalldatetime
- Inputer — varchar(20)
- Acceptance_No — varchar(20)
- ManageMan_Code — varchar(10)
- ManageMan — varchar(20)
- Progress — char(1)
- Progress_Date — varchar(8)
- LC_NO — varchar(20)
- Partner_bkg_no — varchar(13)
- CNEE_NAME — varchar(60)
- … +96
frmSFBookingNote (SF_Booking_Sub)
- Booking_no — varchar(20) — NOT NULL
- Seq — int — NOT NULL
- CLP_NO — varchar(20)
- HBL_NO — varchar(20)
- Cntr_Total — int
- Package_Code — char(10)
- Weight — numeric(18, 3)
- Shipper_CBM — numeric(18, 3)
- CBM — numeric(18, 3)
- Remark — varchar(255)
- Entering_no — varchar(20)
- Shipping_Mark — varchar(255)
- Booking_Remark — varchar(100)
frmSFBookingNote (SF_CFS_ContainerLoadPlan)
- CLP_No — varchar(20) — NOT NULL
- CLP_Date — char(8) — NOT NULL
- Trans_Class — char(1)
- Container_No — char(11)
- Seal_No — varchar(15)
- Container_Type — char(1)
- Closing_Date — char(8)
- Tans_Date — char(8)
- Pod_Code — varchar(5)
- Pod_Name — varchar(50)
- Line_Code — varchar(15)
- Line_Name — varchar(100)
- Vessel_Name — varchar(50)
- Voyage_No — varchar(20)
- FrtAmt — numeric(14, 2)
- Remark — varchar(500)
- In_Person — varchar(40)
- In_Date — char(8)
- Up_Person — varchar(40)
- Up_Date — char(8)
- ETD — smalldatetime
- ETA — smalldatetime
- progress — char(1)
- MBooking_No — varchar(30)
- Job_Date — char(8)
- Job_Person — varchar(40)
- Trans_Cust — varchar(15)
- Warehouse — char(8)
- POL_CODE — varchar(5)
- MBL_NO — varchar(30)
- MRN — char(11)
- POL_NAME — varchar(50)
견적서 (LC_Estimate)
- Ref_No — varchar(12) — NOT NULL
- Estimate_Date — varchar(8)
- Recipient_Code — varchar(15)
- Recipient_Name — varchar(50)
- Addresser — varchar(50)
- Reference — varchar(50)
- Title — varchar(255)
- Title_Detail — varchar(255)
- Content — varchar(2000)
- Recipient_TelFax — varchar(60)
- Recipient_Attn — varchar(50)
- Rate_Type — char(1)
- Effective — char(1)
- Mode — char(1)
- POL_Code — char(5)
- POL_Name — varchar(50)
- PODel_Code — char(5)
- PODel_Name — varchar(50)
- E_Attn — varchar(20)
주문(SFOrderMgt) (SF_Order_Mgt_HBL)
- Order_No — varchar(30) — 기본 키 — NOT NULL
- HBL_No — varchar(30) — 기본 키 — NOT NULL
- PickUp_Date — char(8) — NOT NULL
- Cargo_Closing_Date — char(8)
- Cargo_Closing_Time — char(4)
- Doc_Closing_Date — char(8)
- Doc_Closing_Time — char(4)
- LC_Amount — numeric(12, 4)
- Curr — varchar(3)
- Transport — char(1)
- Line_Code — varchar(20) — 선사코드
- Line_Name — varchar(60) — 선사명
- Vessel_Code — varchar(20)
- Vessel_Name — varchar(60) — 편명
- Voyage_No — varchar(20) — 항차코드
- ETD — char(8)
- ETA — char(8)
- POL_Code — varchar(5) — 출발지코드
- POL_Name — varchar(50) — 출발지명
- POD_Code — varchar(5) — 도착지코드
- POD_Name — varchar(50) — 도착지명
- FL — char(1)
- WEIGHT — numeric(12, 4) — 중량
주문(SFOrderMgt) (SF_Order_Mgt)
- Order_No — varchar(30) — NOT NULL
- IO — char(1) — NOT NULL
- Status — varchar(2)
- Payment — varchar(2)
- Order_Date — char(8)
- Work_Type — char(1)
- PO_No — varchar(30)
- Sales_Man_Code — varchar(30)
- Shipper_Code — varchar(30)
- Shipper_Name — varchar(50)
- Shipper_Attn — varchar(20)
- Shipper_Address — varchar(255)
- Shipper_Tel — varchar(50)
- Shipper_Fax — varchar(50)
- Consignee_Code — varchar(30)
- Consignee_Name — varchar(50)
- Consignee_Attn — varchar(30)
- Partner_Code — varchar(30)
- Partner_Name — varchar(50)
- Partner_Attn — varchar(20)
- PO_Item_Group — varchar(70)
- Comodity — varchar(200)
- Incoterms — char(3)
- Onboard_Date — char(8)
- LC_No — varchar(30)
- Curr — char(3)
- LC_Date — char(8)
- Amount — numeric(12, 4)
- Expiry_Date — char(8)
- Line_Code — varchar(20)
- Line_Name — varchar(60)
- Vessel_Code — varchar(20)
- Vessel_Name — varchar(60)
- Voyage_No — varchar(20)
- Amend_Type — varchar(2)
- Amend_Date — char(8)
- Amend_Seq — int
- SH_Message — varchar(200)
- POL_Code — varchar(5)
- POL_Name — varchar(50)
- POD_Code — varchar(5)
- POD_Name — varchar(50)
- ETD — char(8)
- ETA — char(8)
- In_Date — char(8)
- In_Person — varchar(20)
- Up_Date — char(8)
- Up_Person — varchar(20)
주문(SFOrderMgt) (SF_Order_Mgt_Cntr)
- Order_No — varchar(30) — NOT NULL
- HBL_No — varchar(30) — NOT NULL
- Cntr_Type — varchar(3) — NOT NULL
- Cntr_Qty — int — NOT NULL