Definition
Table Describing the details of shipper, customer and order.
Temporal and Spatial Information
Data source details
Datasets
This distribution is not linked to any datasets
| Path name | Data Element | Definition | Data Type | Format |
|---|---|---|---|---|
| Order_value | Order: Freight, Australian Currency N(4) | - | - | |
| order_Id | Order: Unique Identifier, Identifier X(10) | A distinct code or number assigned to a order to distinguish it from other orders is recorded as Identifier X(10). | CHARACTERSTRING | X(10) |
| Customer_id | Customer: Unique Identifier, Identifier X(10) | A distinct code or number assigned to a customer to distinguish it from other customers is recorded as Identifier X(10). | CHARACTERSTRING | X(10) |
| Employee_id | Employee: Unique Identifier, Identifier X(10) | A distinct code or number assigned to a employee to distinguish it from other employees is recorded as Identifier X(10). | CHARACTERSTRING | X(10) |
| order_date | Order: Order Date, Date DDMMYYY | The date an order was received is recorded as DDMMYYYY | DATE | DDMMYYYY |
| Required_Date | Order: Required Date, Date DDMMYYYY | The date an order was received is recorded as DDMMYYYY | DATE | DDMMYYYY |
| Shipped_date | Order: Shipper Date, Date DDMMYYYY | The date an order was received is recorded as DDMMYYYY | DATE | DDMMYYYY |
| Ship_via | Order: Shipped Via, String X(50) | A written or verbal statement that provides detailed information about a specific group or category of related products within a larger inventory or catalog is recorded as String X(50). | String | X(50) |
| freight | Order: Freight, String X(50) | A written or verbal statement that provides detailed information about a specific group or category of related products within a larger inventory or catalog is recorded as String X(50). | String | X(50) |
| Ship_name | Order: Ship Name, String X(50) |
A detailed information about a name of Shipment company is recorded as String X(50). |
String | X(50) |
| Address | Order: Ship Address, String X(100) |
A detailed information about a shipping address of related products within a larger inventory is recorded as String X(100). |
String | X(100) |
| City | Order: Ship City, String X(50) | A written or verbal statement that provides detailed information about a specific group or category of related products within a larger inventory or catalog is recorded as String X(50). | String | X(50) |
| Region | Order: Ship Region, String X(50) | A written or verbal statement that provides detailed information about a specific group or category of related products within a larger inventory or catalog is recorded as String X(50). | String | X(50) |
| Postal_code | Order: Ship Postal Code, Number X(5) | The Postal Code of the shipping location the shipment will be sent too. | Number | X(5) |
| Country | Order: Ship Country, String X(50) | A written or verbal statement that provides detailed information about a specific group or category of related products within a larger inventory or catalog is recorded as String X(50). | String | X(50) |