[Feature] Clarify transaction_detail documentation and include non converted amount field.

[fivetran-joemarkiewicz]

Is there an existing feature request for this?

• I have searched the existing issues

Describe the Feature

Currently the netsuite(2)__transaction_detail end model doesn't explicitly inform that the following fields are converted for seamless financial statement generation:

• converted_amount
• transaction_amount
• transaction_line_amount

For example, the above fields are adjusted to ensure the inverse value is provided when the account type is income or othincome. This is great for easier financial statement generation. However, this could cause confusion for users that expect these values to retain the original value set by Netsuite.

As such, we should clarify the intended use of the transaction_detail models as include three new fields for the above stated ones which do not apply additional conversions so users may have an accurate map back to the source value if desired.

How would you implement this feature?

1. Update the end model description to detail that intended use case of the transaction_detail end model. A log of each transaction prepared for financial statement reporting and not necessarily to recreate a double entry general ledger.
2. Add three new amount fields to the transaction_detail end model for the above mentioned fields that specify the amounts before converted.

Describe alternatives you've considered

No response

Are you interested in contributing this feature?

• Yes.
• Yes, but I will need assistance.
• No.

Anything else?

No response