仓储
2022-07-16 09:58:20 35 举报AI智能生成
表修改
作者其他创作
大纲/内容
所有表公共字段
id
common_status
creator
create_time
updater
update_time
version
用户表
user_type
货主
customer_user_id
车辆
car_number
transport_type
transport_logo
driver_user_id
driver_name
driver_company
driver_card
driver_phone
tare_up_limit
tare_down_limit
check_load
remarks
员工工作量统计表（t_personnel_workload_count）
id
user_id
user_name
in_number
in_weight
ex_number
ex_weight
入库计划表
input_plan_id
customer_id
customer_name
charge_customer_id
charge_customer_name
contract_id
contract_number
contract_name
goods_type_id
goods_type_name
business_id
business_name
documents_id
documents_name
plan_total_num
plan_origin_weight
plan_net_weight
plan_gross_weight
carrier
storehouse_id
storehouse_name
loading_place
discharging_place
organization_id
plan_date
plan_remarks
plan_status
plan_audit_status
plan_audit_remarks
plan_auditor_id
plan_auditor_name
plan_audit_time
documents_producer
goods_type
weigh_method_code
weigh_method_name
car_numbers
transport_type
入库附件表
goods_number
input_id
upload_way
type
file_name
file_path
入库计划物质表
input_plan_id
goods_id
goods_name
goods_code
goods_number
goods_model
container
container_size
packaging_grade_id
packaging_grade_name
color_id
color_name
origin_id
origin_name
weigh_method_code
weigh_method_name
plan_num
unit_id
unit_name
tiny_count
plan_weight
plan_origin_weight
plan_gross_weight
bundle_number
barcode
remarks
transport_type
入库计划审批表
input_plan_id
input_id
customer_id
customer_name
charge_customer_id
charge_customer_name
contract_number
contract_name
goods_type_id
goods_type_name
business_id
business_name
documents_id
documents_name
fact_total_num
fact_origin_weight
fact_net_weight
fact_gross_weight
carrier
storehouse_id
storehouse_name
loading_place
discharging_place
in_time
in_status
in_approach
audit_status
audit_remarks
auditor_id
auditor_name
audit_time
organization_id
weigh_method_code
weigh_method_name
car_numbers
transport_type
入库计划审批物资表
input_id
input_plan_id
goods_id
goods_name
goods_code
goods_number
goods_model
container
container_size
packaging_grade_id
packaging_grade_name
color_id
color_name
origin_id
origin_name
weigh_method_code
weigh_method_name
fact_num
unit_id
unit_name
tiny_count
fact_weight
fact_origin_weight
fact_gross_weight
plan_num
plan_weight
plan_origin_weight
plan_gross_weight
bundle_number
barcode
remarks
pound_difference
goods_status
in_time
librarian_id
librarian_name
in_man_id
in_man_name
transport_type
运单表
transportion_id
input_plan_id
input_id
car_number
car_id
transport_type
transport_logo
goods_number
goods_model
goods_type_id
goods_type_code
goods_type_name
goods_id
goods_code
goods_name
goods_location_id
goods_location_name
goods_area_id
goods_area_name
driver_user_id
driver_name
driver_company
driver_card
driver_phone
load_net_weight
load_count
tare_up_limit
tare_down_limit
check_weight
check_count
accept_man_id
accept_man_name
accept_date
cancel_reason
transport_remarks
load_ok
load_remarks
load_time
loading_place
unload_ok
unload_remarks
unload_time
discharging_place
transport_status
service_status
documents_producer
metering_status
fact_weight
fact_origin_weight
origin_weight_time
fact_gross_weight
gross_weight_time
weigh_method_code
weigh_method_name
dispatch_car_time
运单附件表
business_type
运单跟踪表
无人计量临时表
car_number
weight
driiver_id_card
weight_time
无人计量日志信息表
car_number
weight
goods_number
driiver_id_card
weight_time
库存客户表
customer_id
customer_name
storehouse_id
storehouse_name
goods_type_id
goods_type_name
in_num
left_num
left_weight
fact_origin_weigh
fact_gross_weigh
fact_net_weight
freeze
freeze_reason
库存客户入库计划表
input_id
input_plan_id
charge_customer_id
charge_customer_name
contract_number
contract_name
customer_id
customer_name
organization_id
storehouse_id
storehouse_name
goods_type_id
goods_type_name
business_id
business_name
fact_total_num
fact_origin_weight
fact_gross_weight
fact_net_weight
in_approach
in_time
验收人取运单最后一个
weigh_method_code
weigh_method_name
库存入库计划物资表 plan_weight plan_num pound_difference
transportion_id
inventory_input_id
input_id
goods_name
goods_number
goods_location_id
goods_location_name
goods_area_id
goods_area_name
goods_id
goods_code
goods_model
container
container_size
packaging_grade_id
packaging_grade_name
color_id
color_name
origin_id
origin_name
weigh_method_code
weigh_method_name
fact_num
unit_id
unit_name
tiny_count
fact_weight
fact_origin_weight
fact_gross_weight
left_num
left_weight
bundle_number
barcode
remarks
in_time
librarian_id
librarian_name
in_man_id
in_man_name
收藏
收藏
0 条评论
下一页
