新增文章

文章标题 分类 C# 云星空 K3 BOS K3 功能 用友 Oracle python SQL MySql PHP HTML script windows Access 影视后期 财务 服务 生活 内容 FVisForBillType 0 1 31 63 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -- 单据表体：显示字段 31/63 UPDATE ICTemplateEntry SET FVisForBillType = 31 WHERE FID = 'S01' AND FFieldName = 'FAuxTaxPrice' -- FAuxTaxPrice 含税单价 UPDATE ICTemplateEntry SET FVisForBillType = 31 WHERE FID = 'S01' AND FFieldName = 'FAllStdAmount' -- FAllStdAmount 价税合计(本位币) UPDATE ICTemplateEntry SET FVisForBillType = 31 WHERE FID = 'S01' AND FFieldName = 'FTaxRate' -- FTaxRate 折扣率(%) UPDATE ICTemplateEntry SET FVisForBillType = 31 WHERE FID = 'S01' AND FFieldName = 'FUniDiscount' -- FUniDiscount 单位折扣额 UPDATE ICTemplateEntry SET FVisForBillType = 31 WHERE FID = 'S01' AND FFieldName = 'FTaxAmount' -- FTaxAmount 折扣额 UPDATE ICTemplateEntry SET FVisForBillType = 31 WHERE FID = 'S01' AND FFieldName = 'FAllAmount' -- FAllAmount 价税合计 UPDATE ICTemplateEntry SET FVisForBillType = 31 WHERE FID = 'S01' AND FFieldName = 'FAuxPriceDiscount' -- FAuxPriceDiscount 实际含税单价 UPDATE ICTemplateEntry SET FVisForBillType = 63 WHERE FID = 'S01' AND FFieldName = 'FCess' -- FCess 税率(%) UPDATE ICTemplateEntry SET FVisForBillType = 31 WHERE FID = 'S01' AND FFieldName = 'FTaxAmt' -- FTaxAmt 销项税额 UPDATE ICTemplateEntry SET FVisForBillType = 31 WHERE FID = 'S01' AND FFieldName = 'Fauxprice' -- Fauxprice 单价 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -- 单据表体：隐藏字段 UPDATE ICTemplateEntry SET FVisForBillType = 0 WHERE FID = 'S01' AND FFieldName = 'FAuxTaxPrice' -- FAuxTaxPrice 含税单价 UPDATE ICTemplateEntry SET FVisForBillType = 0 WHERE FID = 'S01' AND FFieldName = 'FAllStdAmount' -- FAllStdAmount 价税合计(本位币) UPDATE ICTemplateEntry SET FVisForBillType = 0 WHERE FID = 'S01' AND FFieldName = 'FTaxRate' -- FTaxRate 折扣率(%) UPDATE ICTemplateEntry SET FVisForBillType = 0 WHERE FID = 'S01' AND FFieldName = 'FUniDiscount' -- FUniDiscount 单位折扣额 UPDATE ICTemplateEntry SET FVisForBillType = 0 WHERE FID = 'S01' AND FFieldName = 'FTaxAmount' -- FTaxAmount 折扣额 UPDATE ICTemplateEntry SET FVisForBillType = 0 WHERE FID = 'S01' AND FFieldName = 'FAllAmount' -- FAllAmount 价税合计 UPDATE ICTemplateEntry SET FVisForBillType = 0 WHERE FID = 'S01' AND FFieldName = 'FAuxPriceDiscount' -- FAuxPriceDiscount 实际含税单价 UPDATE ICTemplateEntry SET FVisForBillType = 0 WHERE FID = 'S01' AND FFieldName = 'FCess' -- FCess 税率(%) UPDATE ICTemplateEntry SET FVisForBillType = 0 WHERE FID = 'S01' AND FFieldName = 'FTaxAmt' -- FTaxAmt 销项税额 UPDATE ICTemplateEntry SET FVisForBillType = 0 WHERE FID = 'S01' AND FFieldName = 'Fauxprice' -- Fauxprice 单价 返回 保存