Alloc Detail

This column contains the number that uniquely identifies the allocation within the system.

This column contains the location to which the allocation is being sent. The loc_type field determines if the location is a store or a warehouse.

This column contains the type of location in the location field. Valid values are Store and Warehouse.

This column contains the number of items that have already been transferred under this allocation.

This column contains the total number of items allocated.

This column contains the allocation quantity (system generated or manually generated) for the item/location before order scaling processing was performed.

This column contains the final quantity that the external system (RDM) plans on filling.

This column contains the initial quantity that the external system (RDM) plans on filling.

This column contains the quantity that was left to be allocated when the line item was cancelled.

This column contains the quantity of the item which has been received at the to location on the allocation.

This column contains the quantity received at another location for this allocated item. It is populated when adjustment type ( shipsku.adjust_type) is Received Elsewhere ....

This column tracks the quantity received against a cross-docked order. It is only used to distribute unallocated quantities that are received in a physical warehouse.

This column determines if the item/locations allocation quantity should not be scaled during the order scaling process. Valid values include: Y - Yes. Fix the allocation quantity to ensure that the item/location allocation quantity is not adjusted during the order scaling process. N - No. Do not fix the allocation quantity to ensure that the item/location allocation quantity will be adjusted during the order scaling process.

This column contains the date to be included in the RMS publication (Oracle Retail Service Layer) to the RIB for communication to the warehouse.

This column contains the rush flag indicator to be included in the RMS publication (Oracle Retail Service Layer) to the RIB for communication to the warehouse.

This field holds the franchise order number this allocation detail line is linked to.

Indicates if a book transfer has been created for the allocation detail. It is defaulted to 'N' and only applicable to warehouse sourced allocations. Once set to 'Y', the allocation detail cannot be modified.

This column holds the user ID of the user who created the record.

This column holds the record creation date.

Holds the user-id of the user who most recently updated this record. This field is required by the database.

Holds the date time stamp of the most recent update by the last_update_id. This field is required by the database.

This flag is only used when RMS is integrated with a warehouse management system like LogFire that expects a FulRep RIB message when the allocation is modified. It indicates if the ALLOC_DETAIL record has been updated by the SOStatus message sent from the warehouse management system or not. If set to Y, the update will not be published as a FulRep message to the RIB since the warehouse management system is already aware of the change.