/*
================================================================================
档案代号:npk_file
档案名称:银行存款异动记录单身档(转帐)
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table npk_file
(
npk00 varchar2(16) NOT NULL, /*收支单号 */
npk01 number(5) NOT NULL, /*收支项次 */
npk02 varchar2(2), /*出帐异动码/入帐异动码 */
npk03 varchar2(1), /*异动别 */
/*异动别: 1:入帐,2:出帐,3:借方科目,4:贷方*/
npk04 varchar2(11), /*银行编号 */
npk05 varchar2(4), /*币别 */
npk06 number(20,10), /*汇率 */
npk07 varchar2(24), /*科目编号 */
npk071 varchar2(24), /*对方科目编号 */
/*对方科目编号 (98/07/30) */
npk08 number(20,6), /*原币金额 */
npk09 number(20,6), /*本币金额 */
npk10 varchar2(80), /*摘要 */
npk11 varchar2(1), /*进口编号 */
npk12 varchar2(1), /*No Use */
npk13 varchar2(1), /*No Use */
npk14 varchar2(1), /*No Use */
npk15 varchar2(1), /*No Use */
npk072 varchar2(24), /*科目二 */
npk073 varchar2(24), /*对方科目二 */
npkud01 varchar2(255), /*自订栏位-Textedit */
npkud02 varchar2(40), /*自订栏位-文字 */
npkud03 varchar2(40), /*自订栏位-文字 */
npkud04 varchar2(40), /*自订栏位-文字 */
npkud05 varchar2(40), /*自订栏位-文字 */
npkud06 varchar2(40), /*自订栏位-文字 */
npkud07 number(15,3), /*自订栏位-数值 */
npkud08 number(15,3), /*自订栏位-数值 */
npkud09 number(15,3), /*自订栏位-数值 */
npkud10 number(10), /*自订栏位-整数 */
npkud11 number(10), /*自订栏位-整数 */
npkud12 number(10), /*自订栏位-整数 */
npkud13 date, /*自订栏位-日期 */
npkud14 date, /*自订栏位-日期 */
npkud15 date /*自订栏位-日期 */
);
create index npk_04 on npk_file (npk04);
create unique index npk_pk on npk_file (npk00,npk01);
alter table npk_file add constraint npk_pk primary key (npk00,npk01) enable validate;
grant select on npk_file to public;
grant index on npk_file to public;
grant update on npk_file to public;
grant delete on npk_file to public;
grant insert on npk_file to public;
|