/*
================================================================================
档案代号:adx_file
档案名称:流通配销系统参数档-销退单
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table adx_file
(
adx01       varchar2(10) NOT NULL,   /*拨出营运中心                           */
adx02       varchar2(5),             /*单别                                   */
adx03       varchar2(1),             /*销退处理方式                           */
adx04       varchar2(1),             /*No                                     */
adx05       varchar2(1),             /*No                                     */
adx06       varchar2(1),             /*No                                     */
adx07       varchar2(1),             /*No                                     */
adxacti     varchar2(1),             /*资料有效码                             */
adxuser     varchar2(10),            /*资料所有者                             */
adxgrup     varchar2(10),            /*资料所有部门                           */
adxmodu     varchar2(10),            /*资料修改者                             */
adxdate     date                     /*最近修改日                             */
);

create unique index adx_pk on adx_file (adx01);
alter table adx_file add  constraint adx_pk primary key  (adx01) enable validate;
grant select on adx_file to public;
grant index on adx_file to public;
grant update on adx_file to public;
grant delete on adx_file to public;
grant insert on adx_file to public;