

seeds:
  quickbooks:
    solution__int_quickbooks__vendor_credit_double_entry:
      +column_types:
        transaction_id: varchar
        source_relation: varchar
        index: integer
        transaction_date: date
        customer_id: varchar
        vendor_id: varchar
        amount: integer
        account_id: varchar
        class_id: varchar
        department_id: varchar
        transaction_type: varchar
        transaction_source: varchar
    solution__int_quickbooks__sales_union:
      +column_types:
        transaction_source: varchar
        transaction_id: varchar
        source_relation: varchar
        transaction_line_id: integer
        doc_number: varchar
        transaction_type: varchar
        transaction_date: date
        item_id: varchar
        item_quantity: double
        item_unit_price: double
        account_id: varchar
        account_name: varchar
        account_sub_type: varchar
        class_id: varchar
        department_id: varchar
        department_name: varchar
        customer_id: varchar
        customer_name: varchar
        customer_website: integer
        vendor_id: varchar
        vendor_name: varchar
        billable_status: varchar
        description: varchar
        amount: double
        total_amount: integer
    solution__int_quickbooks__sales_receipt_transactions:
      +column_types:
        transaction_id: varchar
        source_relation: varchar
        transaction_line_id: integer
        doc_number: varchar
        transaction_type: varchar
        transaction_date: date
        item_id: varchar
        item_quantity: integer
        item_unit_price: integer
        account_id: varchar
        class_id: varchar
        department_id: varchar
        customer_id: varchar
        vendor_id: varchar
        billable_status: varchar
        description: varchar
        amount: integer
        total_amount: integer
    solution__int_quickbooks__sales_receipt_double_entry:
      +column_types:
        transaction_id: varchar
        source_relation: varchar
        index: integer
        transaction_date: date
        customer_id: varchar
        vendor_id: varchar
        amount: integer
        account_id: varchar
        class_id: varchar
        department_id: varchar
        transaction_type: varchar
        transaction_source: varchar
    solution__int_quickbooks__refund_receipt_transactions:
      +column_types:
        transaction_id: varchar
        source_relation: varchar
        transaction_line_id: integer
        doc_number: varchar
        transaction_type: varchar
        transaction_date: date
        item_id: varchar
        item_quantity: integer
        item_unit_price: integer
        account_id: varchar
        class_id: varchar
        department_id: varchar
        customer_id: varchar
        vendor_id: varchar
        billable_status: varchar
        description: varchar
        amount: integer
        total_amount: integer
    solution__int_quickbooks__refund_receipt_double_entry:
      +column_types:
        transaction_id: varchar
        source_relation: varchar
        index: integer
        transaction_date: date
        customer_id: varchar
        vendor_id: varchar
        amount: integer
        account_id: varchar
        class_id: varchar
        department_id: varchar
        transaction_type: varchar
        transaction_source: varchar
    solution__int_quickbooks__purchase_transactions:
      +column_types:
        transaction_id: varchar
        source_relation: varchar
        transaction_line_id: integer
        doc_number: varchar
        transaction_type: varchar
        transaction_date: date
        account_id: varchar
        class_id: varchar
        department_id: varchar
        customer_id: varchar
        vendor_id: varchar
        billable_status: varchar
        description: varchar
        amount: integer
        total_amount: integer
    solution__int_quickbooks__purchase_double_entry:
      +column_types:
        transaction_id: varchar
        source_relation: varchar
        index: integer
        transaction_date: date
        customer_id: varchar
        vendor_id: varchar
        amount: integer
        account_id: varchar
        class_id: varchar
        department_id: varchar
        transaction_type: varchar
        transaction_source: varchar
    solution__int_quickbooks__payment_double_entry:
      +column_types:
        transaction_id: varchar
        source_relation: varchar
        index: bigint
        transaction_date: date
        customer_id: varchar
        vendor_id: varchar
        amount: double
        account_id: varchar
        class_id: varchar
        department_id: varchar
        transaction_type: varchar
        transaction_source: varchar
    solution__int_quickbooks__journal_entry_transactions:
      +column_types:
        transaction_id: varchar
        source_relation: varchar
        transaction_line_id: integer
        doc_number: varchar
        transaction_type: varchar
        transaction_date: date
        account_id: varchar
        class_id: varchar
        department_id: varchar
        customer_id: varchar
        vendor_id: varchar
        billable_status: varchar
        description: varchar
        amount: integer
        total_amount: integer
    solution__int_quickbooks__journal_entry_double_entry:
      +column_types:
        transaction_id: varchar
        source_relation: varchar
        index: integer
        transaction_date: date
        customer_id: varchar
        vendor_id: varchar
        amount: integer
        account_id: varchar
        class_id: varchar
        department_id: varchar
        transaction_type: varchar
        transaction_source: varchar
    solution__int_quickbooks__invoice_transactions:
      +column_types:
        transaction_id: varchar
        source_relation: varchar
        transaction_line_id: integer
        doc_number: varchar
        transaction_type: varchar
        transaction_date: date
        item_id: varchar
        item_quantity: double
        item_unit_price: integer
        account_id: varchar
        class_id: varchar
        department_id: varchar
        customer_id: varchar
        vendor_id: varchar
        billable_status: varchar
        description: varchar
        amount: double
        total_amount: integer
    solution__int_quickbooks__invoice_join:
      +column_types:
        transaction_type: varchar
        transaction_id: varchar
        source_relation: varchar
        doc_number: varchar
        estimate_id: varchar
        department_id: varchar
        customer_id: varchar
        billing_address_id: varchar
        shipping_address_id: integer
        delivery_type: varchar
        total_amount: integer
        current_balance: integer
        estimate_total_amount: double
        estimate_status: varchar
        due_date: date
        initial_payment_date: date
        recent_payment_date: date
        total_current_payment: double
    solution__int_quickbooks__invoice_double_entry:
      +column_types:
        transaction_id: varchar
        source_relation: varchar
        index: integer
        transaction_date: date
        customer_id: varchar
        vendor_id: varchar
        amount: double
        account_id: varchar
        class_id: varchar
        department_id: varchar
        transaction_type: varchar
        transaction_source: varchar
    solution__int_quickbooks__expenses_union:
      +column_types:
        transaction_source: varchar
        transaction_id: varchar
        source_relation: varchar
        transaction_line_id: integer
        doc_number: varchar
        transaction_type: varchar
        transaction_date: date
        item_id: varchar
        item_quantity: decimal(28,6)
        item_unit_price: decimal(28,6)
        account_id: varchar
        account_name: varchar
        account_sub_type: varchar
        class_id: varchar
        department_id: varchar
        department_name: varchar
        customer_id: varchar
        customer_name: varchar
        customer_website: integer
        vendor_id: varchar
        vendor_name: varchar
        billable_status: varchar
        description: varchar
        amount: double
        total_amount: integer
    solution__int_quickbooks__deposit_transactions:
      +column_types:
        transaction_id: varchar
        source_relation: varchar
        transaction_line_id: integer
        doc_number: varchar
        transaction_type: varchar
        transaction_date: date
        account_id: varchar
        class_id: varchar
        department_id: varchar
        customer_id: varchar
        vendor_id: varchar
        billable_status: varchar
        description: varchar
        amount: integer
        total_amount: integer
    solution__int_quickbooks__credit_memo_transactions:
      +column_types:
        transaction_id: varchar
        source_relation: varchar
        transaction_line_id: integer
        doc_number: varchar
        transaction_type: varchar
        transaction_date: date
        item_id: varchar
        item_quantity: double
        item_unit_price: double
        account_id: varchar
        class_id: varchar
        department_id: varchar
        customer_id: varchar
        vendor_id: varchar
        billable_status: varchar
        description: varchar
        amount: integer
        total_amount: integer
    solution__int_quickbooks__credit_memo_double_entry:
      +column_types:
        transaction_id: varchar
        source_relation: varchar
        index: integer
        transaction_date: date
        customer_id: varchar
        vendor_id: varchar
        amount: integer
        account_id: varchar
        class_id: varchar
        department_id: varchar
        transaction_type: varchar
        transaction_source: varchar
    solution__int_quickbooks__bill_transactions:
      +column_types:
        transaction_id: varchar
        source_relation: varchar
        transaction_line_id: integer
        doc_number: varchar
        transaction_type: varchar
        transaction_date: date
        account_id: varchar
        class_id: varchar
        department_id: varchar
        customer_id: varchar
        vendor_id: varchar
        billable_status: varchar
        description: varchar
        amount: double
        total_amount: integer
    solution__int_quickbooks__bill_payment_double_entry:
      +column_types:
        transaction_id: varchar
        source_relation: varchar
        index: bigint
        transaction_date: date
        customer_id: varchar
        vendor_id: varchar
        amount: integer
        account_id: varchar
        class_id: varchar
        department_id: varchar
        transaction_type: varchar
        transaction_source: varchar
    solution__int_quickbooks__bill_join:
      +column_types:
        transaction_type: varchar
        transaction_id: varchar
        source_relation: varchar
        doc_number: varchar
        department_id: varchar
        vendor_id: varchar
        payable_account_id: varchar
        total_amount: integer
        current_balance: integer
        due_date: date
        initial_payment_date: date
        recent_payment_date: date
        total_current_payment: bigint
    solution__int_quickbooks__bill_double_entry:
      +column_types:
        transaction_id: varchar
        source_relation: varchar
        index: integer
        transaction_date: date
        customer_id: varchar
        vendor_id: varchar
        amount: double
        account_id: varchar
        class_id: varchar
        department_id: varchar
        transaction_type: varchar
        transaction_source: varchar
    solution__quickbooks__ap_ar_enhanced:
      +column_types:
        transaction_type: varchar
        transaction_id: varchar
        source_relation: varchar
        doc_number: varchar
        estimate_id: varchar
        department_name: varchar
        transaction_with: varchar
        customer_vendor_name: varchar
        customer_vendor_balance: integer
        customer_vendor_address_city: varchar
        customer_vendor_address_country: varchar
        customer_vendor_address_line: varchar
        customer_vendor_website: integer
        delivery_type: varchar
        estimate_status: varchar
        total_amount: integer
        estimate_total_amount: double
        current_balance: integer
        due_date: date
        is_overdue: boolean
        days_overdue: bigint
        initial_payment_date: date
        recent_payment_date: date
        total_current_payment: double
