34,587
社区成员
发帖
与我相关
我的任务
分享
我要做进销存,麻烦帮忙设计表,物料表,材料进出库表,库存表,要考虑先进先出,移动加权平均,不核算成本,谢谢!
create table Material (
marno varchar(10) constraint pk_Material primary key,
marDescription varchar(100),
model
uom
category
...
)
create table warehouse (
WHNO varchar(10) constraint pk_warehouse primary key,
address
owner
...
)
create table location(
locID varchar(10), --PK
WHNO varchar(10)
....
)
create table acperiod(
FY integer,
pid integer constraint pk_acperiod primary key,
bdate datetime,
edate datetime
)
create table stockBalance (
pid integer,
WHNO varchar(10),
marno varchar(10),
qty integer,
value money
... --PK(pid,WHNO,marno)
)
create table stockitem(
locID varchar(10),
batchno varchar(10),
marno varchar(10),
qty integer,
....
)
create table goodMovement(
gmno integer, identity
marno varchar(10),
qty integer,
value money,
locID varchar(10),
batchno varchar(10),
gdate datetime,
mvType varchar(4),
opr varchar(10)
)