/*
================================================================================
档案代号:tsl_file
档案名称:集团转拨申请单单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table tsl_file
(
tsl01       varchar2(16) NOT NULL,   /*调拨单号                               */
                                     /*调拨单号 tsk01                         */
tsl02       number(5) NOT NULL,      /*项次                                   */
tsl03       varchar2(40),            /*料件编号                               */
tsl04       varchar2(4),             /*单位                                   */
tsl05       number(20,6),            /*数量                                   */
tsl06       number(20,6),            /*回报数量                               */
tsl07       varchar2(4),             /*单位一                                 */
tsl08       number(20,8),            /*单位一转换率                           */
tsl09       number(15,3),            /*单位一数量                             */
tsl10       varchar2(4),             /*单位二                                 */
tsl11       number(20,8),            /*单位二转换率                           */
tsl12       number(15,3)             /*单位二数量                             */
);

create unique index tsl_pk on tsl_file (tsl01,tsl02);
alter table tsl_file add  constraint tsl_pk primary key  (tsl01,tsl02) enable validate;
grant select on tsl_file to public;
grant index on tsl_file to public;
grant update on tsl_file to public;
grant delete on tsl_file to public;
grant insert on tsl_file to public;