Retail Store Functions
Tag |
Domain |
Definition |
| AccessPassword | Password | The password which permits the OPERATOR to specific RESOURCES and workstations within the RETAIL STORE.\n |
| OperatorID | Identity | A unique, automatically assigned number used to identify a workstation OPERATOR. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
Tag |
Domain |
Definition |
| AccountCode | Code4 | Identifies how the account payable/receivable should be recorded in the financial journal. |
| AccountPayableReceivableCustomerAccountId | Identity | Identifies a customer account that is being debited or credited by the account \npayable/receivable line item. \n |
| AccountPayableReceivableFlag | Flag | Flag that determines whether this line item is a payable or a receivable. |
| Amount | Money | The monetary amount of the account payable/receivable line item. |
| BusinessDayDate | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| CustomerAccountID | Identity | A unique identifier for a customer account. Generally assigned by the home office. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| RetailTransactionLineItemSequenceNumber | LineNumber | The sequence number of line item within a TRANSACTION. |
| TransactionSequenceNumber | Identity | A unique, non-significant, automatically assigned sequential number used\nto identify a TRANSACTION within the context of a WORKSTATION and a BUSINESS PERIOD. |
| WorkstationID | Identity | The unique identifier for the WORKSTATION, typically the serial number. |
Tag |
Domain |
Definition |
| AddressID | Identity | A unique identifier for a location and mail address. |
| AddressTypeCode | Code2 | Defines a standard type of address usage. |
Tag |
Domain |
Definition |
| AddressTypeCode | Code2 | Defines a standard type of address usage. |
| Description | DescriptionShort | Description of address type. |
| Name | Name | Business name for an address type. |
Tag |
Domain |
Definition |
| InventoryControlDocumentID | Identity | The reference number that uniquely identifies the INVENTORY CONTROL DOCUMENT. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
Tag |
Domain |
Definition |
| Description | DescriptionShort | A description of the type of age restriction that applies to this ITEM |
| MinimumCustomerAge | QuantityYrsCount | The minimum age under which the customer is prohibited from purchasing the ITEM. |
| MinimumEmployeeAge | QuantityYrsCount | The minimum age under which the employee is prohibited from selling the ITEM. |
| SalesRestrictionCode | Code6 | A unique, automatically assigned code for a specific limitation on an ITEM's sale. |
| SalesRestrictionTypeCode | Code4 | A unique code for a group of SALES RESTRICTIONS. |
Tag |
Domain |
Definition |
| OriginalItem | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
| SubstituteItem | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
| SubstitutionReasonDesc | DescriptionShort | A narrative describing the circumstances under which one item can be substituted for another. For instance, one item may be offered as an alternative in a gift registry scenario, but not in a clearance or promotional scenario. |
Tag |
Domain |
Definition |
| MerchandiseStructureID | Identity | Unique identifier for a merchandise structure. |
| SummedInto | Code4 | Identifies a hierarchy level within a summarization tree structure for merchandise sales analysis and merchandise classification. The values for this attribute will be standardized within the ARTS Data Model. |
| SumOf | Code4 | Identifies a hierarchy level within a summarization tree structure for merchandise sales analysis and merchandise classification. The values for this attribute will be standardized within the ARTS Data Model. |
Tag |
Domain |
Definition |
| BrandName | Name | A unique name to denote a class of ITEMs as a product of a single supplier or manufacturer. The brand can include private label ITEMs. |
| Description | DescriptionShort | The description of a class of ITEMs produced by a product of a single supplier or manufacturer. |
Tag |
Domain |
Definition |
| AccountingDispositionCode | Code4 | Determines whether the price derivation for this rule is treated as a revaluation of merchandise ( in which case it impacts the stock ledger) or an expense ( in which case it impacts the store financial ledger). |
| BrandName | Name | A unique name to denote a class of ITEMs as a product of a single supplier or manufacturer. The brand can include private label ITEMs. |
| ConcurrenceDispositionCode | Code4 | Determines how the retail price reduction or increase calculated as the result of the application of the PRICE DERIVATION RULE will be handled where more than one rule is applied within a sales transaction. |
| EffectiveDateTimestamp | TimeStampEffective | The time and date this rule is activated and may be applied |
| EventID | Identity | A unique, automatically assigned identifier for each EVENT instance. |
| ExpirationDateTimestamp | TimeStampExpiration | The time and date this rule no longer valid |
| PriceDerivationRuleID | Identity | A identifier for a specific price derivation rule.\n |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| StoreFinancialLedgerAccountID | Identity | The reference for the STORE FINANCIAL LEDGER ACCOUNT |
Tag |
Domain |
Definition |
| BusinessDayDate | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| FiscalDayNumber | DateFiscalDay | The week day part of a fiscal date numbered 1 (Sun) through 7 (Sat) |
| FiscalWeekNumber | DateFiscalWeek | The relative week with in a fiscal year expressed as an integer count. |
| FiscalYear | DateCalendarYear | An identifier that uniquely identifies a particular FISCAL YEAR in CCYY format. |
Tag |
Domain |
Definition |
| CarrierID | Identity | The carrier presenting the bill of lading. |
| DunsNumber | IdentityDunsIdentifier | The identifier assigned by Dun & Bradstreet for the purposes of corporate identification in the retail community and credit worthiness. |
| Name | Name | The legal name of the transportation company referenced by the CARRIER-ID. |
| PartyID | Identity | A unique, automatically assigned identity for a PARTY. |
| PartyRoleTypeCode | Code6 | A code that identifies a group of PARTY ROLES. This is used for subtyping the PARTY ROLEs. |
Tag |
Domain |
Definition |
Tag |
Domain |
Definition |
| CharitableRegistrationNumber | TaxIdentityNumber | An ID assigned by a tax authority for charitable organizations. |
| OrganizationPartyID | Identity | A unique, automatically assigned identity for a PARTY. |
Tag |
Domain |
Definition |
| AdjudicationCode | Code4 | A code to denote that approval has been received from the authorization center. |
| BankID | Identity | The unique identifier of the bank or third party authorization center. |
| BusinessDayDate | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| CheckAccountNumber | Identity | The check account number of CUSTOMERs whose checks have been previously honored or rejected. Retaining a check history by CUSTOMER provides the RETAIL STORE with a means of tender authorization. |
| CheckSequenceNumber | LineNumber | A unique sequence number relating to a particular check authorization. |
| CustomerBirthDate | DateCalendarDay | The customer's date of birth captured as part of the personal data required to verify their identity and authorize their use of a check to pay for a purchase. |
| PersonalIDNumber | Identity | The personal identification number that must be keyed by an individual at the point of sale when paying by personal check. |
| PersonalIDRequiredTypeCode | Code2 | Identifies the type of personal identification required to authorize tender. Examples include driver's license, a second credit card, social security card, etc. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| RetailTransactionLineItemSequenceNumber | LineNumber | The sequence number of line item within a TRANSACTION. |
| TransactionSequenceNumber | Identity | A unique, non-significant, automatically assigned sequential number used\nto identify a TRANSACTION within the context of a WORKSTATION and a BUSINESS PERIOD. |
| WorkstationID | Identity | The unique identifier for the WORKSTATION, typically the serial number. |
Tag |
Domain |
Definition |
| ColorCode | Code4 | A code to identify the color. The assumption is that the retailer will adopt the standards as designated by the NRF, created to facilitate the exchange of data between vendors and retailers |
| Description | DescriptionShort | A full description of the individual color, designated by the respective code and name. |
| Name | Name | The individual names of the associated colors that are encompassed by the respective color code. For example, color code 201 may include both chocolate and kola nut. |
Tag |
Domain |
Definition |
| OrganizationPartyID | Identity | A unique, automatically assigned identity for a PARTY. |
Tag |
Domain |
Definition |
| EmployeeID | Identity | A unique, non-significant number used to identify a store employee. |
Tag |
Domain |
Definition |
| AmountPercentFlag | Flag | Directs the commission calculator to use a flat commission-modifier-amount or the commission-modifier-percent to calculate the commission to be credited to the commissionable employee. |
| BusinessDayDate | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| CommissionEmployeeId | Identity | A unique, non-significant number used to identify a store employee. |
| CommissionModifierSequenceNumber | LineNumber | A sequential counter used to uniquely identify an instance of a COMMISSION MODIFIER. |
| ModifierAmount | Money | Defines the flat amount of commission earned on the sale of this item |
| ModifierPercent | Percent | Defines the percentage applied to the sold-at retail amount to arrive at the commission for an item or service sold in the SALE/RETURN LINE ITEM. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| RetailTransactionLineItemSequenceNumber | LineNumber | The sequence number of line item within a TRANSACTION. |
| TransactionSequenceNumber | Identity | A unique, non-significant, automatically assigned sequential number used\nto identify a TRANSACTION within the context of a WORKSTATION and a BUSINESS PERIOD. |
| WorkstationID | Identity | The unique identifier for the WORKSTATION, typically the serial number. |
Tag |
Domain |
Definition |
| CloseDate | DateCalendar | The date the date the competitor closed |
| CompetitorID | Identity | The unique identifier assigned to a competitor by the store. |
| Name | Name | The name of retailer competing in the same sector within the same locality |
| OpenDate | DateCalendar | The date the competitor opened. |
| PartyID | Identity | A unique, automatically assigned identity for a PARTY. |
| PartyRoleTypeCode | Code6 | A code that identifies a group of PARTY ROLES. This is used for subtyping the PARTY ROLEs. |
| StatusCode | Code2Status | The current status of the competitor. |
Tag |
Domain |
Definition |
| CompetitorID | Identity | The unique identifier assigned to a competitor by the store. |
| ItemID | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
| LocalAdvertisingFlag | Flag | A flag that indicates whether or not the competitor is advertising the item in local media. |
| OnPromotionFlag | Flag | Flag that indicates that the item offered by a competitor is being promoted (i.e. offered at a lower price). |
| PriceEffectiveDate | DateCalendar | The effective date of the competitor retail sale unit price. |
| PriceExpirationDate | DateCalendar | The expiration date of the competitor retail sale unit price. |
| PromotionStoreCouponFlag | Flag | A flag to indicate whether or not the competitor is promoting the item using in-store coupons. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| SaleUnitPriceAmount | MoneyShortRetail | The retail sale unit price that a competitor has assigned to the item. |
Tag |
Domain |
Definition |
| ContactTypeCode | Code2 | A code used to categorize different kinds of contact. |
| Effective Date | DateCalendar | The start date of a PERSON's affiliation with an organization. |
| FunctionCode | Code2 | A code to identify the major duty or responsibility of the contact. These codes relate to the UCC data element 366. |
| OrganizationPartyID | Identity | A unique, automatically assigned identity for a PARTY. |
| Party Role | Code6 | A code that identifies a group of PARTY ROLES. This is used for subtyping the PARTY ROLEs. |
| PersonOrganizationAffilationTypeName | String | A name or label for a group of affiliations of people and organizations. For instance, this might be 'employment'. |
| PersonPartyID | Identity | A unique, automatically assigned identity for a PARTY. |
Tag |
Domain |
Definition |
| ContactTypeCode | Code2 | A code used to categorize different kinds of contact. |
| Description | DescriptionShort | The business description for this type of contact |
| Name | Name | The business name for this type of contact. |
| RoleCode | Code2 | The role played by this type of contact (e.g., pays invoices, approves RTV's, etc.) |
Tag |
Domain |
Definition |
| Description | Name | A description of the container type. |
| UCCPackagingFormCode | Code4External | The UCC code to denote the type of packaging from the UCC 103 packaging code data element list.. |
| UCCPackagingMaterialCode | Code4External | A UCC defined code that describes the material used to fabricate the CONTAINER TYPE. This code uses the UCC 103 packaging code date element value list for packaging materials. |
Tag |
Domain |
Definition |
| ContractorID | Identity | An alternate ID assigned to a CONTRACTOR. |
Tag |
Domain |
Definition |
| BusinessDayDate | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| TransactionSequenceNumber | Identity | A unique, non-significant, automatically assigned sequential number used\nto identify a TRANSACTION within the context of a WORKSTATION and a BUSINESS PERIOD. |
| TypeCode | Code4 | A code that describes the type of control transaction, i.e. period close, etc. |
| WorkstationID | Identity | The unique identifier for the WORKSTATION, typically the serial number. |
Tag |
Domain |
Definition |
| CoordinateTypeCode | Code2 | A categorization of co-ordinate systems. |
| Description | DescriptionNarrative | A description of a category of co-ordinate systems. |
Tag |
Domain |
Definition |
| CouponTypeCode | Code2 | A code to denote the type of coupon, e.g. raincheck, manufacturer coupon, electronic coupon. |
| CouponValueAccountingDispositionCode | Code4 | The disposition code for the coupon, e.g. store coupons are charged as an expense or markdown. |
| Description | DescriptionShort | A description of the coupon, e.g. money off a particular ITEM. |
Tag |
Domain |
Definition |
| BusinessDayDate | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| CouponTypeCode | Code2 | A code to denote the type of coupon, e.g. raincheck, manufacturer coupon, electronic coupon. |
| CouponValidation | LineNumber | The sequence number of line item within a TRANSACTION. |
| ExpirationDate | ProductCodeExpiry | The date a coupon may no longer be used as part of the settlement of a sale transaction. It is normally found in the UCC/EAN-128 coupon extended code. In this code, the expiration code is only four digits and contains only month and year. The day is always the last day of the month. |
| KeyEnteredFlag | Flag | A flag to denote whether the coupon is key entered or scanned, i.e. 0=no (scanned), 1=yes (key entered) |
| ManufacturerFamilyCode | ProductCodeFamily | The UPC designated three digit coupon family code for the manufacturer item. |
| ManufacturerID | Identity | A unique identifier to denote the ITEM MANUFACTURER. |
| PromotionCode | Code6 | Identifies a promotion associated with the coupon. Promotion codes are used by manufacturers and suppliers to analyze the impact their promotion is having on sales across a geographic area and over a specified promotional period of time. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| RetailTransactionLineItemSequenceNumber | LineNumber | The sequence number of line item within a TRANSACTION. |
| ScanCode | PostalCode | The barcode on a store or manufacturer coupon. The coupon scan code comprises two parts: the first is a fixed 12 character code that contains the manufacturer identification, family code, and coupon value, the second is based on Code 128 and comprises up to 20 characters. This supplementary code comprises the manufacturer's number system character, the offer code, and end of offer code. The supplementary was introduced as a guideline in 1997. |
| TransactionSequenceNumber | Identity | A unique, non-significant, automatically assigned sequential number used\nto identify a TRANSACTION within the context of a WORKSTATION and a BUSINESS PERIOD. |
| WorkstationID | Identity | The unique identifier for the WORKSTATION, typically the serial number. |
Tag |
Domain |
Definition |
| AccountNumber | Name | The account number appearing on a debit/credit card and identifying the card issuer's customer account to be charged or credited for the transaction. |
| AdjudicationCode | Code6 | A code indicating the result of a request to authorize the use of tender to settle a transaction. |
| AuthorizationMethodCode | Code4 | Identifies the method used to authorize tender. Examples include by electronic query, by sales employee visual inspection of customer card and id. |
| BusinessDayDate | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| CardNumberSwipedOrKeyedCode | Code2 | A code that indicates whether the credit or debit card account number was read using a magnetic stripe reader (i.e. swiped) or keyed. |
| CustomerSignatureImage | Code2Status | Digitized image of the customer's signature. |
| MediaIssuerID | Identity | The identifying number of the bank, credit union, financial services firm or other third party issuing the debit/credit card used in the transaction. |
| PersonalIDReferenceNumber | Identity | The identifying number of the driver license or other personal id provided by the customer to verify his/her identity at the point of sale. |
| PersonalIDRequiredTypeCode | Code2 | Identifies the type of personal identification required to authorize tender. Examples include driver's license, a second credit card, social security card, etc. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| RetailTransactionLineItemSequenceNumber | LineNumber | The sequence number of line item within a TRANSACTION. |
| Track2CreditCardBitMap | BitMap | Defines the bit pattern used on track 2 of the magnetic strip on the back of a credit card. |
| TransactionSequenceNumber | Identity | A unique, non-significant, automatically assigned sequential number used\nto identify a TRANSACTION within the context of a WORKSTATION and a BUSINESS PERIOD. |
| WorkstationID | Identity | The unique identifier for the WORKSTATION, typically the serial number. |
Tag |
Domain |
Definition |
| CurrencyID | Identity | The unique identifier of the CURRENCY. |
| Description | DescriptionShort | A description of the currency, i.e. pounds sterling, US dollars, Canadian dollars, etc. |
| IssuingCountryCode | Code4 | Identification of the country issuing the currency. This code relates to the UCC data element 100, Currency Code, |
| Symbol | Name | National symbol for the main unit of currency, e.g. £, $, etc |
Tag |
Domain |
Definition |
| AnnualIncomeAmount | Money | A customer's annual salary or income.\n |
| CustomerID | Identity | A unique identifier for a customer. |
| HighestEducationLevelName | Name | A name or label that describes a CUSTOMER's highest level of education. For instance, primary school, post-secondary, graduate, etc. |
| LifecycleType | Name | A categorization of CUSTOMERs based on the type of relationship that customer has with the retail enterprise. |
| MaritalStatusCode | Code2Status | A code that describes a CUSTOMER's current marital status. For instance, married, single, etc. |
| PartyID | Identity | A unique, automatically assigned identity for a PARTY. |
| PartyRoleTypeCode | Code6 | A code that identifies a group of PARTY ROLES. This is used for subtyping the PARTY ROLEs. |
| ReligiousAffiliationName | Name | A name or label that describes a CUSTOMER's religious preference. |
Tag |
Domain |
Definition |
| CumulativeFrequentShopperPointsCount | Quantity | A counter that accumulates frequent shopper points earned by a customer over a period of time and which may entitle a customer to a free gift or additional price reductions on selected items. |
| CustomerAccountID | Identity | A unique identifier for a customer account. Generally assigned by the home office. |
| CustomerID | Identity | A unique identifier for a customer. |
| CustomerIdentityRequiredFlag | Flag | Flag that if set to true requires the customer to provide proof of his/her identity to verify that he/she may use the CUSTOMER ACCOUNT. |
| CustomerIdentityTypeCode | Code2 | Determines the type of customer identification proof required. Examples include drivers license, store charge card, trade association identification card, etc. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| StoreFinancialLedgerAccountID | Identity | The reference for the STORE FINANCIAL LEDGER ACCOUNT |
| TypeCode | Code2 | Determines what kind of customer account this is. Examples include a trade account, a school account, a not-for-profit, regular customer, etc. |
Tag |
Domain |
Definition |
| CustomerAccountCardItemNumber | Number | A sequential number assigned to one of potentially many CUSTOMER ACCOUNT CARDs. |
| CustomerAccountID | Identity | A unique identifier for a customer account. Generally assigned by the home office. |
| ExpirationDate | DateCalendar | A date that a specific CUSTOMER ACCOUNT CARD is no longer valid. |
Tag |
Domain |
Definition |
| AccountingDispositionCode | Code4 | Determines whether the price derivation for this rule is treated as a revaluation of merchandise (in which case it impacts the stock ledger) or an expense (in which case it impacts the store financial ledger). |
| ConcurrenceDispositionCode | Code4 | Determines how the retail price reduction or increase calculated as the result of the application of the PRICE DERIVATION RULE will be handled where more than one rule are applied within a sales transaction. Valid examples of values include: - Compound the price changes; Select the single best deal for the customer (i.e. the one rule that by itself yields the lowest price . |
| CustomerAccountID | Identity | A unique identifier for a customer account. Generally assigned by the home office. |
| EffectiveDateTimestamp | TimeStampEffective | The time and date when the CUSTOMER ACCOUNT PRICE DERIVATION RULE becomes effective. |
| EventID | Identity | A unique, automatically assigned identifier for each EVENT instance. |
| ExpirationDateTimestamp | TimeStampExpiration | The time and date when the CUSTOMER ACCOUNT PRICE DERIVATION RULE expires. |
| PriceDerivationRuleID | Identity | A identifier for a specific price derivation rule.\n |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| StoreFinancialLedgerAccountID | Identity | The reference for the STORE FINANCIAL LEDGER ACCOUNT |
Tag |
Domain |
Definition |
| CustomerAccountID | Identity | A unique identifier for a customer account. Generally assigned by the home office. |
| ItemCurrentSaleUnitSpecialPriceAmount | MoneyShortRetail | The current retail price per sale unit of the item. This monetary amount is used as the basis for deriving retail price at the point of sale. |
| ItemID | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
| ItemSpecialPriceDiscountFlag | Flag | A flag that determines whether or not the customer account special price is eligible for discounts. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
Tag |
Domain |
Definition |
| CustomerGroupID | Identity | A unique identification number assigned to a customer group |
| CustomerID | Identity | A unique identifier for a customer. |
| IdentityVerifyRequiredFlag | Flag | A flag to denote whether the CUSTOMER's identity has been verified as belonging to the CUSTOMER AFFILIATION scheme. |
Tag |
Domain |
Definition |
| AccountingDispositionCode | Code4 | Determines whether the price derivation for this rule is treated as a revaluation of merchandise (in which case it impacts the stock ledger) or an expense (in which case it impacts the store financial ledger). |
| ConcurrenceDispositionCode | Code4 | Determines how the retail price reduction or increase calculated as the result of the application of the PRICE DERIVATION RULE will be handled where more than one rule are applied within a sales transaction. Valid examples of values include: - Compound the price changes; Select the single best deal for the customer (i.e. the one rule that by itself yields the lowest price . |
| CustomerGroupID | Identity | A unique identification number assigned to a customer group |
| CustomerID | Identity | A unique identifier for a customer. |
| EffectiveDateTimestamp | TimeStampEffective | The time when the CUSTOMER AFFILIATION PRICE DERIVATION RULE is effective. |
| EventID | Identity | A unique, automatically assigned identifier for each EVENT instance. |
| ExpirationDateTimestamp | TimeStampExpiration | The time when the CUSTOMER AFFILIATION PRICE DERIVATION RULE can no longer be applied to a TRANSACTION. |
| PriceDerivationRuleID | Identity | A identifier for a specific price derivation rule.\n |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| StoreFinancialLedgerAccountID | Identity | The reference for the STORE FINANCIAL LEDGER ACCOUNT |
Tag |
Domain |
Definition |
| CustomerAssetID | Identity | A unique, automatically assigned identifier for an asset or other item of interest that belongs to or is related to a customer. |
| Description | DescriptionNarrative | A narrative that describes this asset or other item belonging to a CUSTOMER. |
Tag |
Domain |
Definition |
| CustomerAssetID | Identity | A unique, automatically assigned identifier for an asset or other item of interest that belongs to or is related to a customer. |
| CustomerID | Identity | A unique identifier for a customer. |
| OwnedSinceDate | DateCalendar | A self-reported original ownership/lease/acquisition date for a CUSTOMER ASSET. |
| VerifiedDate | DateCalendar | The date that an asset is verified as being in the possession of a CUSTOMER. |
Tag |
Domain |
Definition |
| CustomerAccountID | Identity | A unique identifier for a customer account. Generally assigned by the home office. |
Tag |
Domain |
Definition |
| CreatedDate | DateCalendar | The date and time that a CUSTOMER's letter, fax, or e-mail was created. |
| CustomerCorrespondenceReceivedDate | DateCalendar | The date and time that a CUSTOMER's letter, fax, e-mail, or phone call is taken or received at a retail store or other facility. |
| CustomerID | Identity | A unique identifier for a customer. |
| SendDate | DateCalendar | The date and time that a CUSTOMER's letter, fax, e-mail, or phone call was sent by the customer. |
| SummaryDescription | DescriptionNarrative | A brief interpretation summarizing the main points of the correspondence. |
Tag |
Domain |
Definition |
| CustomerDemographicRoleEffectiveDate | DateCalendar | The date that a CUSTOMER is first assigned to a demographic role. |
| CustomerID | Identity | A unique identifier for a customer. |
| DemographicRoleName | Name | A label or title given to a group of people or organizations that represents their assignment to a class of buyers. |
Tag |
Domain |
Definition |
| CustomerID | Identity | A unique identifier for a customer. |
| CustomerOccasionDate | DateCalendar | The start date of a an event or other occasion that a customer celebrates. |
| CustomerOccasionTypeName | Name | A short label for a group of CUSTOMER OCCASIONs. For instance, this could be a wedding, a high school graduation, a birthday, a golden wedding anniversary, etc. |
| Date | DateCalendar | The date that a CUSTOMER GIFT RESTRATION is created. |
Tag |
Domain |
Definition |
| CustomerGroupID | Identity | A unique identification number assigned to a customer group |
| Description | DescriptionShort | The text description applied to a customer group. |
| Name | Name | The business name applied to a customer group. |
Tag |
Domain |
Definition |
| BusinessDayDate | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| RetailTransactionLineItemSequenceNumber | LineNumber | The sequence number of line item within a TRANSACTION. |
| TransactionSequenceNumber | Identity | A unique, non-significant, automatically assigned sequential number used\nto identify a TRANSACTION within the context of a WORKSTATION and a BUSINESS PERIOD. |
| TypeCode | Code2 | Defines the type of customer information captured in this line item instance. Valid examples\ninclude: Customer Name, Customer Address, Delivery Address, Customer Account, and\nSpecial Handling Instructions. |
| WorkstationID | Identity | The unique identifier for the WORKSTATION, typically the serial number. |
Tag |
Domain |
Definition |
| BusinessDayDate | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| CustomerInformationModifierSequenceNumber | LineNumber | A sequential number designed to uniquely identify each modifier for a CUSTOMER INFORMATION LINE item. |
| DataElementFormatCode | Code2 | Defines how the value of a data element is to be internally represented. Valid examples\ninclude TEXT, MONEY, LOGICAL (yes/no), COUNT (integer), FLOAT. |
| DataElementID | Identity | A dictionary data element identity assigned by each retailer for the type of data they want\nto collect as part of their CUSTOMER INFORMATION LINE. |
| DataElementValue | Money | The value entered for a data element in a CUSTOMER INFORMATION LINE MODIFIER. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| RetailTransactionLineItemSequenceNumber | LineNumber | The sequence number of line item within a TRANSACTION. |
| TransactionSequenceNumber | Identity | A unique, non-significant, automatically assigned sequential number used\nto identify a TRANSACTION within the context of a WORKSTATION and a BUSINESS PERIOD. |
| WorkstationID | Identity | The unique identifier for the WORKSTATION, typically the serial number. |
Tag |
Domain |
Definition |
| CustomerAccountID | Identity | A unique identifier for a customer account. Generally assigned by the home office. |
Tag |
Domain |
Definition |
| CustomerAccountID | Identity | A unique identifier for a customer account. Generally assigned by the home office. |
Tag |
Domain |
Definition |
| CumulativeNetSalesAmount | Money | The net sales (gross sales less returns) accumulated for the CUSTOMER PROMOTIONAL ACCOUNT. Note the accumulation is for the period bounded by the effective date and the expiration date for this promotional account. |
| CustomerAccountID | Identity | A unique identifier for a customer account. Generally assigned by the home office. |
| EffectiveDate | DateCalendar | The date this CUSTOMER PROMOTIONAL ACCOUNT becomes active for accumulating sales and other activity. |
| ExpirationDate | DateCalendar | The date this CUSTOMER PROMOTIONAL ACCOUNT expires making him/her ineligible for special awards and/or price reductions. |
| LoyaltyProgramID | Identity | A artificial, unique identifier for a loyalty program. |
Tag |
Domain |
Definition |
| CustomerAccountID | Identity | A unique identifier for a customer account. Generally assigned by the home office. |
| PriceDerivationRuleID | Identity | A identifier for a specific price derivation rule.\n |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
Tag |
Domain |
Definition |
| CustomerID | Identity | A unique identifier for a customer. |
| CustomerOccasionDate | DateCalendar | The start date of a an event or other occasion that a customer celebrates. |
| CustomerOccasionTypeName | Name | A short label for a group of CUSTOMER OCCASIONs. For instance, this could be a wedding, a high school graduation, a birthday, a golden wedding anniversary, etc. |
Tag |
Domain |
Definition |
| CustomerOccasionTypeName | Name | A short label for a group of CUSTOMER OCCASIONs. For instance, this could be a wedding, a high school graduation, a birthday, a golden wedding anniversary, etc. |
| Description | DescriptionNarrative | A description of a categorization of celebrated events or occasions. |
Tag |
Domain |
Definition |
| CustomerID | Identity | A unique identifier for a customer. |
| Description | DescriptionNarrative | A description of customers likes or dislikes of classes of items, colors, sizes, materials, etc. |
| PreferenceTypeCode | Code2 | A unique code for a group of preferences. For instance, all the types of material (clothing) preferences may be grouped together. |
Tag |
Domain |
Definition |
| CustomerRelationshipTypeName | Name | The name or code assigned to a type of CUSTOMER RELATIONSHIP. |
| First | Identity | A unique identifier for a customer. |
| Second | Identity | A unique identifier for a customer. |
Tag |
Domain |
Definition |
| CustomerRelationshipTypeName | Name | The name or code assigned to a type of CUSTOMER RELATIONSHIP. |
| Description | DescriptionNarrative | A description of a categorization of customer relationships. |
Tag |
Domain |
Definition |
Tag |
Domain |
Definition |
| CustomerID | Identity | A unique identifier for a customer. |
Tag |
Domain |
Definition |
| CustomerAccountID | Identity | A unique identifier for a customer account. Generally assigned by the home office. |
| DiscountMonetaryAmount | Money | The monetary amount of discount provided to a specific CUSTOMER TRADE ACCOUNT. |
| DiscountPercent | Percent | The percentage of the base retail price discount provided to a specific CUSTOMER TRADE ACCOUNT. |
Tag |
Domain |
Definition |
| CustomerGroupID | Identity | A unique identification number assigned to a customer group |
| ItemCurrentSaleUnitSpecialPriceAmount | MoneyShortRetail | The current special price per sale unit of the item. This monetary amount is available to only specific CUSTOMER GROUPs.. |
| ItemID | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
| ItemSpecialPriceDiscountFlag | Flag | A flag that determines whether or not the customer type special price is eligible for discounts. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
Tag |
Domain |
Definition |
| DealCode | Identity | A code which uniquely identifies the type of DEAL offered by the SUPPLIER. For example the SUPPLIER may offer an additional 2% discount off the cost price, or increase the case units by 10% for the same cost price. Normally DEALs last for finite periods. |
| Description | DescriptionShort | A brief text description of the DEAL. |
| EffectiveDate | DateCalendar | The start date upon which an ITEM can be ordered under the terms of a given deal.\n |
| ExpirationDate | DateCalendar | The end date upon which an ITEM can be ordered under the terms of a given deal.\n |
| Name | Name | The business name for the deal. |
| SupplierID | Identity | A code assigned by the retailer to uniquely identify the supplier. |
Tag |
Domain |
Definition |
| CostChangeAmount | MoneyShortCost | The difference between the standard and DEAL cost prices or the DEAL cost intended to replace the standard catalog cost for the item. |
| CostChangePercent | Percent | The percentage difference between the standard and DEAL cost prices or the DEAL cost intended to replace the standard catalog cost for the item. |
| CostChangeReplaceOrModifyCode | Code2 | A code that determines how the deal-supplier-cost-change-amount is to be applied -- i.e. it is to replace or modify the catalog cost. |
| DealCode | Identity | A code which uniquely identifies the type of DEAL offered by the SUPPLIER. For example the SUPPLIER may offer an additional 2% discount off the cost price, or increase the case units by 10% for the same cost price. Normally DEALs last for finite periods. |
| SupplierID | Identity | A code assigned by the retailer to uniquely identify the supplier. |
| SupplierItemCostPerUnitTypeCode | Code2 | Defines the unit type the owned attribute costs are assigned to for this item. Valid unit types include: SALE UNIT, PACK UNIT and SHIP UNIT. A single SUPPLIER ITEM may in effect have 1 to three SUPPLIER ITEM BASE COST entities associated with it. |
| SupplierItemID | Identity | The code assigned by the supplier to uniquely identify the ITEM |
Tag |
Domain |
Definition |
| ChangeAmount | Money | The additional allowance amount which is applied when the SUPPLIER's breakpoint is attained.\n |
| ChangePercent | Percent | The additional allowance percentage that is applied when the SUPPLIER's breakpoint is attained. |
| DealCode | Identity | A code which uniquely identifies the type of DEAL offered by the SUPPLIER. For example the SUPPLIER may offer an additional 2% discount off the cost price, or increase the case units by 10% for the same cost price. Normally DEALs last for finite periods. |
| SupplierID | Identity | A code assigned by the retailer to uniquely identify the supplier. |
| SupplierItemCostPerUnitTypeCode | Code2 | Defines the unit type the owned attribute costs are assigned to for this item. Valid unit types include: SALE UNIT, PACK UNIT and SHIP UNIT. A single SUPPLIER ITEM may in effect have 1 to three SUPPLIER ITEM BASE COST entities associated with it. |
| SupplierItemID | Identity | The code assigned by the supplier to uniquely identify the ITEM |
| SupplierItemUnitDealThresholdCount | Quantity | A count associated with an item that triggers a cost reduction as part of a DEAL. |
Tag |
Domain |
Definition |
| DemographicRoleName | Name | A label or title given to a group of people or organizations that represents their assignment to a class of buyers. |
| Description | DescriptionNarrative | A description of a grouping of customers based on their lifestyles, purchasing trends, income ranges, etc. |
Tag |
Domain |
Definition |
| CurrencyID | Identity | The unique identifier of the CURRENCY. |
| DenominationID | Identity | An identifier which uniquely identifies the quantitative value of a specific currency, e.g. $100, £50, etc.\n |
| Description | Name | A description of the quantitative value of a specific currency.\n |
Tag |
Domain |
Definition |
| DepositRedemptionTypeCode | Code2 | Defines the type of deposit or redemption. In addition to distinguishing between deposits (i.e. deposits on bottles, etc.) and redemptions, this code allows the store to establish different categories of deposits and redemptions. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| StoreFinancialLedgerAccountID | Identity | The reference for the STORE FINANCIAL LEDGER ACCOUNT |
Tag |
Domain |
Definition |
| Amount | Money | The monetary amount of a deposit or redemption. |
| BusinessDayDate | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| DepositRedemptionTypeCode | Code2 | Defines the type of deposit or redemption. In addition to distinguishing between deposits (i.e. deposits on bottles, etc.) and redemptions, this code allows the store to establish different categories of deposits and redemptions. |
| ItemID | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
| POSItemID | Identity | POS item id is a token identifier to facilitate price lookup and does not\ncontain any descriptive information. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| RetailTransactionLineItemSequenceNumber | LineNumber | The sequence number of line item within a TRANSACTION. |
| TransactionSequenceNumber | Identity | A unique, non-significant, automatically assigned sequential number used\nto identify a TRANSACTION within the context of a WORKSTATION and a BUSINESS PERIOD. |
| UnitCount | Quantity | The number of containers, bottles, racks, cases, etc. involved in the deposit or redemption.\nFor example a redemption of $5.00 for 100 aluminum cans - 100 here is the unit count. |
| UnitOfMeasureCode | Code2 | The unit of measures applied for counting the number of units involved in a deposit or\nredemption. Examples include cans, cases, racks, bottles, etc. |
| WorkstationID | Identity | The unique identifier for the WORKSTATION, typically the serial number. |
Tag |
Domain |
Definition |
| DepositPaidOnUnitOfMeasureCode | Code2 | The unit of measure (e.g. each bottle, each case, each rack, etc.) that the customer pays a deposit on at the time of a sale. |
| DepositPaidPerUnitOfMeasureAmount | Money | Th deposit amount paid for each deposit-paid-on-unit-of-measure-code by the consumer at the time an item is purchased. |
| ItemID | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
| ReturnAgentID | Identity | The company to whom the returns for ITEMs, such as empty bottles, are made. |
Tag |
Domain |
Definition |
| Description | DescriptionShort | A textual description of the reason for the DISBURSEMENT or FUNDS RECEIPT |
| DisbursementReceiptReasonCode | Code2 | The reason code for the DISBURSEMENT or the FUNDS RECEIPT. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| StoreFinancialLedgerAccountID | Identity | The reference for p |
Tag |
Domain |
Definition |
| BusinessDayDate | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| DisbursementReceiptReasonCode | Code2 | The reason code for the DISBURSEMENT or the FUNDS RECEIPT. |
| FundDisbursementAmount | Money | The monetary amount of the disbursement transaction. |
| PettyCashPartyId | Identity | Identifies the party receiving the petty cash. |
| PettyCashReceiptRequiredFlag | Flag | A flag that when true indicates that the recipient of a petty cash payment must provide a written receipt as evidence that the transaction was valid. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| TransactionSequenceNumber | Identity | A unique, non-significant, automatically assigned sequential number used\nto identify a TRANSACTION within the context of a WORKSTATION and a BUSINESS PERIOD. |
| WorkstationID | Identity | The unique identifier for the WORKSTATION, typically the serial number. |
Tag |
Domain |
Definition |
| Description | DescriptionShort | A text description of the standard discount types represented in the DISCOUNT\nentity collection. |
| DiscountTypeCode | Code2 | The type code used as a look up key for the standard discount types represented in the DISCOUNT\nentity collection |
| Name | Name | The name of the standard discount types represented in the DISCOUNT\nentity collection. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| StoreFinancialLedgerAccountID | Identity | The reference for the STORE FINANCIAL LEDGER ACCOUNT |
Tag |
Domain |
Definition |
| Amount | Money | The monetary value for the discount line item. |
| BusinessDayDate | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| DiscountTypeCode | Code2 | The type code used as a look up key for the standard discount types represented in the DISCOUNT\nentity collection |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| RetailTransactionLineItemSequenceNumber | LineNumber | The sequence number of line item within a TRANSACTION. |
| TransactionSequenceNumber | Identity | A unique, non-significant, automatically assigned sequential number used\nto identify a TRANSACTION within the context of a WORKSTATION and a BUSINESS PERIOD. |
| WorkstationID | Identity | The unique identifier for the WORKSTATION, typically the serial number. |
Tag |
Domain |
Definition |
| Amount | Money | The monetary value, weight or quantity that establishes the tolerance threshold that when reached will exceed the tolerance for the SUPPLIER and require special approval or remedial action. |
| DiscrepancyRuleID | Identity | A specific rule which defines the nature and amount of the cost, weight or quantity discrepancy. Rules can apply to the entire bill or individual lines and be measured in amount or percentage terms.\n |
| MessageText | DescriptionNarrative | Message to detail the reason for the difference between the billed and ITEM cost amounts, weights or counts.\n |
| Percent | Percent | The monetary value, weight or quantity percent variance between what is ordered and what is received that establishes the tolerance threshold that when reached will exceed the tolerance for the SUPPLIER and require special approval or remedial action. |
| SupplierID | Identity | A code assigned by the retailer to uniquely identify the supplier. |
| TypeCode | Code2 | Determines whether the discrepancy rule applies to cost (in monetary units), weight or quantity (i.e. item count). |
Tag |
Domain |
Definition |
| EmailAddressID | Email address | An electronic address for sending messages.. |
| PartyID | Identity | A unique, automatically assigned identity for a PARTY. |
Tag |
Domain |
Definition |
| CommissionPlanID | Code4 | A unique reference number for an employee's commission plan. This may be the employee's payroll number. |
| EmployeeCompensationTypeCode | Code | |
| EmployeeID | Identity | A unique, non-significant number used to identify a store employee. |
| Name | Name | The full name of the EMPLOYEE. |
| PartyID | Identity | A unique, automatically assigned identity for a PARTY. |
| PartyRoleTypeCode | Code6 | A code that identifies a group of PARTY ROLES. This is used for subtyping the PARTY ROLEs. |
| SocialSecurityNumber | IdentitySocSecurityNumber | The social security number of the EMPLOYEE. |
| StatusCode | Code2Status | The status code regarding the EMPLOYEE, i.e. active or inactive. |
Tag |
Domain |
Definition |
| EffectiveDate | DateCalendar | The date that an EMPLOYEE ASSIGMENT is first valid. |
| EmployeeID | Identity | A unique, non-significant number used to identify a store employee. |
| ExpirationDate | DateCalendar | The date that an employee's assignment is no longer valid. |
| PositionID | Identity | A unique identifier for a specific job. This may or may not be controlled by a centralized HR function. |
| StatusCode | Code2Status | A code that represents the current state of an EMPLOYEE ASSIGNEMENT. |
Tag |
Domain |
Definition |
| Description | DescriptionShort | A textual description of the type of employee's commission plan |
| EmployeeCommissionPlanId | Code4 | A unique reference number for an employee's commission plan. This may be the employee's payroll number. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| StoreFinancialLedgerAccountID | Identity | The reference for the STORE FINANCIAL LEDGER ACCOUNT |
Tag |
Domain |
Definition |
| EmployeeID | Identity | A unique, non-significant number used to identify a store employee. |
| FiscalYear | DateCalendarYear | An identifier that uniquely identifies a particular FISCAL YEAR in CCYY format. |
| LineItemCount | QuantityTransactionCount | The total number of ITEMs discounted as part of EMPLOYEE purchases in each REPORTING PERIOD. |
| MiscellaneousFeeTotalAmount | Money | The total monetary amount of discount granted to EMPLOYEEs for miscellaneous fees in each REPORTING PERIOD. |
| NetSalesTotalAmount | Money | The total monetary amount of net sales resulting from EMPLOYEE purchases in each REPORTING PERIOD. |
| RefundTotalAmount | Money | The total number of refunds made for ITEMs originally purchased as part of an EMPLOYEE discount scheme in each REPORTING PERIOD. |
| ReportingPeriodID | Identity | The identifier for a particular REPORTING PERIOD. |
| ReportingPeriodTypeCode | Code2 | A code to denote a specific REPORTING PERIOD. |
| ReturnTotalAmount | Money | The total monetary amount of refunds made for ITEMs originally purchased as part of an EMPLOYEE discount scheme in each REPORTING PERIOD. |
| TotalAmount | Money | The total monetary amount of discount granted in EMPLOYEE purchases in each REPORTING PERIOD. |
| TotalMiscellaneousFeeCount | QuantityTransactionCount | The total number of miscellaneous fees discounted for EMPLOYLEEs in each REPORTING PERIOD. |
| TotalRefundCount | QuantityTransactionCount | The total number of refunds made for ITEMs originally purchased as part of an EMPLOYEE discount scheme in each REPORTING PERIOD. |
| TotalReturnCount | QuantityTransactionCount | The total number of returns of ITEMs originally purchased as part of an EMPLOYEE discount scheme in each REPORTING PERIOD. |
| TotalTransactionCount | QuantityTransactionCount | The total number of transactions involving EMPLOYEE purchases in a given REPORTING PERIOD. |
Tag |
Domain |
Definition |
| EmployeeDiscountGroupID | Identity | The identifier for a specific EMPLOYEE DISCOUNT GROUP. |
| Name | Name | The name given to a specific EMPLOYEE DISCOUNT GROUP, e.g. store management, part-time employees, etc. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| StoreFinancialLedgerAccountID | Identity | The reference for the STORE FINANCIAL LEDGER ACCOUNT |
Tag |
Domain |
Definition |
| ApplyAfterAllMarkdownsFlag | Flag | A flag to denote whether the EMPLOYEE DISCOUNT is applied after all the ITEM markdowns have been applied. |
| ConcurrenceDispositionCode | Code2 | Determines how the retail price reduction or increase calculated as the result of the application of the PRICE DERIVATION RULE will be handled where more than one rule are applied within a sales transaction. Valid examples of values include: - Compound the price changes; Select the single best deal for the customer (i.e. the one rule that by itself yields the lowest price . |
| CostPlusFlag | Flag | A flag to denote whether the price of the ITEM to the EMPLOYEE is calculated by adding a dollar amount or percent to the cost price. |
| Description | DescriptionShort | Describes the derivation rule for the employee group price discount. |
| EffectiveDateTimestamp | TimeStampEffective | The date and time when the EMPLOYEE DISCOUNT DERIVATION RULE becomes effective. |
| EligibilityDescription | DescriptionShort | Describes this employee-group discount eligibility rule. |
| EmployeeDiscountGroupID | Identity | The identifier for a specific EMPLOYEE DISCOUNT GROUP. |
| EmployeeID | Identity | A unique, non-significant number used to identify a store employee. |
| EventID | Identity | A unique, automatically assigned identifier for each EVENT instance. |
| ExpirationDateTimestamp | TimeStampExpiration | The date and time when the EMPLOYEE DISCOUNT DERIVATION RULE expires. |
| PriceDerivationRuleID | Identity | A identifier for a specific price derivation rule.\n |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
Tag |
Domain |
Definition |
| Amount | Money | The discount amount granted to an EMPLOYEE when making a purchase. The item sales are typically held separately in order to assess whether the EMPLOYEE is abusing the privilege. |
| BusinessDayDate | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| EmployeeDiscountGroupID | Identity | The identifier for a specific EMPLOYEE DISCOUNT GROUP. |
| EmployeeID | Identity | A unique, non-significant number used to identify a store employee. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| RetailTransactionLineItemSequenceNumber | LineNumber | The sequence number of line item within a TRANSACTION. |
| TransactionSequenceNumber | Identity | A unique, non-significant, automatically assigned sequential number used\nto identify a TRANSACTION within the context of a WORKSTATION and a BUSINESS PERIOD. |
| WorkstationID | Identity | The unique identifier for the WORKSTATION, typically the serial number. |
Tag |
Domain |
Definition |
| Description | DescriptionShort | Description associated with this employee discount group. |
| EmployeeDiscountGroupID | Identity | The identifier for a specific EMPLOYEE DISCOUNT GROUP. |
| EmployeeID | Identity | A unique, non-significant number used to identify a store employee. |
| IdentityVerifyRequiredFlag | Flag | A flag to denote whether the identity of the EMPLOYEE has been verified. |
Tag |
Domain |
Definition |
| EffectiveDate | DateCalendar | The date on which an individual assignment in a store becomes effective. |
| EmployeeID | Identity | A unique, non-significant number used to identify a store employee. |
| ExpirationDate | DateCalendar | The date on which an individual assignment in a store expires. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| StatusCode | Code2Status | A code to signify the status of a specific assignment. |
Tag |
Domain |
Definition |
| Description | DescriptionNarrative | A descriptive narrative of the environmental class. |
| EnvironmentClassCode | Code6 | A code that identifies a class environmental properties of a location. For instance, this might describe humidity, temperature, or lighting restrictions or requirements |
Tag |
Domain |
Definition |
| ActualEnd | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| ActualEndDateTimestamp | TimeStampExpiration | Defines the actual time and date when the event terminates. |
| ActualStart | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| ActualStartDateTimestamp | TimeStampEffective | Defines the actual start date and time for an event. |
| Description | DescriptionShort | Describes the event. |
| EventID | Identity | A unique, automatically assigned identifier for each EVENT instance. |
| Name | Name | The business name of the event. |
| OwnerName | Name | Identifies who in the retailer organization owns and is responsible for the EVENT. |
| PlanEndDateTimestamp | TimeStampExpiration | Defines the planned time and date when the event terminates |
| PlanStartDateTimestamp | TimeStampEffective | Defines the planned starting time and date for an event. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| Scheduled Start | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| ScheduledEnd | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| StatusCode | Code2Status | The current status code of the event -- e.g. active, pending, deferred, canceled, etc. |
| StoreOrHomeOfficeControlCode | Code2 | A code to indicate whether the event is controlled by the store or by the home office. |
| TypeCode | Code4 | Identifies the category for the event. Examples include holiday promotion, physical inventory count, Presidents Day, Back to School Sale, Register Roulette, etc. |
Tag |
Domain |
Definition |
| Exchange | Identity | The unique identifier of the CURRENCY. |
| ExchangeRateEffectiveDate | DateCalendar | The date on which a specific exchange rate becomes effective.\n |
| ExchangeRateExpirationDate | DateCalendar | Date on which the exchange rate expires and is no longer valid. |
| MinimumCurrencyAmount | Money | The minimum monetary amount the store will either purchase or sell foreign tender.\n |
| ServiceFeeAmount | Money | The add-on fee, in local currency amounts, imposed on the exchange\n |
| ToBuyAmount | Money | The buying rate of the tender type, based on the store's local currency.\n |
| ToSellAmount | Money | The selling rate of the tender type, based on the store's local currency\n |
Tag |
Domain |
Definition |
| CustomerID | Identity | A unique identifier for a customer. |
Tag |
Domain |
Definition |
| Description | DescriptionShort | Business description of the external depository |
| ExternalDepositoryPartyID | Identity | A unique identifier for an External Depository Party. The identifiers are only unique within this type of PARTY. |
| Name | Name | The business name of the external repository. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| TenderRepositoryID | Identity | The unique identifier for the TENDER RESPOSITORY. |
Tag |
Domain |
Definition |
| BusinessDayDate | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| TenderRepositoryID | Identity | The unique identifier for the TENDER RESPOSITORY. |
| TransactionSequenceNumber | Identity | A unique, non-significant, automatically assigned sequential number used\nto identify a TRANSACTION within the context of a WORKSTATION and a BUSINESS PERIOD. |
| WorkstationID | Identity | The unique identifier for the WORKSTATION, typically the serial number. |
Tag |
Domain |
Definition |
| ExternalDepositoryPartyID | Identity | A unique identifier for an External Depository Party. The identifiers are only unique within this type of PARTY. |
| PartyID | Identity | A unique, automatically assigned identity for a PARTY. |
| PartyRoleTypeCode | Code6 | A code that identifies a group of PARTY ROLES. This is used for subtyping the PARTY ROLEs. |
Tag |
Domain |
Definition |
| BusinessDayDate | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| TransactionSequenceNumber | Identity | A unique, non-significant, automatically assigned sequential number used\nto identify a TRANSACTION within the context of a WORKSTATION and a BUSINESS PERIOD. |
| WorkstationID | Identity | The unique identifier for the WORKSTATION, typically the serial number. |
Tag |
Domain |
Definition |
| OpenBalanceTotalAmount | Money | The monetary amount of the opening balance of TENDER in the EXTERNAL DEPOSITORY at the start of the current deposit..\n |
| OverTenderDiscrepancyAmount | Money | The overage, expressed as an amount, between the actual and recorded tender deposited in the EXTERNAL DEPOSITORY. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| TenderDepositDateTimestamp | TimeStampAudit | The timestamp when tender is deposited in the EXTERNAL DEPOSITORY. \n |
| TenderDepositTotalAmount | Money | The total amount of tender deposited in the EXTERNAL DEPOSITORY.\n |
| TenderReceiptTotalAmount | Money | The total amount of money received from the EXTERNAL DEPOSITORY.\n |
| TenderRepositoryID | Identity | The unique identifier for the TENDER RESPOSITORY. |
| TenderTypeCode | Code4 | A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. |
| TotalTenderDepositCount | QuantityTransactionCount | The total number of TENDER deposits made in the EXTERNAL DEPOSITORY.\n |
| TotalTenderReceiptCount | QuantityTransactionCount | The total number of receipts to the STORE from the EXTERNAL DEPOSITORY.\n |
| UnderTenderDiscrepancyAmount | Money | The shortage, expressed as an amount, between the actual and recorded tender deposited in the EXTERNAL DEPOSITORY.\n |
Tag |
Domain |
Definition |
| BusinessDayDate | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| DepositDateTimestamp | TimeStampAudit | The timestamp when tender is deposited in the EXTERNAL DEPOSITORY for each accumulation period. |
| DepositTotalAmount | Money | The total amount of tender deposited in the EXTERNAL DEPOSITORY for each accumulation period..\n |
| OpenBalanceTotalAmount | Money | The monetary amount of the opening balance of TENDER in the EXTERNAL DEPOSITORY at the start of the accumulation period. |
| OverTenderDiscrepancyAmount | Money | The overage, expressed as an amount, between the actual and recorded tender deposited in the EXTERNAL DEPOSITORY for each accumulation period. |
| ReceiptTotalAmount | Money | The total amount of money received from the EXTERNAL DEPOSITORY in each accumulation period.\n |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| TenderRepositoryID | Identity | The unique identifier for the TENDER RESPOSITORY. |
| TenderTypeCode | Code4 | A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. |
| TotalTenderDepositCount | QuantityTransactionCount | The total number of TENDER deposits made in the EXTERNAL DEPOSITORY for each accumulation period. |
| TotalTenderReceiptCount | QuantityTransactionCount | The total number of receipts to the STORE from the EXTERNAL DEPOSITORY in each accumulation period. |
| TransactionSequenceNumber | Identity | A unique, non-significant, automatically assigned sequential number used\nto identify a TRANSACTION within the context of a WORKSTATION and a BUSINESS PERIOD. |
| UnderTenderDiscrepancyAmount | Money | The shortage, expressed as an amount, between the actual and recorded tender deposited in the EXTERNAL DEPOSITORY for each accumulation period. |
| WorkstationID | Identity | The unique identifier for the WORKSTATION, typically the serial number. |
Tag |
Domain |
Definition |
| FacilityID | Identity | The unique reference for the facility that originated the supply. This facility is a generic term that will normally apply to a warehouse or distribution center. |
| Name | Name | The name by which the FACILITY is known. |
Tag |
Domain |
Definition |
| BusinessDayDate | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| TenderTypeCode | Code4 | A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. |
| TransactionSequenceNumber | Identity | A unique, non-significant, automatically assigned sequential number used\nto identify a TRANSACTION within the context of a WORKSTATION and a BUSINESS PERIOD. |
| TypeCode | Code2 | A code to denote the type of FINANCIAL ACCOUNTING TRANSACTION, e.g. tender loan or pickup.\n |
| WorkstationID | Identity | The unique identifier for the WORKSTATION, typically the serial number. |
Tag |
Domain |
Definition |
| Amount | Money | The monetary value of the FINANCIAL TRANSACTION JOURNAL ENTRY. |
| BusinessDayDate | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| DateTimestamp | TimeStampAudit | The time at which the FINANCIAL TRANSACTION JOURNAL ENTRY is made. |
| DebitCreditCode | Code2 | A code to denote whether the value of the FINANCIAL TRANSACTION JOURNAL ENTRY is debited or credited to the FINANCIAL LEDGER. |
| FinancialTransactionJournalEntryID | Identity | The unique reference of the FINANCIAL TRANSACTION JOURNAL ENTRY. |
| FinancialTransactionJournalEntrySequenceNumber | LineNumber | The sequence number of the FINANCIAL TRANSACTION JOURNAL ENTRY. |
| InventoryControlDocumentID | Identity | The reference number that uniquely identifies the INVENTORY CONTROL DOCUMENT. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| StatusCode | Code2Status | Defines the current status of the FINANCIAL TRANSACTION JOURNAL ENTRY. Examples include pending, booked, etc. |
| StoreFinancialLedgerAccountID | Identity | The reference for the STORE FINANCIAL LEDGER ACCOUNT |
| TransactionSequenceNumber | Identity | A unique, non-significant, automatically assigned sequential number used\nto identify a TRANSACTION within the context of a WORKSTATION and a BUSINESS PERIOD. |
| WorkstationID | Identity | The unique identifier for the WORKSTATION, typically the serial number. |
Tag |
Domain |
Definition |
| CalendarDateTime | TimeStampEffective | A specific date and time within the FISCAL DAY. |
| FiscalDayNumber | DateFiscalDay | The week day part of a fiscal date numbered 1 (Sun) through 7 (Sat) |
| FiscalWeekNumber | DateFiscalWeek | The relative week with in a fiscal year expressed as an integer count. |
| FiscalYear | DateCalendarYear | An identifier that uniquely identifies a particular FISCAL YEAR in CCYY format. |
Tag |
Domain |
Definition |
| FiscalMonth | DateFiscalMonth | A fiscal (financial) month. |
| FiscalQuarterID | DateFiscalQuarter | The identifier which uniquely specifies a FISCAL QUARTER within a specific FISCAL YEAR. |
| FiscalYear | DateCalendarYear | An identifier that uniquely identifies a particular FISCAL YEAR in CCYY format. |
Tag |
Domain |
Definition |
| FiscalQuarterID | DateFiscalQuarter | The identifier which uniquely specifies a FISCAL QUARTER within a specific FISCAL YEAR. |
| FiscalQuarterNumberOfWeeksCount | QuantityMonthCount | The number of weeks within the FISCAL QUARTER. Most retailers use a 13 week quarter, but some apparel retailers use 12 week quarters.\n |
| FiscalYear | DateCalendarYear | An identifier that uniquely identifies a particular FISCAL YEAR in CCYY format. |
Tag |
Domain |
Definition |
| Description | DescriptionShort | A text description applied to a fiscal week. |
| FiscalMonth | DateFiscalMonth | A fiscal (financial) month. |
| FiscalWeekNumber | DateFiscalWeek | The relative week with in a fiscal year expressed as an integer count. |
| FiscalYear | DateCalendarYear | An identifier that uniquely identifies a particular FISCAL YEAR in CCYY format. |
| SeasonCode | Code2 | A unique identifier for the SEASON and year. |
| SubseasonCode | Code2 | A code for a specific subseason. This is normally stated as SUBSEASON, within SEASON, within FISCAL YEAR. |
Tag |
Domain |
Definition |
| BeginningDate | DateCalendar | The start date of the FISCAL YEAR. |
| CalendarYear | DateCalendarYear | The calendar year which spans 52 weeks starting at the first FISCAL WEEK in the new year.\n |
| FiscalYear | DateCalendarYear | An identifier that uniquely identifies a particular FISCAL YEAR in CCYY format. |
| NumberOfMonthsCount | QuantityMonthCount | The number of fiscal months in a FISCAL YEAR. Most retailers will operate 12 FISCAL MONTHS, although some will operate 13. |
Tag |
Domain |
Definition |
| Amount | Money | A tender line item identifying the foreign currency tendered by the CUSTOMER as payment. |
| BusinessDayDate | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| RetailTransactionLineItemSequenceNumber | LineNumber | The sequence number of line item within a TRANSACTION. |
| TransactionSequenceNumber | Identity | A unique, non-significant, automatically assigned sequential number used\nto identify a TRANSACTION within the context of a WORKSTATION and a BUSINESS PERIOD. |
| WorkstationID | Identity | The unique identifier for the WORKSTATION, typically the serial number. |
Tag |
Domain |
Definition |
| CarrierID | Identity | The carrier presenting the bill of lading. |
| CarrierWeightRestrictionCode | Code2 | A code to denote the maximum weight of each carton that can be handled by the carrier. |
| FreightBillID | Identity | The carrier-assigned shipping document number |
| SerialFormID | String | An identifier for this document, usually preprinted on the form stock prior to being filled out. |
| ShippedCartonCount | Quantity | The number of cartons listed on the FREIGHT BILL. \n |
| SpecialHandlingCode | Code2 | A code that specifies special handling instructions. |
| SpecialHandlingMessage | DescriptionNarrative | Free form additional description of special handling conditions if special handling code inadequate. |
| Status | Code2Status | The status of the receiving event: scheduled, initiated, completed, processed, reviewed, modified. |
| StoreCartonCount | Quantity | The number of cartons as established by the store. |
| StoreReceiptTime | TimeStampAudit | The time and date when the freight is received at the store. |
| SupplierID | Identity | A code assigned by the retailer to uniquely identify the supplier. |
Tag |
Domain |
Definition |
| BusinessDayDate | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| DisbursementReceiptReasonCode | Code2 | The reason code for the DISBURSEMENT or the FUNDS RECEIPT. |
| FundReceiptMonetaryAmount | Money | The monetary amount of the receipt transaction. |
| FundsReceiptPartyID | Identity | The identifier for the party who submitted the FUNDS RECEIPT. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| TransactionSequenceNumber | Identity | A unique, non-significant, automatically assigned sequential number used\nto identify a TRANSACTION within the context of a WORKSTATION and a BUSINESS PERIOD. |
| WorkstationID | Identity | The unique identifier for the WORKSTATION, typically the serial number. |
Tag |
Domain |
Definition |
| DonorAddress | Address | The address where the GIFT CERTIFICATE donor resides. |
| DonorCity | City | The city where the GIFT CERTIFICATE donor resides. |
| DonorName | Name | The name of the GIFT CERTIFICATE donor. |
| DonorPostalCode | PostalCode | The postal or zip code component of the address where the GIFT CERTIFICATE donor resides. |
| DonorState | State | The state in which the GIFT CERTIFICATE donor resides. |
| DonorTelephoneAreaCode | PhoneNumberAreaCode | The telephone area code of the GIFT CERTIFICATE donor. |
| DonorTelephoneCountryCode | PhoneNumberCountryCode | The telephone country code of the GIFT CERTIFICATE donor. |
| DonorTelephoneLocalNumber | PhoneNumberLocal | The telephone local number of the GIFT CERTIFICATE donor. |
| ExpirationDate | DateCalendar | The expiration date when the GIFT CERTIFICATE can no longer be tendered. |
| FaceValueAmount | Money | The monetary value printed or embossed on the GIFT CERTIFICATE.\n |
| GiftCertificateSerialNumber | Name | The serial number that uniquely identifies a GIFT CERTIFICATE.\n |
| GiftCertificateTypeCode | Code2 | Identifies a gift certificate type. |
| IssueDateTimestamp | TimeStampEffective | The time and date when the gift certificate was issued by the RETAIL STORE to the CUSTOMER. |
| IssueTypeCode | Code2 | A code to denote how GIFT CERTIFICATEs are issued by the RETAIL STORE, e.g. embossed or printed at the point of sale.\n |
| IssuingStoreNumber | Identity | A unique store number reference to identify the RETAIL STORE that issued the GIFT CERTIFICATE.\n |
| UnspentBalanceAmount | Money | The monetary value of the unspent amount outstanding on a specific GIFT CERTIFICATE.\n |
Tag |
Domain |
Definition |
| BusinessAffiliateName | Name | Identifies the business affiliate (i.e. a mall, another peer store, a union, etc.) on whose behalf this type of gift certificate is set up. |
| FormID | Identity | Identifies the format and type of paper used to print this type of gift certificate. |
| GiftCertificateTypeCode | Code2 | Identifies a gift certificate type. |
| RedemptionPeriodDayCount | QuantityDayCount | Defines the number of days this gift certificate remains outstanding and redeemable. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| StoreFinancialLedgerAccountID | Identity | The reference for the STORE FINANCIAL LEDGER ACCOUNT |
| TypeDescription | DescriptionShort | Describes a gift certificate type |
| UnspentBalanceDispositionCode | Code4 | Defines how the unspent balance for a gift certificate is to be handled. Options are to pay the balance back to the customer as cash, issue a 2nd gift certificate for the remaining balance, etc. |
Tag |
Domain |
Definition |
| BusinessDayDate | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| GiftCertificateSerialNumber | Name | The serial number that uniquely identifies a GIFT CERTIFICATE.\n |
| IssuingStoreNumber | Identity | A unique store number reference to identify the RETAIL STORE that issued the GIFT CERTIFICATE.\n |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| RetailTransactionLineItemSequenceNumber | LineNumber | The sequence number of line item within a TRANSACTION. |
| ScannedOrKeyedCode | Code2 | A code that indicates whether the serial number for the gift certificate was keyed or scanned. |
| TransactionSequenceNumber | Identity | A unique, non-significant, automatically assigned sequential number used\nto identify a TRANSACTION within the context of a WORKSTATION and a BUSINESS PERIOD. |
| WorkstationID | Identity | The unique identifier for the WORKSTATION, typically the serial number. |
Tag |
Domain |
Definition |
| BusinessDayDate | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| GiftCertificateSerialNumber | Name | The serial number that uniquely identifies a GIFT CERTIFICATE.\n |
| IssuingStoreNumber | Identity | A unique store number reference to identify the RETAIL STORE that issued the GIFT CERTIFICATE.\n |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| RetailTransactionLineItemSequenceNumber | LineNumber | The sequence number of line item within a TRANSACTION. |
| TransactionSequenceNumber | Identity | A unique, non-significant, automatically assigned sequential number used\nto identify a TRANSACTION within the context of a WORKSTATION and a BUSINESS PERIOD. |
| WorkstationID | Identity | The unique identifier for the WORKSTATION, typically the serial number. |
Tag |
Domain |
Definition |
| CustomerID | Identity | A unique identifier for a customer. |
| CustomerOccasionDate | DateCalendar | The start date of a an event or other occasion that a customer celebrates. |
| CustomerOccasionTypeName | Name | A short label for a group of CUSTOMER OCCASIONs. For instance, this could be a wedding, a high school graduation, a birthday, a golden wedding anniversary, etc. |
| DesiredQuantity | QuantityShortCount | The quantity of ITEMs that are asked for in the GIFT REGISTRATION. |
| ItemID | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
Tag |
Domain |
Definition |
| BusinessDayDate | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| CustomerID | Identity | A unique identifier for a customer. |
| CustomerOccasionDate | DateCalendar | The start date of a an event or other occasion that a customer celebrates. |
| CustomerOccasionTypeName | Name | A short label for a group of CUSTOMER OCCASIONs. For instance, this could be a wedding, a high school graduation, a birthday, a golden wedding anniversary, etc. |
| ItemID | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
| Quantity | Quantity | The number of items purchased for the GIFT REGRISTRATION on this line item. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| RetailTransactionLineItemSequenceNumber | LineNumber | The sequence number of line item within a TRANSACTION. |
| TransactionSequenceNumber | Identity | A unique, non-significant, automatically assigned sequential number used\nto identify a TRANSACTION within the context of a WORKSTATION and a BUSINESS PERIOD. |
| WorkstationID | Identity | The unique identifier for the WORKSTATION, typically the serial number. |
Tag |
Domain |
Definition |
| GroupReadAccessLevelFlag | Code2 | A flag to indicate whether read access is granted to the referenced GROUP for the corresponding RESOURCE identified in this record.\n |
| GroupWriteAccessLevelFlag | Code2 | A flag to signify whether write access is granted to the referenced GROUP for the corresponding RESOURCE identified in this record.\n |
| ResourceID | Identity | A code to uniquely identify a given application or application component.\n |
| WorkGroupID | Identity | A unique identifier for a work classification group to which EMPLOYEEs are assigned. |
Tag |
Domain |
Definition |
| EmployeeID | Identity | A unique, non-significant number used to identify a store employee. |
Tag |
Domain |
Definition |
| InventoryAdjustmentDocumentID | Identity | A unique identifier for an INVENTORY ADJUSTMENT DOCUMENT which lists adjustments between actual and notified amounts.\n |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
Tag |
Domain |
Definition |
| InventoryAdjustmentDocumentID | Identity | A unique identifier for an INVENTORY ADJUSTMENT DOCUMENT which lists adjustments between actual and notified amounts.\n |
| InventoryAdjustmentLineNumber | LineNumber | The line number for a specific line item adjustment.\n |
| ReasonCode | Code2 | The reason code for the line item adjustment.\n |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| Stock | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
Tag |
Domain |
Definition |
| InboundDescription | DescriptionShort | A textual description of the condition of the shipment.\n |
| InventoryConditionCode | Code4 | A code which uniquely identifies the condition for inventory being received, stored or shipped out by a retail store. These codes will signify good, broken, damaged, wrong, partial shipment, overage, etc. This code relates to the UCC code, Receiving Condition Code, data element 412. \n\n\n\n\n |
Tag |
Domain |
Definition |
| ActualDeliveryDate | DateCalendar | The actual delivery date of the shipment, to which this particular inventory control document relates. |
| CompleteDateTimestamp | TimeStampAudit | The time and date when the processing of the inventory control document was completed. |
| ContractReferenceNumber | Identity | The contract against which the delivery has been made. |
| CreateDateTimestamp | TimeStampAudit | The time and date when the inventory control document was originally created. |
| DeferredPaymentDate | DateCalendar | The deferred payment date on which the RETIL STORE has to make its payment. Deferred payments are an inducement to retailers to accept certain stock. |
| DocumentTypeCode | Code2 | This code identifies the type of INVENTORY CONTROL DOCUMENT. |
| ExpectedDeliveryDate | DateCalendar | The expected delivery date of the shipment, to which this particular inventory control document relates. |
| FacilityID | Identity | The unique reference for the facility that originated the supply. This facility is a generic term that will normally apply to a warehouse or distribution center. |
| FreightChargeDispositionCode | Code4 | A code that assigns responsibility for payment of the freight and insurance charges for this inventory control document to the store or other party in the transaction. |
| FromPartyID | Identity | The party that originated the inventory control document. |
| InventoryControlDocumentID | Identity | The reference number that uniquely identifies the INVENTORY CONTROL DOCUMENT. |
| InventoryControlDocumentType | Identity | The unique identifier of the CURRENCY. |
| LastUpdateDate | DateCalendar | The date when the inventory control document was last updated by the store. |
| OriginatorID | Identity | Identifies the point of origin for this inventory control document. An originator may be a program (for automatically generated documents) or a person. |
| PackingSlipID | Identity | the unique identifier for the packing slip, typically the reference number. |
| ReceivedDifferenceCode | Code2 | A code to indicate the reason for the difference between the quantity ordered and quantity shipped. This code relates to the UCC code, Shipment/Order Status Code, data element 368. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| SerialFormID | String | An idenfier for this document, usually preprinted on the form stock prior to being filled out. |
| SupplierActualShipDate | DateCalendar | The actual ship date of the shipment, to which this particular inventory control document relates. The actual date of the to which this particular inventory control document relates, is expected to be shipped from the originating company or store. |
| SupplierExpectedShipDate | DateCalendar | The expected arrival date of the shipment, to which this particular inventory control document relates. |
| SupplierID | Identity | A code assigned by the retailer to uniquely identify the supplier. |
| TermsAndConditionsCode | Code4 | This code denotes the relevant terms and conditions pertaining to this particular inventory control document, eg the supplier must be notified of any shortages within three days. |
| ToPartyID | Identity | The name and address of the party to whom the inventory control is directed for the purposes of receiving, transferring or ordering of merchandise. |
| UnitDiscrepancyCount | Quantity | The discrepancy count between the units recorded on the INVENTORY CONTROL DOCUMENT and the actual units counted. |
Tag |
Domain |
Definition |
| Amount | Money | The monetary allowance made by the supplier against a specific line on the INVENTORY CONTROL DOCUMENT. |
| InventoryControlDocumentID | Identity | The reference number that uniquely identifies the INVENTORY CONTROL DOCUMENT. |
| InventoryControlDocumentLineNumber | LineNumber | The INVENTORY CONTROL DOCUMENT LINE NUMBER specifies the line number within the INVENTORY CONTROL DOCUMENT. |
| ReasonCode | Code2 | The reason code for applying the allowance. |
| RetailerSerialFormID | String | An idenfier for this document, usually preprinted on the form stock prior to being filled out. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| SupplierAllowanceNumber | Identity | The number assigned by the supplier referencing an allowance, promotion or deal. |
| TypeCode | Code2 | This code defines the type of allowance. For ARTS purposes the UCC-defined codes, data elements 150 and 340, are used as the basis for the domain of this attribute. |
Tag |
Domain |
Definition |
| Amount | Money | The monetary charge levied against a specific line on the INVENTORY CONTROL DOCUMENT. |
| InventoryControlDocumentID | Identity | The reference number that uniquely identifies the INVENTORY CONTROL DOCUMENT. |
| InventoryControlDocumentLineNumber | LineNumber | The INVENTORY CONTROL DOCUMENT LINE NUMBER specifies the line number within the INVENTORY CONTROL DOCUMENT. |
| ReasonCode | Code2 | The reason code for the levy of this charge, eg price labeling the merchandise prior to shipment. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| SupplierChargeNumber | Identity | The number assigned by the supplier referencing the charge. |
| TypeCode | Code2 | This code defines the type of charge. For ARTS purposes the UCC-defined codes, as per data elements 150 and 340, are used as the basis for the domain of this attribute. |
Tag |
Domain |
Definition |
| CostAmount | Money | The freight charges. |
| CostCode | Code2 | A code to signify whether the freight cost is met by the retailer or supplier. |
| InventoryControlDocumentID | Identity | The reference number that uniquely identifies the INVENTORY CONTROL DOCUMENT. |
| InventoryControlDocumentLineNumber | LineNumber | The INVENTORY CONTROL DOCUMENT LINE NUMBER specifies the line number within the INVENTORY CONTROL DOCUMENT. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
Tag |
Domain |
Definition |
| DocumentLineItemID | Identity | The INVENTORY CONTROL DOCUMENT LINE ID identifies the ID for a specific line number within the INVENTORY CONTROL DOCUMENT. |
| DocumentTypeCode | Code2 | The DOCUMENT LINE ITEM CODE TYPE CODE specifies the item type. |
| InventoryControlDocumentID | Identity | The reference number that uniquely identifies the INVENTORY CONTROL DOCUMENT. |
| InventoryControlDocumentLineNumber | LineNumber | The INVENTORY CONTROL DOCUMENT LINE NUMBER specifies the line number within the INVENTORY CONTROL DOCUMENT. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
Tag |
Domain |
Definition |
| ChangeReasonCode | Code2 | A code that defines the reason for the difference between the quantity ordered and quantity shipped for a line item.This code relates to the UCC code, Line Item Change Reason Code, data element 892. |
| CostPerUnitTypeCode | Code2 | Defines the unit type the owned attribute costs are assigned to for this item. Valid unit types include: SALE UNIT, PACK UNIT and SHIP UNIT. A single SUPPLIER ITEM may in effect have 1 to three SUPPLIER ITEM BASE COST entities associated with it. |
| DamagedUnitCount | Quantity | A count of the damaged item units (in the item-cost-per-unit-type) received or shipped in this document line item. This count when subtracted from the document-line-item-unit-count yields the number received or shipped in good condition. |
| DocPreticketedFlag | Flag | A flag indicating whether this line item has been preticketed by the SUPPLIER. |
| InventoryConditionCode | Code4 | A code which uniquely identifies the condition for inventory being received, stored or shipped out by a retail store. These codes will signify good, broken, damaged, wrong, partial shipment, overage, etc. This code relates to the UCC code, Receiving Condition Code, data element 412. \n\n\n\n\n |
| InventoryControlDocumentID | Identity | The reference number that uniquely identifies the INVENTORY CONTROL DOCUMENT. |
| InventoryControlDocumentLineNumber | LineNumber | The INVENTORY CONTROL DOCUMENT LINE NUMBER specifies the line number within the INVENTORY CONTROL DOCUMENT. |
| ItemID | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
| LocationID | Identity | A unique identifier for a specific LOCATION within the RETAIL STORE. |
| PrepricedFlag | Flag | A flag indicating whether or not the item is prepriced by the manufacturer. |
| PurchaseOrder | Identity | The reference number that uniquely identifies the INVENTORY CONTROL DOCUMENT. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| UnitBaseCostAmount | Money | The cost of the merchandise by itself exclusive of shipping and handling, duties and import fees, insurance, taxes and other logistic expenses that a store incurs to bring the item into the store. |
| UnitCount | Quantity | A count of all item units (in the item-cost-per-unit-type) received or shipped in this document line item. |
| UnitNetCostAmount | Money | The cost of the merchandise by itself plus shipping and handling, duties and import fees, insurance, taxes and other logistic expenses that a store incurs to bring the item into the store; and less any discounts or allowances allocated to the line item (hence the term NET). |
| UnitsShippedCount | Quantity | The count of units shipped versus the receiving count. This is subtracted from the document-line-item-unit-count to yield an over/under variance between what a supplier said was shipped and what was counted and received at by the store's staff. |
Tag |
Domain |
Definition |
| AccountingDispositionCode | Code4 | The code to denote as to how the amendment resulting from the INVENTORY DOCUMENT MERCHANDISE LINE ITEM MODIFIER will be accounted for within the STOCK LEDGER.\n |
| AllowanceOrChargeCode | Code2 | A code to denote whether a charge or allowance is applied to a specific merchandise control document line. |
| InventoryControlDocumentID | Identity | The reference number that uniquely identifies the INVENTORY CONTROL DOCUMENT. |
| InventoryControlDocumentLineModifierNumber | LineNumber | A reference number against which a specific instance of a modifier is applied. |
| InventoryControlDocumentLineNumber | LineNumber | The INVENTORY CONTROL DOCUMENT LINE NUMBER specifies the line number within the INVENTORY CONTROL DOCUMENT. |
| MonetaryAmount | Money | The monetary amount amendment resulting from the INVENTORY DOCUMENT MERCHANDISE LINE ITEM MODIFIER. |
| Percent | Percent | The percent amendment resulting from the INVENTORY DOCUMENT MERCHANDISE LINE ITEM MODIFIER. |
| ReasonCode | Code2 | The code which denotes the reason for the change made to a specific INVENTORY CONTROL DOCUMENT MERCHANDISE LINE ITEM.\n |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
Tag |
Domain |
Definition |
| ReferTo | Identity | The reference number that uniquely identifies the INVENTORY CONTROL DOCUMENT. |
| ReferToBy | Identity | The reference number that uniquely identifies the INVENTORY CONTROL DOCUMENT. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
Tag |
Domain |
Definition |
| InventoryControlDocumentID | Identity | The reference number that uniquely identifies the INVENTORY CONTROL DOCUMENT. |
| InventoryControlDocumentLineNumber | LineNumber | The INVENTORY CONTROL DOCUMENT LINE NUMBER specifies the line number within the INVENTORY CONTROL DOCUMENT. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| TaxRateCode | Code4 | A code which refers to the tax rate to be applied to the specific line item on the INVENTORY CONTROL DOCUMENT. |
| TaxTypeCode | Code2 | A code to denote the tax type that refers to the line item on the INVENTORY CONTROL DOCUMENT, eg VAT. |
Tag |
Domain |
Definition |
| AccountingDate | DateCalendar | The accounting date within which the INVENTORY TRANSACTION JOURNAL ENTRY is recorded. |
| BusinessDayDate | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| DateTimestamp | TimeStampAudit | The time and date when the INVENTORY TRANSACTION JOURNAL ENTRY is recorded.\n |
| InventoryAdjustmentDocumentID | Identity | A unique identifier for an INVENTORY ADJUSTMENT DOCUMENT which lists adjustments between actual and notified amounts.\n |
| InventoryAdjustmentLineNumber | LineNumber | The line number for a specific line item adjustment.\n |
| InventoryControlDocumentID | Identity | The reference number that uniquely identifies the INVENTORY CONTROL DOCUMENT. |
| InventoryControlDocumentLineNumber | LineNumber | The INVENTORY CONTROL DOCUMENT LINE NUMBER specifies the line number within the INVENTORY CONTROL DOCUMENT. |
| InventoryTransactionJournalId | Identity | A unique identifier for the INVENTORY TRANSACTION JOURNAL. |
| ItemID | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
| LocationID | Identity | A unique identifier for a specific LOCATION within the RETAIL STORE. |
| PhysicalCountDocumentID | Identity | The identifier for the physical count document on which the actual item counts are recorded.\n |
| PhysicalItemCountLineNumber | Identity | The physical count line item.\n |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| RetailTransactionLineItemSequenceNumber | LineNumber | The sequence number of line item within a TRANSACTION. |
| RetailUnitAllowanceAmount | Money | The allowance permitted between the actual count and the inventory on hand unit amount.\n |
| RetailUnitCount | Quantity | The actual number of units of a specific ITEM.\n |
| RetailUnitCurrentSellingPriceAmount | Money | The actual monetary amount charged to the customer in exchange for ITEMs.\n |
| RetailUnitMarkdownAmount | Money | The monetary amount of the markdown applied to the retail price.\n |
| StockLedgerActionCode | Code4 | Defines the action taken against a specific stock ledger item location\nby the source transaction. |
| TransactionSequenceNumber | Identity | A unique, non-significant, automatically assigned sequential number used\nto identify a TRANSACTION within the context of a WORKSTATION and a BUSINESS PERIOD. |
| WorkstationID | Identity | The unique identifier for the WORKSTATION, typically the serial number. |
Tag |
Domain |
Definition |
| AuthorizedForSaleFlag | Flag | A flag to indicate that the RETAIL STORE is authorized to stock this particular ITEM. |
| BrandName | Name | A unique name to denote a class of ITEMs as a product of a single supplier or manufacturer. The brand can include private label ITEMs. |
| Description | DescriptionShort | The textural description of the ITEM and its characteristics. |
| DiscountFlag | Flag | A flag to indicate whether this ITEM can be discounted. |
| FiscalYear | DateCalendarYear | An identifier that uniquely identifies a particular FISCAL YEAR in CCYY format. |
| ItemID | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
| KitSetCode | Code2 | This code signifies this ITEM is provided as a kit which has to made up either by the customer or by the store at an additional cost. |
| MerchandiseHierarchyLevelCode | Code4 | Identifies a hierarchy level within a summarization tree structure for merchandise sales analysis and merchandise classification. The values for this attribute will be standardized within the ARTS Data Model. |
| MerchandiseStructureID | Identity | Unique identifier for a merchandise structure. |
| Name | Name | The name by which the ITEM is known. |
| OrderCollectionCode | Code2 | A code to signify that this ITEM is ordered as part of a collection of ITEMs. |
| POSDepartmentID | Identity | The point-of-sale department number. |
| PriceAuditFlag | Flag | A flag to denote whether this ITEM was validated (scanned) during verification of the ITEM table. |
| PriceLineID | Identity | A unique identifier for this price point.\n |
| SeasonCode | Code2 | A unique identifier for the SEASON and year. |
| SubseasonCode | Code2 | A code for a specific subseason. This is normally stated as SUBSEASON, within SEASON, within FISCAL YEAR. |
| SubstituteIdentifiedFlag | Flag | An ITEM for which there is a substitute available for sale within the RETAIL STORE. |
| TaxExemptCode | Code2 | A code to denote the tax exemption status from sales and use tax. The codes refer to the UCC code, Tax Exempt Code, defined in data element 441. |
| TaxGroupID | Identity | A tax group which links a TAX AUTHORITY to the merchandise to which the tax applies. |
| TypeCode | Code4 | This code indicates whether the item is a STOCK ITEM or SERVICE ITEM. |
| UsageCode | Code2 | This code defines how this item may be used within a store. Usage is a function of how an item may be consumed or disposed of by the store. |
Tag |
Domain |
Definition |
| CaseCodePackCount | Quantity | The number of units in the case for the alternate ITEM. |
| ColorCode | Code4 | A code to identify the color. The assumption is that the retailer will adopt the standards as designated by the NRF, created to facilitate the exchange of data between vendors and retailers |
| Description | DescriptionShort | The textual description for the alternate ITEM. |
| ItemID | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
| RetailItemAlternateID | Identity | An alternate identifying number or code for an item. |
| SizeCode | Code6 | A code to designate the size of the ITEM. It is proposed to use the 5 apparel and miscellaneous coding structure as specified by the NRMA to facilitate data interchange between vendors and retailers. This code permits the use of both standard and proprietary coding format. |
| StyleCode | Code4 | A code that uniquely identifies the specific appearance type or variety in which an APPAREL ITEM is available. |
| UsageCode | Code2 | A code that defines how this ITEM ALTERNATE IDENTITY is to be used. |
Tag |
Domain |
Definition |
| Collection | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
| ItemCollectionId | Identity | A unique identifier given to a specific ITEM COLLECTION. |
| MemberCollection | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
| PerAssemblyCount | Quantity | The number of individual constituent ITEMs within the ITEM COLLECTION. |
| TypeCode | Code2 | A code to denote the type of ITEM COLLECTION. |
Tag |
Domain |
Definition |
| EventID | Identity | A unique, automatically assigned identifier for each EVENT instance. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
Tag |
Domain |
Definition |
| EventID | Identity | A unique, automatically assigned identifier for each EVENT instance. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
Tag |
Domain |
Definition |
| EventID | Identity | A unique, automatically assigned identifier for each EVENT instance. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
Tag |
Domain |
Definition |
| ItemID | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
| LabelID | Identity | A unique identifier for a specific ITEM LABEL. |
| LocationID | Identity | A unique identifier for a specific LOCATION within the RETAIL STORE. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
Tag |
Domain |
Definition |
| EventID | Identity | A unique, automatically assigned identifier for each EVENT instance. |
| ItemID | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
| LabelID | Identity | A unique identifier for a specific ITEM LABEL. |
| LocationID | Identity | A unique identifier for a specific LOCATION within the RETAIL STORE. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| TypeCode | Code2 | Identifies the type of label to be created for the associated item maintenance event. |
Tag |
Domain |
Definition |
| ItemID | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
| ItemLotID | Identity | An identifier for a LOT of specific ITEMs. |
Tag |
Domain |
Definition |
| CustomerAccountID | Identity | A unique identifier for a customer account. Generally assigned by the home office. |
| ItemID | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
Tag |
Domain |
Definition |
| EventID | Identity | A unique, automatically assigned identifier for each EVENT instance. |
| FunctionCode | Code2 | Defines the maintenance action taken by this ITEM - MAINTENANCE EVENT against an ITEM. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
Tag |
Domain |
Definition |
| PriceDerivationRuleID | Identity | A identifier for a specific price derivation rule.\n |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| SaleUnitMonetaryAmount | Money | The monetary amount to be added to or subtracted from a base retail price. |
| SaleUnitPercent | Percent | The percentage of the base retail to be added to or subtracted from a base retail to arrive at the price paid by the customer. |
Tag |
Domain |
Definition |
| AccountingDispositionCode | Code4 | Determines whether the price derivation for this rule is treated as a revaluation of merchandise (in which case it impacts the stock ledger) or an expense (in which case it impacts the store financial ledger). |
| ConcurrenceDispositionCode | Code4 | Determines how the retail price reduction or increase calculated as the result of the application of the PRICE DERIVATION RULE will be handled where more than one rule are applied within a sales transaction. Valid examples of values include: - Compound the price changes; Select the single best deal for the customer (i.e. the one rule that by itself yields the lowest price . |
| EffectiveDateTimestamp | TimeStampEffective | The time and date this rule is activated and may be applied |
| EventID | Identity | A unique, automatically assigned identifier for each EVENT instance. |
| ExpirationDateTimestamp | TimeStampExpiration | The time and day this rule is no longer valid. |
| ItemID | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
| PriceDerivationRuleID | Identity | A identifier for a specific price derivation rule.\n |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| StoreFinancialLedgerAccountID | Identity | The reference for the STORE FINANCIAL LEDGER ACCOUNT |
Tag |
Domain |
Definition |
| EventID | Identity | A unique, automatically assigned identifier for each EVENT instance. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| TypeCode | Code2 | A code to denote how the permanent price is actioned, ie global or individual ITEM amendment.\n |
Tag |
Domain |
Definition |
| PriceDerivationRuleID | Identity | A identifier for a specific price derivation rule.\n |
| RetailSaleUnitPricePointMonetaryAmount | Money | The monetary value of a retail sale unit that replaces the base retail price. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
Tag |
Domain |
Definition |
| EndDayOfWeekCode | DateFiscalDay | A code to denote the end date in the week for the item sales restriction. |
| EndTime | Time | A code to denote the end time on a specified day for the item sales restriction. |
| SalesRestrictionCode | Code6 | A unique, automatically assigned code for a specific limitation on an ITEM's sale. |
| SalesRestrictionTypeCode | Code4 | A unique code for a group of SALES RESTRICTIONS. |
| StartDayOfWeekCode | DateFiscalDay | A code to denote the start date in the week for the item sales restriction. |
| StartTime | Time | A code to denote the start time on a specified day for the item sales restriction. |
Tag |
Domain |
Definition |
| FiscalYear | DateCalendarYear | An identifier that uniquely identifies a particular FISCAL YEAR in CCYY format. |
| ItemID | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
| ReportingPeriodID | Identity | The identifier for a particular REPORTING PERIOD. |
| ReportingPeriodTypeCode | Code2 | A code to denote a specific REPORTING PERIOD. |
| TotalEmployeeDiscountAmount | Money | The total monetary value of ITEMs sold with an employee discount in the REPORTING PERIOD. |
| TotalEmployeeDiscountCount | QuantityTransactionCount | The total number of items sold with an employee discount in the REPORTING PERIOD. |
| TotalItemAmount | Money | The total monetary amount of ITEMs sold within the REPORTING PERIOD. |
| TotalItemCount | QuantityTransactionCount | The total number of ITEMs sold within the REPORTING PERIOD. |
| TotalMarkdownAmount | Money | The total value of ITEM markdowns sold within the REPORTING PERIOD. |
| TotalMarkdownCount | QuantityTransactionCount | The total number of items marked down within the REPORTING PERIOD. |
| TotalMiscellaneousDiscountAmount | Money | The total monetary value of ITEM miscellaneous discounts in the REPORTING PERIOD. |
| TotalMiscellaneousDiscountCount | QuantityTransactionCount | The total number of items sold with a miscellaneous discount in the REPORTING PERIOD. |
| TotalReturnAmount | Money | The monetary value of ITEMs' returns within the REPORTING PERIOD. |
| TotalReturnCount | QuantityTransactionCount | The total number of ITEM returns within the REPORTING PERIOD. |
| TotalVoidAmount | Money | The total monetary value of voided of items sold within the REPORTING PERIOD. |
| TotalVoidCount | QuantityTransactionCount | The total number of items voided within the REPORTING PERIOD. |
Tag |
Domain |
Definition |
| EffectiveDateTimestamp | TimeStampEffective | The date and date on which a specific price change became effective. |
| EndDateTimestamp | TimeStampExpiration | The date and time when an ITEM price no longer applied. |
| EventID | Identity | A unique, automatically assigned identifier for each EVENT instance. |
| ItemID | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
| ItemRetailPriceSequenceNumber | LineNumber | The reference number that applies to each occurrence of a price change. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| UnitRetailPriceAmount | MoneyShortRetail | The historical unit retail price of an item associated with an event. |
Tag |
Domain |
Definition |
| ItemID | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
| LabelID | Identity | A unique identifier for a specific ITEM LABEL. |
| LocationID | Identity | A unique identifier for a specific LOCATION within the RETAIL STORE. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
Tag |
Domain |
Definition |
| Description | DescriptionShort | The description of a group of TENDER RESTRICTIONs which apply to specific ITEMs.\n |
| ItemTenderRestrictionGroupCode | Code2 | A code to denote a specific group of ITEM TENDER RESTRICTIONs. \n |
| Name | Name | The name of a specific group of TENDER RESTRICTIONs which apply to specific ITEMs, eg WICs cannot be used to purchase tobacco or alcohol ITEMs.\n |
Tag |
Domain |
Definition |
| Description | DescriptionShort | A description of the rule that prohibits the purchase of specific ITEMs with certain tender types. |
| EffectiveDate | DateCalendar | The date on which the ITEM TENDER RESTRICTION becomes effective. |
| ExpirationDate | DateCalendar | the date on which the tender restriction on specific STOCK ITEM expires. |
| ItemTenderRestrictionGroupCode | Code2 | A code to denote a specific group of ITEM TENDER RESTRICTIONs. \n |
| Name | Name | The rule that prohibits the purchase of certain ITEMs by certain tender types. |
| StatusCode | Code2Status | A code to indicate whether the restriction rule applies to a certain ITEM or not. |
| TenderTypeCode | Code4 | A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. |
Tag |
Domain |
Definition |
| ItemID | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
| LabelID | Identity | A unique identifier for a specific ITEM LABEL. |
| LocationID | Identity | A unique identifier for a specific LOCATION within the RETAIL STORE. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
Tag |
Domain |
Definition |
| Description | DescriptionNarrative | A narrative that describes the functions and responsibilities of a JOB. |
| JobCode | Code6 | A unique identifier for a JOB or funcation. |
| Name | Name | A name or label that describes a JOB. |
Tag |
Domain |
Definition |
| CustomerID | Identity | A unique identifier for a customer. |
Tag |
Domain |
Definition |
| CustomerID | Identity | A unique identifier for a customer. |
| KeyCustomerID | Identity | A unique identifier for a customer. |
| TypeCode | String | A grouping of clients based on the relationship between the key customer and the client. |
Tag |
Domain |
Definition |
| Description | String | A narrative that describes the restriction of sales to those holding a license or certification. |
| SalesRestrictionCode | Code6 | A unique, automatically assigned code for a specific limitation on an ITEM's sale. |
| SalesRestrictionTypeCode | Code4 | A unique code for a group of SALES RESTRICTIONS. |
Tag |
Domain |
Definition |
| FunctionCode | Code6 | A code that describes what business activities and functions are performed in a specific location.\n\nActivities may include:\nADMIN - Administration functions (no stock or customer services are handled here)\nDISPLY - Merchandise display (stock is presented to the customer for sale)\nCUSTSVC - Customer service - Customer merchandise may be picked up, returned, etc. \nRETADJ - Returns and adjustments - where a customer may return merchandise for a credit or refund. Where customers may request price adjustments (e.g. when they bought a sale item just before it went on special)\nSTOCKPT - Stock Point - Out of customer sight location where merchandise is stored, counted and tracked at a physical and financial level. This could be the \"back room\" (like you see in shoe stores) or it could be a receiving dock, etc. \nRECV - Receiving or merchandise intake location where merchandise is physically unloaded and accepted by the retail store into its inventory (or at least acknowledged). \nAnd lots more depending on the retailer.\nThese codes should indicate which locations involve merchandise sales and tracking. Based on the examples above DISPLY, STOCKPT, CUSTSVC, RECV and RETADJ all represent types of locations that involve the storage, sale or return of merchandise. There are many additional functions and codes that might be assigned depending on the retailer. As Internet sales open up, the concept of location changes. Instead of physical locations, merchandise tracking may be by URL and HTML name. The goal is still to understand WHERE merchandise is moving and where the ownership gets transferred from one party to another.\n |
| LevelNumber | Number | A retailer-defined code that defines the relative position a location has within a hierarchy of locations. This is for modeling traditional retail stores. It allows a retailer to assign locations to specific levels. For example:\nLevel Level Descrption\n01 Store Building\n03 Floor\n05 Area\n07 Department\n09 Fixture Address\n11 POS Device Plug\n |
| LocationID | Identity | A unique identifier for a specific LOCATION within the RETAIL STORE. |
| LocationLevelID | Identity | A unique identifier for a specific location level. |
| Name | Name | The name designated to identify the LOCATION, eg first floor sales area.\n |
| Parent | Identity | A unique identifier for a specific LOCATION within the RETAIL STORE. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| SecurityClassCode | Code6 | Defines the level of security required for a specific location. This is to accommodate secured merchandise like prescription drugs, guns and ammunition, upper end sound and video equipment, etc. |
| SquareFeetCount | Quantity | The number of square feet within this LOCATION.\n |
Tag |
Domain |
Definition |
| EnvironmentClassCode | Code6 | A code that identifies a class environmental properties of a location. For instance, this might describe humidity, temperature, or lighting restrictions or requirements |
| LocationID | Identity | A unique identifier for a specific LOCATION within the RETAIL STORE. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
Tag |
Domain |
Definition |
| Description | DescriptionNarrative | A narrative that describes a location level. |
| LocationLevelID | Identity | A unique identifier for a specific location level. |
| StockLedgerControlFlag | Flag | A flag that indicates whether or not a LOCATION LEVEL will be used to track stock ledger items. \n\nIf a LOCATION LEVEL has a stock-ledger-control-flag of 'N', no lower levels can have a stock-ledger-control-flag of 'Y'. |
Tag |
Domain |
Definition |
| CustomerAccountID | Identity | A unique identifier for a customer account. Generally assigned by the home office. |
| LoyaltyProgramID | Identity | A artificial, unique identifier for a loyalty program. |
Tag |
Domain |
Definition |
| Description | DescriptionNarrative | |
| LoyaltyProgramID | Identity | A artificial, unique identifier for a loyalty program. |
| LoyaltyProgramTermID | Identity |
Tag |
Domain |
Definition |
| ItemID | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
| PriceDerivationRuleID | Identity | A identifier for a specific price derivation rule.\n |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| TypeCode | Code2 | Indicates the type of promotional award given. For example the award may be an item, a gift certificate, as savings bond, etc. |
Tag |
Domain |
Definition |
| Description | DescriptionNarrative | Text that describes a loyalty program. |
| EffectiveDate | DateCalendar | The date that a loyalty program becomes available. |
| EndDate | DateCalendar | The date that a loyalty program is no longer available. |
| LoyaltyProgramID | Identity | A artificial, unique identifier for a loyalty program. |
| Name | Name | A name or tradename for a loyalty program. |
Tag |
Domain |
Definition |
| AppliedTimestamp | TimeStampAudit | The date and time the maintenance event's associated adds, changes and deletes are applied to the store database. |
| CompetitorID | Identity | The unique identifier assigned to a competitor by the store. |
| CreateDateTimestamp | TimeStampAudit | The date and time this maintenance event was created. |
| Description | DescriptionShort | Describes the maintenance event in business terms. |
| EffectiveDateTimestamp | TimeStampEffective | The date and time the maintenance event is to become effective (and is to be applied) |
| EventID | Identity | A unique, automatically assigned identifier for each EVENT instance. |
| ExpirationDateTimestamp | TimeStampExpiration | The date and time the maintenance event is to expire (and be removed). |
| Merchant | Identity | A unique, non-significant number used to identify a store employee. |
| Name | Name | Assigns a name to the maintenance event. |
| OriginTypeCode | Code4 | The origin for this maintenance event. Examples of origins include: home office, store, etc. |
| ReasonCode | Code4 | Establishes a reason for the maintenance event. Reason codes will be determined by each retailer. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| StatusCode | Code2Status | The current status of the maintenance event. Valid status conditions include pending, applied, canceled, expired, etc. |
| TypeCode | Code2 | Categorizes the maintenance event based on its intended purpose and subject. Examples include ITEM maintenance, selling rules maintenance, tender authorization maintenance and a whole host of different aspects of the retail store data model that may be maintained from the home office.\n\n |
Tag |
Domain |
Definition |
| ManufacturerID | Identity | A unique identifier to denote the ITEM MANUFACTURER. |
| Name | Name | The name of the MANUFACTURER's organization. |
| PartyID | Identity | A unique, automatically assigned identity for a PARTY. |
| PartyRoleTypeCode | Code6 | A code that identifies a group of PARTY ROLES. This is used for subtyping the PARTY ROLEs. |
Tag |
Domain |
Definition |
| BrandName | Name | A unique name to denote a class of ITEMs as a product of a single supplier or manufacturer. The brand can include private label ITEMs. |
| ManufacturerID | Identity | A unique identifier to denote the ITEM MANUFACTURER. |
Tag |
Domain |
Definition |
| Description | DescriptionShort | The description for a coupon family code for the manufacturer item. |
| ManufacturerFamilyCode | ProductCodeFamily | The UPC designated three digit coupon family code for the manufacturer item. |
| ManufacturerID | Identity | A unique identifier to denote the ITEM MANUFACTURER. |
Tag |
Domain |
Definition |
| CouponFamilyCode | ProductCodeFamily | A code that validates the consumer has purchased a couponed product. This code represents a category of products with the same color, favor, size or particular BRAND. |
| Description | DescriptionShort | The business description for the manufacturer item. |
| ManufacturerFamilyCode | ProductCodeFamily | The UPC designated three digit coupon family code for the manufacturer item. |
| ManufacturerID | Identity | A unique identifier to denote the ITEM MANUFACTURER. |
| ManufacturerUPCItemID | ProductCodeGlobal | The UPC number assigned to the item by the manufacturer to uniquely identify the item. |
| Name | Name | The business name of the manufacturer item. |
Tag |
Domain |
Definition |
| AccountingDispositionCode | Code4 | Determines whether the price derivation for this rule is treated as a revaluation of the merchandise ( in which case it impacts the stock ledger) or an expense ( in which case it impacts the store financial ledger). in certain instances where the manufacturer has agreed to compensate the retailer for part or the entire price markdown then it is probable that the store will take the revaluation as an expense which will be credited at a subsequent time. |
| ConcurrenceDispositionCode | Code4 | Determines how the retail price reduction or increase calculated as a result of the application of the PRICE DERIVATION RULE will be handled where more than one rule is applied within a sales transaction. |
| EffectiveDateTimestamp | TimeStampEffective | The time and date this rule is activated and may be applied. |
| EventID | Identity | A unique, automatically assigned identifier for each EVENT instance. |
| ExpirationDateTimestamp | TimeStampExpiration | The time and date this rule is no longer valid. |
| ManufacturerID | Identity | A unique identifier to denote the ITEM MANUFACTURER. |
| PriceDerivationRuleID | Identity | A identifier for a specific price derivation rule.\n |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| StoreFinancialLedgerAccountID | Identity | The reference for the STORE FINANCIAL LEDGER ACCOUNT |
Tag |
Domain |
Definition |
| Description | DescriptionShort | The retailer-specific description associated with an ARTS standard merchandise-hierarchy-level-code. This attribute allows retailers to assign any description they choose to each level. |
| MerchandiseHierarchyLevelCode | Code4 | Identifies a hierarchy level within a summarization tree structure for merchandise sales analysis and merchandise classification. The values for this attribute will be standardized within the ARTS Data Model. |
Tag |
Domain |
Definition |
| FiscalYear | DateCalendarYear | An identifier that uniquely identifies a particular FISCAL YEAR in CCYY format. |
| MerchandiseHierarchyLevelCode | Code4 | Identifies a hierarchy level within a summarization tree structure for merchandise sales analysis and merchandise classification. The values for this attribute will be standardized within the ARTS Data Model. |
| MerchandiseStructureID | Identity | Unique identifier for a merchandise structure. |
| ReportingPeriodID | Identity | The identifier for a particular REPORTING PERIOD. |
| ReportingPeriodTypeCode | Code2 | A code to denote a specific REPORTING PERIOD. |
| SalesBudgetNetSalesRetailAmount | Money | The net sales amount which has been budgeted for the RETAIL STORE. This budget is normally set at certain merchandise hierarchical levels to enable the RETAIL STORE to better identify the sales contribution of the various merchandise groups.\n |
Tag |
Domain |
Definition |
| CumulativeItemDaysOnPromotionCount | QuantityTransactionCount | The cumulative number of days where item promotions are run. These days are recorded at the various merchandise hierarchy levels for each REPORTING PERIOD. \n |
| CumulativeItemDiscountAmount | Money | The cumulative monetary value of miscellaneous item discounts recorded by the RETAIL STORE. These markdowns will be recorded at the various merchandise hierarchy levels for each REPORTING PERIOD.\n |
| CumulativeItemDiscountTransactionCount | QuantityTransactionCount | The cumulative number of item discounts which have been applied at the transaction level. These discounts will be recorded at the various merchandise hierarchy levels for each REPORTING PERIOD.\n\n |
| CumulativeItemDiscountUnitCount | QuantityTransactionCount | The cumulative number of miscellaneous item discounts recorded by the RETAIL STORE. These markdowns will be recorded at the various merchandise hierarchy levels for each REPORTING PERIOD.\n |
| CumulativeItemEmployeeDiscountAmount | Money | The cumulative monetary value of employee item discounts recorded by the RETAIL STORE. These markdowns will be recorded at the various merchandise hierarchy levels for each REPORTING PERIOD. |
| CumulativeItemEmployeeDiscountTransactionCount | QuantityTransactionCount | The cumulative number of item employee discounts which have been applied at the transaction level. These discounts will be recorded at the various merchandise hierarchy levels for each REPORTING PERIOD.\n |
| CumulativeItemEmployeeDiscountUnitCount | QuantityTransactionCount | The cumulative number of employee item discounts recorded by the RETAIL STORE. These markdowns will be recorded at the various merchandise hierarchy levels for each REPORTING PERIOD.\n |
| CumulativeItemGrossSales | Money | The cumulative gross item sales recorded by the RETAIL STORE. These sales are recorded at the various merchandise hierarchy levels for each REPORTING PERIOD.\n |
| CumulativeItemGrossSalesExvatAmount | Money | The cumulative monetary amount of gross sales excluding VAT recorded by the RETAIL STORE. These markdowns will be recorded at the various merchandise hierarchy levels for each REPORTING PERIOD.\n |
| CumulativeItemPromotionalPriceMarkdownAmount | Money | The cumulative monetary value of markdowns recorded by the RETAIL STORE. These markdowns are recorded at the various merchandise hierarchy levels for each REPORTING PERIOD.\n |
| CumulativeItemPromotionalPriceMarkdownTransactionCount | QuantityTransactionCount | The cumulative number of transactions which have been marked down by the RETAIL STORE. These markdowns are recorded at the various merchandise hierarchy levels for each REPORTING PERIOD.\n |
| CumulativeItemPromotionalPriceMarkdownUnitCount | QuantityTransactionCount | The cumulative number of markdowns recorded by the RETAIL STORE. These markdowns are recorded at the various merchandise hierarchy levels for each REPORTING PERIOD.\n |
| CumulativeItemReturnAmount | Money | The cumulative monetary value of item returns for the RETAIL STORE, recorded at the various merchandise hierarchy levels, for each REPORTING PERIOD. \n |
| CumulativeItemReturnUnitCount | QuantityTransactionCount | The cumulative number of item returns for the RETAIL STORE, recorded at the various merchandise hierarchy levels, for each REPORTING PERIOD. \n\n |
| CumulativeItemSalesTransactionCounts | QuantityTransactionCount | The cumulative number of transactions involving item sales. The item sales are recorded at the various MERCHANDISE HIERARCHY levels for each REPORTING PERIOD. |
| CumulativeItemSalesUnitCount | QuantityTransactionCount | The cumulative number of ITEMs sold by the RETAIL STORE. The ITEMs are recorded at the various merchandise hierarchy for each REPORTING PERIOD.\n |
| CumulativeItemStoreCouponAmount | Money | The cumulative monetary value of item store coupons received by the RETAIL STORE. These coupons are recorded at the various merchandise hierarchy levels for each REPORTING PERIOD.\n |
| CumulativeItemStoreCouponTransactionCount | QuantityTransactionCount | The cumulative number of item store coupons received by the RETAIL STORE. These coupons are recorded at the various hierarchy levels for each REPORTING PERIOD.\n |
| CumulativeItemStoreCouponUnitCount | QuantityTransactionCount | The cumulative number of item store coupons received by the RETAIL STORE. These coupons are recorded at the various hierarchy levels for each REPORTING PERIOD.\n |
| CumulativeItemStoreRefundAmount | Money | The cumulative monetary value of item refunds for the RETAIL STORE, recorded at the various merchandise hierarchy levels, for each REPORTING PERIOD. \n |
| CumulativeItemStoreRefundTransactionCount | QuantityTransactionCount | The cumulative number of transaction refunds for the RETAIL STORE, recorded at the various merchandise hierarchy levels, for each REPORTING PERIOD. \n |
| CumulativeItemStoreRefundUnitCount | QuantityTransactionCount | The cumulative number of item refunds for the RETAIL STORE, recorded at the various merchandise hierarchy levels, for each REPORTING PERIOD. \n |
| CumulativeTransactionCount | QuantityTransactionCount | The cumulative number of transactions for the RETAIL STORE, recorded at the various merchandise hierarchy levels, for each REPORTING PERIOD. \n |
| CumulatveItemReturnTransactionCount | QuantityTransactionCount | The cumulative number of item returns for the RETAIL STORE, recorded at the various merchandise hierarchy levels, for each REPORTING PERIOD. \n |
| FiscalYear | DateCalendarYear | An identifier that uniquely identifies a particular FISCAL YEAR in CCYY format. |
| MerchandiseHierarchyLevelCode | Code4 | Identifies a hierarchy level within a summarization tree structure for merchandise sales analysis and merchandise classification. The values for this attribute will be standardized within the ARTS Data Model. |
| MerchandiseStructureID | Identity | Unique identifier for a merchandise structure. |
| ReportingPeriodID | Identity | The identifier for a particular REPORTING PERIOD. |
| ReportingPeriodTypeCode | Code2 | A code to denote a specific REPORTING PERIOD. |
Tag |
Domain |
Definition |
| Description | DescriptionShort | A brief text description of the merchandise structure. |
| MerchandiseHierarchyLevelCode | Code4 | Identifies a hierarchy level within a summarization tree structure for merchandise sales analysis and merchandise classification. The values for this attribute will be standardized within the ARTS Data Model. |
| MerchandiseStructureID | Identity | Unique identifier for a merchandise structure. |
| Merchant | Identity | A unique identifier for a specific job. This may or may not be controlled by a centralized HR function. |
| Name | Name | The business name for the merchandise structure. |
Tag |
Domain |
Definition |
| MerchandiseHierarchyLevelCode | Code4 | Identifies a hierarchy level within a summarization tree structure for merchandise sales analysis and merchandise classification. The values for this attribute will be standardized within the ARTS Data Model. |
| MerchandiseStructureID | Identity | Unique identifier for a merchandise structure. |
| SalesRestrictionCode | Code6 | A unique, automatically assigned code for a specific limitation on an ITEM's sale. |
| SalesRestrictionTypeCode | Code4 | A unique code for a group of SALES RESTRICTIONS. |
Tag |
Domain |
Definition |
| MerchandiseHierarchyLevelCode | Code4 | Identifies a hierarchy level within a summarization tree structure for merchandise sales analysis and merchandise classification. The values for this attribute will be standardized within the ARTS Data Model. |
| MerchandiseStructureID | Identity | Unique identifier for a merchandise structure. |
| SizeCode | Code6 | A code to designate the size of the ITEM. It is proposed to use the 5 apparel and miscellaneous coding structure as specified by the NRMA to facilitate data interchange between vendors and retailers. This code permits the use of both standard and proprietary coding format. |
Tag |
Domain |
Definition |
| AccountingDispositionCode | Code4 | Determines whether the price derivation for this rule is treated as a revaluation of merchandise (in which case it impacts the stock ledger) or an expense (in which case it impacts the store financial ledger). |
| ConcurrenceDispositionCode | Code4 | Determines how the retail price reduction or increase calculated as the result of the application of the PRICE DERIVATION RULE will be handled where more than one rule are applied within a sales transaction. Valid examples of values include: - Compound the price changes; Select the single best deal for the customer (i.e. the one rule that by itself yields the lowest price . |
| EffectiveDateTimestamp | TimeStampEffective | The time and date when the MERCHANDISE STRUCTURE DERIVATION RULE becomes effective.\n |
| EventID | Identity | A unique, automatically assigned identifier for each EVENT instance. |
| ExpirationDateTimestamp | TimeStampExpiration | The time and date when the MERCHANDISE STRUCTURE DERIVATION RULE no longer applies.\n |
| MerchandiseHierarchyLevelCode | Code4 | Identifies a hierarchy level within a summarization tree structure for merchandise sales analysis and merchandise classification. The values for this attribute will be standardized within the ARTS Data Model. |
| MerchandiseStructureID | Identity | Unique identifier for a merchandise structure. |
| PriceDerivationRuleID | Identity | A identifier for a specific price derivation rule.\n |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| StoreFinancialLedgerAccountID | Identity | The reference for the STORE FINANCIAL LEDGER ACCOUNT |
Tag |
Domain |
Definition |
| CustomerPaysForDispositionFlag | Code4 | Flag that determines whether the customer is charged for this misc. fee or the store absorbs it as an expense. |
| Description | DescriptionShort | Describes this miscellaneous fee |
| MiscellaneousFeeTypeCode | Code2 | A code to denote the type of miscellaneous fee, eg delivery, gift wrapping, etc |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| StoreFinancialLedgerAccountID | Identity | The reference for the STORE FINANCIAL LEDGER ACCOUNT |
Tag |
Domain |
Definition |
| Amount | Money | The amount of the miscellaneous fee to be booked. |
| BusinessDayDate | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| MiscellaneousFeeTypeCode | Code2 | A code to denote the type of miscellaneous fee, eg delivery, gift wrapping, etc |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| RetailTransactionLineItemSequenceNumber | LineNumber | The sequence number of line item within a TRANSACTION. |
| TransactionSequenceNumber | Identity | A unique, non-significant, automatically assigned sequential number used\nto identify a TRANSACTION within the context of a WORKSTATION and a BUSINESS PERIOD. |
| WorkstationID | Identity | The unique identifier for the WORKSTATION, typically the serial number. |
Tag |
Domain |
Definition |
| ItemID | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
| PriceDerivationRuleID | Identity | A identifier for a specific price derivation rule.\n |
| ReductionMonetaryAmount | Money | The monetary amount of the markdown each time this rule is applied.\n |
| ReductionPercent | Percent | The percentage markdown each time this rule is applied.\n |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
Tag |
Domain |
Definition |
| MixAndMatchLimitCount | Quantity | The maximum number of mix and matched items that may be purchased along with the item that triggered the price derivation rule. For example a break maker may be sold with an offer to acquire any 3 of 24 varieties of bread mix for half price. The 3 varieties represent the mix-and-match-limit-count. |
| PriceDerivationRuleID | Identity | A identifier for a specific price derivation rule.\n |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
Tag |
Domain |
Definition |
| PriceDerivationRuleID | Identity | A identifier for a specific price derivation rule.\n |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| TriggerByCountOrMonetaryCode | Code2 | A code to determine whether the threshold for triggering a multiple unit purchase will be expressed as a monetary amount or a sale unit count. |
Tag |
Domain |
Definition |
| MonetaryValueAmount | Money | The monetary value of retail sale units of this item that earn the price reduction specified in this MULTIPLE UNIT THRESHOLD entity instance. |
| PriceDerivationRuleID | Identity | A identifier for a specific price derivation rule.\n |
| PriceReductionMonetaryAmount | Money | The monetary amount price reduction to be applied through this MULTIPLE UNIT THRESHOLD price derivation rule. |
| PriceReductionPercent | Percent | The percent of the base retail price reduction to be applied through this MULTIPLE UNIT THRESHOLD price derivation rule. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| ThresholdLevelID | Identity | The identifier for a specific MULTIPLE UNIT THRESHOLD.\n |
| UnitCount | Quantity | The number of retail sale units of this item that earn the price reduction specified in this MULTIPLE UNIT THRESHOLD entity instance. |
Tag |
Domain |
Definition |
| OrganizationPartyID | Identity | A unique, automatically assigned identity for a PARTY. |
| RegistrationNumber | DescriptionShort | A tax or other government identifier that is assigned to non-profit organization. |
Tag |
Domain |
Definition |
| AddressID | Identity | A unique identifier for a location and mail address. |
| AddressLine1Name | Address | A generic holder of non-standardized address infomration. |
| AddressLine2Name | Address | A generic holder of non-standardized address infomration. |
| CountryName | Name | The name of a country or territory. |
| PostalCode | PostalCode | A code assigned by the postal authority and used for mail delivery. |
| TerritoryName | Name | A state, provice, or other region within a country. |
| UnitName | Name | An appartment, suite, office or other location's ID. |
Tag |
Domain |
Definition |
| CustomerOccasionTypeName | Name | A short label for a group of CUSTOMER OCCASIONs. For instance, this could be a wedding, a high school graduation, a birthday, a golden wedding anniversary, etc. |
| ItemID | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
Tag |
Domain |
Definition |
| AccessPassword | Password | A security password entered by an operator and used to verify his/her identity when signing on to a WORKSTATION. |
| EmployeeID | Identity | A unique, non-significant number used to identify a store employee. |
| OperatorID | Identity | A unique, automatically assigned number used to identify a workstation OPERATOR. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
Tag |
Domain |
Definition |
| OperatorID | Identity | A unique, automatically assigned number used to identify a workstation OPERATOR. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| WorkGroupID | Identity | A unique identifier for a work classification group to which EMPLOYEEs are assigned. |
Tag |
Domain |
Definition |
| ContainerDepositTotalAmount | Money | The total monetary amount of container discounts collected by OPERATOR for each REPORTING PERIOD.\n |
| EmployeeDiscountTotalAmount | Money | The total monetary amount of employee discounts actioned by OPERATOR for each REPORTING PERIOD.\n |
| FiscalYear | DateCalendarYear | An identifier that uniquely identifies a particular FISCAL YEAR in CCYY format. |
| GrossNegativeTotalAmount | Money | The total monetary amount of negative gross sales recorded by OPERATOR for each REPORTING PERIOD. This total only includes returns made to the RETAIL STORE.\n |
| GrossPositiveTotalAmount | Money | The total monetary amount of positive gross sales recorded by OPERATOR for each REPORTING PERIOD. Positive gross sales exclude returns.\n |
| GrossSalesExTaxTotalAmount | Money | The total monetary amount of gross sales excluding tax recorded by OPERATOR for each REPORTING PERIOD.\n |
| IntermediateTenderReconciliationCount | QuantityTransactionCount | The total number of intermediate tender reconciliations for an OPERATOR for each REPORTING PERIOD.\n |
| LayawayPaymentsCollectedTotalAmount | MoneyShortCost | The total monetary amount of layaway payments collected by OPERATOR for each REPORTING PERIOD.\n |
| LineItemVoidTotalAmount | Money | The total monetary amount of line item voids made by OPERATOR for each REPORTING PERIOD.\n |
| LockTime | QuantityShortCountSeconds | The time expressed in minutes when the WORKSTATION is locked even though the OPERATOR has signed on for each REPORTING PERIOD. |
| MarkdownTotalAmount | Money | The total monetary amount of price markdowns made by OPERATOR for each REPORTING PERIOD.\n |
| MiscellaneousDiscountTotalAmount | Money | The total monetary amount of miscellaneous discounts recorded by OPERATOR for each REPORTING PERIOD.\n |
| MiscellaneousFeeTotalAmount | Money | The total monetary amount of miscellaneous fees recorded by OPERATOR for each REPORTING PERIOD.\n |
| NetSalesTotalAmount | Money | The total monetary amount of net sales recorded by OPERATOR for each REPORTING PERIOD.\n |
| NoSaleTransactionCount | QuantityTransactionCount | The total number of no sale transactions recorded by OPERATOR for each REPORTING PERIOD.\n |
| OperatorID | Identity | A unique, automatically assigned number used to identify a workstation OPERATOR. |
| PaymentsCollectedTotalAmount | Money | The total monetary amount of payments collected by OPERATOR for each REPORTING PERIOD.\n |
| PettyCashDisbursementTotalAmount | Money | The total monetary amount of petty cash disbursements by OPERATOR for each REPORTING PERIOD.\n |
| PostTransactionVoidTotalAmount | Money | The total monetary amount of post transaction voids by OPERATOR for each REPORTING PERIOD. |
| RedeemedContainerDepositTotalAmount | Money | The total monetary amount of container deposits redeemed by OPERATOR for each REPORTING PERIOD.\n |
| RefundTotalAmount | Money | The total monetary amount of refunds made by OPERATOR for each REPORTING PERIOD.\n |
| ReportingPeriodID | Identity | The identifier for a particular REPORTING PERIOD. |
| ReportingPeriodTypeCode | Code2 | A code to denote a specific REPORTING PERIOD. |
| ResumedTotalAmount | Money | The total monetary amount of TRANSACTIONs resumed by OPERATOR for each REPORTING PERIOD.\n |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| ReturnTotalAmount | Money | The total monetary amount of returns made by OPERATOR for each REPORTING PERIOD.\n |
| StoreCouponTotalAmount | Money | The total monetary amount of store coupons accepted by OPERATOR for each REPORTING PERIOD.\n |
| SuspendedTotalAmount | Money | The total number of TRANSACTIONs suspended by OPERATOR for each REPORTING PERIOD.\n |
| SuspendedTransactionCount | QuantityTransactionCount | The total monetary amount of TRANSACTIONs suspended by OPERATOR for each REPORTING PERIOD.\n |
| TaxExemptTotalAmount | Money | The total tax exempt amount recorded by OPERATOR for each REPORTING PERIOD.\n |
| TaxTotalAmount | Money | The total tax amount recorded by OPERATOR for each REPORTING PERIOD.\n |
| TenderLoanTotalAmount | Money | The total monetary amount of tender loans by OPERATOR for each REPORTING PERIOD.\n |
| TenderPickupTotalAmount | Money | The total monetary amount of tender pickups by OPERATOR for each REPORTING PERIOD.\n |
| TotalContainerDepositCount | QuantityTransactionCount | The total number of container deposits collected by OPERATOR for each REPORTING PERIOD.\n |
| TotalEmployeeDiscountCount | QuantityTransactionCount | The total number of line item employee discounts recorded by OPERATOR for each REPORTING PERIOD.\n |
| TotalIdleTime | QuantityShortCountSeconds | The total time expressed in minutes by operator where no sales are being recorded for each REPORTING PERIOD.\n |
| TotalLayawayPaymentsCollectedCount | QuantityTransactionCount | The total number of layaways payments collected by OPERATOR for each REPORTING PERIOD.\n |
| TotalLineItemKeyedCount | QuantityTransactionCount | The total number of ITEMs keyed at the point of sale by OPERATOR for each REPORTING PERIOD.\n |
| TotalLineItemKeyedPercentage | Percent | The percentage of ITEMs keyed at the point of sale compared to the total sold ITEMs by the OPERATOR for each REPORTING PERIOD.\n |
| TotalLineItemOpenDepartmentCount | QuantityTransactionCount | The number of ITEMs recorded through an open department by OPERATOR for each REPORTING PERIOD.\n |
| TotalLineItemOpenDepartmentPercentage | Percent | The percentage of ITEMs recorded through an open department compared to the total ITEMs by OPERATOR for each REPORTING PERIOD.\n |
| TotalLineItemOverrideCount | QuantityTransactionCount | The total number of line item overrides made by OPERATOR for each REPORTING PERIOD.\n |
| TotalLineItemScannedCount | QuantityTransactionCount | The total number of ITEMs scanned by OPERATOR for each REPORTING PERIOD.\n |
| TotalLineItemScannedPercentage | Percent | The percentage of ITEMs scanned compared to the total sold ITEMs by the OPERATOR for each REPORTING PERIOD.\n |
| TotalLineItemVoidCount | QuantityTransactionCount | The total number of line item voids made by OPERATOR for each REPORTING PERIOD.\n |
| TotalMarkdownCount | QuantityTransactionCount | The total number of item markdowns actioned by OPERATOR for each REPORTING PERIOD.\n |
| TotalMiscellaneousDiscountCount | QuantityTransactionCount | The total number of miscellaneous discounts actioned by OPERATOR for each REPORTING PERIOD.\n |
| TotalMiscellaneousFeeCount | QuantityTransactionCount | The total number of miscellaneous fee item sales recorded by OPERATOR for each REPORTING PERIOD.\n |
| TotalPaymentsCollectedCount | QuantityTransactionCount | The total number of payments on account received by OPERATOR for each REPORTING PERIOD.\n |
| TotalPettyCashDisbursementLineItemCount | QuantityTransactionCount | The total number of disbursement line items made by OPERATOR for each REPORTING PERIOD.\n |
| TotalPostTransactionVoidCount | QuantityTransactionCount | The total number of disbursement line items made by OPERATOR for each REPORTING PERIOD.\n |
| TotalRedeemedContainerDepositCount | QuantityTransactionCount | The total number of disbursement line items made by OPERATOR for each REPORTING PERIOD.\n |
| TotalRefundCount | QuantityTransactionCount | The total number of item refunds actioned by OPERATOR for each REPORTING PERIOD.\n |
| TotalReturnCount | QuantityTransactionCount | The total number of item returns received by OPERATOR for each REPORTING PERIOD.\n |
| TotalRingTime | QuantityShortCountSeconds | The total time expressed in minutes spent scanning or keying ITEMs by OPERATOR for each REPORTING PERIOD.\n |
| TotalSaleLineItemCount | QuantityTransactionCount | The total number of line item sales recorded by OPERATOR for each REPORTING PERIOD.\n |
| TotalSendCheckAmount | Money | The total monetary amount of send checks recorded by OPERATOR for each REPORTING PERIOD.\n |
| TotalSendCheckCount | QuantityTransactionCount | The total number of send checks recorded by OPERATOR for each REPORTING PERIOD.\n |
| TotalSignOffCount | QuantityTransactionCount | The total number of sign-on made by OPERATOR for each REPORTING PERIOD.\n |
| TotalSignOnCount | QuantityTransactionCount | The total number of sign-offs made by OPERATOR for each REPORTING PERIOD.\n |
| TotalStoreCouponCount | QuantityTransactionCount | The total number of store coupons accepted by OPERATOR for each REPORTING PERIOD.\n |
| TotalTaxExemptTransactionCount | QuantityTransactionCount | The total number of tax exempt transactions recorded by OPERATOR for each REPORTING PERIOD.\n |
| TotalTenderLoanCount | QuantityTransactionCount | The total number of tender loans recorded against the workstation OPERATOR for each REPORTING PERIOD.\n |
| TotalTenderOverAmount | Money | The total monetary amount of tender overages recorded against the workstation OPERATOR for each REPORTING PERIOD.\n |
| TotalTenderPickupCount | QuantityTransactionCount | The total number of tender pickups recorded against the workstation OPERATOR for each REPORTING PERIOD.\n |
| TotalTenderUnderAmount | Money | The total monetary amount of tender shortages recorded by OPERATOR for each REPORTING PERIOD.\n |
| TotalTranactionVoidCount | QuantityTransactionCount | The total number of transaction voids recorded by OPERATOR for each REPORTING PERIOD.\n |
| TotalTransactionCount | QuantityTransactionCount | The total number of transactions recorded by OPERATOR for each REPORTING PERIOD.\n |
| TotalWeighedLineItemCount | QuantityTransactionCount | The total number of weighed line items recorded by OPERATOR for each REPORTING PERIOD.\n |
| TransactionVoidTotalAmount | Money | The total number of transaction voids recorded by OPERATOR for each REPORTING PERIOD.\n |
| WorkstationResumedTransactionCount | QuantityTransactionCount | The total number of resumed transactions recorded by OPERATOR for each REPORTING PERIOD.\n |
Tag |
Domain |
Definition |
| OperatorID | Identity | A unique, automatically assigned number used to identify a workstation OPERATOR. |
| ReadAccessLevelCode | Code2AccessControl | An indicator to signify that read access is granted to the referenced OPERATOR for the corresponding resource identified in this record. Read access limitation may be set by, for example, no access, group access, user access, etc.\n |
| ResourceID | Identity | A code to uniquely identify a given application or application component.\n |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| WriteAccessLevelCode | Code2AccessControl | An indicator to signify that write access is granted to the referenced OPERATOR for the corresponding resource identified in this record. Write access limitation may be set by, for example, no access, group access, user access, etc.\n |
Tag |
Domain |
Definition |
| FiscalYear | DateCalendarYear | An identifier that uniquely identifies a particular FISCAL YEAR in CCYY format. |
| Operator | Identity | A specific TAX AUTHORITY that establishes the tax rate. The TAX AUTHORITY is normally a government body. |
| OperatorID | Identity | A unique, automatically assigned number used to identify a workstation OPERATOR. |
| ReportingPeriodID | Identity | The identifier for a particular REPORTING PERIOD. |
| ReportingPeriodTypeCode | Code2 | A code to denote a specific REPORTING PERIOD. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| TaxableSaleTotalAmount | Money | The total monetary amount of taxable sales recorded by OPERATOR for each REPORTING PERIOD. |
| TaxCollectedTotalAmount | Money | The total monetary amount of tax recorded by OPERATOR for each REPORTING PERIOD.\n |
| TaxExemptSaleTotalAmount | Money | The total monetary amount of tax exempt sales recorded by OPERATOR for each REPORTING PERIOD. |
| TaxExemptTransactionCount | QuantityTransactionCount | The total number of tax exempt sales recorded by OPERATOR for each REPORTING PERIOD. |
Tag |
Domain |
Definition |
| DepositTotalAmount | Money | The total monetary value of tender media deposited in the EXTERNAL DEPOSITORY by OPERATOR for each REPORTING PERIOD.\n |
| FiscalYear | DateCalendarYear | An identifier that uniquely identifies a particular FISCAL YEAR in CCYY format. |
| LoanMediaTotalAmount | Money | The total monetary amount of tender media units loaned by operator for each REPORTING PERIOD. |
| OperatorID | Identity | A unique, automatically assigned number used to identify a workstation OPERATOR. |
| OperatorTender | Code4 | A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. |
| OverTotalAmount | Money | The total monetary value of tender overages recorded by OPERATOR for each REPORTING PERIOD.\n |
| PickupMediaTotalAmount | Money | The total monetary amount of tender media units picked up by operator for each REPORTING PERIOD. |
| ReportingPeriodID | Identity | The identifier for a particular REPORTING PERIOD. |
| ReportingPeriodTypeCode | Code2 | A code to denote a specific REPORTING PERIOD. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| ShortTotalAmount | Money | The total monetary value of tender shortages recorded for that OPERATOR for each REPORTING PERIOD.\n |
| TotalBeginningTenderMediaUnitCount | QuantityTransactionCount | The open balance of the number of tender media units for that OPERATOR for each REPORTING PERIOD.\n |
| TotalTenderDepositMediaUnitCount | QuantityTransactionCount | The total number of tender media units deposited in the EXTERNAL DEPOSITORY by OPERATOR for each REPORTING PERIOD. |
| TotalTenderLoanMediaUnitCount | QuantityTransactionCount | The total number of tender media units loaned by operator for each REPORTING PERIOD.\n |
| TotalTenderMediaCount | QuantityTransactionCount | The total number of tender media units counted by operator for each REPORTING PERIOD.\n |
| TotalTenderMediaOverCount | QuantityTransactionCount | The total tender overage recorded against an operator for each REPORTING PERIOD.\n |
| TotalTenderMediaShortCount | QuantityTransactionCount | The total monetary value of tender shortages recorded for that OPERATOR for each REPORTING PERIOD.\n |
| TotalTenderPickupMediaUnitCount | QuantityTransactionCount | The total number of tender media units picked up by operator for each REPORTING PERIOD.\n |
Tag |
Domain |
Definition |
| BuyerID | Identity | The BUYER_ID specifies the corporate buyer responsible for the purchase of merchandise specified in the order document. |
| InventoryControlDocumentID | Identity | The reference number that uniquely identifies the INVENTORY CONTROL DOCUMENT. |
| OrderEventTypeCode | Code2 | A code that characterizes an order based on the event causing its creation. Examples include orders generated on a regular basis, orders generated as part of a promotion and orders generated for a season. |
| OrderTypeCode | Code2 | A code to denote the type of purchase order, eg close out, consignment, etc. This code relates to the UCC Purchase Order Type Code, Data Element 92. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
Tag |
Domain |
Definition |
| FederalTaxID | DescriptionShort | A tax or other number assigned by a federal government that is unique to all ORGANIZATIONs within that federal government's jurisdiction. |
| LegalStatusCode | Code2Status | A code that indicates the ORGANIZATION's legal or tax status. For example, this may be Commercial Corporation, Not-for-profit, Non-profit, Academic, Government, etc. |
| Name | Name | An ORGANIZATION's legal trade name. |
| OrganizationPartyID | Identity | A unique, automatically assigned identity for a PARTY. |
| StateTaxID | DescriptionShort | A tax or other number assigned by a state government that is unique to all ORGANIZATIONs within that state government's jurisdiction. |
| TaxID | DescriptionShort | A tax or other number assigned by a governing body that is unique to all ORGANIZATIONs within that governing body's jurisdiction. |
Tag |
Domain |
Definition |
| Affiliated Organization | Identity | A unique, automatically assigned identity for a PARTY. |
| OrganizationPartyID | Identity | A unique, automatically assigned identity for a PARTY. |
Tag |
Domain |
Definition |
| Parent | Identity | A unique, automatically assigned identity for a PARTY. |
| Subordinate | Identity | A unique, automatically assigned identity for a PARTY. |
Tag |
Domain |
Definition |
| PackingSlipID | Identity | the unique identifier for the packing slip, typically the reference number. |
| SupplierID | Identity | A code assigned by the retailer to uniquely identify the supplier. |
| SupplierOrderFulfilledDate | DateCalendar | The date on which the order is fulfilled by the SUPPLIER.\n |
| SupplierOrderShipmentOutboundDate | DateCalendar | The date on which the fulfilled order is shipped from the SUPPLIER to the RETAIL STORE. \n |
Tag |
Domain |
Definition |
| OrganizationTypeCode | Code2 | Describes the type of organization from the legal aspect, ie company which is either private, public, limited liability, etc. |
| PartyID | Identity | A unique, automatically assigned identity for a PARTY. |
| PartyTypeCode | Code2 | Defines the type of party a store is dealing with (e.g. a supplier, carrier, customer, etc.) |
Tag |
Domain |
Definition |
| AddressID | Identity | A unique identifier for a location and mail address. |
| EffectiveDate | DateCalendar | The date that a PARTY's address is valid for that PARTY. |
| ExpirationDate | DateCalendar | The date that a PARTY's address is no longer valid for that PARTY. |
| PartyID | Identity | A unique, automatically assigned identity for a PARTY. |
| PartyRoleTypeCode | Code6 | A code that identifies a group of PARTY ROLES. This is used for subtyping the PARTY ROLEs. |
| StatusCode | Code2Status | An indicator of the address's currency. For instance, this address may be valid, invalid, temporary, etc. |
Tag |
Domain |
Definition |
| EffectiveDate | DateCalendar | The date that this role is valid. |
| ExpirationDate | DateCalendar | The date that this role is no longer valid. |
| PartyID | Identity | A unique, automatically assigned identity for a PARTY. |
| PartyRoleTypeCode | Code6 | A code that identifies a group of PARTY ROLES. This is used for subtyping the PARTY ROLEs. |
Tag |
Domain |
Definition |
| PartyID | Identity | A unique, automatically assigned identity for a PARTY. |
| PartyRoleStateCode | Code6 | A unique code that will identify a group of party roles. |
| PartyRoleTypeCode | Code6 | A code that identifies a group of PARTY ROLES. This is used for subtyping the PARTY ROLEs. |
Tag |
Domain |
Definition |
| Description | DescriptionNarrative | A narrative that describes this group of party roles. |
| Name | Name | A name or label for a group of party roles. |
| PartyRoleTypeCode | Code6 | A code that identifies a group of PARTY ROLES. This is used for subtyping the PARTY ROLEs. |
Tag |
Domain |
Definition |
| Description | DescriptionNarrative | A narrative that describes the status of a PARTY ROLE. |
| Name | Name | A name or label for a status of a PARTY ROLE> |
| PartyRoleStateCode | Code6 | A unique code that will identify a group of party roles. |
| PartyRoleTypeCode | Code6 | A code that identifies a group of PARTY ROLES. This is used for subtyping the PARTY ROLEs. |
Tag |
Domain |
Definition |
| BusinessDayDate | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| CustomerAccountID | Identity | A unique identifier for a customer account. Generally assigned by the home office. |
| PaymentAgainstReceivableAccountCode | Code4 | A code to denote the type of payment on account, eg layaway, house, etc.\n\n\n |
| PaymentAgainstReceivableAmount | Money | The monetary payment on account received from the CUSTOMER.\n |
| PaymentAgainstReceivableCustomerAccountID | Identity | The unique identifier for the customer account .\n |
| PaymentReceivableFlag | Flag | A flag to denote that payment is outstanding on the account. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| RetailTransactionLineItemSequenceNumber | LineNumber | The sequence number of line item within a TRANSACTION. |
| TransactionSequenceNumber | Identity | A unique, non-significant, automatically assigned sequential number used\nto identify a TRANSACTION within the context of a WORKSTATION and a BUSINESS PERIOD. |
| WorkstationID | Identity | The unique identifier for the WORKSTATION, typically the serial number. |
Tag |
Domain |
Definition |
| BusinessDayDate | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| TransactionSequenceNumber | Identity | A unique, non-significant, automatically assigned sequential number used\nto identify a TRANSACTION within the context of a WORKSTATION and a BUSINESS PERIOD. |
| WorkstationID | Identity | The unique identifier for the WORKSTATION, typically the serial number. |
Tag |
Domain |
Definition |
| EventID | Identity | A unique, automatically assigned identifier for each EVENT instance. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| SaleUnitAmount | MoneyShortRetail | The amount (either monetary or percent) to be used to change or replace the current selling price for a sale unit of the item. |
| SaleUnitAmountTypeCode | Code2 | A code to define how the temporary-price-change-sale-unit-amount is to be \ninterpreted. Valid values include: PCT percent of current retail price to be added to or subtracted from the current retail to arrive at a selling price; AMT, \nflat monetary amount to be added to or subtracted from the current retail to \narrive at a selling price; and AMTREPL, a retail sale unit price amount that is\nto replace the current selling price. |
Tag |
Domain |
Definition |
| EventID | Identity | A unique, automatically assigned identifier for each EVENT instance. |
| ItemID | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
Tag |
Domain |
Definition |
| BirthDate | DateCalendar | A person's date of birth. |
| FirstName | Name | A person's first or given name. |
| GenderType | Code2 | A code for specifying a person's gender. |
| LastName | Name | A person's family name. |
| MiddleInitial | NameMiddleInitial | The first letter of a person's middle name. |
| PersonPartyID | Identity | A unique, automatically assigned identity for a PARTY. |
| Salutation | Name | The courtesy title belonging to a person. For instance, Mr. Ms., Miss, Dr. etc. |
Tag |
Domain |
Definition |
| Description | DescriptionNarrative | A narrative for a group of affiliations of people and organizations. |
| PersonOrganizationAffilationTypeName | String | A name or label for a group of affiliations of people and organizations. For instance, this might be 'employment'. |
Tag |
Domain |
Definition |
| Effective Date | DateCalendar | The start date of a PERSON's affiliation with an organization. |
| OrganizationPartyID | Identity | A unique, automatically assigned identity for a PARTY. |
| PersonOrganizationAffilationTypeName | String | A name or label for a group of affiliations of people and organizations. For instance, this might be 'employment'. |
| PersonPartyID | Identity | A unique, automatically assigned identity for a PARTY. |
Tag |
Domain |
Definition |
| EventID | Identity | A unique, automatically assigned identifier for each EVENT instance. |
| PhysicalCountDocumentID | Identity | The identifier for the physical count document on which the actual item counts are recorded.\n |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
Tag |
Domain |
Definition |
| PhysicalCountDocumentID | Identity | The identifier for the physical count document on which the actual item counts are recorded.\n |
| PhysicalItemCountLineNumber | Identity | The physical count line item.\n |
Tag |
Domain |
Definition |
| EventID | Identity | A unique, automatically assigned identifier for each EVENT instance. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
Tag |
Domain |
Definition |
| CoordinateTypeCode | Code2 | A categorization of co-ordinate systems. |
| PhysicalLocationCode | Code6 | A code that identifies a specific physical location. |
Tag |
Domain |
Definition |
| AddressID | Identity | A unique identifier for a location and mail address. |
| CoordinateTypeCode | Code2 | A categorization of co-ordinate systems. |
| PhysicalLocationCode | Code6 | A code that identifies a specific physical location. |
Tag |
Domain |
Definition |
| Name | Name | The title or label given to a point-of-sale department. |
| Parent | Identity | The unique identifier for a particular POS DEPARTMENT.\n |
| POSDepartmentID | Identity | The point-of-sale department number. |
Tag |
Domain |
Definition |
| ContainerDepositTotalAmount | Money | The total monetary amount of container deposits by POS department for each REPORTING PERIOD. |
| EmployeeDiscountTotalAmount | Money | The total monetary amount of employee discounts by POS department for each REPORTING PERIOD. |
| FiscalYear | DateCalendarYear | An identifier that uniquely identifies a particular FISCAL YEAR in CCYY format. |
| LineItemVoidTotalAmount | Money | The total monetary amount of line item voids by POS department for each REPORTING PERIOD. |
| MarkdownTotalAmount | Money | The total monetary amount of markdowns by POS department for each REPORTING PERIOD. |
| MiscellaneousDiscountTotalAmount | Money | The total monetary amount of miscellaneous discounts by POS department for each REPORTING PERIOD. |
| MiscellaneousFeeTotalAmount | Money | The total monetary amount of miscellaneous fees by POS department for each REPORTING PERIOD. |
| NetItemSalesTotalAmount | Money | The total monetary amount of net item sales by POS department for each REPORTING PERIOD. |
| POSDepartmentID | Identity | The point-of-sale department number. |
| PostTransactionVoidTotalAmount | Money | The total monetary amount of items cancelled by a post transaction void by POS department for each REPORTING PERIOD. |
| RedeemedContainerDepositTotalAmount | Money | The total monetary amount of redeemed container deposits by POS department for each REPORTING PERIOD. |
| RefundTotalAmount | Money | The total monetary amount of refunds by POS department for each REPORTING PERIOD. |
| ReportingPeriodID | Identity | The identifier for a particular REPORTING PERIOD. |
| ReportingPeriodTypeCode | Code2 | A code to denote a specific REPORTING PERIOD. |
| ReturnTotalAmount | Money | The total monetary amount of returns by POS department for each REPORTING PERIOD. |
| StoreCouponTotalAmount | Money | The total monetary amount of lines purchased in part or in full by store coupons by POS department for each REPORTING PERIOD. |
| TaxExemptTotalAmount | Money | The total monetary amount of tax exempt item sales by POS department for each REPORTING PERIOD. |
| TaxTotalAmount | Money | The total monetary amount of tax item sales by POS department for each REPORTING PERIOD. |
| TotalContainerDepositCount | QuantityTransactionCount | The total number of container deposits by POS department for each REPORTING PERIOD. |
| TotalEmployeeDiscountCount | QuantityTransactionCount | The total number of employee discounted items by POS department for each REPORTING PERIOD. |
| TotalLineItemKeyedCount | QuantityTransactionCount | The total number of keyed item sales by POS department for each REPORTING PERIOD. |
| TotalLineItemKeyedPercentage | Percent | The number of items keyed as a percentage of total items sold by POS department for each REPORTING PERIOD. |
| TotalLineItemOpenDepartmentCount | QuantityTransactionCount | The total number of items sold by a POS department for each REPORTING PERIOD. |
| TotalLineItemOpenDepartmentPercentage | Percent | The number of items sold through a department key as a percentage of total items sold by POS department for each REPORTING PERIOD. |
| TotalLineItemOverrideCount | QuantityTransactionCount | The total number of line item overrides by POS department for each REPORTING PERIOD. |
| TotalLineItemScannedCount | QuantityTransactionCount | The total number of scanned item sales by POS department for each REPORTING PERIOD. |
| TotalLineItemScannedPercentage | Percent | The number of items scanned as a percentage of total items sold by POS department for each REPORTING PERIOD. |
| TotalLineItemVoidCount | QuantityTransactionCount | The total number of line item voids by POS department for each REPORTING PERIOD. |
| TotalMarkdownCount | QuantityTransactionCount | The total number of markdowns by POS department for each REPORTING PERIOD. |
| TotalMiscellaneousDiscountCount | QuantityTransactionCount | The total number of miscellaneous discounted items by POS department for each REPORTING PERIOD. |
| TotalMiscellaneousFeeCount | QuantityTransactionCount | The total number of miscellaneous fees by POS department for each REPORTING PERIOD. |
| TotalPostTransactionVoidCount | QuantityTransactionCount | The total number of items cancelled by a post transaction void by POS department for each REPORTING PERIOD. |
| TotalRedeemedContainerDepositCount | QuantityTransactionCount | he total number of redeemed container deposits by POS department for each REPORTING PERIOD. |
| TotalRefundCount | QuantityTransactionCount | The total number of refunds by POS department for each REPORTING PERIOD. |
| TotalReturnCount | QuantityTransactionCount | The total number of returns by POS department for each REPORTING PERIOD. |
| TotalSaleLineItemCount | QuantityTransactionCount | The total number of item sales by POS department for each REPORTING PERIOD. |
| TotalStoreCouponCount | QuantityTransactionCount | he total number of lines purchased in part or in full by store coupons by POS department for each REPORTING PERIOD. |
| TotalTaxExemptTransactionCount | QuantityTransactionCount | The total number of tax exempt item sales by POS department for each REPORTING PERIOD. |
| TotalTranactionVoidCount | QuantityTransactionCount | The total number of items cancelled by transaction void by POS department for each REPORTING PERIOD. |
| TotalWeighedLineItemCount | QuantityTransactionCount | The total number of weighed item sales by POS department for each REPORTING PERIOD. |
| TransactionVoidTotalAmount | Money | The total monetary amount of items cancelled by transaction void by POS department for each REPORTING PERIOD. |
Tag |
Domain |
Definition |
| FiscalYear | DateCalendarYear | An identifier that uniquely identifies a particular FISCAL YEAR in CCYY format. |
| POSDepartmentID | Identity | The point-of-sale department number. |
| ReportingPeriodID | Identity | The identifier for a particular REPORTING PERIOD. |
| ReportingPeriodTypeCode | Code2 | A code to denote a specific REPORTING PERIOD. |
| TaxableSaleTotalAmount | Money | The total amount of taxable sales by POS department for each REPORTING PERIOD. |
| TaxAuthorityID | Identity | A specific TAX AUTHORITY that establishes the tax rate. The TAX AUTHORITY is normally a government body. |
| TaxCollectedTotalAmount | Money | The total amount of tax collected by POS department for each REPORTING PERIOD. |
| TaxExemptSaleTotalAmount | Money | The total amount of tax exempt sales by POS department for each REPORTING PERIOD. |
| TaxExemptTransactionCount | QuantityTransactionCount | The total number of tax exempt sales by POS department for each REPORTING PERIOD. |
Tag |
Domain |
Definition |
| AllowCouponMultiplyFlag | Flag | A flag that enables or disables multiple coupon promotions. Used to enable or disable double or triple coupon promotions. |
| AllowFoodStampFlag | Flag | A flag to indicate whether food stamps can be tendered for this ITEM. |
| CouponEndOfOfferDate | ProductCodeExpiry | The end of offer date encoded in the supplementary part of the coupon code. This code provides the month and year ( eg 0697 denotes the expiration date for that particular coupon as June 30, 1997) |
| CouponRestrictedFlag | Flag | A flag to indicate whether a coupon can be redeemed for this ITEM. |
| CouponValueCode | ProductCodeValue | A two digit value code that designates the redemption value of a coupon in monetary units. The code follows the family code on the UPC/EAN coupon code. The code in some instances is a direct representation of the face value (eg code number 10 represents a 10 cent coupon value) and some which are not (eg code number 83 represents $2.25coupon value). |
| CurrentSaleUnitPOSRetailPriceAmount | MoneyShortRetail | The current retail price per sale unit of the item. This monetary amount is used as the basis for deriving retail price at the point of sale. |
| CustomerAccountDiscountAllowedFlag | Flag | A flag that enables or disables price derivation rule applicability to a particular customer account for the ITEM. |
| CustomerAffiliationDiscountAllowedFlag | Flag | A flag that enables or disables price derivation rule applicability to a customer group affiliation for the ITEM. |
| Description | DescriptionShort | The abbreviated text description of an item printed on the customer receipt. |
| ElectronicCouponFlag | Flag | A flag to denote whether an electronic coupon is available for this ITEM. The value is automatically applied to the purchase, no media is exchanged. |
| EmployeeDiscountAllowedFlag | Flag | A flag that enables or disables price derivation rule applicability to a particular employee for the ITEM. |
| FrequentShopperPointsCount | Quantity | The number of frequent buyer points awarded for purchase of this ITEM. |
| FrequentShopperPointsEligibleFlag | Flag | A flag to denote whether this ITEM is eligible for frequent shopper benefits as part of a customer loyalty scheme |
| GiveawayFlag | Flag | A flag to denote whether this ITEM can be given away free as part of a promotion, provided the CUSTOMER fully meets the conditions of that promotion. |
| ItemID | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
| ItemTenderRestrictionGroupCode | Code2 | A code to denote a specific group of ITEM TENDER RESTRICTIONs. \n |
| ManufacturerFamilyCode | ProductCodeFamily | The UPC designated three digit coupon family code for the manufacturer item. |
| ManufacturerID | Identity | A unique identifier to denote the ITEM MANUFACTURER. |
| MarketBasketDiscountAllowedFlag | Flag | A flag that enables or disables price derivation rule applicability to a market basket for the ITEM. |
| MaximumSaleUnitCount | QuantityShortCount | Defines the maximum number of retail sale units that may be purchased in a single sales transaction. Typically this is used for special promotions or \"rationed\" merchandise (e.g. Nintendo 64 in Christmas 1995). |
| MinimumSaleUnitCount | QuantityShortCount | For items, the minimum number of selling units (e.g. square yards, linear feet, pounds, liters, etc.) that must be purchased for a specific item. This selling rule qualifies the item at point of sale. |
| POSItemID | Identity | POS item id is a token identifier to facilitate price lookup and does not\ncontain any descriptive information. |
| PriceEntryRequiredFlag | Flag | A flag to denote that the RETAIL PRICE has to manually entered when this ITEM is purchased by a CUSTOMER. |
| ProhibitRepeatKeyFlag | Flag | A flag to prohibit the use of the repeat key when selling this ITEM. This flag forces the operator to scan or separately enter each instance of a ITEM rather than use a repeat key to ensure inventory integrity and avoid arithmetic errors.\n |
| ProhibitReturnFlag | Flag | A flag to indicate whether this ITEM can be returned or not, unless faulty. This normally applies to freezer or chilled products. |
| QuantityKeyProhibitFlag | Flag | A flag to denote that the quantity key cannot be used with the sale of this ITEM. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| ReturnAgentID | Identity | The company to whom the returns for ITEMs, such as empty bottles, are made. |
| UPC | ProductCodeGlobal | The UPC number assigned to the item by the manufacturer to uniquely identify the item. |
| VisualVerifyPriceFlag | Flag | A flag to denote whether the operator must verify the price in the ITEM with the price derived from the price look up table. |
| WeightEntryRequiredFlag | Flag | A flag to indicate that the weight of this ITEM has to be entered into the system to derive the selling price. |
| WICFlag | Flag | A flag to indicate it this ITEM is allowed in WIC transaction. |
Tag |
Domain |
Definition |
| AccessLevelCode | Code6 | A code that indicates what access privileges are granted to a position. |
| CommissionFlag | Flag | An indicatory of whether or not this position is eligible for commission. |
| Description | DescriptionNarrative | A narrative that describes the POSTION or job. |
| JobCode | Code6 | A unique identifier for a JOB or funcation. |
| PayrollTypeCode | Code6 | A code indicating how this position is paid. |
| PositionID | Identity | A unique identifier for a specific job. This may or may not be controlled by a centralized HR function. |
| ShareFlag | Flag | An indicator for whether or not this position is eligible for job sharing. |
| Title | Name | A job title associated with a POSITION. |
Tag |
Domain |
Definition |
| EffectiveDate | DateCalendar | The starting date for an allotment of positions to a retail store. |
| ExpirationDate | DateCalendar | The ending date for an allotment of positions to a retail store. |
| LocationId | Identity | A unique identifier for a specific LOCATION within the RETAIL STORE. |
| PositionID | Identity | A unique identifier for a specific job. This may or may not be controlled by a centralized HR function. |
| RetailStoreId | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
Tag |
Domain |
Definition |
| EffectiveDate | DateCalendar | The valid start date for a position's reporting structure |
| ExpirationDate | DateCalendar | The date that a position's reporting structure is no longer valid. |
| Subordinate | Identity | A unique identifier for a specific job. This may or may not be controlled by a centralized HR function. |
| Supervisor | Identity | A unique identifier for a specific job. This may or may not be controlled by a centralized HR function. |
Tag |
Domain |
Definition |
| FinishTime | Time | The ending time for this schedule. |
| Hours | Number | Total hours for this schedule. |
| PositionID | Identity | A unique identifier for a specific job. This may or may not be controlled by a centralized HR function. |
| PositionWorkScheduleWekDay | Name | The name of the day that this schedule is for. |
| StartTime | Time | The beginning time for this schedule. |
Tag |
Domain |
Definition |
| BusinessDayDate | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| TransactionSequenceNumber | Identity | A unique, non-significant, automatically assigned sequential number used\nto identify a TRANSACTION within the context of a WORKSTATION and a BUSINESS PERIOD. |
| WorkstationID | Identity | The unique identifier for the WORKSTATION, typically the serial number. |
Tag |
Domain |
Definition |
| BusinessDayDate | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| TransactionSequenceNumber | Identity | A unique, non-significant, automatically assigned sequential number used\nto identify a TRANSACTION within the context of a WORKSTATION and a BUSINESS PERIOD. |
| WorkstationID | Identity | The unique identifier for the WORKSTATION, typically the serial number. |
Tag |
Domain |
Definition |
| BusinessDayDate | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| TransactionSequenceNumber | Identity | A unique, non-significant, automatically assigned sequential number used\nto identify a TRANSACTION within the context of a WORKSTATION and a BUSINESS PERIOD. |
| Voided | Identity | The unique identifier for the WORKSTATION, typically the serial number. |
| WorkstationID | Identity | The unique identifier for the WORKSTATION, typically the serial number. |
Tag |
Domain |
Definition |
| BusinessDayDate | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| TransactionSequenceNumber | Identity | A unique, non-significant, automatically assigned sequential number used\nto identify a TRANSACTION within the context of a WORKSTATION and a BUSINESS PERIOD. |
| WorkstationID | Identity | The unique identifier for the WORKSTATION, typically the serial number. |
Tag |
Domain |
Definition |
| Description | DescriptionNarrative | A narrative that describes the group of preferences. |
| PreferenceTypeCode | Code2 | A unique code for a group of preferences. For instance, all the types of material (clothing) preferences may be grouped together. |
Tag |
Domain |
Definition |
| Description | DescriptionShort | Business description for this price derivation rule. |
| EffectiveDate | DateCalendar | The date this price derivation rule may be applied to a transaction. |
| EventID | Identity | A unique, automatically assigned identifier for each EVENT instance. |
| ExpirationDate | DateCalendar | The date this derivation rule may no longer be applied to a transaction. |
| Name | Name | Price derivation rule name |
| PriceDerivationRuleID | Identity | A identifier for a specific price derivation rule.\n |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| StatusCode | Code2Status | Defines the current status for the price derivation rule. Examples of valid codes include: Pending, Active, Canceled, Inactive |
| TransactionControlBreakCode | Code2 | This is a special code that determines when, during the entry of a sale transaction, this rule will be applied. For example a price change rule may be applied on a line item by line item basis (which is DETAIL TIME), a price change rule may be triggered after a transaction is totaled -- but before tax and tender entry (i.e. MERCHANDISE SUBTOTAL TIME). |
| TypeCode | Code2 | Defines the type of price derivation rule. |
Tag |
Domain |
Definition |
| EventID | Identity | A unique, automatically assigned identifier for each EVENT instance. |
| MaintenanceFunctionCode | Code4 | Defines the maintenance function to be performed. Valid values include creation, update or deletion of a price derivation rule. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
Tag |
Domain |
Definition |
| HighAmount | Money | The high end of a price range that bounds a price line. |
| LowAmount | Money | The low end of a price range that bounds a price line. |
| MerchandiseHierarchyLevelCode | Code4 | Identifies a hierarchy level within a summarization tree structure for merchandise sales analysis and merchandise classification. The values for this attribute will be standardized within the ARTS Data Model. |
| MerchandiseStructureID | Identity | Unique identifier for a merchandise structure. |
| PriceLineID | Identity | A unique identifier for this price point.\n |
Tag |
Domain |
Definition |
| AccountingDispositionCode | Code4 | Determines whether the price derivation for this rule is treated as a revaluation of merchandise (in which case it impacts the stock ledger) or an expense ( in which case it impacts the store financial ledger). |
| ConcurrenceDispositionCode | Code4 | Determines how the retail price reduction or the increase calculated as a result of the application of the PRICE DERIVATION RULE will be handled when more than one rule is applied within a sales transaction. |
| EffectiveDateTimestamp | TimeStampEffective | The time and date this rule is activated and may be applied. |
| ExpirationDateTimestamp | TimeStampExpiration | The time and date this rule is no longer valid or applicable. |
| MerchandiseHierarchyLevelCode | Code4 | Identifies a hierarchy level within a summarization tree structure for merchandise sales analysis and merchandise classification. The values for this attribute will be standardized within the ARTS Data Model. |
| MerchandiseStructureID | Identity | Unique identifier for a merchandise structure. |
| PriceDerivationRuleID | Identity | A identifier for a specific price derivation rule.\n |
| PriceLineID | Identity | A unique identifier for this price point.\n |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
Tag |
Domain |
Definition |
| BusinessDayDate | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| CustomerAccountID | Identity | A unique identifier for a customer account. Generally assigned by the home office. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| RetailTransactionLineItemSequenceNumber | LineNumber | The sequence number of line item within a TRANSACTION. |
| TransactionSequenceNumber | Identity | A unique, non-significant, automatically assigned sequential number used\nto identify a TRANSACTION within the context of a WORKSTATION and a BUSINESS PERIOD. |
| WorkstationID | Identity | The unique identifier for the WORKSTATION, typically the serial number. |
Tag |
Domain |
Definition |
| CustomerID | Identity | A unique identifier for a customer. |
Tag |
Domain |
Definition |
| AccountingDispositionCode | Code4 | A code for how this price derivation shall be treated for accounting purposes. |
| ConcurrenceDispositionCode | Code4 | A code for how this price derivation shall be treated concurrently. |
| EffectiveDateTimestamp | TimeStampEffective | The time that a temporary price change goes into effect. |
| EventID | Identity | A unique, automatically assigned identifier for each EVENT instance. |
| ExpirationDateTimestamp | TimeStampExpiration | The time that a temporary price change is no longer valid. |
| PriceDerivationRuleID | Identity | A identifier for a specific price derivation rule.\n |
| RecurrenceFlag | Flag | Determines whether the price derivation rule is to be applied one time based on attributed effective and ending date timestamps or on a recurring basis as specified in the attribute recurrenc entity type. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| StoreFinancialLedgerAccountID | Identity | The reference for the STORE FINANCIAL LEDGER ACCOUNT |
Tag |
Domain |
Definition |
| Name | Name | A name or label given to this prototype derivation rule recurrence. |
| PriceDerivationRuleEligibilityRecurrenceEndTime | Time | The time at which the price derivation rule is no longer valid. |
| PriceDerivationRuleEligibilityRecurrenceStartTime | Time | The time for which the price derivation rule is valid. |
| PriceDerivationRuleEligibilityRecurrenceWeekDay | DateFiscalDay | The day of the week for which the price derivation rule is valid. |
| PriceDerivationRuleID | Identity | A identifier for a specific price derivation rule.\n |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
Tag |
Domain |
Definition |
| CarrierID | Identity | The carrier presenting the bill of lading. |
| FreightBillID | Identity | The carrier-assigned shipping document number |
| InventoryControlDocumentID | Identity | The reference number that uniquely identifies the INVENTORY CONTROL DOCUMENT. |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
Tag |
Domain |
Definition |
| CustomerID | Identity | A unique identifier for a customer. |
| CustomerOccasionDate | DateCalendar | The start date of a an event or other occasion that a customer celebrates. |
| CustomerOccasionTypeName | Name | A short label for a group of CUSTOMER OCCASIONs. For instance, this could be a wedding, a high school graduation, a birthday, a golden wedding anniversary, etc. |
| Description | DescriptionNarrative | A description of a class or group of items that have been added to a gift registry for a customer. |
Tag |
Domain |
Definition |
| ItemID | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
| Name | Name | The name to denote the type of association between the two RELATED ITEMs. |
| Related | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
Tag |
Domain |
Definition |
| FiscalYear | DateCalendarYear | An identifier that uniquely identifies a particular FISCAL YEAR in CCYY format. |
| ItemID | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
| Related | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
| RelatedItemSoldSeparatelyTransactionCount | QuantityTransactionCount | Count of transactions in which the associated item is sold without the item. |
| ReportingPeriodID | Identity | The identifier for a particular REPORTING PERIOD. |
| ReportingPeriodTypeCode | Code2 | A code to denote a specific REPORTING PERIOD. |
| SoldSeparatelyTransactionCount | QuantityTransactionCount | Count of transactions in which the item is sold without the associated item. |
| SoldTogetherTransactionCount | QuantityTransactionCount | A count of the number of transactions in which the items in the item association were sold together. |
| TotalSalesTransactionCount | QuantityTransactionCount | Total sale transaction count for the same period as the item association accumulators - used to calculate ratios and percentages. |
Tag |
Domain |
Definition |
| ItemID | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
| Name | Name | The name of the RENTAL OBJECT. For example in the case of video rental this could refer to the film title. |
| RentalObjectId | Identity | The reference which uniquely identifies the RENTAL OBJECT. |
| TypeCode | Code2 | The type of OBJECT being offered for rental. |
Tag |
Domain |
Definition |
| DepositAmount | Money | A deposit related to the value of the RENTAL OBJECT which is paid by the CUSTOMER and is refundable if the ITEM is returned in the same condition. |
| DepositPercent | Percent | The percentage of the value of the RENTAL OBJECT which is charged as a refundable deposit to the CUSTOMER.\n\n |
| ItemID | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
| PenaltyAmount | Money | The penalty amount which is imposed by the RETAILER if the CUSTOMER fails to meet the rental terms.\n |
| PenaltyPercent | Percent | The percentage penalty which is imposed if the terms of the rental are abused by the CUSTOMER, eg if the rental item is delivered late the penalty is 10% of the rental fee for each date late.\n |
| PeriodCount | QuantityDayCount | The number of rental periods.\n |
| PeriodTypeCode | Code2 | A code to denote the rental period, 1 day, 3 days, 1 week, etc.\n |
| PerPeriodAmount | Money | The monetary charge for each rental period.\n |
| TermsID | Identity | A specific reference to the rental terms governing the rental of RENTAL OBJECT.\n |
Tag |
Domain |
Definition |
| ItemID | Identity | The retailer's SKU or unique item identifier for items sold or returned. |
| NumberOfTimesRentedCount | QuantityTransactionCount | A count of the number of times a specific OBJECT has been rented or hired out. |
| RentalObjectID | Identity | The reference which uniquely identifies the RENTAL OBJECT. |
| RentalUnitID | Identity | A reference for a particular copy or product. For example this would refer to the second copy of a video title. |
Tag |
Domain |
Definition |
| FiscalDayNumber | DateFiscalDay | The week day part of a fiscal date numbered 1 (Sun) through 7 (Sat) |
| FiscalMonth | DateFiscalMonth | A fiscal (financial) month. |
| FiscalQuarterID | DateFiscalQuarter | The identifier which uniquely specifies a FISCAL QUARTER within a specific FISCAL YEAR. |
| FiscalWeekNumber | DateFiscalWeek | The relative week with in a fiscal year expressed as an integer count. |
| FiscalYear | DateCalendarYear | An identifier that uniquely identifies a particular FISCAL YEAR in CCYY format. |
| Name | Name | The business name for the reporting period. |
| ReportingPeriodID | Identity | The identifier for a particular REPORTING PERIOD. |
| ReportingPeriodTypeCode | Code2 | A code to denote a specific REPORTING PERIOD. |
| SeasonCode | Code2 | A unique identifier for the SEASON and year. |
| SubseasonCode | Code2 | A code for a specific subseason. This is normally stated as SUBSEASON, within SEASON, within FISCAL YEAR. |
Tag |
Domain |
Definition |
| AdjudicationCode | Code4 | Adjudication to the request for credit or debit. |
| ApprovalDocumentID | Identity | The serial number of the document approving the request for debit or credit. |
| InventoryControlDocumentID | Identity | The reference number that uniquely identifies the INVENTORY CONTROL DOCUMENT. |
| ReasonCode | Code2 | Reason code for debit or credit request. This code refers to the UCC code, Adjustment Reason Code, data element 426. |
| RequestedByEmployeeID | Identity | The EMPLOYEE requesting the debit or credit |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| TypeCode | Code2 | A code to denote whether the request is for a debit or credit. This code refers to the UCC code, Credit/Debit Flag Code, data element 478. |
Tag |
Domain |
Definition |
| Description | DescriptionShort | A textual description of the application RESOURCE. Examples include descriptions of application invocation functions, screens and fields.\n |
| ParentResourceID | Identity | The next highest ownership level for a given RESOURCE. For example, a field resource is owned by the application screen resource to which that field is assigned. |
| ResourceID | Identity | A code to uniquely identify a given application or application component.\n |
Tag |
Domain |
Definition |
| Amount | Money | The flat amount to be applied to the unit retail to arrive at the modified selling price. |
| BusinessDayDate | DateCalendar | The calendar date equivalent of the associated fiscal day, fiscal week and fiscal year. |
| DerivationRuleID | Identity | Identifies the rule fired off to create and apply this retail price modifier. Note that this attribute may be replaced by a foreign key reference as the retail price derivation rules view is further developed. The intent here is to provide an audit trail that shows HOW a retail selling price is derived from the look up price read from the ITEM UNIT RETAIL AND COST entity. |
| Percent | Percent | The percent of the look up retail price to be applied to the unit retail to arrive at the modified selling price. |
| ReasonCode | Code2 | A code that describes why the price modifier is applied to the line item. |
| RetailPriceModifierSequenceNumber | LineNumber | The sequence number to signify a particular instance of a PRICE LINE MODIFIER.\n |
| RetailStoreID | Identity | A unique identifier for a specific RETAIL STORE within the organization. Typically, STOREs are given a unique reference number. |
| RetailTransactionLineItemSequenceNumber | LineNumber | The sequence number of line item within a TRANSACTION. |
| StockLedgerAccountingDispositionCode | Code4 |