V73_ET_NAME | V73_ET_DEF | V73_TBL_NM | V72_ET_NAME | V72_ET_DEF | V72_TBL_NM | V72_V73_ET_COMP | V72_V73_TBL_NM_COMP | V72_V73_ET_DEF_COMP |
BounceBackCouponDocument | A coupon document issued to a customer during a sale that may be applied to FUTURE sales transactions. | DO_BNC_BK_CPN_DCM | | | | NEW ENTITY | | |
BrandedTenderMediaPromotionRewardEligibility | A kind of RewardDerivationRuleEligibility that allows RewardDerivationRules to be linked with the use of a particular tender media brand. For example customers that purchase products using an ART branded VISA credit/debit card get an extra 2.5% discount off of the retailer's retail price. Note that this is separate from the rebates offered by credit card companies which happen independently from retailer offers (since the rebates apply to all purchases made by a customer). | RU_BRN_TND_MD_EL | | | | NEW ENTITY | | |
BrandRewardDerivationRuleEligibility | Defines an association between a BRAND and RewardDerivationRule and the conditions that govern the application of the associated rule to an item belonging to the specified BRAND at the time an instance of the item is recorded as a line item in a sale. | CO_EL_BRN_PRDV | | | | NEW ENTITY | | |
CalendarPeriodRewardDerivationRuleEligibility | A kind of RewardDerivationRuleEligibility that allows RewardDerivationRules to be targeted to particular CalendarPeriods (Eg: Season, SubSeason, Easter, Christmas, Thanksgiving etc..) | CO_EL_CLD_PRDV | | | | NEW ENTITY | | |
CarrierAccount | An explicitly identified relationship between a Carrier and a different Party. A CarrierAccount entity enable retailers to support scenarios where a shipment or return transport fee is handle by the same carrier, but charged to two separate and distinct accounts with that carrier. It is fairly common for a retailer to have more than one account with FedEx or UPS. For example, retailer paid delivery may be assigned to one acccount while customer paid delivery fees may be assigned to a different account. | LE_CRR_ACNT | | | | NEW ENTITY | | |
CarrierService | Retailer defined list of transport services offered by different carriers. The code values vary by Carrier. | CO_CRR_SV | | | | NEW ENTITY | | |
CarrierStandardParcelSize | Identifies, names and describes a pre-defined parcel package used to price shipping services. Different carriers offer different pre-specified package sizes (weight and cubic dimensions). | CO_CRR_STD_PRCL_SZ | | | | NEW ENTITY | | |
ChannelRewardDerivationRuleEligibility | Defines an association between a CHANNEL and a REWARD DERIVATION RULE and the conditions which govern the application of the associated rule to an item at the time an instance of the item is recorded as a line item in a sale. | RU_CHNL_PRC_DRVN_EL | | | | NEW ENTITY | | |
CombinationRewardDerivationRuleEligibility | A kind of RewardDerivationRule Eligibility which enables price derivation rules to be combined using AND, OR and XOR (exclusive OR) conditions. This entity references one or more RewardDerivationRuleEligibilityAssociation entity types. This approach allows the combination rule to represent complex rules that connect simple rules together using AND/OR conjunctions. This allows complex rules like: Account Level Elig: If customer membership level = (PLATINUM or GOLD) Line Item Group: AND ( if customer buys $150 or more of merchandise in Dept 219) OR Line Item: (if customer buys brand XYZ sneakers that sell for $150 or more) then get $25 off those items These eligibility rules result in a $25 discount taken from the line items that meet the eligibility requirements (a line item group RewardDerivation) that is represented as a set of related RetailPriceModifiers. | CO_EL_CMBN_PRDV | | | | NEW ENTITY | | |
CouponTenderLineItem | A sub-type of TenderLineItem that records the use of a coupon (which must be valiated against an item in the Transaction) to tender part (or all) of a the Transaction. Coupons used like tender are discounts that are paid for by an external third party, not the retailer. Accordingly, coupons treated as tender DO NOT change the retail value of the items they affect. Typically coupons used like tender are issued by manufacturers or other external parties that reimburse the retailer for the difference between the full retail price and the price paid by a customer. In this scenario the offsetting debit goes against a kind of accounts receivable account NOT POS markdowns. Because the retailer does not alter its retail price, it may treat the coupon price reduction as a form of tender/receivable. | TR_LTM_CPN_TND | CouponTenderLineItem | A sub-type of TenderLineItem that records the use of a coupon (which must be valiated against an item in the Transaction) to tender part (or all) of a the Transaction. | TR_LTM_CPN_TND | | | CHANGED ET DEF |
Currency | Specifies the national designation and quantitative value of monetary media used as tender in the processing of this TENDER LINE ITEM. This entity will be replaced by ISO4217CurrencyType. We need to review this entity's dependent relationships and repoint them to ISO4217CurrencyType before deleting it. | CO_CNY | Currency | Specifies the national designation and quantitative value of monetary media used as tender in the processing of this TENDER LINE ITEM. | CO_CNY | | | CHANGED ET DEF |
CustomerAccount | An identified, named collection of balances and cumulative totals used to summarize customer transaction-related activity over a designated period of time. CustomerAccount is subtyped into a number of different kinds of accounts such as loyalty account, installment account, etc. Each has additional attributes required to describe the reponsibilities and obligations associated with each account type. A charge account or other accounting relationship a customer has with the store or enterprise. An account exists to allow the store to record a series of transactions with the same customer and keep an ongoing record of monies owed by the customer and monies due to the customer. | LE_CTAC | CustomerAccount | A charge account or other accounting relationship a customer has with the store or enterprise. An account exists to allow the store to record a series of transactions with the same customer and keep an ongoing record of monies owed by the customer and monies due to the customer. CustomerAccount is subtyped into a number of different kinds of accounts such as loyalty account, installment account, etc. Each has additional attributes required to describe the reponsibilities and obligations associated with each account type. | LE_CTAC | | | CHANGED ET DEF |
CustomerAccountInvoice | The record of an invoice that was sent to the Customer, summarizing transactions charged to and payments made against a particular CustomerAccount. Note that in ARTS, the INVOICE is assumed to be generated by a separate process from the POS selling process. Typically it would come from a billing system which is linked to an order processing system. | DO_INVC_CTAC | CustomerAccountInvoice | The record of an invoice that was sent to the Customer, summarizing transactions charged to and payments made against a particular CustomerAccount. | DO_INVC_CTAC | | | CHANGED ET DEF |
CustomerAccountJournal | A journal that captures transaction-level changes to customer account balances. The balance values may represent monetary and/or non-monetary units of measure. For example customer purchases and returns may be reflected in monetary terms and in unit count terms. Additionally, non-monetary units like points, miles and other volume-oriented activity measures may be used to aggregate customer activity levels for the purpose of deriving discounts that reduce the out of pocket monetary price based on customer purchase volume (i.e. buy more, save more). The CustomerAccountJournal is a generalized entity type that may be used to support different kinds of customer account-level reporting. As modeled it is intended to allow a retailer to use a common entity structure to support different kinds of CustomerAccountLedgers and dependent CustomerAccountJournal entries. | JL_CT_ACNT_JR | | | | NEW ENTITY | | |
CustomerAccountLedger | A current reporting period summary of CustomerAccount transaction activity that, depending on its ReportingClassification may represent money, points, miles or any other retailer designated accounting units. | LE_CT_ACNT_LDG | | | | NEW ENTITY | | |
CustomerAccountLedgerHistory | A reporting period bounded record of CustomerAccountLedger balance amounts and cumulative totals. Used for period to period comparative reporting. The period duration is determined by each retailer. | LE_CT_ACNT_LDG_HSTRY | | | | NEW ENTITY | | |
CustomerAccountLinkage | A general purpose join entity that allows retailers to link CustomerAccount instances together. This needs to be used thoughtfully and carefully. A sample scenario for using CustomerAccountLinkage is associating a CustomerMembershipAccount with CustomerInstalllmentPaymentAccount. This enables a retailer to tie multiple installment purchases to a club member. Another scenario is where a retailer wants to tie CustomerRevolvingChargeAccount with a RebateAccount for customer valuation purposes. While CustomerAccounts are typically tied to KeyCustomers it is not a required relationship. Also, the ability to connect specific kinds of accounts for a given customer (like CustomerMembership and Rebate accounts) may be easier to implement with this kind of join entity. | LE_CT_ACNT_LNKG | | | | NEW ENTITY | | |
CustomerAccountPaymentAccount | This is a stored customer account default payment account intended to enable customers to easily pay for ordered items without having to reenger account numbers, names, addresses, etc. As modeled here it is NOT a retailer "owned" customer account which is why it is not a subtype of CustomerAccount. It is a typical credit or debit account that reflects a finanical arrangement between the customer and the financial insitution that issued the credit/debit card. This is included in the data model primarily to reflect the practice of retaining payment methods along with customer accounts (e.g. like Amazon and other ecommerc businesses). This information may physically be gathered and stored by third parties for PCI compliance purposes. This data, if persisted by the retailer, MUST BE ENCRYPTED AND SECURED IN COMPLIANCE WITH PCI SPECIFICATIONS. The attributes shown here refelct the type of information held in a secured default payment entity. | LE_ENCRYPTD_CT_PYM_ACNT | | | | NEW ENTITY | | |
CustomerAccountRewardDerivationRuleEligibility | This entity associates a customer account to a RewardDerivationRule. This entity exists to provide a linkage to special accounts for tradesmen who may purchase supplies at a discount not offered to regular customers. It may also establish associations between price derivation rules and other kinds of accounts as determined by a retailer. | CO_EL_CTAC_PRDV | | | | NEW ENTITY | | |
CustomerAccountRewardTierStatus | Indicates the current and prior assignment of a CustomerRewardProgramAccount to a CustomerRewardProgramTier. This tracks the movement of a customer account between different tiers over time so retailers can analyze customer valuation changes over time. Typically this is updated on a periodiic basis like month end, quarterly or annually to assess customer portfolio variation over time. | CO_CT_ACNT_RWD_TR_STS | | | | NEW ENTITY | | |
CustomerAccountTermsAndConditions | This entity captures and maintains the contract language associated with a customer account. As modeled here it is a generic placeholder and should be extended by the retailer to meet their specific legal and regulatory requirements. This entity is intended to store the contract provisions governing the account relationship established between a RETAILER and a KEY CUSTOMER. | RU_CT_ACNT_TRM_CN | | | | NEW ENTITY | | |
CustomerAccountType | A category of CustomerAccount used to establish different kinds of balances and accumulator summaries. ARTS explicity includes the following kinds of CustomerAccounts: CustomerRevolvingChargeAccount CustomerTradeAccount CustomerLayawayAccount CustomerInstallmentPaymentAccount CustomerBackOrderAccount CustomerRewardAccount CustomerServiceWorkOrderAccount CustomerRentalAccount CustomerDonationAccount CustomerConsignmentAccount Retailers may define other varieties of customer accounts to meet their specific requirements. | CO_CT_ACNT_TYP | | | | NEW ENTITY | | |
CustomerAccountValuationUnitType | A reference entity that identifies, names and defines the units used to explain what an account accumulation or balance is measuring. By design, this entity stretches the idea that accounts deal only with monetary units. It is used to establish a controlled vocabulary for defining various kinds of customer reward earning and redemption activities which often require different measurement units (along with relevant conversions) Examples include: MONEY POINTS MILES GALLONS VISITS others that are relevant to a retailer | CO_CT_ACNT_VLN_UN_TYP | | | | NEW ENTITY | | |
CustomerConsignmentAccount | A customer account that establishes a consignment relationship with a retailer. A consignment relationship allows a customer to transfer items to a retailer who agrees to sell them for a fee while the customer retains ownership of the items. Consignment items are NOT reflected in a retailers inventory. Consignment items do not show up in a stock ledger since they are not owned by the retailer. The retailer fee earned for selling a consginment item on behalf of a customer is typically a percentage of the final selling price of the item. When an item is sold, the amount received is divided between the retailer and the customer (consignor). This is a placeholder entity in ARTS ODM V7.3 to be more fully defined in future releases. | LE_CT_CNSGNMNT_ACNT | | | | NEW ENTITY | | |
CustomerDeliveryInstruction | Identifies an instance of a CustomerDelivery of merchandise/services to the individual or organization that placed an order through a web site, POS terminal (via store cashier), mail order, kiosk, etc. CustomerDeliveryInstruction specifies WHAT is being transported, estimated shipping and handling fees, requested CarrierService, ShipMethod and TransportBillingMethod. This entity is complemented by CustomerDeliveryPreference which defines WHEN and WHERE a delivery is to be made. Delivery tells what to deliver, how much to deliver, where to deliver it and when to deliver it. As modeled, a retail transaction and retail transaction line item group may have zero one or more CustomerDelivery instances. This supports splitting line item groups into multiple deliveries. This entity also is referenced by CustomerOrderGroup's which allow multiple deliveries to be made for a given CustomerOrderLineItemGroup. | CO_CT_DV_INSTR | CustomerDeliveryInstruction | Identifies an instance of a CustomerDelivery of merchandise/services to the individual or organization that placed an order through a web site, POS terminal (via store cashier), mail order, kiosk, etc. Delivery tells what to deliver, how much to deliver, where to deliver it and when to deliver it. As modeled, a retail transaction and retail transaction line item group may have zero one or more CustomerDelivery instances. This supports splitting line item groups into multiple deliveries. This entity also is reference by CustomerOrderGroup's which allow multiple deliveries to be made for a given CustomerOrderLineItemGroup. | CO_CT_DV_INSTR | | | CHANGED ET DEF |
CustomerDeliveryPreference | A specific location, service level, payment type and other customer preferences for where, when, and how merchandise is to be delivered. Specifies WHERE and WHEN a CustomerDeliveryInstruction related shipment is to be dropped off at a customer's location. It complements the CustomerDeliveryInstruction and because it can occur multiple times for a given delivery allows retailers to specify alternate delivery locations. Typically there will be only one occurence. | CO_CT_DV_PRFC | CustomerDeliveryPreference | A specific location, service level, payment type and other customer preferences for where, when, and how merchandise is to be delivered. | CO_CT_DV_PRFC | | | CHANGED ET DEF |
CustomerDonationAccount | A type of account used to aggregate customer donations made through the change for charity retail transaction line items. This subtype of account may or may not be used by a retailer. It provides an additional value-add for retailers that want to provide customers with an annual summary of donations receipt that can be used for income tax reporting purposes. | LE_CT_DNTN_ACNT | | | | NEW ENTITY | | |
CustomerInstallmentPaymentAccount | A type of CUSTOMER ACCOUNT established to track installment payments made against a sale transaction. This type of account is generally established to support big ticket sales. Note that installment account underwritten by banks and finance companies are NOT captured in this entity. Only installment acounts that involve the extension of credit to a customer by the retailer are captured here. | LE_ACNT_CT_INS_PYM | CustomerInstallmentPaymentAccount | A type of CUSTOMER ACCOUNT established to track installment payments made against a sale transaction. This type of account is generally established to support big ticket sales. | LE_ACNT_CT_INS_PYM | | | CHANGED ET DEF |
CustomerLedgerReportingClassification | Accouning classifications are used to identify, name and describe different kinds of periodic balances and accumulators used to summarize customer transaction activity over a period of time. This entity identifies standard named sets of accounting classifications for each kind of customer account. For example, accrued interest would typiically be a classification associated with any account type that extends credit to a customer. A deposit (which is technically unearned revenue) would typically be part of a layaway account since revenue is not earned until the items are transferred to the customer. This table enables retailers to tailor customer accounts and the types of accumulators and balances tracked for each type. | CO_CT_LDG_RP_CLSFN | | | | NEW ENTITY | | |
CustomerLoyaltyProgram | CustomerLoyaltyProgram is a subtype of CustomerMembershipProgram. It is presented as a subtype to highlight the importance of loyalty programs within the retail business community and to make it easier for ARTS ODM users to find and access loyalty program metadata. A loyalty program, as represented in the ARTS ODM has to following properties that distinguish it from other kinds of CustomerMembershipPrograms: If it is free - customers are obligated to register and provide basic contact information Rewards are earned through customer actions (i.e. visits, purchases, referrals, etc.) A RETAILER SPONSORED group plan that customers may elect to join. As used here, join means that the customer provides personal contact information through a registration process and, for paid membership type programs pays a fee. Membership programs are typically implemented as initiatives that reward customers for patronizing the retailer. Membership programs involve monitoring activity over a designated period of time and based on activity volume and cumulative value of the customer's net purchases gives the customer discounts, cash payments, premium gifts, etc. based on the net value they have contributed to the retailer's profitability. NOTE: Some retailers offer different "levels" of paid CustomerRewardProgram membership. As modeled here, to avoid confusion with CustomerRewardProgramTier we recommend that retailers set the different program levels up as different customer reward programs. | LE_CT_LYLTY_PRGM | | | | NEW ENTITY | | |
CustomerMembershipAccount | A type of CustomerAccount used to accumulate earned rewards and redeemed rewards based on a customer's net purchase history as well as other actions that correlate with longer term value to the retailer. There are an enormous variety of different kinds of CustomerRewardAccounts. ARTS models some basic types here. Retailers may extend the model by subtyping CustomerRewardAccount as required. | LE_CT_MBRSHP_ACNT | | | | NEW ENTITY | | |
CustomerMembershipEarnedRewardTier | A reference entity that identifies and names a customer membership earned reward tier or level used to stratify customers based on their level of net purchases, visits, RFM activity and other activities. This entity establishes ranges of values used to bin customers based on activity metrics captured and evaluated on a periodic basis. Activity information is aggregated for the period, compared to the range of values associated with a tier and the customer member account is assigned to the tier where its value falls into the tier high-low range. The term "earned" is used here because customers actions cause them to move between tiers. They may move up to higher-level, higher value tiers or move down to lower level lower value tiers. The CustomerMembershipEarnedRewardTier is different from the CustomerMembershipProgramLevel in that customer membership account level is a function of its activity not a choice made to join at a given level. The CustomerMembershipProgramLevel supports WarehouseClub and Coop arrangements that feature different levels of membership and are established indpendently of customer activities. | CO_CT_MBRSHP_ERN_RWD_TIER | | | | NEW ENTITY | | |
CustomerMembershipProgram | A RETAILER SPONSORED group plan that customers may elect to join. As used here, join means that the customer provides personal contact information through a registration process and, for paid membership type programs pays a fee. Membership programs are typically implemented as initiatives that reward customers for patronizing the retailer. Membership programs involve monitoring activity over a designated period of time and based on activity volume and cumulative value of the customer's net purchases gives the customer discounts, cash payments, premium gifts, etc. based on the net value they have contributed to the retailer's profitability. NOTE: Some retailers offer different "levels" of paid CustomerRewardProgram membership. As modeled here, to avoid confusion with CustomerRewardProgramTier we recommend that retailers set the different program levels up as different customer reward programs. | CO_CT_MBRSHP_PRGM | | | | NEW ENTITY | | |
CustomerMembershipProgramAccount | This is an optional entity type that allows a retailer to associate multiple CustomerMembershipPrograms with a single CustomerMembershipAccount. This allows consolidated reporting of customer activities related to different membership programs. An example of this is customer A (with a membership account A1) is enrolled in two retailer clubs. The first is the Auto club which offers special rewards tied to the purchase of fuel, oil, auto parts and tires. The second is the Food Club which offers special rewards tied to the purchase of groceries. Both club memberships can be tied to a single CustomerMembershipAccount. Grocery retailers sometimes offer customers a menu of different "clubs" that may offer combined and separate rewards. | LE_CT_MBRSHP_PRGM_ACNT | | | | NEW ENTITY | | |
CustomerMembershipProgramAccountRewardDerivationRuleEligibiliy | This entiy represents a subtype of RewardDerivationRule (discount) elgibility based on a customer's enrollment in a specific CustomerMembershipProgram (or programs) as evidenced by a FK reference to a CustomerMembershipProgramAccount entity type instance. This allows us to separate generic customer account targeted rewards from customer membership based rewards. | CO_CT_LYLT_PRGM_PRC_DRVN_RU_EL | | | | NEW ENTITY | | |
CustomerMembershipProgramLevel | A retailer defined subtype of membership represented as a level. Retailers may establish different tiers of membership and offer different levels of benefits and charge different membership fees. Note that a membership level is different from a customer earned reward tier. A membership program level is something that a customer chooses to enroll in or modify upon renewal. An earned reward tier is assigned by the retailer based on a defined set of rules for measuring different kinds of customer activity (like net purchase value, RFM, etc.) and based on a range assigining a customer to particluar tier. A customers position over time may change from one tier to another based on their activity with the retailer. | CO_CT_MBRSHP_PRGM_LV | | | | NEW ENTITY | | |
CustomerMembershipProgramProcessor | An external party that administers a CustomerMembershipProgram on behalf of the retailer for a fee. | PA_CT_MBRSHP_PRGM_PCSR | | | | NEW ENTITY | | |
CustomerMembershipProgramSponsor | A third party that wholly or in partnership with the retailer underwrites the cost associated with a CustomerRewardProgram. | PA_CT_MBRSHP_PRGM_SPNSR | | | | NEW ENTITY | | |
CustomerMembershipProgramTerms | This entity captures and maintains the legal provisions behind a CustomerMembershipProgram. It defines the legal preconditions, limitations, obligations and rights for a CustomerRewardProgram. As modeled here it is used to supplement more general CustomerAccountTermsAndConditions. | CO_CT_MBRSHP_PRGM_TRM | | | | NEW ENTITY | | |
CustomerMembershipProgramType | A reference entity that classifies CustomerMembershipPrograms for reporting and analysis. The classification of clubs is up to each retailer. Note that rebates are handled separately from membership so creating a "rebate membership type" is superflous. | CO_CT_MBRSHP_PRGM_TYP | | | | NEW ENTITY | | |
CustomerOrderAccount | A type of CustomerAccount established when a customer places an order with the retailer and chooses to persist their contact information and a method of payment. This type of account does NOT extend credit it simply provides a pre-established collection of customer data to make ordering easier. It also provides the basis for tracking multiple orders for a customer | LE_CT_ORD_ACNT | | | | NEW ENTITY | | |
CustomerOrderLineItemType | Identifies, defines and describes valid kinds of CustomerOrderLineItemTypes for the retailer's customer orders. Examples include: PRODUCT_LINE_ITEM SERVICE_LINE_ITEM FINANCE_CHARGE_LINE_ITEM These values are determined by each retailer. | CO_CT_ORD_LN _ITM_TYP | | | | NEW ENTITY | | |
CustomerOrderShipment | The record of a shipment which was made to deliver the goods purchased in a particular RetailTransaction to the customer's shipping address(es) This reflects that ACTUAL fees and expenses, service levels, delivery source and destination location, etc. for a customer order shipment. | TR_SHP_CT_ORD | | | | NEW ENTITY | | |
CustomerOrderShipmentContainer | Identifies, names and describes a physical package containing merchandise (Items) to be transported from one place to another. A shipping container is a container with strength suitable to withstand shipment, storage, and handling. Shipping containers range from large reusable steel boxes used for intermodal shipments to the ubiquitous corrugated boxes. In the context of international shipping trade, "container" or "shipping container" is virtually synonymous with "(standard) intermodal freight container" (a container designed to be moved from one mode of transport to another without unloading and reloading). Carton Tote ISO Container Pallet etc. | AS_CT_ORD_SHPMT_CNR | | | | NEW ENTITY | | |
CustomerOrderShipmentItem | A associative entity that relates a particular item sale to a the Shipment that was used to deliver the merchandise to the Customer's shipping address(es) | TR_ITM_RTL_SHP | | | | NEW ENTITY | | |
CustomerRebateAccount | A type of CustomerAccount used to accumulate purchases and other activity that determines if a customer is eligible to receive a rebate. Retailers may establish incentive programs that track customer purchases over a designated period of time (e.g annual, quarterly, etc.) and based on meeting minimum cumulative quantity and/or monetary issue a rebate. This is a common incentive used in membership based retailers that require customers to pay a fee to join. The programs may be tiered based on membership level (which varies based on periodic fees to join). Typically this kind of program stipulates that a customer must buy some mininum value of items over a designated period of time to receive a rebate that is calculated as a percentage of the total purchase value. In this scenario the CustomerRebateAccount is the "container" used to accumulate the period sum of purchases. The rebate cumulative values are reset to at the end of the designated rebate period (e.g. a year). As noted, this is commonly used in membership based retailers and the rebate period is synchronized with the membership period (usually a year). | LE_CT_RBT_ACNT | | | | NEW ENTITY | | |
CustomerRebateAccountProgram | Optional entity that allows a given ConsumerRebateAccount to be associated with more than one RebateProgram. An example of using this entity is where a manufacturer maintains a rebate program that is supplemented by a separate retailer sponsored program. | CO_CT_RBT_ACNT_PRGM | | | | NEW ENTITY | | |
CustomerRebateClaim | A paper or electronic document or other evidence of purchase along with a set of supporting data used to substantiate a customer request for payment based on the terms and conditions offered by the rebate sponsor. Rebate claims are submitted to a RebateProcessor to be validated, adjudicated and paid. Typically a rebate claim for a consumer is accompanied by the UPC from the product package, a copy of the retailer receipt and customer contact data (for check mailing purposes). Typically a retailer will not capture a customer-prepared rebate claim. That should be acceptable since a vendor-paid and processed rebate lies outside the retailer's accounting and financial reporting scope. Instant rebates that involve the payment of tender to a customer by the retailer requires a claim to connect the retailer-sponsor billback, discount (or whatever vehicle used to recognize the vendor liability and expense) to a rebate program and retail transaction. | TR_CT_RBT_CLM | CustomerRebateClaim | A subtype of RebateClaim where a customer (end-consumer) is the beneficiary of a rebate program and is slated to receive a rebate payout or reward. As modeled, ARTS assumes that the customer is a KeyCustomer and hence is known to the reailer. | %EntityName() | | CHANGED TABLE NAME | CHANGED ET DEF |
CustomerRentalAccount | A sub-type of CustomerAccount that records details of the customer as a rentor of RentalService items. It is important to keep in mind that this entity is only intended to support retailer rentals of items on a short term basis. It is not designed to handle real estate rentals or long-term equipment rentals. Both of these kinds of rentals are deemed non-retail businesses. | LE_ACNT_CT_RNT | CustomerRentalAccount | A sub-type of CustomerAccount that records details of the customer as a rentor of RentalService items. | LE_ACNT_CT_RNT | | | CHANGED ET DEF |
CustomerRevolvingChargeAccount | A type of CUSTOMER ACCOUNT that allows a customer to make purchases on credit. This type of account is a "house" charge account and usually requires the customer to use a retailer charge card to settle a transaction. | LE_ACNT_CT_CNS_CHG | | | | NEW ENTITY | | |
CustomerReward | The generic entity used to represent different kinds of customer rewards offered by retailers to induce customers to purchase products and services. The nature of rewards varies. They all involve some common elements including: Eligibility Critieria - conditions a customer and their purchases must satisfy to be eligible to earn rewards. Examples include sales volume, frequency, purchasing specific items or item categories, etc. Reward Derivation - the calculation of the value of a reward. The value may be in monetary units, points,miles, etc. Reward derivation transforms the volume associated with eligibility conditions into a quantity of reward currency (points, money, miles, etc.) Reward Disposition - the timing and method used to redeem a reward. Disposition may be immediate in the current transaction or it may be deferred to a future redemption. Reward disposition is typically a decision made within a line item (e.g. instant, automatic coupons), a transaction or at the account level (deferred). Reward Financial Classification - rewards and the way they are disposed of have different financial accounting implications. This is where those implications are expressed as financial accounting rules. | TR_CT_RWD | | | | NEW ENTITY | | |
CustomerRewardDerivationRuleEligibility | This entity associates a RewardDerivationRule with a customer group and, by its presence, defines a customer group condition for triggering the application of the rule at the point of sale. This entity provides the linkages required to provide senior citizens discounts, credit union member discounts, etc. | CO_EL_CT_PRDV | | | | NEW ENTITY | | |
CustomerRewardLineItem | A type of retail transaction line item used to record the earning, redemption and adjustment of DEFERRED rewards like points, mile or other non-monetary values that may be accumulated for subsequent redemption in the form of discounts, free gifts, etc. | TR_CT_RWD_LN_ITM | CustomerRewardLineItem | A RetailTransactionLIneItemType that captures the redemption of a reward earned by a customer for referring a Consumer to the retailer (and where that consumer subsequently converts into a KeyCustomer). This entity may be used for other kinds of customer reward redemptions in the future. Also, it is separate from LoyaltyRewards because retailers may not want to impose a loyalty enrollment on customers as a pre-condition for earning referral rewards. | TR_LTM_CT_RWD | | CHANGED TABLE NAME | CHANGED ET DEF |
CustomerRewardRebateLineItem | A type of CustomerRewardLineItem used to record the earning, redemption and adjustment of REBATES. CUSTOMER REBATES are rewards that a customer earns and may claim after a purchase is completed. Customer rebates may be INSTANT REBATES or DEFERRABLE REBATES. Instant rebates are earned and redeemed within the same transaction. The earning part of an instant rebate is represented by an earn activity code in the parent CustomerRewardLineItem. Instant rebates are subtracted from a purchase price after it is recorded. The rebate value is represented by a redemption/settlement CustomerRewardLineItem. An INSTANT REBATE always has two CustomerRewardLineItem and CustomerRewardRebateLineItem instances for any rebate captured as part of a retail transaction. The first covers the earning of the rebate (which is a rebate claim). The second is a rebate redemption/settlement which is the payment of the rebate value to the customer. To the customer instant rebates are nearly indistinguishable from a discount. Within the ARTS ODM instant rebates and discounts are very different concepts (see the ODM Narrative Section: Understanding Rebates for a detailed explanation). Customer Rebates may be DEFERRABLE rewards. This means that a rebate is earned in a transaction, added to a rebate payable balance and paid to the customer at a future time through a separate transaction. Deferrable rebates will be recorded as two CustomerRewardLineItem - CustomerRewardRebateLineItem entity type instances. The first captures the earning of a rebate. The second captures the posting of the liability established for the future return of the rebate value to the customer. | TR_CT_RWD_RBT_LN _ITM | | | | NEW ENTITY | | |
CustomerServiceWorkOrderAccount | A customer account type created to track initial deposit, payment, refund and other financial actions related to delivering a service to a customer. For example customer A purchases a garage door from retailer X. The customer pays for the garage door. In addition the customer pays a deposit of $100 for installation service ( work order) . Upon completion of the installation the customer pays the remaining balance for the service of $200. This entity captures the initial deposit and susbequent payment. It also links them to a work order (or potentially a PO if the installer is an outside firm.) | LE_CT_SV_WRK_ORD_ACNT | | | | NEW ENTITY | | |
CustomerStoredValueAccount | A kind of customer account that designates a persistent financial relationship between a customer and a stored value instrument provider. Note that because CustomerStoredValueAccount is modeled here as a SUB-TYPE of CustomerAccount it represents a retailer owned or "house" stored value account where the credit balance carried in the account is a liability of the retailer. This is different from a third party owned stored value account where the liability is owned by the third party not the retailer. In this kind of scenario the retailer may use SVI's like currency but it does not own the liability carried in credit balances. Also, when the retailer sells SVIs it treats it as another item (albeit a non-merchandise item). The StoredValueAccount may have one ore more StoredValueInstruments associated with it. | LE_CT_STRD_VL_ACNT | | | | NEW ENTITY | | |
CustomerSubscriptionProgram | | LE_CT_SBSCRPTN_PRGM | | | | NEW ENTITY | | |
CustomerTradeAccount | A type of CUSTOMER ACCOUNT established for builders, plumbers, electricians and other trade businesses that purchase merchandise, usually at a preferential discount, from the store. A CustomerTradeAccount grants credit to customers on an invoice by invoice basis with the expectation that each invoice will be paid in full. It is different from a revolving charge account which carries an aggregate credit balance from period to period. | LE_ACNT_CT_TRD | CustomerTradeAccount | A type of CUSTOMER ACCOUNT established for builders, plumbers, electricians and other trade businesses that purchase merchandise, usually at a preferential discount, from the store. | LE_ACNT_CT_TRD | | | CHANGED ET DEF |
FreightBill | A carrier-originated document that lists the number of containers (e.g. pallets, cartons, etc.) that were delivered to the store. The freight bill does not reference the inner contents of a shipment. AKA Bill of Lading | DO_BL_FRGT | FreightBill | A carrier-originated document that lists the number of containers (e.g. pallets, cartons, etc.) that were delivered to the store. The freight bill does not reference the inner contents of a shipment. | DO_BL_FRGT | | | CHANGED ET DEF |
ItemRewardDerivationRuleEligibility | Defines an association between an ITEM and a RewardDerivationRule and the conditions which govern the application of the associated rule to an item at the time an instance of the item is recorded as a line item in a sale. | CO_EL_ITM_PRDV | | | | NEW ENTITY | | |
LoadingLimit | A rule that defines a maximum value for recharging (adding money to) a stored value instrument. | CO_LDNG_LM | | | | NEW ENTITY | | |
ManufacturerRewardDerivationRuleEligibility | Defines an association between a MANUFACTURER and RewardDerivationRule and the conditions which govern the application of the associated rule to an item falling under the merchandise structure at the time an instance of the item is recorded as a line item in a sale. | CO_EL_MF_PRDV | | | | NEW ENTITY | | |
MerchandiseHierarchyRewardDerivationRuleEligibility | Defines an association between a MERCHANDISE STRUCTURE LEVEL and RewardDerivationRule and the conditions which govern the application of the associated rule to an item falling under the merchandise structure at the time an instance of the item is recorded as a line item in a sale. This entity is used to link Rewards to merchandise hierarchy levels like departments, classes, sub-classes, styles and other named merchandise/service categories. Example: Earn 100 Bonus GOLD MEMBER POINTS when you buy $100 or more MEAT DEPARTMENT items. | CO_EL_MRHRC_PRDV | | | | NEW ENTITY | | |
PackageType | A code used to classify how merchandise is packaged for transportation and handling. | CO_PKG_TYP | | | | NEW ENTITY | | |
PackagingShape | A reference entity used to categorize package shapes for transportation planning and execution. Used as part of arranging the loading and unloading of trucks or other transportation equipment. | CO_PCKGNG_SHPE | | | | NEW ENTITY | | |
PackingSlip | A document that identifies the merchandise items a supplier claims to be shipping to the store against one or more purchase orders. REVISED DEFINITION 2016-05-23 A document that enumerates the items and item quantities contained in a ShipmentContainer or CustomerOrderShipmentContainer. The document is used to verify the contents of each container at receiving time. | DO_SP_PCKG | PackingSlip | A document that identifies the merchandise items a supplier claims to be shipping to the store against one or more purchase orders. | DO_SP_PCKG | | | CHANGED ET DEF |
PriceLineRewardDerivationRuleEligibility | Defines an association between a MERCHANDISE STRUCTURE RewardDerivationRule and a PRICE LINE for the purposes of triggering a reward. Example: For any item in Department 232 priced 99.99 to 129.99 take 10% off (covers only those items so this is a line item group subtotal reward derivation rule). | CO_EL_PRC_LN_PRDV | | | | NEW ENTITY | | |
PriceModificationType | A modfication in the selling price that is normally charged as an expense to the RETAIL STORE's general ledger or taken as a POS markdown in its stock ledger. Can be applied by transaction line item or to the whole transaction. | TR_MDF | PriceModificationType | A modfication in the selling price that is normally charged as an expense to the RETAIL STORE's general ledger. Can be applied by transaction line item or to the whole transaction. | TR_MDF | | | CHANGED ET DEF |
PromotionalOffer | A PromtionalOffer is a specific proposition to customers that specifies a reward and customer behavioral criteria for earning a reward. The recognition and issue of the reward is captured through a retail transaction, customer order, rebate claim, rebate redemption or customer interaction. Each of these point in time customer actions captures customer actions and relevant context information to determine what (if any) reward is earned, what triggered the issue of the reward and when and where it was triggered. | CO_PRM | PromotionalOffer | A collection of eligibilities and price derivation rules, during a specific time group. A PromtionalOffer is a specific kind of promotion that specifies a reward and customer behavioral criteria for earning a reward. The recognition and issue of the reward is captured through a retail transaction, customer order or customer interaction. Each of these point in time customer actions captures customer actions and relevant context information to determine what (if any) reward is earned, what triggered the issue of the reward and when and where it iwas triggered. ARTS 7 Change Renamed from Promotion. | CO_PRM | | | CHANGED ET DEF |
PromotionalOfferGroup | An infrastructural entity defining types of Promotions which allows Promotions to be grouped together for reporting purposes. | CO_TYP_PRM | | | | NEW ENTITY | | |
PromotionalOfferGroupOfferType | An associative entity resolving the many-to-many relationship between Promotion and PromotionType entity types. This allows Promotions to be grouped together for reporting purposes. | CO_PRM_TYP_PRM | | | | NEW ENTITY | | |
RaincheckDocument | A raincheck is an assurance of a deferred extension of an offer, especially an assurance that a customer can take advantage of a sale later if the item or service offered is not available (as by being sold out). A raincheck is typically represented as a kind of point of sale printed document that is used to secure the missed discount when it is presented in a subsequent retail transaction. Rainchecks have an expiration date and may allow substitution of other items for the original, out of stock item. | RNCHK | | | | NEW ENTITY | | |
RebateClaimDocument | A RebateClaim document that is issued when earned and may be redeemed in the current (as in an instant rebate) or subsequent retail transactions. This entity is a subtype of RetailTransactionDocument and represents the instantiation of a CustomerRebateClaim that is presented to a customer for their records. | DO_RBT_CLM_DCM | | | | NEW ENTITY | | |
RebateProgram | A planned set of offers and activities designed to refund cash, merchandise credit, voucher , stored value instrument, etc. to customers who purchase products and services and in so doing satisfy a set of rules defined by the RebateSponsor. Rebate programs may be sponsored by manufactuerers, suppliers, utility companies, healthcare companies and public agencies or the retailer itself. Rebate programs may be designed to achieve different outcomes such as increasing sales volume, decreasing the use of electricity, gas, oil and other kinds of energy, promoting healthy living habits, etc. Rebate programs may or may not require customers to be enrolled in retailer customer membership programs (hence the optional FK to CustomerMembershipProgram). | RBT_PRGM | RebateProgram | A planned set of offers and activities designed to refund money to customers who purchase products and services and in so doing satisfy a set of rules defined by the RebateSponsor. Rebate programs may be sponsored by manufactuerers, suppliers, utility companies, healthcare companies and public agencies. Rebate programs may be designed to achieve different outcomes such as increasing sales volume, decreasing the use of electricity, gas, oil and other kinds of energy, promoting healthy living habits, etc. | RBT_PRGM | | | CHANGED ET DEF |
RelatedItemAssociation | An association betwen two items where the two items are commonly sold together. For example a car battery is often sold with an attached core charge which is a kind of refundable fee a customer pays for battery recycleing. Another example is drink container deposits. The deposit item is often linked to the drink itslfe. This also may apply to rental items where the rental item will have a deposit item attached or possibly another consumable item like fuel. For example ABC Outdoor Equipment may rent a chainsaw and along with it include a full tank of fuel ( a linked item). ARTS offers several ways to associate items together when recording their sale. This method builds the association into the item. The others involve linking line items in a retail transaction. | CO_ASCTN_RLTD_ITM | RelatedItemAssociation | An association between two items for a specific purpose such as substitution, upselling, cross selling, etc. For each association between related items, transaction and sales summaries may be calculated to analyze how frequently they are purchased together in a sale and how frequently they are purchased separately. | CO_ASCTN_RLTD_ITM | | | CHANGED ET DEF |
RelatedItemAssociationType | A reason or categorization of why items are related to each other. For example, items may be related as substitutions, upsell, cross sell, or other reasons. DEPOSIT_FEE CONSUMABLE_ITEM (related to rental of a tool - fuel, etc.) HANDLING_FEE BATTERY_CORE_CHARGE These are examples. Retailers must define their own codes. | CO_TYP_RLTD_ITM | RelatedItemAssociationType | A reason or categorization of why items are related to each other. For example, items may be related as substitutions, upsell, cross sell, or other reasons. | CO_TYP_RLTD_ITM | | | CHANGED ET DEF |
RentalModifier | An extension to ARTS SaleReturnLineItem used to capture supplementary data about a rental line item. The extended rental charge is reflected in the SaleReturnLineItem.ExtendedAmount. | CO_RNT_MDFR | | | | NEW ENTITY | | |
RentalServiceTerms | The terms and conditions that apply to the rental of a RentalService item. Establishes deposit requirements, start and end rental date times, penaltys and fees, retunr condition, etc. | AS_SV_RNT | | | | NEW ENTITY | | |
RentalStandardContract | A retailers baseline contract that specifies the terms and conditions governing their rental services. The RentalStandardContract serves as a parent entity type used to collect RentalServiceTerms together to faciliated standardized contract management for retailers. | CO_RNT_STD_CNTRT | | | | NEW ENTITY | | |
RentalUnit | A SerializedUnit that is rented out by the retailer for customers to use, It is NOT part of a retailer's inventory but is considered a kind of fixed asset. Rental revenue is service income. | ID_UN_RNT | RentalUnit | An associative entity denoting which SerializedItems may be rented via a particular RentalService | ID_UN_RNT | | | CHANGED ET DEF |
RetailTransactionDocument | A paper and/or digital document that is ISSUED or REDEEMED as part of a RetailTransaction. | DO_RTL_TRN_DCM | | | | NEW ENTITY | | |
RetailTransactionDocumentImage | An image of a printed RetailTransactionDocument that may be provided to a customer along with their sales receipt. The printed document serves as a token that is generated (issued) or redeemed (used to offset all or a portion of a subsequent retail transaction balance due). | DO_RTL_TRN_DCM_IMG | | | | NEW ENTITY | | |
RetailTransactionDocumentLineitem | A subtype of retail transaction line item used to capture the issue of a RetailTransactionDocument to a customer. In ARTS a number of different kinds of RetailTransactionDocuments are supported including: Bounceback Coupons Rebate Claims Reward Vouchers (gift certifcates, stored value cards, etc.) Rainchecks (delayed coupons) As represented in ARTS, retail transaction documents represent a kind of deferrable reward which means it is earned in one transaction and redeemed in a subsequent retail transaction. The document provides an explicit link between a reward "earn" action and a reward "burn" or redemption action when they are executed in separate retail transactions. | DO_RTL_TRN _DCM_LN_ITM | | | | NEW ENTITY | | |
RetailTransactionLineItemAssociation | Associative entity recording relationships between line items within the same or two different RetailTransaction instances. Examples of usage of this entity include: - Associating an original sales line item to a return line item - Associating an original sales line item to an exchange line item - Associating a sales line item to a fee line item - Associating a raincheck voucher issue line item to a raincheck voucher redemption line item - Associating a rental item with deposit item and where appropriate penalty and other kinds of supplementary charges. - Associating a sale/return line item with the deferred reward line items derived from it (using RewardDerivationRule, RewardEligibilityRule and Rewars information. | ST_ASCTN_LTM_RTL | RetailTransactionLineItemAssociation | Associative entity recording relationships between line items within the same or two different RetailTransaction instances. Examples of usage of this entity include: - Associating an original sales line item to a return line item - Associating an original sales line item to an exchange line item - Associating a sales line item to a fee line item | ST_ASCTN_LTM_RTL | | | CHANGED ET DEF |
RetailTransactionLineItemGroupType | The kind of groups of line items in a RetailTransaction. DELIVERY PICKUP MIX_MATCH e.g. Delivery, Pickup, Tray (in food service) | TR_RTL_LTMGP_TYP | RetailTransactionLineItemGroupType | The kind of groups of line items in a RetailTransaction. e.g. Delivery, Pickup, Tray (in food service) | TR_RTL_LTMGP_TYP | | | CHANGED ET DEF |
RetailTransactionLineItemResourceOverride | A record of the OperatorID of the supervisor who authorized access to the RetailTransactionLineItem based Resource that the Operator of record was denied access to. This is an OVERRIDE that enables a manager to modify retail transaction line item attributes that are normally not accessible for update by an operator. An override represents an exception condition that is typcially closely watched by loss prevention and audit staff to ensure that the retailer is not being disadvanteged. Often overrides are used by managers to grant customers return privliges that might not otherwise have been available (e.g. accpepting a return without a receipt). | TR_LTM_RTL_TRN_OVR | RetailTransactionLineItemResourceOverride | A record of the OperatorID of the supervisor who authorized access to the RetailTransactionLineItem based Resource that the Operator of record was denied access to. | TR_LTM_RTL_TRN_OVR | | | CHANGED ET DEF |
RetailTransactionReceiptImage | Identifies and references an image of the printed receipt originally created for this transaction. It is an optional, attributive entity. | TR_RTL_TRN_RCT_IMG | | | | NEW ENTITY | | |
RetailTransactionRentalModifier | An attributive entity type that extends the basic ARTS RetailTransaction entity to include rental provisions. This is an optional entity type. | CO_RTL_TRN _RNT_MDFR | | | | NEW ENTITY | | |
RetailTransactionSalesReceiptImage | This entity identifies and describes a sales receipt digital image that is an exact duplicate of a paper sales receipt printed from the retail transaction. As used here, a digital image is a raster or vector representation of a sales receipt with no retrievable business data. The retrievable business data is already captured in the RetailTransaction and its component entity types. NOTE that the parameters, message structures, methods and other components of a digital receipt generation process are NOT reflected in this entity. Its sole purpose is to provide a way to access the image object connected to the related RetailTransaction. | DO_RTL_TRN_SLS_RCT_IMG | | | | NEW ENTITY | | |
Reward | A Reward is an identified, named benefit provided by a retailer or 3rd party to customers in exchange for customer actions (like purchasing products, visiting web sites or stores, referring other customers, renting items, etc.) . ARTS uses a generic term, Reward, so it can represent a variety of retail benefits including promotional discounts, deals, loyalty program incentives, rebate programs, etc. using a consistent set of entitiy types. | TR_RWD | | | | NEW ENTITY | | |
RewardCurrencyType | A prescribed method for measuring customer rewards for earning and redemption purposes. This generalized entity allows retailers to define rewards using unit designation that are most approrpriate to their product and service offerings. | CO_LYLT_CNY_TYP | | | | NEW ENTITY | | |
RewardDerivationRule | A rule that defines how a reward value is determined when a sale return item in a transaction (or the customer's account, line item subtotal or transaction level property) is eligible for the reward. Reward: 33% promotion of XYZ branded sweaters (Class 323) Eligibility: Buy one or more XYZ brand AND Class 323 (sweaters) Reward Attribution: Get an immediate 33% discount off of the item or items meeting the eligibility requirements. For a transaction with one XYZ brand sweater that has a regular price of 59.99 it means a $19.80 discount generated as a RetailPriceModifier. For a transaction with two XYX brand sweaters it means two discounts (one for each sweater) for a total of 119.98 less 39.59 discount (implemented as two RetailPriceModifiers. | RU_RWD_DRVN_RU | | | | NEW ENTITY | | |
RewardDerivationRuleEligibilityAssociation | The RewardDerivationRuleEligibilityAssociation entity type establishes an association between two or more RewardDerivationRuleEligibility entity types and is used to enable compound eligibility rules to be defined by retailers. This entity type, along with the CombinationRewardDerivationRuleEligibility entity type allows a retailer to "stack" promotion eligibility requirements using AND and OR conditions. This allows retailers to define very precisely targeted rewards. | ST_ASCTN_EL_PRDV | | | | NEW ENTITY | | |
RewardDerivationRuleEligibilityMaintenance | A type of DataMaintenanceEvent that results in the creation, update or deletion of a RewardDerivationRuleEligibility entity type instance. | MA_RU_PRDV_EL | | | | NEW ENTITY | | |
RewardEligibilityPropertyType | A list of valid RewardEligibilityTypes represented in the ARTS ODM. This list may be extended by retailers along with RewardEligibilityRule subtype entities. BRAND_NAME Brand ARTS ODM V7.2 CALENDAR_ID Calendar Period part 1 ARTS ODM V7.2 CALENDAR_LEVEL_ID Calendar Period part 2 ARTS ODM V7.2 CALENDAR_PERIOD_ID Calendar Period part 3 ARTS ODM V7.2 CHANNEL_ID Channel ARTS ODM V7.2 CUSTOMER_ACCOUNT_ID Customer Account ARTS ODM V7.2 CUSTOMER_MEMBER_PROGRAM_ACCOUNT_ID Customer Membershipp Prog Acct ARTS ODM V7.2 EMPLOYEE_DISCOUNT_GROUP_ID Employee Discount Group ARTS ODM V7.2 ITEM_ID Single Item ID (SKU) ARTS ODM V7.2 MANUFACTURER_ID Manufacturer ARTS ODM V7.2 MARKET_BASKET_TRIGGER_ID (follow up on this one) ARTS ODM V7.2 MERCHANDISE_HIERARCHY_GROUP Merch Hier. Group (we're simplifying this will require tree view to create UI) ARTS ODM V7.2 PRICE_LINE_ID Price Line ARTS ODM V7.2 PRICE_OVERRIDE Flagged overriden price - no ARTS equivalent SALE_RTN_CLASS This should be handled in MERCHANDISE HIERARCHY GROUP SALE_RTN_DEPARTMENT This should be handled in MERCHANDISE HIERARCHY GROUP SALE_RTN_ITEM_CLEARANCE no ARTS equivalent SALE_RTN_ITEM_DISCOUNTED Sale Return item is already discounted SALE_RTN_ITEM_STOCK_STATUS no ARTS equivalent SALE_RTN_ITEM_VENDOR This should be handled by mfg / brand SALE_RTN_QUANTITY Eligibilty trigger qty SALE_RTN_SKU Handled by ITEM_ID SALE_RTN_STYLE This should be handled in MERCHANDISE HIERARCHY GROUP SALE_RTN_SUBCLASS This should be handled in MERCHANDISE HIERARCHY GROUP SALE_RTN_SUBDEPARTMENT This should be handled in MERCHANDISE HIERARCHY GROUP SALE_RTN_UNIT_PRICE Eligibilty trigger retail price SEASON see Calendar SEQ_NUMBER Comparison is between the line item number from sale return row and the value in VALUE1 TENDER_MEDIA_BRAND_ID Branded Tender Type part 2 ARTS ODM V7.2 TENDER_TYPE_CODE Branded Tender Type part 1 ARTS ODM V7.2 | CO_RWD_EL_PRY_TYP | | | | NEW ENTITY | | |
RewardEligibilityRule | Defines the conditions which must be satisfied before a RewardDerivationRule may be applied to a transaction or transaction line item. | CO_EL_PRDV | | | | NEW ENTITY | | |
RewardGroup | A named collection of Rewards. NOTE This is a provisional ARTS entity. Its intent is to allow Rewards to be grouped for complex AND/Or applications of rewards within a group. | CO_RWD_GP | | | | NEW ENTITY | | |
RewardVoucherDocument | A subtype of RetailTransactionDocument issued to a customer which entitles them to receive a discount on purchases they make. In retail voucher is a term that is used to cover a number of different kinds of money back offers to customers. From an accounting point of view, a voucher is a non-currency document that may be used as part of a payment tender to settle a transaction. In this context, a voucher can be viewed as a kind of tender. Coinstar, for example allows customers to pay in coins and receive a voucher they may use to pay for products. As used here, a RewardVoucherDocument is used to REDUCE THE PRICE OF PRODUCTS AND SERVICES purchased by a customer. Technically it is NOT a type of tender -- it is a DISCOUNT not a type of tender. | DO_RWD_VCHR_DCM | | | | NEW ENTITY | | |
ShipMethod | Identifies, defines and describes a carrier-specific method for transporting merchandise between a retailer and customer. | CO_SHP_MTH | | | | NEW ENTITY | | |
SpendingLimit | A rule that establishes a limit on the transaction count, monetary value per transaction and/or total transaction value permitted over a defined period of time. This is used for college stored value cards, government issued stored value cards and other SVI's with a relatively large monetary value. | CO_SPND_LM | | | | NEW ENTITY | | |
StoredValueCardSupplement | This outrigger table supplements the information in the StoredValueInstrument entity by providing a place for magnetic card stored value media. | CO_STRD_VL_CRD_SPPLMNT | | | | NEW ENTITY | | |
StoredValueControlTransaction | A Transaction subtype designed to administer StoredValueInstruments and StoredValueAccount outside of a retail transaction context. Used to cancel, adjust, cash out or otherwise change a stored value instrument and account as a stand alone transaction. NOTE: This entity is included here because it is in POSLOG6. There seems to be an overlap between this entity and the StoredValueTransaction entity. For this release of the ARTS ODM we are keeping this entity. We may depricate it in future releases. | TR_STRD_VL_CTL_TRN | | | | NEW ENTITY | | |
StoredValueFundSaleLineItem | TheStoredValueFundSale captures the sale of a gift card, gift certificate or other kind of stored value instrument to a customer. It corresponds to POSLOG6 StoredValueFundSale element. Retailers may sell their own stored value instruments or thrid party stored value instruments (e.g. Blackhawk Giftcards, VISA Giftcards, etc.). When retailers sell a stored value instrument that they "own", they credit stored value unearned revenue or a similar liability account. The retailer has collected a payment and in effect holds it in the stored value instrument for subsequent redemption by the customer. For third party stored value instruments, the third party, not the retailer has the unearned revenue liability. In this case the retailer earns a fee or some kind of margin on the 3rd party stored value instrument and may treat it as another item. In addition to customers explicitly purchasing stored value instruments, a retailer may give them away as part of a promotion (e.g. "free" $10 giftcard when you buy $100 or more worth of merchandise). In this scenario (assuming the retailer "owns" the giftcard), the retailer will debit discount, credit unearned stored value revenue liability and book the merchandise, tax and tender line items as usual. | TR_STRD_VL_FND_SL_LN _ITM | | | | NEW ENTITY | | |
StoredValueInstrument | A plastic card, paper document, key fob or other token that carries a credit balance that may be used to pay for (debit) customer purchases or in tender exchanges (converting the stored value into another tender media like cash, credit/debit card credit, send check, etc.). StoredValueInstruments are used like money but are paper or digital surrogates that are typically purchased and have value added to them in exchange for "real" money. As the name suggests, these entities retain value and may be used to make purchases. Typically stored value instruments may be added to or subtracted from through retail sales and return transactions. The attributes and definition for this entity are taken from POSLOG6 NOTE: StoredValueInstruments, as modeled in ARTS ODM V7.3 are NOT the same thing as COUPONS and VOUCHERS. This distinction is important. StoredValueInstruments function like tender. MANUFACTURER COUPONS are a form of discount. Now manufacturer discounts may be processed as a form of tender in a retail point of sale system. But they are NOT MONEY EQUIVALENTS. Manufacturer coupons are a kind of receivable that the retailer books with the intent of collecting from the manufactuer. This may be confusing but it makes sense. StoredValueInstruments are like money. Manufacturer coupons are like an IOU that retailers will collect on later. RETAILER COUPONS are discounts. They are debited as a point of sale markdown by the retailer. They do NOT represent a payment of any kind. They are NOT money surrogates. They are completely different from StoredValueInstruments VOUCHERS are a kind of deferred discount document. In ARTS, VOUCHERS are NOT money surrogates. They are treated as point of sale markdowns or discount expenses when processed at the point of sale. In ARTS ODM V7.3 a car wash token, free meal punch card, etc. are kinds of VOUCHERS - they represent stored discounts NOT stored money. Services like COINSTAR that aggregate customer change and issue documents they call "vouchers" are, in ARTS, a StoredValueInstrument. They take in real money and issue a document that may be used like money -- it is NOT a DISCOUNT. | DO_STRD_VL_INSTRMNT | | | | NEW ENTITY | | |
StoredValueInstrumentActivationAuthorization | Join entity that associates a StoredVaoueInstrument activation with a TenderAuthorization. Prepaid gift cards and other stored value media require authorization before thay may be used to purchase items. Activation incorporates authorization as part of its process similarly to the way credit and debit cards use authorization as a way to validate their use in a retail transaction. | TR_STRD_VL_INSTRMNT_ACV_AZN | | | | NEW ENTITY | | |
StoredValueInstrumentDocument | The record of a StoredValueInstrument (a prepaid card, a gift card, a stored value card, gift certificate etc.) represented as a document within the scope of a retail transaction. This is part of the generalized handling of retail transaction-related documents in the ARTS ODM. | DO_STRD_VL_INSTRMNT_DCM | | | | NEW ENTITY | | |
StoredValueInstrumentType | ARTS designated category of StoredValueInstruments. Examples include: GIFT_CERTIFICATE - Gift certificate GIFT_CARD - non-refillable stored value card PREPAID_PHONE_CARD - Prepaid phone card PREPAID_MEAL_CARD - Prepaid meal(s) card STORED_VALUE_CARD - Rechargable stored value card Retailers may add additional rows as required. | CO_STRD_VL_INSTRMNT_TYP | | | | NEW ENTITY | | |
StoredValueTransaction | A type of TenderControlTransaction that captures the activation, loading, canceling and other actions taken for a StoredValueInstrument. | TR_STRD_VL_TND_CTL_TRN | | | | NEW ENTITY | | |
StoredValueTenderLineItem | StoredValueTenderLine item records the debit or credit of monetary value to a StoredValueInstrument within the context of a retail transaction. StoredValueInstrument balances will be reduced by sales and increased by returns. | TR_LTM_VCHR_TND | | | | NEW ENTITY | | |
StoreValueInstrumentMediaType | The format and media used to represent a StoredValueMediaInstrument. Examples include: PAPER STORED_VALUE_CARD MOBILE_WALLET OTHER | CO_STR_VL_INSTRMNT_MD_TYP | | | | NEW ENTITY | | |
TenderLineItemAuthorization | | CO_TND_LN_ITM_AZN | | | | NEW ENTITY | | |
TimeGroup | A named set of consecutive hours on a set of days of the week. e.g. 10am - 2pm Mon, Wed and Fri. | CO_GP_TM | TimeGroup | A set of consecutive hours on a set of days of the week. e.g. 10am - 2pm Mon, Wed and Fri. | CO_GP_TM | | | CHANGED ET DEF |
TotalPurchaseMarketBasketRewardDerivationRuleEligibility | This entity associates a market basket reward eligibility rule with a specific transaction-level RewardPriceDerivationRule. This association links the rule with the condition triggering its application. | CO_EL_MRBK_PRDV | | | | NEW ENTITY | | |
TransactionTotalType | A retailer defined classification of transaction subtotal used to summarize different kinds of line items in a retail transaction. One key use for designating transaction total type is to define subtotal categories used to add up line item values used as the base for calculating transaction-level discounts. Other uses may include aggregating subtotals for different kinds of tax calculations, summarizing sales of vendor deal merchandise to support scan based trading deals, etc. | TR_TOT_TYP | TransactionTotalType | One of many different kinds of Total kept in a RetailTransaction. Ususally TotalTaxableAmount, TotalTaxCollected, TotalAmountPaid, TotalItemCount, etc... | TR_TOT_TYP | | | CHANGED ET DEF |
TransportBillingMethod | Retailer designated category of how transportation costs are to be billed for a shipment. | CO_TRNSPRT_BLLNG_MTH | | | | NEW ENTITY | | |
TransportPaymentMethod | Designated methods of paying for transportation services. | CO_TRNSPRT_PYM_MTH | | | | NEW ENTITY | | |
TransportServiceLevelType | A designated code used to designate different gradations of tranportation services. | CO_TRNSPRT_PYM_SV_LV_TYP | | | | NEW ENTITY | | |
WorkerDiscountGroupRewardDerivationRuleEligibility | Establishes the association between an employee Discount Group and a RewardDerivationRule. The association indicates that the employee group is eligible for a price reduction. | CO_EL_EM_DSC_PRDV | | | | NEW ENTITY | | |