/* ================================================================================ 档案代号:azd_file 档案名称:签核过程档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table azd_file ( azd01 varchar2(16) NOT NULL, /*单据编号 */ azd02 number(5) NOT NULL, /*单据类别 */ /*单据类别 (与 aze09 同) */ /*1.报价单 2.请购单 3.采购单 4.传票 */ /*5.销货单 6.传票底稿 */ /*7.常用传票(固定金额)8.常用传票(固定比率)*/ /*9.调拨 10.设计变更单 11.应付帐款 */ /*12.付款单 13.销单(内销)出货单 */ /*14.销单(外销)出货单 15.销货折让单 */ /*16.销退单 17.预收货款单 18.复运出口出货*/ /*19.收款冲帐 20.开状单 21.赎单 */ /*22:借项单 23:贷项单 24:呆帐单 */ /*25.订单 26.订单变更 */ azd03 varchar2(10) NOT NULL, /*签核人员代号 */ azd04 date /*签核日期 */ ); create unique index azd_pk on azd_file (azd01,azd02,azd03); alter table azd_file add constraint azd_pk primary key (azd01,azd02,azd03) enable validate; grant select on azd_file to public; grant index on azd_file to public; grant update on azd_file to public; grant delete on azd_file to public; grant insert on azd_file to public; |