/* ================================================================================ 档案代号:adv_file 档案名称:流通配销系统参数档-收货单 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table adv_file ( adv01 varchar2(10) NOT NULL, /*拨入营运中心 */ adv02 varchar2(5), /*出货单别 */ adv03 varchar2(10), /*销售分类 */ adv04 varchar2(10), /*业务员 */ adv05 varchar2(10), /*出货部门 */ adv06 varchar2(4), /*税别 */ adv07 number(9,4), /*税率 */ adv08 varchar2(1), /*联数 */ adv09 varchar2(1), /*含税否 */ adv10 varchar2(4), /*币别 */ adv11 number(20,10), /*汇率 */ adv12 varchar2(1), /*发票别 */ adv13 varchar2(10), /*科目别 */ adv14 varchar2(1), /*No */ adv15 varchar2(1), /*No */ advacti varchar2(1), /*资料有效码 */ advuser varchar2(10), /*资料所有者 */ advgrup varchar2(10), /*资料所有部门 */ advmodu varchar2(10), /*资料修改者 */ advdate date /*最近修改日 */ ); create unique index adv_pk on adv_file (adv01); alter table adv_file add constraint adv_pk primary key (adv01) enable validate; grant select on adv_file to public; grant index on adv_file to public; grant update on adv_file to public; grant delete on adv_file to public; grant insert on adv_file to public; |