{"joins": [{"type": "left", "first": "lineitems_payments.sales_receipt_id", "table": "sales_receipts", "second": "sales_receipts.sales_receipt_id", "operator": "="}], "table": "lineitems_payments", "columns": ["sales_receipt_id", "org_id", "line_items", "payments"], "primary_key": "sales_receipt_id", "field_labels": {"org_id": "Organization ID", "payments": "Payments (JSON)", "line_items": "Line Items (JSON)", "totalAmount": "Total Amount", "invoiceNumber": "Invoice Number", "sales_receipt_id": "Receipt ID"}, "unique_fields": ["sales_receipt_id"], "required_columns": ["sales_receipt_id"], "validation_rules": {"line_items": {"type": "json_array", "min_items": 1}, "sales_receipt_id": {"type": "exists", "table": "sales_receipts", "column": "sales_receipt_id", "error_message": "Receipt ID must exist in sales_receipts table"}}, "export_transforms": {"payments": {"type": "json_decode", "pretty_print": true}, "line_items": {"type": "json_decode", "pretty_print": true}}, "import_transforms": {"payments": {"type": "json", "validate_structure": {"array_structure": true, "required_fields": ["method", "amount"]}}, "line_items": {"type": "json", "validate_structure": {"array_structure": true, "required_fields": ["product_id", "quantity", "unit_price"]}}}, "additional_columns": [{"name": "invoiceNumber", "type": "text", "source": "sales_receipts.invoiceNumber"}, {"name": "totalAmount", "type": "numeric", "source": "sales_receipts.totalAmount"}]}