/*
================================================================================
档案代号:oas_file
档案名称:多帐期收款条件关联设定档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table oas_file
(
oas01       varchar2(6) NOT NULL,    /*母收款条件                             */
oas02       varchar2(1),             /*类别                                   */
                                     /*1-依比率 2-自定义                      */
oas03       number(5) NOT NULL,      /*项次                                   */
oas04       varchar2(6),             /*子收款条件                             */
oas05       number(9,4),             /*收款比率%                              */
oas06       varchar2(15),            /*No Use                                 */
oas07       varchar2(8),             /*No Use                                 */
oasacti     varchar2(1),             /*资料有效码                             */
oasuser     varchar2(10),            /*资料所有者                             */
oasgrup     varchar2(10),            /*资料所有部门                           */
oasmodu     varchar2(10),            /*资料修改者                             */
oasdate     date                     /*最后修改日期                           */
);

create unique index oas_pk on oas_file (oas01,oas03);
alter table oas_file add  constraint oas_pk primary key  (oas01,oas03) enable validate;
grant select on oas_file to public;
grant index on oas_file to public;
grant update on oas_file to public;
grant delete on oas_file to public;
grant insert on oas_file to public;