/* ================================================================================ 档案代号:oan_file 档案名称:多角贸易抛转单别设定档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table oan_file ( oan01 varchar2(5) NOT NULL, /*出货单别 */ oan02 varchar2(5), /*收货单别 */ oan03 varchar2(5), /*入库单别 */ oan04 varchar2(5), /*AR单别 */ /*AR单别 No.8084 */ oan05 varchar2(5) /*AP单别 */ /*AP单别 No.8084 */ ); create unique index oan_pk on oan_file (oan01); alter table oan_file add constraint oan_pk primary key (oan01) enable validate; grant select on oan_file to public; grant index on oan_file to public; grant update on oan_file to public; grant delete on oan_file to public; grant insert on oan_file to public; |