This PR will address the following Issue/Feature: #107
This PR will result in the following new package version: 13.0 (will be folded into wider release branch)
A lot of updates will be added here that will significantly revamp the package.
Please provide the finalized CHANGELOG entry which details the relevant changes included in this PR:
🚨 Breaking Changes 🚨
Creates hierarchical strings for GL accounts (account_display_full_name) and accounting periods (accounting_period_full_name) that are then presented into the end models.
Feature Updates
Added the following fields to support hierarchy data:
All three models: Added subsidiary_full_name (full hierarchical subsidiary name) and account_display_name (account display name).
netsuite2__transaction_details: Added department_full_name (full hierarchical department name), exchange_rate (exchange rate on accounting line), is_eliminate (boolean to indicate automatic elimination), subsidiary_currency_symbol (base currency of subsidiary), transaction_line_amount (net amount of transaction line).
PR Checklist
Basic Validation
Please acknowledge that you have successfully performed the following commands locally:
[x] dbt run –full-refresh && dbt test
[NA] 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)
[x] BuildKite integration tests are passing
[x] Detailed validation steps have been provided below
Detailed Validation
Please share any and all of your validation steps: See Height ticket
PR Overview
This PR will address the following Issue/Feature: #107
This PR will result in the following new package version: 13.0 (will be folded into wider release branch)
A lot of updates will be added here that will significantly revamp the package.
Please provide the finalized CHANGELOG entry which details the relevant changes included in this PR:
🚨 Breaking Changes 🚨
account_display_full_name
) and accounting periods (accounting_period_full_name
) that are then presented into the end models.Feature Updates
subsidiary_full_name
(full hierarchical subsidiary name) andaccount_display_name
(account display name).netsuite2__transaction_details
: Addeddepartment_full_name
(full hierarchical department name),exchange_rate
(exchange rate on accounting line),is_eliminate
(boolean to indicate automatic elimination),subsidiary_currency_symbol
(base currency of subsidiary),transaction_line_amount
(net amount of transaction line).PR Checklist
Basic Validation
Please acknowledge that you have successfully performed the following commands locally:
Before marking this PR as "ready for review" the following have been applied:
Detailed Validation
Please share any and all of your validation steps: See Height ticket