Purchase Order line
Tabelle public.purchase_order_line
public.purchase_order_lineSpalten
id: internalorg_id: ID to organisationpurchase_order_id: internalpurchase_order_number: internalline_number: internalitem_id: internalsupplier_item_id: internaldescription: internalquantity: double precisionunit_code: internalunit_price: double precisiontotal_amount: double precisioncurrency: internalstatus: internalcreated_by: integercreated_on: timestamp with time zonelast_modified_on: timestamp with time zonedeleted_on: timestamp with time zoneis_deleted: booleanopen_quantity: double precisionreceived_quantity: double precisionconfirmed_quantity: double precisionnote: textsub_org_id: internalsub_line_number: internalunit_price_per: double precisionbuyer_id: internalbuyer_name: internalunit_code_price: internalgeo_code: internalpromised_delivery_date: timestamp with time zonedelivery_method: internalrequested_ship_date: datereceived_base_mou_quantity: double precisionextended_amount: double precision
Analyse & Beschreibung
Technical Documentation for public.purchase_order_line Table
public.purchase_order_line TableIntroduction
The public.purchase_order_line table is designed to store detailed information about each line item within a purchase order. It captures various attributes of a purchase order line such as item details, quantities, prices, and statuses. This table is integral for managing and tracking purchase orders and their fulfillment status within an organizational context.
Column Descriptions
id
Meaning: Unique identifier for each purchase order line item.
Role: Primary Key.
Typical Contents: A UUID string uniquely identifying the purchase order line.
org_id
Meaning: Identifier for the organization associated with the purchase order.
Role: Foreign Key.
Typical Contents: A UUID string referencing an organization.
purchase_order_id
Meaning: Identifier for the purchase order to which the line item belongs.
Role: Foreign Key.
Typical Contents: A UUID string referencing a purchase order.
purchase_order_number
Meaning: The number assigned to the purchase order.
Role: Descriptive field.
Typical Contents: A string representing the purchase order number.
line_number
Meaning: The line number of the item within the purchase order.
Role: Descriptive field.
Typical Contents: A string denoting the line sequence in the purchase order.
item_id
Meaning: Identifier for the item being ordered.
Role: Foreign Key.
Typical Contents: A string representing the item code.
supplier_item_id
Meaning: Supplier-specific identifier for the item.
Role: Descriptive field.
Typical Contents: A string, may be null if not provided by the supplier.
description
Meaning: Description of the item.
Role: Descriptive field.
Typical Contents: A text description of the item.
quantity
Meaning: The number of units ordered.
Role: Descriptive field.
Typical Contents: A numeric value indicating ordered quantity.
unit_code
Meaning: Code representing the unit of measurement for the item.
Role: Descriptive field.
Typical Contents: A string representing units, e.g., 'EA' for each.
unit_price
Meaning: Price per unit of the item.
Role: Descriptive field.
Typical Contents: A numeric value representing the price per unit.
total_amount
Meaning: Total amount for the line item (quantity * unit price).
Role: Descriptive field.
Typical Contents: A numeric value representing the total amount.
currency
Meaning: Currency in which the purchase is made.
Role: Descriptive field.
Typical Contents: A string representing the currency code, e.g., 'USD'.
status
Meaning: Current status of the purchase order line.
Role: Descriptive field.
Typical Contents: A string indicating status, e.g., 'Received', 'Invoiced'.
created_by
Meaning: Identifier for the user who created the entry.
Role: Foreign Key.
Typical Contents: An integer representing the user ID.
created_on
Meaning: Timestamp of when the entry was created.
Role: Technical field.
Typical Contents: A timestamp with timezone information.
last_modified_on
Meaning: Timestamp of the last modification.
Role: Technical field.
Typical Contents: A timestamp with timezone information, may be null if never modified.
deleted_on
Meaning: Timestamp of when the entry was marked as deleted.
Role: Technical field.
Typical Contents: A timestamp with timezone information, may be null if not deleted.
is_deleted
Meaning: Indicates if the entry has been marked as deleted.
Role: Technical field.
Typical Contents: Boolean value (true/false).
open_quantity
Meaning: Quantity not yet received or invoiced.
Role: Descriptive field.
Typical Contents: A numeric value, typically zero if fully received.
received_quantity
Meaning: Quantity that has been received.
Role: Descriptive field.
Typical Contents: A numeric value indicating received quantity.
confirmed_quantity
Meaning: Quantity confirmed by supplier.
Role: Descriptive field.
Typical Contents: A numeric value, may be null if not confirmed.
note
Meaning: Additional notes regarding the purchase order line.
Role: Descriptive field.
Typical Contents: Text, may include special instructions or comments.
sub_org_id
Meaning: Identifier for the sub-organization associated with the purchase order line.
Role: Foreign Key.
Typical Contents: A string, potentially null if not applicable.
sub_line_number
Meaning: Sub-line number within the purchase order.
Role: Descriptive field.
Typical Contents: A string representing sub-line sequence.
unit_price_per
Meaning: Base unit price for the item.
Role: Descriptive field.
Typical Contents: A numeric value representing the base unit price.
buyer_id
Meaning: Identifier for the buyer responsible for the purchase.
Role: Foreign Key.
Typical Contents: A string representing the buyer ID.
buyer_name
Meaning: Name of the buyer responsible.
Role: Descriptive field.
Typical Contents: A string representing the buyer's name.
unit_code_price
Meaning: Unit code related to pricing.
Role: Descriptive field.
Typical Contents: A string, similar to unit_code.
geo_code
Meaning: Geographical code for delivery.
Role: Descriptive field.
Typical Contents: A string representing a geographic location.
promised_delivery_date
Meaning: Date promised for delivery.
Role: Descriptive field.
Typical Contents: A timestamp with timezone information.
delivery_method
Meaning: Method of delivery for the purchase order line.
Role: Descriptive field.
Typical Contents: A string representing delivery method.
requested_ship_date
Meaning: Date requested for shipment.
Role: Descriptive field.
Typical Contents: A date value.
received_base_mou_quantity
Meaning: Quantity received in base measurement units.
Role: Descriptive field.
Typical Contents: A numeric value indicating base MOU quantity received.
extended_amount
Meaning: Extended amount for the line item.
Role: Descriptive field.
Typical Contents: A numeric value representing the extended amount, which may be equal to total_amount if no discounts or additional charges apply.
Was this helpful?