• 金蝶钉钉审批插件SQL(GoldLink) 488.98 kB 2024-03-20 23:22
  • 位置: 金蝶钉钉审批插件SQL(GoldLink) / 2. 金数创建金蝶钉钉审批单据字段映射241008增加简单生产出入库单据.sql

    ��-- =============================================
    
    -- Author:		SUN
    
    -- Create date: 2022t^10g26�e15:05:49
    
    -- Description:	�����[ybUSncW[�kR�YS
    
    -- �O9e�eg�2023t^6g17�e21:25:23
    
    -- =============================================
    
    --select * from [dbo].GoldLink_Form_Values  where FTableName='t_PUR_POOrder'
    
    
    
    --SET ANSI_NULLS ON
    
    --GO
    
    --SET QUOTED_IDENTIFIER ON
    
    --GO
    
    --CREATE TABLE [dbo].[GoldLink_Form_Values](
    
    --	[FTableName] [nvarchar](50) NOT NULL,
    
    --	[FEntrName] [nvarchar](30) NULL CONSTRAINT [DF_GoldLink_Form_Values_FisEntry]  DEFAULT ((0)),
    
    --	[FDingFieldName] [nvarchar](50) NOT NULL,
    
    --	[FField] [nvarchar](50) NULL,
    
    --	[FPropertyName] [nvarchar](30) NULL,
    
    --	[FDefault] [nvarchar](1000) NULL,
    
    --	[FDefaultType] [int] NULL,
    
    --	[FValueType] [nvarchar](10) NULL,
    
    --	[FAddStrLeft] [nvarchar](50) NULL,
    
    --	[FFormatString] [nvarchar](20) NULL,
    
    --	[FAddStrRight] [nvarchar](50) NULL,
    
    --	[FForbidStatus] [bit] NULL CONSTRAINT [DF_GoldLink_Form_Values_FForbidStatus]  DEFAULT ((0)),
    
    --	[FisSysField] [bit] NULL CONSTRAINT [DF_GoldLink_Form_Values_FisSysField]  DEFAULT ((0))
    
    --) ON [PRIMARY]
    
    
    
    --GO
    
    --EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'h�
    T' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'GoldLink_Form_Values', @level2type=N'COLUMN',@level2name=N'FTableName'
    
    --GO
    
    --EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'/f&T/ff�~' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'GoldLink_Form_Values', @level2type=N'COLUMN',@level2name=N'FEntrName'
    
    --GO
    
    --EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'����W[�k
    T' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'GoldLink_Form_Values', @level2type=N'COLUMN',@level2name=N'FDingFieldName'
    
    --GO
    
    --EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'W[�khƋ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'GoldLink_Form_Values', @level2type=N'COLUMN',@level2name=N'FField'
    
    --GO
    
    --EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'W[�k^\'`
    T' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'GoldLink_Form_Values', @level2type=N'COLUMN',@level2name=N'FPropertyName'
    
    --GO
    
    --EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'؞��<P' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'GoldLink_Form_Values', @level2type=N'COLUMN',@level2name=N'FDefault'
    
    --GO
    
    --EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'؞��<PK�<P�e_�0:Nzz:Nnull�1:_6R' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'GoldLink_Form_Values', @level2type=N'COLUMN',@level2name=N'FDefaultType'
    
    --GO
    
    --EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'W[�k{|�W�string datetime�int�float' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'GoldLink_Form_Values', @level2type=N'COLUMN',@level2name=N'FValueType'
    
    --GO
    
    --EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<h_SW[&{2N' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'GoldLink_Form_Values', @level2type=N'COLUMN',@level2name=N'FFormatString'
    
    --GO
    
    --EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'/f&T�|�~W[�k' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'GoldLink_Form_Values', @level2type=N'COLUMN',@level2name=N'FisSysField'
    
    --GO
    
    
    
    
    
    
    
    Declare @BillHeadName Varchar(255);---USnc4Y:h�
    T
    
    Declare @BillEntryName Varchar(255);--f�~:hƋ
    
    Declare @AttachmentFileServerURL Varchar(255);
    
    Declare @AttachmentWeb Varchar(255);
    
    Declare @DefDeptId Varchar(255);
    
    Declare @tDeptId Varchar(255);
    
    Declare @UserPhoneValue Varchar(255);
    
    Declare @Forbidden int;
    
    Declare @Sys Varchar(50);;
    
    
    
    set @Forbidden=1;
    
    set @Sys=N'SYS';;
    
    set @AttachmentFileServerURL=N'http://47.119.140.79/f/';
    
    set @AttachmentWeb=N'http://47.119.140.79/ding/f.aspx';
    
    set @DefDeptId=N'-1';--*gkX��e؞����
    
    
    
    set @UserPhoneValue=N'PHONE';---����Kb:g(u7bW[�k
    T�y
    
    
    
    
    
    ------------------------------------------------------------------/****** �.U��US ******/
    
    --select * from GoldLink_Form_Values  where [FTableName]='T_SAL_ORDER'
    
    set @BillHeadName='T_SAL_ORDER';
    
    set @BillEntryName='FSaleOrderEntry';
    
    delete [dbo].GoldLink_Form_Values  where FTableName=@BillHeadName
    
    INSERT [dbo].GoldLink_Form_Values 
    
    ([FTableName], [FEntrName], [FDingFieldName], [FField], [FPropertyName], [FDefault], [FDefaultType], [FValueType], [FAddStrLeft], [FFormatString], [FAddStrRight], [FForbidStatus], [FFieldType],[FTSQL]) 
    
    VALUES 
    
    (@BillHeadName, NULL, N'userid_list', N'FCreatorId', @UserPhoneValue, NULL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'DeptId', N'FSaleDeptId', N'FDDeptId', @DefDeptId, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentFileServerURL', NULL, NULL, @AttachmentFileServerURL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentWeb', NULL, NULL, @AttachmentWeb, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'USnc{|�W', N'FBillTypeID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'USnc�S', N'FBillNo', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�eg', N'FDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'Y�l', N'FNote', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'��USё��', N'FBillAllAmount', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'^+R', N'FSettleCurrId',N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�.U�~�~', N'FSaleOrgId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�[7b', N'FCustId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�.U��', N'FSaleDeptId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�.UXT', N'FSalerId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�.U�~', N'FSaleGroupId', N'Description', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�N'��e_', N'FHeadDeliveryWay', N'FDataValue', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'6e>kag�N', N'FRecConditionId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�^6e�eg', N'F_GOLD_Date', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�^�S', N'Seq', NULL, NULL, NULL, N'double', NULL, N'0', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�^X[�~�~', N'StockOrgId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'�[7b
    T�y', N'FMRPNO01', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ir�ex', N'MaterialId', N'Number', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ir�e
    T�y', N'MaterialId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ĉ<h�W�S', N'MaterialId', N'Specification', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'US�N', N'Price', NULL, NULL, NULL, N'double', NULL, N'0.000000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'+TzUS�N', N'TaxPrice', NULL, NULL, NULL, N'double', NULL, N'0.000000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'z�s', N'TaxRate', NULL, NULL, NULL, N'double', NULL, N'0', N'%', 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�.Upeϑ', N'Qty', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'USMO', N'UnitId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�NzT��', N'AllAmount', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'��'��eg', N'DeliveryDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'Y�l', N'Note', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    
    
    
    
    ------------------------------------------------------------------/****** �.U��US�e�S�fUS ******/
    
    --select * from GoldLink_Form_Values  where [FTableName]='T_SAL_XORDER'
    
    --set @BillHeadName='T_SAL_XORDER';
    
    --set @BillEntryName='FSaleOrderEntry';
    
    --delete [dbo].GoldLink_Form_Values  where FTableName=@BillHeadName
    
    --INSERT [dbo].GoldLink_Form_Values 
    
    --([FTableName], [FEntrName], [FDingFieldName], [FField], [FPropertyName], [FDefault], [FDefaultType], [FValueType], [FAddStrLeft], [FFormatString], [FAddStrRight], [FForbidStatus], [FFieldType],[FTSQL]) 
    
    --VALUES 
    
    --(@BillHeadName, NULL, N'userid_list', N'FCreatorId', @UserPhoneValue, NULL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    --,(@BillHeadName, NULL, N'DeptId', N'FSaleDeptId', N'FDDeptId', @DefDeptId, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    --,(@BillHeadName, NULL, N'AttachmentFileServerURL', NULL, NULL, @AttachmentFileServerURL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    --,(@BillHeadName, NULL, N'AttachmentWeb', NULL, NULL, @AttachmentWeb, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    --,(@BillHeadName, NULL, N'��US�S', N'FBillNo', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'��US�eg', N'FDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'Y�l', N'FNote', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'��USё��', N'FBillAllAmount', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'�.U�~�~', N'FSaleOrgId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'�[7b', N'FCustId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'�.UXT', N'FSalerId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'�.U�~', N'FSaleGroupId', N'Description', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'�N'��e_', N'FHeadDeliveryWay', N'FDataValue', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'6e>kag�N', N'FRecConditionId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'�^6e�eg', N'F_GOLD_Date', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'�^X[�~�~', N'StockOrgId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'ir�ex', N'MaterialId', N'Number', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'ir�e
    T�y', N'MaterialId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'ĉ<h�W�S', N'MaterialId', N'Specification', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'+TzUS�N', N'TaxPrice', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'z�s', N'TaxRate', NULL, NULL, NULL, N'double', NULL, N'0', N'%', 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'�.Upeϑ', N'Qty', NULL, NULL, NULL, N'double', NULL, N'0.0000', NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'USMO', N'UnitId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'�NzT��', N'AllAmount', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'Y�l', N'Note', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'�S�f�S�V', N'FCHANGEREASON', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'�S�f{|�W', N'ChangeType', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'�S�.Upeϑ', N'QtyX', NULL, NULL, NULL, N'double', NULL, N'0.0000', NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'�S+TzUS�N', N'TaxPricex', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'�Sz�s', N'TaxRateX', NULL, NULL, NULL, N'double', NULL, N'0', N'%', 0, null,null)
    
    
    
    
    
    ------------------------------------------------------------------/****** �.UTT ******/
    
    --select * from [dbo].GoldLink_Form_Values  where FTableName='T_CRM_CONTRACT'
    
    set @BillHeadName='T_CRM_CONTRACT';
    
    set @BillEntryName='FCRMContractEntry';
    
    delete [dbo].GoldLink_Form_Values  where FTableName=@BillHeadName
    
    INSERT [dbo].GoldLink_Form_Values 
    
    ([FTableName], [FEntrName], [FDingFieldName], [FField], [FPropertyName], [FDefault], [FDefaultType], [FValueType], [FAddStrLeft], [FFormatString], [FAddStrRight], [FForbidStatus], [FFieldType],[FTSQL]) 
    
    VALUES 
    
    (@BillHeadName, NULL, N'userid_list', N'FCreatorId', @UserPhoneValue, NULL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'DeptId', N'FSaleDeptId', N'FDDeptId', @DefDeptId, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentFileServerURL', NULL, NULL, @AttachmentFileServerURL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentWeb', NULL, NULL, @AttachmentWeb, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'sQT��[ybUS', N'FSrc_instance_id', NULL, NULL, NULL, N'string', NULL, N'["{0}"]', NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'USnc�S', N'FBillNo', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'TT
    T�y', N'FName', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�eg', N'FDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'	gHew��Y�eg', N'FValiStartDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'	gHe*bbk�eg', N'FValiEndDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'TT	gHeg()Y)', N'FContrValidity', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'@b^\y��v', N'F_Gold_Project', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�.U�~�~', N'FSALEORGID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�[7b', N'FBDCUSTID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�.U��', N'FSaleDeptId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�.UXT', N'FSalerId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�.U�~', N'FSaleGroupId', N'Description', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�~�{^+R', N'FSettleCurrId',N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'TT{|�W', N'FContractType',NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    
    
    ,(@BillHeadName, @BillEntryName, N'�^�S', N'Seq', NULL, NULL, NULL, N'double', NULL, N'0', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ir�ex', N'MaterialId', N'Number', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ir�e
    T�y', N'MaterialId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ĉ<h�W�S', N'MaterialId', N'Specification', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'US�N', N'Price', NULL, NULL, NULL, N'double', NULL, N'0.000000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'+TzUS�N', N'TaxPrice', NULL, NULL, NULL, N'double', NULL, N'0.000000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'z�s', N'FTAXRATE', NULL, NULL, NULL, N'double', NULL, N'0', N'%', 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�.Upeϑ', N'Qty', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�.UUSMO', N'UnitId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�NzT��', N'AllAmount', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'��'��eg', N'FDELIVERYDATE', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'Y�l', N'Note', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    
    
    
    
    
    
    ------------------------------------------------------------------/****** Ǒ-�3u�� ******/
    
    --select * from [dbo].GoldLink_Form_Values  where FTableName='T_PUR_Requisition'
    
    set @BillHeadName='T_PUR_Requisition';
    
    set @BillEntryName='FEntity';
    
    delete [dbo].GoldLink_Form_Values  where FTableName=@BillHeadName
    
    INSERT [dbo].GoldLink_Form_Values 
    
    ([FTableName], [FEntrName], [FDingFieldName], [FField], [FPropertyName], [FDefault], [FDefaultType], [FValueType], [FAddStrLeft], [FFormatString], [FAddStrRight], [FForbidStatus], [FFieldType],[FTSQL]) 
    
    VALUES 
    
    (@BillHeadName, NULL, N'userid_list', N'FCreatorId', @UserPhoneValue, NULL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'DeptId', N'FApplicationDeptId', N'FDDeptId', @DefDeptId, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentFileServerURL', NULL, NULL, @AttachmentFileServerURL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentWeb', NULL, NULL, @AttachmentWeb, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'USnc{|�W', N'FBillTypeID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'USnc�S', N'FBillNo', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'3u���eg', N'FApplicationDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'3u���~�~', N'FApplicationOrgId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'3u����', N'FApplicationDeptId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'@b(W��', N'FApplicationDeptId', N'FDDeptId', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'��', N'FApplicationDeptId', N'FDDeptId', NULL, NULL, N'string', NULL, N'["{0}"]', NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'3u���N', N'FApplicantId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'3u��ё��', N'FTotalAmount', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'Y�l', N'FNote', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�^�S', N'Seq', NULL, NULL, NULL, N'double', NULL, N'0', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�Bl�~�~', N'RequireOrgId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ir�ex', N'MaterialId', N'Number', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ir�e
    T�y', N'MaterialId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ĉ<h�W�S', N'MaterialId', N'Specification', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'+TzUS�N', N'TaxPrice', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'z�s', N'TaxRate', NULL, NULL, NULL, N'double', NULL, N'0', N'%', 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'3u��peϑ', N'ReqQty', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'USMO', N'UnitId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'0R'��eg', N'ArrivalDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'�NzT��', N'ReqAmount', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'Y�l', N'EntryNote', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    
    
    ------------------------------------------------------------------/****** Ǒ-���US ******/
    
    --select * from [dbo].GoldLink_Form_Values  where FTableName='t_PUR_POOrder'
    
    set @BillHeadName='t_PUR_POOrder';
    
    set @BillEntryName='FPOOrderEntry';
    
    delete [dbo].GoldLink_Form_Values  where FTableName=@BillHeadName
    
    INSERT [dbo].GoldLink_Form_Values 
    
    ([FTableName], [FEntrName], [FDingFieldName], [FField], [FPropertyName], [FDefault], [FDefaultType], [FValueType], [FAddStrLeft], [FFormatString], [FAddStrRight], [FForbidStatus], [FFieldType],[FTSQL]) 
    
    VALUES 
    
    (@BillHeadName, NULL, N'userid_list', N'FCreatorId', @UserPhoneValue, NULL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'DeptId', N'FPurchaseDeptId', N'FDDeptId', @DefDeptId, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentFileServerURL', NULL, NULL, @AttachmentFileServerURL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentWeb', NULL, NULL, @AttachmentWeb, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'USnc{|�W', N'FBILLTYPEID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'USnc�S', N'FBillNo', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'Ǒ-��eg', N'FDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�O�^FU', N'FSupplierId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'Ǒ-��~�~', N'FPurchaseOrgId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'Ǒ-���', N'FPurchaseDeptId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'Ǒ-�XT', N'FPurchaserId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�N>kag�N', N'FPAYCONDITIONID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'Y�l', N'FNote', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'��USё��', N'FBillAllAmount', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'^+R', N'FSettleCurrId',N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'6e'�0W@W', N'F_Gold_RecADD',N'FDataValue', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    
    
    ,(@BillHeadName, NULL, N'0W�pN�b', N'F_Gold_Combo',N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)----Name/Value
    
    
    
    ,(@BillHeadName, NULL, N'sQT�Ǒ-�3u��', N'FReq_instance_id', NULL, NULL, NULL, N'string', NULL, N'["{0}"]', NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'@b^\y��v', N'F_NBFB_Projects', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�^�S', N'Seq', NULL, NULL, NULL, N'double', NULL, N'0', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ID', N'ID', NULL, NULL, NULL, N'double', NULL, N'0', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�Bl�~�~', N'ReceiveOrgId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ir�ex', N'MaterialId', N'Number', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ir�e
    T�y', N'MaterialId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ĉ<h�W�S', N'MaterialId', N'Specification', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'+TzUS�N', N'TaxPrice', NULL, NULL, NULL, N'double', NULL, N'0.000000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'z�s', N'TaxRate', NULL, NULL, NULL, N'double', NULL, N'0', N'%', 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'Ǒ-�peϑ', N'Qty', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'Ǒ-�USMO', N'UnitId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�NzT��', N'AllAmount', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�N'��eg', N'DeliveryDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'f���0R�S�e�', N'F_Gold_Time', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'Y�l', N'Note', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    
    
    
    
    ------------------------------------------------------------------/****** Ǒ-���US�S�fUS ******/
    
    set @BillHeadName='T_PUR_POChange';
    
    set @BillEntryName='FEntity';
    
    delete [dbo].GoldLink_Form_Values  where FTableName=@BillHeadName
    
    INSERT [dbo].GoldLink_Form_Values 
    
    ([FTableName], [FEntrName], [FDingFieldName], [FField], [FPropertyName], [FDefault], [FDefaultType], [FValueType], [FAddStrLeft], [FFormatString], [FAddStrRight], [FForbidStatus], [FFieldType],[FTSQL]) 
    
    VALUES 
    
    (@BillHeadName, NULL, N'userid_list', N'FCreatorId', @UserPhoneValue, NULL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'DeptId', N'FPurchaseDeptId', N'FDDeptId', @DefDeptId, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentFileServerURL', NULL, NULL, @AttachmentFileServerURL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentWeb', NULL, NULL, @AttachmentWeb, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'USnc{|�W', N'FBILLTYPEID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'USnc�S', N'FBillNo', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'Ǒ-��eg', N'FDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�O�^FU', N'FSupplierId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'Ǒ-��~�~', N'FPurchaseOrgId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'Ǒ-���', N'FPurchaseDeptId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'Ǒ-�XT', N'FPurchaserId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�N>kag�N', N'FPAYCONDITIONID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�S�f�S�V', N'FChangeReason', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'Y�l', N'FNote', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'��USё��', N'FBillAllAmount', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'6e'�0W@W', N'F_Gold_RecADD',N'FDataValue', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'sQT�Ǒ-�3u��', N'FSrc_instance_id', NULL, NULL, NULL, N'string', NULL, N'["{0}"]', NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'@b^\y��v', N'F_NBFB_Projects', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�^�S', N'Seq', NULL, NULL, NULL, N'double', NULL, N'0', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�S�Bl�~�~', N'ORequireOrgId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�e�Bl�~�~', N'NRequireOrgId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�S�f{|�W', N'ChangeType', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ir�ex', N'MaterialId', N'Number', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ir�e
    T�y', N'MaterialId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ĉ<h�W�S', N'MaterialId', N'Specification', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�SUS�N', N'OldPrice', NULL, NULL, NULL, N'double', NULL, N'0.000000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�eUS�N', N'NewPrice', NULL, NULL, NULL, N'double', NULL, N'0.000000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�SǑ-�peϑ', N'OldQty', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�eǑ-�peϑ', N'NewQty', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�S��US�S', N'OrderFBillNo', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'Ǒ-�USMO', N'UnitId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�S�N'��eg', N'OldDeliveryDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�e�N'��eg', N'NewDeliveryDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'Y�l', N'Note', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    
    
    
    
    ------------------------------------------------------------------/****** Ǒ-���US�e�S�fUS ******/
    
    --select * from [dbo].GoldLink_Form_Values  where FTableName='t_PUR_XPOOrder'
    
    set @BillHeadName='t_PUR_XPOOrder';
    
    set @BillEntryName='FPOOrderEntry';
    
    delete [dbo].GoldLink_Form_Values  where FTableName=@BillHeadName
    
    INSERT [dbo].GoldLink_Form_Values 
    
    ([FTableName], [FEntrName], [FDingFieldName], [FField], [FPropertyName], [FDefault], [FDefaultType], [FValueType], [FAddStrLeft], [FFormatString], [FAddStrRight], [FForbidStatus], [FFieldType],[FTSQL]) 
    
    VALUES 
    
    (@BillHeadName, NULL, N'userid_list', N'FCreatorId', @UserPhoneValue, NULL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'DeptId', N'FPurchaseDeptId', N'FDDeptId', @DefDeptId, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentFileServerURL', NULL, NULL, @AttachmentFileServerURL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentWeb', NULL, NULL, @AttachmentWeb, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'USnc{|�Wn', N'FBillTypeID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'USnc{|�W', N'FBillTypeIdX', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'USnc�S', N'FBillNo', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'Ǒ-��eg', N'FDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'�O�^FU', N'FSupplierId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'Ǒ-��~�~', N'FPurchaseOrgId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'Ǒ-���', N'FPurchaseDeptId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'Ǒ-�XT', N'FPurchaserId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'�N>kag�N', N'FPAYCONDITIONID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'�S�f�S�V', N'FChangeReason', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'Y�l', N'FNote', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'��USё��', N'FBillAllAmount', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'^+R', N'FSettleCurrId',N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ----,(@BillHeadName, NULL, N'6e'�0W@W', N'F_Gold_RecADD',N'FDataValue', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'sQT�Ǒ-�3u��', N'FReq_instance_id', NULL, NULL, NULL, N'string', NULL, N'["{0}"]', NULL, 0, null,null)
    
    ----,(@BillHeadName, NULL, N'@b^\y��v', N'F_NBFB_Projects', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'�^�S', N'Seq', NULL, NULL, NULL, N'double', NULL, N'0', NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'�Bl�~�~', N'RequireOrgId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'�S�f{|�W', N'CHANGETYPE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'ir�ex', N'MaterialId', N'Number', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'ir�e
    T�y', N'MaterialId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'ĉ<h�W�S', N'MaterialId', N'Specification', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'�S+TzUS�N', N'TaxPriceX', NULL, NULL, NULL, N'double', NULL, N'0.000000', NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'�e+TzUS�N', N'TaxPrice', NULL, NULL, NULL, N'double', NULL, N'0.000000', NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'�SǑ-�peϑ', N'QtyX', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'Ǒ-�peϑ', N'Qty', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'Ǒ-�USMO', N'UnitId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'�N'��eg', N'DeliveryDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'Y�l', N'Note', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    
    
    
    
    ------------------------------------------------------------------/****** �^�NUS ******/
    
    --select * from [dbo].GoldLink_Form_Values  where FTableName='T_AP_PAYABLE'
    
    set @BillHeadName='T_AP_PAYABLE';
    
    set @BillEntryName='FEntityDetail';
    
    delete [dbo].GoldLink_Form_Values  where FTableName=@BillHeadName
    
    INSERT [dbo].GoldLink_Form_Values 
    
    ([FTableName], [FEntrName], [FDingFieldName], [FField], [FPropertyName], [FDefault], [FDefaultType], [FValueType], [FAddStrLeft], [FFormatString], [FAddStrRight], [FForbidStatus], [FFieldType],[FTSQL]) 
    
    VALUES 
    
    (@BillHeadName, NULL, N'userid_list', N'FCreatorId', @UserPhoneValue, NULL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'DeptId', N'FPURCHASEDEPTID', N'FDDeptId',@DefDeptId, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentFileServerURL', NULL, NULL, @AttachmentFileServerURL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentWeb', NULL, NULL, @AttachmentWeb, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL,  N'@b(W��', N'FPURCHASEDEPTID', N'FDDeptId', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL)
    
    ,(@BillHeadName, NULL,  N'USnc{|�W', N'FBillTypeID', N'Name', NULL, NULL, N'string', NULL, NULL, NULL, 0, NULL, NULL)
    
    ,(@BillHeadName, NULL,  N'USnc�S', N'FBillNo', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL)
    
    ,(@BillHeadName, NULL,  N'N�R�eg', N'FDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, NULL, NULL)
    
    ,(@BillHeadName, NULL,  N'0Rg�e', N'FENDDATE_H', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, NULL, NULL)
    
    ,(@BillHeadName, NULL,  N'�^�Nё��', N'FPAYAMOUNTFOR_H', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, NULL, NULL)
    
    ,(@BillHeadName, NULL,  N'�NzT��', N'FALLAMOUNTFOR', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, NULL, NULL)
    
    ,(@BillHeadName, NULL,  N'^+R', N'FCURRENCYID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL)
    
    ,(@BillHeadName, NULL,  N'�N>k�~�~', N'FPAYORGID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL)
    
    ,(@BillHeadName, NULL,  N'Ǒ-��~�~', N'FPURCHASEORGID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL)
    
    ,(@BillHeadName, NULL,  N'Ǒ-���', N'FPURCHASEDEPTID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL)
    
    ,(@BillHeadName, NULL,  N'Ǒ-�XT', N'FPURCHASERID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL)
    
    ,(@BillHeadName, NULL,  N'�O�^FU', N'FSUPPLIERID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL)
    
    ,(@BillHeadName, NULL,  N'sQT��[ybUS', N'FSrc_instance_id', NULL, NULL, NULL, N'string', NULL, N'["{0}"]', NULL, 0, NULL, NULL)
    
    ,(@BillHeadName, @BillEntryName,  N'�N>kag�N', N'FPayConditon', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL)
    
    ,(@BillHeadName, @BillEntryName,  N'Y�l', N'FAP_Remark', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL)
    
    ,(@BillHeadName, @BillEntryName,  N'ir�ex', N'MaterialId', N'Number', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL)
    
    ,(@BillHeadName, @BillEntryName,  N'ir�e
    T�y', N'MaterialId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL)
    
    ,(@BillHeadName, @BillEntryName,  N'ĉ<h�W�S', N'MaterialId', N'Specification', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL)
    
    ,(@BillHeadName, @BillEntryName,  N'���Npeϑ', N'PriceQty', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, NULL, NULL)
    
    ,(@BillHeadName, @BillEntryName,  N'+TzUS�N', N'TaxPrice', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, NULL, NULL)
    
    ,(@BillHeadName, @BillEntryName,  N'�NzT��', N'FALLAMOUNTFOR_D', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, NULL, NULL)
    
    ,(@BillHeadName, @BillEntryName,  N'z��', N'FTAXAMOUNTFOR_D', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, NULL, NULL)
    
    ,(@BillHeadName, @BillEntryName,  N'z�s', N'EntryTaxRate', NULL, NULL, NULL, N'double', NULL, N'0', N'%', 0, NULL, NULL)
    
    ,(@BillHeadName, @BillEntryName,  N'�nUS{|�W', N'FSOURCETYPE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, N'enum', N'STK_InStock=eQ�^US')
    
    ,(@BillHeadName, @BillEntryName,  N'�nUS�S', N'SourceBillNo', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL)
    
    ,(@BillHeadName, @BillEntryName,  N'yb�S', N'FLOT', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL)
    
    ,(@BillHeadName, @BillEntryName,  N'Y�l', N'Comment', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL)
    
    
    
    
    
    
    
    
    
    ------------------------------------------------------------------/****** �N>k3u��US ******/
    
    --select * from [dbo].GoldLink_Form_Values  where FTableName='T_CN_PAYAPPLY'
    
    set @BillHeadName='T_CN_PAYAPPLY';
    
    set @BillEntryName='FPAYAPPLYENTRY';
    
    delete [dbo].GoldLink_Form_Values  where FTableName=@BillHeadName
    
    INSERT [dbo].GoldLink_Form_Values 
    
    ([FTableName], [FEntrName], [FDingFieldName], [FField], [FPropertyName], [FDefault], [FDefaultType], [FValueType], [FAddStrLeft], [FFormatString], [FAddStrRight], [FForbidStatus], [FFieldType],[FTSQL]) 
    
    VALUES 
    
    (@BillHeadName, NULL, N'userid_list', N'FCreatorId', @UserPhoneValue, NULL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'DeptId', N'FPURCHASEDEPTID', N'FDDeptId',@DefDeptId, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentFileServerURL', NULL, NULL, @AttachmentFileServerURL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentWeb', NULL, NULL, @AttachmentWeb, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'@b(W��', N'FPURCHASEDEPTID', N'FDDeptId', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'USnc{|�W', N'FBILLTYPEID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'USnc{|�W', N'FBILLTYPEID', N'Name', NULL, NULL, N'string', NULL, N'["{0}"]', NULL, 0, null,null)
    
    
    
    ,(@BillHeadName, NULL, N'USnc�S', N'FBillNo', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'3u���eg', N'FDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�^�Nё��', N'FPAYAMOUNTFOR_H', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'3u���N>kё��', N'FAPPLYAMOUNTFOR_H', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'^+R', N'FCURRENCYID',N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'3u���~�~', N'FAPPLYORGID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�_egUSMO', N'FCONTACTUNIT', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�_egUSMO{|�W', N'FCONTACTUNITTYPE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, N'TSQL',N'select top 1 FNAME from V_META_BASEDATATYPE_L where FID=''{1}''')
    
    ,(@BillHeadName, NULL, N'6e>kUSMO', N'FRECTUNIT', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'Ǒ-�XT', N'FPURCHASERID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'Ǒ-��~', N'FPURCHASERGROUPID', N'Description', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'Ǒ-��~', N'FPURCHASERGROUPID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'Ǒ-���', N'FPURCHASEDEPTID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'Y�l', N'FNote', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'3u���N1u', N'FNote', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'@b^\y��v', N'F_NBFB_Projects', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'sQT��[ybUS', N'FSrc_instance_id', NULL, NULL, NULL, N'Track', NULL, N'["{0}"]', NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'sQT��[ybUS', N'FReq_instance_id', NULL, NULL, NULL, N'string', NULL, N'["{0}"]', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ir�ex', N'FMATERIALID', N'Number', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ir�e
    T�y', N'FMATERIALID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ĉ<h�W�S', N'FMATERIALID', N'Specification', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'peϑ', N'QTY', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�~�{�e_', N'FSETTLETYPEID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'gg�N>k�eg', N'FEXPECTPAYDATE', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'3u���N>kё��', N'FAPPLYAMOUNTFOR', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'9�(ub�b��hQ�y', N'FEXPENSEDEPTID', N'FullName', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'z��', N'TAXAMOUNT', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�[�e��L�&��S', N'FEACHBANKACCOUNT', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�[�e&�7b
    T�y', N'FEACHCCOUNTNAME', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�[�e_7bL�', N'FEACHBANKNAME', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'Y�l', N'Description', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�nUS{|�W', N'FSOURCETYPE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�nUS�S', N'FSRCBILLNO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'9�(uy��v', N'FCOSTID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�N>k(u�', N'FPAYPURPOSEID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'sQT��[ybUS', N'FReq_instance_ide', NULL, NULL, NULL, N'string', NULL, N'["{0}"]', NULL, 0, null,null)
    
    
    
    ------------------------------------------------------------------/****** �.U�N�vh� ******/
    
    --select * from [dbo].GoldLink_Form_Values  where FTableName='T_SAL_PRICELIST'
    
    set @BillHeadName='T_SAL_PRICELIST';
    
    set @BillEntryName='FEntity';
    
    set @tDeptId=@DefDeptId;
    
    set @DefDeptId=N'824339873';--*gkX��e؞�����;`�-%�N�
    
    delete [dbo].GoldLink_Form_Values  where FTableName=@BillHeadName---USnc4Yh�
    T
    
    INSERT [dbo].GoldLink_Form_Values 
    
    ([FTableName], [FEntrName], [FDingFieldName], [FField], [FPropertyName], [FDefault], [FDefaultType], [FValueType], [FAddStrLeft], [FFormatString], [FAddStrRight], [FForbidStatus], [FFieldType],[FTSQL]) 
    
    VALUES 
    
    (@BillHeadName, NULL, N'userid_list', N'FCreatorId', @UserPhoneValue, NULL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'DeptId', N'FPurchaseDeptId', N'FDDeptId', @DefDeptId, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentFileServerURL', NULL, NULL, @AttachmentFileServerURL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentWeb', NULL, NULL, @AttachmentWeb, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'Y�l', N'FDescription', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�.U�~�~', N'FCreateOrgId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�S', N'FNumber', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�N�v�[a�', N'FPriceObject',NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'
    T�y', N'FName', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'uHe�e', N'FEffectiveDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'1YHe�e', N'FExpiryDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�^�S', N'Seq', NULL, NULL, NULL, N'double', NULL, N'0', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ir�ex', N'MaterialId', N'Number', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ir�e
    T�y', N'MaterialId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ĉ<h�W�S', N'MaterialId', N'Specification', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�N<h�|pe', N'PriceBase', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�N<h', N'Price', NULL, NULL, NULL, N'double', NULL, N'0.000000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'gNOP��N', N'DownPrice', NULL, NULL, NULL, N'double', NULL, N'0.000000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'uHe�eg', N'EffectiveDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'1YHe�eg', N'ExpiryDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'Y�l', N'Note', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    
    
    ------------------------------------------------------------------/****** Ǒ-��N�vh� ******/
    
    --select * from [dbo].GoldLink_Form_Values  where FTableName='t_PUR_PriceList'
    
    set @BillHeadName='t_PUR_PriceList';
    
    set @BillEntryName='FPriceListEntry';
    
    delete [dbo].GoldLink_Form_Values  where FTableName=@BillHeadName---USnc4Yh�
    T
    
    INSERT [dbo].GoldLink_Form_Values 
    
    ([FTableName], [FEntrName], [FDingFieldName], [FField], [FPropertyName], [FDefault], [FDefaultType], [FValueType], [FAddStrLeft], [FFormatString], [FAddStrRight], [FForbidStatus], [FFieldType],[FTSQL]) 
    
    VALUES 
    
    (@BillHeadName, NULL, N'userid_list', N'FCreatorId', @UserPhoneValue, NULL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'DeptId', N'FPurchaseDeptId', N'FDDeptId', @DefDeptId, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentFileServerURL', NULL, NULL, @AttachmentFileServerURL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentWeb', NULL, NULL, @AttachmentWeb, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'Y�l', N'FDescription', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'Ǒ-��~�~', N'FCreateOrgId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�O�^FU', N'FSupplierID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�S', N'FNumber', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�N�v�[a�', N'FPriceObject',NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'
    T�y', N'FName', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'uHe�e', N'FEffectiveDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'1YHe�e', N'FExpiryDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�^�S', N'Seq', NULL, NULL, NULL, N'double', NULL, N'0', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ir�ex', N'MaterialId', N'Number', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ir�e
    T�y', N'MaterialId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ĉ<h�W�S', N'MaterialId', N'Specification', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'US�N', N'Price', NULL, NULL, NULL, N'double', NULL, N'0.000000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'+TzUS�N', N'TaxPrice', NULL, NULL, NULL, N'double', NULL, N'0.000000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'z�s', N'TaxRate', NULL, NULL, NULL, N'double', NULL, N'0', N'%', 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'���NUSMO', N'UnitId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�N<h�|pe', N'Pricecoefficient', NULL, NULL, NULL, N'double', NULL, N'0.00', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�N<h
    NP�', N'UpPrice', NULL, NULL, NULL, N'double', NULL, N'0.000000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�N<hNP�', N'DownPrice', NULL, NULL, NULL, N'double', NULL, N'0.000000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'uHe�eg', N'EffectiveDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'1YHe�eg', N'ExpiryDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'Y�l', N'Note', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    set @DefDeptId=@tDeptId;
    
    
    
    ------------------------------------------------------------------/****** Ǒ-���Nh� ******/
    
    --select * from [dbo].GoldLink_Form_Values  where FTableName='T_PUR_PAT'
    
    set @BillHeadName='T_PUR_PAT';
    
    set @BillEntryName='FPUR_PATENTRY';
    
    delete [dbo].GoldLink_Form_Values  where FTableName=@BillHeadName---USnc4Yh�
    T
    
    INSERT [dbo].GoldLink_Form_Values 
    
    ([FTableName], [FEntrName], [FDingFieldName], [FField], [FPropertyName], [FDefault], [FDefaultType], [FValueType], [FAddStrLeft], [FFormatString], [FAddStrRight], [FForbidStatus], [FFieldType],[FTSQL]) 
    
    VALUES 
    
    (@BillHeadName, NULL, N'userid_list', N'FCreatorId', @UserPhoneValue, NULL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'DeptId', N'FPurchaseDeptId', N'FDDeptId', @DefDeptId, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentFileServerURL', NULL, NULL, @AttachmentFileServerURL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentWeb', NULL, NULL, @AttachmentWeb, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'Ǒ-��~�~', N'FPurchaseOrgId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'USnc�S', N'FBillNo', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'
    T�y', N'FName', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�eg', N'FDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'��N�S�V', N'FPaReason', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�c�', N'FDescription', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�^�S', N'Seq', NULL, NULL, NULL, N'double', NULL, N'0', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'��N{|�W', N'AdjustType', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'�N�vh�', N'PriceListId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�O�^FU', N'SupplierId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'^+R', N'CurrencyId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'��N�[a�', N'PricelistObject', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ir�ex', N'MaterialId', N'Number', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ir�e
    T�y', N'MaterialId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ĉ<h�W�S', N'MaterialId', N'Specification', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'���NUSMO', N'UnitID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�N', N'FROMQTY', NULL, NULL, NULL, N'double', NULL, N'0.000000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�', N'ToQty', NULL, NULL, NULL, N'double', NULL, N'0.000000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�MRUS�N', N'BeforePrice', NULL, NULL, NULL, N'double', NULL, N'0.000000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�TUS�N', N'AfterPrice', NULL, NULL, NULL, N'double', NULL, N'0.000000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�MR+TzUS�N', N'BeforeTaxPrice', NULL, NULL, NULL, N'double', NULL, N'0.000000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�T+TzUS�N', N'AfterTaxPrice', NULL, NULL, NULL, N'double', NULL, N'0.000000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'��NE^�^', N'AdjustRange', NULL, NULL, NULL, N'double', NULL, N'0.00', N'%', 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�N<h
    NP�', N'UpPrice', NULL, NULL, NULL, N'double', NULL, N'0.000000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�N<hNP�', N'DownPrice', NULL, NULL, NULL, N'double', NULL, N'0.000000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'uHe�eg', N'EffectiveDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'1YHe�eg', N'ExpiryDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'Y�l', N'Note', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    
    
    
    
    ------------------------------------------------------------------/****** ybϑ��NUS��.U	� ******/
    
    --select * from [dbo].GoldLink_Form_Values  where FTableName='T_SAL_BATCHADJUST'
    
    set @BillHeadName='T_SAL_BATCHADJUST';
    
    set @BillEntryName='FBATCHADJUSTENTRY';
    
    delete [dbo].GoldLink_Form_Values  where FTableName=@BillHeadName---USnc4Yh�
    T
    
    INSERT [dbo].GoldLink_Form_Values 
    
    ([FTableName], [FEntrName], [FDingFieldName], [FField], [FPropertyName], [FDefault], [FDefaultType], [FValueType], [FAddStrLeft], [FFormatString], [FAddStrRight], [FForbidStatus], [FFieldType],[FTSQL]) 
    
    VALUES 
    
    (@BillHeadName, NULL, N'userid_list', N'FCreatorId', @UserPhoneValue, NULL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'DeptId', N'FPurchaseDeptId', N'FDDeptId', @DefDeptId, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentFileServerURL', NULL, NULL, @AttachmentFileServerURL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentWeb', NULL, NULL, @AttachmentWeb, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'�.U�~�~', N'FSaleOrgId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'USnc�S', N'FBillNo', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'yb�
    T�y', N'FName', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�eg', N'FDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'��RuHe�eg', N'FDatetime', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�c�', N'FDescription', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�^�S', N'Seq', NULL, NULL, NULL, N'double', NULL, N'0', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'��N{|�W', N'AdjustType', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�N�vh�', N'PriceListId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'^+R', N'CurrencyId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�N�v�[a�', N'PriceObject', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ir�ex', N'MaterialId', N'Number', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ir�e
    T�y', N'MaterialId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ĉ<h�W�S', N'MaterialId', N'Specification', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'���NUSMO', N'MatUnitId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'yb�S', N'Lot', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�MR�', N'ToQty', NULL, NULL, NULL, N'double', NULL, N'0.000000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�T�', N'AfterToQty', NULL, NULL, NULL, N'double', NULL, N'0.000000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'��NE^�^', N'ADJUSTRANGE', NULL, NULL, NULL, N'double', NULL, N'0.00', N'%', 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�MRUS�N', N'BeforePrice', NULL, NULL, NULL, N'double', NULL, N'0.000000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�TUS�N', N'AfterPrice', NULL, NULL, NULL, N'double', NULL, N'0.000000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�MRgNOP��N', N'BeforeDownPrice', NULL, NULL, NULL, N'double', NULL, N'0.000000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�TgNOP��N', N'AfterDownPrice', NULL, NULL, NULL, N'double', NULL, N'0.000000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�MRuHe�e', N'BeforeEffDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�TuHe�e', N'AfterEffDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�MR1YHe�e', N'BeforeUnEffDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�T1YHe�e', N'AfterUnEffDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'1YHe', N'UnEffective', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    
    
    
    
    
    
    ------------------------------------------------------------------/****** �v�vUS ******/
    
    --select * from [dbo].GoldLink_Form_Values  where FTableName='T_STK_STKCOUNTGAIN'
    
    set @BillHeadName='T_STK_STKCOUNTGAIN';
    
    set @BillEntryName='FBillEntry';
    
    delete [dbo].GoldLink_Form_Values  where FTableName=@BillHeadName
    
    INSERT [dbo].GoldLink_Form_Values 
    
    ([FTableName], [FEntrName], [FDingFieldName], [FField], [FPropertyName], [FDefault], [FDefaultType], [FValueType], [FAddStrLeft], [FFormatString], [FAddStrRight], [FForbidStatus], [FFieldType],[FTSQL]) 
    
    VALUES 
    
    (@BillHeadName, NULL, N'userid_list', N'FCreatorId', @UserPhoneValue, NULL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'DeptId', N'FDeptId', N'FDDeptId', @DefDeptId, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentFileServerURL', NULL, NULL, @AttachmentFileServerURL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentWeb', NULL, NULL, @AttachmentWeb, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'@b(W��', N'FDeptId', N'FDDeptId', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'USnc�S', N'FNumber', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�eg', N'FDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'USnc{|�W', N'FBILLTYPEID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�^X[�~�~', N'FStockOrgId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'��', N'FDeptId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�N�{XT', N'FStockerId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�^X[�~', N'FStockerGroupId', N'Description', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'Y�l', N'FNoteHead', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�^�S', N'Seq', NULL, NULL, NULL, N'double', NULL, N'0', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ir�ex', N'MaterialId', N'Number', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ir�e
    T�y', N'MaterialId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ĉ<h�W�S', N'MaterialId', N'Specification', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'USMO', N'UnitID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'&�X[peϑ', N'AcctQty', NULL, NULL, NULL, N'double', NULL, N'0.0000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�v�ppeϑ', N'CountQty', NULL, NULL, NULL, N'double', NULL, N'0.0000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�v�vpeϑ', N'GainQty', NULL, NULL, NULL, N'double', NULL, N'0.0000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�N�^', N'StockId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'�NMO', N'StockLocId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'yb�S', N'LOT', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'�O(�g', N'ExpPeriod', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'�O(�gUSMO', N'ExpUnit', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'0Rg�e', N'ExpiryDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'Y�l', N'note', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    
    
    
    
    ------------------------------------------------------------------/****** �v�NUS ******/
    
    --select * from [dbo].GoldLink_Form_Values  where FTableName='T_STK_STKCOUNTLOSS'
    
    set @BillHeadName='T_STK_STKCOUNTLOSS';
    
    set @BillEntryName='FBillEntry';
    
    delete [dbo].GoldLink_Form_Values  where FTableName=@BillHeadName
    
    INSERT [dbo].GoldLink_Form_Values 
    
    ([FTableName], [FEntrName], [FDingFieldName], [FField], [FPropertyName], [FDefault], [FDefaultType], [FValueType], [FAddStrLeft], [FFormatString], [FAddStrRight], [FForbidStatus], [FFieldType],[FTSQL]) 
    
    VALUES 
    
    (@BillHeadName, NULL, N'userid_list', N'FCreatorId', @UserPhoneValue, NULL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'DeptId', N'FDeptId', N'FDDeptId', @DefDeptId, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentFileServerURL', NULL, NULL, @AttachmentFileServerURL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentWeb', NULL, NULL, @AttachmentWeb, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'@b(W��', N'FDeptId', N'FDDeptId', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'USnc�S', N'FNumber', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�eg', N'FDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'USnc{|�W', N'FBILLTYPEID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�^X[�~�~', N'FStockOrgId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'��', N'FDeptId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�N�{XT', N'FStockerId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�^X[�~', N'FStockerGroupId', N'Description', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'Y�l', N'FNoteHead', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�^�S', N'Seq', NULL, NULL, NULL, N'double', NULL, N'0', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ir�ex', N'MaterialId', N'Number', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ir�e
    T�y', N'MaterialId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ĉ<h�W�S', N'MaterialId', N'Specification', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'USMO', N'UnitID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'&�X[peϑ', N'AcctQty', NULL, NULL, NULL, N'double', NULL, N'0.0000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�v�ppeϑ', N'CountQty', NULL, NULL, NULL, N'double', NULL, N'0.0000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�v�Npeϑ', N'LossQty', NULL, NULL, NULL, N'double', NULL, N'0.0000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�N�^', N'StockId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'�NMO', N'StockLocId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'yb�S', N'LOT', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'0Rg�e', N'ExpiryDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'Y�l', N'note', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    
    
    
    
    
    
    ------------------------------------------------------------------/****** vQ�N�Q�^US ******/
    
    --select * from [dbo].GoldLink_Form_Values  where FTableName='T_STK_MISDELIVERY'
    
    set @BillHeadName='T_STK_MISDELIVERY';
    
    set @BillEntryName='FEntity';
    
    delete [dbo].GoldLink_Form_Values  where FTableName=@BillHeadName
    
    INSERT [dbo].GoldLink_Form_Values 
    
    ([FTableName], [FEntrName], [FDingFieldName], [FField], [FPropertyName], [FDefault], [FDefaultType], [FValueType], [FAddStrLeft], [FFormatString], [FAddStrRight], [FForbidStatus], [FFieldType],[FTSQL]) 
    
    VALUES 
    
    (@BillHeadName, NULL, N'userid_list', N'FCreatorId', @UserPhoneValue, NULL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'DeptId', N'FDeptId', N'FDDeptId', @DefDeptId, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentFileServerURL', NULL, NULL, @AttachmentFileServerURL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentWeb', NULL, NULL, @AttachmentWeb, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'@b(W��', N'FDeptId', N'FDDeptId', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'USnc�S', N'FNumber', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�eg', N'FDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'USnc{|�W', N'FBILLTYPEID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�^X[�~�~', N'FStockOrgId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�[7b', N'FCustId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'���e��', N'FDeptId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�N�{XT', N'FStockerId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'���e�N', N'FPickerId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�^X[�~', N'FStockerGroupId', N'Description', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'Y�l', N'FNote', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�^�S', N'Seq', NULL, NULL, NULL, N'double', NULL, N'0', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ir�ex', N'MaterialId', N'Number', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ir�e
    T�y', N'MaterialId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ĉ<h�W�S', N'MaterialId', N'Specification', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'USMO', N'UnitID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�[�Speϑ', N'Qty', NULL, NULL, NULL, N'double', NULL, N'0.0000', NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'sS�e�^X[', N'F_ora_Qty', NULL, NULL, NULL, N'double', NULL, N'0.0000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�S'��N�^', N'StockId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'�NMO', N'StockLocId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'yb�S', N'LOT', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'Y�l', N'EntryNote', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    
    
    
    
    ------------------------------------------------------------------/****** vQ�NeQ�^US ******/
    
    --select * from [dbo].GoldLink_Form_Values  where FTableName='T_STK_MISCELLANEOUS'
    
    set @BillHeadName='T_STK_MISCELLANEOUS';
    
    set @BillEntryName='FEntity';
    
    delete [dbo].GoldLink_Form_Values  where FTableName=@BillHeadName
    
    INSERT [dbo].GoldLink_Form_Values 
    
    ([FTableName], [FEntrName], [FDingFieldName], [FField], [FPropertyName], [FDefault], [FDefaultType], [FValueType], [FAddStrLeft], [FFormatString], [FAddStrRight], [FForbidStatus], [FFieldType],[FTSQL]) 
    
    VALUES 
    
    (@BillHeadName, NULL, N'userid_list', N'FCreatorId', @UserPhoneValue, NULL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'DeptId', N'FDeptId', N'FDDeptId', @DefDeptId, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentFileServerURL', NULL, NULL, @AttachmentFileServerURL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentWeb', NULL, NULL, @AttachmentWeb, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'@b(W��', N'FDeptId', N'FDDeptId', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'USnc�S', N'FNumber', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�eg', N'FDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'USnc{|�W', N'FBILLTYPEID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�^X[�~�~', N'FStockOrgId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�O�^FU', N'FSUPPLIERID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'��', N'FDeptId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�N�{XT', N'FStockerId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'��6eXT', N'FACCEPTANCE', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�^X[�~', N'FStockerGroupId', N'Description', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'Y�l', N'FNote', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�^�S', N'Seq', NULL, NULL, NULL, N'double', NULL, N'0', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ir�ex', N'MaterialId', N'Number', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ir�e
    T�y', N'MaterialId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ĉ<h�W�S', N'MaterialId', N'Specification', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'N�]�^', N'PROCESSID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'USMO', N'FUnitID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�[6epeϑ', N'FQty', NULL, NULL, NULL, N'double', NULL, N'0.0000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'sS�e�^X[', N'InvQty', NULL, NULL, NULL, N'double', NULL, N'0.0000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'6e'��N�^', N'FSTOCKID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'�NMO', N'StockLocId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'yb�S', N'Lot', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'Y�l', N'EntryNote', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    
    
    
    
    ------------------------------------------------------------------/****** ir�e ******/
    
    --select * from [dbo].GoldLink_Form_Values  where FTableName='T_BD_MATERIAL'
    
    set @BillHeadName='T_BD_MATERIAL';
    
    set @BillEntryName='SubHeadEntity1';
    
    set @DefDeptId='-1';
    
    delete [dbo].GoldLink_Form_Values  where FTableName=@BillHeadName
    
    INSERT [dbo].GoldLink_Form_Values 
    
    ([FTableName], [FEntrName], [FDingFieldName], [FField], [FPropertyName], [FDefault], [FDefaultType], [FValueType], [FAddStrLeft], [FFormatString], [FAddStrRight], [FForbidStatus], [FFieldType],[FTSQL]) 
    
    VALUES 
    
    (@BillHeadName, NULL, N'userid_list', N'FCreatorId', @UserPhoneValue, NULL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'DeptId', N'FSaleDeptId', N'FDDeptId', @DefDeptId, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentFileServerURL', NULL, NULL, @AttachmentFileServerURL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentWeb', NULL, NULL, @AttachmentWeb, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'R�^�~�~', N'FCreateOrgId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'O(u�~�~', N'FUseOrgId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'x', N'FNumber', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'
    T�y', N'FName', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'ĉ<h�W�S', N'FSpecification', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�c�', N'FDescription', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'ir�eR�~', N'FMaterialGroup', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'ir�e^\'`', N'FErpClsID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�W,gUSMO', N'FBaseUnitId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    
    
    ,(@BillHeadName, NULL, N'AQ��Ǒ-�', N'FIsPurchase', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'AQ���.U', N'FIsSale', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'AQ���^X[', N'FIsInventory', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'AQ��u�N', N'FIsProduce', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'AQ���YY', N'FIsSubContract', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'AQ��l�D��N', N'FIsAsset', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'sS�e8h�{', N'FIsRealTimeAccout', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    
    
    ,(@BillHeadName, NULL, N'؞��z�s', N'FTaxRateId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'X['�{|+R', N'FCategoryID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�^X[USMO', N'FStoreUnitID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�N�^', N'FStockId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'/T(uyb�S�{t', N'FIsBatchManage', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'yb�SxĉR', N'FBatchRuleID', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'/T(u�O(�g�{t', N'FIsKFPeriod', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'g\�^X[��f�', N'FIsEnableMinStock', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�[hQ�^X[��f�', N'FIsEnableSafeStock', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'g'Y�^X[��f�', N'FIsEnableMaxStock', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�Q��'��p��f�', N'FIsEnableReOrder', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�[hQ�^X[', N'FSafeStock', NULL, NULL, NULL, N'double', NULL, N'0.000000', NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'g\�^X[', N'FMinStock', NULL, NULL, NULL, N'double', NULL, N'0.000000', NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'g'Y�^X[', N'FMaxStock', NULL, NULL, NULL, N'double', NULL, N'0.000000', NULL, 0, null,null)
    
    
    
    
    
    
    
    
    
    ------------------------------------------------------------------/****** �{USu�NeQ�^US ******/
    
    --select * from [dbo].GoldLink_Form_Values  where FTableName='T_SP_INSTOCK'
    
    set @BillHeadName='T_SP_INSTOCK';
    
    set @BillEntryName='FEntity';
    
    delete [dbo].GoldLink_Form_Values  where FTableName=@BillHeadName
    
    INSERT [dbo].GoldLink_Form_Values 
    
    ([FTableName], [FEntrName], [FDingFieldName], [FField], [FPropertyName], [FDefault], [FDefaultType], [FValueType], [FAddStrLeft], [FFormatString], [FAddStrRight], [FForbidStatus], [FFieldType],[FTSQL]) 
    
    VALUES 
    
    (@BillHeadName, NULL, N'userid_list', N'FCreatorId', @UserPhoneValue, NULL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'DeptId', N'', N'', @DefDeptId, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentFileServerURL', NULL, NULL, @AttachmentFileServerURL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentWeb', NULL, NULL, @AttachmentWeb, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    --,(@BillHeadName, NULL, N'@b(W��', N'FDeptId', N'FDDeptId', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'USnc�S', N'FBillNo', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�eg', N'FDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'USnc{|�W', N'FBillType', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'eQ�^�~�~', N'FStockOrgId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'u�N�~�~', N'FPrdOrgId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'�O�^FU', N'FSUPPLIERID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'��', N'FDeptId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�N�{XT', N'FStockerId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�^X[�~', N'FStockerGroupId', N'Description', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'�^X[�~', N'FStockerGroupId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'Y�l', N'FDescription', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�^�S', N'Seq', NULL, NULL, NULL, N'double', NULL, N'0', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ir�ex', N'MaterialId', N'Number', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ir�e
    T�y', N'MaterialId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ĉ<h�W�S', N'MaterialId', N'Specification', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'USMO', N'FUnitID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�^6epeϑ', N'MustQty', NULL, NULL, NULL, N'double', NULL, N'0.0000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�[6epeϑ', N'RealQty', NULL, NULL, NULL, N'double', NULL, N'0.0000', NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'sS�e�^X[', N'InvQty', NULL, NULL, NULL, N'double', NULL, N'0.0000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�N�^', N'StockId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'�NMO', N'StockLocId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'u�Nf��', N'WorkShopId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�s�~', N'ShiftGroupId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'u�Nf��', N'WorkShopId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'u�N�S', N'ProductNo', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'yb�S', N'Lot', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'Y�l', N'Memo', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    
    
    ,(@BillHeadName, @BillEntryName, N'�S'�0W�p', N'F_ora_Combo',N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)----Name/Value
    
    ,(@BillHeadName, @BillEntryName, N'eQ�^{|�W', N'InStockType',N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)----Name/Value
    
    ,(@BillHeadName, @BillEntryName, N'N�]�^', N'PROCESSID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'#��Nf��', N'DeptId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�N�T6��k', N'F_ora_Text', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�S'�0W', N'F_ora_Text1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    
    
    --,(@BillHeadName, @BillEntryName, N'�O�^FU', N'FSUPPLIERID', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    
    
    
    
    
    
    ------------------------------------------------------------------/****** �{USu�N���eUS ******/
    
    --select * from [dbo].GoldLink_Form_Values  where FTableName='T_SP_PICKMTRL'
    
    set @BillHeadName='T_SP_PICKMTRL';
    
    set @BillEntryName='FEntity';
    
    delete [dbo].GoldLink_Form_Values  where FTableName=@BillHeadName
    
    INSERT [dbo].GoldLink_Form_Values 
    
    ([FTableName], [FEntrName], [FDingFieldName], [FField], [FPropertyName], [FDefault], [FDefaultType], [FValueType], [FAddStrLeft], [FFormatString], [FAddStrRight], [FForbidStatus], [FFieldType],[FTSQL]) 
    
    VALUES 
    
    (@BillHeadName, NULL, N'userid_list', N'FCreatorId', @UserPhoneValue, NULL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'DeptId', N'FDeptId', N'', @DefDeptId, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentFileServerURL', NULL, NULL, @AttachmentFileServerURL, NULL, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    ,(@BillHeadName, NULL, N'AttachmentWeb', NULL, NULL, @AttachmentWeb, 0, NULL, NULL, NULL, NULL, 0, @Sys,NULL)
    
    --,(@BillHeadName, NULL, N'@b(W��', N'FDeptId', N'FDDeptId', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'USnc�S', N'FBillNo', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�eg', N'FDate', NULL, NULL, NULL, N'DateTime', NULL, N'D', NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'USnc{|�W', N'FBillType', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�S�e�~�~', N'FStockOrgId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'�[7b', N'FCustId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, NULL, N'���e��', N'FDeptId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�^X[�~', N'FStockerGroupId', N'Description', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'�N�{XT', N'FStockerId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'���e�N', N'FPickerId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, NULL, N'Y�l', N'FDescription', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�^�S', N'Seq', NULL, NULL, NULL, N'double', NULL, N'0', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ir�ex', N'MaterialId', N'Number', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ir�e
    T�y', N'MaterialId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'ĉ<h�W�S', N'MaterialId', N'Specification', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'USMO', N'UnitId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'3u��peϑ', N'AppQty', NULL, NULL, NULL, N'double', NULL, N'0.0000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�[�Speϑ', N'ActualQty', NULL, NULL, NULL, N'double', NULL, N'0.0000', NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'sS�e�^X[', N'F_ora_Qty', NULL, NULL, NULL, N'double', NULL, N'0.0000', NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�N�^', N'StockId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    --,(@BillHeadName, @BillEntryName, N'�NMO', N'StockLocId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'yb�S', N'LOT', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'Y�l', N'Memo', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'u�N�[a�', N'ProductId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'u�N�S', N'ProductNo', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    
    
    ,(@BillHeadName, @BillEntryName, N'#��Nf��', N'F_ora_Base', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'
    No�:w�', N'F_ora_Base1', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'�^X[�r`', N'StockStatusId', N'Name', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    ,(@BillHeadName, @BillEntryName, N'���e(u�', N'F_Gold_Assistant', N'FDataValue ', NULL, NULL, NULL, NULL, NULL, NULL, 0, null,null)
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    

    Powered by kodbox V1.59

    Copyright © kodcloud.com.

    Files