/*
================================================================================
档案代号:type_file
档案名称:栏位型态档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table type_file
(
chr1000     varchar2(1000),          /*l_wc, l_buf, l_cmd                     */
chr1        varchar2(1),             /*l_flag, l_choice, g_char               */
num5        number(5),               /*l_i, l_j, l_ac, g_rec_b                */
num20_6     number(20,6),            /*tot, amt                               */
dat         date,                    /*b_date, e_date                         */
chr18       varchar2(18),            /*rowid                                  */
num10       number(10),              /*g_jump                                 */
chr8        varchar2(8),             /*l_time                                 */
chr20       varchar2(20),            /*l_name                                 */
chr21       varchar2(21),            /*l_dbs, g_dbs                           */
num20       number(20),              /*l_btime, l_etime                       */
chr3        varchar2(3),             /*ps_sys 模组名称                        */
num26_10    number(26,10),           /*p_value                                */
chr2        varchar2(2),             /*跳页控制项,排序顺序,etc                */
chr4        varchar2(4),             /*跳页控制项,排序顺序,etc                */
chr5        varchar2(5),             /*跳页控制项,排序顺序,etc                */
chr6        varchar2(6),             /*print,etc                              */
chr50       varchar2(50),            /*print,etc                              */
chr37       varchar2(37),            /*l_str(cl_numfor)                       */
chr9        varchar2(9),
chr12       varchar2(12),
chr30       varchar2(30),
chr14       varchar2(14),
chr7        varchar2(7),
chr10       varchar2(10)             /*g_program,l_desc,l_str,l_prog,pmn16,l_pm*/
);

grant select on type_file to public;
grant index on type_file to public;
grant update on type_file to public;
grant delete on type_file to public;
grant insert on type_file to public;