"import groovy.sql.Sql
import java.sql.Timestamp
//jdbc:sqlserver://" + dbHost + ":" + dbPort + ";databaseName=" + dbName + ";";
//MSSQL
sqlmssql =Sql.newInstance('jdbc:sqlserver://192.168.22.66:1433;databaseName=LYTDB00','sa','80485934',
'com.microsoft.sqlserver.jdbc.SQLServerDriver' )
//PostgreSQL
sqlpostgresql =Sql.newInstance('jdbc:postgresql://192.168.22.90/idempiere','adempiere','adempiere','org.postgresql.Driver' )
def isActive='Y'
def H_ID=1000000
def m_created = new Timestamp(System.currentTimeMillis());
def t_start = System.currentTimeMillis()
sqlmssql.eachRow( 'select * from spdt' )
{ println "$it.sd_sfg -- ${it.sd_date} -- ${it.sd_spno} -- ${it.sd_seq} -- ${it.sd_wkord} -- ${it.sd_skno} -- ${it.sd_sknm} -- ${it.sd_pfg} -- ${it.sd_wsno} -- ${it.sd_wsnm} -- ${it.sd_ucost} -- ${it.sd_skqty} -- ${it.sd_qty} -- ${it.sd_bqty} -- ${it.sd_memo} -- ${it.sd_ncost} -- ${it.sd_ufg} -- ${it.sd_ufgnm} -- ${it.sd_rqty} -- ${it.sd_fml1} -- ${it.sd_fml2} -- ${it.sd_hpfg} -- ${it.sd_hwsno} -- " //讓程式在背景執行
sqlpostgresql.execute('INSERT INTO z_spdt(sd_sfg, sd_date, sd_spno, sd_seq, sd_wkord, sd_skno, sd_sknm, sd_pfg, sd_wsno, sd_wsnm, sd_ucost, sd_skqty, sd_qty, sd_bqty, sd_memo, sd_ncost, sd_ufg, sd_ufgnm, sd_rqty, sd_fml1, sd_fml2, sd_hpfg, sd_hwsno) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)',[it.sd_sfg, it.sd_date, it.sd_spno, it.sd_seq, it.sd_wkord, it.sd_skno, it.sd_sknm, it.sd_pfg, it.sd_wsno, it.sd_wsnm, it.sd_ucost, it.sd_skqty, it.sd_qty, it.sd_bqty, it.sd_memo, it.sd_ncost, it.sd_ufg, it.sd_ufgnm, it.sd_rqty, it.sd_fml1, it.sd_fml2, it.sd_hpfg, it.sd_hwsno])}
def t_end = System.currentTimeMillis()
result="執行完成: " + (t_end - t_start)"
2013年10月11日 星期五
groovy_5
"import groovy.sql.Sql
import java.sql.Timestamp
//jdbc:sqlserver://" + dbHost + ":" + dbPort + ";databaseName=" + dbName + ";";
//MSSQL
sqlmssql =Sql.newInstance('jdbc:sqlserver://192.168.22.66:1433;databaseName=LYTDB00','sa','80485934',
'com.microsoft.sqlserver.jdbc.SQLServerDriver' )
//PostgreSQL
sqlpostgresql =Sql.newInstance('jdbc:postgresql://192.168.22.90/idempiere','adempiere','adempiere','org.postgresql.Driver' )
def isActive='Y'
def H_ID=1000000
def m_created = new Timestamp(System.currentTimeMillis());
def t_start = System.currentTimeMillis()
sqlmssql.eachRow( 'select * from sphd' )
{ println "$it.sh_sfg -- ${it.sh_gfg} -- ${it.sh_date} -- ${it.sh_spno} -- ${it.sh_mnno} -- ${it.sh_skno} -- ${it.sh_sknm} -- ${it.sh_afno} -- ${it.sh_dsno} -- ${it.sh_opfg} -- ${it.sh_owsno} -- ${it.sh_owsnm} -- ${it.sh_owkord} -- ${it.sh_pfg} -- ${it.sh_wsno} -- ${it.sh_wsnm} -- ${it.sh_wkord} -- ${it.sh_sskno} -- ${it.sh_ssknm} -- ${it.sh_qty} -- ${it.sh_ufg} -- ${it.sh_rqty} -- ${it.sh_pcost} -- ${it.sh_ecost} -- ${it.sh_wchg} -- ${it.sh_inno} -- ${it.sh_bno} -- ${it.sh_memo} -- ${it.sh_tcost} -- ${it.sh_acost} -- ${it.sh_dtqty} -- ${it.sh_ncost} -- ${it.sh_tfg} -- ${it.sh_psno} -- ${it.sh_dpno} -- ${it.sh_dpnm} -- ${it.sh_tlno} -- ${it.sh_ifg} -- ${it.sh_rate_nm} -- ${it.sh_rate} -- ${it.sh_mcost} -- " //讓程式在背景執行
sqlpostgresql.execute('INSERT INTO z_sphd(sh_sfg, sh_gfg, sh_date, sh_spno, sh_mnno, sh_skno, sh_sknm, sh_afno, sh_dsno, sh_opfg, sh_owsno, sh_owsnm, sh_owkord, sh_pfg, sh_wsno, sh_wsnm, sh_wkord, sh_sskno, sh_ssknm, sh_qty, sh_ufg, sh_rqty, sh_pcost, sh_ecost, sh_wchg, sh_inno, sh_bno, sh_memo, sh_tcost, sh_acost, sh_dtqty, sh_ncost, sh_tfg, sh_psno, sh_dpno, sh_dpnm, sh_tlno, sh_ifg, sh_rate_nm, sh_rate, sh_mcost) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)',[it.sh_sfg, it.sh_gfg, it.sh_date, it.sh_spno, it.sh_mnno, it.sh_skno, it.sh_sknm, it.sh_afno, it.sh_dsno, it.sh_opfg, it.sh_owsno, it.sh_owsnm, it.sh_owkord, it.sh_pfg, it.sh_wsno, it.sh_wsnm, it.sh_wkord, it.sh_sskno, it.sh_ssknm, it.sh_qty, it.sh_ufg, it.sh_rqty, it.sh_pcost, it.sh_ecost, it.sh_wchg, it.sh_inno, it.sh_bno, it.sh_memo, it.sh_tcost, it.sh_acost, it.sh_dtqty, it.sh_ncost, it.sh_tfg, it.sh_psno, it.sh_dpno, it.sh_dpnm, it.sh_tlno, it.sh_ifg, it.sh_rate_nm, it.sh_rate, it.sh_mcost])}
def t_end = System.currentTimeMillis()
result="執行完成: " + (t_end - t_start)"
import java.sql.Timestamp
//jdbc:sqlserver://" + dbHost + ":" + dbPort + ";databaseName=" + dbName + ";";
//MSSQL
sqlmssql =Sql.newInstance('jdbc:sqlserver://192.168.22.66:1433;databaseName=LYTDB00','sa','80485934',
'com.microsoft.sqlserver.jdbc.SQLServerDriver' )
//PostgreSQL
sqlpostgresql =Sql.newInstance('jdbc:postgresql://192.168.22.90/idempiere','adempiere','adempiere','org.postgresql.Driver' )
def isActive='Y'
def H_ID=1000000
def m_created = new Timestamp(System.currentTimeMillis());
def t_start = System.currentTimeMillis()
sqlmssql.eachRow( 'select * from sphd' )
{ println "$it.sh_sfg -- ${it.sh_gfg} -- ${it.sh_date} -- ${it.sh_spno} -- ${it.sh_mnno} -- ${it.sh_skno} -- ${it.sh_sknm} -- ${it.sh_afno} -- ${it.sh_dsno} -- ${it.sh_opfg} -- ${it.sh_owsno} -- ${it.sh_owsnm} -- ${it.sh_owkord} -- ${it.sh_pfg} -- ${it.sh_wsno} -- ${it.sh_wsnm} -- ${it.sh_wkord} -- ${it.sh_sskno} -- ${it.sh_ssknm} -- ${it.sh_qty} -- ${it.sh_ufg} -- ${it.sh_rqty} -- ${it.sh_pcost} -- ${it.sh_ecost} -- ${it.sh_wchg} -- ${it.sh_inno} -- ${it.sh_bno} -- ${it.sh_memo} -- ${it.sh_tcost} -- ${it.sh_acost} -- ${it.sh_dtqty} -- ${it.sh_ncost} -- ${it.sh_tfg} -- ${it.sh_psno} -- ${it.sh_dpno} -- ${it.sh_dpnm} -- ${it.sh_tlno} -- ${it.sh_ifg} -- ${it.sh_rate_nm} -- ${it.sh_rate} -- ${it.sh_mcost} -- " //讓程式在背景執行
sqlpostgresql.execute('INSERT INTO z_sphd(sh_sfg, sh_gfg, sh_date, sh_spno, sh_mnno, sh_skno, sh_sknm, sh_afno, sh_dsno, sh_opfg, sh_owsno, sh_owsnm, sh_owkord, sh_pfg, sh_wsno, sh_wsnm, sh_wkord, sh_sskno, sh_ssknm, sh_qty, sh_ufg, sh_rqty, sh_pcost, sh_ecost, sh_wchg, sh_inno, sh_bno, sh_memo, sh_tcost, sh_acost, sh_dtqty, sh_ncost, sh_tfg, sh_psno, sh_dpno, sh_dpnm, sh_tlno, sh_ifg, sh_rate_nm, sh_rate, sh_mcost) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)',[it.sh_sfg, it.sh_gfg, it.sh_date, it.sh_spno, it.sh_mnno, it.sh_skno, it.sh_sknm, it.sh_afno, it.sh_dsno, it.sh_opfg, it.sh_owsno, it.sh_owsnm, it.sh_owkord, it.sh_pfg, it.sh_wsno, it.sh_wsnm, it.sh_wkord, it.sh_sskno, it.sh_ssknm, it.sh_qty, it.sh_ufg, it.sh_rqty, it.sh_pcost, it.sh_ecost, it.sh_wchg, it.sh_inno, it.sh_bno, it.sh_memo, it.sh_tcost, it.sh_acost, it.sh_dtqty, it.sh_ncost, it.sh_tfg, it.sh_psno, it.sh_dpno, it.sh_dpnm, it.sh_tlno, it.sh_ifg, it.sh_rate_nm, it.sh_rate, it.sh_mcost])}
def t_end = System.currentTimeMillis()
result="執行完成: " + (t_end - t_start)"
groovy_4
"
// A_Tab.setValue("Help", 'abcdefg'.getAt( 3 ))
import org.compiere.util.DB
import java.util.List
def sql = " select name||','||value from m_product where m_product_id=? ";
String r = DB.getSQLValueString(null, sql, [50002] );
// String r = DB.getSQLValueString(null," select name||','||value from m_product where m_product_id=? ",50002);
if (r==null) r = "Can't Find, nothing";
def s = r.tokenize(',;') ;
// 'he,she;it,;they'.tokenize(',;') ;
def dt = Date.parse("E MMM dd H:m:s z yyyy", "Tue Aug 10 16:02:43 PST 2010")
def date = new Date()
def formattedDate = date.format('yyyy-MM-dd')
A_Tab.setValue("Help", s.first()+" , "+s.last() + " , " + dt + " , " + formattedDate )
"
// A_Tab.setValue("Help", 'abcdefg'.getAt( 3 ))
import org.compiere.util.DB
import java.util.List
def sql = " select name||','||value from m_product where m_product_id=? ";
String r = DB.getSQLValueString(null, sql, [50002] );
// String r = DB.getSQLValueString(null," select name||','||value from m_product where m_product_id=? ",50002);
if (r==null) r = "Can't Find, nothing";
def s = r.tokenize(',;') ;
// 'he,she;it,;they'.tokenize(',;') ;
def dt = Date.parse("E MMM dd H:m:s z yyyy", "Tue Aug 10 16:02:43 PST 2010")
def date = new Date()
def formattedDate = date.format('yyyy-MM-dd')
A_Tab.setValue("Help", s.first()+" , "+s.last() + " , " + dt + " , " + formattedDate )
"
groovy_3
"// A_Tab.setValue("Help", 'abcdefg'.getAt( 3 ))
import org.compiere.util.DB
import groovy.sql.Sql
import java.util.List
def sql = " select name||','||value from m_product where m_product_id=? ";
String r = DB.getSQLValueString(null, sql, [50002] );
// String r = DB.getSQLValueString(null," select name||','||value from m_product where m_product_id=? ",50002);
if (r==null) r = "Can't Find, nothing";
def s = r.tokenize(',;') ;
// 'he,she;it,;they'.tokenize(',;') ;
// def dt = Date.parse("E MMM dd H:m:s z yyyy", "Tue Aug 10 16:02:43 PST 2010")
def date = new Date()
def formattedDate = date.format('yyyy-MM-dd')
Date date1 = Date.parse("dd-MM-yyyy","31-12-2010")
String out1 = date.format("MM-dd-yyyy")
Calendar calendar = GregorianCalendar.instance
calendar.set(2010,3,1) // 1st April 2010
def lastDay = calendar.getActualMaximum(GregorianCalendar.DAY_OF_MONTH)
// assert lastDay == 30
// sql=Sql.newInstance('jdbc:sqlserver://127.0.0.1:1433;databaseName=compiere','compiere','compiere',
// 'com.microsoft.sqlserver.jdbc.SQLServerDriver' )
sql=Sql.newInstance('jdbc:postgresql://127.0.0.1:5432/idempiere','adempiere', 'adempiere','org.postgresql.Driver' )
sql.eachRow( 'select * from AD_Table' ) { println "$it.AD_Table_id-- ${it.TableName} --" }
A_Tab.setValue("Help", s.first()+"\n , "+s.last() + "\n , " + formattedDate )
"
import org.compiere.util.DB
import groovy.sql.Sql
import java.util.List
def sql = " select name||','||value from m_product where m_product_id=? ";
String r = DB.getSQLValueString(null, sql, [50002] );
// String r = DB.getSQLValueString(null," select name||','||value from m_product where m_product_id=? ",50002);
if (r==null) r = "Can't Find, nothing";
def s = r.tokenize(',;') ;
// 'he,she;it,;they'.tokenize(',;') ;
// def dt = Date.parse("E MMM dd H:m:s z yyyy", "Tue Aug 10 16:02:43 PST 2010")
def date = new Date()
def formattedDate = date.format('yyyy-MM-dd')
Date date1 = Date.parse("dd-MM-yyyy","31-12-2010")
String out1 = date.format("MM-dd-yyyy")
Calendar calendar = GregorianCalendar.instance
calendar.set(2010,3,1) // 1st April 2010
def lastDay = calendar.getActualMaximum(GregorianCalendar.DAY_OF_MONTH)
// assert lastDay == 30
// sql=Sql.newInstance('jdbc:sqlserver://127.0.0.1:1433;databaseName=compiere','compiere','compiere',
// 'com.microsoft.sqlserver.jdbc.SQLServerDriver' )
sql=Sql.newInstance('jdbc:postgresql://127.0.0.1:5432/idempiere','adempiere', 'adempiere','org.postgresql.Driver' )
sql.eachRow( 'select * from AD_Table' ) { println "$it.AD_Table_id-- ${it.TableName} --" }
A_Tab.setValue("Help", s.first()+"\n , "+s.last() + "\n , " + formattedDate )
"
groovy_2
"// A_Tab.setValue("Help", 'abcdefg'.getAt( 3 ))
import org.compiere.util.DB
import groovy.sql.Sql
import java.util.List
def sql = " select name||','||value from m_product where m_product_id=? ";
String r = DB.getSQLValueString(null, sql, [50002] );
// String r = DB.getSQLValueString(null," select name||','||value from m_product where m_product_id=? ",50002);
if (r==null) r = "Can't Find, nothing";
def s = r.tokenize(',;') ;
// 'he,she;it,;they'.tokenize(',;') ;
// def dt = Date.parse("E MMM dd H:m:s z yyyy", "Tue Aug 10 16:02:43 PST 2010");
def date = new Date()
def formattedDate = date.format('yyyy-MM-dd')
Date date1 = Date.parse("dd-MM-yyyy","31-12-2010")
String out1 = date.format("MM-dd-yyyy")
Calendar calendar = GregorianCalendar.instance
calendar.set(2010,3,1) // 1st April 2010
def lastDay = calendar.getActualMaximum(GregorianCalendar.DAY_OF_MONTH)
// assert lastDay == 30
sql=Sql.newInstance('jdbc:sqlserver://127.0.0.1:1433;databaseName=compiere','compiere','compiere', 'com.microsoft.sqlserver.jdbc.SQLServerDriver' )
// sql=Sql.newInstance("jdbc:postgresql://127.0.0.1:5432/tg1004","adempiere", "adempiere","org.postgresql.Driver" )
sql.eachRow( 'select * from compiere.AD_Table' ) { println "$it.AD_Table_id-- ${it.TableName} --" }
A_Tab.setValue("Help", s.first()+" , "+s.last() + " , " + formattedDate )
"
import org.compiere.util.DB
import groovy.sql.Sql
import java.util.List
def sql = " select name||','||value from m_product where m_product_id=? ";
String r = DB.getSQLValueString(null, sql, [50002] );
// String r = DB.getSQLValueString(null," select name||','||value from m_product where m_product_id=? ",50002);
if (r==null) r = "Can't Find, nothing";
def s = r.tokenize(',;') ;
// 'he,she;it,;they'.tokenize(',;') ;
// def dt = Date.parse("E MMM dd H:m:s z yyyy", "Tue Aug 10 16:02:43 PST 2010");
def date = new Date()
def formattedDate = date.format('yyyy-MM-dd')
Date date1 = Date.parse("dd-MM-yyyy","31-12-2010")
String out1 = date.format("MM-dd-yyyy")
Calendar calendar = GregorianCalendar.instance
calendar.set(2010,3,1) // 1st April 2010
def lastDay = calendar.getActualMaximum(GregorianCalendar.DAY_OF_MONTH)
// assert lastDay == 30
sql=Sql.newInstance('jdbc:sqlserver://127.0.0.1:1433;databaseName=compiere','compiere','compiere', 'com.microsoft.sqlserver.jdbc.SQLServerDriver' )
// sql=Sql.newInstance("jdbc:postgresql://127.0.0.1:5432/tg1004","adempiere", "adempiere","org.postgresql.Driver" )
sql.eachRow( 'select * from compiere.AD_Table' ) { println "$it.AD_Table_id-- ${it.TableName} --" }
A_Tab.setValue("Help", s.first()+" , "+s.last() + " , " + formattedDate )
"
groovy1
" import org.compiere.util.DB
import groovy.sql.Sql
import org.compiere.model.GridTab
int id = ((Integer)A_Tab.getValue("M_Requisition_ID")).intValue();
// def sql = " select name from m_product where m_product_id=? ";
// String r = DB.getSQLValueString(null, sql, [50002] );
// sql=Sql.newInstance('jdbc:sqlserver://127.0.0.1:1433;databaseName=compiere','compiere','compiere',
// 'com.microsoft.sqlserver.jdbc.SQLServerDriver' )
def str = "xxxxx---xxxxx";
sql=Sql.newInstance('jdbc:postgresql://127.0.0.1:5432/tg0924','adempiere', 'adempiere','org.postgresql.Driver' )
//sql.eachRow(
// 'select p.name from adempiere.m_requisitionline l inner join adempiere.m_product p on p.m_product _id=l.m_product _id where _requisition_id=' + id )
//{ str = str +"$it.name "+"\n" }
GridTab m_tabParent = A_Tab.getParentTab();
m_tabParent .setValue("Help", str )
m_tabParent.dataRefreshAll();
return """
import groovy.sql.Sql
import org.compiere.model.GridTab
int id = ((Integer)A_Tab.getValue("M_Requisition_ID")).intValue();
// def sql = " select name from m_product where m_product_id=? ";
// String r = DB.getSQLValueString(null, sql, [50002] );
// sql=Sql.newInstance('jdbc:sqlserver://127.0.0.1:1433;databaseName=compiere','compiere','compiere',
// 'com.microsoft.sqlserver.jdbc.SQLServerDriver' )
def str = "xxxxx---xxxxx";
sql=Sql.newInstance('jdbc:postgresql://127.0.0.1:5432/tg0924','adempiere', 'adempiere','org.postgresql.Driver' )
//sql.eachRow(
// 'select p.name from adempiere.m_requisitionline l inner join adempiere.m_product p on p.m_product _id=l.m_product _id where _requisition_id=' + id )
//{ str = str +"$it.name "+"\n" }
GridTab m_tabParent = A_Tab.getParentTab();
m_tabParent .setValue("Help", str )
m_tabParent.dataRefreshAll();
return """
2013年9月13日 星期五
把 WF ERP 轉入iDempiere 系統 CREATE TABLE DS_MC
--DROP TABLE DS_MC
CREATE TABLE DS_MC(
MC001 varchar(40), --主件品號 C.NChar 40 主件品號 //941226 S00-9412072 C20=>C40 1.通用 1.一般
MC002 varchar(06), --單位 V.NVarchar 6 單位 //981125 S07-971110003 C4->C6 1.通用 1.一般
MC003 varchar(06), --小單位 V.NVarchar 6 小單位 //981125 S07-971110003 C4->C6 1.通用 1.一般
MC004 numeric(16), --標準批量 N.Numeric 16 標準批量 //950808 S00-9508031 N11.3->N16.3 1.通用 1.一般
MC005 varchar(04), --製令單別 V.NVarchar 4.0 製令單別 1.通用 1.一般
MC006 varchar(04), --變更單別 V.NVarchar 4 變更單別 1.通用 1.一般
MC007 varchar(11), --變更單號 V.NVarchar 11 變更單號 1.通用 1.一般
MC008 varchar(04), --變更序號 V.NVarchar 4 變更序號 1.通用 1.一般
MC009 varchar(04), --版次 V.NVarchar 4 版次 1.通用 1.一般
MC010 varchar(255), --備註 V.NVarchar 255 備註 1.通用 1.一般
MC016 varchar(01), --確認碼 V.NVarchar 1 Y/N[DEF:'N'] //951011 S04-9504017 GP1.0 ADD 1.通用 1.一般
MC017 varchar(08), --確認日期 V.NVarchar 8 確認日期[FORMATE:YMD] //951011 S04-9504017 GP1.0 ADD YMD 1.通用 1.一般
MC018 varchar(10), --確認者 V.NVarchar 10 確認者 //951011 S04-9504017 GP1.0 ADD 1.通用 1.一般
MC019 varchar(01), --簽核狀態碼 V.NVarchar 1 0.待處理、1.簽核中、2.退件、3.已核准、4.取消確認中、5.作廢中、6.取消作廢中、N.不執行電子簽核[DEF:"N"] //951011 S04-9504017 GP1.0 ADD 1.通用 1.一般
MC020 numeric(01), --列印次數 N.Numeric 1 列印次數[DEF:0] //951011 S04-9504017 GP1.0 ADD 1.通用 1.一般
MC021 numeric(01) --傳送次數 N.Numeric 1 傳送次數[DEF:0] //951011 S04-9504017 GP1.0 ADD 1.通用 1.一般
)
CREATE TABLE DS_MC(
MC001 varchar(40), --主件品號 C.NChar 40 主件品號 //941226 S00-9412072 C20=>C40 1.通用 1.一般
MC002 varchar(06), --單位 V.NVarchar 6 單位 //981125 S07-971110003 C4->C6 1.通用 1.一般
MC003 varchar(06), --小單位 V.NVarchar 6 小單位 //981125 S07-971110003 C4->C6 1.通用 1.一般
MC004 numeric(16), --標準批量 N.Numeric 16 標準批量 //950808 S00-9508031 N11.3->N16.3 1.通用 1.一般
MC005 varchar(04), --製令單別 V.NVarchar 4.0 製令單別 1.通用 1.一般
MC006 varchar(04), --變更單別 V.NVarchar 4 變更單別 1.通用 1.一般
MC007 varchar(11), --變更單號 V.NVarchar 11 變更單號 1.通用 1.一般
MC008 varchar(04), --變更序號 V.NVarchar 4 變更序號 1.通用 1.一般
MC009 varchar(04), --版次 V.NVarchar 4 版次 1.通用 1.一般
MC010 varchar(255), --備註 V.NVarchar 255 備註 1.通用 1.一般
MC016 varchar(01), --確認碼 V.NVarchar 1 Y/N[DEF:'N'] //951011 S04-9504017 GP1.0 ADD 1.通用 1.一般
MC017 varchar(08), --確認日期 V.NVarchar 8 確認日期[FORMATE:YMD] //951011 S04-9504017 GP1.0 ADD YMD 1.通用 1.一般
MC018 varchar(10), --確認者 V.NVarchar 10 確認者 //951011 S04-9504017 GP1.0 ADD 1.通用 1.一般
MC019 varchar(01), --簽核狀態碼 V.NVarchar 1 0.待處理、1.簽核中、2.退件、3.已核准、4.取消確認中、5.作廢中、6.取消作廢中、N.不執行電子簽核[DEF:"N"] //951011 S04-9504017 GP1.0 ADD 1.通用 1.一般
MC020 numeric(01), --列印次數 N.Numeric 1 列印次數[DEF:0] //951011 S04-9504017 GP1.0 ADD 1.通用 1.一般
MC021 numeric(01) --傳送次數 N.Numeric 1 傳送次數[DEF:0] //951011 S04-9504017 GP1.0 ADD 1.通用 1.一般
)
訂閱：
文章 (Atom)