Feature: Add locations passthrough column functionality to transaction details

[fivetran-avinash]

PR Overview

This PR will address the following Issue/Feature: [#123]

This PR will result in the following new package version:

A column is being added to netsuite2__transaction_details.

Regardless, this is likely to be folded into a larger release branch with additional updates.

Please provide the finalized CHANGELOG entry which details the relevant changes included in this PR:

🚨 Breaking Changes 🚨

• Added the column location_id to the netsuite2__transaction_details model. To bring this column in, a --full-refresh after upgrading is required. (PR #125)

Features

• Addition of the location_pass_through_columns feature in the netsuite2__transaction_details model--consult the README for more details on how to passthrough additional fields. (PR #125)

Under the Hood

• Added a consistency test for the netsuite2__transaction_details model. (PR #125)

PR Checklist

Basic Validation

Please acknowledge that you have successfully performed the following commands locally:

• [x] dbt run –full-refresh && dbt test
• [x] dbt run (if incremental models are present)

Before marking this PR as "ready for review" the following have been applied:

• [x] The appropriate issue has been linked, tagged, and properly assigned
• [x] All necessary documentation and version upgrades have been applied
• [x] docs were regenerated (unless this PR does not include any code or yml updates)
• [ ] BuildKite integration tests are passing
• [x] Detailed validation steps have been provided below

Detailed Validation

Please share any and all of your validation steps:

Able to successfully pass through location columns.

Simple consistency test added on transaction details, run on devprod. We do an except(location_id) filter to compare dev and prod rows right now.