DCL Logistics

Explore the interactive ERD

Table & Field Reference

rma_auth_line

Column	Type	Keys
`item_number`	Unknown	PK
`rma_id`	Unknown	PKFK
`description`	Unknown
`quantity`	Unknown
`serial_number`	Unknown

rma_return_detail

Column	Type	Keys
`item_number`	Unknown	PK
`rma_id`	Unknown	PKFK
`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	PKFK
`description`	Unknown
`price`	Unknown
`quantity`	Unknown

rma_received_line

Column	Type	Keys
`item_number`	Unknown	PK
`rma_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`ship_id`	Unknown	PKFK

order_shipment_shipped_line_lot_number

Column	Type	Keys
`lot_number`	Unknown	PK
`item_number`	Unknown	PKFK
`ship_id`	Unknown	PKFK

order_shipment_shipped_line_bundle_line

Column	Type	Keys
`item_number`	Unknown	PK
`order_shipment_shipped_line_item_number`	Unknown	PKFK
`ship_id`	Unknown	PKFK
`custom_field`	Unknown
`description`	Unknown
`line_number`	Unknown
`quantity`	Unknown

order_shipment_shipped_line

Column	Type	Keys
`item_number`	Unknown	PK
`ship_id`	Unknown	PKFK
`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	PKFK
`item_number`	Unknown	PKFK
`ship_id`	Unknown	PKFK

order_shipment_package_item_lot_number

Column	Type	Keys
`lot_number`	Unknown	PK
`carton_id`	Unknown	PKFK
`item_number`	Unknown	PKFK
`ship_id`	Unknown	PKFK

order_shipment_package_shipped_item

Column	Type	Keys
`item_number`	Unknown	PK
`carton_id`	Unknown	PKFK
`ship_id`	Unknown	PKFK
`custom_field`	Unknown
`description`	Unknown
`line_number`	Unknown
`quantity`	Unknown

order_shipment_package

Column	Type	Keys
`carton_id`	Unknown	PK
`ship_id`	Unknown	PKFK
`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