<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.bailuntec.mapper.DcBaseOmsSku30Mapper">
  <resultMap id="BaseResultMap" type="com.bailuntec.domain.entity.DcBaseOmsSku30">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    <id column="id" jdbcType="INTEGER" property="id" />
    <result column="origin_order_id" jdbcType="VARCHAR" property="originOrderId" />
    <result column="platform_type" jdbcType="VARCHAR" property="platformType" />
    <result column="transaction_id" jdbcType="VARCHAR" property="transactionId" />
    <result column="pay_time" jdbcType="TIMESTAMP" property="payTime" />
    <result column="pay_method" jdbcType="VARCHAR" property="payMethod" />
    <result column="pay_account" jdbcType="VARCHAR" property="payAccount" />
    <result column="pay_status" jdbcType="VARCHAR" property="payStatus" />
    <result column="collection_account" jdbcType="VARCHAR" property="collectionAccount" />
    <result column="platform_order_type" jdbcType="VARCHAR" property="platformOrderType" />
    <result column="website" jdbcType="VARCHAR" property="website" />
    <result column="create_time" jdbcType="TIMESTAMP" property="createTime" />
    <result column="paid_time" jdbcType="TIMESTAMP" property="paidTime" />
    <result column="refund_time" jdbcType="TIMESTAMP" property="refundTime" />
    <result column="seller_id" jdbcType="VARCHAR" property="sellerId" />
    <result column="bailun_account_id" jdbcType="INTEGER" property="bailunAccountId" />
    <result column="hq_account" jdbcType="VARCHAR" property="hqAccount" />
    <result column="seller_account" jdbcType="VARCHAR" property="sellerAccount" />
    <result column="seller_order_id" jdbcType="VARCHAR" property="sellerOrderId" />
    <result column="seller_email" jdbcType="VARCHAR" property="sellerEmail" />
    <result column="order_update_time" jdbcType="TIMESTAMP" property="orderUpdateTime" />
    <result column="seller_order_exchange_rate" jdbcType="DECIMAL" property="sellerOrderExchangeRate" />
    <result column="seller_other_exchange_rate" jdbcType="DECIMAL" property="sellerOtherExchangeRate" />
    <result column="finance_order_exchange_rate" jdbcType="DECIMAL" property="financeOrderExchangeRate" />
    <result column="finance_other_exchange_rate" jdbcType="DECIMAL" property="financeOtherExchangeRate" />
    <result column="cny_to_usd_exchange_rate" jdbcType="DECIMAL" property="cnyToUsdExchangeRate" />
    <result column="order_to_usd_exchange_rate" jdbcType="DECIMAL" property="orderToUsdExchangeRate" />
    <result column="other_to_usd_exchange_rate" jdbcType="DECIMAL" property="otherToUsdExchangeRate" />
    <result column="order_currency" jdbcType="VARCHAR" property="orderCurrency" />
    <result column="other_currency" jdbcType="VARCHAR" property="otherCurrency" />
    <result column="seller_name" jdbcType="VARCHAR" property="sellerName" />
    <result column="bailun_order_id" jdbcType="VARCHAR" property="bailunOrderId" />
    <result column="platform_order_status" jdbcType="VARCHAR" property="platformOrderStatus" />
    <result column="bailun_order_status" jdbcType="VARCHAR" property="bailunOrderStatus" />
    <result column="bailun_payment_status" jdbcType="VARCHAR" property="bailunPaymentStatus" />
    <result column="bailun_interception_status" jdbcType="VARCHAR" property="bailunInterceptionStatus" />
    <result column="shipping_status" jdbcType="VARCHAR" property="shippingStatus" />
    <result column="bailun_sku" jdbcType="VARCHAR" property="bailunSku" />
    <result column="bailun_sku_title_en" jdbcType="VARCHAR" property="bailunSkuTitleEn" />
    <result column="bailun_sku_title_cn" jdbcType="VARCHAR" property="bailunSkuTitleCn" />
    <result column="bailun_sku_quantity_ordered" jdbcType="INTEGER" property="bailunSkuQuantityOrdered" />
    <result column="bailun_sku_quantity_shipped" jdbcType="INTEGER" property="bailunSkuQuantityShipped" />
    <result column="bailun_sku_quantity_refund" jdbcType="INTEGER" property="bailunSkuQuantityRefund" />
    <result column="bailun_sku_quantity_picked" jdbcType="INTEGER" property="bailunSkuQuantityPicked" />
    <result column="warehouse_name" jdbcType="VARCHAR" property="warehouseName" />
    <result column="warehouse_code_fba" jdbcType="VARCHAR" property="warehouseCodeFba" />
    <result column="warehouse_code" jdbcType="VARCHAR" property="warehouseCode" />
    <result column="bailun_sku_unit_price" jdbcType="DECIMAL" property="bailunSkuUnitPrice" />
    <result column="bailun_sku_weight" jdbcType="DECIMAL" property="bailunSkuWeight" />
    <result column="bailun_sku_size" jdbcType="VARCHAR" property="bailunSkuSize" />
    <result column="amount_sales" jdbcType="DECIMAL" property="amountSales" />
    <result column="amount_total" jdbcType="DECIMAL" property="amountTotal" />
    <result column="amount_shipping" jdbcType="DECIMAL" property="amountShipping" />
    <result column="amount_product" jdbcType="DECIMAL" property="amountProduct" />
    <result column="amount_tax" jdbcType="DECIMAL" property="amountTax" />
    <result column="amount_adjustment" jdbcType="DECIMAL" property="amountAdjustment" />
    <result column="amount_gift_wrap" jdbcType="DECIMAL" property="amountGiftWrap" />
    <result column="amount_refund" jdbcType="DECIMAL" property="amountRefund" />
    <result column="amount_prepaid" jdbcType="DECIMAL" property="amountPrepaid" />
    <result column="cost_total" jdbcType="DECIMAL" property="costTotal" />
    <result column="cost_promotion" jdbcType="DECIMAL" property="costPromotion" />
    <result column="cost_platform_fee" jdbcType="DECIMAL" property="costPlatformFee" />
    <result column="cost_product" jdbcType="DECIMAL" property="costProduct" />
    <result column="cost_shipping" jdbcType="DECIMAL" property="costShipping" />
    <result column="cost_package" jdbcType="DECIMAL" property="costPackage" />
    <result column="cost_fba_fee" jdbcType="DECIMAL" property="costFbaFee" />
    <result column="cost_paypal_fee" jdbcType="DECIMAL" property="costPaypalFee" />
    <result column="cost_refund_commisson" jdbcType="DECIMAL" property="costRefundCommisson" />
    <result column="cost_handle_bailun" jdbcType="DECIMAL" property="costHandleBailun" />
    <result column="cost_handle_platform" jdbcType="DECIMAL" property="costHandlePlatform" />
    <result column="cost_tail" jdbcType="DECIMAL" property="costTail" />
    <result column="cost_first" jdbcType="DECIMAL" property="costFirst" />
    <result column="cost_logistics" jdbcType="DECIMAL" property="costLogistics" />
    <result column="profit_total" jdbcType="DECIMAL" property="profitTotal" />
    <result column="profit_rate" jdbcType="DECIMAL" property="profitRate" />
    <result column="receipt_country" jdbcType="VARCHAR" property="receiptCountry" />
    <result column="receipt_city" jdbcType="VARCHAR" property="receiptCity" />
    <result column="receipt_area" jdbcType="VARCHAR" property="receiptArea" />
    <result column="receipt_address" jdbcType="VARCHAR" property="receiptAddress" />
    <result column="receipt_address_2" jdbcType="VARCHAR" property="receiptAddress2" />
    <result column="receipt_postal_code" jdbcType="VARCHAR" property="receiptPostalCode" />
    <result column="receiver" jdbcType="VARCHAR" property="receiver" />
    <result column="receiver_phone" jdbcType="VARCHAR" property="receiverPhone" />
    <result column="buyer_id" jdbcType="VARCHAR" property="buyerId" />
    <result column="buyer_name" jdbcType="VARCHAR" property="buyerName" />
    <result column="buyer_email" jdbcType="VARCHAR" property="buyerEmail" />
    <result column="has_fba_exception" jdbcType="BIT" property="hasFbaException" />
    <result column="has_platform_exception" jdbcType="BIT" property="hasPlatformException" />
    <result column="has_cancle" jdbcType="BIT" property="hasCancle" />
    <result column="area_id" jdbcType="INTEGER" property="areaId" />
    <result column="bailun_category_id" jdbcType="INTEGER" property="bailunCategoryId" />
    <result column="bailun_category_name" jdbcType="VARCHAR" property="bailunCategoryName" />
    <result column="gmt_create" jdbcType="TIMESTAMP" property="gmtCreate" />
    <result column="gmt_modified" jdbcType="TIMESTAMP" property="gmtModified" />
    <result column="ratio_weight" jdbcType="DECIMAL" property="ratioWeight" />
    <result column="ratio_price" jdbcType="DECIMAL" property="ratioPrice" />
    <result column="bailun_picking_status" jdbcType="VARCHAR" property="bailunPickingStatus" />
    <result column="bailun_require_logistics" jdbcType="VARCHAR" property="bailunRequireLogistics" />
    <result column="has_delete" jdbcType="BIT" property="hasDelete" />
    <result column="has_scalp" jdbcType="BIT" property="hasScalp" />
    <result column="has_buyer_remark" jdbcType="BIT" property="hasBuyerRemark" />
    <result column="has_platsku_remark" jdbcType="BIT" property="hasPlatskuRemark" />
    <result column="logistics_method_code" jdbcType="VARCHAR" property="logisticsMethodCode" />
    <result column="logistics_method_name" jdbcType="VARCHAR" property="logisticsMethodName" />
    <result column="has_innersale" jdbcType="BIT" property="hasInnersale" />
    <result column="company_id" jdbcType="INTEGER" property="companyId" />
    <result column="bailun_refund_status" jdbcType="VARCHAR" property="bailunRefundStatus" />
    <result column="refund_obj" jdbcType="VARCHAR" property="refundObj" />
    <result column="refund_type" jdbcType="VARCHAR" property="refundType" />
    <result column="refund_reference_id" jdbcType="VARCHAR" property="refundReferenceId" />
    <result column="has_fba_s" jdbcType="BIT" property="hasFbaS" />
    <result column="bailun_sku_quantity_pushed" jdbcType="INTEGER" property="bailunSkuQuantityPushed" />
    <result column="amount_general_cargo" jdbcType="DECIMAL" property="amountGeneralCargo" />
    <result column="has_transfer_order" jdbcType="BIT" property="hasTransferOrder" />
  </resultMap>
  <sql id="Example_Where_Clause">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    <where>
      <foreach collection="oredCriteria" item="criteria" separator="or">
        <if test="criteria.valid">
          <trim prefix="(" prefixOverrides="and" suffix=")">
            <foreach collection="criteria.criteria" item="criterion">
              <choose>
                <when test="criterion.noValue">
                  and ${criterion.condition}
                </when>
                <when test="criterion.singleValue">
                  and ${criterion.condition} #{criterion.value}
                </when>
                <when test="criterion.betweenValue">
                  and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}
                </when>
                <when test="criterion.listValue">
                  and ${criterion.condition}
                  <foreach close=")" collection="criterion.value" item="listItem" open="(" separator=",">
                    #{listItem}
                  </foreach>
                </when>
              </choose>
            </foreach>
          </trim>
        </if>
      </foreach>
    </where>
  </sql>
  <sql id="Update_By_Example_Where_Clause">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    <where>
      <foreach collection="example.oredCriteria" item="criteria" separator="or">
        <if test="criteria.valid">
          <trim prefix="(" prefixOverrides="and" suffix=")">
            <foreach collection="criteria.criteria" item="criterion">
              <choose>
                <when test="criterion.noValue">
                  and ${criterion.condition}
                </when>
                <when test="criterion.singleValue">
                  and ${criterion.condition} #{criterion.value}
                </when>
                <when test="criterion.betweenValue">
                  and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}
                </when>
                <when test="criterion.listValue">
                  and ${criterion.condition}
                  <foreach close=")" collection="criterion.value" item="listItem" open="(" separator=",">
                    #{listItem}
                  </foreach>
                </when>
              </choose>
            </foreach>
          </trim>
        </if>
      </foreach>
    </where>
  </sql>
  <sql id="Base_Column_List">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    id, origin_order_id, platform_type, transaction_id, pay_time, pay_method, pay_account,
    pay_status, collection_account, platform_order_type, website, create_time, paid_time,
    refund_time, seller_id, bailun_account_id, hq_account, seller_account, seller_order_id,
    seller_email, order_update_time, seller_order_exchange_rate, seller_other_exchange_rate,
    finance_order_exchange_rate, finance_other_exchange_rate, cny_to_usd_exchange_rate,
    order_to_usd_exchange_rate, other_to_usd_exchange_rate, order_currency, other_currency,
    seller_name, bailun_order_id, platform_order_status, bailun_order_status, bailun_payment_status,
    bailun_interception_status, shipping_status, bailun_sku, bailun_sku_title_en, bailun_sku_title_cn,
    bailun_sku_quantity_ordered, bailun_sku_quantity_shipped, bailun_sku_quantity_refund,
    bailun_sku_quantity_picked, warehouse_name, warehouse_code_fba, warehouse_code, bailun_sku_unit_price,
    bailun_sku_weight, bailun_sku_size, amount_sales, amount_total, amount_shipping,
    amount_product, amount_tax, amount_adjustment, amount_gift_wrap, amount_refund, amount_prepaid,
    cost_total, cost_promotion, cost_platform_fee, cost_product, cost_shipping, cost_package,
    cost_fba_fee, cost_paypal_fee, cost_refund_commisson, cost_handle_bailun, cost_handle_platform,
    cost_tail, cost_first, cost_logistics, profit_total, profit_rate, receipt_country,
    receipt_city, receipt_area, receipt_address, receipt_address_2, receipt_postal_code,
    receiver, receiver_phone, buyer_id, buyer_name, buyer_email, has_fba_exception, has_platform_exception,
    has_cancle, area_id, bailun_category_id, bailun_category_name, gmt_create, gmt_modified,
    ratio_weight, ratio_price, bailun_picking_status, bailun_require_logistics, has_delete,
    has_scalp, has_buyer_remark, has_platsku_remark, logistics_method_code, logistics_method_name,
    has_innersale, company_id, bailun_refund_status, refund_obj, refund_type, refund_reference_id,
    has_fba_s, bailun_sku_quantity_pushed, amount_general_cargo, has_transfer_order
  </sql>
  <select id="selectByExample" parameterType="com.bailuntec.domain.example.DcBaseOmsSku30Example" resultMap="BaseResultMap">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    select
    <if test="distinct">
      distinct
    </if>
    <include refid="Base_Column_List" />
    from dc_base_oms_sku_30
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
    <if test="orderByClause != null">
      order by ${orderByClause}
    </if>
    <if test="rows != null">
      <if test="offset != null">
        limit ${offset}, ${rows}
      </if>
      <if test="offset == null">
        limit ${rows}
      </if>
    </if>
  </select>
  <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    select
    <include refid="Base_Column_List" />
    from dc_base_oms_sku_30
    where id = #{id,jdbcType=INTEGER}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    delete from dc_base_oms_sku_30
    where id = #{id,jdbcType=INTEGER}
  </delete>
  <delete id="deleteByExample" parameterType="com.bailuntec.domain.example.DcBaseOmsSku30Example">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    delete from dc_base_oms_sku_30
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
  </delete>
  <insert id="insert" parameterType="com.bailuntec.domain.entity.DcBaseOmsSku30">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    insert into dc_base_oms_sku_30 (id, origin_order_id, platform_type,
      transaction_id, pay_time, pay_method,
      pay_account, pay_status, collection_account,
      platform_order_type, website, create_time,
      paid_time, refund_time, seller_id,
      bailun_account_id, hq_account, seller_account,
      seller_order_id, seller_email, order_update_time,
      seller_order_exchange_rate, seller_other_exchange_rate,
      finance_order_exchange_rate, finance_other_exchange_rate,
      cny_to_usd_exchange_rate, order_to_usd_exchange_rate,
      other_to_usd_exchange_rate, order_currency,
      other_currency, seller_name, bailun_order_id,
      platform_order_status, bailun_order_status,
      bailun_payment_status, bailun_interception_status,
      shipping_status, bailun_sku, bailun_sku_title_en,
      bailun_sku_title_cn, bailun_sku_quantity_ordered,
      bailun_sku_quantity_shipped, bailun_sku_quantity_refund,
      bailun_sku_quantity_picked, warehouse_name,
      warehouse_code_fba, warehouse_code, bailun_sku_unit_price,
      bailun_sku_weight, bailun_sku_size, amount_sales,
      amount_total, amount_shipping, amount_product,
      amount_tax, amount_adjustment, amount_gift_wrap,
      amount_refund, amount_prepaid, cost_total,
      cost_promotion, cost_platform_fee, cost_product,
      cost_shipping, cost_package, cost_fba_fee,
      cost_paypal_fee, cost_refund_commisson, cost_handle_bailun,
      cost_handle_platform, cost_tail, cost_first,
      cost_logistics, profit_total, profit_rate,
      receipt_country, receipt_city, receipt_area,
      receipt_address, receipt_address_2, receipt_postal_code,
      receiver, receiver_phone, buyer_id,
      buyer_name, buyer_email, has_fba_exception,
      has_platform_exception, has_cancle, area_id,
      bailun_category_id, bailun_category_name, gmt_create,
      gmt_modified, ratio_weight, ratio_price,
      bailun_picking_status, bailun_require_logistics,
      has_delete, has_scalp, has_buyer_remark,
      has_platsku_remark, logistics_method_code, logistics_method_name,
      has_innersale, company_id, bailun_refund_status,
      refund_obj, refund_type, refund_reference_id,
      has_fba_s, bailun_sku_quantity_pushed, amount_general_cargo,
      has_transfer_order)
    values (#{id,jdbcType=INTEGER}, #{originOrderId,jdbcType=VARCHAR}, #{platformType,jdbcType=VARCHAR},
      #{transactionId,jdbcType=VARCHAR}, #{payTime,jdbcType=TIMESTAMP}, #{payMethod,jdbcType=VARCHAR},
      #{payAccount,jdbcType=VARCHAR}, #{payStatus,jdbcType=VARCHAR}, #{collectionAccount,jdbcType=VARCHAR},
      #{platformOrderType,jdbcType=VARCHAR}, #{website,jdbcType=VARCHAR}, #{createTime,jdbcType=TIMESTAMP},
      #{paidTime,jdbcType=TIMESTAMP}, #{refundTime,jdbcType=TIMESTAMP}, #{sellerId,jdbcType=VARCHAR},
      #{bailunAccountId,jdbcType=INTEGER}, #{hqAccount,jdbcType=VARCHAR}, #{sellerAccount,jdbcType=VARCHAR},
      #{sellerOrderId,jdbcType=VARCHAR}, #{sellerEmail,jdbcType=VARCHAR}, #{orderUpdateTime,jdbcType=TIMESTAMP},
      #{sellerOrderExchangeRate,jdbcType=DECIMAL}, #{sellerOtherExchangeRate,jdbcType=DECIMAL},
      #{financeOrderExchangeRate,jdbcType=DECIMAL}, #{financeOtherExchangeRate,jdbcType=DECIMAL},
      #{cnyToUsdExchangeRate,jdbcType=DECIMAL}, #{orderToUsdExchangeRate,jdbcType=DECIMAL},
      #{otherToUsdExchangeRate,jdbcType=DECIMAL}, #{orderCurrency,jdbcType=VARCHAR},
      #{otherCurrency,jdbcType=VARCHAR}, #{sellerName,jdbcType=VARCHAR}, #{bailunOrderId,jdbcType=VARCHAR},
      #{platformOrderStatus,jdbcType=VARCHAR}, #{bailunOrderStatus,jdbcType=VARCHAR},
      #{bailunPaymentStatus,jdbcType=VARCHAR}, #{bailunInterceptionStatus,jdbcType=VARCHAR},
      #{shippingStatus,jdbcType=VARCHAR}, #{bailunSku,jdbcType=VARCHAR}, #{bailunSkuTitleEn,jdbcType=VARCHAR},
      #{bailunSkuTitleCn,jdbcType=VARCHAR}, #{bailunSkuQuantityOrdered,jdbcType=INTEGER},
      #{bailunSkuQuantityShipped,jdbcType=INTEGER}, #{bailunSkuQuantityRefund,jdbcType=INTEGER},
      #{bailunSkuQuantityPicked,jdbcType=INTEGER}, #{warehouseName,jdbcType=VARCHAR},
      #{warehouseCodeFba,jdbcType=VARCHAR}, #{warehouseCode,jdbcType=VARCHAR}, #{bailunSkuUnitPrice,jdbcType=DECIMAL},
      #{bailunSkuWeight,jdbcType=DECIMAL}, #{bailunSkuSize,jdbcType=VARCHAR}, #{amountSales,jdbcType=DECIMAL},
      #{amountTotal,jdbcType=DECIMAL}, #{amountShipping,jdbcType=DECIMAL}, #{amountProduct,jdbcType=DECIMAL},
      #{amountTax,jdbcType=DECIMAL}, #{amountAdjustment,jdbcType=DECIMAL}, #{amountGiftWrap,jdbcType=DECIMAL},
      #{amountRefund,jdbcType=DECIMAL}, #{amountPrepaid,jdbcType=DECIMAL}, #{costTotal,jdbcType=DECIMAL},
      #{costPromotion,jdbcType=DECIMAL}, #{costPlatformFee,jdbcType=DECIMAL}, #{costProduct,jdbcType=DECIMAL},
      #{costShipping,jdbcType=DECIMAL}, #{costPackage,jdbcType=DECIMAL}, #{costFbaFee,jdbcType=DECIMAL},
      #{costPaypalFee,jdbcType=DECIMAL}, #{costRefundCommisson,jdbcType=DECIMAL}, #{costHandleBailun,jdbcType=DECIMAL},
      #{costHandlePlatform,jdbcType=DECIMAL}, #{costTail,jdbcType=DECIMAL}, #{costFirst,jdbcType=DECIMAL},
      #{costLogistics,jdbcType=DECIMAL}, #{profitTotal,jdbcType=DECIMAL}, #{profitRate,jdbcType=DECIMAL},
      #{receiptCountry,jdbcType=VARCHAR}, #{receiptCity,jdbcType=VARCHAR}, #{receiptArea,jdbcType=VARCHAR},
      #{receiptAddress,jdbcType=VARCHAR}, #{receiptAddress2,jdbcType=VARCHAR}, #{receiptPostalCode,jdbcType=VARCHAR},
      #{receiver,jdbcType=VARCHAR}, #{receiverPhone,jdbcType=VARCHAR}, #{buyerId,jdbcType=VARCHAR},
      #{buyerName,jdbcType=VARCHAR}, #{buyerEmail,jdbcType=VARCHAR}, #{hasFbaException,jdbcType=BIT},
      #{hasPlatformException,jdbcType=BIT}, #{hasCancle,jdbcType=BIT}, #{areaId,jdbcType=INTEGER},
      #{bailunCategoryId,jdbcType=INTEGER}, #{bailunCategoryName,jdbcType=VARCHAR}, #{gmtCreate,jdbcType=TIMESTAMP},
      #{gmtModified,jdbcType=TIMESTAMP}, #{ratioWeight,jdbcType=DECIMAL}, #{ratioPrice,jdbcType=DECIMAL},
      #{bailunPickingStatus,jdbcType=VARCHAR}, #{bailunRequireLogistics,jdbcType=VARCHAR},
      #{hasDelete,jdbcType=BIT}, #{hasScalp,jdbcType=BIT}, #{hasBuyerRemark,jdbcType=BIT},
      #{hasPlatskuRemark,jdbcType=BIT}, #{logisticsMethodCode,jdbcType=VARCHAR}, #{logisticsMethodName,jdbcType=VARCHAR},
      #{hasInnersale,jdbcType=BIT}, #{companyId,jdbcType=INTEGER}, #{bailunRefundStatus,jdbcType=VARCHAR},
      #{refundObj,jdbcType=VARCHAR}, #{refundType,jdbcType=VARCHAR}, #{refundReferenceId,jdbcType=VARCHAR},
      #{hasFbaS,jdbcType=BIT}, #{bailunSkuQuantityPushed,jdbcType=INTEGER}, #{amountGeneralCargo,jdbcType=DECIMAL},
      #{hasTransferOrder,jdbcType=BIT})
  </insert>
  <insert id="insertSelective" parameterType="com.bailuntec.domain.entity.DcBaseOmsSku30">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    insert into dc_base_oms_sku_30
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="id != null">
        id,
      </if>
      <if test="originOrderId != null">
        origin_order_id,
      </if>
      <if test="platformType != null">
        platform_type,
      </if>
      <if test="transactionId != null">
        transaction_id,
      </if>
      <if test="payTime != null">
        pay_time,
      </if>
      <if test="payMethod != null">
        pay_method,
      </if>
      <if test="payAccount != null">
        pay_account,
      </if>
      <if test="payStatus != null">
        pay_status,
      </if>
      <if test="collectionAccount != null">
        collection_account,
      </if>
      <if test="platformOrderType != null">
        platform_order_type,
      </if>
      <if test="website != null">
        website,
      </if>
      <if test="createTime != null">
        create_time,
      </if>
      <if test="paidTime != null">
        paid_time,
      </if>
      <if test="refundTime != null">
        refund_time,
      </if>
      <if test="sellerId != null">
        seller_id,
      </if>
      <if test="bailunAccountId != null">
        bailun_account_id,
      </if>
      <if test="hqAccount != null">
        hq_account,
      </if>
      <if test="sellerAccount != null">
        seller_account,
      </if>
      <if test="sellerOrderId != null">
        seller_order_id,
      </if>
      <if test="sellerEmail != null">
        seller_email,
      </if>
      <if test="orderUpdateTime != null">
        order_update_time,
      </if>
      <if test="sellerOrderExchangeRate != null">
        seller_order_exchange_rate,
      </if>
      <if test="sellerOtherExchangeRate != null">
        seller_other_exchange_rate,
      </if>
      <if test="financeOrderExchangeRate != null">
        finance_order_exchange_rate,
      </if>
      <if test="financeOtherExchangeRate != null">
        finance_other_exchange_rate,
      </if>
      <if test="cnyToUsdExchangeRate != null">
        cny_to_usd_exchange_rate,
      </if>
      <if test="orderToUsdExchangeRate != null">
        order_to_usd_exchange_rate,
      </if>
      <if test="otherToUsdExchangeRate != null">
        other_to_usd_exchange_rate,
      </if>
      <if test="orderCurrency != null">
        order_currency,
      </if>
      <if test="otherCurrency != null">
        other_currency,
      </if>
      <if test="sellerName != null">
        seller_name,
      </if>
      <if test="bailunOrderId != null">
        bailun_order_id,
      </if>
      <if test="platformOrderStatus != null">
        platform_order_status,
      </if>
      <if test="bailunOrderStatus != null">
        bailun_order_status,
      </if>
      <if test="bailunPaymentStatus != null">
        bailun_payment_status,
      </if>
      <if test="bailunInterceptionStatus != null">
        bailun_interception_status,
      </if>
      <if test="shippingStatus != null">
        shipping_status,
      </if>
      <if test="bailunSku != null">
        bailun_sku,
      </if>
      <if test="bailunSkuTitleEn != null">
        bailun_sku_title_en,
      </if>
      <if test="bailunSkuTitleCn != null">
        bailun_sku_title_cn,
      </if>
      <if test="bailunSkuQuantityOrdered != null">
        bailun_sku_quantity_ordered,
      </if>
      <if test="bailunSkuQuantityShipped != null">
        bailun_sku_quantity_shipped,
      </if>
      <if test="bailunSkuQuantityRefund != null">
        bailun_sku_quantity_refund,
      </if>
      <if test="bailunSkuQuantityPicked != null">
        bailun_sku_quantity_picked,
      </if>
      <if test="warehouseName != null">
        warehouse_name,
      </if>
      <if test="warehouseCodeFba != null">
        warehouse_code_fba,
      </if>
      <if test="warehouseCode != null">
        warehouse_code,
      </if>
      <if test="bailunSkuUnitPrice != null">
        bailun_sku_unit_price,
      </if>
      <if test="bailunSkuWeight != null">
        bailun_sku_weight,
      </if>
      <if test="bailunSkuSize != null">
        bailun_sku_size,
      </if>
      <if test="amountSales != null">
        amount_sales,
      </if>
      <if test="amountTotal != null">
        amount_total,
      </if>
      <if test="amountShipping != null">
        amount_shipping,
      </if>
      <if test="amountProduct != null">
        amount_product,
      </if>
      <if test="amountTax != null">
        amount_tax,
      </if>
      <if test="amountAdjustment != null">
        amount_adjustment,
      </if>
      <if test="amountGiftWrap != null">
        amount_gift_wrap,
      </if>
      <if test="amountRefund != null">
        amount_refund,
      </if>
      <if test="amountPrepaid != null">
        amount_prepaid,
      </if>
      <if test="costTotal != null">
        cost_total,
      </if>
      <if test="costPromotion != null">
        cost_promotion,
      </if>
      <if test="costPlatformFee != null">
        cost_platform_fee,
      </if>
      <if test="costProduct != null">
        cost_product,
      </if>
      <if test="costShipping != null">
        cost_shipping,
      </if>
      <if test="costPackage != null">
        cost_package,
      </if>
      <if test="costFbaFee != null">
        cost_fba_fee,
      </if>
      <if test="costPaypalFee != null">
        cost_paypal_fee,
      </if>
      <if test="costRefundCommisson != null">
        cost_refund_commisson,
      </if>
      <if test="costHandleBailun != null">
        cost_handle_bailun,
      </if>
      <if test="costHandlePlatform != null">
        cost_handle_platform,
      </if>
      <if test="costTail != null">
        cost_tail,
      </if>
      <if test="costFirst != null">
        cost_first,
      </if>
      <if test="costLogistics != null">
        cost_logistics,
      </if>
      <if test="profitTotal != null">
        profit_total,
      </if>
      <if test="profitRate != null">
        profit_rate,
      </if>
      <if test="receiptCountry != null">
        receipt_country,
      </if>
      <if test="receiptCity != null">
        receipt_city,
      </if>
      <if test="receiptArea != null">
        receipt_area,
      </if>
      <if test="receiptAddress != null">
        receipt_address,
      </if>
      <if test="receiptAddress2 != null">
        receipt_address_2,
      </if>
      <if test="receiptPostalCode != null">
        receipt_postal_code,
      </if>
      <if test="receiver != null">
        receiver,
      </if>
      <if test="receiverPhone != null">
        receiver_phone,
      </if>
      <if test="buyerId != null">
        buyer_id,
      </if>
      <if test="buyerName != null">
        buyer_name,
      </if>
      <if test="buyerEmail != null">
        buyer_email,
      </if>
      <if test="hasFbaException != null">
        has_fba_exception,
      </if>
      <if test="hasPlatformException != null">
        has_platform_exception,
      </if>
      <if test="hasCancle != null">
        has_cancle,
      </if>
      <if test="areaId != null">
        area_id,
      </if>
      <if test="bailunCategoryId != null">
        bailun_category_id,
      </if>
      <if test="bailunCategoryName != null">
        bailun_category_name,
      </if>
      <if test="gmtCreate != null">
        gmt_create,
      </if>
      <if test="gmtModified != null">
        gmt_modified,
      </if>
      <if test="ratioWeight != null">
        ratio_weight,
      </if>
      <if test="ratioPrice != null">
        ratio_price,
      </if>
      <if test="bailunPickingStatus != null">
        bailun_picking_status,
      </if>
      <if test="bailunRequireLogistics != null">
        bailun_require_logistics,
      </if>
      <if test="hasDelete != null">
        has_delete,
      </if>
      <if test="hasScalp != null">
        has_scalp,
      </if>
      <if test="hasBuyerRemark != null">
        has_buyer_remark,
      </if>
      <if test="hasPlatskuRemark != null">
        has_platsku_remark,
      </if>
      <if test="logisticsMethodCode != null">
        logistics_method_code,
      </if>
      <if test="logisticsMethodName != null">
        logistics_method_name,
      </if>
      <if test="hasInnersale != null">
        has_innersale,
      </if>
      <if test="companyId != null">
        company_id,
      </if>
      <if test="bailunRefundStatus != null">
        bailun_refund_status,
      </if>
      <if test="refundObj != null">
        refund_obj,
      </if>
      <if test="refundType != null">
        refund_type,
      </if>
      <if test="refundReferenceId != null">
        refund_reference_id,
      </if>
      <if test="hasFbaS != null">
        has_fba_s,
      </if>
      <if test="bailunSkuQuantityPushed != null">
        bailun_sku_quantity_pushed,
      </if>
      <if test="amountGeneralCargo != null">
        amount_general_cargo,
      </if>
      <if test="hasTransferOrder != null">
        has_transfer_order,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="id != null">
        #{id,jdbcType=INTEGER},
      </if>
      <if test="originOrderId != null">
        #{originOrderId,jdbcType=VARCHAR},
      </if>
      <if test="platformType != null">
        #{platformType,jdbcType=VARCHAR},
      </if>
      <if test="transactionId != null">
        #{transactionId,jdbcType=VARCHAR},
      </if>
      <if test="payTime != null">
        #{payTime,jdbcType=TIMESTAMP},
      </if>
      <if test="payMethod != null">
        #{payMethod,jdbcType=VARCHAR},
      </if>
      <if test="payAccount != null">
        #{payAccount,jdbcType=VARCHAR},
      </if>
      <if test="payStatus != null">
        #{payStatus,jdbcType=VARCHAR},
      </if>
      <if test="collectionAccount != null">
        #{collectionAccount,jdbcType=VARCHAR},
      </if>
      <if test="platformOrderType != null">
        #{platformOrderType,jdbcType=VARCHAR},
      </if>
      <if test="website != null">
        #{website,jdbcType=VARCHAR},
      </if>
      <if test="createTime != null">
        #{createTime,jdbcType=TIMESTAMP},
      </if>
      <if test="paidTime != null">
        #{paidTime,jdbcType=TIMESTAMP},
      </if>
      <if test="refundTime != null">
        #{refundTime,jdbcType=TIMESTAMP},
      </if>
      <if test="sellerId != null">
        #{sellerId,jdbcType=VARCHAR},
      </if>
      <if test="bailunAccountId != null">
        #{bailunAccountId,jdbcType=INTEGER},
      </if>
      <if test="hqAccount != null">
        #{hqAccount,jdbcType=VARCHAR},
      </if>
      <if test="sellerAccount != null">
        #{sellerAccount,jdbcType=VARCHAR},
      </if>
      <if test="sellerOrderId != null">
        #{sellerOrderId,jdbcType=VARCHAR},
      </if>
      <if test="sellerEmail != null">
        #{sellerEmail,jdbcType=VARCHAR},
      </if>
      <if test="orderUpdateTime != null">
        #{orderUpdateTime,jdbcType=TIMESTAMP},
      </if>
      <if test="sellerOrderExchangeRate != null">
        #{sellerOrderExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="sellerOtherExchangeRate != null">
        #{sellerOtherExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="financeOrderExchangeRate != null">
        #{financeOrderExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="financeOtherExchangeRate != null">
        #{financeOtherExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="cnyToUsdExchangeRate != null">
        #{cnyToUsdExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="orderToUsdExchangeRate != null">
        #{orderToUsdExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="otherToUsdExchangeRate != null">
        #{otherToUsdExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="orderCurrency != null">
        #{orderCurrency,jdbcType=VARCHAR},
      </if>
      <if test="otherCurrency != null">
        #{otherCurrency,jdbcType=VARCHAR},
      </if>
      <if test="sellerName != null">
        #{sellerName,jdbcType=VARCHAR},
      </if>
      <if test="bailunOrderId != null">
        #{bailunOrderId,jdbcType=VARCHAR},
      </if>
      <if test="platformOrderStatus != null">
        #{platformOrderStatus,jdbcType=VARCHAR},
      </if>
      <if test="bailunOrderStatus != null">
        #{bailunOrderStatus,jdbcType=VARCHAR},
      </if>
      <if test="bailunPaymentStatus != null">
        #{bailunPaymentStatus,jdbcType=VARCHAR},
      </if>
      <if test="bailunInterceptionStatus != null">
        #{bailunInterceptionStatus,jdbcType=VARCHAR},
      </if>
      <if test="shippingStatus != null">
        #{shippingStatus,jdbcType=VARCHAR},
      </if>
      <if test="bailunSku != null">
        #{bailunSku,jdbcType=VARCHAR},
      </if>
      <if test="bailunSkuTitleEn != null">
        #{bailunSkuTitleEn,jdbcType=VARCHAR},
      </if>
      <if test="bailunSkuTitleCn != null">
        #{bailunSkuTitleCn,jdbcType=VARCHAR},
      </if>
      <if test="bailunSkuQuantityOrdered != null">
        #{bailunSkuQuantityOrdered,jdbcType=INTEGER},
      </if>
      <if test="bailunSkuQuantityShipped != null">
        #{bailunSkuQuantityShipped,jdbcType=INTEGER},
      </if>
      <if test="bailunSkuQuantityRefund != null">
        #{bailunSkuQuantityRefund,jdbcType=INTEGER},
      </if>
      <if test="bailunSkuQuantityPicked != null">
        #{bailunSkuQuantityPicked,jdbcType=INTEGER},
      </if>
      <if test="warehouseName != null">
        #{warehouseName,jdbcType=VARCHAR},
      </if>
      <if test="warehouseCodeFba != null">
        #{warehouseCodeFba,jdbcType=VARCHAR},
      </if>
      <if test="warehouseCode != null">
        #{warehouseCode,jdbcType=VARCHAR},
      </if>
      <if test="bailunSkuUnitPrice != null">
        #{bailunSkuUnitPrice,jdbcType=DECIMAL},
      </if>
      <if test="bailunSkuWeight != null">
        #{bailunSkuWeight,jdbcType=DECIMAL},
      </if>
      <if test="bailunSkuSize != null">
        #{bailunSkuSize,jdbcType=VARCHAR},
      </if>
      <if test="amountSales != null">
        #{amountSales,jdbcType=DECIMAL},
      </if>
      <if test="amountTotal != null">
        #{amountTotal,jdbcType=DECIMAL},
      </if>
      <if test="amountShipping != null">
        #{amountShipping,jdbcType=DECIMAL},
      </if>
      <if test="amountProduct != null">
        #{amountProduct,jdbcType=DECIMAL},
      </if>
      <if test="amountTax != null">
        #{amountTax,jdbcType=DECIMAL},
      </if>
      <if test="amountAdjustment != null">
        #{amountAdjustment,jdbcType=DECIMAL},
      </if>
      <if test="amountGiftWrap != null">
        #{amountGiftWrap,jdbcType=DECIMAL},
      </if>
      <if test="amountRefund != null">
        #{amountRefund,jdbcType=DECIMAL},
      </if>
      <if test="amountPrepaid != null">
        #{amountPrepaid,jdbcType=DECIMAL},
      </if>
      <if test="costTotal != null">
        #{costTotal,jdbcType=DECIMAL},
      </if>
      <if test="costPromotion != null">
        #{costPromotion,jdbcType=DECIMAL},
      </if>
      <if test="costPlatformFee != null">
        #{costPlatformFee,jdbcType=DECIMAL},
      </if>
      <if test="costProduct != null">
        #{costProduct,jdbcType=DECIMAL},
      </if>
      <if test="costShipping != null">
        #{costShipping,jdbcType=DECIMAL},
      </if>
      <if test="costPackage != null">
        #{costPackage,jdbcType=DECIMAL},
      </if>
      <if test="costFbaFee != null">
        #{costFbaFee,jdbcType=DECIMAL},
      </if>
      <if test="costPaypalFee != null">
        #{costPaypalFee,jdbcType=DECIMAL},
      </if>
      <if test="costRefundCommisson != null">
        #{costRefundCommisson,jdbcType=DECIMAL},
      </if>
      <if test="costHandleBailun != null">
        #{costHandleBailun,jdbcType=DECIMAL},
      </if>
      <if test="costHandlePlatform != null">
        #{costHandlePlatform,jdbcType=DECIMAL},
      </if>
      <if test="costTail != null">
        #{costTail,jdbcType=DECIMAL},
      </if>
      <if test="costFirst != null">
        #{costFirst,jdbcType=DECIMAL},
      </if>
      <if test="costLogistics != null">
        #{costLogistics,jdbcType=DECIMAL},
      </if>
      <if test="profitTotal != null">
        #{profitTotal,jdbcType=DECIMAL},
      </if>
      <if test="profitRate != null">
        #{profitRate,jdbcType=DECIMAL},
      </if>
      <if test="receiptCountry != null">
        #{receiptCountry,jdbcType=VARCHAR},
      </if>
      <if test="receiptCity != null">
        #{receiptCity,jdbcType=VARCHAR},
      </if>
      <if test="receiptArea != null">
        #{receiptArea,jdbcType=VARCHAR},
      </if>
      <if test="receiptAddress != null">
        #{receiptAddress,jdbcType=VARCHAR},
      </if>
      <if test="receiptAddress2 != null">
        #{receiptAddress2,jdbcType=VARCHAR},
      </if>
      <if test="receiptPostalCode != null">
        #{receiptPostalCode,jdbcType=VARCHAR},
      </if>
      <if test="receiver != null">
        #{receiver,jdbcType=VARCHAR},
      </if>
      <if test="receiverPhone != null">
        #{receiverPhone,jdbcType=VARCHAR},
      </if>
      <if test="buyerId != null">
        #{buyerId,jdbcType=VARCHAR},
      </if>
      <if test="buyerName != null">
        #{buyerName,jdbcType=VARCHAR},
      </if>
      <if test="buyerEmail != null">
        #{buyerEmail,jdbcType=VARCHAR},
      </if>
      <if test="hasFbaException != null">
        #{hasFbaException,jdbcType=BIT},
      </if>
      <if test="hasPlatformException != null">
        #{hasPlatformException,jdbcType=BIT},
      </if>
      <if test="hasCancle != null">
        #{hasCancle,jdbcType=BIT},
      </if>
      <if test="areaId != null">
        #{areaId,jdbcType=INTEGER},
      </if>
      <if test="bailunCategoryId != null">
        #{bailunCategoryId,jdbcType=INTEGER},
      </if>
      <if test="bailunCategoryName != null">
        #{bailunCategoryName,jdbcType=VARCHAR},
      </if>
      <if test="gmtCreate != null">
        #{gmtCreate,jdbcType=TIMESTAMP},
      </if>
      <if test="gmtModified != null">
        #{gmtModified,jdbcType=TIMESTAMP},
      </if>
      <if test="ratioWeight != null">
        #{ratioWeight,jdbcType=DECIMAL},
      </if>
      <if test="ratioPrice != null">
        #{ratioPrice,jdbcType=DECIMAL},
      </if>
      <if test="bailunPickingStatus != null">
        #{bailunPickingStatus,jdbcType=VARCHAR},
      </if>
      <if test="bailunRequireLogistics != null">
        #{bailunRequireLogistics,jdbcType=VARCHAR},
      </if>
      <if test="hasDelete != null">
        #{hasDelete,jdbcType=BIT},
      </if>
      <if test="hasScalp != null">
        #{hasScalp,jdbcType=BIT},
      </if>
      <if test="hasBuyerRemark != null">
        #{hasBuyerRemark,jdbcType=BIT},
      </if>
      <if test="hasPlatskuRemark != null">
        #{hasPlatskuRemark,jdbcType=BIT},
      </if>
      <if test="logisticsMethodCode != null">
        #{logisticsMethodCode,jdbcType=VARCHAR},
      </if>
      <if test="logisticsMethodName != null">
        #{logisticsMethodName,jdbcType=VARCHAR},
      </if>
      <if test="hasInnersale != null">
        #{hasInnersale,jdbcType=BIT},
      </if>
      <if test="companyId != null">
        #{companyId,jdbcType=INTEGER},
      </if>
      <if test="bailunRefundStatus != null">
        #{bailunRefundStatus,jdbcType=VARCHAR},
      </if>
      <if test="refundObj != null">
        #{refundObj,jdbcType=VARCHAR},
      </if>
      <if test="refundType != null">
        #{refundType,jdbcType=VARCHAR},
      </if>
      <if test="refundReferenceId != null">
        #{refundReferenceId,jdbcType=VARCHAR},
      </if>
      <if test="hasFbaS != null">
        #{hasFbaS,jdbcType=BIT},
      </if>
      <if test="bailunSkuQuantityPushed != null">
        #{bailunSkuQuantityPushed,jdbcType=INTEGER},
      </if>
      <if test="amountGeneralCargo != null">
        #{amountGeneralCargo,jdbcType=DECIMAL},
      </if>
      <if test="hasTransferOrder != null">
        #{hasTransferOrder,jdbcType=BIT},
      </if>
    </trim>
  </insert>
  <select id="countByExample" parameterType="com.bailuntec.domain.example.DcBaseOmsSku30Example" resultType="java.lang.Long">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    select count(*) from dc_base_oms_sku_30
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
  </select>
  <update id="updateByExampleSelective" parameterType="map">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update dc_base_oms_sku_30
    <set>
      <if test="record.id != null">
        id = #{record.id,jdbcType=INTEGER},
      </if>
      <if test="record.originOrderId != null">
        origin_order_id = #{record.originOrderId,jdbcType=VARCHAR},
      </if>
      <if test="record.platformType != null">
        platform_type = #{record.platformType,jdbcType=VARCHAR},
      </if>
      <if test="record.transactionId != null">
        transaction_id = #{record.transactionId,jdbcType=VARCHAR},
      </if>
      <if test="record.payTime != null">
        pay_time = #{record.payTime,jdbcType=TIMESTAMP},
      </if>
      <if test="record.payMethod != null">
        pay_method = #{record.payMethod,jdbcType=VARCHAR},
      </if>
      <if test="record.payAccount != null">
        pay_account = #{record.payAccount,jdbcType=VARCHAR},
      </if>
      <if test="record.payStatus != null">
        pay_status = #{record.payStatus,jdbcType=VARCHAR},
      </if>
      <if test="record.collectionAccount != null">
        collection_account = #{record.collectionAccount,jdbcType=VARCHAR},
      </if>
      <if test="record.platformOrderType != null">
        platform_order_type = #{record.platformOrderType,jdbcType=VARCHAR},
      </if>
      <if test="record.website != null">
        website = #{record.website,jdbcType=VARCHAR},
      </if>
      <if test="record.createTime != null">
        create_time = #{record.createTime,jdbcType=TIMESTAMP},
      </if>
      <if test="record.paidTime != null">
        paid_time = #{record.paidTime,jdbcType=TIMESTAMP},
      </if>
      <if test="record.refundTime != null">
        refund_time = #{record.refundTime,jdbcType=TIMESTAMP},
      </if>
      <if test="record.sellerId != null">
        seller_id = #{record.sellerId,jdbcType=VARCHAR},
      </if>
      <if test="record.bailunAccountId != null">
        bailun_account_id = #{record.bailunAccountId,jdbcType=INTEGER},
      </if>
      <if test="record.hqAccount != null">
        hq_account = #{record.hqAccount,jdbcType=VARCHAR},
      </if>
      <if test="record.sellerAccount != null">
        seller_account = #{record.sellerAccount,jdbcType=VARCHAR},
      </if>
      <if test="record.sellerOrderId != null">
        seller_order_id = #{record.sellerOrderId,jdbcType=VARCHAR},
      </if>
      <if test="record.sellerEmail != null">
        seller_email = #{record.sellerEmail,jdbcType=VARCHAR},
      </if>
      <if test="record.orderUpdateTime != null">
        order_update_time = #{record.orderUpdateTime,jdbcType=TIMESTAMP},
      </if>
      <if test="record.sellerOrderExchangeRate != null">
        seller_order_exchange_rate = #{record.sellerOrderExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="record.sellerOtherExchangeRate != null">
        seller_other_exchange_rate = #{record.sellerOtherExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="record.financeOrderExchangeRate != null">
        finance_order_exchange_rate = #{record.financeOrderExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="record.financeOtherExchangeRate != null">
        finance_other_exchange_rate = #{record.financeOtherExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="record.cnyToUsdExchangeRate != null">
        cny_to_usd_exchange_rate = #{record.cnyToUsdExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="record.orderToUsdExchangeRate != null">
        order_to_usd_exchange_rate = #{record.orderToUsdExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="record.otherToUsdExchangeRate != null">
        other_to_usd_exchange_rate = #{record.otherToUsdExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="record.orderCurrency != null">
        order_currency = #{record.orderCurrency,jdbcType=VARCHAR},
      </if>
      <if test="record.otherCurrency != null">
        other_currency = #{record.otherCurrency,jdbcType=VARCHAR},
      </if>
      <if test="record.sellerName != null">
        seller_name = #{record.sellerName,jdbcType=VARCHAR},
      </if>
      <if test="record.bailunOrderId != null">
        bailun_order_id = #{record.bailunOrderId,jdbcType=VARCHAR},
      </if>
      <if test="record.platformOrderStatus != null">
        platform_order_status = #{record.platformOrderStatus,jdbcType=VARCHAR},
      </if>
      <if test="record.bailunOrderStatus != null">
        bailun_order_status = #{record.bailunOrderStatus,jdbcType=VARCHAR},
      </if>
      <if test="record.bailunPaymentStatus != null">
        bailun_payment_status = #{record.bailunPaymentStatus,jdbcType=VARCHAR},
      </if>
      <if test="record.bailunInterceptionStatus != null">
        bailun_interception_status = #{record.bailunInterceptionStatus,jdbcType=VARCHAR},
      </if>
      <if test="record.shippingStatus != null">
        shipping_status = #{record.shippingStatus,jdbcType=VARCHAR},
      </if>
      <if test="record.bailunSku != null">
        bailun_sku = #{record.bailunSku,jdbcType=VARCHAR},
      </if>
      <if test="record.bailunSkuTitleEn != null">
        bailun_sku_title_en = #{record.bailunSkuTitleEn,jdbcType=VARCHAR},
      </if>
      <if test="record.bailunSkuTitleCn != null">
        bailun_sku_title_cn = #{record.bailunSkuTitleCn,jdbcType=VARCHAR},
      </if>
      <if test="record.bailunSkuQuantityOrdered != null">
        bailun_sku_quantity_ordered = #{record.bailunSkuQuantityOrdered,jdbcType=INTEGER},
      </if>
      <if test="record.bailunSkuQuantityShipped != null">
        bailun_sku_quantity_shipped = #{record.bailunSkuQuantityShipped,jdbcType=INTEGER},
      </if>
      <if test="record.bailunSkuQuantityRefund != null">
        bailun_sku_quantity_refund = #{record.bailunSkuQuantityRefund,jdbcType=INTEGER},
      </if>
      <if test="record.bailunSkuQuantityPicked != null">
        bailun_sku_quantity_picked = #{record.bailunSkuQuantityPicked,jdbcType=INTEGER},
      </if>
      <if test="record.warehouseName != null">
        warehouse_name = #{record.warehouseName,jdbcType=VARCHAR},
      </if>
      <if test="record.warehouseCodeFba != null">
        warehouse_code_fba = #{record.warehouseCodeFba,jdbcType=VARCHAR},
      </if>
      <if test="record.warehouseCode != null">
        warehouse_code = #{record.warehouseCode,jdbcType=VARCHAR},
      </if>
      <if test="record.bailunSkuUnitPrice != null">
        bailun_sku_unit_price = #{record.bailunSkuUnitPrice,jdbcType=DECIMAL},
      </if>
      <if test="record.bailunSkuWeight != null">
        bailun_sku_weight = #{record.bailunSkuWeight,jdbcType=DECIMAL},
      </if>
      <if test="record.bailunSkuSize != null">
        bailun_sku_size = #{record.bailunSkuSize,jdbcType=VARCHAR},
      </if>
      <if test="record.amountSales != null">
        amount_sales = #{record.amountSales,jdbcType=DECIMAL},
      </if>
      <if test="record.amountTotal != null">
        amount_total = #{record.amountTotal,jdbcType=DECIMAL},
      </if>
      <if test="record.amountShipping != null">
        amount_shipping = #{record.amountShipping,jdbcType=DECIMAL},
      </if>
      <if test="record.amountProduct != null">
        amount_product = #{record.amountProduct,jdbcType=DECIMAL},
      </if>
      <if test="record.amountTax != null">
        amount_tax = #{record.amountTax,jdbcType=DECIMAL},
      </if>
      <if test="record.amountAdjustment != null">
        amount_adjustment = #{record.amountAdjustment,jdbcType=DECIMAL},
      </if>
      <if test="record.amountGiftWrap != null">
        amount_gift_wrap = #{record.amountGiftWrap,jdbcType=DECIMAL},
      </if>
      <if test="record.amountRefund != null">
        amount_refund = #{record.amountRefund,jdbcType=DECIMAL},
      </if>
      <if test="record.amountPrepaid != null">
        amount_prepaid = #{record.amountPrepaid,jdbcType=DECIMAL},
      </if>
      <if test="record.costTotal != null">
        cost_total = #{record.costTotal,jdbcType=DECIMAL},
      </if>
      <if test="record.costPromotion != null">
        cost_promotion = #{record.costPromotion,jdbcType=DECIMAL},
      </if>
      <if test="record.costPlatformFee != null">
        cost_platform_fee = #{record.costPlatformFee,jdbcType=DECIMAL},
      </if>
      <if test="record.costProduct != null">
        cost_product = #{record.costProduct,jdbcType=DECIMAL},
      </if>
      <if test="record.costShipping != null">
        cost_shipping = #{record.costShipping,jdbcType=DECIMAL},
      </if>
      <if test="record.costPackage != null">
        cost_package = #{record.costPackage,jdbcType=DECIMAL},
      </if>
      <if test="record.costFbaFee != null">
        cost_fba_fee = #{record.costFbaFee,jdbcType=DECIMAL},
      </if>
      <if test="record.costPaypalFee != null">
        cost_paypal_fee = #{record.costPaypalFee,jdbcType=DECIMAL},
      </if>
      <if test="record.costRefundCommisson != null">
        cost_refund_commisson = #{record.costRefundCommisson,jdbcType=DECIMAL},
      </if>
      <if test="record.costHandleBailun != null">
        cost_handle_bailun = #{record.costHandleBailun,jdbcType=DECIMAL},
      </if>
      <if test="record.costHandlePlatform != null">
        cost_handle_platform = #{record.costHandlePlatform,jdbcType=DECIMAL},
      </if>
      <if test="record.costTail != null">
        cost_tail = #{record.costTail,jdbcType=DECIMAL},
      </if>
      <if test="record.costFirst != null">
        cost_first = #{record.costFirst,jdbcType=DECIMAL},
      </if>
      <if test="record.costLogistics != null">
        cost_logistics = #{record.costLogistics,jdbcType=DECIMAL},
      </if>
      <if test="record.profitTotal != null">
        profit_total = #{record.profitTotal,jdbcType=DECIMAL},
      </if>
      <if test="record.profitRate != null">
        profit_rate = #{record.profitRate,jdbcType=DECIMAL},
      </if>
      <if test="record.receiptCountry != null">
        receipt_country = #{record.receiptCountry,jdbcType=VARCHAR},
      </if>
      <if test="record.receiptCity != null">
        receipt_city = #{record.receiptCity,jdbcType=VARCHAR},
      </if>
      <if test="record.receiptArea != null">
        receipt_area = #{record.receiptArea,jdbcType=VARCHAR},
      </if>
      <if test="record.receiptAddress != null">
        receipt_address = #{record.receiptAddress,jdbcType=VARCHAR},
      </if>
      <if test="record.receiptAddress2 != null">
        receipt_address_2 = #{record.receiptAddress2,jdbcType=VARCHAR},
      </if>
      <if test="record.receiptPostalCode != null">
        receipt_postal_code = #{record.receiptPostalCode,jdbcType=VARCHAR},
      </if>
      <if test="record.receiver != null">
        receiver = #{record.receiver,jdbcType=VARCHAR},
      </if>
      <if test="record.receiverPhone != null">
        receiver_phone = #{record.receiverPhone,jdbcType=VARCHAR},
      </if>
      <if test="record.buyerId != null">
        buyer_id = #{record.buyerId,jdbcType=VARCHAR},
      </if>
      <if test="record.buyerName != null">
        buyer_name = #{record.buyerName,jdbcType=VARCHAR},
      </if>
      <if test="record.buyerEmail != null">
        buyer_email = #{record.buyerEmail,jdbcType=VARCHAR},
      </if>
      <if test="record.hasFbaException != null">
        has_fba_exception = #{record.hasFbaException,jdbcType=BIT},
      </if>
      <if test="record.hasPlatformException != null">
        has_platform_exception = #{record.hasPlatformException,jdbcType=BIT},
      </if>
      <if test="record.hasCancle != null">
        has_cancle = #{record.hasCancle,jdbcType=BIT},
      </if>
      <if test="record.areaId != null">
        area_id = #{record.areaId,jdbcType=INTEGER},
      </if>
      <if test="record.bailunCategoryId != null">
        bailun_category_id = #{record.bailunCategoryId,jdbcType=INTEGER},
      </if>
      <if test="record.bailunCategoryName != null">
        bailun_category_name = #{record.bailunCategoryName,jdbcType=VARCHAR},
      </if>
      <if test="record.gmtCreate != null">
        gmt_create = #{record.gmtCreate,jdbcType=TIMESTAMP},
      </if>
      <if test="record.gmtModified != null">
        gmt_modified = #{record.gmtModified,jdbcType=TIMESTAMP},
      </if>
      <if test="record.ratioWeight != null">
        ratio_weight = #{record.ratioWeight,jdbcType=DECIMAL},
      </if>
      <if test="record.ratioPrice != null">
        ratio_price = #{record.ratioPrice,jdbcType=DECIMAL},
      </if>
      <if test="record.bailunPickingStatus != null">
        bailun_picking_status = #{record.bailunPickingStatus,jdbcType=VARCHAR},
      </if>
      <if test="record.bailunRequireLogistics != null">
        bailun_require_logistics = #{record.bailunRequireLogistics,jdbcType=VARCHAR},
      </if>
      <if test="record.hasDelete != null">
        has_delete = #{record.hasDelete,jdbcType=BIT},
      </if>
      <if test="record.hasScalp != null">
        has_scalp = #{record.hasScalp,jdbcType=BIT},
      </if>
      <if test="record.hasBuyerRemark != null">
        has_buyer_remark = #{record.hasBuyerRemark,jdbcType=BIT},
      </if>
      <if test="record.hasPlatskuRemark != null">
        has_platsku_remark = #{record.hasPlatskuRemark,jdbcType=BIT},
      </if>
      <if test="record.logisticsMethodCode != null">
        logistics_method_code = #{record.logisticsMethodCode,jdbcType=VARCHAR},
      </if>
      <if test="record.logisticsMethodName != null">
        logistics_method_name = #{record.logisticsMethodName,jdbcType=VARCHAR},
      </if>
      <if test="record.hasInnersale != null">
        has_innersale = #{record.hasInnersale,jdbcType=BIT},
      </if>
      <if test="record.companyId != null">
        company_id = #{record.companyId,jdbcType=INTEGER},
      </if>
      <if test="record.bailunRefundStatus != null">
        bailun_refund_status = #{record.bailunRefundStatus,jdbcType=VARCHAR},
      </if>
      <if test="record.refundObj != null">
        refund_obj = #{record.refundObj,jdbcType=VARCHAR},
      </if>
      <if test="record.refundType != null">
        refund_type = #{record.refundType,jdbcType=VARCHAR},
      </if>
      <if test="record.refundReferenceId != null">
        refund_reference_id = #{record.refundReferenceId,jdbcType=VARCHAR},
      </if>
      <if test="record.hasFbaS != null">
        has_fba_s = #{record.hasFbaS,jdbcType=BIT},
      </if>
      <if test="record.bailunSkuQuantityPushed != null">
        bailun_sku_quantity_pushed = #{record.bailunSkuQuantityPushed,jdbcType=INTEGER},
      </if>
      <if test="record.amountGeneralCargo != null">
        amount_general_cargo = #{record.amountGeneralCargo,jdbcType=DECIMAL},
      </if>
      <if test="record.hasTransferOrder != null">
        has_transfer_order = #{record.hasTransferOrder,jdbcType=BIT},
      </if>
    </set>
    <if test="_parameter != null">
      <include refid="Update_By_Example_Where_Clause" />
    </if>
  </update>
  <update id="updateByExample" parameterType="map">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update dc_base_oms_sku_30
    set id = #{record.id,jdbcType=INTEGER},
      origin_order_id = #{record.originOrderId,jdbcType=VARCHAR},
      platform_type = #{record.platformType,jdbcType=VARCHAR},
      transaction_id = #{record.transactionId,jdbcType=VARCHAR},
      pay_time = #{record.payTime,jdbcType=TIMESTAMP},
      pay_method = #{record.payMethod,jdbcType=VARCHAR},
      pay_account = #{record.payAccount,jdbcType=VARCHAR},
      pay_status = #{record.payStatus,jdbcType=VARCHAR},
      collection_account = #{record.collectionAccount,jdbcType=VARCHAR},
      platform_order_type = #{record.platformOrderType,jdbcType=VARCHAR},
      website = #{record.website,jdbcType=VARCHAR},
      create_time = #{record.createTime,jdbcType=TIMESTAMP},
      paid_time = #{record.paidTime,jdbcType=TIMESTAMP},
      refund_time = #{record.refundTime,jdbcType=TIMESTAMP},
      seller_id = #{record.sellerId,jdbcType=VARCHAR},
      bailun_account_id = #{record.bailunAccountId,jdbcType=INTEGER},
      hq_account = #{record.hqAccount,jdbcType=VARCHAR},
      seller_account = #{record.sellerAccount,jdbcType=VARCHAR},
      seller_order_id = #{record.sellerOrderId,jdbcType=VARCHAR},
      seller_email = #{record.sellerEmail,jdbcType=VARCHAR},
      order_update_time = #{record.orderUpdateTime,jdbcType=TIMESTAMP},
      seller_order_exchange_rate = #{record.sellerOrderExchangeRate,jdbcType=DECIMAL},
      seller_other_exchange_rate = #{record.sellerOtherExchangeRate,jdbcType=DECIMAL},
      finance_order_exchange_rate = #{record.financeOrderExchangeRate,jdbcType=DECIMAL},
      finance_other_exchange_rate = #{record.financeOtherExchangeRate,jdbcType=DECIMAL},
      cny_to_usd_exchange_rate = #{record.cnyToUsdExchangeRate,jdbcType=DECIMAL},
      order_to_usd_exchange_rate = #{record.orderToUsdExchangeRate,jdbcType=DECIMAL},
      other_to_usd_exchange_rate = #{record.otherToUsdExchangeRate,jdbcType=DECIMAL},
      order_currency = #{record.orderCurrency,jdbcType=VARCHAR},
      other_currency = #{record.otherCurrency,jdbcType=VARCHAR},
      seller_name = #{record.sellerName,jdbcType=VARCHAR},
      bailun_order_id = #{record.bailunOrderId,jdbcType=VARCHAR},
      platform_order_status = #{record.platformOrderStatus,jdbcType=VARCHAR},
      bailun_order_status = #{record.bailunOrderStatus,jdbcType=VARCHAR},
      bailun_payment_status = #{record.bailunPaymentStatus,jdbcType=VARCHAR},
      bailun_interception_status = #{record.bailunInterceptionStatus,jdbcType=VARCHAR},
      shipping_status = #{record.shippingStatus,jdbcType=VARCHAR},
      bailun_sku = #{record.bailunSku,jdbcType=VARCHAR},
      bailun_sku_title_en = #{record.bailunSkuTitleEn,jdbcType=VARCHAR},
      bailun_sku_title_cn = #{record.bailunSkuTitleCn,jdbcType=VARCHAR},
      bailun_sku_quantity_ordered = #{record.bailunSkuQuantityOrdered,jdbcType=INTEGER},
      bailun_sku_quantity_shipped = #{record.bailunSkuQuantityShipped,jdbcType=INTEGER},
      bailun_sku_quantity_refund = #{record.bailunSkuQuantityRefund,jdbcType=INTEGER},
      bailun_sku_quantity_picked = #{record.bailunSkuQuantityPicked,jdbcType=INTEGER},
      warehouse_name = #{record.warehouseName,jdbcType=VARCHAR},
      warehouse_code_fba = #{record.warehouseCodeFba,jdbcType=VARCHAR},
      warehouse_code = #{record.warehouseCode,jdbcType=VARCHAR},
      bailun_sku_unit_price = #{record.bailunSkuUnitPrice,jdbcType=DECIMAL},
      bailun_sku_weight = #{record.bailunSkuWeight,jdbcType=DECIMAL},
      bailun_sku_size = #{record.bailunSkuSize,jdbcType=VARCHAR},
      amount_sales = #{record.amountSales,jdbcType=DECIMAL},
      amount_total = #{record.amountTotal,jdbcType=DECIMAL},
      amount_shipping = #{record.amountShipping,jdbcType=DECIMAL},
      amount_product = #{record.amountProduct,jdbcType=DECIMAL},
      amount_tax = #{record.amountTax,jdbcType=DECIMAL},
      amount_adjustment = #{record.amountAdjustment,jdbcType=DECIMAL},
      amount_gift_wrap = #{record.amountGiftWrap,jdbcType=DECIMAL},
      amount_refund = #{record.amountRefund,jdbcType=DECIMAL},
      amount_prepaid = #{record.amountPrepaid,jdbcType=DECIMAL},
      cost_total = #{record.costTotal,jdbcType=DECIMAL},
      cost_promotion = #{record.costPromotion,jdbcType=DECIMAL},
      cost_platform_fee = #{record.costPlatformFee,jdbcType=DECIMAL},
      cost_product = #{record.costProduct,jdbcType=DECIMAL},
      cost_shipping = #{record.costShipping,jdbcType=DECIMAL},
      cost_package = #{record.costPackage,jdbcType=DECIMAL},
      cost_fba_fee = #{record.costFbaFee,jdbcType=DECIMAL},
      cost_paypal_fee = #{record.costPaypalFee,jdbcType=DECIMAL},
      cost_refund_commisson = #{record.costRefundCommisson,jdbcType=DECIMAL},
      cost_handle_bailun = #{record.costHandleBailun,jdbcType=DECIMAL},
      cost_handle_platform = #{record.costHandlePlatform,jdbcType=DECIMAL},
      cost_tail = #{record.costTail,jdbcType=DECIMAL},
      cost_first = #{record.costFirst,jdbcType=DECIMAL},
      cost_logistics = #{record.costLogistics,jdbcType=DECIMAL},
      profit_total = #{record.profitTotal,jdbcType=DECIMAL},
      profit_rate = #{record.profitRate,jdbcType=DECIMAL},
      receipt_country = #{record.receiptCountry,jdbcType=VARCHAR},
      receipt_city = #{record.receiptCity,jdbcType=VARCHAR},
      receipt_area = #{record.receiptArea,jdbcType=VARCHAR},
      receipt_address = #{record.receiptAddress,jdbcType=VARCHAR},
      receipt_address_2 = #{record.receiptAddress2,jdbcType=VARCHAR},
      receipt_postal_code = #{record.receiptPostalCode,jdbcType=VARCHAR},
      receiver = #{record.receiver,jdbcType=VARCHAR},
      receiver_phone = #{record.receiverPhone,jdbcType=VARCHAR},
      buyer_id = #{record.buyerId,jdbcType=VARCHAR},
      buyer_name = #{record.buyerName,jdbcType=VARCHAR},
      buyer_email = #{record.buyerEmail,jdbcType=VARCHAR},
      has_fba_exception = #{record.hasFbaException,jdbcType=BIT},
      has_platform_exception = #{record.hasPlatformException,jdbcType=BIT},
      has_cancle = #{record.hasCancle,jdbcType=BIT},
      area_id = #{record.areaId,jdbcType=INTEGER},
      bailun_category_id = #{record.bailunCategoryId,jdbcType=INTEGER},
      bailun_category_name = #{record.bailunCategoryName,jdbcType=VARCHAR},
      gmt_create = #{record.gmtCreate,jdbcType=TIMESTAMP},
      gmt_modified = #{record.gmtModified,jdbcType=TIMESTAMP},
      ratio_weight = #{record.ratioWeight,jdbcType=DECIMAL},
      ratio_price = #{record.ratioPrice,jdbcType=DECIMAL},
      bailun_picking_status = #{record.bailunPickingStatus,jdbcType=VARCHAR},
      bailun_require_logistics = #{record.bailunRequireLogistics,jdbcType=VARCHAR},
      has_delete = #{record.hasDelete,jdbcType=BIT},
      has_scalp = #{record.hasScalp,jdbcType=BIT},
      has_buyer_remark = #{record.hasBuyerRemark,jdbcType=BIT},
      has_platsku_remark = #{record.hasPlatskuRemark,jdbcType=BIT},
      logistics_method_code = #{record.logisticsMethodCode,jdbcType=VARCHAR},
      logistics_method_name = #{record.logisticsMethodName,jdbcType=VARCHAR},
      has_innersale = #{record.hasInnersale,jdbcType=BIT},
      company_id = #{record.companyId,jdbcType=INTEGER},
      bailun_refund_status = #{record.bailunRefundStatus,jdbcType=VARCHAR},
      refund_obj = #{record.refundObj,jdbcType=VARCHAR},
      refund_type = #{record.refundType,jdbcType=VARCHAR},
      refund_reference_id = #{record.refundReferenceId,jdbcType=VARCHAR},
      has_fba_s = #{record.hasFbaS,jdbcType=BIT},
      bailun_sku_quantity_pushed = #{record.bailunSkuQuantityPushed,jdbcType=INTEGER},
      amount_general_cargo = #{record.amountGeneralCargo,jdbcType=DECIMAL},
      has_transfer_order = #{record.hasTransferOrder,jdbcType=BIT}
    <if test="_parameter != null">
      <include refid="Update_By_Example_Where_Clause" />
    </if>
  </update>
  <update id="updateByPrimaryKeySelective" parameterType="com.bailuntec.domain.entity.DcBaseOmsSku30">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update dc_base_oms_sku_30
    <set>
      <if test="originOrderId != null">
        origin_order_id = #{originOrderId,jdbcType=VARCHAR},
      </if>
      <if test="platformType != null">
        platform_type = #{platformType,jdbcType=VARCHAR},
      </if>
      <if test="transactionId != null">
        transaction_id = #{transactionId,jdbcType=VARCHAR},
      </if>
      <if test="payTime != null">
        pay_time = #{payTime,jdbcType=TIMESTAMP},
      </if>
      <if test="payMethod != null">
        pay_method = #{payMethod,jdbcType=VARCHAR},
      </if>
      <if test="payAccount != null">
        pay_account = #{payAccount,jdbcType=VARCHAR},
      </if>
      <if test="payStatus != null">
        pay_status = #{payStatus,jdbcType=VARCHAR},
      </if>
      <if test="collectionAccount != null">
        collection_account = #{collectionAccount,jdbcType=VARCHAR},
      </if>
      <if test="platformOrderType != null">
        platform_order_type = #{platformOrderType,jdbcType=VARCHAR},
      </if>
      <if test="website != null">
        website = #{website,jdbcType=VARCHAR},
      </if>
      <if test="createTime != null">
        create_time = #{createTime,jdbcType=TIMESTAMP},
      </if>
      <if test="paidTime != null">
        paid_time = #{paidTime,jdbcType=TIMESTAMP},
      </if>
      <if test="refundTime != null">
        refund_time = #{refundTime,jdbcType=TIMESTAMP},
      </if>
      <if test="sellerId != null">
        seller_id = #{sellerId,jdbcType=VARCHAR},
      </if>
      <if test="bailunAccountId != null">
        bailun_account_id = #{bailunAccountId,jdbcType=INTEGER},
      </if>
      <if test="hqAccount != null">
        hq_account = #{hqAccount,jdbcType=VARCHAR},
      </if>
      <if test="sellerAccount != null">
        seller_account = #{sellerAccount,jdbcType=VARCHAR},
      </if>
      <if test="sellerOrderId != null">
        seller_order_id = #{sellerOrderId,jdbcType=VARCHAR},
      </if>
      <if test="sellerEmail != null">
        seller_email = #{sellerEmail,jdbcType=VARCHAR},
      </if>
      <if test="orderUpdateTime != null">
        order_update_time = #{orderUpdateTime,jdbcType=TIMESTAMP},
      </if>
      <if test="sellerOrderExchangeRate != null">
        seller_order_exchange_rate = #{sellerOrderExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="sellerOtherExchangeRate != null">
        seller_other_exchange_rate = #{sellerOtherExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="financeOrderExchangeRate != null">
        finance_order_exchange_rate = #{financeOrderExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="financeOtherExchangeRate != null">
        finance_other_exchange_rate = #{financeOtherExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="cnyToUsdExchangeRate != null">
        cny_to_usd_exchange_rate = #{cnyToUsdExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="orderToUsdExchangeRate != null">
        order_to_usd_exchange_rate = #{orderToUsdExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="otherToUsdExchangeRate != null">
        other_to_usd_exchange_rate = #{otherToUsdExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="orderCurrency != null">
        order_currency = #{orderCurrency,jdbcType=VARCHAR},
      </if>
      <if test="otherCurrency != null">
        other_currency = #{otherCurrency,jdbcType=VARCHAR},
      </if>
      <if test="sellerName != null">
        seller_name = #{sellerName,jdbcType=VARCHAR},
      </if>
      <if test="bailunOrderId != null">
        bailun_order_id = #{bailunOrderId,jdbcType=VARCHAR},
      </if>
      <if test="platformOrderStatus != null">
        platform_order_status = #{platformOrderStatus,jdbcType=VARCHAR},
      </if>
      <if test="bailunOrderStatus != null">
        bailun_order_status = #{bailunOrderStatus,jdbcType=VARCHAR},
      </if>
      <if test="bailunPaymentStatus != null">
        bailun_payment_status = #{bailunPaymentStatus,jdbcType=VARCHAR},
      </if>
      <if test="bailunInterceptionStatus != null">
        bailun_interception_status = #{bailunInterceptionStatus,jdbcType=VARCHAR},
      </if>
      <if test="shippingStatus != null">
        shipping_status = #{shippingStatus,jdbcType=VARCHAR},
      </if>
      <if test="bailunSku != null">
        bailun_sku = #{bailunSku,jdbcType=VARCHAR},
      </if>
      <if test="bailunSkuTitleEn != null">
        bailun_sku_title_en = #{bailunSkuTitleEn,jdbcType=VARCHAR},
      </if>
      <if test="bailunSkuTitleCn != null">
        bailun_sku_title_cn = #{bailunSkuTitleCn,jdbcType=VARCHAR},
      </if>
      <if test="bailunSkuQuantityOrdered != null">
        bailun_sku_quantity_ordered = #{bailunSkuQuantityOrdered,jdbcType=INTEGER},
      </if>
      <if test="bailunSkuQuantityShipped != null">
        bailun_sku_quantity_shipped = #{bailunSkuQuantityShipped,jdbcType=INTEGER},
      </if>
      <if test="bailunSkuQuantityRefund != null">
        bailun_sku_quantity_refund = #{bailunSkuQuantityRefund,jdbcType=INTEGER},
      </if>
      <if test="bailunSkuQuantityPicked != null">
        bailun_sku_quantity_picked = #{bailunSkuQuantityPicked,jdbcType=INTEGER},
      </if>
      <if test="warehouseName != null">
        warehouse_name = #{warehouseName,jdbcType=VARCHAR},
      </if>
      <if test="warehouseCodeFba != null">
        warehouse_code_fba = #{warehouseCodeFba,jdbcType=VARCHAR},
      </if>
      <if test="warehouseCode != null">
        warehouse_code = #{warehouseCode,jdbcType=VARCHAR},
      </if>
      <if test="bailunSkuUnitPrice != null">
        bailun_sku_unit_price = #{bailunSkuUnitPrice,jdbcType=DECIMAL},
      </if>
      <if test="bailunSkuWeight != null">
        bailun_sku_weight = #{bailunSkuWeight,jdbcType=DECIMAL},
      </if>
      <if test="bailunSkuSize != null">
        bailun_sku_size = #{bailunSkuSize,jdbcType=VARCHAR},
      </if>
      <if test="amountSales != null">
        amount_sales = #{amountSales,jdbcType=DECIMAL},
      </if>
      <if test="amountTotal != null">
        amount_total = #{amountTotal,jdbcType=DECIMAL},
      </if>
      <if test="amountShipping != null">
        amount_shipping = #{amountShipping,jdbcType=DECIMAL},
      </if>
      <if test="amountProduct != null">
        amount_product = #{amountProduct,jdbcType=DECIMAL},
      </if>
      <if test="amountTax != null">
        amount_tax = #{amountTax,jdbcType=DECIMAL},
      </if>
      <if test="amountAdjustment != null">
        amount_adjustment = #{amountAdjustment,jdbcType=DECIMAL},
      </if>
      <if test="amountGiftWrap != null">
        amount_gift_wrap = #{amountGiftWrap,jdbcType=DECIMAL},
      </if>
      <if test="amountRefund != null">
        amount_refund = #{amountRefund,jdbcType=DECIMAL},
      </if>
      <if test="amountPrepaid != null">
        amount_prepaid = #{amountPrepaid,jdbcType=DECIMAL},
      </if>
      <if test="costTotal != null">
        cost_total = #{costTotal,jdbcType=DECIMAL},
      </if>
      <if test="costPromotion != null">
        cost_promotion = #{costPromotion,jdbcType=DECIMAL},
      </if>
      <if test="costPlatformFee != null">
        cost_platform_fee = #{costPlatformFee,jdbcType=DECIMAL},
      </if>
      <if test="costProduct != null">
        cost_product = #{costProduct,jdbcType=DECIMAL},
      </if>
      <if test="costShipping != null">
        cost_shipping = #{costShipping,jdbcType=DECIMAL},
      </if>
      <if test="costPackage != null">
        cost_package = #{costPackage,jdbcType=DECIMAL},
      </if>
      <if test="costFbaFee != null">
        cost_fba_fee = #{costFbaFee,jdbcType=DECIMAL},
      </if>
      <if test="costPaypalFee != null">
        cost_paypal_fee = #{costPaypalFee,jdbcType=DECIMAL},
      </if>
      <if test="costRefundCommisson != null">
        cost_refund_commisson = #{costRefundCommisson,jdbcType=DECIMAL},
      </if>
      <if test="costHandleBailun != null">
        cost_handle_bailun = #{costHandleBailun,jdbcType=DECIMAL},
      </if>
      <if test="costHandlePlatform != null">
        cost_handle_platform = #{costHandlePlatform,jdbcType=DECIMAL},
      </if>
      <if test="costTail != null">
        cost_tail = #{costTail,jdbcType=DECIMAL},
      </if>
      <if test="costFirst != null">
        cost_first = #{costFirst,jdbcType=DECIMAL},
      </if>
      <if test="costLogistics != null">
        cost_logistics = #{costLogistics,jdbcType=DECIMAL},
      </if>
      <if test="profitTotal != null">
        profit_total = #{profitTotal,jdbcType=DECIMAL},
      </if>
      <if test="profitRate != null">
        profit_rate = #{profitRate,jdbcType=DECIMAL},
      </if>
      <if test="receiptCountry != null">
        receipt_country = #{receiptCountry,jdbcType=VARCHAR},
      </if>
      <if test="receiptCity != null">
        receipt_city = #{receiptCity,jdbcType=VARCHAR},
      </if>
      <if test="receiptArea != null">
        receipt_area = #{receiptArea,jdbcType=VARCHAR},
      </if>
      <if test="receiptAddress != null">
        receipt_address = #{receiptAddress,jdbcType=VARCHAR},
      </if>
      <if test="receiptAddress2 != null">
        receipt_address_2 = #{receiptAddress2,jdbcType=VARCHAR},
      </if>
      <if test="receiptPostalCode != null">
        receipt_postal_code = #{receiptPostalCode,jdbcType=VARCHAR},
      </if>
      <if test="receiver != null">
        receiver = #{receiver,jdbcType=VARCHAR},
      </if>
      <if test="receiverPhone != null">
        receiver_phone = #{receiverPhone,jdbcType=VARCHAR},
      </if>
      <if test="buyerId != null">
        buyer_id = #{buyerId,jdbcType=VARCHAR},
      </if>
      <if test="buyerName != null">
        buyer_name = #{buyerName,jdbcType=VARCHAR},
      </if>
      <if test="buyerEmail != null">
        buyer_email = #{buyerEmail,jdbcType=VARCHAR},
      </if>
      <if test="hasFbaException != null">
        has_fba_exception = #{hasFbaException,jdbcType=BIT},
      </if>
      <if test="hasPlatformException != null">
        has_platform_exception = #{hasPlatformException,jdbcType=BIT},
      </if>
      <if test="hasCancle != null">
        has_cancle = #{hasCancle,jdbcType=BIT},
      </if>
      <if test="areaId != null">
        area_id = #{areaId,jdbcType=INTEGER},
      </if>
      <if test="bailunCategoryId != null">
        bailun_category_id = #{bailunCategoryId,jdbcType=INTEGER},
      </if>
      <if test="bailunCategoryName != null">
        bailun_category_name = #{bailunCategoryName,jdbcType=VARCHAR},
      </if>
      <if test="gmtCreate != null">
        gmt_create = #{gmtCreate,jdbcType=TIMESTAMP},
      </if>
      <if test="gmtModified != null">
        gmt_modified = #{gmtModified,jdbcType=TIMESTAMP},
      </if>
      <if test="ratioWeight != null">
        ratio_weight = #{ratioWeight,jdbcType=DECIMAL},
      </if>
      <if test="ratioPrice != null">
        ratio_price = #{ratioPrice,jdbcType=DECIMAL},
      </if>
      <if test="bailunPickingStatus != null">
        bailun_picking_status = #{bailunPickingStatus,jdbcType=VARCHAR},
      </if>
      <if test="bailunRequireLogistics != null">
        bailun_require_logistics = #{bailunRequireLogistics,jdbcType=VARCHAR},
      </if>
      <if test="hasDelete != null">
        has_delete = #{hasDelete,jdbcType=BIT},
      </if>
      <if test="hasScalp != null">
        has_scalp = #{hasScalp,jdbcType=BIT},
      </if>
      <if test="hasBuyerRemark != null">
        has_buyer_remark = #{hasBuyerRemark,jdbcType=BIT},
      </if>
      <if test="hasPlatskuRemark != null">
        has_platsku_remark = #{hasPlatskuRemark,jdbcType=BIT},
      </if>
      <if test="logisticsMethodCode != null">
        logistics_method_code = #{logisticsMethodCode,jdbcType=VARCHAR},
      </if>
      <if test="logisticsMethodName != null">
        logistics_method_name = #{logisticsMethodName,jdbcType=VARCHAR},
      </if>
      <if test="hasInnersale != null">
        has_innersale = #{hasInnersale,jdbcType=BIT},
      </if>
      <if test="companyId != null">
        company_id = #{companyId,jdbcType=INTEGER},
      </if>
      <if test="bailunRefundStatus != null">
        bailun_refund_status = #{bailunRefundStatus,jdbcType=VARCHAR},
      </if>
      <if test="refundObj != null">
        refund_obj = #{refundObj,jdbcType=VARCHAR},
      </if>
      <if test="refundType != null">
        refund_type = #{refundType,jdbcType=VARCHAR},
      </if>
      <if test="refundReferenceId != null">
        refund_reference_id = #{refundReferenceId,jdbcType=VARCHAR},
      </if>
      <if test="hasFbaS != null">
        has_fba_s = #{hasFbaS,jdbcType=BIT},
      </if>
      <if test="bailunSkuQuantityPushed != null">
        bailun_sku_quantity_pushed = #{bailunSkuQuantityPushed,jdbcType=INTEGER},
      </if>
      <if test="amountGeneralCargo != null">
        amount_general_cargo = #{amountGeneralCargo,jdbcType=DECIMAL},
      </if>
      <if test="hasTransferOrder != null">
        has_transfer_order = #{hasTransferOrder,jdbcType=BIT},
      </if>
    </set>
    where id = #{id,jdbcType=INTEGER}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.bailuntec.domain.entity.DcBaseOmsSku30">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update dc_base_oms_sku_30
    set origin_order_id = #{originOrderId,jdbcType=VARCHAR},
      platform_type = #{platformType,jdbcType=VARCHAR},
      transaction_id = #{transactionId,jdbcType=VARCHAR},
      pay_time = #{payTime,jdbcType=TIMESTAMP},
      pay_method = #{payMethod,jdbcType=VARCHAR},
      pay_account = #{payAccount,jdbcType=VARCHAR},
      pay_status = #{payStatus,jdbcType=VARCHAR},
      collection_account = #{collectionAccount,jdbcType=VARCHAR},
      platform_order_type = #{platformOrderType,jdbcType=VARCHAR},
      website = #{website,jdbcType=VARCHAR},
      create_time = #{createTime,jdbcType=TIMESTAMP},
      paid_time = #{paidTime,jdbcType=TIMESTAMP},
      refund_time = #{refundTime,jdbcType=TIMESTAMP},
      seller_id = #{sellerId,jdbcType=VARCHAR},
      bailun_account_id = #{bailunAccountId,jdbcType=INTEGER},
      hq_account = #{hqAccount,jdbcType=VARCHAR},
      seller_account = #{sellerAccount,jdbcType=VARCHAR},
      seller_order_id = #{sellerOrderId,jdbcType=VARCHAR},
      seller_email = #{sellerEmail,jdbcType=VARCHAR},
      order_update_time = #{orderUpdateTime,jdbcType=TIMESTAMP},
      seller_order_exchange_rate = #{sellerOrderExchangeRate,jdbcType=DECIMAL},
      seller_other_exchange_rate = #{sellerOtherExchangeRate,jdbcType=DECIMAL},
      finance_order_exchange_rate = #{financeOrderExchangeRate,jdbcType=DECIMAL},
      finance_other_exchange_rate = #{financeOtherExchangeRate,jdbcType=DECIMAL},
      cny_to_usd_exchange_rate = #{cnyToUsdExchangeRate,jdbcType=DECIMAL},
      order_to_usd_exchange_rate = #{orderToUsdExchangeRate,jdbcType=DECIMAL},
      other_to_usd_exchange_rate = #{otherToUsdExchangeRate,jdbcType=DECIMAL},
      order_currency = #{orderCurrency,jdbcType=VARCHAR},
      other_currency = #{otherCurrency,jdbcType=VARCHAR},
      seller_name = #{sellerName,jdbcType=VARCHAR},
      bailun_order_id = #{bailunOrderId,jdbcType=VARCHAR},
      platform_order_status = #{platformOrderStatus,jdbcType=VARCHAR},
      bailun_order_status = #{bailunOrderStatus,jdbcType=VARCHAR},
      bailun_payment_status = #{bailunPaymentStatus,jdbcType=VARCHAR},
      bailun_interception_status = #{bailunInterceptionStatus,jdbcType=VARCHAR},
      shipping_status = #{shippingStatus,jdbcType=VARCHAR},
      bailun_sku = #{bailunSku,jdbcType=VARCHAR},
      bailun_sku_title_en = #{bailunSkuTitleEn,jdbcType=VARCHAR},
      bailun_sku_title_cn = #{bailunSkuTitleCn,jdbcType=VARCHAR},
      bailun_sku_quantity_ordered = #{bailunSkuQuantityOrdered,jdbcType=INTEGER},
      bailun_sku_quantity_shipped = #{bailunSkuQuantityShipped,jdbcType=INTEGER},
      bailun_sku_quantity_refund = #{bailunSkuQuantityRefund,jdbcType=INTEGER},
      bailun_sku_quantity_picked = #{bailunSkuQuantityPicked,jdbcType=INTEGER},
      warehouse_name = #{warehouseName,jdbcType=VARCHAR},
      warehouse_code_fba = #{warehouseCodeFba,jdbcType=VARCHAR},
      warehouse_code = #{warehouseCode,jdbcType=VARCHAR},
      bailun_sku_unit_price = #{bailunSkuUnitPrice,jdbcType=DECIMAL},
      bailun_sku_weight = #{bailunSkuWeight,jdbcType=DECIMAL},
      bailun_sku_size = #{bailunSkuSize,jdbcType=VARCHAR},
      amount_sales = #{amountSales,jdbcType=DECIMAL},
      amount_total = #{amountTotal,jdbcType=DECIMAL},
      amount_shipping = #{amountShipping,jdbcType=DECIMAL},
      amount_product = #{amountProduct,jdbcType=DECIMAL},
      amount_tax = #{amountTax,jdbcType=DECIMAL},
      amount_adjustment = #{amountAdjustment,jdbcType=DECIMAL},
      amount_gift_wrap = #{amountGiftWrap,jdbcType=DECIMAL},
      amount_refund = #{amountRefund,jdbcType=DECIMAL},
      amount_prepaid = #{amountPrepaid,jdbcType=DECIMAL},
      cost_total = #{costTotal,jdbcType=DECIMAL},
      cost_promotion = #{costPromotion,jdbcType=DECIMAL},
      cost_platform_fee = #{costPlatformFee,jdbcType=DECIMAL},
      cost_product = #{costProduct,jdbcType=DECIMAL},
      cost_shipping = #{costShipping,jdbcType=DECIMAL},
      cost_package = #{costPackage,jdbcType=DECIMAL},
      cost_fba_fee = #{costFbaFee,jdbcType=DECIMAL},
      cost_paypal_fee = #{costPaypalFee,jdbcType=DECIMAL},
      cost_refund_commisson = #{costRefundCommisson,jdbcType=DECIMAL},
      cost_handle_bailun = #{costHandleBailun,jdbcType=DECIMAL},
      cost_handle_platform = #{costHandlePlatform,jdbcType=DECIMAL},
      cost_tail = #{costTail,jdbcType=DECIMAL},
      cost_first = #{costFirst,jdbcType=DECIMAL},
      cost_logistics = #{costLogistics,jdbcType=DECIMAL},
      profit_total = #{profitTotal,jdbcType=DECIMAL},
      profit_rate = #{profitRate,jdbcType=DECIMAL},
      receipt_country = #{receiptCountry,jdbcType=VARCHAR},
      receipt_city = #{receiptCity,jdbcType=VARCHAR},
      receipt_area = #{receiptArea,jdbcType=VARCHAR},
      receipt_address = #{receiptAddress,jdbcType=VARCHAR},
      receipt_address_2 = #{receiptAddress2,jdbcType=VARCHAR},
      receipt_postal_code = #{receiptPostalCode,jdbcType=VARCHAR},
      receiver = #{receiver,jdbcType=VARCHAR},
      receiver_phone = #{receiverPhone,jdbcType=VARCHAR},
      buyer_id = #{buyerId,jdbcType=VARCHAR},
      buyer_name = #{buyerName,jdbcType=VARCHAR},
      buyer_email = #{buyerEmail,jdbcType=VARCHAR},
      has_fba_exception = #{hasFbaException,jdbcType=BIT},
      has_platform_exception = #{hasPlatformException,jdbcType=BIT},
      has_cancle = #{hasCancle,jdbcType=BIT},
      area_id = #{areaId,jdbcType=INTEGER},
      bailun_category_id = #{bailunCategoryId,jdbcType=INTEGER},
      bailun_category_name = #{bailunCategoryName,jdbcType=VARCHAR},
      gmt_create = #{gmtCreate,jdbcType=TIMESTAMP},
      gmt_modified = #{gmtModified,jdbcType=TIMESTAMP},
      ratio_weight = #{ratioWeight,jdbcType=DECIMAL},
      ratio_price = #{ratioPrice,jdbcType=DECIMAL},
      bailun_picking_status = #{bailunPickingStatus,jdbcType=VARCHAR},
      bailun_require_logistics = #{bailunRequireLogistics,jdbcType=VARCHAR},
      has_delete = #{hasDelete,jdbcType=BIT},
      has_scalp = #{hasScalp,jdbcType=BIT},
      has_buyer_remark = #{hasBuyerRemark,jdbcType=BIT},
      has_platsku_remark = #{hasPlatskuRemark,jdbcType=BIT},
      logistics_method_code = #{logisticsMethodCode,jdbcType=VARCHAR},
      logistics_method_name = #{logisticsMethodName,jdbcType=VARCHAR},
      has_innersale = #{hasInnersale,jdbcType=BIT},
      company_id = #{companyId,jdbcType=INTEGER},
      bailun_refund_status = #{bailunRefundStatus,jdbcType=VARCHAR},
      refund_obj = #{refundObj,jdbcType=VARCHAR},
      refund_type = #{refundType,jdbcType=VARCHAR},
      refund_reference_id = #{refundReferenceId,jdbcType=VARCHAR},
      has_fba_s = #{hasFbaS,jdbcType=BIT},
      bailun_sku_quantity_pushed = #{bailunSkuQuantityPushed,jdbcType=INTEGER},
      amount_general_cargo = #{amountGeneralCargo,jdbcType=DECIMAL},
      has_transfer_order = #{hasTransferOrder,jdbcType=BIT}
    where id = #{id,jdbcType=INTEGER}
  </update>
  <insert id="upsertSelective" parameterType="com.bailuntec.domain.entity.DcBaseOmsSku30">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
      @project https://github.com/itfsw/mybatis-generator-plugin
    -->
    insert into dc_base_oms_sku_30
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="id != null">
        id,
      </if>
      <if test="originOrderId != null">
        origin_order_id,
      </if>
      <if test="platformType != null">
        platform_type,
      </if>
      <if test="transactionId != null">
        transaction_id,
      </if>
      <if test="payTime != null">
        pay_time,
      </if>
      <if test="payMethod != null">
        pay_method,
      </if>
      <if test="payAccount != null">
        pay_account,
      </if>
      <if test="payStatus != null">
        pay_status,
      </if>
      <if test="collectionAccount != null">
        collection_account,
      </if>
      <if test="platformOrderType != null">
        platform_order_type,
      </if>
      <if test="website != null">
        website,
      </if>
      <if test="createTime != null">
        create_time,
      </if>
      <if test="paidTime != null">
        paid_time,
      </if>
      <if test="refundTime != null">
        refund_time,
      </if>
      <if test="sellerId != null">
        seller_id,
      </if>
      <if test="bailunAccountId != null">
        bailun_account_id,
      </if>
      <if test="hqAccount != null">
        hq_account,
      </if>
      <if test="sellerAccount != null">
        seller_account,
      </if>
      <if test="sellerOrderId != null">
        seller_order_id,
      </if>
      <if test="sellerEmail != null">
        seller_email,
      </if>
      <if test="orderUpdateTime != null">
        order_update_time,
      </if>
      <if test="sellerOrderExchangeRate != null">
        seller_order_exchange_rate,
      </if>
      <if test="sellerOtherExchangeRate != null">
        seller_other_exchange_rate,
      </if>
      <if test="financeOrderExchangeRate != null">
        finance_order_exchange_rate,
      </if>
      <if test="financeOtherExchangeRate != null">
        finance_other_exchange_rate,
      </if>
      <if test="cnyToUsdExchangeRate != null">
        cny_to_usd_exchange_rate,
      </if>
      <if test="orderToUsdExchangeRate != null">
        order_to_usd_exchange_rate,
      </if>
      <if test="otherToUsdExchangeRate != null">
        other_to_usd_exchange_rate,
      </if>
      <if test="orderCurrency != null">
        order_currency,
      </if>
      <if test="otherCurrency != null">
        other_currency,
      </if>
      <if test="sellerName != null">
        seller_name,
      </if>
      <if test="bailunOrderId != null">
        bailun_order_id,
      </if>
      <if test="platformOrderStatus != null">
        platform_order_status,
      </if>
      <if test="bailunOrderStatus != null">
        bailun_order_status,
      </if>
      <if test="bailunPaymentStatus != null">
        bailun_payment_status,
      </if>
      <if test="bailunInterceptionStatus != null">
        bailun_interception_status,
      </if>
      <if test="shippingStatus != null">
        shipping_status,
      </if>
      <if test="bailunSku != null">
        bailun_sku,
      </if>
      <if test="bailunSkuTitleEn != null">
        bailun_sku_title_en,
      </if>
      <if test="bailunSkuTitleCn != null">
        bailun_sku_title_cn,
      </if>
      <if test="bailunSkuQuantityOrdered != null">
        bailun_sku_quantity_ordered,
      </if>
      <if test="bailunSkuQuantityShipped != null">
        bailun_sku_quantity_shipped,
      </if>
      <if test="bailunSkuQuantityRefund != null">
        bailun_sku_quantity_refund,
      </if>
      <if test="bailunSkuQuantityPicked != null">
        bailun_sku_quantity_picked,
      </if>
      <if test="warehouseName != null">
        warehouse_name,
      </if>
      <if test="warehouseCodeFba != null">
        warehouse_code_fba,
      </if>
      <if test="warehouseCode != null">
        warehouse_code,
      </if>
      <if test="bailunSkuUnitPrice != null">
        bailun_sku_unit_price,
      </if>
      <if test="bailunSkuWeight != null">
        bailun_sku_weight,
      </if>
      <if test="bailunSkuSize != null">
        bailun_sku_size,
      </if>
      <if test="amountSales != null">
        amount_sales,
      </if>
      <if test="amountTotal != null">
        amount_total,
      </if>
      <if test="amountShipping != null">
        amount_shipping,
      </if>
      <if test="amountProduct != null">
        amount_product,
      </if>
      <if test="amountTax != null">
        amount_tax,
      </if>
      <if test="amountAdjustment != null">
        amount_adjustment,
      </if>
      <if test="amountGiftWrap != null">
        amount_gift_wrap,
      </if>
      <if test="amountRefund != null">
        amount_refund,
      </if>
      <if test="amountPrepaid != null">
        amount_prepaid,
      </if>
      <if test="costTotal != null">
        cost_total,
      </if>
      <if test="costPromotion != null">
        cost_promotion,
      </if>
      <if test="costPlatformFee != null">
        cost_platform_fee,
      </if>
      <if test="costProduct != null">
        cost_product,
      </if>
      <if test="costShipping != null">
        cost_shipping,
      </if>
      <if test="costPackage != null">
        cost_package,
      </if>
      <if test="costFbaFee != null">
        cost_fba_fee,
      </if>
      <if test="costPaypalFee != null">
        cost_paypal_fee,
      </if>
      <if test="costRefundCommisson != null">
        cost_refund_commisson,
      </if>
      <if test="costHandleBailun != null">
        cost_handle_bailun,
      </if>
      <if test="costHandlePlatform != null">
        cost_handle_platform,
      </if>
      <if test="costTail != null">
        cost_tail,
      </if>
      <if test="costFirst != null">
        cost_first,
      </if>
      <if test="costLogistics != null">
        cost_logistics,
      </if>
      <if test="profitTotal != null">
        profit_total,
      </if>
      <if test="profitRate != null">
        profit_rate,
      </if>
      <if test="receiptCountry != null">
        receipt_country,
      </if>
      <if test="receiptCity != null">
        receipt_city,
      </if>
      <if test="receiptArea != null">
        receipt_area,
      </if>
      <if test="receiptAddress != null">
        receipt_address,
      </if>
      <if test="receiptAddress2 != null">
        receipt_address_2,
      </if>
      <if test="receiptPostalCode != null">
        receipt_postal_code,
      </if>
      <if test="receiver != null">
        receiver,
      </if>
      <if test="receiverPhone != null">
        receiver_phone,
      </if>
      <if test="buyerId != null">
        buyer_id,
      </if>
      <if test="buyerName != null">
        buyer_name,
      </if>
      <if test="buyerEmail != null">
        buyer_email,
      </if>
      <if test="hasFbaException != null">
        has_fba_exception,
      </if>
      <if test="hasPlatformException != null">
        has_platform_exception,
      </if>
      <if test="hasCancle != null">
        has_cancle,
      </if>
      <if test="areaId != null">
        area_id,
      </if>
      <if test="bailunCategoryId != null">
        bailun_category_id,
      </if>
      <if test="bailunCategoryName != null">
        bailun_category_name,
      </if>
      <if test="gmtCreate != null">
        gmt_create,
      </if>
      <if test="gmtModified != null">
        gmt_modified,
      </if>
      <if test="ratioWeight != null">
        ratio_weight,
      </if>
      <if test="ratioPrice != null">
        ratio_price,
      </if>
      <if test="bailunPickingStatus != null">
        bailun_picking_status,
      </if>
      <if test="bailunRequireLogistics != null">
        bailun_require_logistics,
      </if>
      <if test="hasDelete != null">
        has_delete,
      </if>
      <if test="hasScalp != null">
        has_scalp,
      </if>
      <if test="hasBuyerRemark != null">
        has_buyer_remark,
      </if>
      <if test="hasPlatskuRemark != null">
        has_platsku_remark,
      </if>
      <if test="logisticsMethodCode != null">
        logistics_method_code,
      </if>
      <if test="logisticsMethodName != null">
        logistics_method_name,
      </if>
      <if test="hasInnersale != null">
        has_innersale,
      </if>
      <if test="companyId != null">
        company_id,
      </if>
      <if test="bailunRefundStatus != null">
        bailun_refund_status,
      </if>
      <if test="refundObj != null">
        refund_obj,
      </if>
      <if test="refundType != null">
        refund_type,
      </if>
      <if test="refundReferenceId != null">
        refund_reference_id,
      </if>
      <if test="hasFbaS != null">
        has_fba_s,
      </if>
      <if test="bailunSkuQuantityPushed != null">
        bailun_sku_quantity_pushed,
      </if>
      <if test="amountGeneralCargo != null">
        amount_general_cargo,
      </if>
      <if test="hasTransferOrder != null">
        has_transfer_order,
      </if>
    </trim>
    values
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="id != null">
        #{id,jdbcType=INTEGER},
      </if>
      <if test="originOrderId != null">
        #{originOrderId,jdbcType=VARCHAR},
      </if>
      <if test="platformType != null">
        #{platformType,jdbcType=VARCHAR},
      </if>
      <if test="transactionId != null">
        #{transactionId,jdbcType=VARCHAR},
      </if>
      <if test="payTime != null">
        #{payTime,jdbcType=TIMESTAMP},
      </if>
      <if test="payMethod != null">
        #{payMethod,jdbcType=VARCHAR},
      </if>
      <if test="payAccount != null">
        #{payAccount,jdbcType=VARCHAR},
      </if>
      <if test="payStatus != null">
        #{payStatus,jdbcType=VARCHAR},
      </if>
      <if test="collectionAccount != null">
        #{collectionAccount,jdbcType=VARCHAR},
      </if>
      <if test="platformOrderType != null">
        #{platformOrderType,jdbcType=VARCHAR},
      </if>
      <if test="website != null">
        #{website,jdbcType=VARCHAR},
      </if>
      <if test="createTime != null">
        #{createTime,jdbcType=TIMESTAMP},
      </if>
      <if test="paidTime != null">
        #{paidTime,jdbcType=TIMESTAMP},
      </if>
      <if test="refundTime != null">
        #{refundTime,jdbcType=TIMESTAMP},
      </if>
      <if test="sellerId != null">
        #{sellerId,jdbcType=VARCHAR},
      </if>
      <if test="bailunAccountId != null">
        #{bailunAccountId,jdbcType=INTEGER},
      </if>
      <if test="hqAccount != null">
        #{hqAccount,jdbcType=VARCHAR},
      </if>
      <if test="sellerAccount != null">
        #{sellerAccount,jdbcType=VARCHAR},
      </if>
      <if test="sellerOrderId != null">
        #{sellerOrderId,jdbcType=VARCHAR},
      </if>
      <if test="sellerEmail != null">
        #{sellerEmail,jdbcType=VARCHAR},
      </if>
      <if test="orderUpdateTime != null">
        #{orderUpdateTime,jdbcType=TIMESTAMP},
      </if>
      <if test="sellerOrderExchangeRate != null">
        #{sellerOrderExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="sellerOtherExchangeRate != null">
        #{sellerOtherExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="financeOrderExchangeRate != null">
        #{financeOrderExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="financeOtherExchangeRate != null">
        #{financeOtherExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="cnyToUsdExchangeRate != null">
        #{cnyToUsdExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="orderToUsdExchangeRate != null">
        #{orderToUsdExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="otherToUsdExchangeRate != null">
        #{otherToUsdExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="orderCurrency != null">
        #{orderCurrency,jdbcType=VARCHAR},
      </if>
      <if test="otherCurrency != null">
        #{otherCurrency,jdbcType=VARCHAR},
      </if>
      <if test="sellerName != null">
        #{sellerName,jdbcType=VARCHAR},
      </if>
      <if test="bailunOrderId != null">
        #{bailunOrderId,jdbcType=VARCHAR},
      </if>
      <if test="platformOrderStatus != null">
        #{platformOrderStatus,jdbcType=VARCHAR},
      </if>
      <if test="bailunOrderStatus != null">
        #{bailunOrderStatus,jdbcType=VARCHAR},
      </if>
      <if test="bailunPaymentStatus != null">
        #{bailunPaymentStatus,jdbcType=VARCHAR},
      </if>
      <if test="bailunInterceptionStatus != null">
        #{bailunInterceptionStatus,jdbcType=VARCHAR},
      </if>
      <if test="shippingStatus != null">
        #{shippingStatus,jdbcType=VARCHAR},
      </if>
      <if test="bailunSku != null">
        #{bailunSku,jdbcType=VARCHAR},
      </if>
      <if test="bailunSkuTitleEn != null">
        #{bailunSkuTitleEn,jdbcType=VARCHAR},
      </if>
      <if test="bailunSkuTitleCn != null">
        #{bailunSkuTitleCn,jdbcType=VARCHAR},
      </if>
      <if test="bailunSkuQuantityOrdered != null">
        #{bailunSkuQuantityOrdered,jdbcType=INTEGER},
      </if>
      <if test="bailunSkuQuantityShipped != null">
        #{bailunSkuQuantityShipped,jdbcType=INTEGER},
      </if>
      <if test="bailunSkuQuantityRefund != null">
        #{bailunSkuQuantityRefund,jdbcType=INTEGER},
      </if>
      <if test="bailunSkuQuantityPicked != null">
        #{bailunSkuQuantityPicked,jdbcType=INTEGER},
      </if>
      <if test="warehouseName != null">
        #{warehouseName,jdbcType=VARCHAR},
      </if>
      <if test="warehouseCodeFba != null">
        #{warehouseCodeFba,jdbcType=VARCHAR},
      </if>
      <if test="warehouseCode != null">
        #{warehouseCode,jdbcType=VARCHAR},
      </if>
      <if test="bailunSkuUnitPrice != null">
        #{bailunSkuUnitPrice,jdbcType=DECIMAL},
      </if>
      <if test="bailunSkuWeight != null">
        #{bailunSkuWeight,jdbcType=DECIMAL},
      </if>
      <if test="bailunSkuSize != null">
        #{bailunSkuSize,jdbcType=VARCHAR},
      </if>
      <if test="amountSales != null">
        #{amountSales,jdbcType=DECIMAL},
      </if>
      <if test="amountTotal != null">
        #{amountTotal,jdbcType=DECIMAL},
      </if>
      <if test="amountShipping != null">
        #{amountShipping,jdbcType=DECIMAL},
      </if>
      <if test="amountProduct != null">
        #{amountProduct,jdbcType=DECIMAL},
      </if>
      <if test="amountTax != null">
        #{amountTax,jdbcType=DECIMAL},
      </if>
      <if test="amountAdjustment != null">
        #{amountAdjustment,jdbcType=DECIMAL},
      </if>
      <if test="amountGiftWrap != null">
        #{amountGiftWrap,jdbcType=DECIMAL},
      </if>
      <if test="amountRefund != null">
        #{amountRefund,jdbcType=DECIMAL},
      </if>
      <if test="amountPrepaid != null">
        #{amountPrepaid,jdbcType=DECIMAL},
      </if>
      <if test="costTotal != null">
        #{costTotal,jdbcType=DECIMAL},
      </if>
      <if test="costPromotion != null">
        #{costPromotion,jdbcType=DECIMAL},
      </if>
      <if test="costPlatformFee != null">
        #{costPlatformFee,jdbcType=DECIMAL},
      </if>
      <if test="costProduct != null">
        #{costProduct,jdbcType=DECIMAL},
      </if>
      <if test="costShipping != null">
        #{costShipping,jdbcType=DECIMAL},
      </if>
      <if test="costPackage != null">
        #{costPackage,jdbcType=DECIMAL},
      </if>
      <if test="costFbaFee != null">
        #{costFbaFee,jdbcType=DECIMAL},
      </if>
      <if test="costPaypalFee != null">
        #{costPaypalFee,jdbcType=DECIMAL},
      </if>
      <if test="costRefundCommisson != null">
        #{costRefundCommisson,jdbcType=DECIMAL},
      </if>
      <if test="costHandleBailun != null">
        #{costHandleBailun,jdbcType=DECIMAL},
      </if>
      <if test="costHandlePlatform != null">
        #{costHandlePlatform,jdbcType=DECIMAL},
      </if>
      <if test="costTail != null">
        #{costTail,jdbcType=DECIMAL},
      </if>
      <if test="costFirst != null">
        #{costFirst,jdbcType=DECIMAL},
      </if>
      <if test="costLogistics != null">
        #{costLogistics,jdbcType=DECIMAL},
      </if>
      <if test="profitTotal != null">
        #{profitTotal,jdbcType=DECIMAL},
      </if>
      <if test="profitRate != null">
        #{profitRate,jdbcType=DECIMAL},
      </if>
      <if test="receiptCountry != null">
        #{receiptCountry,jdbcType=VARCHAR},
      </if>
      <if test="receiptCity != null">
        #{receiptCity,jdbcType=VARCHAR},
      </if>
      <if test="receiptArea != null">
        #{receiptArea,jdbcType=VARCHAR},
      </if>
      <if test="receiptAddress != null">
        #{receiptAddress,jdbcType=VARCHAR},
      </if>
      <if test="receiptAddress2 != null">
        #{receiptAddress2,jdbcType=VARCHAR},
      </if>
      <if test="receiptPostalCode != null">
        #{receiptPostalCode,jdbcType=VARCHAR},
      </if>
      <if test="receiver != null">
        #{receiver,jdbcType=VARCHAR},
      </if>
      <if test="receiverPhone != null">
        #{receiverPhone,jdbcType=VARCHAR},
      </if>
      <if test="buyerId != null">
        #{buyerId,jdbcType=VARCHAR},
      </if>
      <if test="buyerName != null">
        #{buyerName,jdbcType=VARCHAR},
      </if>
      <if test="buyerEmail != null">
        #{buyerEmail,jdbcType=VARCHAR},
      </if>
      <if test="hasFbaException != null">
        #{hasFbaException,jdbcType=BIT},
      </if>
      <if test="hasPlatformException != null">
        #{hasPlatformException,jdbcType=BIT},
      </if>
      <if test="hasCancle != null">
        #{hasCancle,jdbcType=BIT},
      </if>
      <if test="areaId != null">
        #{areaId,jdbcType=INTEGER},
      </if>
      <if test="bailunCategoryId != null">
        #{bailunCategoryId,jdbcType=INTEGER},
      </if>
      <if test="bailunCategoryName != null">
        #{bailunCategoryName,jdbcType=VARCHAR},
      </if>
      <if test="gmtCreate != null">
        #{gmtCreate,jdbcType=TIMESTAMP},
      </if>
      <if test="gmtModified != null">
        #{gmtModified,jdbcType=TIMESTAMP},
      </if>
      <if test="ratioWeight != null">
        #{ratioWeight,jdbcType=DECIMAL},
      </if>
      <if test="ratioPrice != null">
        #{ratioPrice,jdbcType=DECIMAL},
      </if>
      <if test="bailunPickingStatus != null">
        #{bailunPickingStatus,jdbcType=VARCHAR},
      </if>
      <if test="bailunRequireLogistics != null">
        #{bailunRequireLogistics,jdbcType=VARCHAR},
      </if>
      <if test="hasDelete != null">
        #{hasDelete,jdbcType=BIT},
      </if>
      <if test="hasScalp != null">
        #{hasScalp,jdbcType=BIT},
      </if>
      <if test="hasBuyerRemark != null">
        #{hasBuyerRemark,jdbcType=BIT},
      </if>
      <if test="hasPlatskuRemark != null">
        #{hasPlatskuRemark,jdbcType=BIT},
      </if>
      <if test="logisticsMethodCode != null">
        #{logisticsMethodCode,jdbcType=VARCHAR},
      </if>
      <if test="logisticsMethodName != null">
        #{logisticsMethodName,jdbcType=VARCHAR},
      </if>
      <if test="hasInnersale != null">
        #{hasInnersale,jdbcType=BIT},
      </if>
      <if test="companyId != null">
        #{companyId,jdbcType=INTEGER},
      </if>
      <if test="bailunRefundStatus != null">
        #{bailunRefundStatus,jdbcType=VARCHAR},
      </if>
      <if test="refundObj != null">
        #{refundObj,jdbcType=VARCHAR},
      </if>
      <if test="refundType != null">
        #{refundType,jdbcType=VARCHAR},
      </if>
      <if test="refundReferenceId != null">
        #{refundReferenceId,jdbcType=VARCHAR},
      </if>
      <if test="hasFbaS != null">
        #{hasFbaS,jdbcType=BIT},
      </if>
      <if test="bailunSkuQuantityPushed != null">
        #{bailunSkuQuantityPushed,jdbcType=INTEGER},
      </if>
      <if test="amountGeneralCargo != null">
        #{amountGeneralCargo,jdbcType=DECIMAL},
      </if>
      <if test="hasTransferOrder != null">
        #{hasTransferOrder,jdbcType=BIT},
      </if>
    </trim>
    on duplicate key update
    <trim suffixOverrides=",">
      <if test="id != null">
        id = #{id,jdbcType=INTEGER},
      </if>
      <if test="originOrderId != null">
        origin_order_id = #{originOrderId,jdbcType=VARCHAR},
      </if>
      <if test="platformType != null">
        platform_type = #{platformType,jdbcType=VARCHAR},
      </if>
      <if test="transactionId != null">
        transaction_id = #{transactionId,jdbcType=VARCHAR},
      </if>
      <if test="payTime != null">
        pay_time = #{payTime,jdbcType=TIMESTAMP},
      </if>
      <if test="payMethod != null">
        pay_method = #{payMethod,jdbcType=VARCHAR},
      </if>
      <if test="payAccount != null">
        pay_account = #{payAccount,jdbcType=VARCHAR},
      </if>
      <if test="payStatus != null">
        pay_status = #{payStatus,jdbcType=VARCHAR},
      </if>
      <if test="collectionAccount != null">
        collection_account = #{collectionAccount,jdbcType=VARCHAR},
      </if>
      <if test="platformOrderType != null">
        platform_order_type = #{platformOrderType,jdbcType=VARCHAR},
      </if>
      <if test="website != null">
        website = #{website,jdbcType=VARCHAR},
      </if>
      <if test="createTime != null">
        create_time = #{createTime,jdbcType=TIMESTAMP},
      </if>
      <if test="paidTime != null">
        paid_time = #{paidTime,jdbcType=TIMESTAMP},
      </if>
      <if test="refundTime != null">
        refund_time = #{refundTime,jdbcType=TIMESTAMP},
      </if>
      <if test="sellerId != null">
        seller_id = #{sellerId,jdbcType=VARCHAR},
      </if>
      <if test="bailunAccountId != null">
        bailun_account_id = #{bailunAccountId,jdbcType=INTEGER},
      </if>
      <if test="hqAccount != null">
        hq_account = #{hqAccount,jdbcType=VARCHAR},
      </if>
      <if test="sellerAccount != null">
        seller_account = #{sellerAccount,jdbcType=VARCHAR},
      </if>
      <if test="sellerOrderId != null">
        seller_order_id = #{sellerOrderId,jdbcType=VARCHAR},
      </if>
      <if test="sellerEmail != null">
        seller_email = #{sellerEmail,jdbcType=VARCHAR},
      </if>
      <if test="orderUpdateTime != null">
        order_update_time = #{orderUpdateTime,jdbcType=TIMESTAMP},
      </if>
      <if test="sellerOrderExchangeRate != null">
        seller_order_exchange_rate = #{sellerOrderExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="sellerOtherExchangeRate != null">
        seller_other_exchange_rate = #{sellerOtherExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="financeOrderExchangeRate != null">
        finance_order_exchange_rate = #{financeOrderExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="financeOtherExchangeRate != null">
        finance_other_exchange_rate = #{financeOtherExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="cnyToUsdExchangeRate != null">
        cny_to_usd_exchange_rate = #{cnyToUsdExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="orderToUsdExchangeRate != null">
        order_to_usd_exchange_rate = #{orderToUsdExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="otherToUsdExchangeRate != null">
        other_to_usd_exchange_rate = #{otherToUsdExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="orderCurrency != null">
        order_currency = #{orderCurrency,jdbcType=VARCHAR},
      </if>
      <if test="otherCurrency != null">
        other_currency = #{otherCurrency,jdbcType=VARCHAR},
      </if>
      <if test="sellerName != null">
        seller_name = #{sellerName,jdbcType=VARCHAR},
      </if>
      <if test="bailunOrderId != null">
        bailun_order_id = #{bailunOrderId,jdbcType=VARCHAR},
      </if>
      <if test="platformOrderStatus != null">
        platform_order_status = #{platformOrderStatus,jdbcType=VARCHAR},
      </if>
      <if test="bailunOrderStatus != null">
        bailun_order_status = #{bailunOrderStatus,jdbcType=VARCHAR},
      </if>
      <if test="bailunPaymentStatus != null">
        bailun_payment_status = #{bailunPaymentStatus,jdbcType=VARCHAR},
      </if>
      <if test="bailunInterceptionStatus != null">
        bailun_interception_status = #{bailunInterceptionStatus,jdbcType=VARCHAR},
      </if>
      <if test="shippingStatus != null">
        shipping_status = #{shippingStatus,jdbcType=VARCHAR},
      </if>
      <if test="bailunSku != null">
        bailun_sku = #{bailunSku,jdbcType=VARCHAR},
      </if>
      <if test="bailunSkuTitleEn != null">
        bailun_sku_title_en = #{bailunSkuTitleEn,jdbcType=VARCHAR},
      </if>
      <if test="bailunSkuTitleCn != null">
        bailun_sku_title_cn = #{bailunSkuTitleCn,jdbcType=VARCHAR},
      </if>
      <if test="bailunSkuQuantityOrdered != null">
        bailun_sku_quantity_ordered = #{bailunSkuQuantityOrdered,jdbcType=INTEGER},
      </if>
      <if test="bailunSkuQuantityShipped != null">
        bailun_sku_quantity_shipped = #{bailunSkuQuantityShipped,jdbcType=INTEGER},
      </if>
      <if test="bailunSkuQuantityRefund != null">
        bailun_sku_quantity_refund = #{bailunSkuQuantityRefund,jdbcType=INTEGER},
      </if>
      <if test="bailunSkuQuantityPicked != null">
        bailun_sku_quantity_picked = #{bailunSkuQuantityPicked,jdbcType=INTEGER},
      </if>
      <if test="warehouseName != null">
        warehouse_name = #{warehouseName,jdbcType=VARCHAR},
      </if>
      <if test="warehouseCodeFba != null">
        warehouse_code_fba = #{warehouseCodeFba,jdbcType=VARCHAR},
      </if>
      <if test="warehouseCode != null">
        warehouse_code = #{warehouseCode,jdbcType=VARCHAR},
      </if>
      <if test="bailunSkuUnitPrice != null">
        bailun_sku_unit_price = #{bailunSkuUnitPrice,jdbcType=DECIMAL},
      </if>
      <if test="bailunSkuWeight != null">
        bailun_sku_weight = #{bailunSkuWeight,jdbcType=DECIMAL},
      </if>
      <if test="bailunSkuSize != null">
        bailun_sku_size = #{bailunSkuSize,jdbcType=VARCHAR},
      </if>
      <if test="amountSales != null">
        amount_sales = #{amountSales,jdbcType=DECIMAL},
      </if>
      <if test="amountTotal != null">
        amount_total = #{amountTotal,jdbcType=DECIMAL},
      </if>
      <if test="amountShipping != null">
        amount_shipping = #{amountShipping,jdbcType=DECIMAL},
      </if>
      <if test="amountProduct != null">
        amount_product = #{amountProduct,jdbcType=DECIMAL},
      </if>
      <if test="amountTax != null">
        amount_tax = #{amountTax,jdbcType=DECIMAL},
      </if>
      <if test="amountAdjustment != null">
        amount_adjustment = #{amountAdjustment,jdbcType=DECIMAL},
      </if>
      <if test="amountGiftWrap != null">
        amount_gift_wrap = #{amountGiftWrap,jdbcType=DECIMAL},
      </if>
      <if test="amountRefund != null">
        amount_refund = #{amountRefund,jdbcType=DECIMAL},
      </if>
      <if test="amountPrepaid != null">
        amount_prepaid = #{amountPrepaid,jdbcType=DECIMAL},
      </if>
      <if test="costTotal != null">
        cost_total = #{costTotal,jdbcType=DECIMAL},
      </if>
      <if test="costPromotion != null">
        cost_promotion = #{costPromotion,jdbcType=DECIMAL},
      </if>
      <if test="costPlatformFee != null">
        cost_platform_fee = #{costPlatformFee,jdbcType=DECIMAL},
      </if>
      <if test="costProduct != null">
        cost_product = #{costProduct,jdbcType=DECIMAL},
      </if>
      <if test="costShipping != null">
        cost_shipping = #{costShipping,jdbcType=DECIMAL},
      </if>
      <if test="costPackage != null">
        cost_package = #{costPackage,jdbcType=DECIMAL},
      </if>
      <if test="costFbaFee != null">
        cost_fba_fee = #{costFbaFee,jdbcType=DECIMAL},
      </if>
      <if test="costPaypalFee != null">
        cost_paypal_fee = #{costPaypalFee,jdbcType=DECIMAL},
      </if>
      <if test="costRefundCommisson != null">
        cost_refund_commisson = #{costRefundCommisson,jdbcType=DECIMAL},
      </if>
      <if test="costHandleBailun != null">
        cost_handle_bailun = #{costHandleBailun,jdbcType=DECIMAL},
      </if>
      <if test="costHandlePlatform != null">
        cost_handle_platform = #{costHandlePlatform,jdbcType=DECIMAL},
      </if>
      <if test="costTail != null">
        cost_tail = #{costTail,jdbcType=DECIMAL},
      </if>
      <if test="costFirst != null">
        cost_first = #{costFirst,jdbcType=DECIMAL},
      </if>
      <if test="costLogistics != null">
        cost_logistics = #{costLogistics,jdbcType=DECIMAL},
      </if>
      <if test="profitTotal != null">
        profit_total = #{profitTotal,jdbcType=DECIMAL},
      </if>
      <if test="profitRate != null">
        profit_rate = #{profitRate,jdbcType=DECIMAL},
      </if>
      <if test="receiptCountry != null">
        receipt_country = #{receiptCountry,jdbcType=VARCHAR},
      </if>
      <if test="receiptCity != null">
        receipt_city = #{receiptCity,jdbcType=VARCHAR},
      </if>
      <if test="receiptArea != null">
        receipt_area = #{receiptArea,jdbcType=VARCHAR},
      </if>
      <if test="receiptAddress != null">
        receipt_address = #{receiptAddress,jdbcType=VARCHAR},
      </if>
      <if test="receiptAddress2 != null">
        receipt_address_2 = #{receiptAddress2,jdbcType=VARCHAR},
      </if>
      <if test="receiptPostalCode != null">
        receipt_postal_code = #{receiptPostalCode,jdbcType=VARCHAR},
      </if>
      <if test="receiver != null">
        receiver = #{receiver,jdbcType=VARCHAR},
      </if>
      <if test="receiverPhone != null">
        receiver_phone = #{receiverPhone,jdbcType=VARCHAR},
      </if>
      <if test="buyerId != null">
        buyer_id = #{buyerId,jdbcType=VARCHAR},
      </if>
      <if test="buyerName != null">
        buyer_name = #{buyerName,jdbcType=VARCHAR},
      </if>
      <if test="buyerEmail != null">
        buyer_email = #{buyerEmail,jdbcType=VARCHAR},
      </if>
      <if test="hasFbaException != null">
        has_fba_exception = #{hasFbaException,jdbcType=BIT},
      </if>
      <if test="hasPlatformException != null">
        has_platform_exception = #{hasPlatformException,jdbcType=BIT},
      </if>
      <if test="hasCancle != null">
        has_cancle = #{hasCancle,jdbcType=BIT},
      </if>
      <if test="areaId != null">
        area_id = #{areaId,jdbcType=INTEGER},
      </if>
      <if test="bailunCategoryId != null">
        bailun_category_id = #{bailunCategoryId,jdbcType=INTEGER},
      </if>
      <if test="bailunCategoryName != null">
        bailun_category_name = #{bailunCategoryName,jdbcType=VARCHAR},
      </if>
      <if test="gmtCreate != null">
        gmt_create = #{gmtCreate,jdbcType=TIMESTAMP},
      </if>
      <if test="gmtModified != null">
        gmt_modified = #{gmtModified,jdbcType=TIMESTAMP},
      </if>
      <if test="ratioWeight != null">
        ratio_weight = #{ratioWeight,jdbcType=DECIMAL},
      </if>
      <if test="ratioPrice != null">
        ratio_price = #{ratioPrice,jdbcType=DECIMAL},
      </if>
      <if test="bailunPickingStatus != null">
        bailun_picking_status = #{bailunPickingStatus,jdbcType=VARCHAR},
      </if>
      <if test="bailunRequireLogistics != null">
        bailun_require_logistics = #{bailunRequireLogistics,jdbcType=VARCHAR},
      </if>
      <if test="hasDelete != null">
        has_delete = #{hasDelete,jdbcType=BIT},
      </if>
      <if test="hasScalp != null">
        has_scalp = #{hasScalp,jdbcType=BIT},
      </if>
      <if test="hasBuyerRemark != null">
        has_buyer_remark = #{hasBuyerRemark,jdbcType=BIT},
      </if>
      <if test="hasPlatskuRemark != null">
        has_platsku_remark = #{hasPlatskuRemark,jdbcType=BIT},
      </if>
      <if test="logisticsMethodCode != null">
        logistics_method_code = #{logisticsMethodCode,jdbcType=VARCHAR},
      </if>
      <if test="logisticsMethodName != null">
        logistics_method_name = #{logisticsMethodName,jdbcType=VARCHAR},
      </if>
      <if test="hasInnersale != null">
        has_innersale = #{hasInnersale,jdbcType=BIT},
      </if>
      <if test="companyId != null">
        company_id = #{companyId,jdbcType=INTEGER},
      </if>
      <if test="bailunRefundStatus != null">
        bailun_refund_status = #{bailunRefundStatus,jdbcType=VARCHAR},
      </if>
      <if test="refundObj != null">
        refund_obj = #{refundObj,jdbcType=VARCHAR},
      </if>
      <if test="refundType != null">
        refund_type = #{refundType,jdbcType=VARCHAR},
      </if>
      <if test="refundReferenceId != null">
        refund_reference_id = #{refundReferenceId,jdbcType=VARCHAR},
      </if>
      <if test="hasFbaS != null">
        has_fba_s = #{hasFbaS,jdbcType=BIT},
      </if>
      <if test="bailunSkuQuantityPushed != null">
        bailun_sku_quantity_pushed = #{bailunSkuQuantityPushed,jdbcType=INTEGER},
      </if>
      <if test="amountGeneralCargo != null">
        amount_general_cargo = #{amountGeneralCargo,jdbcType=DECIMAL},
      </if>
      <if test="hasTransferOrder != null">
        has_transfer_order = #{hasTransferOrder,jdbcType=BIT},
      </if>
    </trim>
  </insert>
  <insert id="upsert" parameterType="com.bailuntec.domain.entity.DcBaseOmsSku30">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
      @project https://github.com/itfsw/mybatis-generator-plugin
    -->
    insert into dc_base_oms_sku_30
    (id, origin_order_id, platform_type, transaction_id, pay_time, pay_method, pay_account,
      pay_status, collection_account, platform_order_type, website, create_time, paid_time,
      refund_time, seller_id, bailun_account_id, hq_account, seller_account, seller_order_id,
      seller_email, order_update_time, seller_order_exchange_rate, seller_other_exchange_rate,
      finance_order_exchange_rate, finance_other_exchange_rate, cny_to_usd_exchange_rate,
      order_to_usd_exchange_rate, other_to_usd_exchange_rate, order_currency, other_currency,
      seller_name, bailun_order_id, platform_order_status, bailun_order_status, bailun_payment_status,
      bailun_interception_status, shipping_status, bailun_sku, bailun_sku_title_en, bailun_sku_title_cn,
      bailun_sku_quantity_ordered, bailun_sku_quantity_shipped, bailun_sku_quantity_refund,
      bailun_sku_quantity_picked, warehouse_name, warehouse_code_fba, warehouse_code,
      bailun_sku_unit_price, bailun_sku_weight, bailun_sku_size, amount_sales, amount_total,
      amount_shipping, amount_product, amount_tax, amount_adjustment, amount_gift_wrap,
      amount_refund, amount_prepaid, cost_total, cost_promotion, cost_platform_fee, cost_product,
      cost_shipping, cost_package, cost_fba_fee, cost_paypal_fee, cost_refund_commisson,
      cost_handle_bailun, cost_handle_platform, cost_tail, cost_first, cost_logistics,
      profit_total, profit_rate, receipt_country, receipt_city, receipt_area, receipt_address,
      receipt_address_2, receipt_postal_code, receiver, receiver_phone, buyer_id, buyer_name,
      buyer_email, has_fba_exception, has_platform_exception, has_cancle, area_id, bailun_category_id,
      bailun_category_name, gmt_create, gmt_modified, ratio_weight, ratio_price, bailun_picking_status,
      bailun_require_logistics, has_delete, has_scalp, has_buyer_remark, has_platsku_remark,
      logistics_method_code, logistics_method_name, has_innersale, company_id, bailun_refund_status,
      refund_obj, refund_type, refund_reference_id, has_fba_s, bailun_sku_quantity_pushed,
      amount_general_cargo, has_transfer_order)
    values
    (#{id,jdbcType=INTEGER}, #{originOrderId,jdbcType=VARCHAR}, #{platformType,jdbcType=VARCHAR},
      #{transactionId,jdbcType=VARCHAR}, #{payTime,jdbcType=TIMESTAMP}, #{payMethod,jdbcType=VARCHAR},
      #{payAccount,jdbcType=VARCHAR}, #{payStatus,jdbcType=VARCHAR}, #{collectionAccount,jdbcType=VARCHAR},
      #{platformOrderType,jdbcType=VARCHAR}, #{website,jdbcType=VARCHAR}, #{createTime,jdbcType=TIMESTAMP},
      #{paidTime,jdbcType=TIMESTAMP}, #{refundTime,jdbcType=TIMESTAMP}, #{sellerId,jdbcType=VARCHAR},
      #{bailunAccountId,jdbcType=INTEGER}, #{hqAccount,jdbcType=VARCHAR}, #{sellerAccount,jdbcType=VARCHAR},
      #{sellerOrderId,jdbcType=VARCHAR}, #{sellerEmail,jdbcType=VARCHAR}, #{orderUpdateTime,jdbcType=TIMESTAMP},
      #{sellerOrderExchangeRate,jdbcType=DECIMAL}, #{sellerOtherExchangeRate,jdbcType=DECIMAL},
      #{financeOrderExchangeRate,jdbcType=DECIMAL}, #{financeOtherExchangeRate,jdbcType=DECIMAL},
      #{cnyToUsdExchangeRate,jdbcType=DECIMAL}, #{orderToUsdExchangeRate,jdbcType=DECIMAL},
      #{otherToUsdExchangeRate,jdbcType=DECIMAL}, #{orderCurrency,jdbcType=VARCHAR},
      #{otherCurrency,jdbcType=VARCHAR}, #{sellerName,jdbcType=VARCHAR}, #{bailunOrderId,jdbcType=VARCHAR},
      #{platformOrderStatus,jdbcType=VARCHAR}, #{bailunOrderStatus,jdbcType=VARCHAR},
      #{bailunPaymentStatus,jdbcType=VARCHAR}, #{bailunInterceptionStatus,jdbcType=VARCHAR},
      #{shippingStatus,jdbcType=VARCHAR}, #{bailunSku,jdbcType=VARCHAR}, #{bailunSkuTitleEn,jdbcType=VARCHAR},
      #{bailunSkuTitleCn,jdbcType=VARCHAR}, #{bailunSkuQuantityOrdered,jdbcType=INTEGER},
      #{bailunSkuQuantityShipped,jdbcType=INTEGER}, #{bailunSkuQuantityRefund,jdbcType=INTEGER},
      #{bailunSkuQuantityPicked,jdbcType=INTEGER}, #{warehouseName,jdbcType=VARCHAR},
      #{warehouseCodeFba,jdbcType=VARCHAR}, #{warehouseCode,jdbcType=VARCHAR}, #{bailunSkuUnitPrice,jdbcType=DECIMAL},
      #{bailunSkuWeight,jdbcType=DECIMAL}, #{bailunSkuSize,jdbcType=VARCHAR}, #{amountSales,jdbcType=DECIMAL},
      #{amountTotal,jdbcType=DECIMAL}, #{amountShipping,jdbcType=DECIMAL}, #{amountProduct,jdbcType=DECIMAL},
      #{amountTax,jdbcType=DECIMAL}, #{amountAdjustment,jdbcType=DECIMAL}, #{amountGiftWrap,jdbcType=DECIMAL},
      #{amountRefund,jdbcType=DECIMAL}, #{amountPrepaid,jdbcType=DECIMAL}, #{costTotal,jdbcType=DECIMAL},
      #{costPromotion,jdbcType=DECIMAL}, #{costPlatformFee,jdbcType=DECIMAL}, #{costProduct,jdbcType=DECIMAL},
      #{costShipping,jdbcType=DECIMAL}, #{costPackage,jdbcType=DECIMAL}, #{costFbaFee,jdbcType=DECIMAL},
      #{costPaypalFee,jdbcType=DECIMAL}, #{costRefundCommisson,jdbcType=DECIMAL}, #{costHandleBailun,jdbcType=DECIMAL},
      #{costHandlePlatform,jdbcType=DECIMAL}, #{costTail,jdbcType=DECIMAL}, #{costFirst,jdbcType=DECIMAL},
      #{costLogistics,jdbcType=DECIMAL}, #{profitTotal,jdbcType=DECIMAL}, #{profitRate,jdbcType=DECIMAL},
      #{receiptCountry,jdbcType=VARCHAR}, #{receiptCity,jdbcType=VARCHAR}, #{receiptArea,jdbcType=VARCHAR},
      #{receiptAddress,jdbcType=VARCHAR}, #{receiptAddress2,jdbcType=VARCHAR}, #{receiptPostalCode,jdbcType=VARCHAR},
      #{receiver,jdbcType=VARCHAR}, #{receiverPhone,jdbcType=VARCHAR}, #{buyerId,jdbcType=VARCHAR},
      #{buyerName,jdbcType=VARCHAR}, #{buyerEmail,jdbcType=VARCHAR}, #{hasFbaException,jdbcType=BIT},
      #{hasPlatformException,jdbcType=BIT}, #{hasCancle,jdbcType=BIT}, #{areaId,jdbcType=INTEGER},
      #{bailunCategoryId,jdbcType=INTEGER}, #{bailunCategoryName,jdbcType=VARCHAR}, #{gmtCreate,jdbcType=TIMESTAMP},
      #{gmtModified,jdbcType=TIMESTAMP}, #{ratioWeight,jdbcType=DECIMAL}, #{ratioPrice,jdbcType=DECIMAL},
      #{bailunPickingStatus,jdbcType=VARCHAR}, #{bailunRequireLogistics,jdbcType=VARCHAR},
      #{hasDelete,jdbcType=BIT}, #{hasScalp,jdbcType=BIT}, #{hasBuyerRemark,jdbcType=BIT},
      #{hasPlatskuRemark,jdbcType=BIT}, #{logisticsMethodCode,jdbcType=VARCHAR}, #{logisticsMethodName,jdbcType=VARCHAR},
      #{hasInnersale,jdbcType=BIT}, #{companyId,jdbcType=INTEGER}, #{bailunRefundStatus,jdbcType=VARCHAR},
      #{refundObj,jdbcType=VARCHAR}, #{refundType,jdbcType=VARCHAR}, #{refundReferenceId,jdbcType=VARCHAR},
      #{hasFbaS,jdbcType=BIT}, #{bailunSkuQuantityPushed,jdbcType=INTEGER}, #{amountGeneralCargo,jdbcType=DECIMAL},
      #{hasTransferOrder,jdbcType=BIT})
    on duplicate key update
    id = #{id,jdbcType=INTEGER},
    origin_order_id = #{originOrderId,jdbcType=VARCHAR},
    platform_type = #{platformType,jdbcType=VARCHAR},
    transaction_id = #{transactionId,jdbcType=VARCHAR},
    pay_time = #{payTime,jdbcType=TIMESTAMP},
    pay_method = #{payMethod,jdbcType=VARCHAR},
    pay_account = #{payAccount,jdbcType=VARCHAR},
    pay_status = #{payStatus,jdbcType=VARCHAR},
    collection_account = #{collectionAccount,jdbcType=VARCHAR},
    platform_order_type = #{platformOrderType,jdbcType=VARCHAR},
    website = #{website,jdbcType=VARCHAR},
    create_time = #{createTime,jdbcType=TIMESTAMP},
    paid_time = #{paidTime,jdbcType=TIMESTAMP},
    refund_time = #{refundTime,jdbcType=TIMESTAMP},
    seller_id = #{sellerId,jdbcType=VARCHAR},
    bailun_account_id = #{bailunAccountId,jdbcType=INTEGER},
    hq_account = #{hqAccount,jdbcType=VARCHAR},
    seller_account = #{sellerAccount,jdbcType=VARCHAR},
    seller_order_id = #{sellerOrderId,jdbcType=VARCHAR},
    seller_email = #{sellerEmail,jdbcType=VARCHAR},
    order_update_time = #{orderUpdateTime,jdbcType=TIMESTAMP},
    seller_order_exchange_rate = #{sellerOrderExchangeRate,jdbcType=DECIMAL},
    seller_other_exchange_rate = #{sellerOtherExchangeRate,jdbcType=DECIMAL},
    finance_order_exchange_rate = #{financeOrderExchangeRate,jdbcType=DECIMAL},
    finance_other_exchange_rate = #{financeOtherExchangeRate,jdbcType=DECIMAL},
    cny_to_usd_exchange_rate = #{cnyToUsdExchangeRate,jdbcType=DECIMAL},
    order_to_usd_exchange_rate = #{orderToUsdExchangeRate,jdbcType=DECIMAL},
    other_to_usd_exchange_rate = #{otherToUsdExchangeRate,jdbcType=DECIMAL},
    order_currency = #{orderCurrency,jdbcType=VARCHAR},
    other_currency = #{otherCurrency,jdbcType=VARCHAR},
    seller_name = #{sellerName,jdbcType=VARCHAR},
    bailun_order_id = #{bailunOrderId,jdbcType=VARCHAR},
    platform_order_status = #{platformOrderStatus,jdbcType=VARCHAR},
    bailun_order_status = #{bailunOrderStatus,jdbcType=VARCHAR},
    bailun_payment_status = #{bailunPaymentStatus,jdbcType=VARCHAR},
    bailun_interception_status = #{bailunInterceptionStatus,jdbcType=VARCHAR},
    shipping_status = #{shippingStatus,jdbcType=VARCHAR},
    bailun_sku = #{bailunSku,jdbcType=VARCHAR},
    bailun_sku_title_en = #{bailunSkuTitleEn,jdbcType=VARCHAR},
    bailun_sku_title_cn = #{bailunSkuTitleCn,jdbcType=VARCHAR},
    bailun_sku_quantity_ordered = #{bailunSkuQuantityOrdered,jdbcType=INTEGER},
    bailun_sku_quantity_shipped = #{bailunSkuQuantityShipped,jdbcType=INTEGER},
    bailun_sku_quantity_refund = #{bailunSkuQuantityRefund,jdbcType=INTEGER},
    bailun_sku_quantity_picked = #{bailunSkuQuantityPicked,jdbcType=INTEGER},
    warehouse_name = #{warehouseName,jdbcType=VARCHAR},
    warehouse_code_fba = #{warehouseCodeFba,jdbcType=VARCHAR},
    warehouse_code = #{warehouseCode,jdbcType=VARCHAR},
    bailun_sku_unit_price = #{bailunSkuUnitPrice,jdbcType=DECIMAL},
    bailun_sku_weight = #{bailunSkuWeight,jdbcType=DECIMAL},
    bailun_sku_size = #{bailunSkuSize,jdbcType=VARCHAR},
    amount_sales = #{amountSales,jdbcType=DECIMAL},
    amount_total = #{amountTotal,jdbcType=DECIMAL},
    amount_shipping = #{amountShipping,jdbcType=DECIMAL},
    amount_product = #{amountProduct,jdbcType=DECIMAL},
    amount_tax = #{amountTax,jdbcType=DECIMAL},
    amount_adjustment = #{amountAdjustment,jdbcType=DECIMAL},
    amount_gift_wrap = #{amountGiftWrap,jdbcType=DECIMAL},
    amount_refund = #{amountRefund,jdbcType=DECIMAL},
    amount_prepaid = #{amountPrepaid,jdbcType=DECIMAL},
    cost_total = #{costTotal,jdbcType=DECIMAL},
    cost_promotion = #{costPromotion,jdbcType=DECIMAL},
    cost_platform_fee = #{costPlatformFee,jdbcType=DECIMAL},
    cost_product = #{costProduct,jdbcType=DECIMAL},
    cost_shipping = #{costShipping,jdbcType=DECIMAL},
    cost_package = #{costPackage,jdbcType=DECIMAL},
    cost_fba_fee = #{costFbaFee,jdbcType=DECIMAL},
    cost_paypal_fee = #{costPaypalFee,jdbcType=DECIMAL},
    cost_refund_commisson = #{costRefundCommisson,jdbcType=DECIMAL},
    cost_handle_bailun = #{costHandleBailun,jdbcType=DECIMAL},
    cost_handle_platform = #{costHandlePlatform,jdbcType=DECIMAL},
    cost_tail = #{costTail,jdbcType=DECIMAL},
    cost_first = #{costFirst,jdbcType=DECIMAL},
    cost_logistics = #{costLogistics,jdbcType=DECIMAL},
    profit_total = #{profitTotal,jdbcType=DECIMAL},
    profit_rate = #{profitRate,jdbcType=DECIMAL},
    receipt_country = #{receiptCountry,jdbcType=VARCHAR},
    receipt_city = #{receiptCity,jdbcType=VARCHAR},
    receipt_area = #{receiptArea,jdbcType=VARCHAR},
    receipt_address = #{receiptAddress,jdbcType=VARCHAR},
    receipt_address_2 = #{receiptAddress2,jdbcType=VARCHAR},
    receipt_postal_code = #{receiptPostalCode,jdbcType=VARCHAR},
    receiver = #{receiver,jdbcType=VARCHAR},
    receiver_phone = #{receiverPhone,jdbcType=VARCHAR},
    buyer_id = #{buyerId,jdbcType=VARCHAR},
    buyer_name = #{buyerName,jdbcType=VARCHAR},
    buyer_email = #{buyerEmail,jdbcType=VARCHAR},
    has_fba_exception = #{hasFbaException,jdbcType=BIT},
    has_platform_exception = #{hasPlatformException,jdbcType=BIT},
    has_cancle = #{hasCancle,jdbcType=BIT},
    area_id = #{areaId,jdbcType=INTEGER},
    bailun_category_id = #{bailunCategoryId,jdbcType=INTEGER},
    bailun_category_name = #{bailunCategoryName,jdbcType=VARCHAR},
    gmt_create = #{gmtCreate,jdbcType=TIMESTAMP},
    gmt_modified = #{gmtModified,jdbcType=TIMESTAMP},
    ratio_weight = #{ratioWeight,jdbcType=DECIMAL},
    ratio_price = #{ratioPrice,jdbcType=DECIMAL},
    bailun_picking_status = #{bailunPickingStatus,jdbcType=VARCHAR},
    bailun_require_logistics = #{bailunRequireLogistics,jdbcType=VARCHAR},
    has_delete = #{hasDelete,jdbcType=BIT},
    has_scalp = #{hasScalp,jdbcType=BIT},
    has_buyer_remark = #{hasBuyerRemark,jdbcType=BIT},
    has_platsku_remark = #{hasPlatskuRemark,jdbcType=BIT},
    logistics_method_code = #{logisticsMethodCode,jdbcType=VARCHAR},
    logistics_method_name = #{logisticsMethodName,jdbcType=VARCHAR},
    has_innersale = #{hasInnersale,jdbcType=BIT},
    company_id = #{companyId,jdbcType=INTEGER},
    bailun_refund_status = #{bailunRefundStatus,jdbcType=VARCHAR},
    refund_obj = #{refundObj,jdbcType=VARCHAR},
    refund_type = #{refundType,jdbcType=VARCHAR},
    refund_reference_id = #{refundReferenceId,jdbcType=VARCHAR},
    has_fba_s = #{hasFbaS,jdbcType=BIT},
    bailun_sku_quantity_pushed = #{bailunSkuQuantityPushed,jdbcType=INTEGER},
    amount_general_cargo = #{amountGeneralCargo,jdbcType=DECIMAL},
    has_transfer_order = #{hasTransferOrder,jdbcType=BIT}
  </insert>
  <select id="selectOneByExample" parameterType="com.bailuntec.domain.example.DcBaseOmsSku30Example" resultMap="BaseResultMap">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
      @project https://github.com/itfsw/mybatis-generator-plugin
    -->
    select
    <include refid="Base_Column_List" />
    from dc_base_oms_sku_30
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
    <if test="orderByClause != null">
      order by ${orderByClause}
    </if>
    limit 1
  </select>

  <update id="upsertByOmsSku">
    insert into `dc_base_oms_sku_30` (
    origin_order_id,
    platform_type,
    transaction_id,
    pay_time,
    pay_method,
    pay_account,
    pay_status,
    collection_account,
    platform_order_type,
    website,
    create_time,
    paid_time,
    refund_time,
    seller_id,
    bailun_account_id,
    hq_account,
    seller_account,
    seller_order_id,
    seller_email,
    order_update_time,
    seller_order_exchange_rate,
    seller_other_exchange_rate,
    finance_order_exchange_rate,
    finance_other_exchange_rate,
    cny_to_usd_exchange_rate,
    order_to_usd_exchange_rate,
    other_to_usd_exchange_rate,
    order_currency,
    other_currency,
    seller_name,
    bailun_order_id,
    platform_order_status,
    bailun_order_status,
    bailun_payment_status,
    bailun_interception_status,
    shipping_status,
    bailun_sku,
    bailun_sku_title_en,
    bailun_sku_title_cn,
    bailun_sku_quantity_ordered,
    bailun_sku_quantity_shipped,
    bailun_sku_quantity_refund,
    bailun_sku_quantity_picked,
    warehouse_name,
    warehouse_code_fba,
    warehouse_code,
    bailun_sku_unit_price,
    bailun_sku_weight,
    bailun_sku_size,
    amount_sales,
    amount_total,
    amount_shipping,
    amount_product,
    amount_tax,
    amount_adjustment,
    amount_gift_wrap,
    amount_refund,
    amount_prepaid,
    cost_total,
    cost_promotion,
    cost_platform_fee,
    cost_product,
    cost_shipping,
    cost_package,
    cost_fba_fee,
    cost_paypal_fee,
    cost_refund_commisson,
    cost_handle_bailun,
    cost_handle_platform,
    cost_tail,
    cost_first,
    cost_logistics,
    profit_total,
    profit_rate,
    receipt_country,
    receipt_city,
    receipt_area,
    receipt_address,
    receipt_address_2,
    receipt_postal_code,
    receiver,
    receiver_phone,
    buyer_id,
    buyer_name,
    buyer_email,
    has_fba_exception,
    has_platform_exception,
    has_cancle,
    area_id,
    bailun_category_id,
    bailun_category_name,
    gmt_create,
    gmt_modified,
    ratio_weight,
    ratio_price,
    bailun_picking_status,
    bailun_require_logistics,
    has_delete,
    has_scalp,
    has_buyer_remark,
    has_platsku_remark,
    logistics_method_code,
    logistics_method_name,
    has_innersale,
    company_id,
    bailun_refund_status,
    refund_obj,
    refund_type,
    refund_reference_id,
    has_fba_s,
    bailun_sku_quantity_pushed,
    amount_general_cargo,
    has_transfer_order)
    select
    origin_order_id,
    platform_type,
    transaction_id,
    pay_time,
    pay_method,
    pay_account,
    pay_status,
    collection_account,
    platform_order_type,
    website,
    create_time,
    paid_time,
    refund_time,
    seller_id,
    bailun_account_id,
    hq_account,
    seller_account,
    seller_order_id,
    seller_email,
    order_update_time,
    seller_order_exchange_rate,
    seller_other_exchange_rate,
    finance_order_exchange_rate,
    finance_other_exchange_rate,
    cny_to_usd_exchange_rate,
    order_to_usd_exchange_rate,
    other_to_usd_exchange_rate,
    order_currency,
    other_currency,
    seller_name,
    bailun_order_id,
    platform_order_status,
    bailun_order_status,
    bailun_payment_status,
    bailun_interception_status,
    shipping_status,
    bailun_sku,
    bailun_sku_title_en,
    bailun_sku_title_cn,
    bailun_sku_quantity_ordered,
    bailun_sku_quantity_shipped,
    bailun_sku_quantity_refund,
    bailun_sku_quantity_picked,
    warehouse_name,
    warehouse_code_fba,
    warehouse_code,
    bailun_sku_unit_price,
    bailun_sku_weight,
    bailun_sku_size,
    amount_sales,
    amount_total,
    amount_shipping,
    amount_product,
    amount_tax,
    amount_adjustment,
    amount_gift_wrap,
    amount_refund,
    amount_prepaid,
    cost_total,
    cost_promotion,
    cost_platform_fee,
    cost_product,
    cost_shipping,
    cost_package,
    cost_fba_fee,
    cost_paypal_fee,
    cost_refund_commisson,
    cost_handle_bailun,
    cost_handle_platform,
    cost_tail,
    cost_first,
    cost_logistics,
    profit_total,
    profit_rate,
    receipt_country,
    receipt_city,
    receipt_area,
    receipt_address,
    receipt_address_2,
    receipt_postal_code,
    receiver,
    receiver_phone,
    buyer_id,
    buyer_name,
    buyer_email,
    has_fba_exception,
    has_platform_exception,
    has_cancle,
    area_id,
    bailun_category_id,
    bailun_category_name,
    gmt_create,
    gmt_modified,
    ratio_weight,
    ratio_price,
    bailun_picking_status,
    bailun_require_logistics,
    has_delete,
    has_scalp,
    has_buyer_remark,
    has_platsku_remark,
    logistics_method_code,
    logistics_method_name,
    has_innersale,
    company_id,
    bailun_refund_status,
    refund_obj,
    refund_type,
    refund_reference_id,
    has_fba_s,
    bailun_sku_quantity_pushed,
    amount_general_cargo,
    has_transfer_order
    FROM dc_base_oms_sku
    where pay_time &gt;= DATE_SUB(#{queryTime}, INTERVAL 31 DAY)
    and  pay_time &lt; #{queryTime}
    on duplicate key update
    origin_order_id = values(origin_order_id),
    platform_type = values(platform_type),
    transaction_id = values(transaction_id),
    pay_time = values(pay_time),
    pay_method = values(pay_method),
    pay_account = values(pay_account),
    pay_status = values(pay_status),
    collection_account = values(collection_account),
    platform_order_type = values(platform_order_type),
    website = values(website),
    create_time = values(create_time),
    paid_time = values(paid_time),
    refund_time = values(refund_time),
    seller_id = values(seller_id),
    bailun_account_id = values(bailun_account_id),
    hq_account = values(hq_account),
    seller_account = values(seller_account),
    seller_order_id = values(seller_order_id),
    seller_email = values(seller_email),
    order_update_time = values(order_update_time),
    seller_order_exchange_rate = values(seller_order_exchange_rate),
    seller_other_exchange_rate = values(seller_other_exchange_rate),
    finance_order_exchange_rate = values(finance_order_exchange_rate),
    finance_other_exchange_rate = values(finance_other_exchange_rate),
    cny_to_usd_exchange_rate = values(cny_to_usd_exchange_rate),
    order_to_usd_exchange_rate = values(order_to_usd_exchange_rate),
    other_to_usd_exchange_rate = values(other_to_usd_exchange_rate),
    order_currency = values(order_currency),
    other_currency = values(other_currency),
    seller_name = values(seller_name),
    bailun_order_id = values(bailun_order_id),
    platform_order_status = values(platform_order_status),
    bailun_order_status = values(bailun_order_status),
    bailun_payment_status = values(bailun_payment_status),
    bailun_interception_status = values(bailun_interception_status),
    shipping_status = values(shipping_status),
    bailun_sku = values(bailun_sku),
    bailun_sku_title_en = values(bailun_sku_title_en),
    bailun_sku_title_cn = values(bailun_sku_title_cn),
    bailun_sku_quantity_ordered = values(bailun_sku_quantity_ordered),
    bailun_sku_quantity_shipped = values(bailun_sku_quantity_shipped),
    bailun_sku_quantity_refund = values(bailun_sku_quantity_refund),
    bailun_sku_quantity_picked = values(bailun_sku_quantity_picked),
    warehouse_name = values(warehouse_name),
    warehouse_code_fba = values(warehouse_code_fba),
    warehouse_code = values(warehouse_code),
    bailun_sku_unit_price = values(bailun_sku_unit_price),
    bailun_sku_weight = values(bailun_sku_weight),
    bailun_sku_size = values(bailun_sku_size),
    amount_sales = values(amount_sales),
    amount_total = values(amount_total),
    amount_shipping = values(amount_shipping),
    amount_product = values(amount_product),
    amount_tax = values(amount_tax),
    amount_adjustment = values(amount_adjustment),
    amount_gift_wrap = values(amount_gift_wrap),
    amount_refund = values(amount_refund),
    amount_prepaid = values(amount_prepaid),
    cost_total = values(cost_total),
    cost_promotion = values(cost_promotion),
    cost_platform_fee = values(cost_platform_fee),
    cost_product = values(cost_product),
    cost_shipping = values(cost_shipping),
    cost_package = values(cost_package),
    cost_fba_fee = values(cost_fba_fee),
    cost_paypal_fee = values(cost_paypal_fee),
    cost_refund_commisson = values(cost_refund_commisson),
    cost_handle_bailun = values(cost_handle_bailun),
    cost_handle_platform = values(cost_handle_platform),
    cost_tail = values(cost_tail),
    cost_first = values(cost_first),
    cost_logistics = values(cost_logistics),
    profit_total = values(profit_total),
    profit_rate = values(profit_rate),
    receipt_country = values(receipt_country),
    receipt_city = values(receipt_city),
    receipt_area = values(receipt_area),
    receipt_address = values(receipt_address),
    receipt_address_2 = values(receipt_address_2),
    receipt_postal_code = values(receipt_postal_code),
    receiver = values(receiver),
    receiver_phone = values(receiver_phone),
    buyer_id = values(buyer_id),
    buyer_name = values(buyer_name),
    buyer_email = values(buyer_email),
    has_fba_exception = values(has_fba_exception),
    has_platform_exception = values(has_platform_exception),
    has_cancle = values(has_cancle),
    area_id = values(area_id),
    bailun_category_id = values(bailun_category_id),
    bailun_category_name = values(bailun_category_name),
    gmt_create = values(gmt_create),
    gmt_modified = values(gmt_modified),
    ratio_weight = values(ratio_weight),
    ratio_price = values(ratio_price),
    bailun_picking_status = values(bailun_picking_status),
    bailun_require_logistics = values(bailun_require_logistics),
    has_delete = values(has_delete),
    has_scalp = values(has_scalp),
    has_buyer_remark = values(has_buyer_remark),
    has_platsku_remark = values(has_platsku_remark),
    logistics_method_code = values(logistics_method_code),
    logistics_method_name = values(logistics_method_name),
    has_innersale = values(has_innersale),
    company_id = values(company_id),
    bailun_refund_status = values(bailun_refund_status),
    refund_obj = values(refund_obj),
    refund_type = values(refund_type),
    refund_reference_id = values(refund_reference_id),
    has_fba_s = values(has_fba_s),
    bailun_sku_quantity_pushed = values(bailun_sku_quantity_pushed),
    amount_general_cargo = values(amount_general_cargo),
    has_transfer_order = values(has_transfer_order)
  </update>

  <delete id="truncateTable">
    delete from dc_base_oms_sku_30
  </delete>
</mapper>
