SityDB Translog transaction type Excel formula
=IF(AND(F3=0, G3=10, H3=0), "Credit Card", IF(AND(G3=10,F3=7, H3=0),"Failed CC Transaction",IF(AND(G3=1,F3=0, H3=0), "Coin",IF(AND(G3=1, F3=3, H3=0), "Cash Out",IF(AND(F3=0,G3=1,
Where:
F3 = tlRecordType
G3 = tlPaymentType
H3 = tlUserType