Procurement Unit Options

Determines if cost or unit adjustments will affect backposted deals processing, where any matched shipment after unmatched shipment will be used to calculate the correct on hand and adjust quantity for WAC calculation.

The Calculate Negative Income for Deals indicator determines if negative income will be calculated in case of RTV and sales return transactions during deal period. Default value if NULL is N.

When copying a PO from an existing PO, this indicator determines if the exchange rate will be copied on the new PO. When Y, the exchange rate will be copied from existing POs. If N, then the latest exchange rate is used for POs.

Indicates which cost bucket is used when calculating the return on investment for investment buy opportunities and also for deals. Valid values are N for net cost, NN for net net cost and DNN for dead net net cost.

This indicator decides at what level the credit/debit memos will be posted to ReIM, valid values can be L (Location level), S (Set of Books level), T (Transfer entity level), D (Deal level). Default value if NULL is D.

The Deal Age Priority parameter drives if older or newer deals have a higher priority when more than one deal component applies to the same item/location. Valid values are 'O' for older deals or 'N' for newer deals.

This parameter determines the earliest date that a deal created today can become active in RMS, which is calculated by taking the current date plus the value in this parameter.

The Deal Type Priority parameter controls if annual deals or promotional deals have a higher priority when more than one deal component applies to the same item/location. Valid values are 'A' for annual deals or 'P' for promotional deals.

Indicates whether multiple department orders will be allowed in the system. If this parameter is set to Y, then only one department is allowed on an order when created via RMS screens or via replenishment. If the value is N, then one or more departments are allowed on orders.

This parameter indicates whether RMS will allow costs sent through EDI855 for vendor generated orders to be overridden in RMS. If this field is set to Y, then the unit cost on the PO can be updated by applying deals the unit cost of the item. If this field is set to N, then the cost sent by the supplier will be used.

Indicates the number of days pre-issued order numbers remain valid in RMS before being deleted.

The frequency that PO (and invoices if applicable) are generated for consignment goods. Valid values include are P - Multiple, W - Weekly, M - Monthly or D - Daily. If it is set to P, then only one PO/Invoice will be generated for each unique level (as defined by the gen_consignment_invc_item_sup_loc_ind ) per run of the sales upload program. If W, then only one PO/Invoice will be generated for each unique level per week. If M, then only one PO/Invoice will be generated for each unique level per month. If D, then only one PO/Invoice will be generated for each unique level per day.

Identifies the level at which consignment POs and its consignment invoices are generated. Valid values include: S - Supplier/Department, L -Supplier/Department/Loc, I - Supplier/Location/Item.

The number of days after which the latest ship date should default from the earliest ship date on POs.

This parameter drives closure of shipped but unreceived orders once the latest ship date crosses the delay period through Order Auto Close batch process.

Determines whether the order approval upper limit amount by user role is based on total cost or total retail of the order. Valid values for this field are: C - Cost R - Retail. Limits by user role are set on the RTK_ROLE_PRIVS table.

Indicates if partially received orders should be auto closed through Order Auto Close batch.

This parameter drives closure of partially received orders once the not after date crosses the delay period and ORD_AUTO_CLOSE_PART_RCVD_IND=Y through the Order Auto Close batch process.

The number of days prior to the planned ready date for which the system automatically generates the next order specified on the production plan for type B contracts.

This indicator is used if the order exchange rate can be overwritten. When set to Y, a user can update the exchange rate used for order/location level expense to the exchange rate on the order, which would result in expenses and assessments being recalculated . Default value if NULL is N.

This determines whether client intends to use the Open-to-Buy functionality within RMS. This is also used to control whether to re-calculate OTB during reclassification process.

Drives the type of Receiver cost adjustment. Valid values are S(Standard) and F(FIFO). The standard adjustment will recalculate WAC using all units on the receivers. The FIFO adjustment will layer the receipts for the PO and create adjust WAC for only those units in stock whose receivers have not been matched.

Specifies whether item reclassification can take place if the item exists on an approved order. When this indicator is Y reclass is done as follows: * when department level PO is turned on and PO is in worksheet/submitted - reclass will be allowed * when department level PO is turned on and PO is in approved - reclass will not be allowed if multiple items on PO * when department level PO is turned off and PO is approved and partially received - reclass will not be allowed * when department level PO is turned off and PO is approved - reclass will be allowed Default value if NULL is Y.

The percentage by which the supplier lead time and warehouse lead time should be incremented to come up with the number of days prior to the not before date that an order should show up on a report listing approved orders requiring redistribution.

Soft contracting is a option to allow fashion retailer to commit to a above transaction level item (e.g. style) without specifying the diffs that bring the item to transaction level. When set to N, all items on contracts must be indicated at the transaction level before the contract can be used. When set to Y, above transaction level items can be in included in contracts.

This wil determine if WAC will be recalculated when for adjustments on purchase order during receiving. Default value if NULL is N.

Stores the Oracle username of the one who inserted the first record. This field is required by the database.

The date and time of when the record was created in the table. This value should only be populated on insert - it should never be updated.

The Oracle username of the one who most recently updated this record.

The date time stamp of the most recent update by the user.

This field indicates if Inventory Optimization (OI) can be used to optimize the MIN/MAX replenishment of any item/location. Valid values are Y and N. The item-location level optimize indicator can only be set to Y when this system level flag is set to Y.

This parameter is used to indicate if the Purchase Order number should default into the ASN field when the shipment is created upon receipt, so in cases where no vendor ASNs are communicated.

This parameter will indicate which type of scaling will be performed on a purchase order. In phase one of the release there are two possible options 'Internal' and 'External'. Internal means that the standard scaling logic available in MFCS will be used when truck scaling is performed in the PO Order Review Workflow. External means a REST call will be made to Inventory Management to perform scaling in the PO Order Review Workflow.

Contains the desired behavior when defaulting expenses to a purchase order when there is no exact match found in item expenses or partner expense profiles using the order’s ports or the primary ports. This option will specify if no exact match is found if the system should always default the item expenses marked as the Base Expense, never default the item expenses marked as Base Expense, or only default the item expenses marked as Base Expense when the discharge port on the record marked as the Base Expenses exists within the country of import on the purchase order. The code type used with this option is BEDO. Valid values are Always (A), When Base Discharge Port is in Import Country (DP) or Never (N). A change to this value will only impact processing from that point forward.

This option will control whether the deals should be applied automatically to Worksheet (pre-approved) Purchase Orders generated by Merchandising Replenishment or generated by the Vendor (VMI). When set to Yes, deals will automatically be applied during creation of Purchase Orders belonging to the above stated types. If set to No, then automatic deal application will be restricted only to approved orders.

This defines the maximum number of days in the past a deal can be made retroactive. The active date on a deal cannot be set or updated to a value that is more than the Retroactive Deal Period days in the past. The deal active date must be no earlier than the current date minus the Retroactive Deal Period days. The value should be a positive integer between 0 and 365 inclusively.

Indicates whether or not the system will allow Order Line level Cancellations of open shipped quantity. Valid values are Yes (Y) or No (N), with a default value of No (N). When set to Yes (Y), user is allowed Order Line level Cancellations keeping shipment Open. This will cancel the unreceived quantity - both shipped and unshipped. When this value is No (N), system cancels only the unshipped quantity.