Deposco

Explore the interactive ERD

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	PKFK
`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	PKFK
`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	PKFK
`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