TIMSS 6: FAR TXN_TYPE_CODEs

When a transaction is inserted into the FAR_TXN table it will have a TXN_TYPE_CODE. Some of the codes are the same in TIMSS 5 & TIMSS 6, but some new ones have been added.

Here is what they mean in TIMSS 6:

1 - Receipt: a payment
2 - Voucher: a refund (credit card or check)
3 - Transfer: funds moved from one order to another
4 - Sale: prodcut price that a customer is billed
5 - Writeoff: left over amount you aren't asking the customer to pay
6 - Adjustment: Adjustment/Cancelation fees with real dollar amounts
7 - Revenue Recognition: generated by the FAR670 process
8 - Memo: $0 but notes adjustments
9 - Deferred Receipt : future payments
0 - “Non-Receivable”
J - Journal Entry: done on FAR003J-Advanced Adjustments

Note that these are characters not numbers because of the J. If you are using this column in queries and are comparing it with numbers it will work, until you have a J somewhere in the column. Then you will get an error when comparing a number to a character.

Applies to: TIMSS6