/*
================================================================================
档案代号:tuq_file
档案名称:客户库存异动明细档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table tuq_file
(
tuq01       varchar2(10),            /*客户代号                               */
tuq02       varchar2(40),            /*商品代号                               */
tuq03       varchar2(24),            /*批号                                   */
tuq04       date,                    /*异动日期                               */
tuq05       varchar2(16),            /*原始单据代号                           */
tuq06       varchar2(4),             /*原始单位                               */
tuq07       number(15,3),            /*原始数量                               */
tuq08       number(20,8),            /*换算率                                 */
tuq09       number(15,3),            /*异动数量                               */
tuq10       varchar2(1),             /*异动区分                               */
tuq11       varchar2(1),             /*库存类别                               */
tuq12       varchar2(10),            /*送货客户                               */
tuq051      number(5)                /*来源单据项次                           */
);

create        index tuq_01 on tuq_file (tuq01,tuq02,tuq03,tuq04,tuq05,tuq051,tuq11,tuq12);
grant select on tuq_file to public;
grant index on tuq_file to public;
grant update on tuq_file to public;
grant delete on tuq_file to public;
grant insert on tuq_file to public;