Consolidate additional inventory
The Consolidate Additional Inventory time-triggered transaction consolidates supply and demand from the YFS_INVENTORY_SUPPLY_ADDNL and YFS_INVENTORY_DEMAND_ADDNL tables. Consolidation is performed by summing up the quantities of additional supply and demand in the YFS_INVENTORY_SUPPLY and YFS_INVENTORY_DEMAND tables.
If no matching supply or demand is found, a new supply or demand is created with the sum quantity of the changes in the YFS_INVENTORY_SUPPLY_ADDNL and YFS_INVENTORY_DEMAND_ADDNL tables. After the changes are applied, the records in the YFS_INVENTORY_SUPPLY_ADDNL and YFS_INVENTORY_DEMAND_ADDNL tables that were used in the consolidation process, are deleted.
Attributes
The following are the attributes for this time-triggered transaction:
| Attribute | Value |
|---|---|
| Base Transaction ID | CONSOLIDATE_ADDNL_INV |
| Base Document Type | General |
| Base Process Type | General |
| Abstract Transaction | No |
| APIs Called | None |
Criteria parameters
The following are the parameters for this transaction:
| Parameter | Description |
|---|---|
| Action | Required. Triggers the transaction. If left blank, it defaults to Get, the only valid value. |
| Number of Records To Buffer | Optional. Number of inventory item records (whose additional supplies and demands are consolidated) to retrieve and process at one time. If left blank or specified as 0 (zero), it defaults to 5000. |
| ColonyID | Required in a sharded deployment where the YFS_INVENTORY_SUPPLY_ADDNL and YFS_INVENTORY_DEMAND_ADDNL tables may exist in multiple schemas. Runs the agent for the colony. |
Statistics tracked
The following statistics are tracked for this transaction:
| Statistic Name | Description |
|---|---|
| NumInventorySupplyAddnlsProcessed | Number of additional inventory supply records processed in the consolidation. |
| NumInventoryDemandAddnlsProcessed | Number of additional inventory demand records processed in the consolidation. |
| NumInventoryDemandDtlsProcessed | Number of inventory demand details records processed in the consolidation. |
Pending job count
For this transaction the pending job count is the number of distinct inventory items in the YFS_INVENTORY_SUPPLY_ADDNL and YFS_INVENTORY_DEMAND_ADDNL tables, multiplied by two.
Events raised
None.