Monthly Archives: September 2009

2 Finding the value of the state and status codes

If you’ve ever wondered how to find the values for the statecode and statuscode, you can use the following SQL script to find those values: select AttributeName, AttributeValue, Value from dbo.StringMap where (dbo.StringMap.AttributeName = ‘statuscode’ or dbo.StringMap.AttributeName = ‘statecode’) and dbo.StringMap.ObjectTypeCode = 1 Will display the following values for the Account Entity ( ObjectTypeCode = […]

Continue reading