• 金蝶钉钉审批插件SQL(GoldLink) 488.98 kB 2024-03-20 23:22
  • 位置: 金蝶钉钉审批插件SQL(GoldLink) / 1. 金数创建钉钉审批流程表单信息.sql

    ��
    
    -- =============================================
    
    -- Author:		SUN
    
    -- Create date: 2022t^10g26�e
    
    -- Description:	R�^�����[ybAmzh�US<P
    
    -- �O9e�eg�2023-06-18 10:33:32
    
    -- =============================================
    
    
    
    /****** Object:  Table [dbo].[GoldLink_PROCESSCODE]    Script Date: 2023/6/18 10:28:42 ******/
    
    SET ANSI_NULLS ON
    
    GO
    
    SET QUOTED_IDENTIFIER ON
    
    GO
    
    --CREATE TABLE [dbo].[GoldLink_PROCESSCODE](
    
    --	[FPROCESSCODE] [nvarchar](50) NOT NULL,
    
    --	[FBillName] [nvarchar](20) NULL,
    
    --	[FTableName] [nvarchar](50) NULL,
    
    --	[FormID] [nvarchar](50) NULL,
    
    --	[FForbidStatus] [bit] NULL CONSTRAINT [DF_GoldLink_PROCESSCODE_FForbidStatus]  DEFAULT ((0)),
    
    --	[Fdate] [datetime] NULL CONSTRAINT [DF_GoldLink_PROCESSCODE_Fdate]  DEFAULT (getdate()),
    
    --	[FBillField] [nvarchar](1000) NULL,
    
    --	[FBillEntryField] [nvarchar](1000) NULL,
    
    -- CONSTRAINT [PK_GoldLink_PROCESSCODE] PRIMARY KEY CLUSTERED 
    
    --(
    
    --	[FPROCESSCODE] ASC
    
    --)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    
    --) ON [PRIMARY]
    
    
    
    --select * from [dbo].[GoldLink_PROCESSCODE] 
    
    Declare @Forbidden int;
    
    set @Forbidden=1;
    
    
    
    delete [GoldLink_PROCESSCODE] 
    
    go
    
    INSERT [dbo].[GoldLink_PROCESSCODE] 
    
    ([FPROCESSCODE], [FBillName], [FTableName], [FormID], [FForbidStatus], [Fdate], [FBillField], [FBillEntryField]) VALUES 
    
    
    
    (N'PROC-0E97AB98-6278-454E-A7AB-2A748CC762FA', N'�.U��US', N'T_SAL_ORDER', N'SAL_SaleOrder', 0, GETDATE(), NULL, NULL)
    
    ,(N'PROC-27E8B43A-1132-469A-B04C-38385B14FC2C', N'�.UTT', N'T_CRM_CONTRACT', N'CRM_Contract', 0, GETDATE(), NULL, NULL)
    
    --,(N'PROC-1B9933DE-DCAC-41AD-8443-131C3C6BE463', N'�.U��US�e�S�fUS', N'T_SAL_XORDER', N'SAL_XORDER', 0, GETDATE(), NULL, NULL)
    
    ,(N'PROC-4787F101-2AE3-4D78-9F42-AB5B90028DC2', N'Ǒ-�3u��US', N'T_PUR_Requisition', N'PUR_Requisition', 0, GETDATE(), NULL, NULL)
    
    --,(N'PROC-FCDD8A2D-0129-4C71-8665-F73A724AE215', N'Ǒ-�TT', N'T_PUR_CONTRACT', N'PUR_Contract', 0, GETDATE(), NULL, NULL)
    
    ,(N'PROC-25614E0F-6ED5-46F5-A1B4-79E7646CE195', N'Ǒ-���US', N't_PUR_POOrder', N'PUR_PurchaseOrder', 0, GETDATE(), NULL, NULL)
    
    --,(N'PROC-1617EBBA-0960-419C-949B-AA9CD0EC2ED4', N'Ǒ-���US�S�fUS', N'T_PUR_POChange', N'PUR_POChange', 0, GETDATE(), NULL, NULL)
    
    ,(N'PROC-384A372F-B319-4F3A-9050-6EC49E77290A', N'Ǒ-���US�e�S�fUS', N't_PUR_XPOOrder', N'PUR_POXChange', 0, GETDATE(), NULL, NULL)
    
    ,(N'PROC-D04ACDD5-FC49-4058-905D-533FF0D3A47E', N'�N>k3u��US', N'T_CN_PAYAPPLY', N'CN_PAYAPPLY', 0, GETDATE(), NULL, NULL)
    
    --,(N'PROC-82136878-63FC-4861-9970-401FA24E9C0C', N'�.U�N�vh�', N'T_SAL_PRICELIST', N'BD_SAL_PriceList', 0, GETDATE(), NULL, NULL)
    
    --,(N'PROC-2FC54951-F663-4EF1-B572-79A4882ED373', N'Ǒ-��N�vh�', N't_PUR_PriceList', N'PUR_PriceCategory', 0, GETDATE(), NULL, NULL)
    
    --,(N'PROC-526FDA5E-4268-43EF-83C4-639DDD3F68D8', N'Ǒ-���Nh�', N'T_PUR_PAT', N'PUR_PAT', 0, GETDATE(), NULL, NULL)
    
    --,(N'PROC-81F26326-3E5B-4886-B592-337F1145A715', N'ybϑ��NUS', N'T_SAL_BATCHADJUST', N'SAL_BATCHADJUSTPRICE', 0, GETDATE(), NULL, NULL)
    
    --,(N'PROC-0AB12ADD-C1D6-45D3-9FB3-F389761B7118', N'�v�vUS', N'T_STK_STKCOUNTGAIN', N'STK_StockCountGain', 0, GETDATE(), NULL, NULL)
    
    --,(N'PROC-3E5F227D-2670-466D-ADAC-CA0C94B6D149', N'�v�NUS', N'T_STK_STKCOUNTLOSS', N'STK_StockCountLoss', 0, GETDATE(), NULL, NULL)
    
    ,(N'PROC-4455665C-C025-4194-8ED5-38A19991F096', N'vQ�N�Q�^US', N'T_STK_MISDELIVERY', N'STK_MisDelivery', 0, GETDATE(), NULL, NULL)
    
    ,(N'PROC-0A17C385-9BEF-4112-AF80-17410824BC43', N'vQ�NeQ�^US', N'T_STK_MISCELLANEOUS', N'STK_MISCELLANEOUS', 0, GETDATE(), NULL, NULL)
    
    ,(N'PROC-CCA46B91-E923-4773-BB25-636CF1CC4B30', N'ir�e', N'T_BD_MATERIAL', N'BD_MATERIAL', 0, GETDATE(), NULL, NULL)
    
    --,(N'PROC-7F62AB33-EDEF-4789-A3EE-23DFC9CB333E', N'>mf�US', N'abc_t_Cust100001', N'k95d983877d20489cb50133dcb13d177d', 0, GETDATE(), NULL, NULL)
    
    
    
    

    Powered by kodbox V1.59

    Copyright © kodcloud.com.

    Files