业务伙伴主数据-常规

已将对应字段和导入代码对应，直接复制表即可导入，注意删除第一行标题

• 示例代码

SELECT N'CardCode' AS '业务伙伴代码', N'CardName' AS '业务伙伴名称', N'CardType' AS '业务伙伴类型', N'GroupCode' AS '组代码', N'Currency' AS '业务伙伴货币'
	, N'FederalTaxID' AS '国税编号', N'Phone1' AS '电话 1', N'Phone2' AS '电话 2', N'Cellular' AS '移动电话', N'EmailAddress' AS '电子邮件'
	, N'UnifiedFederalTaxID' AS '唯一国税编号'
UNION ALL
SELECT N'业务伙伴代码', N'业务伙伴名称', N'业务伙伴类型', N'组代码', N'业务伙伴货币'
	, N'国税编号', N'电话 1', N'电话 2', N'移动电话', N'电子邮件'
	, N'唯一国税编号'
UNION ALL
SELECT T0.[CardCode], T0.[CardName], T0.[CardType], CAST(T0.[GroupCode] AS nvarchar), T0.[Currency]
	, T0.[LicTradNum], T0.[Phone1], T0.[Phone2], T0.[Cellular], T0.[E_Mail]
	, T0.[VatIdUnCmp]
FROM OCRD T0