2. 金数创建金蝶钉钉审批单据字段映射.sql - 金蝶钉钉审批插件SQL（GoldLink） - Kodbox

Position: 金蝶钉钉审批插件SQL（GoldLink） / 2. 金数创建金蝶钉钉审批单据字段映射.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)





------------------------------------------------------------------/****** �.UTT ******/

--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'TT
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'TT	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'TT{|�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)
Powered by kodbox V1.55

Copyright © kodcloud.com.

Files
