/*
================================================================================
档案代号:tsh_file
档案名称:集团转拨申请单单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table tsh_file
(
tsh01       varchar2(16) NOT NULL,   /*调拨单号                               */
                                     /*调拨单号 tse01                         */
tsh02       number(5) NOT NULL,      /*项次                                   */
tsh03       varchar2(40),            /*料件编号                               */
tsh04       varchar2(4),             /*单位                                   */
tsh05       number(20,6),            /*数量                                   */
tsh06       number(20,6),            /*核准数量                               */
tsh07       varchar2(4),             /*单位一                                 */
tsh08       number(20,8),            /*单位一转换率                           */
tsh09       number(15,3),            /*单位一数量                             */
tsh10       varchar2(4),             /*单位二                                 */
tsh11       number(20,8),            /*单位二转换率                           */
tsh12       number(15,3),            /*单位二数量                             */
tsh13       varchar2(10)             /*原因码                                 */
);

create unique index tsh_pk on tsh_file (tsh01,tsh02);
alter table tsh_file add  constraint tsh_pk primary key  (tsh01,tsh02) enable validate;
grant select on tsh_file to public;
grant index on tsh_file to public;
grant update on tsh_file to public;
grant delete on tsh_file to public;
grant insert on tsh_file to public;