/*
================================================================================
档案代号:npc_file
档案名称:银行实际对帐记录档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table npc_file
(
npc01       varchar2(11),            /*银行编号                               */
npc02       date,                    /*异动日期                               */
npc021      varchar2(5),             /*异动时间                               */
npc03       varchar2(80),            /*交易摘要                               */
npc04       varchar2(1),             /*收支别                                 */
                                     /*收支别 1:收 2:支                       */
npc05       number(20,6),            /*金额                                   */
                                     /*金额                 02/11/26 alter    */
npc06       varchar2(15),            /*票据号码                               */
npc07       varchar2(1),             /*对帐码                                 */
                                     /*对帐码1:已入帐2:公司未入帐D:删除       */
npc08       number(10)               /*更新来源                               */
                                     /*更新来源  nme00                        */
);

create        index npc_01 on npc_file (npc01,npc02,npc06);
grant select on npc_file to public;
grant index on npc_file to public;
grant update on npc_file to public;
grant delete on npc_file to public;
grant insert on npc_file to public;