个人博客 用于记载日常收集的一些技术文章 ...

用友 : Oracle使用备份创建数据库 用友 : Oracle使用备份创建数据库 -- 创建表空间
create tablespace GYSY datafile 'D:\Oracle11g\oradata\orcl\GYSY.dbf' size 10240m autoextend on next 50m maxsize 15360M;

-- 创建零食表空间
create temporary tablespace GYSY_TEMP tempfile 'D:\Oracle11g\oradata\orcl\GYSY_temp.dbf' size 50m autoextend on next 50m maxsize 15360M;

-- 创建用户并制定默认表空间和临时表空间
CREATE USER "GYSY" PROFILE "DEFAULT" IDENTIFIED BY "orcl" DEFAULT TABLESPACE "GYSY" TEMPORARY TABLESPACE "GYSY_TEMP" ACCOUNT UNLOCK;

-- 用户分配权限
GRANT CREATE ANY TABLE TO "GYSY";
GRANT UNLIMITED TABLESPACE TO "GYSY";
GRANT "CONNECT" TO "GYSY";
GRANT "RESOURCE" TO "GYSY";
GRANT CREATE ANY VIEW TO "GYSY";
GRANT dba TO "GYSY";

-- 第一次需要创建备份文件目录
create directory impdp_dir as 'D:\Oracle11g\impdata';

-- 用户分配目录权限
grant read,write on directory impdp_dir to "GYSY";

-- 执行导入
impdp GYSY/orcl@orcl table_exists_action=replace directory=impdp_dir dumpfile=SXRQ20200617.DMP logfile=impdp.log remap_tablespace=NNC_DATA01:GYSY,TEMP:GYSY_TEMP remap_schema=SXRQ63:GYSY

-- 如果数据库超过创建时设置的最大内存，修改最大内存
ALTER DATABASE DATAFILE 'D:\Oracle11g\oradata\orcl\GYSY.dbf' AUTOEXTEND ON NEXT 50M MAXSIZE 20480M;

-- 或者添加存储文件
alter tablespace NNC_INDEX01 add datafile 'D:\Oracle11g\oradata\orcl\NNC_INDEX02.DBF' size 1000M autoextend on next 50M maxsize unlimited; 郭少锋 创建 2023-10-03 09:39:30 用友 用友 : 用友文章 用友 : 用友文章 NC Cloud2021.11、2021.05、2020.05低代码开发工具安装包申请渠道
https://nccdev.yonyou.com/article/detail/476


安装包申请渠道：
https://yundoc.yonyou.com/wps_form/form-write/c7PyPfGG/
填写申请单需要登录云文档，云文档的密码是域用户密码+动态口令（友空间） 郭少锋 创建 2023-10-03 09:35:04 用友 SQL : 下载 ssms SQL : 下载 ssms https://learn.microsoft.com/zh-cn/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16
下载 ssms 郭少锋 创建 2023-10-01 22:21:33 SQL K3 功能 : K3 移动审批 K3 功能 : K3 移动审批 K3 WISE 移动审批对接企业微信
https://vip.kingdee.com/article/388377617219119360?productLineId=7&isKnowledge=2

K/3 WISE 13.0及以下版本不支持使用移动云管理平台
http://k3mobile.kingdee.com/lightapp/index.html#/download

K3 移动应用部署
http://k3mobile.kingdee.com/lightapp/index.html#/help 郭少锋 编辑 2023-09-23 13:43:18 创建 2023-09-23 13:33:37 K3 功能 K3 功能 : KIS-Z-1602 单据字段 K3 功能 : KIS-Z-1602 单据字段 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- KIS-Z-1602 单据字段

select * from ICTransactionType
select * from ICTemplate
select * from ICTemplateEntry


select * from ICTemplate where FID = 'A01'
select * from ICTemplateEntry where FID = 'A01'


select FID ,1 FPage ,FCtlIndex,FTabIndex,FFieldName,FCaption ,FIsVisibleForList,FVisForBillType from ICTemplate where FID = 'A01'
union all
select FID ,2 FPage ,FCtlIndex,FCtlOrder,FFieldName,FHeadCaption ,FIsVisibleForList,FVisForBillType from ICTemplateEntry where FID = 'A01'

order by FCaption
郭少锋 编辑 2023-09-22 20:30:35 创建 2023-09-22 20:24:28 K3 功能 K3 功能 : KIS-Z-1602 过滤方案 K3 功能 : KIS-Z-1602 过滤方案 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- KIS-Z-1602 过滤方案

select * from ICSchemeProfile
select * from ICSchemeProfileEntry

delete from ICSchemeProfile
delete from ICSchemeProfileEntry 郭少锋 创建 2023-09-22 20:25:27 K3 功能 K3 功能 : KIS-Z-1602 序时簿字段：添加 行号 K3 功能 : KIS-Z-1602 序时簿字段：添加 行号 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- KIS-Z-1602 序时簿字段：添加 行号

delete from ICChatBillTitle where FTypeID = 58 and FColName = 'FIndex'
insert into ICChatBillTitle (
FInterID ,FTypeID ,FCtlIndex ,FListSort ,FAlign ,FColType ,FColWidth ,FVisible ,FVisForQuest ,FVisForOrder ,FFormatType ,FIsVisibleForTemplate ,FColCaption ,FColCaption_CHT ,FColCaption_EN ,FHeadSecond ,FTableName ,FTableAlias ,FName ,FColName ,FItemClassID ,FReturnDataType ,FCountPriceType ,FAction ,FNeedCount ,FIsPrimary ,FLogicAction ,FStatistical ,FMergeable ,FControl ,FMode ,FControlType ,FPrecisionField ,FEditable ,FFormat ,FColCaptionByShow ,FHeadSecondByShow
) select 6 ,58 ,6 ,1 ,3 ,3 ,500 ,1 ,1 ,1 ,0 ,1 ,'行号$' ,'行号$' ,'行号$' ,'' ,'ICStockBillEntry' ,'u1' ,'FIndex' ,'FIndex' ,-1 ,0 ,0 ,'' ,0 ,0 ,'' ,1 ,0 ,0 ,0 ,5 ,'' ,0 ,'' ,'' ,''
郭少锋 创建 2023-09-22 20:25:12 K3 功能 K3 功能 : KIS-Z-1602 序时簿字段 K3 功能 : KIS-Z-1602 序时簿字段 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- KIS-Z-1602 序时簿字段

select * from ICListTemplate order by FTemplateID,FID
select * from ICChatBillTitle order by FTypeID,FInterID


select * from ICListTemplate
select * from ICChatBillTitle where FTypeID = 58 order by FInterID

select * from ICChatBillTitle where FTypeID = 58 and FColCaption != '$' and FVisible != 0 order by FInterID


select
FInterID ,FTypeID ,FCtlIndex ,FListSort ,FAlign ,FColType ,FColWidth ,FVisible ,FVisForQuest ,FVisForOrder ,FColCaption ,FColCaption_CHT ,FColCaption_EN ,FHeadSecond ,FTableName ,FTableAlias ,FName ,FColName ,FItemClassID ,FReturnDataType ,FCountPriceType ,FAction ,FNeedCount ,FIsPrimary ,FLogicAction ,FStatistical ,FMergeable ,FControl ,FMode ,FControlType ,FPrecisionField ,FEditable ,FFormat ,FFormatType ,FIsVisibleForTemplate ,FColCaptionByShow ,FHeadSecondByShow
from ICChatBillTitle
where FTypeID = 58 and FColCaption like '%行号%' or FColCaption like '%新增列36%'
order by FInterID 郭少锋 创建 2023-09-22 20:24:47 K3 功能 K3 功能 : KIS-Z-1602 库存单据 K3 功能 : KIS-Z-1602 库存单据 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- KIS-Z-1602 库存单据

select * from ICStockBill
select * from ICStockBillEntry


郭少锋 创建 2023-09-22 20:24:09 K3 功能 K3 功能 : 数据表：管家婆普及版Top 13.2 K3 功能 : 数据表：管家婆普及版Top 13.2 select * from btype -- 往来单位
select * from ptype -- 商品信息
select * from atype -- 科目

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 商品信息

select
a1.prec
,a1.leveal
,a1.ptypeid
,a1.ParId

,a2.pusercode Code1 ,a2.pname Name1
,a1.pusercode Code2 ,a1.pname Name2

,a3.Unit1 Unit

from ptype a1
left join ptype a2 on a2.ptypeid = a1.ParId
left join xw_PtypeUnit a3 on a3.PTypeId = a1.ptypeid

where a3.Unit1 != ''


---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

select * from xw_P_PtypePrice
select * from xw_F_VchFlow


select * from Dlyndx


select * from DlySale
select * from DlyBuy

select * from GoodsStocks
select * from T_GoodsStocksGlide
select * from employee
select * from DlyA


select * from atype

select * from T_ReportTree
select * from T_ReportInfo
select * from Stock
select * from Department
select * from city
select * from RefIndustry
select * from Province


select * from xw_PtypeUnit




select * from xw_P_PtypeBPrice
select * from xw_P_PriceOrderM
select * from xw_P_PriceType
select * from xw_P_PriceOrderD
select * from xw_P_PriceFollow

select * from xw_OperUpdateLog
select * from xwc_SysMenu




select * from AreaType
select * from BRtype
select * from PMtype
select * from WGtype
select * from FCtype
select * from GXtype
select * from Wtype
select * from SlType
select * from xjtype
select * from kwtype
select * from pptype
select * from LXTYPE
select * from ZCTYPE
select * from SXTYPE

select * from STYPE
select * from FMTYPE
select * from Ftype

select * from CashRunType
select * from Cash_Atype



select * from C4Type
select * from C3Type
select * from C2Type
select * from C1Type
select * from MTYPE
select * from ZeroType
select * from Vchtype




select * from Pos_Dummy_Ptype
select * from InOutVchType
select * from VchColConfig
select * from Xw_ColorManType
select * from T_Billmonthnumber
select * from MonthProc



select * from BR_ACTIONLOG
select * from LEOHOTKEY


select * from loginuser
select * from vchcon


select * from FixedChangeType
select * from FixedUseOf
select * from FixedType
select * from AdvConfig
select * from sys_update_flag



select * from sysdata
select * from syscon





select * from t_gbl_FieldTypeList
select * from t_gbl_DataTypeList
select * from t_gbl_ActionList


select * from BillPrintSetting
select * from HHLOCKINFO
select * from DitDefFomat


select * from itemSale
select * from SetTip


select * from Xw_SelfData
select * from Xw_SelfBT


select * from xwc_functionlist
select * from xw_UpdateLog

select * from xw_gridfieldconfig
select * from xw_baseupdatetag



select * from Xw_colorMan
select * from Xw_SysData
select * from Xw_BusinessDataNdx
select * from Xw_BusinessDataParam


select * from YearInfo




select * from WEOverCost
select * from FcOverCost
select * from OrderVchType
select * from NavSetting
select * from Pos_ColCfg
select * from CustomBalanceKey
select * from WxTemplateSet
select * from SMSTemplateSet
select * from ERPConfig
select * from Plu_SS_SysInfo
select * from DDMessageSet
select * from ProfitVchType
select * from DlyndxExte
select * from VoucherType
select * from FtypeLevLenModel

select * from AtypeRelateModel
select * from AccountModel


select * from BOM_Type

郭少锋 编辑 2023-09-11 22:57:47 创建 2023-09-11 22:48:11 K3 功能