Receive delivery line
Table public.receive_delivery_line
public.receive_delivery_lineSpalten
id: internalorg_id: ID to organisationreceive_delivery_id: internaldelivery_number: internalline_number: internalitem_id: internaldescription: internalshipped_quantity: double precisionstatus: internalcreated_by: integercreated_on: timestamp with time zonelast_modified_on: timestamp with time zonedeleted_on: timestamp with time zoneis_deleted: booleanpurchase_order: internalsequence_number: internalsub_org_id: internalshipped_quantity_unit_code: internalpacking_slip_quantity: double precisionpacking_slip_quantity_unit_code: internalreceived_quantity: double precisionreceived_quantity_unit_code: internalpurchase_order_line_number: internalstatus_effective_from: timestamp with time zonepurchase_order_sub_line_number: internalinvoiced_quantity: double precisioninvoice_matching_status: internalopen_quantity: double precisionlast_modified_by: internaldeleted_by: internal
Analyse & Beschreibung
Table Documentation: public.receive_delivery_line
public.receive_delivery_lineIntroduction
The public.receive_delivery_line table appears to be a detailed record of delivery and receipt lines associated with an organization's logistics and supply chain operations. Each row in the table represents a specific line item in a delivery, capturing details such as the item description, quantities shipped and received, and various status fields. The table serves as a vital component in tracking the movement of goods from shipment to receipt, including invoicing and order management.
Column Descriptions
id
Meaning: Unique identifier for each delivery line item.
Role: Primary Key.
Typical Contents: A unique universally unique identifier (UUID).
org_id
Meaning: Identifier for the organization associated with the delivery.
Role: Foreign Key.
Typical Contents: A UUID representing the organization.
receive_delivery_id
Meaning: Identifier linking to the overall delivery transaction.
Role: Foreign Key.
Typical Contents: A UUID associated with a specific delivery transaction.
delivery_number
Meaning: Unique number assigned to the delivery.
Role: Reference Field.
Typical Contents: A string representing the delivery number.
line_number
Meaning: Specific line number within a delivery.
Role: Reference Field.
Typical Contents: Numeric string indicating the sequence of the line.
item_id
Meaning: Identifier for the item being shipped.
Role: Reference Field.
Typical Contents: A numeric string corresponding to an item.
description
Meaning: Description of the item.
Role: Descriptive Field.
Typical Contents: Textual description of the item, e.g., "FLOUR, WHEAT, UN-BLEACHED ENRICHED, BULK".
shipped_quantity
Meaning: Quantity of the item that was shipped.
Role: Quantitative Field.
Typical Contents: A decimal number indicating the amount shipped.
status
Meaning: Current status of the delivery line item.
Role: Status Field.
Typical Contents: Text such as "Received".
created_by
Meaning: Identifier for the user or system that created the record.
Role: Audit Field.
Typical Contents: Integer representing a user ID.
created_on
Meaning: Timestamp when the record was created.
Role: Audit Field.
Typical Contents: Date and time with time zone.
last_modified_on
Meaning: Timestamp of the last modification.
Role: Audit Field.
Typical Contents: Date and time with time zone.
deleted_on
Meaning: Timestamp when the record was marked as deleted.
Role: Audit Field.
Typical Contents: Date and time with time zone, often null unless deleted.
is_deleted
Meaning: Indicates if the record is marked as deleted.
Role: Technical Field.
Typical Contents: Boolean value, true or false.
purchase_order
Meaning: Reference to the associated purchase order.
Role: Reference Field.
Typical Contents: Alphanumeric string representing a purchase order number.
sequence_number
Meaning: Sequence number for the delivery line.
Role: Reference Field.
Typical Contents: Numeric string, often null.
sub_org_id
Meaning: Identifier for a sub-organization involved.
Role: Foreign Key.
Typical Contents: UUID, often null.
shipped_quantity_unit_code
Meaning: Unit of measurement for shipped quantity.
Role: Reference Field.
Typical Contents: Code representing units, e.g., "LBP".
packing_slip_quantity
Meaning: Quantity as per the packing slip.
Role: Quantitative Field.
Typical Contents: Decimal number, often null.
packing_slip_quantity_unit_code
Meaning: Unit code for the packing slip quantity.
Role: Reference Field.
Typical Contents: Code representing units, often null.
received_quantity
Meaning: Quantity of items actually received.
Role: Quantitative Field.
Typical Contents: Decimal number indicating the amount received.
received_quantity_unit_code
Meaning: Unit code for received quantity.
Role: Reference Field.
Typical Contents: Code representing units, e.g., "LBP".
purchase_order_line_number
Meaning: Line number within the purchase order.
Role: Reference Field.
Typical Contents: Numeric string.
status_effective_from
Meaning: The date and time from when the status is effective.
Role: Status Field.
Typical Contents: Date and time with time zone, often null.
purchase_order_sub_line_number
Meaning: Sub-line number within the purchase order.
Role: Reference Field.
Typical Contents: Numeric string, often "000".
invoiced_quantity
Meaning: Quantity that has been invoiced.
Role: Quantitative Field.
Typical Contents: Decimal number.
invoice_matching_status
Meaning: Status of the invoice matching process.
Role: Status Field.
Typical Contents: Textual status code, e.g., "9.0".
open_quantity
Meaning: Quantity that remains open or not yet processed.
Role: Quantitative Field.
Typical Contents: Decimal number.
last_modified_by
Meaning: Identifier for the user who last modified the record.
Role: Audit Field.
Typical Contents: UUID of the user, often null.
deleted_by
Meaning: Identifier for the user who marked the record as deleted.
Role: Audit Field.
Typical Contents: UUID of the user, often null.
Last updated
Was this helpful?