/*
================================================================================
档案代号:adu_file
档案名称:流通配销系统参数档-采购单
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table adu_file
(
adu01       varchar2(10) NOT NULL,   /*拨出营运中心                           */
adu02       varchar2(5),             /*采购单别                               */
adu021      varchar2(5),             /*收货单别                               */
adu03       varchar2(10),            /*付款条件                               */
adu04       varchar2(6),             /*价格条件                               */
adu05       varchar2(10),            /*送货地址                               */
adu06       varchar2(10),            /*采购员                                 */
adu07       varchar2(10),            /*采购部门                               */
adu08       varchar2(4),             /*税别                                   */
adu09       number(9,4),             /*税率                                   */
adu10       varchar2(4),             /*币别                                   */
adu11       number(20,10),           /*汇率                                   */
adu12       varchar2(1),             /*No                                     */
adu13       varchar2(1),             /*No                                     */
adu14       varchar2(1),             /*No                                     */
adu15       varchar2(1),             /*No                                     */
aduacti     varchar2(1),             /*资料有效码                             */
aduuser     varchar2(10),            /*资料所有者                             */
adugrup     varchar2(10),            /*资料所有部门                           */
adumodu     varchar2(10),            /*资料修改者                             */
adudate     date                     /*最近修改日                             */
);

create unique index adu_pk on adu_file (adu01);
alter table adu_file add  constraint adu_pk primary key  (adu01) enable validate;
grant select on adu_file to public;
grant index on adu_file to public;
grant update on adu_file to public;
grant delete on adu_file to public;
grant insert on adu_file to public;