CREATE TABLE CIS.FISCASH_MLDeclare
(Declare_Id NUMBER,
FirstInput VARCHAR2(25),
FirstInputName VARCHAR2(25),
FirstInputDate DATE,
Declare_Company VARCHAR2(21),
ConCode VARCHAR2(100),
FCashCoin VARCHAR2(11),
FDeclare_Num NUMBER(25,2),
FCashType VARCHAR2(11),
FCashRemark VARCHAR2(100),
DeclareDate VARCHAR2(11),
YearMonth VARCHAR2(8),
NumType VARCHAR2(11),
InvoiceNum VARCHAR2(100),
BusinessManId VARCHAR2(21),
BusinessMan VARCHAR2(21),
Business_Remark VARCHAR2(100),
CashCoin VARCHAR2(11),
Declare_Num NUMBER(25,2),
CashType VARCHAR2(11),
CashRemark VARCHAR2(100),
ChangeType CHAR(1),
UpdaterId VARCHAR2(25),
UpdaterName VARCHAR2(25),
UpdateDate Date,
Confirm_Id VARCHAR2(21),
Confirm_Name VARCHAR2(21),
Confirm_Date DATE,
Confirm_Flag CHAR(1),
Confrim_Remark VARCHAR2(100),
InputFlag CHAR(1),
Declare_State CHAR(1),
Fore_State CHAR(1),
Remark VARCHAR2(100),
PRIMARY KEY(Declare_Id)
)
Create Sequence CIS.FISCASH_MLDeclare_Id start with 1000 increment by 1;
Grant SELECT,ALTER ON CIS.FISCASH_MLDeclare_Id TO cisprg
GRANT SELECT,INSERT,DELETE,UPDATE ON CIS.FISCASH_MLDeclare TO cisprg;
String sql="insert into CIS.FISCASH_MLDeclare(Declare_Id,Declare_Company,CashType,CashCoin,ConCode,Declare_Num,DeclareDate,CashRemark,Business_Remark,UpdaterId,UpdaterName,YearMonth,ChangeType,UpdateDate,InputFlag,Declare_State,FirstInputDate) values(CIS.FISCASH_MLDeclare_Id.nextVal,";