/* ================================================================================ 档案代号: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; |