#采购申请单表
|
drop table if exists purchase_application;
|
create table purchase_application
|
(
|
id bigint auto_increment primary key,
|
application_no varchar(50) not null comment '申请单号',
|
supplier_id bigint null comment '供应商id',
|
supplier_name varchar(100) null comment '供应商名称',
|
project_name varchar(100) null comment '项目名称',
|
sales_contract_no varchar(50) null comment '销售合同号',
|
sales_ledger_id int null comment '关联销售台账主表主键',
|
applicant_id bigint null comment '申请人id',
|
applicant_name varchar(50) null comment '申请人姓名',
|
apply_date date null comment '申请日期',
|
expected_arrival_date date null comment '期望到货日期',
|
contract_amount decimal(10, 2) null comment '申请金额（含税总价）',
|
payment_method varchar(255) null comment '付款方式',
|
remarks text null comment '备注',
|
status tinyint not null default 0 comment '状态 0草稿 1已生成订单',
|
purchase_ledger_id bigint null comment '转订单后生成的采购台账id',
|
convert_time datetime null comment '转订单时间',
|
tenant_id bigint null comment '租户ID',
|
dept_id bigint null comment '部门ID',
|
create_user bigint null comment '创建人ID',
|
create_time datetime null comment '创建时间',
|
update_time datetime null comment '更新时间',
|
index idx_application_no (application_no),
|
index idx_supplier_id (supplier_id),
|
index idx_purchase_ledger_id (purchase_ledger_id)
|
);
|
|
#采购申请产品明细表
|
drop table if exists purchase_application_product;
|
create table purchase_application_product
|
(
|
id bigint auto_increment primary key,
|
purchase_application_id bigint not null comment '采购申请单id',
|
product_id bigint null comment '产品id',
|
product_model_id bigint null comment '产品规格id',
|
product_category varchar(100) null comment '产品大类',
|
specification_model varchar(100) null comment '规格型号',
|
unit varchar(20) null comment '单位',
|
quantity decimal(18, 2) not null default 0 comment '数量',
|
tax_rate decimal(5, 0) null comment '税率',
|
tax_inclusive_unit_price decimal(18, 2) null comment '含税单价',
|
tax_inclusive_total_price decimal(18, 2) null comment '含税总价',
|
tax_exclusive_total_price decimal(18, 2) null comment '不含税总价',
|
invoice_type varchar(50) null comment '发票类型',
|
is_checked tinyint(1) not null default 1 comment '是否推送质检',
|
remark varchar(255) null comment '备注',
|
tenant_id bigint null comment '租户ID',
|
dept_id bigint null comment '部门ID',
|
create_user bigint null comment '创建人ID',
|
create_time datetime null comment '创建时间',
|
update_time datetime null comment '更新时间',
|
index idx_purchase_application_id (purchase_application_id)
|
);
|
