/* ================================================================================ 档案代号: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; |