## Entity DefinitionLogical Name : POSDepartmentHistory |
---|

Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
---|---|---|---|---|---|

RetailStoreID (FK)(PK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_STR_RTL | Identity | integer | RetailStore(PA_STR_RTL) |

ReportingPeriodID (FK)(PK) | The unique system assigned identifier for a particular ReportingPeriod. | ID_PRD_RP | Identity | integer | ReportingPeriod(CA_PRD_RP) |

POSDepartmentID (FK)(PK) | A unique system-assigned identifier for the POSDepartment | ID_DPT_PS | Identity | integer | POSDepartment(ID_DPT_PS) |

LineItemVoidTotalAmount | The total monetary amount of line item voids by POS department for each REPORTING PERIOD. | CP_VD_LN_ITM_TOT | Money | decimal(16,5) | |

TotalLineItemVoidCount | The total number of line item voids by POS department for each REPORTING PERIOD. | QU_LTM_VD_TOT | QuantityTransactionCount | decimal(7,0) | |

PostTransactionVoidTotalAmount | The total monetary amount of items cancelled by a post transaction void by POS department for each REPORTING PERIOD. | CP_VD_PST_TRN_TOT | Money | decimal(16,5) | |

TotalPostTransactionVoidCount | The total number of items cancelled by a post transaction void by POS department for each REPORTING PERIOD. | QU_VD_PST_TRN_TOT | QuantityTransactionCount | decimal(7,0) | |

TransactionVoidTotalAmount | The total monetary amount of items cancelled by transaction void by POS department for each REPORTING PERIOD. | CP_VD_TRN_TOT | Money | decimal(16,5) | |

TotalTranactionVoidCount | The total number of items cancelled by transaction void by POS department for each REPORTING PERIOD. | QU_VD_TRN_TOT | QuantityTransactionCount | decimal(7,0) | |

ReturnTotalAmount | The total monetary amount of returns by POS department for each REPORTING PERIOD. | CP_RTN_TOT | Money | decimal(16,5) | |

TotalReturnCount | The total number of returns by POS department for each REPORTING PERIOD. | QU_RTN_TOT | QuantityTransactionCount | decimal(7,0) | |

RefundTotalAmount | The total monetary amount of refunds by POS department for each REPORTING PERIOD. | CP_RFD_TOT | Money | decimal(16,5) | |

TotalRefundCount | The total number of refunds by POS department for each REPORTING PERIOD. | QU_RFD_TOT | QuantityTransactionCount | decimal(7,0) | |

EmployeeDiscountTotalAmount | The total monetary amount of employee discounts by POS department for each REPORTING PERIOD. | CP_DSC_EM_TOT | Money | decimal(16,5) | |

TotalEmployeeDiscountCount | The total number of employee discounted items by POS department for each REPORTING PERIOD. | QU_DSC_EM_TOT | QuantityTransactionCount | decimal(7,0) | |

MiscellaneousDiscountTotalAmount | The total monetary amount of miscellaneous discounts by POS department for each REPORTING PERIOD. | CP_DSC_MSC_TOT | Money | decimal(16,5) | |

TotalMiscellaneousDiscountCount | The total number of miscellaneous discounted items by POS department for each REPORTING PERIOD. | QU_DSC_MSC_TOT | QuantityTransactionCount | decimal(7,0) | |

StoreCouponTotalAmount | The total monetary amount of lines purchased in part or in full by store coupons by POS department for each REPORTING PERIOD. | CP_CPN_STR_TOT | Money | decimal(16,5) | |

TotalStoreCouponCount | he total number of lines purchased in part or in full by store coupons by POS department for each REPORTING PERIOD. | QU_CPN_STR_TOT | QuantityTransactionCount | decimal(7,0) | |

RedeemedContainerDepositTotalAmount | The total monetary amount of redeemed container deposits by POS department for each REPORTING PERIOD. | CP_DS_RDM_CNR_TOT | Money | decimal(16,5) | |

TotalRedeemedContainerDepositCount | he total number of redeemed container deposits by POS department for each REPORTING PERIOD. | QU_DS_RDM_CNR_TOT | QuantityTransactionCount | decimal(7,0) | |

MarkdownTotalAmount | The total monetary amount of markdowns by POS department for each REPORTING PERIOD. | CP_MKD_TOT | Money | decimal(16,5) | |

TotalMarkdownCount | The total number of markdowns by POS department for each REPORTING PERIOD. | QU_MKD_TOT | QuantityTransactionCount | decimal(7,0) | |

NetItemSalesTotalAmount | The total monetary amount of net item sales by POS department for each REPORTING PERIOD. | CP_SLS_NT_ITM_TOT | Money | decimal(16,5) | |

MiscellaneousFeeTotalAmount | The total monetary amount of miscellaneous fees by POS department for each REPORTING PERIOD. | CP_FE_MSC_TOT | Money | decimal(16,5) | |

TotalMiscellaneousFeeCount | The total number of miscellaneous fees by POS department for each REPORTING PERIOD. | QU_FE_MSC_TOT | QuantityTransactionCount | decimal(7,0) | |

ContainerDepositTotalAmount | The total monetary amount of container deposits by POS department for each REPORTING PERIOD. | CP_DS_CNR_TOT | Money | decimal(16,5) | |

TotalContainerDepositCount | The total number of container deposits by POS department for each REPORTING PERIOD. | QU_DS_CNR_TOT | QuantityTransactionCount | decimal(7,0) | |

TaxTotalAmount | The total monetary amount of tax item sales by POS department for each REPORTING PERIOD. | CP_TX_TOT | Money | decimal(16,5) | |

TaxExemptTotalAmount | The total monetary amount of tax exempt item sales by POS department for each REPORTING PERIOD. | CP_TX_EXM_TOT | Money | decimal(16,5) | |

TotalTaxExemptTransactionCount | The total number of tax exempt item sales by POS department for each REPORTING PERIOD. | QU_TRN_TX_EXM | QuantityTransactionCount | decimal(7,0) | |

TotalLineItemOverrideCount | The total number of line item overrides by POS department for each REPORTING PERIOD. | QU_LTM_OVRD_TOT | QuantityTransactionCount | decimal(7,0) | |

TotalWeighedLineItemCount | The total number of weighed item sales by POS department for each REPORTING PERIOD. | QU_ITM_LN_WT_TOT | QuantityTransactionCount | decimal(7,0) | |

TotalLineItemKeyedCount | The total number of keyed item sales by POS department for each REPORTING PERIOD. | QU_LTM_KY_TOT | QuantityTransactionCount | decimal(7,0) | |

TotalLineItemScannedCount | The total number of scanned item sales by POS department for each REPORTING PERIOD. | QU_LTM_SC_TOT | QuantityTransactionCount | decimal(7,0) | |

TotalLineItemKeyedPercentage | The number of items keyed as a percentage of total items sold by POS department for each REPORTING PERIOD. | PE_LTM_KY_TOT | Percent | decimal(7,4) | |

TotalLineItemScannedPercentage | The number of items scanned as a percentage of total items sold by POS department for each REPORTING PERIOD. | PE_LTM_SC_TOT | Percent | decimal(7,4) | |

TotalLineItemOpenDepartmentCount | The total number of items sold by a POS department for each REPORTING PERIOD. | QU_LTM_DPT_TOT | QuantityTransactionCount | decimal(7,0) | |

TotalLineItemOpenDepartmentPercentage | The number of items sold through a department key as a percentage of total items sold by POS department for each REPORTING PERIOD. | PE_LTM_DPT_TOT | Percent | decimal(7,4) | |

TotalSaleLineItemCount | The total number of item sales by POS department for each REPORTING PERIOD. | QU_LTM_SLS_TOT | QuantityTransactionCount | decimal(7,0) |

Parent Entity | Verb Phrase | Child Entity |
---|---|---|

ReportingPeriod | delineates | POSDepartmentHistory |

POSDepartment | is tracked via | POSDepartmentHistory |

RetailStore | delineates | POSDepartmentHistory |

Logical View |
---|

Logical 03000 - Reporting - Macro View |

Logical 03000 - Reporting - Macro View |

Logical 10300 - Enterprise - POS Department View |