Data entities supported in AWS Supply Chain - AWS Supply Chain

Data entities supported in AWS Supply Chain

The following is an overview of the data entities supported in AWS Supply Chain.

Note

The data entities listed in this chapter are required for Data Lake ingestion. For data entities required for each AWS Supply Chain module, see Data entities and columns used in AWS Supply Chain.

Category Category type Data entity and description

Organization

Non-transactional data

company - Entity to store the name and location of your company.

Non-transactional data

geography - Entity stores geographical hierarchy of your company.

Non-transactional data

trading_partner - Contains the partners that have trading relationship with your company, such as vendors, 3PLs, channel partners, or distributors.

Non-transactional data

trading_partner_poc - Contains information that can be identified about the point of contacts at the partners such as vendors, 3PLs, channel partners, or distributors, that have trading relationship with your company.

Product

Non-transactional data

product - Contains the key product attributes, including name, description, brand, codes, category, business group, and price.

Non-transactional data

product_hierarchy - Contains the product categories and sub-categories.

Non-transactional data

product_uom - Contains the product packaging options and conversations between packages.

Non-transactional data

product_alternate - Contains information about alternative products, including type of alternative.

Non-transactional data

un_details - Contains information about hazardous products.

Network

Non-transactional data

site - Stores information for sites holding inventory such as Stores, Distribution Centres ,including ID, name, address, geographical region, and site type.

Non-transactional data

transportation_lane - Contains information about transportation lanes, including from and to sites, transportation mode, and transit time.

Vendor management

Non-transactional data

vendor_product - Contains the product information per vendor, including price, lead-time, and inbound sites.

Non-transactional data

vendor_lead_time - Contains the planned and actual lead times from the vendor.

Non-transactional data

vendor_holiday - Displays information on vendor outages due to holidays and shutdowns.

Planning

Non-transactional data

inv_policy - Contains inventory policies such as minimum and maximum safety stock policy, target inventory quantity, minimum or ma maximum order quantity and so on, for product, product-site, and other possible combinations.

Non-transactional data

segmentation - Used to store segments. Segments are used in conjunction with product, site, and effective dates for uniqueness. For example, HV1 for High Value, HLW for Halloween Products, seasonal, volatile and so on.

Non-transactional data

sourcing_rules - Defines rules at product-site level to specify the sourcing related attributes (for example, rule type, to and from site, transportation lane, minimum and maximum quantity, priority, ratio, and so on).

Non-transactional data

sourcing_schedule - Sourcing schedule determines when to source. For example, source from vendors or transfer between sites.

Non-transactional data

sourcing_schedule_details - Provides sourcing schedule details. For example, the days in a week, a product be sourced from a vendor.

Transactional data

reservation - Provides details about inventory reservation. For example, reservation ID, type, date, quantity, product ID.

Transactional data

product_bom - Displays bill of material for product with type, level, ratios, quantities, and cost attributes.

Operation

Transactional data

process_header - Track execution activities within a plant or site. For example, manufacturing, maintenance or repairs.

Transactional data

process_operation - Defines operation associated with an activity. For example, Stop machine, Oiling, and so on.

Transactional data

process_product - Define the product or material associated with an activity.

Transactional data

production_process - Defines attributes associated with the manufacturing or production process.

Inventory Management

Transactional data

inv_level - A snapshot of the product’s inventory condition in each site. For example, snapshot date, on-hand inventory, condition of the product.

Inbound

Transactional data

inbound_order - Contains information about inbound orders into your companies locations. For example, for example, purchase orders (POs), blanket POs, production orders, or stock transfer orders).

Transactional data

inbound_order_line - Stores line level information for inbound_order, including product_id, and quantity.

Transactional data

inbound_order_line_schedule - Stores schedule-line level data within an inbound_order_line and is relevant only when schedules are used.

Transactional data

shipment - Stores shipment information like origin, carrier code, ship date, product, quantity, ship from site, expected delivery date, and actual delivery date, or inbound orders (PO,TO and so on) including ship date, product, quantity, ship from site, expected delivery date, and actual delivery date.

Transactional data

shipment_stop - Contains list of shipment stops with corresponding date and time. This field is used when there are multiple stops for shipments.

Transactional data

shipment_stop_order - Contains list of orders picked and dropped per shipment stop.

Transactional data

shipment_lot - Contains the shipment details per shipment lot.

Outbound fulfillment

Transactional data

outbound_order_line - Contains orders originating from your company and shipped to locations outside of the your network. Outbound_order_line contains order date, customer location, incoterms, and so on. It also includes product, price, discount, and units.

Transactional data

outbound_shipment - Stores shipment information for outbound orders, including ship date, product, quantity, ship from site, expected delivery date, and actual delivery date.

Cost management

Transactional data

customer_cost - Displays the information about the costs incurred by you during the supply chain operations.

Plan

Transactional data

supply_plan - Displays the supply plan generated by AWS Supply Chain Supply Planning.

Forecast

Transactional data

forecast - Stores forecast over forecast horizon for product, product-site, or other combinations.

Transactional data

supplementary_time_series - Displays additional demand driver time series information such as price, promotions, and out-of-stock indicator to improve forecast quality.

Reference

Non-transactional data

reference_field - Contains mapping of any entity-field-value combination to a corresponding description, such as mapping specific inbound_order status code to status description.

Non-transactional data

calendar - Calendars can be used for many purposes by the application, such as planning, execution, and reporting.

Non-transactional data

uom_conversion - Contains conversions for unit of measure (UOM).

Insights

Transactional data

work_order_plan - Provides the supply chain process plan for a work order along with source type and duration to finish each supply chain process.

Note
  • All fields marked as type timestamp should be in ISO 8601 format.

  • The dataset that you ingest into AWS Supply Chain can only include the following special characters: ASCII 35 (number sign: #), 36 (dollar sign: $), 37 (percent sign: %), 45 (hyphen: -), 46 (period: .), 47 (slash: /), 94 (caret), 95 (underscore: _), 123 (left curly brace: { ), and 125 (right curly brace: }).