Tables and Key Fields for Route Integration

You must use or configure the tables and the key fields to support the integration.

To facilitate the data flow between multiple systems, this integration uses the following staging tables to store route inventory information:

Route Inventory
Route Inventory Transactions

Route Inventory

Use the following table lists the key fields in the Route Inventory (__ORACO__RouteInventory_c) staging table, which contains the information about the current inventory.

Key Fields	API Name	Description
Route ID Product	ID `__ORACO__Product_c`	Indicates the user keys that uniquely identify each inventory record.
Total Quantity	`__ORACO__TotalQuantity_c`	Indicates the quantity of inventory in a route.
Sellable Quantity	`__ORACO__SellableQuantity_c`	Indicates the sellable subset of the total quantity of inventory in a vehicle.
Unsellable Quantity	`__ORACO__UnsellableQuantity_c`	Indicates the unsellable subset of the total quantity of inventory in a vehicle.
Last Processed Transaction Time Stamp	`__ORACO__LastProcessedTimestamp_c`	Indicates the last creation time stamp from the Route Inventory Transaction table. This time stamp is used for calculating the inventory position for the route. See, Configuring Integration Flows on how this time stamp is used for refreshing inventory position.

Route Inventory Transactions

Use the following table and the key fields in the Route Inventory Transactions (__ORACO__RouteInvTransDSD_c) staging table, which contains the information about the inventory transactions.

Key Fields	API Name	Description
Route ID	Id	A unique and incremental database sequence ID generated by application when a record is created.
Creating Time Stamp	`__ORACO__CreatedOn_c`	The date when the inventory transaction record was created.
Route ID Product	`__ORACO__TransferRouteID_c` `__ORACO__Product_c`	The keys that uniquely identify each inventory transaction. These correspond to a Route ID and the associated product.
Transaction Date Transaction Type Transaction Quantity	`__ORACO__TransactionDate_c` `__ORACO__TransactionType_c` `__ORACO__TransactionQuantity_c`	These fields describe how the route inventory has changed.