| Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
| ReportingPeriodID (FK)(PK) | The unique system assigned identifier for a particular ReportingPeriod. | ID_PRD_RP | Identity | integer | ReportingPeriod(CA_PRD_RP) |
| RetailStoreID (FK)(PK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_STR_RTL | Identity | integer | RetailStore(PA_STR_RTL) |
| GrossPositiveTotalAmount | The total monetary positive gross sales amount recorded by RETAIL STORE for each REPORTING PERIOD. | TP_SLS_GS_PSTV_TOT | Money | decimal(16,5) | |
| GrossNegativeTotalAmount | The total monetary negative gross sales amount recorded by RETAIL STORE for each REPORTING PERIOD. | TP_SLS_GS_NG_TOT | Money | decimal(16,5) | |
| TotalTransactionCount | The total number of transactions recorded by the RETAIL STORE for each REPORTING PERIOD. | QU_TRN_TOT | QuantityTransactionCount | decimal(7,0) | |
| LineItemVoidTotalAmount | The total monetary amount of line item voids made by RETAIL STORE for each REPORTING PERIOD. | MO_VD_LN_ITM_TOT | Money | decimal(16,5) | |
| TotalLineItemVoidCount | The total number of line item voids recorded by RETAIL STORE for each REPORTING PERIOD. | QU_VD_LN_ITM_TOT | QuantityTransactionCount | decimal(7,0) | |
| PostTransactionVoidTotalAmount | The total monetary amount of post transaction voids recorded by RETAIL STORE for each REPORTING PERIOD. | MO_VD_PST_TRN_TOT | Money | decimal(16,5) | |
| TotalPostTransactionVoidCount | The total number of post transaction voids recorded by RETAIL STORE for each REPORTING PERIOD. | QU_VD_PST_TRN_TOT | QuantityTransactionCount | decimal(7,0) | |
| TransactionVoidTotalAmount | The total monetary amount of transaction voids recorded by RETAIL STOREfor each REPORTING PERIOD. | MO_VD_TRN_TOT | Money | decimal(16,5) | |
| TotalTransactionVoidCount | The total number of transactions voids by RETAIL STORE for each REPORTING PERIOD. | QU_VD_TRN_TOT | QuantityTransactionCount | decimal(7,0) | |
| TotalTenderPickupCount | The total number of tender pickups from this RETAIL STORE for each REPORTING PERIOD. | QU_PKP_TND_TOT | Money | decimal(16,5) | |
| TotalTenderLoanCount | The total number of tender loans by the RETAIL STORE for each REPORTING PERIOD. | QU_LON_TND_TOT | QuantityTransactionCount | decimal(7,0) | |
| TenderLoanTotalAmount | The total monetary amount of tender loans by the RETAIL STORE for each REPORTING PERIOD. | MO_LON_TND_TOT | Money | decimal(16,5) | |
| TenderPickupTotalAmount | The total monetary amount of tender pickups by the RETAIL STORE for each REPORTING PERIOD. | MO_PKP_TND_TOT | Money | decimal(16,5) | |
| ReturnTotalAmount | The total monetary amount of returns by RETAIL STORE for each REPORTING PERIOD. | MO_RTN_TOT | Money | decimal(16,5) | |
| TotalReturnCount | The total number of returns by RETAIL STORE for each REPORTING PERIOD. | QU_RTN_TOT | QuantityTransactionCount | decimal(7,0) | |
| RefundTotalAmount | The total monetary amount refunded by RETAIL STORE for each REPORTING PERIOD. | MO_RFD_TOT | Money | decimal(16,5) | |
| TotalRefundCount | The total number of refunds by RETAIL STORE for each REPORTING PERIOD. | QU_RFD_TOT | QuantityTransactionCount | decimal(7,0) | |
| EmployeeDiscountTotalAmount | The total monetary amount of employee discounts by RETAIL STORE for each REPORTING PERIOD. | MO_DSC_EM_TOT | Money | decimal(16,5) | |
| TotalEmployeeDiscountCount | The total number of employee discount line items by RETAIL STORE for each REPORTING PERIOD. | QU_DSC_EM_TOT | QuantityTransactionCount | decimal(7,0) | |
| MiscellaneousDiscountTotalAmount | The total monetary amount of miscellaneous discounts by RETAIL STORE for each REPORTING PERIOD. | MO_DSC_MSC_TOT | Money | decimal(16,5) | |
| TotalMiscellaneousDiscountCount | The total number of miscellaneous line items by RETAIL STORE for each REPORTING PERIOD. | QU_DS_MSC_TOT | QuantityTransactionCount | decimal(7,0) | |
| StoreCouponTotalAmount | The total monetary amount of store coupons by RETAIL STORE for each REPORTING PERIOD. | MO_CPN_STR_TOT | Money | decimal(16,5) | |
| TotalStoreCouponCount | The total number of store coupons by RETAIL STORE for each REPORTING PERIOD. | QU_CPN_STR_TOT | QuantityTransactionCount | decimal(7,0) | |
| RedeemedContainerDepositTotalAmount | The total monetary amount of container deposits redeemed by RETAIL STORE for each REPORTING PERIOD. | MO_DS_RDM_CNR_TOT | Money | decimal(16,5) | |
| TotalRedeemedContainerDepositCount | The total number of container deposits redeemed by RETAIL STORE for each REPORTING PERIOD. | QU_DS_RDM_CNR | QuantityTransactionCount | decimal(7,0) | |
| MarkdownTotalAmount | The total monetary amount of line item markdowns made by RETAIL STORE for each REPORTING PERIOD. | MO_MKD_TOT | Money | decimal(16,5) | |
| TotalMarkdownCount | The total number of line item markdowns made by RETAIL STORE for each REPORTING PERIOD. | QU_MKD_TOT | QuantityTransactionCount | decimal(7,0) | |
| NetSalesTotalAmount | The total monetary amount of net sales recorded by RETAIL STORE for each REPORTING PERIOD. | MO_SLS_NT_TOT | Money | decimal(16,5) | |
| MiscellaneousFeeTotalAmount | The total monetary amount of miscellaneous fees recorded by RETAIL STORE for each REPORTING PERIOD. | MO_FE_MSC_TOT | Money | decimal(16,5) | |
| TotalMiscellaneousFeeCount | The total number of miscellaneous fees recorded by RETAIL STORE for each REPORTING PERIOD. | QU_FE_MSC_TOT | QuantityTransactionCount | decimal(7,0) | |
| ContainerDepositTotalAmount | The total monetary amount container deposits collected by RETAIL STORE for each REPORTING PERIOD. | MO_DS_CNR_TOT | Money | decimal(16,5) | |
| TotalContainerDepositCount | The total number of container deposits collected by RETAIL STORE for each REPORTING PERIOD. | QU_DS_CNR_TOT | QuantityTransactionCount | decimal(7,0) | |
| PaymentsCollectedTotalAmount | The total monetary amount of payments collected by RETAIL STORE for each REPORTING PERIOD. | MO_PYM_CLT_TOT | Money | decimal(16,5) | |
| TotalPaymentsCollectedCount | The total number of payments on account collected by RETAIL STORE for each REPORTING PERIOD. | QU_PYM_CLT_TOT | QuantityTransactionCount | decimal(7,0) | |
| LayawayPaymentsCollectedTotalAmount | The total monetary amount of layaway payments collected by RETAIL STORE for each REPORTING PERIOD. | MO_PYM_LY_CLT_TOT | Money | decimal(16,5) | |
| TotalLayawayPaymentsCollectedCount | The total number of layaway payments collected by RETAIL STORE for each REPORTING PERIOD. | QU_PYM_LY_CLT_TOT | QuantityTransactionCount | decimal(7,0) | |
| PettyCashDisbursementTotalAmount | The total monetary amount of petty cash line disbursements by RETAIL STORE for each REPORTING PERIOD. | MO_DSB_PTY_CSH_TOT | Money | decimal(16,5) | |
| TotalPettyCashDisbursementLineItemCount | he total number of petty cash line disbursements by RETAIL STORE for each REPORTING PERIOD. | QU_DSB_PTY_LN_ITM | QuantityTransactionCount | decimal(7,0) | |
| GrossSalesExTaxTotalAmount | The total gross sales excluding tax recorded by RETAIL STORE for each REPORTING PERIOD. | TP_SLS_EX_TX_TOT | Money | decimal(16,5) | |
| TaxTotalAmount | The total tax recorded by RETAIL STORE for each REPORTING PERIOD. | MO_TX_TOT | Money | decimal(16,5) | |
| TaxExemptTotalAmount | The total monetary amount of tax exempt transactions by RETAIL STORE for each REPORTING PERIOD. | MO_TX_EXM_TOT | Money | decimal(16,5) | |
| TotalTaxExemptTransactionCount | The total number of tax exempt transactions by RETAIL STORE for each REPORTING PERIOD. | QU_TRN_TX_EXM_TOT | Money | decimal(16,5) | |
| TotalLineItemOverrideCount | The total number of line item overrides by RETAIL STORE for each REPORTING PERIOD. | QU_OVRD_LN_ITM_TOT | QuantityTransactionCount | decimal(7,0) | |
| TotalWeighedLineItemCount | The total number of weighed line items by RETAIL STORE for each REPORTING PERIOD. | QU_ITM_LN_WT_TOT | QuantityTransactionCount | decimal(7,0) | |
| TotalLineItemKeyedCount | The total number of ITEMs keyed at the point of sale by RETAIL STORE for each REPORTING PERIOD. | QU_ITM_LN_KY_TOT | QuantityTransactionCount | decimal(7,0) | |
| TotalLineItemScannedCount | The total number of ITEMs scanned by RETAIL STORE for each REPORTING PERIOD. | QU_SC_LN_ITM_TOT | QuantityTransactionCount | decimal(7,0) | |
| TotalLineItemKeyedPercentage | The percentage of ITEMs keyed at the point of sale compared to the total sold ITEMs by RETAIL STORE for each REPORTING PERIOD. | PE_ITM_LN_KY_TOT | Percent | decimal(7,4) | |
| TotalLineItemScannedPercentage | The percentage of ITEMs keyed at the point of sale compared to the total sold ITEMs by RETAIL STORE for each REPORTING PERIOD. | PE_SC_LN_ITM_TOT | Percent | decimal(7,4) | |
| TotalLineItemOpenDepartmentCount | The number of ITEMs recorded through an open department by RETAIL STORE for each REPORTING PERIOD. | QU_DPT_LN_ITM_TOT | QuantityTransactionCount | decimal(7,0) | |
| TotalLineItemOpenDepartmentPercentage | The number of ITEMs recorded through an open department by RETAIL STORE for each REPORTING PERIOD. | PE_DPT_LN_ITM_TOT | Percent | decimal(7,4) | |
| TotalNoSaleTransactionCount | The total number of no sale transactions recorded by RETAIL STORE for each REPORTING PERIOD. | QU_TRN_NO_SLS_TOT | QuantityTransactionCount | decimal(7,0) | |
| TotalRingTime | The total time expressed in minutes spent scanning or keying ITEMs by RETAIL STORE for each REPORTING PERIOD. | IN_RNG_TOT | QuantityShortCountSeconds | decimal(5,0) | |
| TotalIdleTime | The total time expressed in minutes spent by the point of sale system in non-activity (e.g. in wait mode with no operator activity) by RETAIL STORE for each REPORTING PERIOD. | IN_IDL_TOT | QuantityShortCountSeconds | decimal(5,0) | |
| TotalLockTime | he total time expressed in minutes when the WORKSTATION is locked even though an OPERATOR is signed on by RETAIL STORE for each REPORTING PERIOD. | IN_LCK_TOT | QuantityShortCountSeconds | decimal(5,0) | |
| TotalSaleLineItemCount | The total number of line item sales recorded by RETAIL STORE for each REPORTING PERIOD. | QU_ITM_LN_SLS_TOT | QuantityTransactionCount | decimal(7,0) | |
| TotalSignOnCount | The total number of operator sign-ons on this RETAIL STORE for each REPORTING PERIOD. | QU_SGN_ON_TOT | QuantityTransactionCount | decimal(7,0) | |
| TotalSignOffCount | The total number of operator sign-offs on this RETAIL STORE for each REPORTING PERIOD. | QU_SGN_OFF_TOT | QuantityTransactionCount | decimal(7,0) | |
| TotalTenderOverAmount | The total number of operator sign-ons on this RETAIL STORE for each REPORTING PERIOD. | CP_TND_OVR_TOT | Money | decimal(16,5) | |
| TotalTenderUnderAmount | The total monetary amount of shortages by RETAIL STORE for each REPORTING PERIOD. | CP_TND_UND_TOT | Money | decimal(16,5) | |
| IntermediateTenderReconciliationCount | The total number of intermediate tender reconciliations performed on the RETAIL STORE for each REPORTING PERIOD. | QU_RCN_INTM_TND | QuantityTransactionCount | decimal(7,0) | |
| TotalSendCheckAmount | The total monetary amount of send checks by RETAIL STORE for each REPORTING PERIOD. | CP_CHK_SND_TOT | Money | decimal(16,5) | |
| TotalSendCheckCount | The total number of send checks by RETAIL STORE for each REPORTING PERIOD. | QU_CHK_SND_TOT | QuantityTransactionCount | decimal(7,0) | |
| SuspendedTotalAmount | The total monetary value of suspended transactions made by RETAIL STORE for each REPORTING PERIOD. | MO_SLS_SPN_TOT | Money | decimal(16,5) | |
| SuspendedTransactionCount | The total number of suspended transactions made by RETAIL STORE for each REPORTING PERIOD. | QU_TRN_SPN_TOT | Quantity | DECIMAL(9,3) | |
| ResumedTotalAmount | The total monetary value of suspended transactions resumed by RETAIL STORE for each REPORTING PERIOD. | MO_SLS_RSM_TOT | Money | decimal(16,5) | |
| ResumedTransactionCount | The total number of suspended transactions resumed by RETAIL STORE for each REPORTING PERIOD. | QU_TRN_RSM_TOT | QuantityTransactionCount | decimal(7,0) | |