Entity Definition

Logical Name : ItemSellingPrices
Physical Name : RU_ITM_SL_PRC

The schdeule of base (or regular) retail prices applied to product and service items sold by a retailer.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ItemSellingPricesID (PK) A unique system assigned identifier for the ItemSellingPrices. ID_ITM_SL_PRC Identity integer
PermanentSaleUnitRetailPriceAmount The sale unit monetary value of the item which is the original retail minus permanent markdowns taken against this item. RP_PR_SLS MoneyShortRetail decimal(7,2)
PermanentSaleUnitRetailPriceOriginalMarkdownFlag This flag indicates whether the permanent sale unit retail price amount is the original retail value or the value after one or more permanent markdowns. FL_MKD_ORGL_PRC_PR Flag integer
PermanentRetailPricePermanentMarkdownCount The number of permanent markdowns taken against this item. QU_MKD_PR_PRC_PR QuantityTransactionCount decimal(7,0)
PermanentRetailPriceEffectiveDate The date when the permanent retail price becomes effective. This will impact the stock ledger valuation (retail method). DC_PRC_EF_PRN_RT DateCalendar date
CurrentSaleUnitRetailPriceAmount The current retail price per sale unit of the item. This monetary amount is used as the basis for deriving retail price at the point of sale. RP_SLS_CRT MoneyShortRetail decimal(7,2)
CurrentSaleUnitRetailPriceTypeCode Defines the type of retail price represented in the item-current-sale-unit-retail-price-amount. Examples include marked down merchandise (permanent markdown price), promotional markdown (temporarily marked down and owned at low. TY_PRC_RT Code2 char(2)
CurrentSaleUnitRetailPricePointAllowedFlag This flag determines whether this ITEM may or may not have an associted price point. FL_PRC_RT_PNT_ALW Flag integer
CurrentSaleUnitRetailPriceEffectiveDate The date on which the item-current-sale-retail-price-amount becomes effective and is used as the basis for deriving the retail price used at the point of sale. DC_PRC_SLS_EF_CRT EffectiveDate date
CurrentSaleUnitRetailPriceExpirationDate The date the item-current-sale-unit-retail-price-amount expires and is no longer valid as the basis for deriving the point of sale price. DC_PRC_SLS_EP_CRT ExpirationDate date
ManufacturerSaleUnitRecommendedRetailPriceAmount The suggested sale unit retail price provided by the item's manufacturer. RP_PRC_MF_RCM_RT MoneyShortRetail decimal(7,2)
ManufacturerSaleUnitRecommendedRetailPriceEffectiveDate The date the manufacturer's suggested retail price becomes effective. DC_PRC_MF_RCM_RT EffectiveDate date
CompareAtSaleUnitRetailPriceAmount Provides the monetary saving that can be gained by the purchase of this ITEM at this time from this RETAIL STORE. Used as a promotional tool, this saving (normally between the normal selling retail price and the price shown at the point of sale) is usually printed on the shelf label and the customer receipt to reinforce the marketing strategy of this retailer. RP_PRC_CMPR_AT_SLS MoneyShortRetail decimal(7,2)
QuantityPricingFlag Denotes whether the item is priced using Quantity Package Price (Eg: 3 for $0.89) FL_QTY_PRC Flag integer
CurrentPackagePriceQuantity The Quantity part of the current package quantity price (Eg: 3 for $1.00) QU_PCKG_PRC_CRT QuantityShortCount decimal(3,0)
CurrentPackagePrice The Price part of the current package quantity price (Eg: 3 for $1.00) RP_PCKG_PRC_CRT MoneyShortRetail decimal(7,2)
PermanentPackagePriceQuantity The Quantity part of the permanent package quantity price (Eg: 3 for $1.00) QU_PCKG_PRC_PRN QuantityShortCount decimal(3,0)
PermanentPackagePrice The Price part of the permanent package quantity price (Eg: 3 for $1.00) RP_PCKG_PRC_PRN MoneyShortRetail decimal(7,2)
PermanentSaleUnitReturnPrice The ordinary or regular price to be refunded when the item is returned by a customer. RP_RTN_UN_PRN_SLS MoneyShortRetail decimal(7,2)
CurrentSaleUnitReturnPrice The crrent price to be refunded when the item is returned by a customer. RP_RTN_UN_CRT_SLS MoneyShortRetail decimal(7,2)
IncludesSalesTaxFlag Indicates if the prices include all applicable sales taxes or not. FL_TX_INC Flag integer
PermanentSalesTaxAmount The total of all applicable taxes on the PermanentSalesPrice Note: This value only has meaning when ItemSellingPrices is related to RetailStoreGroupItem. MO_AMT_TX_PRN MoneyShortRetail decimal(7,2)
CurrentSalesTaxAmount The total of all applicable taxes on the CurrentSalesPrice Note: This value only has meaning when ItemSellingPrices is related to RetailStoreGroupItem. MO_AMT_TX_CRT MoneyShortRetail decimal(7,2)
MinimumAdvertisedRetailUnitPrice A contractually defined retail unit prices that establishes a minimum value that may be ADVERTISED for an item. The retailer may sell the item for any retail price it deems appoprirate - this value establishes a floor value which for ADVERTISING and promotiong an item. RP_MNM_ADVRTSD MoneyShortRetail decimal(7,2)
MinimumAdvertisedRetailUnitPriceEffectiveDate Data upon which the minimum advertised retail unit price is in force. DC_EF_RP_MNM_ADVRTSD EffectiveDate date


Parent Entity Verb Phrase Child Entity
ItemSellingPrices is assigned to BusinessUnitGroupPOSDepartment
ItemSellingPrices is assigned to Item
ItemSellingPrices is assigned to BusinessUnitGroupItem
ItemSellingPrices is assigned to POSIdentity

Logical Views containing ItemSellingPrices

Logical View
Logical 01000 - Item Description - Macro View
Logical 01004 - Item Description - Branding
Logical 01020 - Item Description - Enterprise View
Logical 01100 - Item Selling Rules - Macro View
Logical 01300 - Item Price Maintenance View
Logical 01400 - Item Rewards Derivation - Transaction Level
Logical 06700 - Event Scheduler View
Logical 10200 - Enterprise - Merchandise View
Logical 10300 - Enterprise - POS Department View