/*
================================================================================
档案代号:cxc_file
档案名称:库存出库明细资料档
档案目的:储存出库单冲销入库明细资料
上游档案:
下游档案:
============.========================.==========================================
*/
create table cxc_file
(
cxc01       varchar2(40) NOT NULL,   /*料件编号                               */
cxc02       number(5) NOT NULL,      /*年度                                   */
cxc03       number(5) NOT NULL,      /*期别                                   */
cxc04       varchar2(16) NOT NULL,   /*出库单号                               */
cxc05       number(5) NOT NULL,      /*项次                                   */
cxc06       varchar2(16) NOT NULL,   /*冲销入库单号                           */
cxc07       number(5) NOT NULL,      /*项次                                   */
cxc08       number(15,3),            /*冲销数量                               */
cxc09       number(20,6),            /*冲销金额                               */
cxc091      number(20,6),            /*冲销金额-材料                          */
cxc092      number(20,6),            /*冲销金额-人工                          */
cxc093      number(20,6),            /*冲销金额-制费                          */
cxc094      number(20,6),            /*冲销金额-加工                          */
cxc095      number(20,6),            /*冲销金额-其他                          */
cxc10       number(20,6),            /*单价                                   */
cxc11       number(5),               /*顺序                                   */
                                     /*此栏位只用于后续报表呈现先进先出的顺序 */
cxc12       varchar2(1),             /*No Use                                 */
cxc010      varchar2(1) DEFAULT '' NOT NULL, /*成本计算类别*/
cxc011      varchar2(40) DEFAULT '' NOT NULL, /*类别代号(批次号/专案号/利润 */
cxc096      number(20,6) DEFAULT '0',/*冲销金额-制费三                        */
cxc097      number(20,6) DEFAULT '0',/*冲销金额-制费四                        */
cxc098      number(20,6) DEFAULT '0' /*冲销金额-制费五                        */
);

create        index cxc_02 on cxc_file (cxc01,cxc06,cxc07);
create        index cxc_03 on cxc_file (cxc01,cxc04,cxc05);
create unique index cxc_pk on cxc_file (cxc01,cxc010,cxc011,cxc02,cxc03,cxc04,cxc05,cxc06,cxc07);
alter table cxc_file add  constraint cxc_pk primary key  
(cxc01,cxc010,cxc011,cxc02,cxc03,cxc04,cxc05,cxc06,cxc07) enable validate;
grant select on cxc_file to public;
grant index on cxc_file to public;
grant update on cxc_file to public;
grant delete on cxc_file to public;
grant insert on cxc_file to public;