INITIALIZE_SYSCODE_CSH_TRANSATION.sql 1.8 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
WHENEVER SQLERROR EXIT FAILURE ROLLBACK;
WHENEVER OSERROR  EXIT FAILURE ROLLBACK;

spool INITIALIZE_SYSCODE_CSH_TRANSACTION.log

set feedback off
set define off

<!--系统代码取值-->

begin
sys_code_pkg.delete_sys_code('CONFIRMED_FLAG');
sys_code_pkg.insert_sys_code('CONFIRMED_FLAG', '单据状态', '单据状态', '单据状态', 'ZHS', '');
sys_code_pkg.insert_sys_code_value('CONFIRMED_FLAG','NEW','未提交','ZHS','');
sys_code_pkg.insert_sys_code_value('CONFIRMED_FLAG','APPROVED','新增确认','ZHS','');
sys_code_pkg.insert_sys_code_value('CONFIRMED_FLAG','REJECTED','新增退回','ZHS','');
17
sys_code_pkg.insert_sys_code_value('CONFIRMED_FLAG','ACCAUDITING','会计新增确认中','ZHS','');
18
sys_code_pkg.insert_sys_code_value('CONFIRMED_FLAG','CANCELLED','已作废','ZHS','');
stone's avatar
stone committed
19
sys_code_pkg.insert_sys_code_value('CONFIRMED_FLAG','DEBTAUDITING','债权新增确认中','ZHS','');
20 21 22 23 24

sys_code_pkg.delete_sys_code('PAID_BYOTHER_FLAG');
sys_code_pkg.insert_sys_code('PAID_BYOTHER_FLAG', '代付', '代付', '代付', 'ZHS', '');
sys_code_pkg.insert_sys_code_value('PAID_BYOTHER_FLAG','T','是','ZHS','');
sys_code_pkg.insert_sys_code_value('PAID_BYOTHER_FLAG','F','否','ZHS','');
25 26 27 28 29 30 31 32

sys_code_pkg.delete_sys_code('WRITE_OFF_FLAG');
sys_code_pkg.insert_sys_code('WRITE_OFF_FLAG', '核销状态', '核销状态', '核销状态', 'ZHS', '');
sys_code_pkg.insert_sys_code_value('WRITE_OFF_FLAG','NOT','未核销','ZHS','');
sys_code_pkg.insert_sys_code_value('WRITE_OFF_FLAG','FULL','全部核销','ZHS','');
sys_code_pkg.insert_sys_code_value('WRITE_OFF_FLAG','DEPOSIT','保证金','ZHS','');
sys_code_pkg.insert_sys_code_value('WRITE_OFF_FLAG','ADVRECEIVED','预收款','ZHS','');
sys_code_pkg.insert_sys_code_value('WRITE_OFF_FLAG','DISABLED','不可用','ZHS','');
33 34 35 36 37 38 39
end;
/
commit;
set feedback on
set define on


stone's avatar
stone committed
40

41 42 43
spool off

exit