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 = 1 ):
AttributeName | AttributeValue | Value |
statecode |
0 |
Active |
statecode |
1 |
Inactive |
statuscode |
1 |
Active |
statuscode |
2 |
Inactive |