RPM Svc Clearance

The process_id is the ID of the current induction run.

The chunk_id breaks up the data under a process_id for concurrent processing.

The row ID. Oracle Retail target column ROW_SEQ on RPM_SVC_CLEARANCE.

The action for the row: NEW, MOD, DEL.

The status of the row: 'N'ew, 'E'rror, 'W'arnding, 'P'rocessed, 'I' - Processing.

The clearance group the clearance belongs to.

The clearance group display id.

The clearance group description.

The clearance ID of the row. Oracle Retail target column CLEARANCE_ID on RPM_SVC_CLEARANCE.

The clearance display of the row.

The state of the clearance. Oracle Retail target column STATE on RPM_SVC_CLEARANCE.

The markdown number of the clearance.

The reason code of the clearance.

The item of the clearance. Oracle Retail target column ITEM on RPM_SVC_CLEARANCE.

The diff id of the clearance. Oracle Retail target column DIFF_ID on RPM_SVC_CLEARANCE.

The location type of the clearance.

The location of the clearance.

The effective date of the clearance.

The new effective date for the clearance.

The change type of the clearance.

The change amount of the clearance.

The rounding rule id for the clearance.

The grouping column for new clearances.

The input location mapped to RPM's internal value.

The currency of the internal location of the clearance.

The input rounding rule mapped to RPM's internal value.

Helper for the state of the clearance.

Helper for the change type of the clearance.

Helper for the change amount of the clearance.

Helper for the change percent of the clearance.

Helper for the change currency of the clearance.

Helper for the change selling UOM of the clearance.

Helper for the effective date of the clearance.

Helper for the rounding rule of the clearance.

Helper for conflict checking. Oracle Retail target column CC_REQ on RPM_SVC_CLEARANCE.

Helper for ranging validation.

Helper for conflict checking. Oracle Retail target column PRICE_EVENT_TYPE on RPM_SVC_CLEARANCE.

The error message for the row.

The primary supplier for the item/location.

The purchase type. Valid value comes from code_detail table with code_type PRTP; those are 0 - Owned, 1 - Consignment and 2 - Concession.

The creator of the clearance. Valid value comes from code_detail table with code_type PRCT; those are S - Supplier and R - Retailer.

Helper for ownership validation.

Helper to indicate if the explosion is needed due to ownership variation.

The file that processed the clearance record

The source that last created/updated the clearance record