stg_quickbooks.yml

version: 2

models:
  - name: stg_quickbooks__account
    description: "{{ doc('account_table') }}"  
    tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - account_id
            - source_relation
    columns:
      - name: account_id
        description: Unique identifier for an account.
        tests: 
          - not_null
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: account_number
        description: User-defined account number intended to identify the account within the Chart of Accounts.
      - name: is_sub_account
        description: Specifies whether this object represents a parent (false) or a sub_account (true).
      - name: parent_account_id
        description: User entered description for the account.
      - name: name
        description: User recognizable name for the Account.
      - name: account_type
        description: A detailed account classification that specifies the use of this account. The type is based on the Classification.
      - name: is_active
        description: Boolean indicating whether an account is currently active.
      - name: account_sub_type
        description: The account sub-type classification and is based on the AccountType value.
      - name: classification
        description: The classification of an account. Not supported for non-posting accounts. Valid values include Asset, Equity, Expense, Liability, Revenue.
        tests:
          - accepted_values:
              values: ['Asset', 'Equity', 'Expense', 'Liability', 'Revenue']
      - name: created_at
        description: Timestamp of the date the account was created.
      - name: currency_id
        description: Reference to the currency which the account records the balance in.
      - name: description
        description: Description of the account.
      - name: fully_qualified_name
        description: Full name of the account.
      - name: balance
        description: Specifies the balance amount for the current Account.
      - name: balance_with_sub_accounts
        description: Specifies the balance amount for the current Account sub accounts.
      - name: updated_at
        description: Timestamp of the date which the account was last updated.

  - name: stg_quickbooks__address
    description: "{{ doc('address_table') }}"
    tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - address_id
            - source_relation
    columns:
      - name: address_id
        description: Unique identifier for an address.
        tests: 
          - not_null
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: city
        description: The city which the address is located.
      - name: country
        description: The country which the address is located.
      - name: address_1
        description: The address_line_1 associated with the address.
      - name: address_2
        description: The address_line_2 associated with the address (if applicable).
      - name: postal_code
        description: The postal code which the address is located.

  - name: stg_quickbooks__bill_line
    description: "{{ doc('bill_line_table') }}"  
    tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - bill_id
            - index
            - source_relation    
    columns:
      - name: bill_id
        description: "The {{ doc('id') }} parent bill record."
        tests:
          - not_null
      - name: index
        description: Bill line index in reference to the parent bill.
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: account_expense_class_id
        description: The class reference associated with the account based expense bill line.
      - name: account_expense_customer_id
        description: The customer reference associated with the account based expense bill line.
      - name: item_expense_item_id
        description: The item reference associated with the item based expense bill line.
      - name: item_expense_customer_id
        description: The customer reference associated with the item based expense bill line.
      - name: item_expense_billable_status
        description: The billable status of the item based expense bill line.
      - name: item_expense_class_id
        description: The class reference associated with the item based expense bill line.
      - name: account_expense_account_id
        description: The id of the account being expensed from the bill.
      - name: account_expense_billable_status
        description: The status of the bill line item expense.
      - name: account_expense_tax_code_id
        description: The tax code id associated with the bill.
      - name: amount
        description: Monetary amount of the bill line item.
      - name: description
        description: Description of the bill line item.

  - name: stg_quickbooks__bill_linked_txn
    description: "{{ doc('bill_linked_txn_table') }}"
    columns:
      - name: bill_id
        description: "The {{ doc('id') }} bill record."
        tests:
          - not_null
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: index
        description: Index count of records from a single bill record associated with payment ids.
      - name: bill_payment_id
        description: "The {{ doc('id') }} bill payment id record."

  - name: stg_quickbooks__bill_payment_line
    description: "{{ doc('bill_payment_line_table') }}"
    tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - bill_payment_id
            - index
            - source_relation    
    columns:
      - name: bill_payment_id
        description: "The {{ doc('id') }} bill payment record."
        tests:
          - not_null
      - name: index
        description: Index count of payments associated with the parent bill payment record.
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: amount
        description: Monetary amount of the bill payment.
      - name: bill_id
        description: "{{ doc('id') }} bill record associated with the bill payment."
      - name: deposit_id
        description: "{{ doc('id') }} deposit record associated with the bill payment."
      - name: expense_id
        description: "{{ doc('id') }} purchase record associated with the bill payment."
      - name: linked_bill_payment_id
        description: "{{ doc('id') }} bill record associated with the bill payment."
      - name: vendor_credit_id
        description: "{{ doc('id') }} vendor_credit record associated with the bill payment."
      - name: journal_entry_id
        description: "{{ doc('id') }} journal entry record associated with the bill payment."

  - name: stg_quickbooks__bill_payment
    description: "{{ doc('bill_payment_table') }}"
    tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - bill_payment_id
            - source_relation     
    columns:
      - name: bill_payment_id
        description: "{{ doc('id') }} bill payment."
        tests: 
          - not_null
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: check_bank_account_id
        description: Account id of the account which the bill payment is credited. Only applicable if bill payment `pay_type` is of type check.
      - name: check_print_status
        description: Status of the check which was used as payment for the bill. Only applicable if bill payment `pay_type` is of type Check.
      - name: credit_card_account_id
        description: Account id of the account which the bill is credited. Only applicable if bill payment `pay_type` is of type CreditCard.
      - name: exchange_rate
        description: The number of home currency units it takes to equal one unit of currency specified by CurrencyRef. Applicable if multicurrency is enabled for the company.
      - name: currency_id
        description: Reference to the currency in which all amounts on the associated transaction are expressed.
      - name: department_id
        description: Reference to a Department object specifying the location of the transaction.
      - name: pay_type
        description: The payment type. Valid values include Check, CreditCard
      - name: total_amount
        description: Indicates the total amount associated with this payment. This includes the total of all the payments from the payment line details.
      - name: transaction_date
        description: Date of the day the transaction took place.
      - name: vendor_id
        description: Reference to the vendor for this transaction.
      - name: _fivetran_deleted
        description: Boolean created by Fivetran to indicate whether the record has been deleted.

  - name: stg_quickbooks__bill
    description: "{{ doc('bill_table') }}"
    tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - bill_id
            - source_relation    
    columns:
      - name: bill_id
        description: "{{ doc('id') }} bill record."
        tests:
          - not_null
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: balance
        description: The balance reflecting any payments made against the transaction.
      - name: currency_id
        description: Reference to the currency in which all amounts on the associated transaction are expressed.
      - name: department_id
        description: Reference to the department the bill is linked with.
      - name: total_amount
        description: Total monetary amount of all bill line items.
      - name: doc_number
        description: Reference number for the transaction.
      - name: vendor_id
        description: Reference to the vendor the bill is linked with.
      - name: due_date_at
        description: Date which the bill is due.
      - name: transaction_date
        description: Date when the bill transaction occurred.
      - name: exchange_rate
        description: The number of home currency units it takes to equal one unit of currency specified by currency_id.
      - name: payable_account_id
        description: Account id of the account which the bill is credited.
      - name: private_note
        description: User entered, organization-private note about the transaction.
      - name: _fivetran_deleted
        description: Boolean created by Fivetran to indicate whether the record has been deleted.

  - name: stg_quickbooks__bundle_item
    description: "{{ doc('bundle_item_table') }}"  
    columns:
      - name: bundle_id
        description: Reference to the bundle table.
        tests:
          - not_null
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: item_id
        description: Reference to the item which the bundle is mapped.
      - name: item_quantity
        description: Total item quantity associated with the bunlde and item mapping.

  - name: stg_quickbooks__bundle
    description: "{{ doc('bundle_table') }}"
    tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - bundle_id
            - source_relation    
    columns:
      - name: bundle_id
        description: "{{ doc('id') }} bundle."
        tests:
          - not_null
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: created_at
        description: Timestamp of the date which the bundle was created.
      - name: is_active
        description: Boolean indicating whether the bundle is active.
      - name: fully_qualified_name
        description: Full name given to the bundle.
      - name: updated_at
        description: Timestamp of the date when the bundle was last updated.

  - name: stg_quickbooks__credit_card_payment_txn
    description: "{{ doc('credit_card_payment_txn_table') }}"
    columns:
      - name: credit_card_payment_id
        description: "{{ doc('id') }} credit card payment transaction."
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: amount
        description: Total amount of money applied to the credit card payment transaction.
      - name: bank_account_id
        description: Reference to the bank account which the credit card payment is debited towards.
      - name: credit_card_account_id
        description: Reference to the credit card account which the credit card payment is credited towards.
      - name: created_at
        description: Timestamp when the credit card payment was created.
      - name: updated_at
        description: Timestamp when the credit card payment was last updated.
      - name: currency_id
        description: Reference to the currency used for the credit card payment.
      - name: transaction_date
        description: Date the credit card payment transaction took place.
      - name: _fivetran_deleted
        description: Boolean indicating if the credit card payment was deleted.
      - name: is_most_recent_record
        description: Boolean indicating if the record is the most recent updated version of the credit card payment transaction.

  - name: stg_quickbooks__credit_memo_line
    description: "{{ doc('credit_memo_line_table') }}"
    tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - credit_memo_id
            - index
            - source_relation
    columns:
      - name: credit_memo_id
        description: "{{ doc('id') }} credit memo record."
        tests:
          - not_null
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: index
        description: Index count of records from a credit memo record.
      - name: amount
        description: Monetary amount of the credit memo line.
      - name: sales_item_account_id
        description: "{{ doc('account_id') }} with the credited refund."
      - name: sales_item_class_id
        description: "{{ doc('class_id') }} with the refunded item."
      - name: sales_item_item_id
        description: "{{ doc('item_id') }} with the refunded item."
      - name: sales_item_quantity
        description: Quantity of item related to the credit memo line.
      - name: sales_item_unit_price
        description: Unit price of the item related to the credit memo line.
      - name: discount_account_id
        description: "{{ doc('account_id') }} with the income account used to track discounts."
      - name: discount_class_id
        description: "{{ doc('class_id') }} with the discount of the refunded item." 
      - name: description
        description: Description of the credit memo line.

  - name: stg_quickbooks__credit_memo
    description: "{{ doc('credit_memo_table') }}"
    tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - credit_memo_id
            - source_relation
    columns:
      - name: credit_memo_id
        description: Unique identifier for a credit memo.
        tests: 
          - not_null
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: balance
        description: The balance reflecting any payments made against the transaction.
      - name: total_amount
        description: Indicates the total amount of the transaction.
      - name: doc_number
        description: Reference number for the transaction.
      - name: currency_id
        description: Reference to the currency in which all amounts on the associated transaction are expressed.
      - name: class_id
        description: Reference to the class associated with the credit memo.
      - name: department_id
        description: Reference to the department associated with the credit memo.
      - name: customer_id
        description: Reference to the customer associated with the credit memo.
      - name: exchange_rate
        description: The number of home currency units it takes to equal one unit of currency specified by currency_id.
      - name: transaction_date
        description: Date when the credit memo occurred.
      - name: _fivetran_deleted
        description: Boolean created by Fivetran to indicate whether the record has been deleted.

  - name: stg_quickbooks__customer
    description: "{{ doc('customer_table') }}"
    tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - customer_id
            - source_relation
    columns:
      - name: customer_id
        description: "{{ doc('id') }} customer."
        tests:
          - not_null
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: is_active
        description: Boolean indicating whether it is currently enabled for use by QuickBooks.
      - name: balance
        description: Specifies the open balance amount or the amount unpaid by the customer.
      - name: balance_with_jobs
        description: Cumulative open balance amount for the Customer (or Job) and all its sub-jobs.
      - name: bill_with_parent
        description: Boolean indicating whether this Customer object is billed with its parent.
      - name: company_name
        description: Full name of the company.
      - name: fully_qualified_name
        description: Fully qualified name of the company.
      - name: currency_id
        description: Reference to the currency in which all amounts associated with this customer are expressed.
      - name: display_name
        description: Name of the customer which is displayed.
      - name: website
        description: Website url associated with the vendor.
      - name: taxable
        description: Boolean indicating whether the customer is taxable.

  - name: stg_quickbooks__department
    description: "{{ doc('department_table') }}"
    columns:
      - name: department_id
        description: "{{ doc('id') }} department."
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: is_active
        description: Boolean indicating whether the department is currently active.
      - name: created_at
        description: Timestamp of the date when the department was created.
      - name: updated_at
        description: Timestamp of the date when the department was last updated.
      - name: fully_qualified_name
        description: Fully qualified name of the department.
      - name: name
        description: Name of the department.
      - name: is_sub_department
        description: Boolean indicating whether the department is a sub department.
      - name: parent_department_id
        description: "Reference to the {{ doc('id') }} parent department if is_sub_department = true."

  - name: stg_quickbooks__deposit_line
    description: "{{ doc('deposit_line_table') }}"
    tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - deposit_id
            - index
            - source_relation
    columns:
      - name: deposit_id
        description: "{{ doc('id') }} deposit record."
        tests:
          - not_null
      - name: index
        description: Index count of records associated with the deposit record.
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: amount
        description: Monetary amount of the deposit line record.
      - name: description
        description: Description of the deposit line record.
      - name: deposit_class_id
        description: Reference to the class which the deposit line record is associated with.
      - name: deposit_account_id
        description: Account id of the account which the deposit is credited.
      - name: deposit_customer_id
        description: Customer id of the customer which the deposit is credited.

  - name: stg_quickbooks__deposit
    description: "{{ doc('deposit_table') }}"
    tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - deposit_id
            - source_relation
    columns:
      - name: deposit_id
        description: "{{ doc('id') }} deposit."
        tests:
          - not_null
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: account_id
        description: Identifies the account to be used for this deposit.
      - name: created_at
        description: Timestamp of the date which the deposit was created.
      - name: department_id
        description: Reference to the department associated with the deposit line.
      - name: currency_id
        description: Reference to the currency in which all amounts on the associated transaction are expressed.
      - name: total_amount
        description: Indicates the total amount of the transaction. This includes the total of all the charges, allowances, and taxes.
      - name: transaction_date
        description: Date which the deposit transaction occurred.
      - name: transaction_status
        description: Status of the deposit transaction.
      - name: _fivetran_deleted
        description: Boolean created by Fivetran to indicate whether the record has been deleted.

  - name: stg_quickbooks__estimate
    description: "{{ doc('estimate_table') }}"
    tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - estimate_id
            - source_relation
    columns:
      - name: estimate_id
        description: "{{ doc('id') }} estimate."
        tests:
          - not_null
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: class_id
        description: Reference to the class associated with the estimate record.
      - name: created_at
        description: Timestamp of the date when the estimate was created.
      - name: currency_id
        description: Reference to the currency which the estimate was provided.
      - name: customer_id
        description: Reference to the customer associated with the estimate.
      - name: department_id
        description: Reference to the department associated with the estimate.
      - name: due_date
        description: Date which the estimate is due.
      - name: total_amount
        description: Total amount of all line items included in the estimate.
      - name: transaction_date
        description: Date which the estimate occurred.
      - name: transaction_status
        description: Current status of the estimate.
      - name: _fivetran_deleted
        description: Boolean created by Fivetran to indicate whether the record has been deleted.

  - name: stg_quickbooks__estimate_line
    description: "{{ doc('estimate_line_table') }}"
    tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - estimate_id
            - index
            - source_relation
    columns:
      - name: estimate_id
        description: Reference to the unique estimate record.
        tests:
          - not_null
      - name: index
        description: Index count of records associated with the estimate line record.
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: description
        description: Description of the estimate line.
      - name: discount_account_id
        description: Reference to the account associated with the discount estimate line.
      - name: discount_class_id
        description: Reference to the class associated with the discount estimate line.
      - name: sales_item_account_id
        description: Reference to the account associated with the sales estimate line.
      - name: sales_item_class_id
        description: Reference to the class associated with the sales estimate line.
      - name: sales_item_item_id
        description: Reference to the item associated with a sales estimate line.
      - name: sales_item_quantity
        description: Quantity of the item for a sales estimate line.
      - name: item_id
        description: Reference to the item associated with the estimate line.
      - name: quantity
        description: Quantity of the item for the estimate line.
      - name: account_id
        description: Reference to the account associated with the estimate line.
      - name: amount
        description: Monetary amount of the estimate line.

  - name: stg_quickbooks__invoice_linked_txn
    description: "{{ doc('invoice_linked_txn_table') }}"
    columns:
      - name: invoice_id
        description: Reference to the unique invoice.
        tests:
          - not_null
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: payment_id
        description: Reference to the respective payment object for the invoice.
      - name: estimate_id
        description: Reference to the respective estimate object for the invoice.
      - name: index
        description: Index count of records associated with the invoice mapping record.

  - name: stg_quickbooks__invoice_line
    description: "{{ doc('invoice_line_table') }}"
    tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - invoice_id
            - index
            - source_relation
    columns:
      - name: invoice_id
        description: "{{ doc('id') }} invoice record."
        tests:
          - not_null
      - name: index
        description: Index count of records associated with the invoice record.
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: amount
        description: Monetary amount of the invoice line record.
      - name: sales_item_account_id
        description: Account reference for an item invoice record.
      - name: sales_item_item_id
        description: Item reference for an item invoice record.
      - name: sales_item_class_id
        description: Class reference for an item invoice record.
      - name: sales_item_quantity
        description: Quantity of the item for an item invoice record.
      - name: sales_item_unit_price
        description: Unit price of the item for an item invoice record.
      - name: discount_account_id
        description: Account reference for a discount invoice record.
      - name: discount_class_id
        description: Class reference for a discount invoice record.
      - name: description
        description: Description of the invoice line.
      - name: bundle_quantity
        description: Quantity of items included in the invoice bundle.
      - name: bundle_id
        description: Reference to the bundle associated with the invoice line.
      - name: account_id
        description: Reference to the account associated with the invoice line.
      - name: item_id
        description: Reference to the item associated with the invoice line.
      - name: quantity
        description: Quantity of the item included on the invoice line.
      - name: detail_type
        description: Individual line items of a transaction. Valid line types include SalesItemLineDetail, DescriptionOnly (also used for inline Subtotal lines), DiscountLineDetail and SubTotalLineDetail (used for the overall transaction). FYI - Records synced prior to 11/2021 will have a null value.

  - name: stg_quickbooks__invoice_line_bundle
    description: "{{ doc('invoice_line_bundle_table') }}"
    tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - invoice_id
            - index
            - invoice_line_index
            - source_relation
    columns:
      - name: invoice_id
        description: "{{ doc('id') }} invoice record."
        tests:
          - not_null
      - name: index
        description: Index count of records associated with the invoice bundle line.
      - name: invoice_line_index
        description: Invoice index count of records associated with the invoice bundle line.
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: class_id
        description: Reference to the class associated with the invoice line bundle.
      - name: description
        description: Description of the invoice bundle line.
      - name: amount
        description: Total monetary value of the invoice bundle line.
      - name: sales_item_item_id
        description: Reference to the sales item on the invoice bundle line.
      - name: item_id
        description: Reference to the item on the invoice bundle line.
      - name: quantity
        description: Total quantity of the item on the invoice bundle line.
      - name: sales_item_quantity
        description: Total quantity in relation to the sales item on the invoice bundle line.
      - name: account_id
        description: Reference to the account associated with the invoice bundle line.
      - name: unit_price
        description: Unit price of the line item included on the invoice bundle line.

  - name: stg_quickbooks__invoice
    description: "{{ doc('invoice_table') }}"
    tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - invoice_id
            - source_relation
    columns:
      - name: invoice_id
        description: "{{ doc('id') }} invoice."
        tests:
          - not_null
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: balance
        description: The balance reflecting any payments made against the transaction.
      - name: total_amount
        description: Indicates the total amount of the transaction. This includes the total of all the charges, allowances, and taxes.
      - name: doc_number
        description: Reference number for the transaction.
      - name: currency_id
        description: Reference to the currency in which all amounts on the associated transaction are expressed.
      - name: department_id
        description: Reference to the department associated with the invoice.
      - name: deposit_to_account_id
        description: Identifies the account to be used for this invoice.
      - name: exchange_rate
        description: The number of home currency units it takes to equal one unit of currency specified by currency_id.
      - name: transaction_date
        description: Date which the deposit transaction occurred.
      - name: customer_id
        description: Customer reference is associated with the invoice.
      - name: billing_address_id
        description: Reference to the address where the invoice is billed.
      - name: shipping_address_id
        description: Reference to the address where the invoice is to be shipped.
      - name: delivery_type
        description: How the invoice is delivered to the customer.
      - name: due_date
        description: Date which the invoice payment is due.
      - name: class_id
        description: Reference to the class to which the invoice is associated with.
      - name: _fivetran_deleted
        description: Boolean created by Fivetran to indicate whether the record has been deleted.

  - name: stg_quickbooks__item
    description: "{{ doc('item_table') }}"
    tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - item_id
            - source_relation
    columns:
      - name: item_id
        description: "{{ doc('id') }} item."
        tests:
          - not_null
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: is_active
        description: Boolean indicating whether the object is currently enabled for use by QuickBooks.
      - name: created_at
        description: Timestamp of the date when the item was created within QuickBooks.
      - name: income_account_id
        description: Reference to the posting account, that is, the account that records the proceeds from the sale of this item.
      - name: asset_account_id
        description: Reference to the Inventory Asset account that tracks the current value of the inventory.
      - name: expense_account_id
        description: Reference to the expense account used to pay the vendor for this item.
      - name: name
        description: Full name of the item.
      - name: inventory_start_date
        description: Timestamp of the date the item was started as inventory.
      - name: parent_item_id
        description: Reference to the parent item.
      - name: purchase_cost
        description: Amount paid when buying or ordering the item, as expressed in the home currency.
      - name: taxable
        description: Boolean indicating whether the item is taxable.
      - name: type
        description: Classification that specifies the use of this item.
      - name: unit_price
        description: The monetary value of the service or product, as expressed in the home currency.

  - name: stg_quickbooks__journal_entry_line
    description: "{{ doc('journal_entry_line_table') }}"
    tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - journal_entry_id
            - index
            - source_relation
    columns:
      - name: journal_entry_id
        description: "{{ doc('id') }} journal entry record."
        tests:
          - not_null
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: index
        description: Index count of records associated with the journal entry record.
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: account_id
        description: Account id of the account which the journal entry is credited.
      - name: amount
        description: Monetary amount of the journal entry line.
      - name: customer_id
        description: Customer id of the customer which the journal entry is credited.
      - name: department_id
        description: Reference to the department which the journal entry is associated.
      - name: class_id
        description: Reference to the class which the journal entry is associated.
      - name: billable_status
        description: Status of the journal entry indicating whether it is billable or not.
      - name: description
        description: User defined description of the journal entry line.
      - name: posting_type
        description: Indicates whether this JournalEntry line is a debit or credit. Valid values are Credit and Debit
        tests:
          - accepted_values:
              values: ['Credit', 'Debit']
      - name: vendor_id
        description: Reference to the vendor for this journal entry.

  - name: stg_quickbooks__journal_entry
    description: "{{ doc('journal_entry_table') }}"
    columns:
      - name: journal_entry_id
        description: "{{ doc('id') }} journal entry."
        tests:
          - not_null
      - name: is_adjustment
        description: Indicates the total amount of the transaction. This includes the total of all the charges, allowances, and taxes. By default, this is recalculated by the system based on sub-items total and overridden.
      - name: created_at
        description: Timestamp of the date when the journal entry was created.
      - name: currency_id
        description: Reference to the currency in which all amounts on the associated transaction are expressed.
      - name: doc_number
        description: Reference number for the transaction.
      - name: exchange_rate
        description: The number of home currency units it takes to equal one unit of currency specified by currency_id.
      - name: private_note
        description: User entered, organization-private note about the transaction.
      - name: total_amount
        description: The value of this field will always be set to zero.
      - name: transaction_date
        description: Date when the journal entry was transacted.
      - name: _fivetran_deleted
        description: Boolean created by Fivetran to indicate whether the record has been deleted.

  - name: stg_quickbooks__payment_line
    description: "{{ doc('payment_line_table') }}"
    tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - payment_id
            - index
            - source_relation
    columns:
      - name: payment_id
        description: "{{ doc('id') }} payment record."
        tests:
          - not_null
      - name: index
        description: Index count of records associated with the payment record.
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: amount
        description: Monetary amount of the payment line.
      - name: journal_entry_id
        description: Journal entry reference associated with the payment.
      - name: deposit_id
        description: Deposit reference associated with the payment.
      - name: invoice_id
        description: Invoice reference associated with the payment.
      - name: credit_memo_id
        description: credit memo reference associated with the payment.

  - name: stg_quickbooks__payment
    description: "{{ doc('payment_table') }}"
    tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - payment_id
            - source_relation
    columns:
      - name: payment_id
        description: "{{ doc('id') }} payment."
        tests:
          - not_null
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: unapplied_amount
        description: Indicates the amount that has not been applied to pay amounts owed for sales transactions.
      - name: total_amount
        description: Indicates the total amount of the transaction.
      - name: currency_id
        description: Reference to the currency in which all amounts on the associated transaction are expressed.
      - name: receivable_account_id
        description: Identifies the account for obtaining a receivable from this payment.
      - name: deposit_to_account_id
        description: Identifies the account to be used for this payment.
      - name: exchange_rate
        description: The number of home currency units it takes to equal one unit of currency specified by currency_id.
      - name: transaction_date
        description: Date when the payment occurred.
      - name: customer_id
        description: Reference to a customer or job.
      - name: _fivetran_deleted
        description: Boolean created by Fivetran to indicate whether the record has been deleted.

  - name: stg_quickbooks__purchase_line
    description: "{{ doc('purchase_line_table') }}"
    tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - purchase_id
            - index
            - source_relation
    columns:
      - name: purchase_id
        description: "{{ doc('id') }} purchase record."
        tests:
          - not_null
      - name: index
        description: Index count of records associated with the purchase record.
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: account_expense_account_id
        description: Account id of the account which the purchase is credited.
      - name: account_expense_class_id
        description: The class reference associated with the account based expense purchase line.
      - name: account_expense_billable_status
        description: Status of the purchase billable.
      - name: account_expense_customer_id
        description: The customer id associated with the account based expense purchase line
      - name: account_expense_tax_code_id
        description: Tax code reference associated to the purchase.
      - name: item_expense_item_id
        description: The item reference associated with the item based expense purchase line.
      - name: item_expense_billable_status
        description: The billable status of the item based expense purchase line.
      - name: item_expense_class_id
        description: The class id associated with the item based expense purchase line. 
      - name: item_expense_customer_id
        description: The customer id associated with the item based expense purchase line.
      - name: amount
        description: Monetary amount of the purchase.
      - name: description
        description: User defined description of the purchase line.

  - name: stg_quickbooks__purchase
    description: "{{ doc('purchase_table') }}"
    tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - purchase_id
            - source_relation
    columns:
      - name: purchase_id
        description: "{{ doc('id') }} purchase."
        tests:
          - not_null
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: account_id
        description: Specifies the account reference to which this purchase is applied based on the PaymentType.
      - name: created_at
        description: Timestamp of the date when the purchase was created.
      - name: doc_number
        description: Reference number for the transaction.
      - name: currency_id
        description: Reference to the currency in which all amounts on the associated transaction are expressed.
      - name: exchange_rate
        description: The number of home currency units it takes to equal one unit of currency specified by currency_id.
      - name: credit
        description: Boolean where `false` represents a charge and `true` represents a refund.
      - name: department_id
        description: Reference to the department which the purchase is associated.
      - name: customer_id
        description: Reference to the customer which the purchase is associated.
      - name: transaction_date
        description: Date when the purchase occurred.
      - name: total_amount
        description: Indicates the total amount of the transaction.
      - name: payment_type
        description: Payment type of the purchase. Type can be Cash, Check, or CreditCard.
        tests:
          - accepted_values:
              values: ['Cash', 'Check', 'CreditCard']
      - name: vendor_id
        description: Reference to the vendor for the purchase.
      - name: _fivetran_deleted
        description: Boolean created by Fivetran to indicate whether the record has been deleted.

  - name: stg_quickbooks__purchase_order_line
    description: "{{ doc('purchase_order_line_table') }}"
    tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - purchase_order_id
            - index
            - source_relation
    columns:
      - name: purchase_order_id
        description: "{{ doc('id') }} purchase order record."
        tests:
          - not_null
      - name: index
        description: Index count of records associated with the purchase order record.
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: account_expense_account_id
        description: Account id of the account which the purchase order is credited.
      - name: account_expense_class_id
        description: The class reference associated with the account based expense purchase order line.
      - name: account_expense_billable_status
        description: Status of the purchase billable.
      - name: account_expense_customer_id
        description: The customer id associated with the account based purchase order line.
      - name: account_expense_tax_code_id
        description: Tax code reference associated to the purchase order.
      - name: item_expense_item_id
        description: The item reference associated with the item based expense purchase order line.
      - name: item_expense_billable_status
        description: The billable status of the item based expense purchase order line.
      - name: item_expense_customer_id
        description: The customer id associated with the item based purchase order line.
      - name: amount
        description: Monetary amount of the purchase.
      - name: description
        description: User defined description of the purchase line.

  - name: stg_quickbooks__purchase_order_linked_txn
    description: "{{ doc('purchase_order_linked_txn_table') }}"
    columns:
      - name: purchase_order_id
        description: Reference to the unique purchase order.
        tests:
          - not_null
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: bill_id
        description: Reference to the respective bill object for the purchase order.
      - name: purchase_id
        description: Reference to the respective purchase object for the purchase_order.
      - name: vendor_credit_id
        description: Reference to the respective vendor credit object for the purchase_order.
      - name: index
        description: Index count of records associated with the purchase order mapping record.

  - name: stg_quickbooks__purchase_order
    description: "{{ doc('purchase_order_table') }}"
    tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - purchase_order_id
            - source_relation
    columns:
      - name: purchase_order_id
        description: "{{ doc('id') }} purchase order."
        tests:
          - not_null
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: created_at
        description: Timestamp of the date when the purchase order was created.
      - name: custom_po_number
        description: Custom field for PO number.
      - name: doc_number
        description: Reference number for the transaction.
      - name: due_date
        description: Date when the purchase order is due.
      - name: currency_id
        description: Reference to the currency in which all amounts on the associated transaction are expressed.
      - name: exchange_rate
        description: The number of home currency units it takes to equal one unit of currency specified by currency_id.
      - name: transaction_date
        description: Date when the purchase order occurred.
      - name: total_amount
        description: Indicates the total amount of the transaction.
      - name: payable_account_id
        description: Account id for which the purchase order will credited.
      - name: status
        description: Purchase order status. Valid values are "Open" and "Closed".
        tests:
          - accepted_values:
              values: ['Open', 'Closed']
      - name: vendor_id
        description: Reference to the vendor for the purchase order.
      - name: _fivetran_deleted
        description: Boolean created by Fivetran to indicate whether the record has been deleted.

  - name: stg_quickbooks__refund_receipt_line
    description: "{{ doc('refund_receipt_line_table') }}"
    tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - refund_id
            - index
            - source_relation
    columns:
      - name: refund_id
        description: "{{ doc('id') }} refund record."
        tests:
          - not_null
      - name: index
        description: Index count of records associated with the refund record.
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: amount
        description: Monetary amount of the refund line.
      - name: description
        description: User defined description of the refund line.
      - name: discount_account_id
        description: Reference to Income account used to track discounts.
      - name: discount_class_id
        description: Class id of the discount associated with the refunded item. 
      - name: sales_item_quantity
        description: Quantity of the item associated with the refund receipt line.
      - name: sales_item_unit_price
        description: Unit price of the item associated with the refund receipt line.
      - name: sales_item_account_id
        description: Account id of the account which the refund is credited.
      - name: sales_item_class_id
        description: Class id of the refunded item.
      - name: sales_item_item_id
        description: Item id of the refunded item.
      - name: sales_item_tax_code_id
        description: Tax code id of the tax code associated with the refund.

  - name: stg_quickbooks__refund_receipt
    description: "{{ doc('refund_receipt_table') }}"
    tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - refund_id
            - source_relation
    columns:
      - name: refund_id
        description: "{{ doc('id') }} refund."
        tests: 
          - not_null
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: balance
        description: The balance reflecting any payments made against the transaction.
      - name: total_amount
        description: Indicates the total amount of the transaction.
      - name: doc_number
        description: Reference number for the transaction.
      - name: class_id
        description: Reference to the class which the refund receipt is associated.
      - name: department_id
        description: Reference to the department which the refund receipt is associated.
      - name: deposit_to_account_id
        description: Account from which payment money is refunded.
      - name: created_at
        description: Timestamp of the date when the refund was created.
      - name: customer_id
        description: Customer id of the customer credited with the refund.
      - name: currency_id
        description: Reference to the currency in which all amounts on the associated transaction are expressed.
      - name: exchange_rate
        description: The number of home currency units it takes to equal one unit of currency specified by currency_id.
      - name: transaction_date
        description: Date in which the refund occurred.
      - name: _fivetran_deleted
        description: Boolean created by Fivetran to indicate whether the record has been deleted.

  - name: stg_quickbooks__sales_receipt_line
    description: "{{ doc('sales_receipt_line_table') }}"
    tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - sales_receipt_id
            - index
            - source_relation
    columns:
      - name: sales_receipt_id
        description: "{{ doc('id') }} sales record."
        tests:
          - not_null
      - name: index
        description: Index count of records associated with the sales record.
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: amount
        description: Monetary amount of the sales line.
      - name: description
        description: Description of the sales receipt line.
      - name: discount_account_id
        description: Reference to Income account used to track discounts.
      - name: discount_class_id
        description: Class id of the discount credited to the sales line.
      - name: sales_item_account_id
        description: Account id of the account credited with the sales line.
      - name: sales_item_class_id
        description: Class id of the receipt credited with the sales line.
      - name: sales_item_item_id
        description: Item id of the item sold in the sale line.
      - name: sales_item_tax_code_id
        description: Tax code id of the tax code associated with the sales line.
      - name: sales_item_quantity
        description: Total quantity of items included in the sales line.
      - name: sales_item_unit_price
        description: Unit price of the item included on the sales line.

  - name: stg_quickbooks__sales_receipt
    description: "{{ doc('sales_receipt_table') }}"
    tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - sales_receipt_id
            - source_relation
    columns:
      - name: sales_receipt_id
        description: "{{ doc('id') }} sales receipt."
        tests: 
          - not_null
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: balance
        description: The balance reflecting any payments made against the transaction.
      - name: total_amount
        description: Indicates the total amount of the transaction.
      - name: doc_number
        description: Reference number for the transaction.
      - name: deposit_to_account_id
        description: Account to which payment money is deposited.
      - name: created_at
        description: Timestamp of the date when the sale was created.
      - name: customer_id
        description: Customer id of the sold to customer.
      - name: currency_id
        description: Reference to the currency in which all amounts on the associated transaction are expressed.
      - name: department_id
        description: Reference to the department which the sales receipt is associated.
      - name: class_id
        description: Reference to the class which the sales receipt is associated.
      - name: exchange_rate
        description: The number of home currency units it takes to equal one unit of currency specified by currency_id.
      - name: transaction_date
        description: Date which the sale occurred.
      - name: _fivetran_deleted
        description: Boolean created by Fivetran to indicate whether the record has been deleted.

  - name: stg_quickbooks__transfer
    description: "{{ doc('transfer_table') }}"
    tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - transfer_id
            - source_relation
    columns:
      - name: transfer_id
        description: "{{ doc('id') }} transfer."
        tests: 
          - not_null
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: amount
        description: Monetary amount of the transfer.
      - name: from_account_id
        description: Account id of the account which the transfer is from.
      - name: to_account_id
        description: Account id of the account which the transfer is to.
      - name: transaction_date
        description: Date which the transfer occurred.
      - name: _fivetran_deleted
        description: Boolean created by Fivetran to indicate whether the record has been deleted.

  - name: stg_quickbooks__vendor_credit_line
    description: "{{ doc('vendor_credit_line_table') }}"
    tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - vendor_credit_id
            - index
            - source_relation
    columns:
      - name: vendor_credit_id
        description: "{{ doc('id') }} vendor credit record."
        test:
          - not_null
      - name: index
        description: Index count of records associated with the vendor credit record.
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: account_expense_account_id
        description: Account id of the account credited for the vendor credit line.
      - name: account_expense_billable_status
        description: Status of the billable related to the vendor credit line.
      - name: account_expense_tax_code_id
        description: Tax code id of the tax code associated with the vendor credit line.
      - name: account_expense_customer_id
        description: Customer reference for the vendor credit expense.
      - name: account_expense_class_id
        description: The class reference associated with the account based expense vendor credit line.
      - name: item_expense_customer_id
        description: Customer reference for the item on the vendor credit line.
      - name: item_expense_item_id
        description: The item reference associated with the item based expense vendor credit line.
      - name: item_expense_quantity
        description: Quantity of the item within the item based expense vendor credit line.
      - name: item_expense_unit_price
        description: Unit price of the item within the item based expense vendor credit line.
      - name: item_expense_class_id
        description: Reference to the class associated with the item based expense vendor credit line.
      - name: item_expense_billable_status
        description: The billable status of the item based expense vendor credit line.
      - name: amount
        description: Monetary amount of the vendor credit line.
      - name: description
        description: Description of the vendor credit line.

  - name: stg_quickbooks__vendor_credit
    description: "{{ doc('vendor_credit_table') }}"
    columns:
      - name: vendor_credit_id
        description: "{{ doc('id') }} vendor credit."
        tests: 
          - not_null
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: balance
        description: The current amount of the vendor credit reflecting any adjustments to the original credit amount.
      - name: total_amount
        description: Indicates the total credit amount, determined by taking the total of all all lines of the transaction.
      - name: doc_number
        description: Reference number for the transaction.
      - name: currency_id
        description: Reference to the currency in which all amounts on the associated transaction are expressed.
      - name: exchange_rate
        description: The number of home currency units it takes to equal one unit of currency specified by currency_id.
      - name: created_at
        description: Timestamp of the date the vendor credit was created.
      - name: payable_account_id
        description: Specifies to which AP account the bill is credited.
      - name: department_id
        description: Reference to the department which the vendor credit is associated.
      - name: private_note
        description: User entered, organization-private note about the transaction.
      - name: transaction_date
        description: The date entered by the user when this transaction occurred.
      - name: vendor_id
        description: Reference to the vendor for this transaction.
      - name: _fivetran_deleted
        description: Boolean created by Fivetran to indicate whether the record has been deleted.

  - name: stg_quickbooks__vendor
    description: "{{ doc('vendor_table') }}"
    tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - vendor_id
            - source_relation
    columns:
      - name: vendor_id
        description: "{{ doc('id') }} vendor."
        tests: 
          - not_null
      - name: source_relation
        description: "{{ doc('source_relation') }}"
      - name: account_number
        description: Name or number of the account associated with this vendor.
      - name: billing_address_id
        description: Address reference for the billing address of the vendor.
      - name: is_active
        description: Boolean indicating whether the vendor is active.
      - name: balance
        description: Specifies the open balance amount or the amount unpaid by the customer.
      - name: company_name
        description: The name of the company associated with the person or organization.
      - name: created_at
        description: Timestamp of the date when the vendor was created.
      - name: currency_id
        description: Reference to the currency in which all amounts associated with this vendor are expressed.
      - name: display_name
        description: The name of the vendor as displayed. Must be unique across all Vendor, Customer, and Employee objects.
      - name: web_url
        description: Website url associated with the vendor.
      - name: is_vendor_1099
        description: Boolean indicating whether this vendor is an independent contractor; someone who is given a 1099-MISC form at the end of the year.