# Deposco schema ERD

Table and field reference for the Fivetran Deposco connector.

## Table & Field Reference

### inventory

| Column | Type | Keys |
| --- | --- | --- |
| item_number | Unknown | PK |
| facility_inventory | Json |  |

### receipt_line

| Column | Type | Keys |
| --- | --- | --- |
| number | Unknown | PK |
| item_number | Unknown | FK |
| order_number | Unknown | FK |
| create_item | Unknown |  |
| create_po | Unknown |  |
| expiration_date | Unknown |  |
| line_number | Unknown |  |
| lot_number | Unknown |  |
| order_type | Unknown |  |
| pack_qty | Unknown |  |
| pack_type | Unknown |  |
| quantity | Unknown |  |
| received_date | Unknown |  |
| receiving_container | Unknown |  |
| receiving_container_type | Unknown |  |
| receiving_facility | Unknown |  |
| receiving_location | Unknown |  |
| status | Unknown |  |

### billable_transaction

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| billable_transaction_config_active | Unknown |  |
| billable_transaction_config_business_unit | Unknown |  |
| billable_transaction_config_cost | Unknown |  |
| billable_transaction_config_custom_field_1 | Unknown |  |
| billable_transaction_config_custom_field_10 | Unknown |  |
| billable_transaction_config_custom_field_2 | Unknown |  |
| billable_transaction_config_custom_field_3 | Unknown |  |
| billable_transaction_config_custom_field_4 | Unknown |  |
| billable_transaction_config_custom_field_5 | Unknown |  |
| billable_transaction_config_custom_field_6 | Unknown |  |
| billable_transaction_config_custom_field_7 | Unknown |  |
| billable_transaction_config_custom_field_8 | Unknown |  |
| billable_transaction_config_custom_field_9 | Unknown |  |
| billable_transaction_config_custom_value_3 | Unknown |  |
| billable_transaction_config_description | Unknown |  |
| billable_transaction_config_generated_by | Unknown |  |
| billable_transaction_config_percent | Unknown |  |
| billable_transaction_config_price | Unknown |  |
| billable_transaction_config_profile_name | Unknown |  |
| billable_transaction_config_quantity | Unknown |  |
| billable_transaction_config_type | Unknown |  |
| business_unit | Unknown |  |
| created_by | Unknown |  |
| created_date_time | Unknown |  |
| description | Unknown |  |
| facility_number | Unknown |  |
| order_header_number | Unknown |  |
| quantity | Unknown |  |
| total_cost | Unknown |  |
| total_price | Unknown |  |
| transaction_type | Unknown |  |

### purchase_order_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| purchase_order_id | Unknown | PK, FK |
| item_number | Unknown | FK |
| allocated_quantity | Unknown |  |
| canceled_pack_quantity | Unknown |  |
| catch_weight | Unknown |  |
| created_by | Unknown |  |
| created_date_time | Unknown |  |
| custom_field | Json |  |
| custom_mapping_nil | Unknown |  |
| discount_amount | Unknown |  |
| extended_total | Unknown |  |
| line_number | Unknown |  |
| line_status | Unknown |  |
| line_total | Unknown |  |
| note | Json |  |
| order_number | Unknown |  |
| order_pack_quantity | Unknown |  |
| pack_custom_mapping_nil | Unknown |  |
| pack_dimension_nil | Unknown |  |
| pack_quantity | Unknown |  |
| pack_type | Unknown |  |
| pack_upcs_nil | Unknown |  |
| picked_pack_quantity | Unknown |  |
| received_damaged_pack_quantity | Unknown |  |
| received_pack_quantity | Unknown |  |
| shipped_pack_quantity | Unknown |  |
| shipping_amount | Unknown |  |
| shortage_pack_quantity | Unknown |  |
| sold_pack_quantity | Unknown |  |
| sort_order | Unknown |  |
| tax_cost | Unknown |  |
| unit_cost | Unknown |  |
| unit_price | Unknown |  |
| untaxable_total | Unknown |  |
| updated_by | Unknown |  |
| updated_date_time | Unknown |  |

### purchase_order

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| actual_arrival_date | Unknown |  |
| bill_to_address | Json |  |
| business_unit | Unknown |  |
| created_by | Unknown |  |
| created_date_time | Unknown |  |
| custom_mapping_nil | Unknown |  |
| drop_ship | Unknown |  |
| facility | Unknown |  |
| freight_bill_to_address | Json |  |
| insurance_required | Unknown |  |
| number | Unknown |  |
| on_time | Unknown |  |
| order_discount_subtotal | Unknown |  |
| order_priority | Unknown |  |
| order_ship_total | Unknown |  |
| order_shipping_total | Unknown |  |
| order_sub_total | Unknown |  |
| order_tax_total | Unknown |  |
| order_taxable_total | Unknown |  |
| order_total | Unknown |  |
| order_untaxable_total | Unknown |  |
| return_required | Unknown |  |
| saturday_delivery | Unknown |  |
| send_asn | Unknown |  |
| ship_from_address | Json |  |
| ship_to | Unknown |  |
| ship_to_address | Json |  |
| shipping_status | Unknown |  |
| shipping_tax_total | Unknown |  |
| status | Unknown |  |
| taxable | Unknown |  |
| type | Unknown |  |
| updated_by | Unknown |  |
| updated_date_time | Unknown |  |

### shipment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| line_item_number | Unknown | FK |
| actual_ship_date | Unknown |  |
| bill_to_address_attention | Unknown |  |
| bill_to_address_city | Unknown |  |
| bill_to_address_contact_name | Unknown |  |
| bill_to_address_country_code | Unknown |  |
| bill_to_address_line_1 | Unknown |  |
| bill_to_address_line_2 | Unknown |  |
| bill_to_address_line_3 | Unknown |  |
| bill_to_address_line_4 | Unknown |  |
| bill_to_address_name | Unknown |  |
| bill_to_address_phone | Unknown |  |
| bill_to_address_postal_code | Unknown |  |
| bill_to_address_state_province_code | Unknown |  |
| business_unit | Unknown |  |
| cod_amount | Unknown |  |
| container_depth_uom | Unknown |  |
| container_description | Unknown |  |
| container_lpn | Unknown |  |
| container_number | Unknown |  |
| container_status | Unknown |  |
| container_total_charge | Unknown |  |
| container_tracking_number | Unknown |  |
| container_type | Unknown |  |
| created_by | Unknown |  |
| dimension_height | Unknown |  |
| dimension_length | Unknown |  |
| dimension_unit | Unknown |  |
| dimension_volume | Unknown |  |
| dimension_width | Unknown |  |
| drop_ship | Unknown |  |
| extended_shipping_cost_nil | Unknown |  |
| facility | Unknown |  |
| insurance_required | Unknown |  |
| line_customer_number | Unknown |  |
| line_expiration_date | Unknown |  |
| line_lot_number | Unknown |  |
| line_number | Unknown |  |
| line_order_pack_quantity | Unknown |  |
| line_shipment_number | Unknown |  |
| line_shipped_pack_quantity | Unknown |  |
| line_status | Unknown |  |
| line_tracking_number | Unknown |  |
| note_body | Unknown |  |
| note_title | Unknown |  |
| notification_code_1 | Unknown |  |
| order_customer_number | Unknown |  |
| order_number | Unknown |  |
| order_other_reference_number | Unknown |  |
| order_shipping_status | Unknown |  |
| order_source | Unknown |  |
| order_status | Unknown |  |
| order_type | Unknown |  |
| pack_custom_mapping_nil | Unknown |  |
| pack_dimension_nil | Unknown |  |
| pack_quantity | Unknown |  |
| pack_type | Unknown |  |
| pack_upcs_nil | Unknown |  |
| planned_ship_date | Unknown |  |
| rate_zone | Unknown |  |
| residential | Unknown |  |
| saturday_delivery | Unknown |  |
| ship_from_address_attention | Unknown |  |
| ship_from_address_city | Unknown |  |
| ship_from_address_country_code | Unknown |  |
| ship_from_address_line_1 | Unknown |  |
| ship_from_address_phone | Unknown |  |
| ship_from_address_postal_code | Unknown |  |
| ship_from_address_state_province_code | Unknown |  |
| ship_to_address_attention | Unknown |  |
| ship_to_address_city | Unknown |  |
| ship_to_address_contact_name | Unknown |  |
| ship_to_address_country_code | Unknown |  |
| ship_to_address_email | Unknown |  |
| ship_to_address_line_1 | Unknown |  |
| ship_to_address_line_2 | Unknown |  |
| ship_to_address_line_3 | Unknown |  |
| ship_to_address_line_4 | Unknown |  |
| ship_to_address_name | Unknown |  |
| ship_to_address_phone | Unknown |  |
| ship_to_address_postal_code | Unknown |  |
| ship_to_address_state_province_code | Unknown |  |
| ship_vendor | Unknown |  |
| ship_via | Unknown |  |
| shipment_number | Unknown |  |
| shipment_status | Unknown |  |
| shipping_cost | Unknown |  |
| tax_cost | Unknown |  |
| tracking_number | Unknown |  |
| tracking_url | Unknown |  |
| trading_partner | Unknown |  |
| type | Unknown |  |
| unit | Unknown |  |
| weight | Unknown |  |

### sales_order_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| sales_order_id | Unknown | PK, FK |
| item_number | Unknown | FK |
| allocated_quantity | Unknown |  |
| canceled_pack_quantity | Unknown |  |
| catch_weight | Unknown |  |
| created_by | Unknown |  |
| created_date_time | Unknown |  |
| custom_field | Json |  |
| custom_mapping_nil | Unknown |  |
| customer_line_number | Unknown |  |
| discount_amount | Unknown |  |
| export_reference | Unknown |  |
| extended_total | Unknown |  |
| line_number | Unknown |  |
| line_status | Unknown |  |
| line_total | Unknown |  |
| note | Json |  |
| order_number | Unknown |  |
| order_pack_quantity | Unknown |  |
| pack_custom_mapping_nil | Unknown |  |
| pack_dimension_nil | Unknown |  |
| pack_quantity | Unknown |  |
| pack_type | Unknown |  |
| pack_upcs_nil | Unknown |  |
| picked_pack_quantity | Unknown |  |
| received_damaged_pack_quantity | Unknown |  |
| received_pack_quantity | Unknown |  |
| ship_from | Unknown |  |
| shipped_pack_quantity | Unknown |  |
| shipping_amount | Unknown |  |
| shortage_pack_quantity | Unknown |  |
| sold_pack_quantity | Unknown |  |
| sort_order | Unknown |  |
| tax_cost | Unknown |  |
| unit_cost | Unknown |  |
| unit_price | Unknown |  |
| untaxable_total | Unknown |  |
| updated_by | Unknown |  |
| updated_date_time | Unknown |  |
| zone_number | Unknown |  |

### sales_order

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| actual_ship_date | Unknown |  |
| bill_to_address_attention | Unknown |  |
| bill_to_address_city | Unknown |  |
| bill_to_address_contact_name | Unknown |  |
| bill_to_address_country_code | Unknown |  |
| bill_to_address_email | Unknown |  |
| bill_to_address_line_1 | Unknown |  |
| bill_to_address_line_2 | Unknown |  |
| bill_to_address_name | Unknown |  |
| bill_to_address_phone | Unknown |  |
| bill_to_address_postal_code | Unknown |  |
| bill_to_address_state_province_code | Unknown |  |
| business_unit | Unknown |  |
| cancel_by_arrival_date | Unknown |  |
| cancel_by_ship_date | Unknown |  |
| created_by | Unknown |  |
| created_date_time | Unknown |  |
| custom_attribute_1 | Unknown |  |
| custom_attribute_2 | Unknown |  |
| custom_attribute_3 | Unknown |  |
| custom_attribute_4 | Unknown |  |
| custom_attribute_5 | Unknown |  |
| custom_mapping_nil | Unknown |  |
| customer_order_number | Unknown |  |
| drop_ship | Unknown |  |
| facility | Unknown |  |
| freight_bill_to_address | Unknown |  |
| freight_term_type | Unknown |  |
| import_type | Unknown |  |
| insurance_required | Unknown |  |
| note_body | Unknown |  |
| note_title | Unknown |  |
| notification_code_1 | Unknown |  |
| number | Unknown |  |
| on_time | Unknown |  |
| order_discount_subtotal | Unknown |  |
| order_priority | Unknown |  |
| order_ship_total | Unknown |  |
| order_shipping_total | Unknown |  |
| order_source | Unknown |  |
| order_sub_total | Unknown |  |
| order_tax_total | Unknown |  |
| order_taxable_total | Unknown |  |
| order_total | Unknown |  |
| order_untaxable_total | Unknown |  |
| other_reference_number | Unknown |  |
| other_reference_number_2 | Unknown |  |
| placed_date | Unknown |  |
| planned_ship_date | Unknown |  |
| related_order_number | Unknown |  |
| return_required | Unknown |  |
| saturday_delivery | Unknown |  |
| send_asn | Unknown |  |
| ship_from_address | Unknown |  |
| ship_to_address_attention | Unknown |  |
| ship_to_address_city | Unknown |  |
| ship_to_address_contact_name | Unknown |  |
| ship_to_address_country_code | Unknown |  |
| ship_to_address_email | Unknown |  |
| ship_to_address_line_1 | Unknown |  |
| ship_to_address_line_2 | Unknown |  |
| ship_to_address_name | Unknown |  |
| ship_to_address_phone | Unknown |  |
| ship_to_address_postal_code | Unknown |  |
| ship_to_address_state_province_code | Unknown |  |
| ship_to_email | Unknown |  |
| ship_vendor | Unknown |  |
| ship_via | Unknown |  |
| shipping_status | Unknown |  |
| shipping_tax_total | Unknown |  |
| status | Unknown |  |
| taxable | Unknown |  |
| trading_partner | Unknown |  |
| type | Unknown |  |
| updated_by | Unknown |  |
| updated_date_time | Unknown |  |

### billing_invoice_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| invoice_number | Unknown | PK, FK |
| billing_transaction_type | Unknown |  |
| business_unit | Unknown |  |
| created_by | Unknown |  |
| created_date_time | Unknown |  |
| line_number | Unknown |  |
| quantity | Unknown |  |
| total_price | Unknown |  |
| updated_by | Unknown |  |
| updated_date_time | Unknown |  |

### billing_invoice

| Column | Type | Keys |
| --- | --- | --- |
| number | Unknown | PK |
| billing_end_date_time | Unknown |  |
| billing_start_date_time | Unknown |  |
| business_unit | Unknown |  |
| created_by | Unknown |  |
| created_date_time | Unknown |  |
| status | Unknown |  |
| updated_by | Unknown |  |
| updated_date_time | Unknown |  |

## Relationships

- receipt_line(order_number) → purchase_order(id)
- receipt_line(item_number) → inventory(item_number)
- purchase_order_line(item_number) → inventory(item_number)
- purchase_order_line(purchase_order_id) → purchase_order(id)
- shipment(line_item_number) → inventory(item_number)
- sales_order_line(item_number) → inventory(item_number)
- sales_order_line(sales_order_id) → sales_order(id)
- billing_invoice_line(invoice_number) → billing_invoice(number)