Svc Stkupld Status

Unique id that identifies a stock upload process. It can either be manually provided or automatically generated.

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.

Contains a value that references the source for the data in the parameter tables. In batch execution, this is the filename of the stock upload file.

Status of the stock upload execution for a particular process ID and chunk ID. Valid values are: N - New, R = Reprocess, P = Processed, J = Reject, E = Error.

Contains the error message for this record. Error messages are stored as the output the SQL_LIB.CREATE_MSG function. Multiple error messages are possible for a single record if the error is non-fatal. Multiple error messages are concatenated together.