/*
================================================================================
档案代号:tsj_file
档案名称:转拨申请单/采购单抛转单别设定档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table tsj_file
(
tsj01       varchar2(10) NOT NULL,   /*营运中心编号                           */
tsj02       varchar2(5) NOT NULL,    /*杂发单别                               */
tsj03       varchar2(5),             /*出货单别                               */
tsj04       varchar2(5),             /*采购单别                               */
tsj05       varchar2(10),            /*付款条件                               */
tsj06       varchar2(6),             /*价格条件                               */
tsj07       varchar2(10),            /*送货地点                               */
tsj08       varchar2(10),            /*采购员                                 */
tsj09       varchar2(10),            /*采购部门                               */
tsj10       varchar2(4),             /*税别                                   */
tsj11       number(9,4),             /*税率                                   */
tsj12       varchar2(4),             /*币别                                   */
tsj13       number(20,10),           /*汇率                                   */
tsjacti     varchar2(1)              /*资料有效否                             */
);

create unique index tsj_pk on tsj_file (tsj01);
alter table tsj_file add  constraint tsj_pk primary key  (tsj01) enable validate;
grant select on tsj_file to public;
grant index on tsj_file to public;
grant update on tsj_file to public;
grant delete on tsj_file to public;
grant insert on tsj_file to public;