

seeds:
  quickbooks:
    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
        converted_amount: integer
        total_amount: integer
        total_converted_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
        converted_amount: integer
        total_amount: integer
        total_converted_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
        total_converted_amount: integer
        current_balance: integer
        estimate_total_amount: double
        estimate_total_converted_amount: double
        estimate_status: varchar
        due_date: date
        initial_payment_date: date
        recent_payment_date: date
        total_current_payment: double
        total_current_converted_payment: double
