Receiving Line¶

Table name (referenced in Insights SQL queries): marts_mdc__receiving_line

Contains details about the receiving process, including expected and actual quantities, timestamps, supplier, warehouse, and product information. Helps track and manage inventory reception efficiently.

Columns¶

Column	Type	Description
`receiving_id`	`number`	Unique identifier for the receiving event.
`receiving_line_key`	`varchar`	Unique identifier of the line within the given Receiving provided by the Merchant
`account_name`	`varchar`	Name of the account associated with the receiving event.
`account_id`	`number`	Identifier for the account linked to the receiving event.
`warehouse_name`	`varchar`	Name of the warehouse where the receiving occurred.
`warehouse_id`	`number`	Identifier of the warehouse linked to the receiving event.
`receiving_key`	`varchar`	Unique Receiving identifier provided by the Merchant
`receiving_asn`	`varchar`	Advanced Shipment Notice associated with the receiving event.
`receiving_category`	`varchar`	Receiving category
`receiving_supplier_name`	`varchar`	Name of the supplier related to the receiving event.
`receiving_status`	`varchar`	Status of the receiving process.
`receiving_type_of_packing`	`varchar`	Type of packing used in the shipment.
`receiving_amount_of_handling_units`	`number`	Amount of handling units
`receiving_description`	`varchar`	Detailed description of the receiving event.
`product_name`	`varchar`	Name of the product received.
`product_id`	`number`	Identifier for the product received.
`sku`	`varchar`	Stock Keeping Unit (SKU) of the product received.
`lot_number`	`varchar`	Lot number of the inventory
`lot_expiration_date`	`date`	Expiration date of the inventory
`expected_quantity`	`number`	Quantity expected to be received.
`received_quantity`	`number`	Quantity actually received.
`receiving_created_at_utc`	`timestamp_ntz`	Timestamp when the receiving record was created.
`receiving_estimated_delivery_at_utc`	`timestamp_ntz`	Estimated delivery date and time.
`receiving_arrived_at_utc`	`timestamp_ntz`	Timestamp when the items arrived at the warehouse.
`receiving_received_at_utc`	`timestamp_ntz`	Timestamp when the items were marked as received.
`receiving_line_created_at_utc`	`timestamp_ntz`	Timestamp when the receiving line has been originally created.
`receiving_tracking_numbers`	`varchar`	Comma-separated list of carrier tracking numbers associated with the receiving, ordered alphabetically.
`receiving_tracking_numbers_count`	`number`	Number of tracking numbers associated with the receiving.
`location_timezone`	`varchar`	Timezone of the warehouse location.