Subject Area Concepts The Logical 03110 entity diagram details the entities used to capture of the movement of Tender in and out of various tender repositories. Tender is the Cash, Checks, Travelers Checks, Credit Card Slips, and all other financial instruments that the retailer will exchange for goods sold or returned. All forms of tender are placed in repositories, and each TenderRepository has its own set of tender history totals. The three kinds of TenderRepository are: •Till: The insert that lives inside the cash-drawer that is attached to the POS. Money is added to the till via sales recorded in RetailTransaction and the tender loans and funds received types of TenderControlTransaction. Tender is removed from the till via returns recorded in RetailTransaction and the tender pickup type of TenderControlTransaction; •Safe: One or more safes that are used to store Tender and Tills. Tender is added to the safe via tender pickup and safe transfer types of TenderControlTransaction, while it is removed from the safe via the tender loan, safe transfer and tender deposit types of TenderControlTransaction; and •ExternalDepository: One or more banks or cash pickup companies, that takes the collected Tender offsite and arranges its deposit into the retailer's bank accounts. Tender is only ever added to the external depository via the tender deposit type of TenderControlTransaction. Each of the three kinds of tender repository have two sets of tender history totals, giving a complete set of six tender repository history entity types: •TillTender: A single record for each kind of Tender in each Till. Each record has an opening balance, a set of movement deltas since opening and a current balance. These records are closed through a TillSettlementTransaction, at which time the data is copied to TillSettlementDocument, the closing balance is copied to the opening balance, and the movement deltas are set to zero. This entity serves as the real-time record of how much money is sitting in which tills at the present time; •TillSettlementTenderDetail: Multiple records for each kind of Tender in each Till. Each record has an opening balance, a set of movement deltas summarizing tender movements in and out of the till, and the closing balance. This entity serves as the historic record of the movement of money into and out of the till, during the period of time bounded by two successive till settlement transactions; •StoreSafeTender: A single record for each kind of Tender in each Safe. Each record has an opening balance, a set of movement deltas since opening and a current balance. These records are closed via a SafeSettlementTransaction, at which time the data is copied to StoreSafeSettlementDocument, the closing balance is copied to the opening balance, and the movement deltas are set to zero. This entity serves as the real-time record of how much money is sitting in each safe right now; •StoreSafeSettlementTenderDetail: Multiple records for each kind of Tender in each Safe. Each record has an opening balance, a set of movement transactions summarizing tender movements in and out of the safe and the closing balance. This entity serves as the historic record of the movement of Tender into and out of the till during the period of time bounded by two successive safe settlement transactions; •ExternalDepositoryTender: A single record for each kind of Tender in each ExternalDepository. Each record has an opening balance, a set of movement deltas summarizing tender movements into the depository since opening, and the current balance. These records are closed via an ExternalDepositorySettlementTransaction, at which time the data is copied to ExternalDepositoryDocument, while the opening balance, movement deltas and current balance are all set to zero. This entity serves as the real-time record of how much money is sitting in what external depositories right now; and •ExternalTenderDepositorySettlementTenderDetail: Multiple records for each kind of Tender in each ExternalDepository. Each record has an opening balance, a set of movement deltas into the depository and the closing balance. This entity serves as the historic record of the movement of money into the depository during the period of time bounded by two successive depository settlement transactions. These tender repository tender history totals use a settlement transaction based time-dimension rather than the ReportingPeriod time-dimension, because although tills, safes and depositories may be settled and reconciled as part of the store "day-end" process (and hence could use the ReportingPeriod time-dimension), the repositories may also be settled at other times as well. |