Sales order

Table public.sales_order

Spalten

  • id: internal

  • org_id: ID to organisation

  • sub_org_id: internal

  • location_id: internal

  • order_number: internal

  • customer_purchase_order: internal

  • customer_id: internal

  • customer_name: internal

  • warehouse_id: internal

  • warehouse_name: internal

  • transportation_method: internal

  • requested_delivery_date: timestamp with time zone

  • order_date: timestamp with time zone

  • sales_person_id: internal

  • sales_person_name: internal

  • ship_to_party_id: internal

  • ship_to_party_name: internal

  • ship_to_party_city: internal

  • ship_to_party_state: internal

  • ship_to_party_country: internal

  • ship_to_party_zip: internal

  • status: internal

  • created_by: integer

  • created_on: timestamp with time zone

  • last_modified_on: timestamp with time zone

  • is_deleted: boolean

  • deleted_on: timestamp with time zone

  • preview_path: internal

  • last_modified_by: internal

  • deleted_by: internal

Analyse & Beschreibung

Technical Documentation for public.sales_order Table

Introduction

The public.sales_order table is designed to capture and store information related to sales orders within a business context. This includes details about the order, the customer, the logistics, and various metadata associated with the order's lifecycle. The table serves as a central repository for tracking the status and history of sales transactions.

Column Descriptions

id

  • Meaning: Unique identifier for each sales order.

  • Role: Primary key.

  • Typical Contents: A UUID string (e.g., '6ffe4673-7563-44dc-8e71-855e8f25534a').

org_id

  • Meaning: Identifier for the organization that created the sales order.

  • Role: Foreign key.

  • Typical Contents: A UUID string representing the organization (e.g., '23f3d697-7411-4c95-981d-faf089d266be').

sub_org_id

  • Meaning: Identifier for a sub-organization, if applicable.

  • Role: Foreign key.

  • Typical Contents: May be NULL if not applicable.

location_id

  • Meaning: Identifier for the location associated with the sales order.

  • Role: Foreign key.

  • Typical Contents: A string code representing a location (e.g., '028').

order_number

  • Meaning: Unique number assigned to the sales order.

  • Role: Technical field for order tracking.

  • Typical Contents: A string (e.g., '0010174175').

customer_purchase_order

  • Meaning: Reference number for the customer's purchase order.

  • Role: Technical field for cross-referencing.

  • Typical Contents: A string (e.g., '1YFNC3').

customer_id

  • Meaning: Identifier for the customer placing the order.

  • Role: Foreign key.

  • Typical Contents: A string code (e.g., '35623000').

customer_name

  • Meaning: Name of the customer.

  • Role: Descriptive field.

  • Typical Contents: A string (e.g., 'DOLLAR GENERAL').

warehouse_id

  • Meaning: Identifier for the warehouse responsible for fulfilling the order.

  • Role: Foreign key.

  • Typical Contents: A string code (e.g., '028').

warehouse_name

  • Meaning: Name of the warehouse.

  • Role: Descriptive field.

  • Typical Contents: A string (e.g., 'USCS - DENTON, TX').

transportation_method

  • Meaning: Method of transportation for delivering the order.

  • Role: Descriptive field.

  • Typical Contents: A string code (e.g., '001').

requested_delivery_date

  • Meaning: Date the customer requested for delivery.

  • Role: Descriptive field.

  • Typical Contents: A timestamp (e.g., None).

order_date

  • Meaning: Date when the order was placed.

  • Role: Descriptive field.

  • Typical Contents: A timestamp (e.g., datetime.datetime(2024, 1, 29, 0, 0, tzinfo=datetime.timezone.utc)).

sales_person_id

  • Meaning: Identifier for the salesperson handling the order.

  • Role: Foreign key.

  • Typical Contents: A string (e.g., 'ROBERTDOCK').

sales_person_name

  • Meaning: Name of the salesperson.

  • Role: Descriptive field.

  • Typical Contents: A string (e.g., 'ROBERT DOCKINS').

ship_to_party_id

  • Meaning: Identifier for the party to whom the order is shipped.

  • Role: Foreign key.

  • Typical Contents: A string (e.g., '35623000 009').

ship_to_party_name

  • Meaning: Name of the party to whom the order is shipped.

  • Role: Descriptive field.

  • Typical Contents: A string (e.g., 'DOLLAR GENERAL DC 98061/96460').

ship_to_party_city

  • Meaning: City of the shipping address.

  • Role: Descriptive field.

  • Typical Contents: A string (e.g., 'SAN ANTONIO').

ship_to_party_state

  • Meaning: State of the shipping address.

  • Role: Descriptive field.

  • Typical Contents: May be NULL.

ship_to_party_country

  • Meaning: Country of the shipping address.

  • Role: Descriptive field.

  • Typical Contents: A string (e.g., 'US').

ship_to_party_zip

  • Meaning: ZIP code of the shipping address.

  • Role: Descriptive field.

  • Typical Contents: A string (e.g., '78218').

status

  • Meaning: Current status of the sales order.

  • Role: Descriptive field.

  • Typical Contents: A string (e.g., 'Allocated').

created_by

  • Meaning: Identifier of the user who created the entry.

  • Role: Technical field.

  • Typical Contents: An integer (e.g., 1).

created_on

  • Meaning: Timestamp when the entry was created.

  • Role: Technical field.

  • Typical Contents: A timestamp (e.g., datetime.datetime(2024, 3, 6, 11, 48, 43, 237208, tzinfo=datetime.timezone.utc)).

last_modified_on

  • Meaning: Timestamp of the last modification.

  • Role: Technical field.

  • Typical Contents: A timestamp (e.g., datetime.datetime(2024, 9, 4, 8, 42, 32, 912247, tzinfo=datetime.timezone.utc)).

is_deleted

  • Meaning: Flag indicating if the order is marked as deleted.

  • Role: Technical field.

  • Typical Contents: A boolean (e.g., False).

deleted_on

  • Meaning: Timestamp when the order was marked as deleted.

  • Role: Technical field.

  • Typical Contents: Default date if not deleted (e.g., datetime.datetime(2, 1, 1, 11, 0, tzinfo=datetime.timezone.utc)).

preview_path

  • Meaning: Path to a preview document for the sales order.

  • Role: Descriptive field.

  • Typical Contents: A string representing a file path (e.g., 'previews/sales_order/23f3d697-7411-4c95-981d-faf089d266be/0010174175/0010174175_preview.pdf').

last_modified_by

  • Meaning: Identifier of the user who last modified the entry.

  • Role: Technical field.

  • Typical Contents: May be NULL.

deleted_by

  • Meaning: Identifier of the user who marked the entry as deleted.

  • Role: Technical field.

  • Typical Contents: May be NULL.

Last updated

Was this helpful?