Transactional Data

Transactional Data

Transactional data is data that changes daily and may affect your supply or demand. Filter the data with the dropdown to show only Sales History, Sales Orders, Purchase Orders, Production Orders, or Transaction Orders.


View Inventory, Replenishment Levels, Sales History, Sales Orders, Purchase Orders, Production Orders, and Transfer Orders transactional data from the dropdown. 




Inventory

Inventory Transactional Data:
  1. ID
  2. Item Code
  3. Location Code
  4. Quantity
  5. UOM
  6. Value
  7. Currency
  8. Age
  9. Batch Number
  10. Adjustment Date



Replenishment Levels

Replenishment Levels Transactional Data is imported into an existing replenishment level map in Orbit. 

Replenishment Level Transaction Data:
  1. ID
  2. Location Code
  3. Start Date
  4. Expiration Date
  5. Safety Stock
  6. Replenishment Value
  7. Minimum Stock
  8. Maximum Stock




Sales History

Sales History Transactional Data:
  1. ID
  2. Item Code
  3. Customer Code
  4. Location Code
  5. Date
  6. Quantity
  7. UOM
  8. Price of UOM
  9. Revenue
  10. Currency





Sales Orders 

Sales Orders Transactional Data:
  1. ID
  2. Item Code
  3. Customer Code
  4. Location Code
  5. Date 
  6. Quantity
  7. UOM
  8. Price Per UOM
  9. Revenue
  10. Currency
  11. Expiry Date
  12. Erp Code
  13. Priority
  14. Minimum Age Remaining Days




Purchase Orders 

Purchase Orders Transactional Data:
  1. ID
  2. Item Code
  3. Item Description
  4. Location
  5. Location Description
  6. Vender Code
  7. Vendor Description
  8. Delivery Date
  9. Quantity
  10. UOM
  11. Erp Code
  12. Contract Status
  13. Purchase Type



Production Orders 

Production Orders Transactional Data:
  1. ID
  2. Item Code
  3. Item Description
  4. Location Code
  5. Location Description
  6. Start Date
  7. End Date
  8. Quantity
  9. UOM
  10. Erp Code
  11. Production Type



Transfer Orders 

Transfer Orders Transactional Data:
  1. ID
  2. Source Item Code
  3. Source Location Code
  4. Destination Item Code
  5. Destination Location Code
  6. Ship Date
  7. Delivery Date 
  8. Quantity
  9. Vehicle Type
  10. UOM
  11. Erp Code
  12. Transfer Type





Duplicate Transactional Data Records

When duplicate transactional data records are present in the data input file, the duplicate records are all pulled into the application, with the values combined.  












    • Related Articles

    • Master Data

      Master data are the key dimensions of the supply chain that we are to plan for. Within this tab we can see the following columns: ID, Code, Description, UOM, Unit Cost, Unit Price, Currency, Item Group Code, Item Group Description, Item Family Code, ...

    • Data Versions

      On the Orbit Data Versions page, you can create data versions from a source orbit scenario or from an existing data version. You can also archive a data version (and check the View Archived checkbox to only view archived data versions), and Delete a ...

    • NetSuite Data Source Configuration

      When connecting your NetSuite implementation to the Arkieva Small Business application there are several things that need to be done before data can flow between the two services. Before you begin, make sure you have administrative access to your ...

    • How Data Flows Inside Arkieva

      This flow chart shows how Arkieva ingests ERP data and how it's used throughout the application.

    • How Data Flows in Arkieva's Planning Environment

      Data flow diagram