Subclass

Contains the department number of which the subclass is a member.

Contains the class number of which the subclass is a member.

Contains the number which uniquely identifies the subclass.

Contains the name of the subclass which, along with the subclass number, uniquely identifies the subclass.

This column holds the User id of the user who created the record.

This column holds the record creation date.

Contains the number that uniquely identifies the department/class/subclass combination. This column is populated by the system and not displayed to end users. This will be used for integration to downstream systems as many downstream systems are unable to accommodate the composite dept/class/subclass PK in their hierarchy and item structures.

User who last updated the record.

Date time when record was last updated.

This column to specify whether the Up Charges being defined for the item under the corresponding subclass, should be included in the pricing cost or not for company owned stores.

This specifies the Default Intercompany Transfer Price that will be used during recording of transaction data postings on intercompany transfers and allocations. Valid Values are 'W'(Weighted Average Cost) and 'S'(Supplier Cost) for subclasses under cost based departments and are defined in CODE_DETAIL with CODE_TYPE 'ICTP'. Valid value for subclasses under Retail based departments is 'R'(Retail Based).

Oracle Retail target column UPD_SELL_DATE_ON_ST_ORD_RECEIPT_IND on SUBCLASS.

Oracle Retail target column UPD_SELL_DATE_ON_WH2ST_RECEIPT_IND on SUBCLASS.

Oracle Retail target column UPD_SELL_DATE_ON_ST2ST_RECEIPT_IND on SUBCLASS.

This field would be used to capture at the subclass level the minimum number of units that would trigger an update to the selling phase start date to the receipt date in case of a warehouse to store transfer/allocation or a store to store transfer. This setting would be defaulted at the time of new item/store ranging for any item that belongs to that subclass. This value will be used only if either of the ‘Update Selling Phase Start Date upon Receipt of Warehouse to Store Transfers / Allocations’ or ‘Update Selling Phase Start Date upon Receipt of Store to Store Transfers’ is set to Yes (Y). If either or both flags are set and this parameter is left as NULL, then the minimum value would be considered as zero and the selling phase start date updated based on that.