배차 신청
테이블 (7)
WINI_BIS
- V_BISCD — VARCHAR2(20) — 기본 키
- V_ITEMCD — VARCHAR2(20)
- V_ITEM_TYPE — VARCHAR2(10)
- V_SELLERCD — VARCHAR2(14)
- V_BUYERCD — VARCHAR2(14) — NOT NULL
- V_STATUS — VARCHAR2(5)
- V_BIS_COUNTRYCD — VARCHAR2(5)
- V_BIS_PORTCD — VARCHAR2(20)
- N_OVERALL_LENGTH — NUMBER
- N_OVERALL_WIDTH — NUMBER
- N_OVERALL_HEIGHT — NUMBER
- N_CBM — NUMBER
- N_OCEAN_FREIGHT — NUMBER
- N_WHARFAGE_FEE — NUMBER
- N_LOADING_FEE — NUMBER
- N_DOCUMENTS_FEE — NUMBER
- N_BIS_CHARGE — NUMBER
- V_INSPECTION_FLAG — VARCHAR2(1)
- N_TOTAL_CHARGE — NUMBER
- V_COMMENT — VARCHAR2(4000)
- V_REG_USERCD — VARCHAR2(14)
- V_REG_DTM — VARCHAR2(14)
- V_UPDATE_USERCD — VARCHAR2(14)
- V_UPDATE_DTM — VARCHAR2(14)
- V_ITEM_LISTINGID — VARCHAR2(20)
- V_ITEMNM — VARCHAR2(200)
- N_ITEM_PRICE — NUMBER
- V_BIS_SIZECD — VARCHAR2(50)
- V_USER_IP — VARCHAR2(100)
- N_PALLET_PACKING_FEE — NUMBER
- V_FLAG_BIS — VARCHAR2(1)
- V_USER_AGENT — VARCHAR2(10)
- V_MANAGERCD — VARCHAR2(14)
- V_FLAG_CONFIRM — VARCHAR2(5)
- V_OTHER_CHARGE_TXT — VARCHAR2(100)
- N_OTHER_CHARGE — NUMBER
- N_BIS_DISCOUNT — NUMBER
- N_ITEM_DISCOUNT — NUMBER
- N_ACTUAL_EXPENSES — NUMBER
- N_CARRIER_CHARGE — NUMBER
- V_FLAG_EVENT — VARCHAR2(1)
- V_FLAG_DEL — VARCHAR2(1)
- N_SURCHARGE — NUMBER
- V_TRADE_CONDITION — VARCHAR2(5)
- N_BOOKING_FEE — NUMBER
- V_FLAG_INQUIRY_ALERT — VARCHAR2(1)
- V_REQUEST_DETAIL — VARCHAR2(400)
WINI_BIS_BOOKING
- V_BOOKINGCD — VARCHAR2(20) — 기본 키 — NOT NULL
- V_ITEMCD — VARCHAR2(20) — NOT NULL
- V_ITEM_LISTINGID — VARCHAR2(20)
- V_MANAGERCD — VARCHAR2(20)
- V_STATUS — VARCHAR2(5)
- V_MEMO — VARCHAR2(1000)
- V_REG_DTM — VARCHAR2(14)
- V_REG_USERCD — VARCHAR2(14)
- V_UPDATE_DTM — VARCHAR2(14)
- V_UPDATE_USERCD — VARCHAR2(14)
- V_BUYERCD — VARCHAR2(14)
- V_SELLERCD — VARCHAR2(14)
- V_ITEMNM — VARCHAR2(300)
- V_VIN_NUM — VARCHAR2(20)
- V_FLAG_DEL — VARCHAR2(1)
- V_SHIPPING_TYPE — VARCHAR2(5)
- V_BISCD — VARCHAR2(20)
- V_SHIPPINGCD — VARCHAR2(20)
- V_STATUS_DTM — VARCHAR2(14)
- V_DOCUMENT_TRACKING_TYPE — VARCHAR2(5)
- V_DOCUMENT_TRACKING_NO — VARCHAR2(20)
- V_VESSEL_TRACKING_TYPE — VARCHAR2(5)
- V_VESSEL_TRACKING_NO — VARCHAR2(30)
- V_GROUP_NO — VARCHAR2(20)
- V_BUYER_STATUS — VARCHAR2(5)
- V_SELLER_STATUS — VARCHAR2(5)
- N_FLAG — NUMBER
- N_WEIGHT — NUMBER
- V_DELIVERY_ADDRESS — VARCHAR2(500)
- V_DELIVERY_TYPE — VARCHAR2(5)
- V_DELIVERY_NAME — VARCHAR2(100)
- V_DELIVERY_TEL — VARCHAR2(100)
- V_FILE_NUM — VARCHAR2(30)
- V_BANKCD — VARCHAR2(20)
- V_BUSINESSCD — VARCHAR2(20)
- N_PAY_PRICE — NUMBER
- N_PAY_CHARGE — NUMBER
- N_PAY_DISCOUNT — NUMBER
- V_PAY_DTM — VARCHAR2(14)
- V_PAY_OTHER — VARCHAR2(100)
- N_PAY_OTHER — NUMBER
- V_FLAG_SELLER — VARCHAR2(1)
- V_PAY_STATUS — VARCHAR2(5)
- V_SELLER_PAY_DTM — VARCHAR2(14)
- V_INTRODUCE_STATUS — VARCHAR2(5)
- V_FLAG_SELLER_PAY — VARCHAR2(1)
- N_SHIPPING_WON — NUMBER
- V_SELLER_MEMO — VARCHAR2(1000)
- V_ACC_STATUS — VARCHAR2(5)
- V_SHIPPING_MEMO — VARCHAR2(2000)
- V_SHIPPING_STATUS — VARCHAR2(5)
- V_ACC_MEMO — VARCHAR2(1000)
- V_FLAG_EL — VARCHAR2(5)
- V_BL_STATUS — VARCHAR2(5)
- V_FORWARDER_MEMO — VARCHAR2(500)
- V_CHECK_EL — VARCHAR2(1)
- V_CHECK_PL — VARCHAR2(1)
- V_AUTOWINI_MEMO — VARCHAR2(200)
- V_FLAG_PROMOTION — VARCHAR2(1)
- V_FLAG_CMSM — VARCHAR2(1)
- … +41
WINI_BIS_BOOKING_GROUP
- V_GROUP_NO — VARCHAR2(20) — 기본 키 — NOT NULL
- V_MANAGERCD — VARCHAR2(20)
- V_MEMO — VARCHAR2(300)
- V_BUYERCD — VARCHAR2(20)
- V_SHIPPING_TYPE — VARCHAR2(5)
- V_SHIPPINGCD — VARCHAR2(20)
- V_DOCUMENT_TRACKING_TYPE — VARCHAR2(5)
- V_DOCUMENT_TRACKING_NO — VARCHAR2(20)
- V_VESSEL_TRACKING_TYPE — VARCHAR2(5)
- V_VESSEL_TRACKING_NO — VARCHAR2(20)
- V_STATUS — VARCHAR2(5)
- V_REG_DTM — VARCHAR2(20)
- V_REG_USERCD — VARCHAR2(20)
- V_UPDATE_DTM — VARCHAR2(20)
- V_UPDATE_USERCD — VARCHAR2(20)
- V_QUOTATION_TYPE — VARCHAR2(5)
- N_SHIPPING_COST — NUMBER
- N_BIS_CHARGE — NUMBER
- N_DISCOUNT — NUMBER
- N_TOTAL_CHARGE — NUMBER
- V_OTHER_CHARGE_TXT — VARCHAR2(100)
- N_OTHER_CHARGE — NUMBER
- V_DELIVERY_ADDRESS — VARCHAR2(200)
- V_DELIVERY_TYPE — VARCHAR2(5)
- V_DELIVERY_NAME — VARCHAR2(100)
- V_DELIVERY_TEL — VARCHAR2(100)
- V_FILE_NUM — VARCHAR2(30)
- N_FLAG — NUMBER
- V_SHIPPING_MEMO — VARCHAR2(2000)
- V_SHIPPING_STATUS — VARCHAR2(5)
- V_BL_STATUS — VARCHAR2(5)
- V_FORWARDER_MEMO — VARCHAR2(500)
- V_CHECK_EL — VARCHAR2(1)
- V_CHECK_PL — VARCHAR2(1)
- V_AUTOWINI_MEMO — VARCHAR2(200)
- V_GROUP_TYPE — VARCHAR2(5)
- V_SELLER_MEMO — VARCHAR2(1000)
- V_CTN_STATUS — VARCHAR2(5)
- V_CTN_MEMO — VARCHAR2(200)
- V_CTN_NO — VARCHAR2(40)
- V_CTN_MESSAGE — VARCHAR2(2000)
WINI_BIS_CI
- V_INVOICE_NO — VARCHAR2(20) — 기본 키 — NOT NULL
- V_STATUS — VARCHAR2(5)
- V_FLAG_DEL — VARCHAR2(1)
- V_SHIPPING_TYPE — VARCHAR2(5)
- V_TRADE_CONDITION — VARCHAR2(5)
- V_VESSEL_FLIGTH — VARCHAR2(100)
- V_DEPARTURE_DATE — VARCHAR2(14)
- V_ARRIVAL_DATE — VARCHAR2(14)
- N_SHIPPING_UNIT — NUMBER
- N_SHIPPING_UNIT_PRICE — NUMBER
- N_BIS_UNIT — NUMBER
- N_BIS_UNIT_PRICE — NUMBER
- N_INSURANCE_UNIT — NUMBER
- N_INSURANCE_UNIT_PRICE — NUMBER
- N_TOTAL_AMOUNT — NUMBER
- N_TOTAL_WEIGHT — NUMBER
- N_TOTAL_CBM — NUMBER
- V_MANAGERCD — VARCHAR2(20)
- V_REG_USERCD — VARCHAR2(20)
- V_REG_DTM — VARCHAR2(20)
- V_UPDATE_USERCD — VARCHAR2(20)
- V_UPDATE_DTM — VARCHAR2(20)
- V_DEL_USERCD — VARCHAR2(20)
- N_TOTAL_UNIT — NUMBER
- V_ISSUE_DATE — VARCHAR2(14)
- V_BOOKINGCD — VARCHAR2(20)
- V_OTHER_CHARGE_TXT — VARCHAR2(100)
- N_OTHER_CHARGE_UNIT — NUMBER
- N_OTHER_CHARGE_UNIT_PRICE — NUMBER
- V_SHIPPINGCD — VARCHAR2(20)
- N_TOTAL_BIS_DISCOUNT — NUMBER
- V_FLAG_CONFIRM — VARCHAR2(1)
- V_FLAG_ISSUE_DATE — VARCHAR2(1)
- V_BOOKINGCD (V_BOOKINGCD2) — VARCHAR2(20) — 외래 키 → WINI_BIS_BOOKING.V_BOOKINGCD — NOT NULL
WINI_BIS_CI_ITEM
- V_CI_ITEMCD — VARCHAR2(20) — 기본 키 — NOT NULL
- V_INVOICE_NO — VARCHAR2(20) — 외래 키 → WINI_BIS_CI.V_INVOICE_NO — NOT NULL
- V_ITEMCD — VARCHAR2(20)
- V_LISTINGID — VARCHAR2(20)
- V_VIN_NUM — VARCHAR2(40)
- N_UNIT_PRICE — NUMBER
- N_UNIT — NUMBER
- N_WEIGHT — NUMBER
- N_WIDTH — NUMBER
- N_LENGTH — NUMBER
- N_HEIGTH — NUMBER
- V_STATUS — VARCHAR2(5)
- V_ITEM_TYPE — VARCHAR2(20)
- V_ITEMNM — VARCHAR2(500)
- V_ITEM_MEMO — VARCHAR2(500)
- N_CBM — NUMBER
- N_BIS_SELLER — NUMBER
- N_ITEM_DISCOUNT — NUMBER
- N_BIS_CHARGE — NUMBER
- N_BIS_DISCOUNT — NUMBER
- N_ACTUAL_EXPENSES — NUMBER
WINI_BIS_SMS
- V_BIS_SMSCD — VARCHAR2(20) — 기본 키 — NOT NULL
- V_BOOKINGCD — VARCHAR2(20)
- V_TO_PHONE — VARCHAR2(20)
- V_FROM_PHONE — VARCHAR2(20)
- V_TITLE — VARCHAR2(120)
- V_MESSAGE — VARCHAR2(2048)
- V_REG_DTM — VARCHAR2(20)
- V_REG_USERCD — VARCHAR2(20)
- V_SMS_TYPE — VARCHAR2(5)
- V_RECEIVERCD — VARCHAR2(20)
WINI_REQUEST_DISPATCH
- V_DISPATCHCD — VARCHAR2(20) — 기본 키 — NOT NULL
- V_BOOKINGCD — VARCHAR2(20) — NOT NULL
- V_TYPE — VARCHAR2(5)
- V_PHONE — VARCHAR2(100)
- V_STAFF_PHONE — VARCHAR2(100)
- V_LOCATIONCD — VARCHAR2(5)
- V_LOCATIONNM — VARCHAR2(200)
- V_TIMECD — VARCHAR2(5)
- V_INTRODUCE_DATE — VARCHAR2(10)
- V_INTRODUCE_STAFF_PHONE — VARCHAR2(100)
- V_REG_DTM — VARCHAR2(14)
- V_REG_USERCD — VARCHAR2(14)
- V_UPDATE_DTM — VARCHAR2(14)
- V_UPDATE_USERCD — VARCHAR2(14)
- V_MEMO — VARCHAR2(500)