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