Data interface requirements > Locations

Locations

File name location.csv
Importance Required
Description Physical stocking locations at warehouse / branch level (not bin locations)
Criteria
  • All locations that hold stock (warehouses, branches etc.)
  • May be limited by scope of the engagement
 

Columns

Pos Name Type Importance Description
1 Location Code Char Required Warehouse / branch code
2 Description Char Required Warehouse / branch name
3 Active Bit Required Indicates whether the location is active:
  • 1 = Active
  • 0 = Inactive
Determines visibility of the location in NETSTOCK and whether the location is processed
4 Group Char If Applicable May be used to group locations for reporting
5 Type Char If Applicable Type of location:
  • ST = Store/branch
  • DC = Warehouse
  • CW = Central Warehouse