Svc Fulfilordref

Unique identifier for a set of rows that are staged for a customer order fulfillment cancellation request. This is generated by a sequence.

This is used to divide data associated with the same process_id into multiple chunks to facilitate parallel processing. For the same process_id, chunk_id starts with 1 and increment by 1 for each new chunk.

Indicates the processing status of a customer order fulfillment cancellation request. Valid values are: 'N' (new), 'V' (validated), 'E' (error), 'C' (completed).

Indicates the action type of a customer order fulfillment request. Currently only 'cancel' request is supported.

Indicates the transaction type of a customer order fulfillment cancellation request. Valid values are: 'T' (transfer), 'P' (PO), 'I' (reverse inventory). The value is derived from source_loc_type and fulfill_loc_type of the record.

Unique identifier for a customer order fulfillment cancellation request.

Holds the master customer order number from OMS.

Unique number from OMS related to the fulfillment details. One or more fulfillment orders could relate back to a single customer order in OMS.

Indicates the source location type. Valid values are: 'SU' for supplier, 'ST' for store, 'WH' for warehouse. This would only be populated for cancellation of vendor, warehouse or multi-site fulfillment orders.

Indicates the supplier, store or warehouse number associated with sourcing the customer order. Only populated for cancellation of vendor, warehouse or multi-site fulfillment orders.

Indicates the fulfillment location type. Valid values are: 'S' (for physical store) or 'V' (for virtual store).

Indicates the store or warehouse number associated with fulfilling the customer order. For this release, this should always be populated with a virtual or physical store number.

Holds the validation errors of the record. If multiple validation errors are found on a record, the error messages are concatenated and separated by .;..

This field contains the timestamp when the record is created.

This field contains the user that created the record.

This field contains the timestamp when the record is last updated.

This field contains the user that user that last updated the record.