1
Download Oracle Release Management Technical Reference Manual
Transcript
RLM_SHIP_DELIVERY_CODES This table stores the optional Shipment/Delivery Pattern Rules which can then be associated with the customer/item/destination. They are used in the Demand Stream Processor for splitting or consolidating daily or weekly customer requirements from planning and shipping schedules into discrete shipment date/quantity groups which consistently and accurately reflect the customer?s expected shipment or delivery patterns. The Rule is in context of the customer–given date qualifier, i.e. delivery or shipment. Column Descriptions Name SHIP_DELIVERY_RULE_NAME Null? Type NOT NULL VARCHAR2(30) DESCRIPTION MONDAY_PERCENT NULL VARCHAR2(240) NULL NUMBER TUESDAY_PERCENT NULL NUMBER WEDNESDAY_PERCENT NULL NUMBER THURSDAY_PERCENT NULL NUMBER FRIDAY_PERCENT NULL NUMBER SATURDAY_PERCENT NULL NUMBER SUNDAY_PERCENT NULL NUMBER USER_MAINTAINABLE_FLAG NULL VARCHAR2(1) LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY ATTRIBUTE_CATEGORY NOT NOT NOT NOT NULL NULL NULL NULL NULL DATE NUMBER DATE NUMBER VARCHAR2(30) ATTRIBUTE1 NULL VARCHAR2(150) ATTRIBUTE2 NULL VARCHAR2(150) ATTRIBUTE3 NULL VARCHAR2(150) Description Unique shipment/delivery rule name Rule description If splitting weekly buckets, the percent of customer requirement quantity which is to be allocated to Monday If splitting weekly buckets, the percent of customer requirement quantity which is to be allocated to Tuesday If splitting weekly buckets, the percent of customer requirement quantity which is to be allocated to Wednesday If splitting weekly buckets, the percent of customer requirement quantity which is to be allocated to Thursday If splitting weekly buckets, the percent of customer requirement quantity which is to be allocated to Friday If splitting weekly buckets, the percent of customer requirement quantity which is to be allocated to Saturday If splitting weekly buckets, the percent of customer requirement quantity which is to be allocated to Sunday Y or N flag that indicates whether this seeded row can be updated by the users Standard Who column Standard Who column Standard Who column Standard Who column Descriptive Flexfield context column Descriptive Flexfield segment column Descriptive Flexfield segment column Descriptive Flexfield segment column Oracle Proprietary, Confidential Information––Use Restricted by Contract Detailed Design 3 – 63
