Compliance - Core Entities
Version 2.1 RFC 2 Build 1
Copyright 2000, National Retail Federation.
|
Compliance - Core EntitiesVersion 2.1 RFC 2 Build 1 Copyright 2000, National Retail Federation. |
Entity |
Attribute |
|
|---|---|---|
| Name | Assessment | |
| AccessPassword CO_ACS_PSWD |
||
| AccessPassword PS_ACS_OPR |
· |
|
| OperatorID(PK)(FK) ID_OPR |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| AddressType CO_TYP_ADS |
||
| AddressTypeCode(PK) TY_ADS |
· |
|
| Description DE_ADS |
· |
|
| Name NM_ADS |
· |
|
| BusinessDay CA_DY_BSN |
||
| BusinessDayDate(PK) DC_DY_BSN |
· |
|
| FiscalDayNumber(FK) WD_DY_FSC |
· |
|
| FiscalWeekNumber(FK) FW_NMB |
· |
|
| FiscalYear(FK) FY |
· |
|
| CheckTenderLineItem TR_LTM_CHK_TND |
||
| BankID ID_BK_CHK |
· |
|
| CheckAccountNumber ID_ACNT_CHK |
· |
|
| CheckSequenceNumber AI_CHK |
· |
|
| AdjudicationCode ID_AJD_CHK |
· |
|
| WorkstationID(PK)(FK) ID_WS |
· |
|
| TransactionSequenceNumber(PK)(FK) AI_TRN |
· |
|
| RetailTransactionLineItemSequenceNumber(PK)(FK) AI_LN_ITM |
· |
|
| BusinessDayDate(PK)(FK) DC_DY_BSN |
· |
|
| PersonalIDRequiredTypeCode TY_ID_PRSL_RQ |
· |
|
| PersonalIDNumber ID_PRSL_AZN |
· |
|
| CustomerBirthDate DC_BRT_CHK |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| ControlTransaction TR_CTL |
||
| WorkstationID(PK)(FK) ID_WS |
· |
|
| TransactionSequenceNumber(PK)(FK) AI_TRN |
· |
|
| BusinessDayDate(PK)(FK) DC_DY_BSN |
· |
|
| TypeCode TY_TRN_CTL |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| CreditDebitCardTenderLineItem TR_LTM_CRDB_CRD_TN |
||
| WorkstationID(PK)(FK) ID_WS |
· |
|
| TransactionSequenceNumber(PK)(FK) AI_TRN |
· |
|
| RetailTransactionLineItemSequenceNumber(PK)(FK) AI_LN_ITM |
· |
|
| BusinessDayDate(PK)(FK) DC_DY_BSN |
· |
|
| MediaIssuerID ID_ISSR_TND_MD |
· |
|
| AccountNumber ID_ACNT_DB_CR_CRD |
· |
|
| PersonalIDRequiredTypeCode TY_ID_PRSL_RQ |
· |
|
| PersonalIDReferenceNumber ID_RFC_PRSL_ID |
· |
|
| AuthorizationMethodCode LU_MTH_AZN |
· |
|
| Track2CreditCardBitMap DE_TRCK_2_BT_MP |
· |
|
| AdjudicationCode LU_AJD_CR_DB |
· |
|
| CardNumberSwipedOrKeyedCode LU_NMB_CRD_SWP_KY |
· |
|
| CustomerSignatureImage CH_IM_TND_AZN_CT |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| DisbursementFundsReceiptReason CO_RCV_DSB_FND |
||
| Description DE_RCV_DSB |
· |
|
| DisbursementReceiptReasonCode(PK) RC_RCV_DSB |
· |
|
| RetailStoreID(FK) ID_STR_RT |
· |
|
| StoreFinancialLedgerAccountID(FK) ID_ACTN_LDG |
· |
|
| DisbursementTransaction TR_DSB |
||
| WorkstationID(PK)(FK) ID_WS |
· |
|
| TransactionSequenceNumber(PK)(FK) AI_TRN |
· |
|
| PettyCashReceiptRequiredFlag FL_RCV_PTY_CSH_RQ |
· |
|
| PettyCashPartyId ID_PRTY_PTY_CSH |
· |
|
| BusinessDayDate(PK)(FK) DC_DY_BSN |
· |
|
| FundDisbursementAmount MO_DSB_FND |
· |
|
| DisbursementReceiptReasonCode(FK) RC_RCV_DSB |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| Discount TR_DSC |
||
| DiscountTypeCode(PK) TY_DSC |
· |
|
| Name NM_DSC |
· |
|
| Description DE_DSC |
· |
|
| RetailStoreID(FK) ID_STR_RT |
· |
|
| StoreFinancialLedgerAccountID(FK) ID_ACTN_LDG |
· |
|
| DiscountLineItem TR_LTM_DSC |
||
| WorkstationID(PK)(FK) ID_WS |
· |
|
| TransactionSequenceNumber(PK)(FK) AI_TRN |
· |
|
| RetailTransactionLineItemSequenceNumber(PK)(FK) AI_LN_ITM |
· |
|
| BusinessDayDate(PK)(FK) DC_DY_BSN |
· |
|
| DiscountTypeCode(FK) TY_DSC |
· |
|
| Amount MO_DSC |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| Employee PA_EM |
||
| EmployeeID(PK) ID_EM |
· |
|
| CommissionPlanID(FK) ID_PLN_EM_CMN |
· |
|
| Name NM_EM |
· |
|
| SocialSecurityNumber UN_NMB_SCL_SCTY |
· |
|
| StatusCode SC_EM |
· |
|
| PartyID(FK) ID_PRTY |
· |
|
| PartyRoleTypeCode(FK) TY_RO_PRTY |
· |
|
| EmployeeCompensationTypeCode |
· |
|
| EmployeeAssignment ST_EM_ASGMT |
||
| EmployeeID(PK)(FK) ID_EM |
· |
|
| PositionID(PK)(FK) ID_PST |
· |
|
| StatusCode SC_EM_ASGMT |
· |
|
| EffectiveDate DC_EF |
· |
|
| ExpirationDate DC_EP |
· |
|
| EmployeeDiscountGroupPriceDerivationRuleEligibility CO_EL_EM_DSC_PRDV |
||
| EmployeeID(PK)(FK) ID_EM |
· |
|
| EmployeeDiscountGroupID(PK)(FK) ID_GP_EM_DSC |
· |
|
| EventID(FK) ID_EV |
· |
|
| EffectiveDateTimestamp TS_RU_EM_PRDV_EF |
· |
|
| ExpirationDateTimestamp TS_RU_EM_PRDV_EP |
· |
|
| EligibilityDescription DE_EL_EM_DSC_GP |
· |
|
| CostPlusFlag FL_CST_PLS_EM_DSC |
· |
|
| ApplyAfterAllMarkdownsFlag FL_MKD_APLY_AFT |
· |
|
| Description DE_EL_EM_PRDV_RU |
· |
|
| ConcurrenceDispositionCode LU_CNCRN_EM_PRDV |
· |
|
| RetailStoreID(FK) ID_STR_RT |
· |
|
| PriceDerivationRuleEligibilityID(PK)(FK) ID_EL_PRDV |
· |
|
| EmployeeDiscountLineItem TR_LTM_EM__DSC |
||
| RetailTransactionLineItemSequenceNumber(PK)(FK) AI_LN_ITM |
· |
|
| WorkstationID(PK)(FK) ID_WS |
· |
|
| TransactionSequenceNumber(PK)(FK) AI_TRN |
· |
|
| BusinessDayDate(PK)(FK) DC_DY_BSN |
· |
|
| Amount MO_ITM_LN_EM_DSC |
· |
|
| EmployeeID(FK) ID_EM |
· |
|
| EmployeeDiscountGroupID(FK) ID_GP_EM_DSC |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| Event CO_EV |
||
| EventID(PK) ID_EV |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| Scheduled Start(FK) DC_DY_BSN_SS |
· |
|
| TypeCode TY_EV |
· |
|
| Description DE_EV |
· |
|
| Name NM_EV |
· |
|
| StatusCode SC_EV |
· |
|
| StoreOrHomeOfficeControlCode CC_EV |
· |
|
| OwnerName NM_EV_OWNR |
· |
|
| PlanStartDateTimestamp TS_EV_PL_EF |
· |
|
| PlanEndDateTimestamp TS_EV_PL_EP |
· |
|
| ActualStartDateTimestamp TS_EV_ACT_EF |
· |
|
| ActualEndDateTimestamp TS_EV_ACT_EP |
· |
|
| ScheduledEnd(FK) DC_DY_BSN_SE |
· |
|
| ActualStart(FK) DC_DY_BSN_AS |
· |
|
| ActualEnd(FK) DC_DY_BSN_AE |
· |
|
| ExternalDepository LO_EXTDST |
||
| TenderRepositoryID(PK)(FK) ID_RPSTY_TND |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| Name NM_RPSTY_EXTRN |
· |
|
| Description DE_RPSTY_EXTRN |
· |
|
| ExternalDepositoryPartyID(FK) ID_EXTDST |
· |
|
| ExternalDepositorySettlementTransaction TR_STLM_EXTDST |
||
| WorkstationID(PK)(FK) ID_WS |
· |
|
| TransactionSequenceNumber(PK)(FK) AI_TRN |
· |
|
| BusinessDayDate(PK)(FK) DC_DY_BSN |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| ExternalDepositoryTender AS_TND_EXTDST |
||
| TenderRepositoryID(PK)(FK) ID_RPSTY_TND |
· |
|
| TenderTypeCode(PK)(FK) TY_TND |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| OpenBalanceTotalAmount MO_BLNC_OPN_TOT |
· |
|
| TenderDepositTotalAmount MO_DS_TND_TOT |
· |
|
| TotalTenderDepositCount QU_DS_TND_TOT |
· |
|
| TenderDepositDateTimestamp TS_DS_TND |
· |
|
| TenderReceiptTotalAmount MO_RCV_TND_TOT |
· |
|
| TotalTenderReceiptCount QU_RCV_TND_TOT |
· |
|
| UnderTenderDiscrepancyAmount MO_DSCP_TND_UND |
· |
|
| OverTenderDiscrepancyAmount MO_DSCP_TND_OVR |
· |
|
| Facility LO_FCLY |
||
| FacilityID(PK) ID_FC |
· |
|
| Name NM_FC |
· |
|
| FinancialAccountingTransaction TR_FN_ACNT |
||
| WorkstationID(PK)(FK) ID_WS |
· |
|
| TransactionSequenceNumber(PK)(FK) AI_TRN |
· |
|
| BusinessDayDate(PK)(FK) DC_DY_BSN |
· |
|
| TenderTypeCode(FK) TY_TND |
· |
|
| TypeCode TY_TRN_FN_ACNT |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| FinancialTransactionJournalEntry JL_JE_FN_ACNT |
||
| FinancialTransactionJournalEntryID(PK) ID_ENT_FN_TRN_JR |
· |
|
| FinancialTransactionJournalEntrySequenceNumber(PK) AI_ENR_FN_TRN_JR |
· |
|
| TransactionSequenceNumber(FK) AI_TRN |
· |
|
| InventoryControlDocumentID(FK) ID_ORD |
· |
|
| WorkstationID(FK) ID_WS |
· |
|
| StoreFinancialLedgerAccountID(FK) ID_ACTN_LDG |
· |
|
| DateTimestamp TS_ENR_FN_TRN_JR |
· |
|
| Amount MO_ENR_FN_TRN_JR |
· |
|
| DebitCreditCode LU_ENR_JR_DB_CR |
· |
|
| StatusCode SC_ENR_FN_TRN_JR |
· |
|
| BusinessDayDate(FK) DC_DY_BSN |
· |
|
| RetailStoreID(FK) ID_STR_RT |
· |
|
| FiscalDay CA_DY_FSC |
||
| FiscalYear(PK)(FK) FY |
· |
|
| FiscalDayNumber(PK) WD_DY_FSC |
· |
|
| FiscalWeekNumber(PK)(FK) FW_NMB |
· |
|
| CalendarDateTime TM_CLD |
· |
|
| FiscalMonth CA_MNTH_FSC |
||
| FiscalMonth(PK) FM_MNTH_FSC |
· |
|
| FiscalYear(PK)(FK) FY |
· |
|
| FiscalQuarterID(FK) ID_QRT_FSC |
· |
|
| FiscalQuarter CA_QRT_FSC |
||
| FiscalYear(PK)(FK) FY |
· |
|
| FiscalQuarterID(PK) ID_QRT_FSC |
· |
|
| FiscalQuarterNumberOfWeeksCount QU_NMB_OF_WK |
· |
|
| FiscalWeek CA_WK_FSC |
||
| SubseasonCode(FK) LU_SBSN |
· |
|
| SeasonCode(FK) LU_SN |
· |
|
| FiscalWeekNumber(PK) FW_NMB |
· |
|
| FiscalMonth(FK) FM_MNTH_FSC |
· |
|
| Description DE_WK_FSC |
· |
|
| FiscalYear(PK)(FK) FY |
· |
|
| FiscalYear CA_YR_FSC |
||
| FiscalYear(PK) FY |
· |
|
| CalendarYear YR_CLD |
· |
|
| BeginningDate DC_BGN_FSC_YR |
· |
|
| NumberOfMonthsCount QU_MNTH_NMB_OF |
· |
|
| FundsReceiptTransaction TR_RCV_FND |
||
| WorkstationID(PK)(FK) ID_WS |
· |
|
| TransactionSequenceNumber(PK)(FK) AI_TRN |
· |
|
| FundsReceiptPartyID ID_PRTY_FND_RCV |
· |
|
| BusinessDayDate(PK)(FK) DC_DY_BSN |
· |
|
| FundReceiptMonetaryAmount MO_RCV_FND |
· |
|
| DisbursementReceiptReasonCode(FK) RC_RCV_DSB |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| GroupResourceAccess CO_ACS_GP_RS |
||
| WorkGroupID(PK)(FK) ID_GP_WRK |
· |
|
| ResourceID(PK)(FK) ID_RS |
· |
|
| GroupReadAccessLevelFlag FL_ACS_GP_RD |
· |
|
| GroupWriteAccessLevelFlag FL_ACS_GP_WR |
· |
|
| InventoryControlDocument DO_CTL_INV |
||
| InventoryControlDocumentID(PK) ID_ORD |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| PackingSlipID(FK) ID_SP_PCKG |
· |
|
| InventoryControlDocumentType(FK) ID_CNY_ICD |
· |
|
| FacilityID(FK) ID_FC |
· |
|
| CompleteDateTimestamp TS_CTL_ICD |
· |
|
| DocumentTypeCode TY_ICD |
· |
|
| ToPartyID ID_PRTY_TO_ICD |
· |
|
| FromPartyID ID_PRTY_FM_ICD |
· |
|
| CreateDateTimestamp TS_CRT_ICD |
· |
|
| LastUpdateDate DC_UPDT_LS_ICD |
· |
|
| TermsAndConditionsCode LU_TC_ICD |
· |
|
| DeferredPaymentDate DC_PYM_DFR_ICD |
· |
|
| ExpectedDeliveryDate DC_DV_EXP_ICD |
· |
|
| ActualDeliveryDate DC_DV_ACT_ICD |
· |
|
| SupplierExpectedShipDate DC_SPR_EXP_SHP_ICD |
· |
|
| SupplierActualShipDate DC_SPR_ACT_SHP |
· |
|
| UnitDiscrepancyCount QU_DSCP_ICD |
· |
|
| OriginatorID ID_ORGR_ICD |
· |
|
| FreightChargeDispositionCode DP_CHG_FRGT_ICD |
· |
|
| ReceivedDifferenceCode LU_DF_RCV_ICD |
· |
|
| ContractReferenceNumber ID_CNRT |
· |
|
| SupplierID(FK) ID_SPR |
· |
|
| SerialFormID ID_SRZ_FRM |
· |
|
| InventoryTransactionJournalEntry JE_JL_TR_INV |
||
| InventoryTransactionJournalID(PK) ID_JR |
· |
|
| WorkstationID(FK) ID_WS |
· |
|
| TransactionSequenceNumber(FK) AI_TRN |
· |
|
| RetailTransactionLineItemSequenceNumber(FK) AI_LN_ITM |
· |
|
| BusinessDayDate(FK) DC_DY_BSN |
· |
|
| InventoryAdjustmentDocumentID(FK) ID_DCM_INV_ADJT |
· |
|
| InventoryAdjustmentLineNumber(FK) IC_INV_ADJT |
· |
|
| PhysicalItemCountLineNumber(FK) IC_CNT_PHY_ITM |
· |
|
| PhysicalCountDocumentID(FK) ID_DCM_PHY_CNT |
· |
|
| InventoryControlDocumentLineNumber(FK) IC_LN_ICD |
· |
|
| InventoryControlDocumentID(FK) ID_ORD |
· |
|
| LocationID(FK) ID_LCN |
· |
|
| AccountingDate DC_ENR_JR |
· |
|
| DateTimestamp TS_ENR_JR |
· |
|
| RetailUnitCount QU_UN_RT |
· |
|
| StockLedgerActionCode LU_ACTN_STK_LDG |
· |
|
| RetailUnitCurrentSellingPriceAmount RP_SLS_CRT |
· |
|
| RetailUnitMarkdownAmount MO_MKD_RT_UN |
· |
|
| RetailUnitAllowanceAmount MO_ALW_RT_UN |
· |
|
| RetailStoreID(FK) ID_STR_RT |
· |
|
| ItemID(FK) ID_ITM |
· |
|
| FuelingTransactionID(FK) ID_TRN_FUEL |
· |
|
| Item AS_ITM |
||
| ItemID(PK) ID_ITM |
· |
|
| DiscountFlag FL_ITM_DSC |
· |
|
| AuthorizedForSaleFlag FL_AZN_FR_SLS |
· |
|
| PriceLineID(FK) ID_LN_PRC |
· |
|
| SubseasonCode(FK) LU_SBSN |
· |
|
| SeasonCode(FK) LU_SN |
· |
|
| FiscalYear(FK) FY |
· |
|
| POSDepartmentID(FK) ID_DPT_POS |
· |
|
| BrandName(FK) NM_BRN |
· |
|
| UsageCode LU_ITM_USG |
· |
|
| Name NM_ITM |
· |
|
| Description DE_ITM |
· |
|
| TypeCode TY_ITM |
· |
|
| KitSetCode LU_KT_ST |
· |
|
| SubstituteIdentifiedFlag FL_ITM_SBST_IDN |
· |
|
| OrderCollectionCode LU_CLN_ORD |
· |
|
| TaxExemptCode LU_EXM_TX |
· |
|
| PriceAuditFlag FL_ADT_ITM_PRC |
· |
|
| MerchandiseStructureID(FK) ID_STRC_MR |
· |
|
| MerchandiseHierarchyLevelCode(FK) LU_HRC_MR_LV |
· |
|
| ItemCreation MA_CRT_ITM |
||
| EventID(PK)(FK) ID_EV |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| ItemDeletion MA_DLT_ITM |
||
| EventID(PK)(FK) ID_EV |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| ItemDescriptonUpdate MA_UPDT_ITM_DSCR |
||
| EventID(PK)(FK) ID_EV |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| ItemLabel AS_LB_ITM |
||
| LabelID(PK) ID_LB |
· |
|
| LocationID(PK)(FK) ID_LCN |
· |
|
| EventID(FK) ID_EV |
· |
|
| TypeCode TY_LB |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| ItemID(PK)(FK) ID_ITM |
· |
|
| ItemMaintenanceEvent CO_MNT_ITM |
||
| EventID(PK)(FK) ID_EV |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| FunctionCode LU_EV_ITM_MNT |
· |
|
| ItemPriceDerivationRule RU_PRDV_ITM |
||
| PriceDerivationRuleID(PK)(FK) ID_RU_PRDV |
· |
|
| ReductionPercent |
· |
|
| ReductionAmount |
· |
|
| NewPriceAmount |
· |
|
| ItemPriceDerivationRuleEligibility CO_EL_ITM_PRDV |
||
| ItemID(PK)(FK) ID_ITM |
· |
|
| EventID(FK) ID_EV |
· |
|
| EffectiveDateTimestamp TS_RU_PRC_DRVN_EF |
· |
|
| ExpirationDateTimestamp TS_RU_PRC_DRVN_EP |
· |
|
| AccountingDispositionCode DP_RU_PRC_DRVN |
· |
|
| ConcurrenceDispositionCode LU_RU_PRC_DRVN_CNCR |
· |
|
| RetailStoreID(FK) ID_STR_RT |
· |
|
| PriceDerivationRuleEligibilityID(PK)(FK) ID_EL_PRDV |
· |
|
| ThresholdTypeCode |
· |
|
| ThresholdQuantity |
· |
|
| ThresholdAmount |
· |
|
| IntervalQuantity |
· |
|
| LimitQuantity |
· |
|
| IntervalAmount |
· |
|
| LimitAmount |
· |
|
| ItemPriceMaintenance MA_PRC_ITM |
||
| EventID(PK)(FK) ID_EV |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| TypeCode TY_PRC_MNT |
· |
|
| ItemSellingPriceHistory LE_HST_ITM_SLS_PRC |
||
| ItemRetailPriceSequenceNumber(PK) AI_PRC_RT |
· |
|
| EventID(FK) ID_EV |
· |
|
| EffectiveDateTimestamp TS_PR_EF |
· |
|
| EndDateTimestamp TS_PR_END |
· |
|
| UnitRetailPriceAmount RP_UN_ITM_HST_SL |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| ItemID(PK)(FK) ID_ITM |
· |
|
| MaintenanceEvent CO_EV_MNT |
||
| EventID(PK)(FK) ID_EV |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| Merchant(FK) ID_EM |
· |
|
| CompetitorID(FK) ID_CMP |
· |
|
| Name NM_EV_MNT |
· |
|
| Description DE_EV_MNT |
· |
|
| ReasonCode RC_EV_MNT |
· |
|
| EffectiveDateTimestamp TS_EV_MNT_EF |
· |
|
| ExpirationDateTimestamp TS_EV_MNT_EP |
· |
|
| TypeCode TY_EV_MNT |
· |
|
| StatusCode SC_EV_MNT |
· |
|
| AppliedTimestamp TS_EV_MNT_APLY |
· |
|
| CreateDateTimestamp TS_EV_MNT_CRT |
· |
|
| OriginTypeCode TY_EV_MNT_ORG |
· |
|
| MerchandiseHierarchyLevel ST_LV_MR_HRC |
||
| MerchandiseHierarchyLevelCode(PK) LU_HRC_MR_LV |
· |
|
| Description DE_HRC_MR_LV |
· |
|
| Operator PA_OPR |
||
| OperatorID(PK) ID_OPR |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| EmployeeID(FK) ID_EM |
· |
|
| AccessPassword PW_ACS_OPR |
· |
|
| OperatorGroup CO_GP_OPR |
||
| WorkGroupID(PK)(FK) ID_GP_WRK |
· |
|
| OperatorID(PK)(FK) ID_OPR |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| OperatorResourceAccess CO_ACS_OPR_RS |
||
| ResourceID(PK)(FK) ID_RS |
· |
|
| ReadAccessLevelCode PS_ACS_RD |
· |
|
| WriteAccessLevelCode PR_ACS_WR |
· |
|
| OperatorID(PK)(FK) ID_OPR |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| PackingSlip DO_SP_PCKG |
||
| SupplierID(PK)(FK) ID_SPR |
· |
|
| PackingSlipID(PK) ID_SP_PCKG |
· |
|
| SupplierOrderFulfilledDate DC_ORD_FLF |
· |
|
| SupplierOrderShipmentOutboundDate DC_SHP_OTB |
· |
|
| PeriodCloseTransaction TR_CL_PRD |
||
| WorkstationID(PK)(FK) ID_WS |
· |
|
| TransactionSequenceNumber(PK)(FK) AI_TRN |
· |
|
| BusinessDayDate(PK)(FK) DC_DY_BSN |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| PermanentPriceChange TR_CHN_PRN_PRC |
||
| EventID(PK)(FK) ID_EV |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| SaleUnitAmount MO_CHN_PRN_UN_PRC |
· |
|
| SaleUnitAmountTypeCode TY_CHN_PRN_UN_PRC |
· |
|
| PermanentPriceChangeItem MA_ITM_PRN_PRC_ITM |
||
| EventID(PK)(FK) ID_EV |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| ItemID(PK)(FK) ID_ITM |
· |
|
| PhysicalCountDocument DO_CNT_PHY |
||
| PhysicalCountDocumentID(PK) ID_DCM_PHY_CNT |
· |
|
| RetailStoreID(FK) ID_STR_RT |
· |
|
| EventID(FK) ID_EV |
· |
|
| PhysicalCountLineItem TR_LTM_PHY_CNT |
||
| PhysicalItemCountLineNumber(PK) IC_CNT_PHY_ITM |
· |
|
| PhysicalCountDocumentID(PK)(FK) ID_DCM_PHY_CNT |
· |
|
| PhysicalInventoryEvent CO_EV_PHY_INV |
||
| EventID(PK)(FK) ID_EV |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| POSDepartment ID_DPT_PS |
||
| Parent(FK) ID_DPT_POS_PRNT |
· |
|
| POSDepartmentID(PK) ID_DPT_POS |
· |
|
| Name NM_DPT_POS |
· |
|
| POSIdentity ID_IDN_PS |
||
| POSItemID(PK) ID_ITM_POS |
· |
|
| FrequentShopperPointsEligibleFlag FL_PNT_FQ_SHPR_EL |
· |
|
| CustomerAffiliationDiscountAllowedFlag FL_DSC_AF_DSC_ALW |
· |
|
| MarketBasketDiscountAllowedFlag FL_DSC_MRK_BSK_ALW |
· |
|
| CustomerAccountDiscountAllowedFlag FL_DSC_CT_ACNT_ALW |
· |
|
| EmployeeDiscountAllowedFlag FL_DSC_EM_ALW |
· |
|
| AllowCouponMultiplyFlag FL_CPN_ALW_MULTY |
· |
|
| AllowFoodStampFlag FL_FD_STP_ALW |
· |
|
| ElectronicCouponFlag FL_CPN_ELNTC |
· |
|
| CouponRestrictedFlag FL_CPN_RST |
· |
|
| PriceEntryRequiredFlag FL_ENTR_PRC_RQ |
· |
|
| WeightEntryRequiredFlag FL_QR_ENR_WT |
· |
|
| QuantityKeyProhibitFlag FL_KY_PRH_QTY |
· |
|
| ProhibitReturnFlag FL_RTN_PRH |
· |
|
| GiveawayFlag FL_ITM_GWY |
· |
|
| WICFlag FL_ITM_WIC |
· |
|
| VisualVerifyPriceFlag FL_PRC_VS_VR |
· |
|
| ProhibitRepeatKeyFlag FL_KY_PRH_RPT |
· |
|
| FrequentShopperPointsCount QU_PNT_FQ_SHPR |
· |
|
| ManufacturerID(FK) ID_MF |
· |
|
| ManufacturerFamilyCode(FK) FC_FMY_MF |
· |
|
| UPC(FK) ID_ITM_MF_UPC |
· |
|
| ReturnAgentID(FK) ID_AGNT_RTN |
· |
|
| Description DE_ITM_POS |
· |
|
| CouponValueCode LU_VT_PS_CPN |
· |
|
| CouponEndOfOfferDate DT_END_PS_CPN_OFR |
· |
|
| MinimumSaleUnitCount QU_UN_BLK_MNM |
· |
|
| MaximumSaleUnitCount QU_UN_BLK_MXM |
· |
|
| ItemTenderRestrictionGroupCode(FK) LU_GP_TND_RST |
· |
|
| CurrentSaleUnitPOSRetailPriceAmount RP_SLS_POS_CRT |
· |
|
| RetailStoreID(FK) ID_STR_RT |
· |
|
| ItemID(FK) ID_ITM |
· |
|
| POSItemIDQualifier(PK) |
· |
|
| POSLockTransaction TR_LCK_PS |
||
| WorkstationID(PK)(FK) ID_WS |
· |
|
| TransactionSequenceNumber(PK)(FK) AI_TRN |
· |
|
| BusinessDayDate(PK)(FK) DC_DY_BSN |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| POSNoSaleTransaction TR_SLS_PS_NO |
||
| WorkstationID(PK)(FK) ID_WS |
· |
|
| TransactionSequenceNumber(PK)(FK) AI_TRN |
· |
|
| BusinessDayDate(PK)(FK) DC_DY_BSN |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| PostVoidTransaction TR_VD_PST |
||
| WorkstationID(PK)(FK) ID_WS |
· |
|
| TransactionSequenceNumber(PK)(FK) AI_TRN |
· |
|
| BusinessDayDate(PK)(FK) DC_DY_BSN |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| VoidedRetailStoreID(FK) |
· |
|
| VoidedTransactionSequenceNumber(FK) AI_TRN_VD |
· |
|
| VoidedWorkstationID(FK) ID_WS_VD |
· |
|
| VoidedBusinessDayDate(FK) DC_DY_BSN_VD |
· |
|
| POSUnlockTransaction TR_UNLK_PS |
||
| WorkstationID(PK)(FK) ID_WS |
· |
|
| TransactionSequenceNumber(PK)(FK) AI_TRN |
· |
|
| BusinessDayDate(PK)(FK) DC_DY_BSN |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| PriceDerivationRule RU_PRDV |
||
| PriceDerivationRuleID(PK) ID_RU_PRDV |
· |
|
| EventID(FK) ID_EV |
· |
|
| Name NM_RU_PRDV |
· |
|
| Description DE_RU_PRDV |
· |
|
| EffectiveDate DC_RU_PRDV_EF |
· |
|
| ExpirationDate DC_RU_PRDV_EP |
· |
|
| TransactionControlBreakCode LU_CBRK_PRDV_TRN |
· |
|
| StatusCode SC_RU_PRDV |
· |
|
| TypeCode TY_RU_PRDV |
· |
|
| RetailStoreID(FK) ID_STR_RT |
· |
|
| PriceDerivationRuleMaintenance MA_RU_PRDV |
||
| EventID(PK)(FK) ID_EV |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| MaintenanceFunctionCode LU_RU_PRC_DRVN_MNT |
· |
|
| ReportingPeriod CA_PRD_RP |
||
| ReportingPeriodTypeCode(PK) TY_PR_PRD |
· |
|
| ReportingPeriodID(PK) ID_PR_PRD |
· |
|
| SubseasonCode(FK) LU_SBSN |
· |
|
| FiscalDayNumber(FK) WD_DY_FSC |
· |
|
| FiscalMonth(FK) FM_MNTH_FSC |
· |
|
| FiscalQuarterID(FK) ID_QRT_FSC |
· |
|
| Name NM_PRD_FSC |
· |
|
| SeasonCode(FK) LU_SN |
· |
|
| FiscalWeekNumber(FK) FW_NMB |
· |
|
| FiscalYear(FK) FY |
· |
|
| RetailPriceModifier CO_MDFR_RTL_PRC |
||
| WorkstationID(PK)(FK) ID_WS |
· |
|
| TransactionSequenceNumber(PK)(FK) AI_TRN |
· |
|
| RetailTransactionLineItemSequenceNumber(PK)(FK) AI_LN_ITM |
· |
|
| BusinessDayDate(PK)(FK) DC_DY_BSN |
· |
|
| ReasonCode RC_MDFR_RT_PRC |
· |
|
| Percent PE_MDFR_RT_PRC |
· |
|
| Amount MO_MDFR_RT_PRC |
· |
|
| StockLedgerAccountingDispositionCode DP_LDG_STK_MDFR |
· |
|
| DerivationRuleID ID_RU_MDFR |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| RetailStore PA_STR_RTL |
||
| RetailStoreID(PK) ID_STR_RT |
· |
|
| OpenDate DC_OPN_RT_STR |
· |
|
| ClosingDate DC_CL_RT_STR |
· |
|
| SquareFeetCount QY_FT_SQ_RT_STR |
· |
|
| SellingAreaSquareFeetCount QY_AR_SL_SQ_FT |
· |
|
| PriceZoneCode LU_ZN_PRC_RT_STR |
· |
|
| PartyID(FK) ID_PRTY |
· |
|
| PartyRoleTypeCode(FK) TY_RO_PRTY |
· |
|
| RetailStoreItem AS_ITM_RTL_STR |
||
| SellingStatusCode SC_ITM_SLS |
· |
|
| SellingStatusCodeEffectiveDate DC_ITM_SLS |
· |
|
| UpdateStockOnHandFlag FL_STK_UPDT_ON_HD |
· |
|
| StatusCode SC_ITM |
· |
|
| PermanentSaleUnitRetailPriceAmount RP_PR_SLS |
· |
|
| PermanentSaleUnitRetailPriceOriginalMarkdownFlag FL_MKD_ORGL_PRC_PR |
· |
|
| PermanentRetailPricePermanentMarkdownCount QU_MKD_PR_PRC_PR |
· |
|
| PermanentRetailPriceEffectiveDate DC_PRC_EF_PRN_RT |
· |
|
| CurrentSaleUnitRetailPriceAmount RP_SLS_CRT |
· |
|
| CurrentSaleUnitRetailPriceTypeCode TY_PRC_RT |
· |
|
| CurrentSaleUnitRetailPricePointAllowedFlag FL_PRC_RT_PNT_ALW |
· |
|
| CurrentSaleUnitRetailPriceEffectiveDate DC_PRC_SLS_EF_CRT |
· |
|
| CurrentSaleUnitRetailPriceExpirationDate DC_PRC_SLS_EP_CRT |
· |
|
| ManufacturerSaleUnitRecommendedRetailPriceAmount RP_PRC_MF_REC_RT |
· |
|
| ManufacturerSaleUnitRecommendedRetailPriceEffectiveDate DC_PRC_MF_REC_RT |
· |
|
| CompareAtSaleUnitRetailPriceAmount RP_PRC_CMPR_AT_SLS |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| ItemID(PK)(FK) ID_ITM |
· |
|
| TaxGroupID(FK) ID_GP_TX |
· |
|
| RetailTransaction TR_RTL |
||
| WorkstationID(PK)(FK) ID_WS |
· |
|
| TransactionSequenceNumber(PK)(FK) AI_TRN |
· |
|
| BusinessDayDate(PK)(FK) DC_DY_BSN |
· |
|
| RingElapsedTime IN_RNG_ELPSD |
· |
|
| TenderElapsedTime IN_TND_ELPSD |
· |
|
| IdleElapsedTime IN_ELPSD_IDL |
· |
|
| LockElapsedTime IN_LCK_ELPSD |
· |
|
| LineItemsScannedCount QU_ITM_LN_SC |
· |
|
| LineItemsScannedPercent PE_ITM_LN_SC |
· |
|
| LineItemsKeyedCount QU_ITM_LN_KY |
· |
|
| LineItemsKeyedPercent PE_ITM_LN_KY |
· |
|
| KeyDepartmentCount QU_DPT_KY |
· |
|
| KeyDepartmentPercent PE_DPT_KY |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| CustomerID(FK) ID_CT |
· |
|
| RetailTransactionLineItem TR_LTM_RTL_TRN |
||
| VoidedLine(FK) AI_LN_ITM_VD |
· |
|
| RetailTransactionLineItemSequenceNumber(PK) AI_LN_ITM |
· |
|
| TypeCode TY_LN_ITM |
· |
|
| BeginDateTimestamp TS_LN_ITM_BGN |
· |
|
| EndDateTimestamp TS_LN_ITM_END |
· |
|
| VoidFlag FL_VD_LN_ITM |
· |
|
| BusinessDayDate(FK) DC_DY_BSN |
· |
|
| RetailStoreID(FK) ID_STR_RT |
· |
|
| WorkstationID(FK) ID_WS |
· |
|
| TransactionSequenceNumber(FK) AI_TRN |
· |
|
| SafeTransferTransaction TR_TSF_SF |
||
| WorkstationID(PK)(FK) ID_WS |
· |
|
| TransactionSequenceNumber(PK)(FK) AI_TRN |
· |
|
| BusinessDayDate(PK)(FK) DC_DY_BSN |
· |
|
| TenderRepositoryID(FK) ID_RPSTY_TND |
· |
|
| TenderTypeCode(FK) TY_TND |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| Session CO_SSN |
||
| WorkstationID(PK)(FK) ID_WS |
· |
|
| SessionStartDateTimestamp(PK) TS_TM_SRT |
· |
|
| EndDateTimestamp TS_END |
· |
|
| OperatorID(PK)(FK) ID_OPR |
· |
|
| GrossPositiveTotalAmount CP_SLS_GS_PSTV_TOT |
· |
|
| GrossNegativeTotalAmount CP_SLS_GS_NG_TOT |
· |
|
| TotalTransactionCount QU_TRN_TOT |
· |
|
| LineItemVoidTotalAmount CP_VD_LN_ITM_TOT |
· |
|
| TotalLineItemVoidCount QU_VD_LN_ITM_TOT |
· |
|
| PostTransactionVoidTotalAmount CP_VD_PST_TRN_TOT |
· |
|
| TotalPostTransactionVoidCount QU_VD_PST_TRN_TOT |
· |
|
| TransactionVoidTotalAmount CP_VD_TRN_TOT |
· |
|
| TotalTransactionVoidCount QU_VD_TRN_TOT |
· |
|
| TenderLoanTotalAmount CP_LON_TND_TOT |
· |
|
| TotalTenderLoanCount QU_LON_TND_TOT |
· |
|
| TenderPickupTotalAmount CP_PKP_TND_TOT |
· |
|
| TotalTenderPickupCount QU_PKP_TND_TOT |
· |
|
| ReturnTotalAmount CP_RTN_TOT |
· |
|
| TotalReturnCount QU_RTN_TOT |
· |
|
| RefundTotalAmount CP_RFD_TOT |
· |
|
| TotalRefundCount QU_RFD_TOT |
· |
|
| EmployeeDiscountTotalAmount CP_DS_EM_TOT |
· |
|
| TotalEmployeeDiscountCount QU_DSC_EM_TOT |
· |
|
| MiscellaneousDiscountTotalAmount CP_DS_MSC_TOT |
· |
|
| TotalMiscellaneousDiscountCount QU_DSC_MSC_TOT |
· |
|
| StoreCouponTotalAmount CP_CPN_STR_TOT |
· |
|
| TotalStoreCouponCount QU_CPN_STR_TOT |
· |
|
| RedeemedContainerDepositTotalAmount CP_DS_RDM_CNR |
· |
|
| TotalRedeemedContainerDepositCount QU_DS_RDM_CNR |
· |
|
| MarkdownTotalAmount CP_MKD_TOT |
· |
|
| TotalMarkdownCount QU_MKD_TOT |
· |
|
| NetSalesTotalAmount CP_SLS_NT_TOT |
· |
|
| MiscellaneousFeeTotalAmount CP_FE_MSC_TOT |
· |
|
| TotalMiscellaneousFeeCount QU_FE_MSC_TOT |
· |
|
| ContainerDepositTotalAmount CP_DS_CNR_TOT |
· |
|
| TotalContainerDepositCount QU_DS_CNR_TOT |
· |
|
| PaymentsCollectedTotalAmount CP_PYM_CLT_TOT |
· |
|
| TotalPaymentsCollectedCount QU_PYM_CLT_TOT |
· |
|
| LayawayPaymentsCollectedTotalAmount CP_PYM_LY_CLT_TOT |
· |
|
| TotalLayawayPaymentsCollectedCount QU_PYM_LY_CLT_TOT |
· |
|
| PettyCashDisbursementTotalAmount CP_DSB_PTY_CSH_TOT |
· |
|
| TotalPettyCashDisbursementLineItemCount QU_DSB_PTY_CSH_ITM |
· |
|
| GrossSalesExTaxTotalAmount CP_SLS_EX_TX_GS |
· |
|
| TaxTotalAmount CP_TX_TOT |
· |
|
| TaxExemptTotalAmount CP_TX_EXM_TOT |
· |
|
| TotalTaxExemptTransactionCount QU_TRN_TX_EXM_TOT |
· |
|
| TotalLineItemOverrideCount QU_OVRD_LN_ITM_TOT |
· |
|
| TotalWeighedLineItemCount QU_LN_ITM_WT_TOT |
· |
|
| TotalLineItemKeyedCount QU_ITM_LN_KY_TOT |
· |
|
| TotalLineItemScannedCount QU_LN_ITM_SC_TOT |
· |
|
| TotalLineItemKeyedPercentage PE_ITM_LN_KY_TOT |
· |
|
| TotalLineItemScannedPercentage PE_LN_ITM_SC_TOT |
· |
|
| TotalLineItemOpenDepartmentCount QU_DPT_OPN_LN_ITM |
· |
|
| TotalLineItemOpenDepartmentPercentage PE_DPT_OPN_LN_ITM |
· |
|
| TotalNoSaleTransactionCount QU_TRN_NO_SLS_TOT |
· |
|
| TotalRingTime IN_RNG_TOT |
· |
|
| TotalIdleTime IN_IDL_TOT |
· |
|
| TotalLockTime IN_LCK_TOT |
· |
|
| TotalSaleLineItemCount QU_ITM_LN_SLS_TOT |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| SessionTender LE_TND_SSN |
||
| Session(PK)(FK) TY_TND |
· |
|
| WorkstationID(PK)(FK) ID_WS |
· |
|
| SessionStartDateTimestamp(PK)(FK) TS_TM_SRT |
· |
|
| OperatorID(PK)(FK) ID_OPR |
· |
|
| TotalTenderMediaOverCount QU_MD_OVR_TND_TOT |
· |
|
| TotalTenderMediaShortCount QU_MD_SHRT_TND_TOT |
· |
|
| TotalBeginningTenderMediaUnitCount QU_MD_TND_BGN_TOT |
· |
|
| TotalTenderLoanMediaUnitCount QU_MD_TND_LON_TOT |
· |
|
| TenderLoanMediaTotalAmount CP_MD_TND_LON_TOT |
· |
|
| TotalTenderPickupMediaUnitCount QU_MD_TND_PKP_TOT |
· |
|
| PickupMediaTotalAmount CP_MD_TND_PKP_TOT |
· |
|
| DepositTotalAmount CP_DS_TND_TOT |
· |
|
| TotalTenderDepositMediaUnitCount QU_MD_TND_DS_TOT |
· |
|
| OverTotalAmount CP_TND_OVR_TOT |
· |
|
| ShortTotalAmount CP_TND_SHRT_TOT |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| SignOffTransaction TR_SGN_OFF |
||
| WorkstationID(PK)(FK) ID_WS |
· |
|
| TransactionSequenceNumber(PK)(FK) AI_TRN |
· |
|
| BusinessDayDate(PK)(FK) DC_DY_BSN |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| SignOnTransaction TR_SGN_ON |
||
| WorkstationID(PK)(FK) ID_WS |
· |
|
| TransactionSequenceNumber(PK)(FK) AI_TRN |
· |
|
| BusinessDayDate(PK)(FK) DC_DY_BSN |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| StockItem AS_ITM_STK |
||
| ItemID(PK)(FK) ID_ITM |
· |
|
| BulkToSellingUnitWasteTypeCode TY_WST_BLK_SLS |
· |
|
| BulkToSellingUnitWasteFactorPercent PE_WST_BLK_SLS |
· |
|
| Primary(FK) ID_SPR |
· |
|
| RetailSelling(FK) LU_UOM |
· |
|
| StockItemTypeCode TY_ITM_STK |
· |
|
| SaleUnitPrimaryMeasurementSystemCode LU_SYS_PRMRY_MS |
· |
|
| SaleUnitOfMeasureCode LU_UOM_SLS |
· |
|
| SaleWeightOrUnitCountCode LU_CNT_SLS_WT_UN |
· |
|
| CustomerPickupTypeCode TY_PKP_CT_STK_ITM |
· |
|
| UnitPriceFactor FA_PRC_UN_STK_ITM |
· |
|
| ShelfLifePeriodDayCount DI_PRD_SH_LF |
· |
|
| AvailableForSaleDate DC_AVLB_FR_SLS |
· |
|
| EnvironmentTypeCode TY_ENV_STK_ITM |
· |
|
| SecurityRequiredTypeCode TY_SCTY_RQ |
· |
|
| HazardousMaterialTypeCode TY_MTR_HZ_STK_ITM |
· |
|
| InventoryAccountingMethodCode LU_MTH_INV_ACCTN |
· |
|
| SellUnitLastReceivedBaseCostAmount CP_UN_SL_LS_RCV_BS |
· |
|
| SellUnitLastReceivedNetCostAmount CP_CST_NT_LS_RCV |
· |
|
| SellUnitLandedCostAmount CP_UN_SL_LND |
· |
|
| SellUnitLastReceivedCostsEstablishedDate DC_CST_EST_LS_RCV |
· |
|
| LastReceived(FK) ID_ORD |
· |
|
| InventoryControlDocumentLineNumber(FK) IC_LN_ICD |
· |
|
| FabricDescription DE_FBRC |
· |
|
| SilhouetteDescription DE_SLH |
· |
|
| ShelfItemConsumerPackageHeight QL_HT_PCKG_CNS |
· |
|
| ShelfItemConsumerPackageWidth QL_UOM_WD_PCKG_CNS |
· |
|
| ShelfItemConsumerPackageDepth QL_PCKG_CNS |
· |
|
| ShelfItemConsumerPackageDimensionUnitOfMeasureCode LU_UOM_PCKG_CNS_DMN |
· |
|
| ShelfItemConsumerPackageWeight QW_WT_PCKG_CNS |
· |
|
| ShelfItemConsumerPackageWeightUnitOfMeasureCode LU_UOM_WT_PCKG_CNS |
· |
|
| ShelfItemConsumerPackageSizeUnitOfMeasureCode LU_UOM_SZ_PCKG_CNS |
· |
|
| ShelfItemDSDAuthorizedFlag FL_DSD_AZN |
· |
|
| ShelfItemShelfLifeDayCount DI_LF_SH |
· |
|
| ShelfItemBrokerID ID_BRKR |
· |
|
| ShelfItemStaplePerishableTypeCode TY_ITM_STPL_PRSH |
· |
|
| ShelfItemAisleLocation NM_LCN_ASL |
· |
|
| ShelfItemShelfLocation NM_LCN_SH |
· |
|
| ShelfItemFacingsCount QU_FCG |
· |
|
| PackItemWeightCount QW_ITM_PCK |
· |
|
| PackItemCubeCount QU_CB_PCK_ITM |
· |
|
| PackItemUnitNumberCount QU_UN_PCK_ITM |
· |
|
| SerializedItemModelNumber NM_NMB_SRZ_ITM_MDL |
· |
|
| SerializedItemModelYear CY_MDL_SRZ_ITM |
· |
|
| SerializedItemManufacturerColorDescription DE_CLR_MF_SRZ_ITM |
· |
|
| SerializedItemManufacturerSizeDescription DE_SZ_MF_SRZ_ITM |
· |
|
| SerializedItemManufacturerWarrantyDescriptionCode LU_WRTY_MF_SRZ_ITM |
· |
|
| SerializedItemStoreWarrantyDescriptionCode LU_WRTY_STR_SRZ |
· |
|
| SerializedItemValidationFlag FL_VLD_SRZ_ITM |
· |
|
| ShelfItemsHeldCapacityCount QU_CPC_HLD |
· |
|
| DisplayUnitTypeCode TY_UN_DPLY |
· |
|
| DisplayUnitSetUpDate DC_UN_DPLY_ST_UP |
· |
|
| DisplayUnitTakeDownDate DC_UN_DPLY_TK_DWN |
· |
|
| DisplayUnitDispositionCode DP_UN_DPLY |
· |
|
| ShrinkFlag FL_SHRK_SH_ITM |
· |
|
| SwellFlag FL_SWL_SH_ITM |
· |
|
| ShelfItemUnitPricingRequiredFlag FL_RQ_UN_PRC |
· |
|
| ShelfItemSideLocation NM_LCN_SID |
· |
|
| RetailStoreID(FK) ID_STR_RT |
· |
|
| StoreSafe AS_SF_STR |
||
| TenderRepositoryID(PK)(FK) ID_RPSTY_TND |
· |
|
| Description DE_SF_STR |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| StoreSafeSettlementTransaction TR_STLM_STR_SF |
||
| WorkstationID(PK)(FK) ID_WS |
· |
|
| TransactionSequenceNumber(PK)(FK) AI_TRN |
· |
|
| BusinessDayDate(PK)(FK) DC_DY_BSN |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| StoreSafeTender LE_TND_STR_SF |
||
| LoanTotalAmount MO_LON_SF_TND_TOT |
· |
|
| TotalTenderLoanCount QU_LON_TND_TOT |
· |
|
| PickupTotalAmount MO_PKP_SF_TND_TOT |
· |
|
| TotalTenderPickupCount QU_PKP_TND_TOT |
· |
|
| OverTenderDiscrepancyTotalAmount MO_DSCP_SF_TND_OVR |
· |
|
| UnderTenderDiscrepancyTotalAmount MO_DSCP_TNDUND_TOT |
· |
|
| PettyCashDisbursementTransactionTotalAmount MO_DSCB_SF_PTY_CSH |
· |
|
| TotalPettyCashDisbursementTransactionCount QU_TRN_DSB_PTY_CSH |
· |
|
| DepositTotalAmount MO_DS_SF_TND_TOT |
· |
|
| ReceiptTotalAmount MO_RCV_SF_TND_TOT |
· |
|
| OpenBalanceTotalAmount MO_BLNC_OPN_TOT |
· |
|
| TenderRepositoryID(PK)(FK) ID_RPSTY_TND |
· |
|
| TenderTypeCode(PK)(FK) TY_TND |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| TaxGroupRule ST_TX_GP_TX_ATHY |
||
| TaxGroupID(PK)(FK) ID_GP_TX |
· |
|
| Name NM_RU_TX |
· |
|
| Description DE_RU_TX |
· |
|
| TaxAuthorityID(FK) ID_ATHY_TX |
· |
|
| RetailStoreID(FK) ID_STR_RT |
· |
|
| StoreFinancialLedgerAccountID(FK) ID_ACTN_LDG |
· |
|
| TaxRuleSequenceNumber(PK) |
· |
|
| CompoundSequenceNumber |
· |
|
| CompoundFlag |
· |
|
| TaxOnGrossAmountFlag |
· |
|
| TaxedAtTransactionLevelFlag |
· |
|
| TaxLineItem TR_LTM_TX |
||
| WorkstationID(PK)(FK) ID_WS |
· |
|
| TransactionSequenceNumber(PK)(FK) AI_TRN |
· |
|
| RetailTransactionLineItemSequenceNumber(PK)(FK) AI_LN_ITM |
· |
|
| TaxAmount MO_TX |
· |
|
| BusinessDayDate(PK)(FK) DC_DY_BSN |
· |
|
| TaxGroupID(FK) ID_GP_TX |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| TaxRuleSequenceNumber(FK) |
· |
|
| TaxableAmount |
· |
|
| TemporaryPriceChange TR_CHN_TMP_PRC |
||
| EventID(PK)(FK) ID_EV |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| SaleUnitAmount MO_UN_TMP_PRC_CHN |
· |
|
| SaleUnitAmountTypeCode TY_UN_TMP_PRC_CHN |
· |
|
| TemporaryPriceChangeItem MA_ITM_TMP_PRC_CHN |
||
| EventID(PK)(FK) ID_EV |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| ItemID(PK)(FK) ID_ITM |
· |
|
| Tender AS_TND |
||
| TenderTypeCode(PK) TY_TND |
· |
|
| RetailStoreID(FK) ID_STR_RT |
· |
|
| StoreFinancialLedgerAccountID(FK) ID_ACTN_LDG |
· |
|
| ClassCode(FK) LU_CLS_TND |
· |
|
| LocalCurrency(FK) ID_CNY_ICD |
· |
|
| Description DE_TND |
· |
|
| SerialIdentificationNumberRequiredFlag FL_NUB_SRZ_IDN_RQ |
· |
|
| AuthorizationRequiredFlag FL_AZN_RQ |
· |
|
| AuthorizationMethodCode LU_MTH_AZN |
· |
|
| AuthorizationExpirationDateRequiredFlag FL_DT_AZN_EP_RQ |
· |
|
| AuthorizationMaximumWaitAllowedSecondsCount IN_WIT_AZN_MXM_ALW |
· |
|
| CustomerIdentificationRequiredFlag FL_IDTN_RQ_CT |
· |
|
| PersonalIdentificationNumberRequiredFlag FL_ID_PRSL_RQ |
· |
|
| CustomerSignatureRequiredFlag FL_SGNTR_CT_RQ |
· |
|
| AccountIdentificationRequiredFlag FL_ACNT_ID_RQ |
· |
|
| OnLineTenderFloorApprovalAmount MO_APVL_TNDFLR_ON |
· |
|
| OnLineTenderCeilingApprovalAmount MO_APVL_TNDCE_ON |
· |
|
| OffLineTenderFloorApprovalAmount MO_APVL_TNDFLR_OFF |
· |
|
| OffLineTenderCeilingApprovalAmount MO_APVL_TNDCE_OFF |
· |
|
| MinimumAcceptAmount LL_ACPT_TND |
· |
|
| MaximumAcceptAmount LU_ACPT_TND |
· |
|
| OverrideTriggerMaximumAmount UL_OVRD_TRGR |
· |
|
| LoanPermissabilityFlag FL_PRMS_TND_LON |
· |
|
| ItemRestrictionsApplyFlag FL_RST_APLY |
· |
|
| LocalCurrencyAvailabilityFlag FL_AVLB_LCL_CNY |
· |
|
| RealtimeBalanceUpdateFlag FL_UPDT_RLTM_BLNC |
· |
|
| EndorsementRequiredFlag FL_ENDSM_RQ |
· |
|
| OpenCashDrawerRequiredFlag FL_DRW_OPN_CSH_RQ |
· |
|
| ChangeThresholdAmount MO_TH_TND_CHN |
· |
|
| UnitCountRequiredFlag FL_RQ_TND_UN_CNT |
· |
|
| AcceptanceForPaymentOnAccountFlag FL_POA_TND_ACTPN |
· |
|
| MagneticStripeReaderRequiredFlag FL_MSR_RQ |
· |
|
| CheckEncodingFlag FL_CHK_ENC |
· |
|
| TenderAccountApprovalReference CO_RFC_TND_APVL |
||
| AccountNumber(PK) ID_ACNT_NMB |
· |
|
| TenderTypeCode(PK)(FK) TY_TND |
· |
|
| TenderAuthorizationPermissionFlag FL_PRMS |
· |
|
| TenderAuthorizationFollowUpActionCode LU_ACTN_FLW_UP |
· |
|
| CeilingLimitAmount UL_APVL_TND |
· |
|
| TenderAuthorizationLastActionCode LU_ACTN_LS |
· |
|
| TenderIssuingBankID ID_BK_TND_ISSG |
· |
|
| CreateDateTimestamp TS_CRT_TND_APVL |
· |
|
| LastUpdateDateTimestamp TS_UPDT_LS_APVL |
· |
|
| LastApprovalGivenDateTimestamp TS_APRV_TND_LS_GVN |
· |
|
| PartyID(FK) ID_PRTY |
· |
|
| PartyRoleTypeCode(FK) TY_RO_PRTY |
· |
|
| TenderChangeLineItem TR_LTM_TND_CHN |
||
| WorkstationID(PK)(FK) ID_WS |
· |
|
| TransactionSequenceNumber(PK)(FK) AI_TRN |
· |
|
| RetailTransactionLineItemSequenceNumber(PK)(FK) AI_LN_ITM |
· |
|
| BusinessDayDate(PK)(FK) DC_DY_BSN |
· |
|
| Amount MO_LN_ITM_TND_CHN |
· |
|
| TenderTypeCode(FK) TY_TND |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| TenderClass CO_CLS_TND |
||
| TenderClassCode(PK) LU_CLS_TND |
· |
|
| TenderClassDescription DE_CLS_TND |
· |
|
| TenderControlTransaction TR_CTL_TND |
||
| TransactionSequenceNumber(PK)(FK) AI_TRN |
· |
|
| WorkstationID(PK)(FK) ID_WS |
· |
|
| BusinessDayDate(PK)(FK) DC_DY_BSN |
· |
|
| PickupOrLoanCode LU_PKP_LON |
· |
|
| ReasonCode RC_TND_CTL |
· |
|
| ExternalDepositReceiptFlag FL_RCV_EXTRN_DS |
· |
|
| Loan Origin(FK) ID_RPSTY_TND_ORG |
· |
|
| Pickup Destination(FK) ID_RPSTY_TND_DEST |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| TenderControlTransactionTenderLineItem TR_LTM_TND_CTL_TND |
||
| WorkstationID(PK)(FK) ID_WS |
· |
|
| TransactionSequenceNumber(PK)(FK) AI_TRN |
· |
|
| BusinessDayDate(PK)(FK) DC_DY_BSN |
· |
|
| TenderTypeCode(PK)(FK) TY_TND |
· |
|
| Amount MO_TND_FN_TRN |
· |
|
| Count QU_TND_FN_TRN |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| TenderDepositTransaction TR_DS_TND |
||
| WorkstationID(PK)(FK) ID_WS |
· |
|
| TransactionSequenceNumber(PK)(FK) AI_TRN |
· |
|
| BusinessDayDate(PK)(FK) DC_DY_BSN |
· |
|
| TenderTypeCode(FK) TY_TND |
· |
|
| TenderRepositoryID(FK) ID_RPSTY_TND |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| TenderLineItem TR_LTM_TND |
||
| WorkstationID(PK)(FK) ID_WS |
· |
|
| TenderAccountNumber ID_ACNT_TND |
· |
|
| TransactionSequenceNumber(PK)(FK) AI_TRN |
· |
|
| RetailTransactionLineItemSequenceNumber(PK)(FK) AI_LN_ITM |
· |
|
| Amount MO_ITM_LN_TND |
· |
|
| BusinessDayDate(PK)(FK) DC_DY_BSN |
· |
|
| AccountNumber(FK) ID_ACNT_NMB |
· |
|
| TenderTypeCode(FK) TY_TND |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| TenderLoanTransaction TR_LON_TND |
||
| WorkstationID(PK)(FK) ID_WS |
· |
|
| TransactionSequenceNumber(PK)(FK) AI_TRN |
· |
|
| Amount MO_LON_TND |
· |
|
| ReasonCode RC_LON_TND |
· |
|
| BusinessDayDate(PK)(FK) DC_DY_BSN |
· |
|
| TenderTypeCode(FK) TY_TND |
· |
|
| TenderRepositoryID(FK) ID_RPSTY_TND_FM |
· |
|
| Inbound(FK) ID_RPSTY_TND_TO |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| TenderPickupTransaction TR_PKP_TND |
||
| WorkstationID(PK)(FK) ID_WS |
· |
|
| TransactionSequenceNumber(PK)(FK) AI_TRN |
· |
|
| Amount MO_PKP_TND |
· |
|
| ReasonCode RC_PKP_TND |
· |
|
| BusinessDayDate(PK)(FK) DC_DY_BSN |
· |
|
| TenderTypeCode(FK) TY_TND |
· |
|
| TenderRepositoryID(FK) ID_RPSTY_TND |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| TenderRepository AS_RPSTY_TND |
||
| TenderRepositoryID(PK) ID_RPSTY_TND |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| TypeCode(FK) TY_RPSTY_TND |
· |
|
| Name NM_RPSTY_TND |
· |
|
| Description DE_TND_RPSTY |
· |
|
| TenderRepositoryClass CO_CLS_TND_RPSTY |
||
| Description DS_CLS_TND_RPSTY |
· |
|
| TenderRepositoryTypeCode(PK) TY_RPSTY_TND |
· |
|
| TenderRepositoryTenderAccount LE_ACNT_TND_RPSTY |
||
| TenderRepositoryID(PK)(FK) ID_RPSTY_TND |
· |
|
| TenderTypeCode(PK)(FK) TY_TND |
· |
|
| StoreFinancialLedgerAccountID(FK) ID_ACTN_LDG |
· |
|
| RetailStoreID(FK) ID_STR_RT |
· |
|
| Transaction TR_TRN |
||
| TransactionSequenceNumber(PK) AI_TRN |
· |
|
| BusinessDayDate(PK)(FK) DC_DY_BSN |
· |
|
| OperatorID(FK) ID_OPR |
· |
|
| SessionStartDateTimestamp(FK) TS_TM_SRT |
· |
|
| TransactionTypeCode(FK) TY_TRN |
· |
|
| BeginDateTimestamp TS_TRN_BGN |
· |
|
| EndDateTimestamp TS_TRN_END |
· |
|
| TrainingFlag FL_TRG_TRN |
· |
|
| WorkstationID(FK) ID_WS |
· |
|
| RetailStoreID(FK) ID_STR_RT |
· |
|
| KeyedOfflineFlag FL_KY_OFL |
· |
|
| TransactionType CO_TYP_TRN |
||
| TransactionTypeCode(PK) TY_TRN |
· |
|
| ResourceID(FK) ID_RS |
· |
|
| WorkGroup CO_GP_WRK |
||
| Description DE_GP_WRK |
· |
|
| ParentWorkGroupID(FK) ID_GP_WRK_PRNT |
· |
|
| WorkGroupID(PK) ID_GP_WRK |
· |
|
| Workstation AS_WS |
||
| WorkstationID(PK) ID_WS |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| SupplierID(FK) ID_SPR |
· |
|
| ServiceProviderID(FK) ID_PVR_SV |
· |
|
| ManufacturerName NM_WS_MF |
· |
|
| TerminalModelNumber NM_MDL_WS_TML |
· |
|
| TerminalDeviceAddress AD_DVC_TML |
· |
|
| TerminalStatusCode SC_TML_WS |
· |
|
| TillCount QU_TL_WS |
· |
|
| TerminalFixedAssetNumber ID_AST_FX_WS_TML |
· |
|
| TypeCode TY_WS |
· |
|
| TrainingModeFlag FL_MOD_TRG |
· |
|
| WorkstationResource ST_WS_RS |
||
| WorkstationID(PK)(FK) ID_WS |
· |
|
| ResourceID(PK)(FK) ID_RS |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|
| ReadAccessLevel PS_ACS_RD |
· |
|
| WriteAccessLevel PS_ACS_WR |
· |
|
| WorkstationRule RU_WS |
||
| WorkstationRuleTypeCode(PK) TY_RU_WS |
· |
|
| WorkstationRuleNumber(PK) ID_RU_WS |
· |
|
| LowerLimitAmount LL_RU_WS |
· |
|
| UpperLimitAmount UL_RU_WS |
· |
|
| ActionApprovalByTypeCode TY_ACTN_APLV_BY |
· |
|
| BelowLowerLimitActionRequiredTypeCode TY_ACTN_RQ_BLW_LM |
· |
|
| AboveUpperLimitActionRequiredTypeCode TY_ACTN_RQ_ABV_LM |
· |
|
| WorkstationGroupID(PK) ID_GP_WS |
· |
|
| MultiplierAmount CP_MPR_WS_RU |
· |
|
| MultiplierMultiplicandTypeCode TY_MPD_MPR_WS_RU |
· |
|
| Name NM_RU_WS |
· |
|
| WorkstationRuleApplication CO_APLN_WS_RU |
||
| WorkstationID(PK)(FK) ID_WS |
· |
|
| WorkstationRuleTypeCode(PK)(FK) TY_RU_WS |
· |
|
| WorkstationRuleNumber(PK)(FK) ID_RU_WS |
· |
|
| WorkstationGroupID(PK)(FK) ID_GP_WS |
· |
|
| EffectiveDate DC_APLN_EF |
· |
|
| ExpirationDate DC_APLN_EP |
· |
|
| CreateDateTimestamp TS_APLN_CRT |
· |
|
| RetailStoreID(PK)(FK) ID_STR_RT |
· |
|