[15009-导入委外申请]
[13002-导入业务订单]

//sheet
Sheet=sheet1

//正式内容起启行
BEGINROWS =6

//客户
VCL1Field=CLIENTID
VCL1Content=SELECT CLIENTID FROM DATA_CLIENT WHERE SHORTNAME = [2,B]

//要求送货
VCL2Field=TRANSITDATE
VCL2Content=[2,D]
//客订单号
VCL3Field=PONUMBER
VCL3Content=[2,F]
//币别
VCL4Field=CURRENCYID
VCL4Content=SELECT CURRENCYID FROM DATA_CURRENCY WHERE NAME = [3,B]
//汇率
VCL5Field=EXCHANGERATE
VCL5Content=[3,D]
//接单类型
VCL6Field=BILLCONTENTID
VCL6Content=SELECT BILLCONTENTID FROM DATA_BILLCONTENT WHERE NAME = [3,F]
//业务员
VCL7Field=OPERATIONERNAME
VCL7Content=[3,H]
//税别
VCL8Field=TAXID
VCL8Content=SELECT TAXID FROM DATA_TAX WHERE NAME = [4,B]

//表格数据[A]是列

//模具编号
COL1Field=FACTORYNUMBER
COL1Content=[A]
//客户模号
COL2Field=CUSTOMERPRODUCENUMBER
COL2Content=[B]
//客户图号
COL3Field=CUSTOMDRAWNUMBER
COL3Content=[C]
//产品名称
COL4Field=MACHINEGOODSNAME
COL4Content=[D]
//单位
COL5Field=SALEUNITNAME
COL5Content=[E]
//产品尺寸
COL6Field=PRODUCESPEC
COL6Content=[F]
//材质
COL7Field=MATERIALREQUEST
COL7Content=[G]
//数量
COL8Field=GOODSCOUNT
COL8Content=[H]
//未税单价
COL9Field=GOODSPRICE
COL9Content=[I]

[16017-导入物品调整]

//sheet
Sheet=sheet1

//正式内容起启行
BEGINROWS =5


VCL1Field=OPERATIONERNAME
VCL1Content=[2,B]

//表格数据[A]是列

//WAREHOUSEID 仓库ID
COL1Field=WAREHOUSEID
COL1Content=SELECT WAREHOUSEID FROM DATA_WAREHOUSE WHERE NAME=[A]

//WAREHOUSENAME仓库名称
COL2Field=WAREHOUSENAME
COL2Content=[A]

//GOODSID物品ID
COL3Field=GOODSID
COL3Content=SELECT GOODSID FROM DATA_GOODS WHERE GOODSCODE=[B]

//GOODSCODE物品编号
COL4Field=GOODSCODE
COL4Content=[B]

//GOODSKIND类别
COL5Field=GOODSKIND
COL5Content=SELECT DATA_GOODSKIND.NAME FROM DATA_GOODS INNER JOIN DATA_GOODSKIND ON (DATA_GOODSKIND.GOODSKINDID = DATA_GOODS.GOODSKINDID) WHERE GOODSCODE=[B]

//GOODSNAME物品名称
COL6Field=GOODSNAME
COL6Content=SELECT GOODSNAME FROM DATA_GOODS WHERE GOODSCODE=[B]

//GOODSSPEC规格
COL7Field=GOODSSPEC
COL7Content=SELECT GOODSSPEC FROM DATA_GOODS WHERE GOODSCODE=[B]

//GOODSPRICE平均单价
COL8Field=GOODSPRICE
COL8Content=SELECT AVERAGEPRICE FROM STORE_CURRSTORE WHERE WAREHOUSEID = (SELECT WAREHOUSEID FROM DATA_WAREHOUSE WHERE NAME=[A]) AND GOODSID = (SELECT GOODSID FROM DATA_GOODS WHERE GOODSCODE=[B])

//MINSAFECOUNT最低安全存量
COL9Field=MINSAFECOUNT
COL9Content=SELECT MINSAFECOUNT FROM STORE_CURRSTORE WHERE WAREHOUSEID = (SELECT WAREHOUSEID FROM DATA_WAREHOUSE WHERE NAME=[A]) AND GOODSID = (SELECT GOODSID FROM DATA_GOODS WHERE GOODSCODE=[B])

//MAXSAFECOUNT最高安全存量
COL10Field=MAXSAFECOUNT
COL10Content=SELECT MAXSAFECOUNT FROM STORE_CURRSTORE WHERE WAREHOUSEID = (SELECT WAREHOUSEID FROM DATA_WAREHOUSE WHERE NAME=[A]) AND GOODSID = (SELECT GOODSID FROM DATA_GOODS WHERE GOODSCODE=[B])

//ADJGOODSPRICE调整单价 先将系统中原有单价导入
COL17Field=ADJGOODSPRICE
COL17Content=SELECT AVERAGEPRICE FROM STORE_CURRSTORE WHERE WAREHOUSEID = (SELECT WAREHOUSEID FROM DATA_WAREHOUSE WHERE NAME=[A]) AND GOODSID = (SELECT GOODSID FROM DATA_GOODS WHERE GOODSCODE=[B])

//ADJGOODSPRICE调整单价 导入Excel中值
COL18Field=ADJGOODSPRICE
COL18Content=[C]

//ADJMINCOUNT调整最低安全量
COL19Field=ADJMINCOUNT
COL19Content=SELECT MINSAFECOUNT FROM STORE_CURRSTORE WHERE WAREHOUSEID = (SELECT WAREHOUSEID FROM DATA_WAREHOUSE WHERE NAME=[A]) AND GOODSID = (SELECT GOODSID FROM DATA_GOODS WHERE GOODSCODE=[B])

//ADJMINCOUNT调整最低安全量 导入Excel中值
COL20Field=ADJMINCOUNT
COL20Content=[D]

//ADJMAXCOUNT调整最高安全存量
COL21Field=ADJMAXCOUNT
COL21Content=SELECT MAXSAFECOUNT FROM STORE_CURRSTORE WHERE WAREHOUSEID = (SELECT WAREHOUSEID FROM DATA_WAREHOUSE WHERE NAME=[A]) AND GOODSID = (SELECT GOODSID FROM DATA_GOODS WHERE GOODSCODE=[B])

//ADJMAXCOUNT调整最高安全存量 导入Excel中值
COL22Field=ADJMAXCOUNT
COL22Content=[E]