数据库词典
数据库tables列表
APP: tbo2o
- tbo2o_store (淘宝门店信息表)
- tbo2o_shop (全渠道店铺表)
- tbo2o_store_items (淘宝门店关联商品表)
- tbo2o_shop_products (淘宝后端货品表)
- tbo2o_store_cat (淘宝门店类目表)
- tbo2o_shop_product_ext (淘宝后端货品扩展表)
- tbo2o_shop_skus (淘宝前端宝贝表)
- tbo2o_shop_items (店铺商品表)
APP: inventorydepth
- inventorydepth_regulation_apply (规则应用中心)
- inventorydepth_formula (所有的公式信息，包括调整价格、调整库存等等..)
- inventorydepth_stock_release
- inventorydepth_regulation (所有的规则信息)
- inventorydepth_shop_skustockset (店铺货品库存设置)
- inventorydepth_task (活动任务信息)
- inventorydepth_operation_log (手工发布库存回写日志表)
- inventorydepth_log (库存深度日志)
- inventorydepth_shop_skus (店铺货品明细)
- inventorydepth_shop_items (店铺商品表)
- inventorydepth_task_skus (活动任务货品信息)
APP: organization
- organization_organization_ops (门店组织架构管理员关联表)
- organization_cos (企业组织架构表)
- organization_cos_ops (企业组织管理员)
- organization_organization (组织层级表)
APP: taoguaniostockorder
- taoguaniostockorder_diff (调拨入库差异表)
- taoguaniostockorder_iso_items_detail (出入库单信息明细表(批次维度))
- taoguaniostockorder_diff_items_detail (差异单明细责任判定表)
- taoguaniostockorder_diff_items (调拨入库差异明细表)
- taoguaniostockorder_iso (出入库单信息表)
- taoguaniostockorder_iso_items (出入库单信息明细表)
APP: monitor
- monitor_event_receiver (预警配置)
- monitor_event_group_template (监控邮件组关联模板)
- monitor_event_template (监控事件模板)
- monitor_event_notify (预警通知)
- monitor_event_group (监控邮件组关联事件信息)
APP: wms
- wms_delivery_bill (发货单多包裹表)
- wms_order_items (订单货品明细表(弃用))
- wms_delivery (自由仓库发货单)
- wms_delivery_items (发货单明细表)
- wms_batch_log (批量日志)
- wms_delivery_bill_items (发货包裹明细表)
- wms_delivery_log (发货单物流信息日志表)
- wms_batch_detail_log (批量发货日志)
- wms_order_objects (订单商品对象表(弃用))
- wms_product_serial (仓库货品唯一码表)
- wms_print_tmpl (打印模板)
- wms_delivery_items_storage_life (发货单明细预占保质期信息)
- wms_pda_pick
- wms_print_tag (大头笔设置表)
- wms_delivery_items_serial (发货单货品唯一码表)
- wms_abnormal_cause (异常原因信息)
APP: wap
- wap_delivery_bill (移动端发货通知单运单表)
- wap_return_items (门店H5移动端-退换货单据明细表)
- wap_return (门店H5移动端-退换货处理单据主表)
- wap_authorize (第三方免登信息表)
- wap_delivery (移动端发货通知单表)
- wap_delivery_items (移动端发货通知单明细表)
- wap_delivery_code (门店提货校验码关联表)
APP: dchain
- dchain_aoxiang_skus (店铺SKU映射表)
- dchain_aoxiang_branch (仓库映射表)
- dchain_aoxiang_delivery (发货单表)
- dchain_foreign_sku (外部erp商品映射关系)
- dchain_aoxiang_logistics (物流公司映射表)
- dchain_aoxiang_product (店铺商品映射表)
APP: archive
- archive_wmsdelivery_items (归档自有仓储发货单明细表)
- archive_refund_apply
- archive_delivery_bill (归档发货单多包裹表)
- archive_order_items (归档订单商品明细表)
- archive_sales (销售单归档表)
- archive_aftersale_items (售后单据明细)
- archive_order_objects_check_items (归档订单对象检测表)
- archive_sales_delivery_order_item
- archive_sales_objects (销售明细对象表)
- archive_order_objects_coupon (归档平台订单汇总优惠金额)
- archive_delivery (归档发货单表)
- archive_order_receiver (归档订单收货人信息表)
- archive_delivery_items (归档发货单明细表)
- archive_return_product (售后申请表)
- archive_delivery_items_detail (归档发货单明细关联订单表)
- archive_order_service (订单服务归档表)
- archive_return_product_items (售后申请单据明细)
- archive_order_selling_agent (归档订单代销扩展结构)
- archive_delivery_order (归档发货单和订单多对多的关系表)
- archive_wmsdelivery (归档自有仓储发货单主表)
- archive_order_pmt (归档订单促销规则)
- archive_order_luckybag (归档订单福袋表)
- archive_order_objects (归档订单商品对象表)
- archive_order_invoice (归档订单发票记录)
- archive_operation_log (归档操作员操作记录表)
- archive_wmsdelivery_bill (归档自有仓储发货单多包裹表)
- archive_order_objects_extend (归档订单Objects扩展表)
- archive_operation_log_copy (归档操作员操作记录备份表)
- archive_aftersale (售后单据)
- archive_order_coupon (归档订单优惠券明细)
- archive_reship_items
- archive_reship (退换货单表)
- archive_sales_delivery_order
- archive_sales_items (销售明细归档表)
- archive_orders (归档订单主表)
- archive_bill_label (归档单据标记表)
APP: sales
- sales_aftersale_items (售后单据明细)
- sales_delivery_order
- sales_aftersale_items_props
- sales_aftersale (售后单据)
- sales_delivery_order_item
- sales_delivery_order_item_props
APP: taoguanallocate
APP: omeauto
- omeauto_autohold
- omeauto_autobranch (自动审单仓库规则)
- omeauto_order_labels (标签表)
- omeauto_order_type (分组规则设置)
- omeauto_autodispatch (自动分配规则)
- omeauto_autobranchget
- omeauto_order_labelrule (订单标记规则)
- omeauto_order_split
- omeauto_branchgroup
- omeauto_autobind (自动合并规则)
- omeauto_autoconfirm (自动确认规则)
APP: tgstockcost
APP: o2o
- o2o_store_regions (门店关联地区数据表)
- o2o_store_daliy (门店每日汇总统计表)
- o2o_server (webpos服务端信息表)
- o2o_inventory (门店盘点主表)
- o2o_store (组织架构门店属性表)
- o2o_store_refuse_analysis (门店拒单原因表)
- o2o_autostore_rule (门店优选规则)
- o2o_product_store (门店货品库存表)
- o2o_syncproduct (pos sku关联表)
- o2o_branch_ops (管理员门店仓库权限表)
- o2o_refuse_reason (门店拒单原因表)
- o2o_autostore_rule_area_items (门店优选规则区域覆盖表)
- o2o_inventory_items (门店盘点明细表)
- o2o_branch_product (门店供货关系表)
APP: financebase
- financebase_bill_import_order (按单号导入明细)
- financebase_bill_import_jzt (精准通账单明细)
- financebase_bill_import_jdwallet (京东钱包导入记录表)
- financebase_bill_import_sale (按销售周期导入明细)
- financebase_bill_import_summary (导入数据汇总)
- financebase_bill_fee_type (费用表)
- financebase_bill_verification_error (核销误差表)
- financebase_expenses_split (费用拆分表)
- financebase_expenses_export_log (导出日志表)
- financebase_queue (队列表)
- financebase_bill_import_jdbill (京东钱包流水)
- financebase_bill_import (导入记录表)
- financebase_bill_base (流水原始数据表)
- financebase_bill_import_sku (商品sku明细)
- financebase_bill_category_rules (对账类目规则表)
- financebase_bill (流水快速表)
APP: omevirtualwms
APP: crm
APP: siso
APP: qimen
APP: desktop
- desktop_roles (管理员角色表)
- desktop_tag (列表标签表)
- desktop_user_flow (管理员和信息关联表)
- desktop_recycle (回收站)
- desktop_customcols (自定义字段)
- desktop_menus (后台菜单表)
- desktop_users (商店后台管理员表)
- desktop_filter (后台搜索过滤器表)
- desktop_export_template (新版导出模板存储表)
- desktop_role_flow (角色和信息关联表)
- desktop_hasrole (后台权限角色和用户关联表)
- desktop_pagecols_setting (页面字段配置表)
- desktop_flow (信息表)
- desktop_tag_rel (tag和对象关联表)
- desktop_interfacefield_mapper (接口字段映射表)
- desktop_user_logs (管理员操作日志表)
APP: omeanalysts
- omeanalysts_ome_goodsamount (商品表)
- omeanalysts_cat_sale_statis (商品类目销售对比统计)
- omeanalysts_relate (报表分析关联表)
- omeanalysts_interval (价格区间)
- omeanalysts_ome_orderDiscounts (订单优惠明细表)
- omeanalysts_logistics_analysts (仓储物流配送统计表)
- omeanalysts_branch_product_stock_detail (商品库存日报表)
- omeanalysts_ome_rmatype (售后类型)
- omeanalysts_ordersPrice (客单价分布)
- omeanalysts_ordersTime (下单时间分析)
- omeanalysts_sale_products (已销售产品)
- omeanalysts_ome_salestatistics (退货率统计)
- omeanalysts_zero_sale (零销售产品分析)
- omeanalysts_products_sale (产品销售排行榜)
- omeanalysts_ome_goodsrma (商品表)
APP: dealer
- dealer_platform_order_extend (平台订单信息表)
- dealer_series (产品线)
- dealer_platform_aftersale (aftersales)
- dealer_platform_order_items (分销平台订单Item表)
- dealer_platform_aftersale_extend (aftersales)
- dealer_bbu (销售团队表)
- dealer_business_branch (经销商仓库)
- dealer_batch_log (批量日志表)
- dealer_goods (经销商货品)
- dealer_platform_aftersale_items (platform_aftersale_items)
- dealer_series_endorse_products (产品授权到店)
- dealer_platform_order_objects (分销平台订单Object表)
- dealer_platform_aftersale_objects (platform_aftersale_objects)
- dealer_platform_orders (分销平台订单主表)
- dealer_sales_material (销售商品表)
- dealer_business (经销商)
- dealer_sales_basic_material (销售物料与基础物料关联表)
- dealer_series_products (产品线绑物料)
- dealer_betc (贸易公司表)
- dealer_goods_price (经销商品价格管理)
- dealer_series_endorse (产品线授权到店)
APP: dbeav
- dbeav_meta_register (meta关联表)
- dbeav_meta_value_decimal (meta系统decimal类型)
- dbeav_recycle (回收站)
- dbeav_meta_value_longtext (meta系统text类型存值表)
- dbeav_meta_value_int (meta系统int类型存值表)
- dbeav_meta_value_text (meta系统text类型存值表)
- dbeav_meta_value_datetime (meta系统datetime类型存值表)
- dbeav_meta_value_varchar (meta系统varchar类型存值表)
APP: pam
APP: openapi
APP: image
APP: channel
- channel_logistics_logs (日志表)
- channel_channel (渠道表)
- channel_adapter (渠道适配器关系表)
- channel_logistics_examinreport (体检记录表)
APP: wmsmgr
- wmsmgr_branch_relation (第三方仓储仓库关联关系表)
- wmsmgr_supplier_relation
- wmsmgr_express_relation (物流公司关联表)
- wmsmgr_abnormal_code (WMS异常错误码)
- wmsmgr_channel (渠道管理列表)
APP: ome
- ome_order_batch (订单批次号计算)
- ome_return_product_problem (售后问题类型表)
- ome_shop_props (店铺自定义表)
- ome_api_log_copy (api日志)
- ome_return_batch (批量操作表)
- ome_tbfx_orders (淘宝分销主表)
- ome_iostock (出入库单)
- ome_refund_apply (退款单申请)
- ome_branch_props (仓库自定义表)
- ome_delivery_bill (物流包裹单表)
- ome_shop_members (前端店铺会员和ome会员对应关系表)
- ome_order_items (订单行明细表,用于存储订单最小发货单位商品,与子单是一对多关系.比如捆绑商品就是一个子单对应多个订单行明细)
- ome_analysis_productnsale (不动销商品报表)
- ome_branch_relation (平台仓库编码配置表)
- ome_return_product_tmall (售后申请天猫附加信息表)
- ome_return_product_yihaodian (售后申请一号店附加信息表)
- ome_return_payments (售后单与[退货]支付单(明细)对应表)
- ome_refund_apply_luban (抖音退款申请附加信息表)
- ome_tbgift_product (捆绑商品)
- ome_return_product_pinduoduo (售后申请拼多多附加信息表)
- ome_sales (销售单表)
- ome_delivery_object_freeze (发货单销售物料的冻结数)
- ome_refund_apply_pinduoduo (退款申请拼多多附加信息表)
- ome_sync_task (同步任务)
- ome_dly_corp_channel
- ome_reship_objects
- ome_order_objects_check_items (订单对象检测表)
- ome_branch_product_extend (库存销售模式表)
- ome_print_otmpl (打印发货备货单模板管理表)
- ome_payment_shop (支付方式和店铺关系表)
- ome_order_extend (订单扩展表)
- ome_gift_rule (赠品规则表)
- ome_sales_objects (销售明细对象表)
- ome_refund_negotiate (售后协商申请表)
- ome_product_serial_log (唯一码商品日志表)
- ome_return_product_huawei (抖音售后申请附加信息表)
- ome_operation_organization (运营组织主表)
- ome_return_address (地址表)
- ome_payment_cfg (支付单辅助表)
- ome_order_objects_coupon (平台订单汇总优惠金额)
- ome_concurrent (防止重复记录表)
- ome_delivery (发货单表,用于存储仓库发货信息,与订单是多对多关系)
- ome_reship_items_serial (退货单货品唯一码表)
- ome_return_product_kaola (售后申请考拉附加表)
- ome_order_receiver (订单收货人信息表)
- ome_type_brand (类型品牌关系表)
- ome_operations_order (订单操作扩展表)
- ome_snapshot (赠品设置快照表)
- ome_branch_flow (货物流转)
- ome_delivery_items (发货单商品明细,用于存储需要发货的基础物料)
- ome_batch_log (批量日志)
- ome_order_label (订单标记表)
- ome_reship_pda_return_info
- ome_delivery_sync (订单拆单发货单回写状态表)
- ome_return_product (售后申请表)
- ome_material_freeze_queue (物料总冻结流水队列)
- ome_goods (商品表)
- ome_delivery_items_detail (发货单明细详情,用于存储以订单行明细纬度数量.如:合单发货会以订单行明细平铺)
- ome_tbfx_order_objects (淘宝分销主表)
- ome_shipment_log (前端回写日志)
- ome_order_delivery (订单拆单店铺原子订单记录表)
- ome_fxw_orders (分销王主表)
- ome_bank_account (银行账户信息)
- ome_gift_logs (赠品发送日志表)
- ome_branch_corp (仓库物流关系表)
- ome_shop_groups (管理员组与店铺绑定关系表)
- ome_refund_apply_youzan (退款申请拼多多附加信息表)
- ome_members (会员表)
- ome_order_service (服务订单表)
- ome_print_queue (打印批次主表结构)
- ome_return_product_problem_type (质量问题类型)
- ome_return_product_items (售后申请单据明细)
- ome_tbjz_orders (淘宝家装订单附加信息表)
- ome_return_product_youzan (售后申请有赞附加信息表)
- ome_sales_items_props
- ome_delivery_log (发货单物流信息日志记录表)
- ome_dailystock (每日库存快照)
- ome_tbfx_order_items (淘宝分销主表)
- ome_return_refund_apply (售后服务和退款申请的对应关系表)
- ome_shop (店铺表)
- ome_tbgift_order_items (淘宝订单赠品信息表)
- ome_print_queue_items (打印批次表子表结构)
- ome_api_log (api日志)
- ome_order_selling_agent (订单代销扩展结构)
- ome_order_retrial_snapshot (复审订单快照表)
- ome_abnormal_type (订单异常类型)
- ome_branch_freeze_queue (仓冻结流水队列)
- ome_delivery_order (发货单和订单多对多关系表)
- ome_reship_package_items (退货包裹明细表)
- ome_batch_detail_log (批量发货日志)
- ome_order_outstorage (出库失败表)
- ome_delivery_package (发货包裹表)
- ome_dly_corp_area (物流公司能对应的地区id 关系表)
- ome_entity_branch_product (实体仓商品关联表)
- ome_order_pmt (订单促销规则)
- ome_dly_items_pos (发货单明细中的货品的货位关系表)
- ome_refund_no_order (支付记录)
- ome_order_luckybag (订单福袋表)
- ome_goods_type (商品类型表)
- ome_order_objects (订单子单表,用于存储平台的订单购买行明细)
- ome_return_process (收货服务中间表)
- ome_shop_dly_corp (前端店铺物流公司关联)
- ome_product_serial (商品唯一码表)
- ome_branch_type (仓库类型表)
- ome_product_storagelife_history (保质期批次历史记录表)
- ome_order_invoice (订单发表记录)
- ome_return_product_360buy (售后申请京东附加信息表)
- ome_member_address (会员地址库)
- ome_operation_log (操作员记录表)
- ome_reship_package (退货包裹表)
- ome_tbgift_goods (淘宝赠品表)
- ome_print_tmpl (快递单模板)
- ome_branch_groups (仓库和管理员组关系表)
- ome_order_settle (平台订单金额明细)
- ome_refunds (支付记录)
- ome_extrabranch (外部仓库设置)
- ome_api_fail (请求失败记录)
- ome_branch (发货点)
- ome_order_platformsplit (订单平台拆分表)
- ome_order_preprocess (订单预处理记录表)
- ome_misc_task (定时触发表)
- ome_operation_ops (运营组织管理员)
- ome_channel (应用绑定)
- ome_refund_noreturn (退款未退货报表)
- ome_payments (支付记录)
- ome_product_stock_artificial_freeze (人工库存预占表)
- ome_product_serial_history (唯一码历史记录表)
- ome_dly_corp_items (物流公司明细)
- ome_delivery_return (发货单和售后服务关系表)
- ome_gift_set_logs (赠品设置日志表)
- ome_order_objects_extend (订单Objects扩展表)
- ome_branch_ops (仓库和管理员关联表)
- ome_branch_area (发货点和地区对应关系表)
- ome_specification (商店中商品规格)
- ome_goods_type_spec (类型 规格索引表)
- ome_goods_spec_index (商品规格索引表)
- ome_api_order_log (前端店铺订单列表同步日志)
- ome_return_process_items (收货服务中间表明细)
- ome_api_stock_log (库存同步日志)
- ome_refund_apply_tmall (退款申请天猫附加信息表)
- ome_return_product_luban (抖音售后申请附加信息表)
- ome_return_freight (退货寄回运费)
- ome_freeze_stock_log (冻结库存流水表)
- ome_branch_stock_queue (仓库存流水队列)
- ome_reship_items_storagelife (退货单货品保质期批次表)
- ome_order_coupon (平台订单金额明细)
- ome_return_product_bbc (售后申请BBC附加表)
- ome_refund_reason (退款原因)
- ome_return_apply_special (退款单特殊相关)
- ome_products (货品表)
- ome_order_sync_status (订单同步状态表)
- ome_product_stock_artificial_freeze_group (人工库存预占组表)
- ome_spec_values (商店中商品规格值)
- ome_print_tag (大头笔设置)
- ome_order_groupon (订单批量导入)
- ome_stock_change_log (库存变更日志)
- ome_operation_log_snapshoot (操作员记录快照扩展表)
- ome_order_retrial (复审订单表)
- ome_order_groupon_items (团购订单批次和订单号的关联)
- ome_change_items (换货明细)
- ome_groups (管理员组)
- ome_reship_items (退货申请明细)
- ome_branch_pos (发货点仓库货位表)
- ome_refund_apply_taobao (退款申请淘宝附加信息表)
- ome_reship (退换货单表)
- ome_delivery_items_storagelife (发货单货品保质期批次表)
- ome_delivery_items_serial (发货单货品唯一码表)
- ome_tbjz_partner (淘宝家装服务商信息表)
- ome_return_product_taobao (售后申请淘宝附加信息表)
- ome_group_ops (小组成员表)
- ome_print_tmpl_diy (信息表)
- ome_abnormal (订单异常信息表)
- ome_sales_items (销售明细表)
- ome_analysis_stocknsale (呆滞库存统计报表)
- ome_goods_cat (类别属性值有限表)
- ome_shop_onoffline (网店和门店的关联表)
- ome_order_retrial_store_freeze (复审订单购买数量快照表)
- ome_brand (品牌表)
- ome_iostock_type (出入库类型)
- ome_return_exchange_receiver (换货地址表)
- ome_branch_product_pos (仓库中货品所在货位关系表)
- ome_orders (订单表,用于存储全渠道订单)
- ome_bill_label (单据标记表)
- ome_dly_corp (物流公司配送信息)
- ome_order_abnormal (订单异常表)
- ome_branch_product (分店(仓库)和商品关联表)
- ome_compensate_record
APP: eccommon
- eccommon_analysis_logs (电商商务通用应用分析记录)
- eccommon_warehouse_address (京标地址表)
- eccommon_currency (电商商务通用应用货币表)
- eccommon_analysis (电商商务通用应用分析)
- eccommon_regions (电商商务通用应用区域表)
- eccommon_platform_regions (平台地区表)
APP: vop
- vop_sales (唯品会销售单)
- vop_po (唯品会账单)
- vop_source_billgoods_ext (唯品会账单明细)
- vop_vreturn_diff_items (退供差异账单明细)
- vop_source_billgoods (唯品会账单明细)
- vop_source_detail_ext (唯品会费用项明细)
- vop_vreturn_diff (退供差异账单)
- vop_source_discount (唯品会账单满减明细)
- vop_sku_stock (唯品会购物车冻结表)
- vop_bill (唯品会账单)
- vop_sales_items (唯品会销售单明细)
- vop_source_discount_ext (唯品会账单满减明细)
- vop_source_detail (唯品会费用项明细)
APP: pos
- pos_inventory_snapshot_items (POS库存快照明细)
- pos_refund (退款单申请)
- pos_productprice (pos price关联表)
- pos_inventory_snapshot (POS库存快照)
- pos_syncproduct (pos sku关联表)
- pos_aftersale (售后单申请原始数据)
- pos_iso (POS其他出入库单据)
- pos_iso_items (POS其他出入库明细)
- pos_orders (订单表)
APP: taoguaninventory
- taoguaninventory_inventory (盘点表)
- taoguaninventory_inventory_filter (盘点筛选条件表)
- taoguaninventory_inventory_object (盘点中间表)
- taoguaninventory_encoded_state (编码状态表)
- taoguaninventory_inventory_items (盘点明细表)
APP: tongyioil
- tongyioil_sales (统一SAP销售表)
- tongyioil_aftersale_items (售后单明细表)
- tongyioil_bill_items_detail (回款单明细详情, 源数据取自sdb_financebase_bill)
- tongyioil_bill_items (统一SAP账单明细表)
- tongyioil_region_relation (地区关联表)
- tongyioil_aftersale (售后单表)
- tongyioil_platform_coupon_setting (平台优惠券配置表)
- tongyioil_bill (统一SAP账单表)
- tongyioil_sales_items (统一SAP销售明细表)
APP: purchase
- purchase_supplier_goods (供应商商品)
- purchase_purchase_payments (付款单)
- purchase_order_sku_price (PO采购单供货价)
- purchase_inventory (盘点表)
- purchase_purchase_refunds (退款单)
- purchase_eo_items (入库单明细)
- purchase_order (PO单)
- purchase_carrier (承运商管理表)
- purchase_appropriation_items (库存调拨单明细)
- purchase_pick_bill_check_items (拣货单明细检测表)
- purchase_pick_order_items (JIT订单明细查询表)
- purchase_po (采购单)
- purchase_eo (入库单( entry_order ))
- purchase_pick_bill_items (拣货单明细)
- purchase_returned_purchase_items (退货单明细)
- purchase_order_wait (待寻仓订单)
- purchase_appropriation (库存调整单（调拨单）)
- purchase_inventory_filter (盘点筛选条件表)
- purchase_statement (结算单)
- purchase_supplier (供应商)
- purchase_branch_product_batch (货品价格历史记录)
- purchase_setting_shop (JIT配置关联店铺表)
- purchase_supplier_brand (供应商提供的品牌)
- purchase_pick_stockout_bills (出库单)
- purchase_pick_stockout (拣货出库单关联表)
- purchase_warehouse (唯品会仓库表)
- purchase_credit_sheet (赊账单)
- purchase_pick_bills (拣货单)
- purchase_pick_stockout_bill_item_boxs (出库单明细装箱信息)
- purchase_returned_purchase (退货单)
- purchase_setting (自动审核配置)
- purchase_pick_bill_item_inventory (拣货单明细的详单)
- purchase_pick_stockout_bill_items (出库单明细)
- purchase_order_wait_items (待寻仓订单明细)
- purchase_po_items (采购单明细)
- purchase_inventory_items (盘点明细表)
APP: logisticsmanager
- logisticsmanager_waybill_extend (运单扩展表)
- logisticsmanager_sfcity_code (顺丰城市代码表)
- logisticsmanager_cloudprint (云打印终端表)
- logisticsmanager_logistics_log (请求面单号日志表)
- logisticsmanager_channel_extend (面单来源表)
- logisticsmanager_waybill_log (请求面单号日志表)
- logisticsmanager_waybill (面单号表)
- logisticsmanager_express_template (面单模板表)
- logisticsmanager_channel (面单来源表)
- logisticsmanager_warehouse_address (京标地址表)
- logisticsmanager_warehouse (区域仓表)
- logisticsmanager_warehouse_shop (区域店铺关系表)
APP: finance
- finance_verification
- finance_ar
- finance_bill_confirm (账单确认表)
- finance_analysis_book_bills (运营费用表)
- finance_taskid (交易任务号)
- finance_tasklog (对账支付宝接口请求日志表)
- finance_channel_bills (弃用)
- finance_ar_items (销售应收单明细)
- finance_bill_fee_type (费用项类型)
- finance_bill_verification_relation (核销关联表)
- finance_verification_items (核销日志明细)
- finance_monthly_report_items (月结账单明细)
- finance_analysis_bills (交易费用表)
- finance_bill (销售收退款单)
- finance_bill_fee_item (费用项)
- finance_monthly_report (月结账单)
- finance_bill_op_logs (流水操作日志表)
APP: brush
- brush_farm (刷单条件表)
- brush_delivery
- brush_delivery_items
- brush_delivery_items_detail
- brush_delivery_order
- brush_farm_order (刷单与订单对应表)
APP: tgkpi
APP: omecsv
APP: warehouse
APP: taoexlib
- taoexlib_sms_bind (发送设置)
- taoexlib_ietask (导出任务列表)
- taoexlib_queue (队列管理)
- taoexlib_sms_sample (短信模板)
- taoexlib_smslog (短信日志)
- taoexlib_sms_sign (短信验签表)
- taoexlib_log (短信日志)
- taoexlib_export_history (导出任务历史记录)
- taoexlib_sms_sample_items (短信模板明细表)
APP: erpapi
APP: logisticsaccounts
- logisticsaccounts_actual_task (对账任务)
- logisticsaccounts_estimate (对账审核)
- logisticsaccounts_actual_object (物流账单对象)
- logisticsaccounts_actual (物流账单)
APP: logistics
- logistics_area (区域)
- logistics_rule (规则)
- logistics_branch_rule (仓库规则)
- logistics_rule_obj (规则对象)
- logistics_area_router (区域路由表)
- logistics_rule_shop (优选规则与店铺关系表)
- logistics_region_rule (区域规则)
- logistics_rule_items (规则明细)
APP: material
- material_basic_material_stock (基础物料总库存表)
- material_sales_material_fukubukuro (销售物料与福袋组合关联表, 用于存储两者关系, 支持一对多)
- material_basic_material_stock_artificial_freeze_group (人工库存预占组表)
- material_fukubukuro_log (订单分配福袋日志表)
- material_basic_material (基础物料表,用于存储SKU纬度的商品数据)
- material_sales_material_shop_freeze (销售物料店铺冻结表)
- material_basic_material_ext (基础物料扩展表,用于存储基础物料的额外属性信息)
- material_basic_material_cat (基础物料分类)
- material_basic_material_feature_group (基础物料关联特性扩展表)
- material_basic_material_conf (基础物料配置表)
- material_fukubukuro_combine_items (福袋组合关联基础物料表)
- material_luckybag_rule_reship_item (售后换出福袋货品的规则关系表)
- material_basic_material_combination_items (基础物料组合类扩展表)
- material_fukubukuro_combine (福袋组合表)
- material_sales_material (销售物料表,用于匹配销售平台订单商品编码)
- material_basic_material_props (基础物料配置表)
- material_basic_material_storage_life (基础物料保质期明细数据)
- material_basic_material_channel (基础物料wms渠道映射表)
- material_luckybag_log (福袋商品订单日志表)
- material_sales_basic_material (销售物料与基础物料关联表, 用于存储两者关系, 支持一对多)
- material_basic_material_stock_artificial_freeze (人工库存预占表)
- material_basic_material_storage_life_bills (基础物料保质期明细流水单据)
- material_basic_material_stock_freeze (基础物料预占流水表)
- material_codebase (基础物料与条码关联表)
- material_pickone_rules (多选一商品规则信息表)
- material_sales_material_ext (销售物料扩展表,用于存储销售物料的额外属性信息)
- material_customer_classify (销售客户分类表)
- material_basic_material_conf_special (基础物料特殊扫码配置表)
- material_luckybag_rules (福袋商品规则信息表)
- material_basic_material_stock_arrive (在途流水表)
APP: billcenter
- billcenter_sales (唯品会销售单)
- billcenter_aftersales (唯品会售后单)
- billcenter_aftersales_items (唯品会售后单明细)
- billcenter_sales_items (唯品会销售单明细)
APP: base
- base_apps (系统应用表)
- base_files (storager文件存储信息)
- base_cache_expires (缓存过期表)
- base_task (计划任务表)
- base_queue (对列表)
- base_rpcnotify (系统通知表)
- base_kvstore (kvstore存储表)
- base_rpcpoll (通信链接池表)
- base_app_content (app资源信息表)
- base_network (网络互联表)
APP: flowctrl
APP: invoice
- invoice_order_items
- invoice_order (订单发票表)
- invoice_order_electronic_items (电子发票开票信息明细表)
- invoice_setting_shopid_relation (开票配置和店铺关系表)
- invoice_content (发票内容表)
- invoice_goods_items (商品与服务税收分类编码)
- invoice_channel (电子发票渠道来源表)
- invoice_order_front_items
- invoice_order_taobao (淘系原始开票信息)
- invoice_order_front (预发票表)
- invoice_order_setting (订单发票配置表)
- invoice_order_taobao_items (淘系原始开票明细信息)
APP: console
- console_wms_stockin_items (第三方入库单明细)
- console_stock_account_items (盘点申请表)
- console_material_package_items_detail (组装单表明细详情)
- console_inventory_order_items (唯品会成交的销售单明细表)
- console_vopreturn (唯品会退货单)
- console_inventory_snapshot_items (WMS库存快照明细)
- console_difference (盘点差异单)
- console_adjust_items (库存调整表明细)
- console_wms_stock_change (第三方库存异动单)
- console_wms_reship (第三方退货单)
- console_inventory (盘点申请表)
- console_dailyinventory_items (日盘单wms仓库)
- console_inventory_snapshot (WMS库存快照)
- console_dailyinventory (日盘单)
- console_difference_items (盘点差异单明细)
- console_useful_life_log
- console_vopreturn_items (唯品会退货单明细)
- console_vopbill_items (唯品会账单明细)
- console_delivery_extension (京东仓储发货单外部带好对于扩展表)
- console_wms_delivery_items (第三方发货单明细)
- console_stockdump_items (库存出入库单明细)
- console_material_package (库存调整表)
- console_difference_items_freeze (盘点差异单明细冻结)
- console_foreign_bn (外部编号关联表)
- console_wms_stockin (第三方入库单)
- console_foreign_sku (外部sku关联表)
- console_wms_transferorder_items (第三方转储单明细)
- console_cpfr_items (配货单明细表)
- console_store_freeze_log (出入库日志表)
- console_wms_reship_items (第三方退货单明细)
- console_replenish_diff (补货差异单据表)
- console_wms_transferorder (第三方转储单)
- console_wms_delivery (第三方退货单)
- console_wms_storeprocess (第三方加工单)
- console_useful_life
- console_replenish_suggest (补货建议单据表)
- console_vopbill_detail (唯品会费用项明细)
- console_inventory_apply (盘点申请表)
- console_wms_storeprocess_productitems (第三方加工单商品)
- console_material_package_items (组装单表明细)
- console_adjust (库存调整表)
- console_wms_stockout (第三方出库单)
- console_replenish_task (补货任务表)
- console_wms_stockout_items (第三方出库单明细)
- console_wms_storeprocess_materialitems (第三方加工单物料)
- console_inventory_orders (唯品会成交的销售单表)
- console_vopbill_amount (唯品会账单明细)
- console_stock_account (商品出库统计表)
- console_cpfr (配货单表)
- console_stockdump (库存出入库单列表)
- console_replenish_suggest_items (补货建议单据表)
- console_vopbill_discount (唯品会账单满减明细)
- console_inventory_items (盘点申请表)
- console_inventory_apply_items (盘点申请明细表)
- console_vopbill (唯品会账单)