用友U9C账簿表查询

--U9账簿查询：

SELECT

B.[ID] AS [ID],

B.[SysVersion] AS [SysVersion],

B.[OrgFunction] AS [OrgFunction],

B.[Code] AS [Code],

B1.[Name] AS [Name],

B.[SOBType] AS [SOBType],

B3.[Name] AS [AccountingStandard_Name],

B5.[Name] AS [AccountCalendar_Name],

B7.[Name] AS [FunctionalCurrency_Name],

B.[DefaultExRateType] AS [DefaultExRateType],

B9.[Name] AS [AccountStructure_Name]

FROM

Base_SetofBooks AS B

LEFT JOIN [Base_SetofBooks_Trl] AS B1 ON (B1.SysMlFlag = 'zh-CN') AND (B.[ID] = B1.[ID])

LEFT JOIN [Base_AccountStandard] AS B2 ON (B.[AccountingStandard] = B2.[ID])

LEFT JOIN [Base_AccountStandard_Trl] AS B3 ON (B3.SysMlFlag = 'zh-CN') AND (B2.[ID] = B3.[ID])

LEFT JOIN [Base_AccountCalendar] AS B4 ON (B.[AccountCalendar] = B4.[ID])

LEFT JOIN [Base_AccountCalendar_Trl] AS B5 ON (B5.SysMlFlag = 'zh-CN') AND (B4.[ID] = B5.[ID])

LEFT JOIN [Base_Currency] AS B6 ON (B.[FunctionalCurrency] = B6.[ID])

LEFT JOIN [Base_Currency_Trl] AS B7 ON (B7.SysMlFlag = 'zh-CN') AND (B6.[ID] = B7.[ID])

LEFT JOIN [Base_KeyFlexFieldStru] AS B8 ON (B.[AccountStructure] = B8.[ID])

LEFT JOIN [Base_KeyFlexFieldStru_Trl] AS B9 ON (B9.SysMlFlag = 'zh-CN') AND (B8.[ID] = B9.[ID])

WHERE ((B.[Code] = N'1001') AND (B.[Org] = 1002109246703048))