# DCL Logistics schema ERD

Table and field reference for the Fivetran DCL Logistics connector.

## Table & Field Reference

### rma_auth_line

| Column | Type | Keys |
| --- | --- | --- |
| item_number | Unknown | PK |
| rma_id | Unknown | PK, FK |
| description | Unknown |  |
| quantity | Unknown |  |
| serial_number | Unknown |  |

### rma_return_detail

| Column | Type | Keys |
| --- | --- | --- |
| item_number | Unknown | PK |
| rma_id | Unknown | PK, FK |
| authorized_line_number | Unknown |  |
| authorized_quantity | Unknown |  |
| condition | Unknown |  |
| condition_code | Unknown |  |
| disposition | Unknown |  |
| disposition_code | Unknown |  |
| is_cancelled | Unknown |  |
| om_line_number | Unknown |  |
| received_date | Unknown |  |
| received_quantity | Unknown |  |
| received_serial_number | Unknown |  |

### rma_ship_line

| Column | Type | Keys |
| --- | --- | --- |
| item_number | Unknown | PK |
| rma_id | Unknown | PK, FK |
| description | Unknown |  |
| price | Unknown |  |
| quantity | Unknown |  |

### rma_received_line

| Column | Type | Keys |
| --- | --- | --- |
| item_number | Unknown | PK |
| rma_id | Unknown | PK, FK |
| condition | Unknown |  |
| disposition | Unknown |  |
| line_number | Unknown |  |
| quantity | Unknown |  |
| received_on | Unknown |  |
| serial_number | Unknown |  |

### rma_line

| Column | Type | Keys |
| --- | --- | --- |
| item_number | Unknown | PK |
| rma_id | Unknown | PK, FK |
| description | Unknown |  |
| price | Unknown |  |
| quantity | Unknown |  |
| serial_number | Unknown |  |
| ship_description | Unknown |  |
| ship_item_number | Unknown |  |
| ship_price | Unknown |  |
| ship_quantity | Unknown |  |

### rma

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| cancelled_date | Unknown |  |
| comments | Unknown |  |
| custom_option_1 | Unknown |  |
| custom_option_2 | Unknown |  |
| custom_option_3 | Unknown |  |
| custom_option_4 | Unknown |  |
| custom_option_5 | Unknown |  |
| custom_option_6 | Unknown |  |
| custom_option_7 | Unknown |  |
| customer_number | Unknown |  |
| disposition | Unknown |  |
| expired_date | Unknown |  |
| order_amount | Unknown |  |
| original_order_number | Unknown |  |
| received_lines | Unknown |  |
| replacement_order | Unknown |  |
| restocking_fee | Unknown |  |
| return_label_tracking_number | Unknown |  |
| return_label_url | Unknown |  |
| rma_account_number | Unknown |  |
| rma_date | Unknown |  |
| rma_location | Unknown |  |
| rma_type | Unknown |  |
| sales_tax | Unknown |  |
| ship_lines | Unknown |  |
| shipping_account_number | Unknown |  |
| shipping_address_address_1 | Unknown |  |
| shipping_address_address_2 | Unknown |  |
| shipping_address_attention | Unknown |  |
| shipping_address_city | Unknown |  |
| shipping_address_company | Unknown |  |
| shipping_address_country | Unknown |  |
| shipping_address_email | Unknown |  |
| shipping_address_phone | Unknown |  |
| shipping_address_postal_code | Unknown |  |
| shipping_address_state_province | Unknown |  |
| shipping_carrier | Unknown |  |
| shipping_handling | Unknown |  |
| shipping_instructions | Unknown |  |
| shipping_location | Unknown |  |
| shipping_service | Unknown |  |
| total_amount | Unknown |  |

### item_lot

| Column | Type | Keys |
| --- | --- | --- |
| lot_number | Unknown | PK |
| item_id | Unknown | PK, FK |
| available | Unknown |  |
| committed | Unknown |  |
| expiration_date | Unknown |  |
| in_process | Unknown |  |
| on_hand | Unknown |  |
| on_hold | Unknown |  |

### item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| available | Unknown |  |
| committed | Unknown |  |
| dcl_quantity | Unknown |  |
| description | Unknown |  |
| in_process | Unknown |  |
| inventory_type | Unknown |  |
| min_quantity | Unknown |  |
| net_available | Unknown |  |
| on_demand | Unknown |  |
| on_hand | Unknown |  |
| on_hold | Unknown |  |
| open_po | Unknown |  |
| open_rma | Unknown |  |
| open_wo | Unknown |  |

### order_line_bundle_line

| Column | Type | Keys |
| --- | --- | --- |
| item_number | Unknown | PK |
| line_number | Unknown | PK |
| order_line_item_number | Unknown | PK, FK |
| comments | Unknown |  |
| custom_field_1 | Unknown |  |
| custom_field_2 | Unknown |  |
| custom_field_3 | Unknown |  |
| custom_field_4 | Unknown |  |
| custom_field_5 | Unknown |  |
| description | Unknown |  |
| do_not_ship_before | Unknown |  |
| is_back_order | Unknown |  |
| price | Unknown |  |
| quantity | Unknown |  |
| ship_by | Unknown |  |

### order_line

| Column | Type | Keys |
| --- | --- | --- |
| item_number | Unknown | PK |
| order_number | Unknown | PK, FK |
| comments | Unknown |  |
| custom_field_1 | Unknown |  |
| custom_field_2 | Unknown |  |
| custom_field_3 | Unknown |  |
| custom_field_4 | Unknown |  |
| custom_field_5 | Unknown |  |
| description | Unknown |  |
| do_not_ship_before | Unknown |  |
| is_back_order | Unknown |  |
| line_number | Unknown |  |
| price | Unknown |  |
| quantity | Unknown |  |
| ship_by | Unknown |  |

### order_shipment_shipped_line_serial_number

| Column | Type | Keys |
| --- | --- | --- |
| serial_number | Unknown | PK |
| order_shipment_shipped_line_item_number | Unknown | PK, FK |
| ship_id | Unknown | PK, FK |

### order_shipment_shipped_line_lot_number

| Column | Type | Keys |
| --- | --- | --- |
| lot_number | Unknown | PK |
| item_number | Unknown | PK, FK |
| ship_id | Unknown | PK, FK |

### order_shipment_shipped_line_bundle_line

| Column | Type | Keys |
| --- | --- | --- |
| item_number | Unknown | PK |
| order_shipment_shipped_line_item_number | Unknown | PK, FK |
| ship_id | Unknown | PK, FK |
| custom_field | Unknown |  |
| description | Unknown |  |
| line_number | Unknown |  |
| quantity | Unknown |  |

### order_shipment_shipped_line

| Column | Type | Keys |
| --- | --- | --- |
| item_number | Unknown | PK |
| ship_id | Unknown | PK, FK |
| custom_field | Unknown |  |
| description | Unknown |  |
| line_number | Unknown |  |
| quantity | Unknown |  |

### order_shipment_package_item_serial_number

| Column | Type | Keys |
| --- | --- | --- |
| serial_number | Unknown | PK |
| carton_id | Unknown | PK, FK |
| item_number | Unknown | PK, FK |
| ship_id | Unknown | PK, FK |

### order_shipment_package_item_lot_number

| Column | Type | Keys |
| --- | --- | --- |
| lot_number | Unknown | PK |
| carton_id | Unknown | PK, FK |
| item_number | Unknown | PK, FK |
| ship_id | Unknown | PK, FK |

### order_shipment_package_shipped_item

| Column | Type | Keys |
| --- | --- | --- |
| item_number | Unknown | PK |
| carton_id | Unknown | PK, FK |
| ship_id | Unknown | PK, FK |
| custom_field | Unknown |  |
| description | Unknown |  |
| line_number | Unknown |  |
| quantity | Unknown |  |

### order_shipment_package

| Column | Type | Keys |
| --- | --- | --- |
| carton_id | Unknown | PK |
| ship_id | Unknown | PK, FK |
| asn | Unknown |  |
| carton_count_number | Unknown |  |
| delivery_date | Unknown |  |
| delivery_status | Unknown |  |
| dimension | Unknown |  |
| freight | Unknown |  |
| tracking_number | Unknown |  |
| weight | Unknown |  |

### order_shipment

| Column | Type | Keys |
| --- | --- | --- |
| ship_id | Unknown | PK |
| order_number | Unknown | FK |
| freight_account | Unknown |  |
| reference_1 | Unknown |  |
| reference_2 | Unknown |  |
| reference_3 | Unknown |  |
| reference_4 | Unknown |  |
| rs_tracking_number | Unknown |  |
| ship_date | Unknown |  |
| shipping_address | Unknown |  |
| shipping_carrier | Unknown |  |
| shipping_service | Unknown |  |
| total_charge | Unknown |  |
| total_weight | Unknown |  |

### orders

| Column | Type | Keys |
| --- | --- | --- |
| order_number | Unknown | PK |
| account_number | Unknown |  |
| amount_paid | Unknown |  |
| balance_due_us | Unknown |  |
| billing_address_address_1 | Unknown |  |
| billing_address_address_2 | Unknown |  |
| billing_address_attention | Unknown |  |
| billing_address_city | Unknown |  |
| billing_address_company | Unknown |  |
| billing_address_country | Unknown |  |
| billing_address_email | Unknown |  |
| billing_address_phone | Unknown |  |
| billing_address_postal_code | Unknown |  |
| billing_address_state_province | Unknown |  |
| consignee_number | Unknown |  |
| custom_field_1 | Unknown |  |
| custom_field_2 | Unknown |  |
| custom_field_3 | Unknown |  |
| custom_field_4 | Unknown |  |
| custom_field_5 | Unknown |  |
| customer_number | Unknown |  |
| fob | Unknown |  |
| freight_account | Unknown |  |
| international_code | Unknown |  |
| international_declared_value | Unknown |  |
| international_handling | Unknown |  |
| is_back_order | Unknown |  |
| is_cancelled | Unknown |  |
| location | Unknown |  |
| modified_at | Instant |  |
| net_due_currency | Unknown |  |
| order_stage | Unknown |  |
| order_status | Unknown |  |
| order_subtotal | Unknown |  |
| ordered_date | Unknown |  |
| packing_list_comments | Unknown |  |
| packing_list_type | Unknown |  |
| payment_type | Unknown |  |
| po_number | Unknown |  |
| received_date | Unknown |  |
| sales_tax | Unknown |  |
| shipping_address_address_1 | Unknown |  |
| shipping_address_address_2 | Unknown |  |
| shipping_address_attention | Unknown |  |
| shipping_address_city | Unknown |  |
| shipping_address_company | Unknown |  |
| shipping_address_country | Unknown |  |
| shipping_address_email | Unknown |  |
| shipping_address_phone | Unknown |  |
| shipping_address_postal_code | Unknown |  |
| shipping_address_state_province | Unknown |  |
| shipping_carrier | Unknown |  |
| shipping_handling | Unknown |  |
| shipping_instructions | Unknown |  |
| shipping_service | Unknown |  |
| stage_description | Unknown |  |
| system_id | Unknown |  |
| terms | Unknown |  |
| total_due | Unknown |  |
| type | Unknown |  |

## Relationships

- rma_auth_line(rma_id) → rma(id)
- rma_return_detail(rma_id) → rma(id)
- rma_ship_line(rma_id) → rma(id)
- rma_received_line(rma_id) → rma(id)
- rma_line(rma_id) → rma(id)
- item_lot(item_id) → item(id)
- order_line_bundle_line(order_line_item_number) → order_line(item_number)
- order_line(order_number) → orders(order_number)
- order_shipment_shipped_line_serial_number(order_shipment_shipped_line_item_number) → order_shipment_shipped_line(item_number)
- order_shipment_shipped_line_serial_number(ship_id) → order_shipment(ship_id)
- order_shipment_shipped_line_lot_number(item_number) → order_shipment_shipped_line(item_number)
- order_shipment_shipped_line_lot_number(ship_id) → order_shipment(ship_id)
- order_shipment_shipped_line_bundle_line(order_shipment_shipped_line_item_number) → order_shipment_shipped_line(item_number)
- order_shipment_shipped_line_bundle_line(ship_id) → order_shipment(ship_id)
- order_shipment_shipped_line(ship_id) → order_shipment(ship_id)
- order_shipment_package_item_serial_number(item_number) → order_shipment_package_shipped_item(item_number)
- order_shipment_package_item_serial_number(carton_id) → order_shipment_package(carton_id)
- order_shipment_package_item_serial_number(ship_id) → order_shipment(ship_id)
- order_shipment_package_item_lot_number(item_number) → order_shipment_package_shipped_item(item_number)
- order_shipment_package_item_lot_number(carton_id) → order_shipment_package(carton_id)
- order_shipment_package_item_lot_number(ship_id) → order_shipment(ship_id)
- order_shipment_package_shipped_item(carton_id) → order_shipment_package(carton_id)
- order_shipment_package_shipped_item(ship_id) → order_shipment(ship_id)
- order_shipment_package(ship_id) → order_shipment(ship_id)
- order_shipment(order_number) → orders(order_number)