/*
================================================================================
档案代号:oot_file
档案名称:应收/销退帐款档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table oot_file
(
oot01       varchar2(16) NOT NULL,   /*销退帐款编号                           */
                                     /*帐款类别 21.退货折让待抵               */
oot02       varchar2(10),            /*帐款客户编号                           */
                                     /*帐款客户编号  occ01                    */
oot03       varchar2(16),            /*应收帐款编号                           */
oot04       number(20,6) NOT NULL,   /*原币未税金额                           */
oot04x      number(20,6) NOT NULL,   /*原币税额                               */
oot04t      number(20,6) NOT NULL,   /*原币含税金额                           */
oot05       number(20,6) NOT NULL,   /*本币未税金额                           */
oot05x      number(20,6) NOT NULL,   /*本币税额                               */
oot05t      number(20,6) NOT NULL,   /*本币含税金额                           */
oot06       varchar2(4)              /*币别                                   */
);

create        index oot_02 on oot_file (oot03);
create unique index oot_pk on oot_file (oot01);
alter table oot_file add  constraint oot_pk primary key  (oot01) enable validate;
grant select on oot_file to public;
grant index on oot_file to public;
grant update on oot_file to public;
grant delete on oot_file to public;
grant insert on oot_file to public;