配送计划导入子表设计
PEISON JYEAHWA DAORW DSIBYAOR SHAJYEA
create table T_AIS_CL_OUTPUT_D
(
PLAN_MGR_ID VARCHAR2(20) not null,
PLAN_MGR_SUBID VARCHAR2(20) not null,
STATUS VARCHAR2(10) default 10,
PLAN_YEAR VARCHAR2(4),
PLAN_TIME VARCHAR2(10),
PLAN_WEIGHT NUMBER(18,6),
VERSION_WEEK_NO VARCHAR2(20),
REMARK VARCHAR2(400),
UPLOAD_PERSION VARCHAR2(20),
UPLOAD_DATE DATE default sysdate,
CREATE_ID VARCHAR2(10),
CREATE_DATE DATE default sysdate,
UPDATE_ID VARCHAR2(10),
UPDATE_DATE DATE,
MANAGE_DIMENSIONALITY VARCHAR2(10),
PLAN_MONTH VARCHAR2(10),
PLAN_WEEK VARCHAR2(10),
BEGIN_DATE DATE,
END_DATE DATE,
ORD_DIS_TYPE VARCHAR2(10),
UNITS VARCHAR2(10),
COST_WEIGHT NUMBER(10,6)
)
tablespace AIS_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Add comments to the table
comment on table T_AIS_CL_OUTPUT_D
is '家电产量明细信息';
-- Add comments to the columns
comment on column T_AIS_CL_OUTPUT_D.PLAN_MGR_ID
is '计划管理号';
comment on column T_AIS_CL_OUTPUT_D.PLAN_MGR_SUBID
is '计划管理子项号';
comment on column T_AIS_CL_OUTPUT_D.STATUS
is '有效状态[10，有效，00，无效]';
comment on column T_AIS_CL_OUTPUT_D.PLAN_YEAR
is '计划年';
comment on column T_AIS_CL_OUTPUT_D.PLAN_TIME
is '计划时间[周
月
季,
根据管理维度定
]';
comment on column T_AIS_CL_OUTPUT_D.PLAN_WEIGHT
is '计划量';
comment on column T_AIS_CL_OUTPUT_D.VERSION_WEEK_NO
is '版本控制';
comment on column T_AIS_CL_OUTPUT_D.REMARK
is '备注';
comment on column T_AIS_CL_OUTPUT_D.UPLOAD_PERSION
is '上传人';
comment on column T_AIS_CL_OUTPUT_D.UPLOAD_DATE
is '上传时间';
comment on column T_AIS_CL_OUTPUT_D.CREATE_ID
is '创建人';
comment on column T_AIS_CL_OUTPUT_D.CREATE_DATE
is '创建日期';
comment on column T_AIS_CL_OUTPUT_D.UPDATE_ID
is '更新人';
comment on column T_AIS_CL_OUTPUT_D.UPDATE_DATE
is '更新日期';
comment on column T_AIS_CL_OUTPUT_D.MANAGE_DIMENSIONALITY
is '管理维度[10 年
20 季
30月 40
周 50
日
]';
comment on column T_AIS_CL_OUTPUT_D.PLAN_MONTH
is '计划月－取消';
comment on column T_AIS_CL_OUTPUT_D.PLAN_WEEK
is '计划周－取消';
comment on column T_AIS_CL_OUTPUT_D.BEGIN_DATE
is '计划开始日期－取消';
comment on column T_AIS_CL_OUTPUT_D.END_DATE
is '计划结束日期－取消';
comment on column T_AIS_CL_OUTPUT_D.ORD_DIS_TYPE
is '计划类型[10 订货
20 配送
]';
comment on column T_AIS_CL_OUTPUT_D.UNITS
is '单位（EA为片，KG重量）';
comment on column T_AIS_CL_OUTPUT_D.COST_WEIGHT
is '单耗';
-- Create/Recreate primary, unique and foreign key constraints
alter table T_AIS_CL_OUTPUT_D
add constraint PK_T_AIS_CL_OUTPUT_D_ID primary key (PLAN_MGR_ID, PLAN_MGR_SUBID)
disable;
Powered by Zoundry
