Account Type Rule = Credit or?

Hi @emre

Is there any way to determine what this value is below during automation?

Reasoning:
My “Fast Payment” buttons that execute Payments using Entity Account will need to determine if the Account Type allows CREDIT/DEBIT/DEFAULT and I also need to determine if Entity has been set a Credit Limit!?

State Flow: Enable Fast Payment Account IF:
CREDIT then Ticket Total <= Credit Limit (if set) + Entity Type Account Balance
DEFAULT then ignore Credit Limit (if set)

I note Emre your internal “hidden gem” custom field = “Credit Limit” only works of Account Type = CREDIT, correct? Duh makes sense.

Your thoughts on how to determine Account Type Rule: Value…?
Thanks.

Get it from the DB …

SELECT
[Id]
,[Name]
,[DefaultFilterType]
,CASE [DefaultFilterType]
 WHEN 0 THEN 'All'
 WHEN 1 THEN 'Month'
 WHEN 2 THEN 'Week'
 WHEN 3 THEN 'Workperiod'
 END as [AccountFilter]
,[WorkingRule]
,CASE [WorkingRule]
 WHEN 0 THEN 'Default'
 WHEN 1 THEN 'Debit'
 WHEN 2 THEN 'Credit'
 END as [AccountRule]
,[Tags]
,[SortOrder]
FROM [AccountTypes]
WHERE 1=1
-- AND [Name] = '(Account Name)'
ORDER BY [Name]
1 Like

OR, or I could get it from the DB… :grinning: oh Hi and thanks Q.

I always out put these things out there as you get know @emre could come back and say “oh yea we have this thing you can do…”