# Unicommerce schema ERD

Table and field reference for the Fivetran Unicommerce connector.

## Table & Field Reference

### inflow_receipt_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| grn_code | Unknown | PK, FK |
| item_sku | Unknown | FK |
| purchase_order_item_id | Unknown | FK |
| additional_cost | Unknown |  |
| batch_code | Unknown |  |
| batch_dto | Unknown |  |
| detailed_quantity | Unknown |  |
| determine_expiry_from | Unknown |  |
| discount | Unknown |  |
| discount_percentage | Unknown |  |
| expirable | Unknown |  |
| expiry | Unknown |  |
| grn_expiry_tolerance | Unknown |  |
| item_type_image_url | Unknown |  |
| item_type_name | Unknown |  |
| item_type_page_url | Unknown |  |
| items_labelled | Unknown |  |
| manufacturing_date | Unknown |  |
| max_retail_price | Unknown |  |
| pending_quantity | Unknown |  |
| quantity | Unknown |  |
| rejected_quantity | Unknown |  |
| rejection_comment | Unknown |  |
| scan_identifier | Unknown |  |
| shelf_life | Unknown |  |
| status | Unknown |  |
| unit_price | Unknown |  |
| vendor_sku_code | Unknown |  |

### grn_custom_field_value

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| grn_code | Unknown | PK, FK |
| display_name | Unknown |  |
| field_name | Unknown |  |
| field_value | Json |  |
| possible_value | Json |  |
| required | Unknown |  |
| value_type | Unknown |  |

### grn

| Column | Type | Keys |
| --- | --- | --- |
| code | Unknown | PK |
| purchase_order_code | Unknown | FK |
| asn_code | Unknown |  |
| created | Unknown |  |
| created_by | Unknown |  |
| facility | Unknown |  |
| purchase_order_approved | Unknown |  |
| purchase_order_vendor_code | Unknown |  |
| status_code | Unknown |  |
| total_quantity | Unknown |  |
| total_received_amount | Unknown |  |
| total_rejected_amount | Unknown |  |
| total_rejected_quantity | Unknown |  |
| vendor_invoice_date | Unknown |  |
| vendor_invoice_number | Unknown |  |

### sale_order_custom_field_value

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| sale_order_code | Unknown | PK, FK |
| display_name | Unknown |  |
| field_name | Unknown |  |
| field_value | Unknown |  |
| possible_value | Unknown |  |
| required | Unknown |  |
| value_type | Unknown |  |

### sale_order_return

| Column | Type | Keys |
| --- | --- | --- |
| code | Unknown | PK |
| sale_order_code | Unknown | PK, FK |
| action_code | Unknown |  |
| putaway_code | Unknown |  |
| return_invoice_code | Unknown |  |
| return_invoice_display_code | Unknown |  |
| shipping_provider | Unknown |  |
| status_code | Unknown |  |
| tracking_number | Unknown |  |
| type | Unknown |  |

### sale_order_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| sale_order_code | Unknown | PK, FK |
| reverse_pickup_code | Unknown | FK |
| shipping_address_id | Unknown | FK |
| shipping_package_code | Unknown | FK |
| alternate_facility_code | Unknown |  |
| batch_dto | Unknown |  |
| brand | Unknown |  |
| bundle_sku_code | Unknown |  |
| cancellable | Unknown |  |
| cancellation_reason | Unknown |  |
| cancelled_by_seller | Unknown |  |
| cash_on_delivery_charge | Unknown |  |
| central_gst_percentage | Unknown |  |
| channel_expiry_date | Unknown |  |
| channel_mfd | Unknown |  |
| channel_mrp | Unknown |  |
| channel_sale_order_item_code | Unknown |  |
| channel_vendor_batch_number | Unknown |  |
| code | Unknown |  |
| color | Unknown |  |
| combination_description | Unknown |  |
| combination_identifier | Unknown |  |
| country_of_origin | Unknown |  |
| created | Unknown |  |
| custom_field_value | Unknown |  |
| discount | Unknown |  |
| edit_address | Unknown |  |
| effective_tolerance | Unknown |  |
| expected_delivery_date | Unknown |  |
| facility_code | Unknown |  |
| facility_name | Unknown |  |
| gift_message | Unknown |  |
| gift_wrap | Unknown |  |
| gift_wrap_charge | Unknown |  |
| hsn_code | Unknown |  |
| image_url | Unknown |  |
| integrated_gst_percentage | Unknown |  |
| item | Unknown |  |
| item_detail_field | Unknown |  |
| item_detail_field_dto_list | Unknown |  |
| item_name | Unknown |  |
| item_sku | Unknown |  |
| max_retail_price | Unknown |  |
| on_hold | Unknown |  |
| packet_configurable | Unknown |  |
| packet_number | Unknown |  |
| page_url | Unknown |  |
| prepaid_amount | Unknown |  |
| replacement_sale_order_code | Unknown |  |
| reverse_pickable | Unknown |  |
| sale_order_item_alternate_id | Unknown |  |
| selling_price | Unknown |  |
| selling_price_without_taxes_and_discount | Unknown |  |
| shelf_code | Unknown |  |
| shipping_charge | Unknown |  |
| shipping_charge_tax_percentage | Unknown |  |
| shipping_method_charge | Unknown |  |
| shipping_method_code | Unknown |  |
| shipping_package_status | Unknown |  |
| size | Unknown |  |
| state_gst_percentage | Unknown |  |
| status_code | Unknown |  |
| store_credit | Unknown |  |
| tax_percentage | Unknown |  |
| tcs | Unknown |  |
| total_central_gst | Unknown |  |
| total_integrated_gst | Unknown |  |
| total_price | Unknown |  |
| total_state_gst | Unknown |  |
| total_union_territory_gst | Unknown |  |
| type | Unknown |  |
| uc_batch_code | Unknown |  |
| union_territory_gst_percentage | Unknown |  |
| updated | Unknown |  |
| voucher_code | Unknown |  |
| voucher_value | Unknown |  |

### shipping_package_item

| Column | Type | Keys |
| --- | --- | --- |
| item_sku | Unknown | PK |
| sale_order_shipping_package_code | Unknown | PK, FK |
| item_name | Unknown |  |
| quantity | Unknown |  |

### sale_order_shipping_package

| Column | Type | Keys |
| --- | --- | --- |
| code | Unknown | PK |
| sale_order_code | Unknown | FK |
| actual_weight | Unknown |  |
| channel | Unknown |  |
| channel_shipment_code | Unknown |  |
| city | Unknown |  |
| collectable_amount | Unknown |  |
| collected_amount | Unknown |  |
| courier_status | Unknown |  |
| created | Unknown |  |
| custom_field_value | Unknown |  |
| customer | Unknown |  |
| delivered | Unknown |  |
| dispatched | Unknown |  |
| estimated_weight | Unknown |  |
| invoice | Unknown |  |
| invoice_code | Unknown |  |
| invoice_date | Unknown |  |
| invoice_display_code | Unknown |  |
| irn | Unknown |  |
| no_of_item | Unknown |  |
| payment_reconciled | Unknown |  |
| pod_code | Unknown |  |
| shipping_courier | Unknown |  |
| shipping_label_link | Unknown |  |
| shipping_manifest_code | Unknown |  |
| shipping_method | Unknown |  |
| shipping_package_type | Unknown |  |
| shipping_provider | Unknown |  |
| status | Unknown |  |
| tracking_number | Unknown |  |
| tracking_status | Unknown |  |
| updated | Unknown |  |

### sale_order_address

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| sale_order_code | Unknown | PK, FK |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| district | Unknown |  |
| email | Unknown |  |
| name | Unknown |  |
| phone | Unknown |  |
| pincode | Unknown |  |
| state | Unknown |  |
| type | Unknown |  |

### sale_order

| Column | Type | Keys |
| --- | --- | --- |
| code | Unknown | PK |
| additional_info | Unknown |  |
| amount_paid | Unknown |  |
| billing_address_city | Unknown |  |
| billing_address_country | Unknown |  |
| billing_address_district | Unknown |  |
| billing_address_email | Unknown |  |
| billing_address_id | Unknown |  |
| billing_address_line_1 | Unknown |  |
| billing_address_line_2 | Unknown |  |
| billing_address_name | Unknown |  |
| billing_address_phone | Unknown |  |
| billing_address_pincode | Unknown |  |
| billing_address_state | Unknown |  |
| billing_address_type | Unknown |  |
| c_form_provided | Unknown |  |
| cancellable | Unknown |  |
| channel | Unknown |  |
| channel_processing_time | Unknown |  |
| cod | Unknown |  |
| created | Unknown |  |
| currency_code | Unknown |  |
| customer_code | Unknown |  |
| customer_gstin | Unknown |  |
| display_order_code | Unknown |  |
| display_order_date_time | Unknown |  |
| fulfillment_tat | Unknown |  |
| notification_email | Unknown |  |
| notification_mobile | Unknown |  |
| packet_configurable | Unknown |  |
| payment_detail | Unknown |  |
| payment_instrument | Unknown |  |
| payment_mode | Unknown |  |
| priority | Unknown |  |
| reverse_pickable | Unknown |  |
| sale_order_metadata | Json |  |
| source | Unknown |  |
| status | Unknown |  |
| third_party_shipping | Unknown |  |
| total_discount | Unknown |  |
| total_shipping_charge | Unknown |  |
| transaction_id | Unknown |  |
| updated | Unknown |  |

### gate_pass_item_dto

| Column | Type | Keys |
| --- | --- | --- |
| item_type_sku | Unknown | PK |
| gate_pass_code | Unknown | PK, FK |
| inflow_receipt_code | Unknown | FK |
| batch_dto | Unknown |  |
| central_gst_percentage | Unknown |  |
| compensation_cess_percentage | Unknown |  |
| gate_pass_item_id | Unknown |  |
| gate_pass_item_status | Unknown |  |
| hsn_code | Unknown |  |
| integrated_gst_percentage | Unknown |  |
| inventory_type | Unknown |  |
| item_code | Unknown |  |
| item_condition | Unknown |  |
| item_status | Unknown |  |
| item_type_image_url | Unknown |  |
| item_type_name | Unknown |  |
| item_type_page_url | Unknown |  |
| pending_quantity | Unknown |  |
| quantity | Unknown |  |
| reason | Unknown |  |
| received_quantity | Unknown |  |
| shelf_code | Unknown |  |
| state_gst_percentage | Unknown |  |
| tax_percentage | Unknown |  |
| total | Unknown |  |
| union_territory_gst_percentage | Unknown |  |
| unit_price | Unknown |  |

### gate_pass

| Column | Type | Keys |
| --- | --- | --- |
| code | Unknown | PK |
| created | Unknown |  |
| custom_field_value | Json |  |
| gate_pass_order_code | Unknown |  |
| id | Unknown |  |
| invoice_code | Unknown |  |
| invoice_display_code | Unknown |  |
| purpose | Unknown |  |
| reference | Unknown |  |
| return_invoice_code | Unknown |  |
| return_invoice_display_code | Unknown |  |
| status_code | Unknown |  |
| to_party_name | Unknown |  |
| type | Unknown |  |
| updated | Unknown |  |
| username | Unknown |  |

### inventory_snapshot

| Column | Type | Keys |
| --- | --- | --- |
| item_type_sku | Unknown | PK |
| inventory | Unknown |  |
| inventory_blocked | Unknown |  |
| open_purchase | Unknown |  |
| open_sale | Unknown |  |
| pending_inventory_assessment | Unknown |  |
| pending_stock_transfer | Unknown |  |
| putaway_pending | Unknown |  |
| vendor_inventory | Unknown |  |
| virtual_inventory | Unknown |  |

### rto_sale_order_item

| Column | Type | Keys |
| --- | --- | --- |
| sku_code | Unknown | PK |
| shipment_code | Unknown | PK, FK |
| sale_order_code | Unknown | FK |
| channel_product_id | Unknown |  |
| courier_status | Unknown |  |
| inventory_type | Unknown |  |
| item_name | Unknown |  |
| marketplace_return_reason | Unknown |  |
| putaway_qc_comment | Unknown |  |
| sale_order_item_code | Unknown |  |
| tracking_status | Unknown |  |

### purchase_order_custom_field_value

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| purchase_order_id | Unknown | PK, FK |
| display_name | Unknown |  |
| field_name | Unknown |  |
| field_value | Json |  |
| possible_value | Json |  |
| required | Unknown |  |
| value_type | Unknown |  |

### purchase_order_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| purchase_order_id | Unknown | PK, FK |
| item_sku | Unknown | FK |
| asn_pending_quantity | Unknown |  |
| batch_group_code | Unknown |  |
| central_gst_percentage | Unknown |  |
| custom_field_value | Json |  |
| determine_expiry_from | Unknown |  |
| discount | Unknown |  |
| discount_percentage | Unknown |  |
| expirable | Unknown |  |
| grn_expiry_tolerance | Unknown |  |
| integrated_gst_percentage | Unknown |  |
| item_type_custom_field | Json |  |
| item_type_id | Unknown |  |
| logistic_charge | Unknown |  |
| max_retail_price | Unknown |  |
| pending_quantity | Unknown |  |
| quantity | Unknown |  |
| rejected_quantity | Unknown |  |
| shelf_life | Unknown |  |
| state_gst_percentage | Unknown |  |
| sub_total | Unknown |  |
| tax | Unknown |  |
| tax_percentage | Unknown |  |
| tax_type | Unknown |  |
| total | Unknown |  |
| total_central_gst | Unknown |  |
| total_integrated_gst | Unknown |  |
| total_state_gst | Unknown |  |
| total_union_territory_gst | Unknown |  |
| union_territory_gst_percentage | Unknown |  |
| unit_price | Unknown |  |

### purchase_order

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| amended_purchase_order_code | Unknown |  |
| amendment_purchase_order_code | Unknown |  |
| code | Unknown |  |
| created | Unknown |  |
| created_by | Unknown |  |
| delivery_date | Unknown |  |
| expiry_date | Unknown |  |
| from_party | Unknown |  |
| inflow_receipts_count | Unknown |  |
| logistic_charge | Unknown |  |
| logistic_charges_division_method | Unknown |  |
| name | Unknown |  |
| party_address_dto_address_line_1 | Unknown |  |
| party_address_dto_address_line_2 | Unknown |  |
| party_address_dto_address_type | Unknown |  |
| party_address_dto_address_type_name | Unknown |  |
| party_address_dto_city | Unknown |  |
| party_address_dto_country_code | Unknown |  |
| party_address_dto_email | Unknown |  |
| party_address_dto_enabled | Unknown |  |
| party_address_dto_phone | Unknown |  |
| party_address_dto_pincode | Unknown |  |
| party_address_dto_state_code | Unknown |  |
| party_address_dto_state_name | Unknown |  |
| price_summary_currency_code | Unknown |  |
| price_summary_discount | Unknown |  |
| price_summary_logistic_charge | Unknown |  |
| price_summary_sub_total_before_taxes_and_discount | Unknown |  |
| price_summary_tax_on_sale | Unknown |  |
| price_summary_tcs_amount | Unknown |  |
| price_summary_total_amount | Unknown |  |
| price_summary_total_item | Unknown |  |
| rejection_reason | Unknown |  |
| status_code | Unknown |  |
| tcs_addition_enabled | Unknown |  |
| tcs_amount | Unknown |  |
| type | Unknown |  |
| vendor_agreement_name | Unknown |  |
| vendor_code | Unknown |  |
| vendor_id | Unknown |  |
| vendor_name | Unknown |  |

### cir_sale_order_item

| Column | Type | Keys |
| --- | --- | --- |
| sku_code | Unknown | PK |
| reverse_pickup_code | Unknown | PK, FK |
| sale_order_code | Unknown | FK |
| shipment_code | Unknown | FK |
| channel_product_id | Unknown |  |
| courier_status | Unknown |  |
| inventory_type | Unknown |  |
| item_name | Unknown |  |
| marketplace_return_reason | Unknown |  |
| putaway_qc_comment | Unknown |  |
| sale_order_item_code | Unknown |  |
| tracking_status | Unknown |  |

## Relationships

- inflow_receipt_item(item_sku) → gate_pass_item_dto(item_type_sku)
- inflow_receipt_item(purchase_order_item_id) → purchase_order_item(id)
- inflow_receipt_item(grn_code) → grn(code)
- grn_custom_field_value(grn_code) → grn(code)
- grn(purchase_order_code) → purchase_order(code)
- sale_order_custom_field_value(sale_order_code) → sale_order(code)
- sale_order_return(sale_order_code) → sale_order(code)
- sale_order_item(shipping_address_id) → sale_order_address(id)
- sale_order_item(shipping_package_code) → sale_order_shipping_package(code)
- sale_order_item(reverse_pickup_code) → sale_order_return(code)
- sale_order_item(sale_order_code) → sale_order(code)
- shipping_package_item(sale_order_shipping_package_code) → sale_order_shipping_package(code)
- sale_order_shipping_package(sale_order_code) → sale_order(code)
- sale_order_address(sale_order_code) → sale_order(code)
- gate_pass_item_dto(inflow_receipt_code) → grn(code)
- gate_pass_item_dto(gate_pass_code) → gate_pass(code)
- rto_sale_order_item(shipment_code) → sale_order_return(code)
- rto_sale_order_item(sale_order_code) → sale_order(code)
- purchase_order_custom_field_value(purchase_order_id) → purchase_order(id)
- purchase_order_item(item_sku) → inventory_snapshot(item_type_sku)
- purchase_order_item(purchase_order_id) → purchase_order(id)
- cir_sale_order_item(shipment_code) → sale_order_shipping_package(code)
- cir_sale_order_item(reverse_pickup_code) → sale_order_return(code)
- cir_sale_order_item(sale_order_code) → sale_order(code)