These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- Fashion/Apparel SCM
- Data model
The tables behind Fashion/Apparel SCM
Fashion/Apparel SCM ships with 13 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 13
- Features
- 7
- Change it
- Add fields and tables in Proto
How the model is organised
Operating context:
Organizations, storage locations, team members and Users establish the entity, site and person.
Apparel identity:
Stock items identifies a size-color SKU and base unit; stock lots holds release state and expiry for lot-tracked items.
Work and decisions:
Stock requests is the parent of seasonal stock plans, review decisions, record attachments and operation receipts.
Stock effect:
Stock reservations records claims; stock movements records posted signed changes and optional reversals.
Every table, by feature
- Stock requests7
- Seasonal plans5
- Items and lots6
- Reservations6
- Movements6
- Review and evidence6
- Organizations and locations7
- Stock requests
Guarded stock operations requested by a coordinator for an exact SKU and location.
Linked to Organizations, Team members, Storage locations, Stock items - Review decisions
Independent reviewer decisions recorded against a frozen revision.
Linked to Stock requests, Team members - Operation receipts
Stable idempotent receipts for every guarded operation attempt.
Linked to Stock requests - Stock movements
Posted signed movements that are the only source of on-hand quantity.
Linked to Stock requests, Stock items, Storage locations, Stock movements - Stock items
Size/color style-level SK us tracked in their base unit.
Linked to Organizations - Storage locations
Warehouses, DCs and 3PL sites holding apparel stock.
Linked to Organizations - Team members
Coordinator, reviewer and auditor memberships bound to an organization.
Linked to Organizations, Users
- Seasonal stock plans
Seasonal balancing extensions by size/color for an exact stock request parent.
Linked to Stock requests, Organizations - Stock requests
Guarded stock operations requested by a coordinator for an exact SKU and location.
Linked to Organizations, Team members, Storage locations, Stock items - Organizations
Legal entities operating stock across the apparel supply chain.
- Stock items
Size/color style-level SK us tracked in their base unit.
Linked to Organizations - Review decisions
Independent reviewer decisions recorded against a frozen revision.
Linked to Stock requests, Team members
- Stock items
Size/color style-level SK us tracked in their base unit.
Linked to Organizations - Stock lots
Lot codes with release state and expiry for lot-tracked apparel SK us.
Linked to Stock items - Stock reservations
Active, released and consumed claims against eligible free quantity.
Linked to Stock requests, Stock items, Storage locations, Stock lots - Stock movements
Posted signed movements that are the only source of on-hand quantity.
Linked to Stock requests, Stock items, Storage locations, Stock movements - Stock requests
Guarded stock operations requested by a coordinator for an exact SKU and location.
Linked to Organizations, Team members, Storage locations, Stock items - Organizations
Legal entities operating stock across the apparel supply chain.
- Stock reservations
Active, released and consumed claims against eligible free quantity.
Linked to Stock requests, Stock items, Storage locations, Stock lots - Stock requests
Guarded stock operations requested by a coordinator for an exact SKU and location.
Linked to Organizations, Team members, Storage locations, Stock items - Stock items
Size/color style-level SK us tracked in their base unit.
Linked to Organizations - Stock lots
Lot codes with release state and expiry for lot-tracked apparel SK us.
Linked to Stock items - Storage locations
Warehouses, DCs and 3PL sites holding apparel stock.
Linked to Organizations - Stock movements
Posted signed movements that are the only source of on-hand quantity.
Linked to Stock requests, Stock items, Storage locations, Stock movements
- Stock movements
Posted signed movements that are the only source of on-hand quantity.
Linked to Stock requests, Stock items, Storage locations, Stock movements - Stock requests
Guarded stock operations requested by a coordinator for an exact SKU and location.
Linked to Organizations, Team members, Storage locations, Stock items - Stock lots
Lot codes with release state and expiry for lot-tracked apparel SK us.
Linked to Stock items - Stock items
Size/color style-level SK us tracked in their base unit.
Linked to Organizations - Storage locations
Warehouses, DCs and 3PL sites holding apparel stock.
Linked to Organizations - Operation receipts
Stable idempotent receipts for every guarded operation attempt.
Linked to Stock requests
- Review decisions
Independent reviewer decisions recorded against a frozen revision.
Linked to Stock requests, Team members - Record attachments
Uploaded evidence files linked to a stock request.
Linked to Stock requests, Team members - Operation receipts
Stable idempotent receipts for every guarded operation attempt.
Linked to Stock requests - Stock requests
Guarded stock operations requested by a coordinator for an exact SKU and location.
Linked to Organizations, Team members, Storage locations, Stock items - Team members
Coordinator, reviewer and auditor memberships bound to an organization.
Linked to Organizations, Users - Stock movements
Posted signed movements that are the only source of on-hand quantity.
Linked to Stock requests, Stock items, Storage locations, Stock movements
- Organizations
Legal entities operating stock across the apparel supply chain.
- Storage locations
Warehouses, DCs and 3PL sites holding apparel stock.
Linked to Organizations - Team members
Coordinator, reviewer and auditor memberships bound to an organization.
Linked to Organizations, Users - Users
Users
Linked to Users - Stock items
Size/color style-level SK us tracked in their base unit.
Linked to Organizations - Stock requests
Guarded stock operations requested by a coordinator for an exact SKU and location.
Linked to Organizations, Team members, Storage locations, Stock items - Stock movements
Posted signed movements that are the only source of on-hand quantity.
Linked to Stock requests, Stock items, Storage locations, Stock movements
Keys and references
A request connects its organization, owner, item, location and counterparty. Its revision connects to a reviewer decision through the recorded source revision. A posted movement points back to the request and also identifies the item, location and optional lot. An operation receipt carries an operation key, expected revision and effect references. Preserve these keys in migration so an auditor can reconstruct a decision and its result.
Migration order
- Organizations and users. Establish legal entities and accounts before assigning memberships.
- Locations and items. Import site codes and SKU identities under the correct organization.
- Lots and memberships. Record expiry and release state, then attach active people to their organization.
- Requests and plans. Import parent requests before linked seasonal targets, attachments and decisions.
- Claims and effects. Load reservations and posted movements only after the referenced request, item, location and lot exist.
- Operation evidence. Reconcile operation keys, outcomes and effect references to the migrated movements.
Set up Fashion/Apparel SCM your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.