Skip to main content

DBO function to return account taxability from account id and country

DBO.EQ_STD_ACCOUNT_TAXABILITY_GET(Parameter1, Parameter2, Parameter3) This function will accept Account ID, Country Code, and/or Country as parameters.  It will return the Account Taxability for an Ac

Updated over 2 weeks ago

DBO.EQ_STD_ACCOUNT_TAXABILITY_GET(Parameter1, Parameter2, Parameter3)

This function will accept Account ID, Country Code, and/or Country as parameters. It will return the Account Taxability for an Account based on the Country, which is pulled from the Account Taxability by Country screen.

Parameter(s)

Parameter1: [Account: ID] - this is the system generated Account ID used to point to an Account. The 'Account' table must be included in the User Report Type since this required parameter is from that table.

Parameter2: 3 character ISO Country Code or NULL

Parameter3: Country Name or NULL

Example(s)

Example 1: Return the Account Taxability for an Account based on the 3 Letter ISO Country Code, which is pulled from the Account Taxability by Country screen.

  • DBO.EQ_STD_ACCOUNT_TAXABILITY_GET([Account: ID], [Assignment Derived Calculations: To Country Code (3 char)], NULL)

Example 2: Return the Account Taxability for an Account based on the Country Name, which is pulled from the Account Taxability by Country screen.

  • DBO.EQ_STD_ACCOUNT_TAXABILITY_GET([Account: ID], NULL, [Assignment: To Country])

Example of field output

mceclip0.png

Account Taxability by Country screen

mceclip1.png

Did this answer your question?