用友U9C账簿表查询

--U9账簿查询SELECTB.[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]FROMBase_SetofBooks AS BLEFT 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] N1001) AND (B.[Org] 1002109246703048))