/*
================================================================================
档案代号:adw_file
档案名称:流通配销系统参数档--仓退单
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table adw_file
(
adw01       varchar2(10) NOT NULL,   /*拨入营运中心                           */
adw02       varchar2(5),             /*单别                                   */
adw03       varchar2(10),            /*部门                                   */
adw04       varchar2(10),            /*人员                                   */
adw05       varchar2(4),             /*理由码                                 */
adw06       varchar2(1),             /*No                                     */
adw07       varchar2(1),             /*No                                     */
adw08       varchar2(1),             /*No                                     */
adw09       varchar2(1),             /*No                                     */
adwacti     varchar2(1),             /*资料有效码                             */
adwuser     varchar2(10),            /*资料所有者                             */
adwgrup     varchar2(10),            /*资料所有部门                           */
adwmodu     varchar2(10),            /*资料修改者                             */
adwdate     date                     /*最近修改日                             */
);

create unique index adw_pk on adw_file (adw01);
alter table adw_file add  constraint adw_pk primary key  (adw01) enable validate;
grant select on adw_file to public;
grant index on adw_file to public;
grant update on adw_file to public;
grant delete on adw_file to public;
grant insert on adw_file to public;