Change LogITEM XML-DB Mapping DocumentThis document describes mapping between the Data Model and the data as defined within ItemImport.xsd.SUBJECT AREAPhysical table NameLogical table NameCommentItemAS_ITMItemAS_ITM_I8ItemI18nAS_ITM_STKStockItemAS_ITM_RTL_STRRetailStoreItemID_IDN_PSPOSIdentityCO_BRK_SPR_ITM_BSSupplierItemCatalogBaseCostBreakTR_CHN_PRN_PRCPermanentPriceChangeAS_ITM_IMGItemImageAS_ITM_ASCTN_MSGItemMessageAssociationPreload DataCO_CLRItemColorCO_CLR_I8ItemColorI18NCO_SZItemSizeCO_SZ_I8ItemSizeI18NCO_STYLItemStyleCO_STYL_I8ItemStyleI18NCO_UOMUnitOfMeasureCO_UOM_I8UnitOfMeasureI18NAS_ITM_PDTItemProductdeprecated as 13.1LU_CD_STRC_MRMerchandiseClassificationCodeLU_CD_STRC_MR_I8MerchandiseClassificationCodeI18NPA_SPRSupplierPA_SPR_I8SupplierI18NPA_MFManufacturerPA_MF_I8ManufacturerI18NDO_MSGItemMessageDO_MSG_I8ItemMessageI18NAS_ITM_LSTItemListAssociationCHANGE LOGVersionDateAuthorAction1.02/7/06Christian GreeneInitial draft1.13/23/07ISC TeamModified.1.24/3/07Christian GreeneUpdate some some elements and spreadsheet formatting.1.34/4/07Christian GreeneMerged Manas' XSD mapping sheet.1.44/5/07Christian GreeneMapped POSDNLD and POSCDNLD1.58/8/07Christian GreeneAdded Max Lengths for Names1.68/22/07Maisa De CamargoRemoved References to SupplierItem Table (AS_ITM_SPR). This table is for inventory purpose only.1.78/30/07Kaitlyn LundriganAdd yellow highlight to data element SupplierItemCatalogBaseCostBreak - SupplierID for which the XSD does not restrict length, but which the customer is expected to limit anyway.1.810/24/07Christian GreeneRe-mapped SellingPrice to PermanentPriceChange1.912/6/07Christian GreeneChange "SellingPrice" to "RegularPrice"2.02/11/09Ashwyn TirkeyItem Images changes2.12/11/09Vivekanand KiniItem Message changes2.22/13/09Gloria WangI18N related changes2.33/31/09Christian GreeneUpdated ItemImage mapping3.04/1/09Stephen GonzalesUpdated mapping document template; added I18N notes on multibyte character limits; added XSD data types and notes; corrected DB data types.3.14/14/09Stephen GonzalesItem Mapping: Updated mapping to DE_ITM_SHRT for case of StoreCoupon loading.3.212/2/09Manikandan ChellappanItem Mapping : Added the new Serialization fields.3.37/15/10Christian GreeneDocument that Item's RetailStoreID can be different from the bundle's store ID.3.44/11/12Srirama Thallam1.removed classification mapping from Item 2.Added Item List MappingNOTES:Bold elements indicate primary keys.

Preload MappingTARGET - CO/BO DatabaseTransformation RulesSOURCE XML - ItemImport.XSDLogical / Physical TableLogical Column NamePhysical Column NameDataTypeField/Column Name/XpathField TypeLengthValid Values / Functional NotesItemColorColorCodeED_CLRVARCHAR(20)ItemImport/PreloadData/Color@CodeString20CO_CLRColorNamesNM_CLRVARCHAR(120)ItemImport/PreloadData/Color@NamesString120DescriptionDE_CLRVARCHAR(250)ItemImport/PreloadData/Color@DescriptionString250RecordCreatedTimestampTS_CRT_RCRDTIMESTAMPNow( )RecordLastModifiedTimestampTS_MDF_RCRDTIMESTAMPNow( )ItemColorI18NColorCodeED_CLRVARCHAR(20)ItemImport/PreloadData/Color@CodeString20CO_CLR_I8LocaleLCLVARCHAR(10)No mapping availableSystem Supported LocalesLocalizedColorNameNM_CLRVARCHAR(120)ItemImport/PreloadData/Color/LocalizedNameDescription@NameString120The length here is defined as the length of single byte string. If multibyte characters are used, the max length should be 120/4 = 30.LocalizedColorDescriptionDE_CLRVARCHAR(250)ItemImport/PreloadData/Color/LocalizedNameDescription@DescriptionString250The length here is defined as the length of single byte string. If multibyte characters are used, the max length should be 250/4 = 60.ItemSizeSizeCodeED_SZVARCHAR(10)ItemImport/PreloadData/Size@CodeString10CO_SZActualSizeProportionDescriptionDE_PRPTN_ACT_SZVARCHAR(250)ItemImport/PreloadData/Size@ProportionDescString250ActualSizeTypeDescriptionDE_TYP_ACT_SZVARCHAR(250)ItemImport/PreloadData/Size@TypeDescString120ActualSizeCodeED_SZ_ACTVARCHAR(20)ItemImport/PreloadData/Size@ActualSizeCodeString20TableNameNM_TB_SZVARCHAR(120)ItemImport/PreloadData/Size@TableNameString120TableCodeED_TB_SZVARCHAR(20)ItemImport/PreloadData/Size@TableCodeString20TableDescriptionDE_TB_SZVARCHAR(250)ItemImport/PreloadData/Size@TableDescString250RecordCreatedTimestampTS_CRT_RCRDTIMESTAMPNow( )RecordLastModifiedTimestampTS_MDF_RCRDTIMESTAMPNow( )ItemSizeI18NSizeCodeED_SZVARCHAR(10)ItemImport/PreloadData/Size@CodeString10CO_SZ_I8LocaleLCLVARCHAR(10)No mapping availableSystem Supported LocalesLocalizedActualSizeProportionDescriptionDE_PRPTN_ACT_SZVARCHAR(250)ItemImport/PreloadData/Size/LocalizedSizeData@ProportionDescString250The length here is defined as the length of single byte string. If multibyte characters are used, the max length should be 250/4 = 60.LocalizedActualSizeTypeDescriptionDE_TYP_ACT_SZVARCHAR(250)ItemImport/PreloadData/Size/LocalizedSizeData@TypeDescString120The length here is defined as the length of single byte string. If multibyte characters are used, the max length should be 250/4 = 60.LocalizedTableNameNM_TB_SZVARCHAR(120)ItemImport/PreloadData/Size/LocalizedSizeData@TableNameString120The length here is defined as the length of single byte string. If multibyte characters are used, the max length should be 120/4 = 30.LocalizedTableDescriptionDE_TB_SZVARCHAR(250)ItemImport/PreloadData/Size/LocalizedSizeData@TableDescString250The length here is defined as the length of single byte string. If multibyte characters are used, the max length should be 250/4 = 60.ItemStyleStyleCodeLU_STYLVARCHAR(4)ItemImport/PreloadData/Style@CodeString4CO_STYLStyleNameNM_STYLVARCHAR(120)ItemImport/PreloadData/Style@NameString120DescriptionDE_STYLVARCHAR(250)ItemImport/PreloadData/Style@DescriptionString250RecordCreatedTimestampTS_CRT_RCRDTIMESTAMPNow( )RecordLastModifiedTimestampTS_MDF_RCRDTIMESTAMPNow( )ItemStyleI18NStyleCodeLU_STYLVARCHAR(4)ItemImport/PreloadData/Style@CodeString4CO_STYL_I8LocaleLCLVARCHAR(10)No mapping availableSystem Supported LocalesLocalizedStyleNameNM_STYLVARCHAR(120)ItemImport/PreloadData/Style/LocalizedNameDescription@NameString120The length here is defined as the length of single byte string. If multibyte characters are used, the max length should be 120/4 = 30.LocalizedStylerDescriptionDE_STYLVARCHAR(250)ItemImport/PreloadData/Style/LocalizedNameDescription@DescriptionString250The length here is defined as the length of single byte string. If multibyte characters are used, the max length should be 250/4 = 60.UnitOfMeasureUnitOfMeasureCodeLU_UOMVARCHAR(2)ItemImport/PreloadData/UOM@CodeString2CO_UOMEnglishMetricFlagFL_UOM_ENG_MCCHAR(1)ItemImport/PreloadData/UOM@SystemEnum"Metric" = 1NameNM_UOMVARCHAR(120)ItemImport/PreloadData/UOM@NameString120UnitOfMeasureTypeCodeTY_UOMVARCHAR(2)ItemImport/PreloadData/UOM@TypeCodeString2DescriptionDE_UOMVARCHAR(250)ItemImport/PreloadData/UOM@DescriptionString250DefaultUnitOfMeasureFlagFL_DFLT_UOMCHAR(1)ItemImport/PreloadData/UOM@IsDefaultBooleanDefaultEntryCodeFL_CD_ENT_DFLTCHAR(1)ItemImport/PreloadData/UOM@DefaultEntryCodeBooleanEnabledFlagFL_CD_ENT_ENABCHAR(1)ItemImport/PreloadData/UOM@EnabledBooleanListSortIndexCD_ENT_SRTSMALLINTItemImport/PreloadData/UOM@SortIndexIntUnitOfMeasureI18NUnitOfMeasureCodeLU_UOMVARCHAR(2)ItemImport/PreloadData/UOM@CodeString2CO_UOM_I8LocaleLCLVARCHAR(10)No mapping availableSystem Supported LocalesUnitOfMeasureNameNM_UOMVARCHAR(120)ItemImport/PreloadData/UOM/LocalizedNameDescription@NameString120The length here is defined as the length of single byte string. If multibyte characters are used, the max length should be 120/4 = 30.UnitOfMeasureDescriptionDE_UOMVARCHAR(250)ItemImport/PreloadData/UOM/LocalizedNameDescription@DescriptionString250The length here is defined as the length of single byte string. If multibyte characters are used, the max length should be 250/4 = 60.ItemProductItemProductIDID_ITM_PDTAS_ITM_PDTItemProductDescriptionDE_ITM_PDTManufacturerIDID_MFRecordCreatedTimestampTS_CRT_RCRDTIMESTAMPRecordLastModifiedTimestampTS_MDF_RCRDTIMESTAMPManufacturerManufacturerIDID_MFVARCHAR(22)ItemImport/PreloadData/Manufacturer@IDString20PA_MFNameNM_MFVARCHAR(120)ItemImport/PreloadData/Manufacturer@NameString120PartyIDID_PRTYNull value to be storedRecordCreatedTimestampTS_CRT_RCRDTIMESTAMPNow( )RecordLastModifiedTimestampTS_MDF_RCRDTIMESTAMPNow( )ManufacturerI18NManufacturerIDID_MFVARCHAR(22)ItemImport/PreloadData/Manufacturer@IDString20PA_MF_I8LocaleLCLVARCHAR(10)No mapping availableSystem Supported LocalesLocalizedNameNM_MFVARCHAR(120)ItemImport/PreloadData/Manufacturer/LocalizedName@NameString120The length here is defined as the length of single byte string. If multibyte characters are used, the max length should be 120/4 = 30.MerchandiseClassificationCodeMerchandiseClassificationCodeID_STRC_MR_CDVARCHAR(10)ItemImport/PreloadData/MerchandiseClassification@CodeString10LU_CD_STRC_MRMerchandiseClassificationCodeDescriptionDE_STRC_MR_CDVARCHAR(250)ItemImport/PreloadData/MerchandiseClassification@DescriptionString250RecordCreatedTimestampTS_CRT_RCRDTIMESTAMPNow( )RecordLastModifiedTimestampTS_MDF_RCRDTIMESTAMPNow( )MerchandiseClassificationCodeI18NMerchandiseClassificationCodeID_STRC_MR_CDVARCHAR(10)ItemImport/PreloadData/MerchandiseClassification@CodeString10LU_CD_STRC_MR_I8LocaleLCLVARCHAR(10)No mapping availableSystem Supported LocalesLocalizedMerchandiseClassificationCodeDescriptionDE_UOMVARCHAR(250)ItemImport/PreloadData/MerchandiseClassification/LocalizedDescription@DescriptionString250The length here is defined as the length of single byte string. If multibyte characters are used, the max length should be 250/4 = 60.SupplierSupplierID_SPRVARCHAR(20)ItemImport/PreloadData/Supplier@IDString20PA_SPRDUNSNumberDU_SPRVARCHAR(9)ItemImport/PreloadData/Supplier@DUNSNumberString9NameNM_SPRVARCHAR120)ItemImport/PreloadData/Supplier@NameString120PartyIDID_PRTYINTEGERNull value to be storedColumn not used in DB.PartyRoleTypeCodeTY_RO_PRTYVARCHAR(20)Null value to be storedColumn not used in DB.SupplierIsManufacturerFlagFL_MF_SPR_ISCHAR(1)ItemImport/PreloadData/Supplier@IsManufacturerBooleanSupplierI18NSupplierLU_UOMVARCHAR(20)ItemImport/PreloadData/Supplier@IDString20PA_SPR_I8LocaleLCLVARCHAR(10)No mapping availableSystem Supported LocalesLocalizedNameNM_SPRVARCHAR(120)ItemImport/PreloadData/Supplier/LocalizedName@NameString120The length here is defined as the length of single byte string. If multibyte characters are used, the max length should be 120/4 = 30.DO_MSGMessage IDID_MSGINTEGERItemImport/PreloadData/Message@IDIntMaximum field size for INTEGER is typically NUMBER(10) to support Java INT datatype in application.ItemMessageI18NMessage IDID_MSGINTEGERItemImport/PreloadData/Message@IDIntDO_MSG_I8LocaleLCLVARCHAR(10)ItemImport/PreloadData/Message/MsgText@LanguageString2MessageDisplayNameNM_MSG_DPLYVARCHAR(120)ItemImport/PreloadData/Message/MsgText@NameStringThe length here is defined as the length of single byte string. If multibyte characters are used, the max length should be 120/4 = 30.MessageDisplayTextNA_MSG_DPLYCLOBItemImport/PreloadData/Message/MsgTextString250

masahu:Product PreLoad has been removed as part of the import

Item MappingTARGET - CO/BO DatabaseTransformation RulesSOURCE XML - PricingImport.XSDLogical / Physical TableLogical Column NamePhysical Column NameDataTypeField/Column Name/XpathField TypeLengthValid Values / Functional NotesItemItemIDID_ITMVARCHAR(14)ItemImport/Item@IDString14AS_ITMItemProductIDID_ITM_PDTVARCHAR(14)No mapping availableColumn use deprecated.DiscountFlagFL_ITM_DSCCHAR(1)ItemImport/Item@DiscountableBooleantrue = "1", false= "0"DamageDiscountFlagFL_ITM_DSC_DMGCHAR(1)ItemImport/Item@DamageDiscountableBooleantrue = "1", false= "0"PriceAuditFlagFL_ADT_ITM_PRCCHAR(1)Null Value to be enteredNo mapping availableItemSizeRequiredFlagFL_ITM_SZ_REQCHAR(1)ItemImport/Item@SizeRequiredBooleantrue = "1", false= "0"POSDepartmentIDID_DPT_POSVARCHAR(14)ItemImport/Item@POSDepartmentIDString10*AuthorizedForSaleFlagFL_AZN_FR_SLSCHAR(1)ItemImport/Item@AuthorizedForSaleBooleantrue = "1", false= "0"TaxExemptCodeLU_EXM_TXVARCHAR(20)ItemImport/Item@TaxableBooleantrue = "1", false= "0"UsageCodeLU_ITM_USGVARCHAR(20)Null Value to be enteredNo mapping availableNameNM_ITMVARCHAR(120)Null Value to be enteredNo mapping availableDescriptionDE_ITMVARCHAR(250)ItemImport/Item/LongDescriptionString250AbbreviatedDescriptionDE_ITM_SHRTVARCHAR(120)ItemImport/Item/ShortNameItemImport/Item/LongDescription (for Item@Type="Coupon" only)String120Based on the default locale the ShortName specific to the locale is inserted into the column. When application is I18N aware then each locale specific data will be inserted into the locale table.When Item@Type = "Coupon" then /LongDescription will be truncated to 120 characters; for multi-byte characters more truncation may occur.TypeCodeTY_ITMVARCHAR(20)ItemImport/Item@TypeEnumStock=STCK, Service=SRVC, Coupon=SCPNKitSetCodeLU_KT_STVARCHAR(20)ItemImport/Item@KitSetCodeString200 (Default Value)means item is not part of a kit1 means it is a kit and this item is the header of the kit2 means this item is one of the component of the kit. of 0.SubstituteIdentifiedFlagFL_ITM_SBST_IDNCHAR(1)Default value of 0No mapping availableOrderCollectionCodeLU_CLN_ORDVARCHAR(20)Null Value to be enteredNo mapping availableMerchandiseStructureIDID_STRC_MRINTEGER-1ItemImport/Item/MerchandiseHierarchy@StructureIDStringDefault is -1. This field is not used by the application.PriceLineIDID_LN_PRCINTEGERNull Value to be enteredNo mapping availableBrandNameNM_BRNVARCHAR(120)Null Value to be enteredNo mapping availableSeasonCodeLU_SNVARCHAR(20)Null Value to be enteredNo mapping availableFiscalYearFYVARCHAR(4)Null Value to be enteredNo mapping availableMerchandiseHierarchyLevelCodeLU_HRC_MR_LVVARCHAR(4)ItemImport/Item/MerchandiseHierarchy@LevelString4SubseasonCodeLU_SBSNVARCHAR(20)Null Value to be enteredNo mapping availableTaxGroupIDID_GP_TXINTEGERItemImport/RetailStoreItem@VatCode orItemImport/RetailStoreItem@TaxGroup orItemImport/Item@TaxGroupIntStringInt20If the vatcode or the taxgroup attributes is given in the retailstoreitem tag the corresponding value only will be inserted in the ID_GP_TX column. If both of the vatcode and taxgroup attributes are not provided, the Item@taxgroup attribute will be considered otherwise it will be ignored.ActivationRequiredFlagFL_ACTVN_RQCHAR(1)ItemImport/Item@ActivationRequiredBooleantrue = "1", false= "0"RegistryEligibleFlagFL_ITM_RGSTRYCHAR(1)ItemImport/Item@RegistryEligibleBooleantrue = "1", false= "0"MerchandiseHierarchyIDID_MRHRC_GPVARCHAR(14)ItemImport/Item/MerchandiseHierarchyStringManufacturerIDID_MFINTEGERDefault value of 0RecordCreatedTimestampTS_CRT_RCRDTIMESTAMPNow( )RecordLastModifiedTimestampTS_MDF_RCRDTIMESTAMPNow( )ItemI18NItemIDID_ITMVARCHAR(14)ItemImport/Item@IDString14AS_ITM_I8LocaleLCLVARCHAR(10)No mapping availableSystem SupportedLocaleDesriptionDE_ITMVARCHAR(250)ItemImport/Item/LocalizedNameDescription@DescriptionString250The length here is defined as the length of single byte string. If multibyte characters are used, the max length should be 250/4 = 60.ItemNameNM_ITMVARCHAR(120)No mapping availableAbbreviatedDescriptionDE_ITM_SHRTVARCHAR(120)ItemImport/Item/LocalizedNameDescription@NameString120The length here is defined as the length of single byte string. If multibyte characters are used, the max length should be 120/4 = 30.BrandNameNM_BRNVARCHAR(120)No mapping availableStockItemItemIDID_ITMVARCHAR(14)ItemImport/Item@IDString14AS_ITM_STKStockItemSaleUnitOfMeasureCodeLU_UOM_SLSVARCHAR(20)Default to "UN" for "units" if not specifiedItemImport/Item@UOMCodeString20ColorCodeED_CLRVARCHAR(20)ItemImport/Item@ColorString20SizeCodeED_SZVARCHAR(10)ItemImport/Item@SizeString10StyleCodeLU_STYLVARCHAR(4)ItemImport/Item@StyleString4RetailStoreIDID_STR_RTVARCHAR(5)No mapping availableShelfItemConsumerPackageHeightQL_HT_PCKG_CNSDECIMAL(9,2)No mapping availableSupplierIDID_SPRVARCHAR(20)ItemImport/Item/RetailStoreItem/POSIdentity@SupplierIDStringSerializedItemModelNumberNM_NMB_SRZ_ITM_MDLVARCHAR(40)No mapping availableShelfItemConsumerPackageWidthQL_UOM_WD_PCKG_CNSDECIMAL(9,2)No mapping availableBulkToSellingUnitWasteTypeCodeTY_WST_BLK_SLSVARCHAR(20)No mapping availableSerializedItemModelYearCY_MDL_SRZ_ITMVARCHAR(4)No mapping availableShelfItemsHeldCapacityCountQU_CPC_HLDDECIMAL(9,2)No mapping availablePackItemWeightCountQW_ITM_PCKDECIMAL(9,2)ItemImport/Item@PackItemWeightCountDecimalUnitOfMeasureCodeLU_UOMVARCHAR(2)No mapping availableDisplayUnitTypeCodeTY_UN_DPLYVARCHAR(20)No mapping availablePackItemCubeCountQU_CB_PCK_ITMDECIMAL(9,2)No mapping availableShelfItemConsumerPackageDepthQL_PCKG_CNSDECIMAL(9,2)No mapping availableSerializedItemManufacturerColorDescriptionDE_CLR_MF_SRZ_ITMVARCHAR(250)No mapping availableStockItemTypeCodeTY_ITM_STKVARCHAR(20)No mapping availableBulkToSellingUnitWasteFactorPercentPE_WST_BLK_SLSDECIMAL(5,2)No mapping availableShelfItemConsumerPackageDimensionUnitOfMeasureCodeLU_UOM_PCKG_CNS_DMNVARCHAR(20)No mapping availableStockItemSaleUnitPrimaryMeasurementSystemCodeLU_SYS_PRMRY_MSVARCHAR(20)No mapping availableSerializedItemManufacturerSizeDescriptionDE_SZ_MF_SRZ_ITMVARCHAR(250)No mapping availablePackItemUnitNumberCountQU_UN_PCK_ITMDECIMAL(9,2)No mapping availableDisplayUnitSetUpDateDC_UN_DPLY_ST_UPDATENo mapping availableSerializedItemManufacturerWarrantyDescriptionCodeLU_WRTY_MF_SRZ_ITMVARCHAR(20)No mapping availableShelfItemConsumerPackageWeightQW_WT_PCKG_CNSDECIMAL(9,2)No mapping availableDisplayUnitTakeDownDateDC_UN_DPLY_TK_DWNDATENo mapping availableFabricDescriptionDE_FBRCVARCHAR(250)No mapping availableDisplayUnitDispositionCodeDP_UN_DPLYVARCHAR(20)No mapping availableStockItemSaleWeightOrUnitCountCodeLU_CNT_SLS_WT_UNVARCHAR(20)No mapping availableSerializedItemStoreWarrantyDescriptionCodeLU_WRTY_STR_SRZVARCHAR(20)No mapping availableShelfItemConsumerPackageWeightUnitOfMeasureCodeLU_UOM_WT_PCKG_CNSVARCHAR(20)No mapping availableStockItemCustomerPickupTypeCodeTY_PKP_CT_STK_ITMVARCHAR(20)No mapping availableShelfItemConsumerPackageSizeUnitOfMeasureCodeLU_UOM_SZ_PCKG_CNSVARCHAR(20)No mapping availableSilhouetteDescriptionDE_SLHVARCHAR(250)No mapping availableSerializedItemValidationFlagFL_VLD_SRZ_ITMCHAR(1)ItemImport/Item@SerializedItemBooleantrue = "1", false= "0"SerializedItemTypeTY_SRZ_ITMVARCHAR(40)ItemImport/Item@UINTypeStringSerializedItemLabelIDID_SRZ_ITM_LBINTEGERThis ID will be generated by the system.IntegerSerialNumberCaptureTimeCodeCD_SRZ_CPT_TMVARCHAR(20)ItemImport/Item@UINCaptureTimeStringExternalSerialNumberCreateFlagFL_SRZ_CRTCHAR(1)ItemImport/Item@ExternalSystemCreateUINBooleantrue = "1", false= "0"StockItemUnitPriceFactorFA_PRC_UN_STK_ITMDECIMAL(9,2)No mapping availableShelfItemDsdAuthorizedFlagFL_DSD_AZNCHAR(1)No mapping availableStockItemShelfLifePeriodDayCountDI_PRD_SH_LFDECIMAL(3)No mapping availableShelfItemShelfLifeDayCountDI_LF_SHDECIMAL(3)No mapping availableShelfItemBrokerIdID_BRKRINTEGERNo mapping availableStockItemAvailableForSaleDateDC_AVLB_FR_SLSDATENo mapping availableShelfItemStaplePerishableTypeCodeTY_ITM_STPL_PRSHVARCHAR(20)No mapping availableStockItemEnvironmentTypeCodeTY_ENV_STK_ITMVARCHAR(20)No mapping availableShelfItemAisleLocationNM_LCN_ASLVARCHAR(250)No mapping availableStockItemSecurityRequiredTypeCodeTY_SCTY_RQVARCHAR(20)No mapping availableShelfItemShelfLocationNM_LCN_SHVARCHAR(250)No mapping availableShelfItemSideLocationNM_LCN_SIDVARCHAR(250)No mapping availableStockItemHazardousMaterialTypeCodeTY_MTR_HZ_STK_ITMVARCHAR(20)No mapping availableShelfItemFacingsCountQU_FCGDECIMAL(9,2)No mapping availableStockItemSellUnitLastReceivedBaseCostAmountCP_UN_SL_LS_RCV_BSDECIMAL(7,3)No mapping availableStockItemSellUnitLastReceivedNetCostAmountCP_CST_NT_LS_RCVDECIMAL(7,3)No mapping availableStockItemSellUnitLandedCostAmountCP_UN_SL_LNDDECIMAL(7,3)No mapping availableStockItemSellUnitLastReceivedCostsEstablishedDateDC_CST_EST_LS_RCVDATENo mapping availableStockItemShrinkFlagFL_SHRK_SH_ITMCHAR(1)No mapping availableStockItemSwellFlagFL_SWL_SH_ITMCHAR(1)No mapping availableShelfItemUnitPricingRequiredFlagFL_RQ_UN_PRCCHAR(1)No mapping availableRestockingFeeFlagFL_FE_RSTKCHAR(1)ItemImport/Item@RestockingFeeBooleantrue = "1", false= "0"DispositionCodeIDID_DPSN_CDINTEGERNo mapping availableRecordCreationTimestampTS_CRT_RCRDTIMESTAMPNow( )RecordLastModifiedTimestampTS_MDF_RCRDTIMESTAMPNow( )RetailStoreItemRetailStoreIDID_STR_RTVARCHAR(5)ItemImport/Item/RetailStoreItem/RetailStoreIDThis value can be different from the bundle's metadata, i.e. the bundle file name or manifest.mf property.AS_ITM_RTL_STRItemIDID_ITMVARCHAR(14)ItemImport/Item@IDString14UpdateStockOnHandFlagFL_STK_UPT_ON_HDCHAR(1)No mapping availableSellingStatusCodeEffectiveDateDC_ITM_SLSDATENo mapping availableSellingStatusCodeSC_ITM_SLSVARCHAR(2)No mapping availableCompareAtSaleUnitRetailPriceAmountRP_PRC_CMPR_AT_SLSDECIMAL(8,2)ItemImport/Item/RetailStoreItem/RegularPrice@CompareAtPriceDecimal13,2*ManufacturerSaleUnitRecommendedRetailPriceEffectiveDateDC_PRC_MF_REC_RTDATENo mapping availableManufacturerSaleUnitRecommendedRetailPriceAmountRP_PRC_MF_REC_RTDECIMAL(8,2)No mapping availableTaxGroupIDID_GP_TXINTEGERItemImport/Item/RetailStoreItem@TaxGroupItemImport/Item/RetailStoreItem@VatCodeIntString20If VatCode is not provided, then only ID_GP_TX will be filled with the value of the taxgroup attribute. The VatCode will be the VAT Code Name. VatCode will have to be translated from some String (xs:string) to an Integer. The VatCode should match a name specified in RU_TX_GP.NM_RU_TX. The ID_GP_TX of the name will be the ID used to insert into AS_ITM_RTL_STR.ID_GP_TAX for the incoming VatCode.CurrentSaleUnitRetailPriceExpirationDateDC_PRC_SLS_EP_CRTDATENo mapping availableCurrentSaleUnitRetailPriceEffectiveDateDC_PRC_SLS_EF_CRTDATENo mapping availableCurrentSaleUnitRetailPricePointAllowedFlagFL_PRC_RT_PNT_ALWCHAR(1)No mapping availableCurrentSaleUnitRetailPriceTypeCodeTY_PRC_RTVARCHAR(2)No mapping availableCurrentSaleUnitRetailPriceAmountRP_SLS_CRTDECIMAL(8,2)No mapping availablePermanentRetailPriceEffectiveDateDC_PRC_EF_PRN_RTDATENo mapping availablePermanentRetailPricePermanentMarkdownCountQU_MKD_PR_PRC_PRDECIMAL(7,3)No mapping availablePermanentSaleUnitRetailPriceOriginalMarkdownFlagFL_MKD_ORGL_PRC_PRCHAR(1)No mapping availablePermanentSaleUnitRetailPriceAmountRP_PR_SLSDECIMAL(8,2)No mapping availableStatusCodeSC_ITMVARCHAR(2)No mapping availableSalesAgeRestrictionIdentifierIDN_SLS_AG_RSTINTEGERItemImport/Item/RetailStoreItem@AgeRestrictionIDIntLabelTemplateIDID_TMPLT_LBVARCHAR(8)ItemImport/Item/RetailStoreItem@TemplateIDString8Defaults to *DEFAULT upon insertsRecordCreationTimestampTS_CRT_RCRDTIMESTAMPNow( )RecordLastModifiedTimestampTS_MDF_RCRDTIMESTAMPNow( )POSIdentityRetailStoreIDID_STR_RTVARCHAR(5)ItemImport/Item/RetailStoreItem/RetailStoreIDThis value can be different from the bundle's metadata, i.e. the bundle file name or manifest.mf property.ID_IDN_PSPOSItemIDID_ITM_POSVARCHAR(14)ItemImport/Item/RetailStoreItem/POSIdentity@POSItemIDString14ItemIDID_ITMVARCHAR(14)ItemImport/Item@IDString14ItemDescriptionDE_ITM_POSVARCHAR(250)No mapping availableCurrentSaleUnitPOSRetailPriceAmountRP_SLS_POS_CRTDECIMAL(8,2)No mapping availableFrequentShopperPointsEligibleFlagFL_PNT_FQ_SHPR_ELCHAR(1)No mapping availableManufacturerIDID_MFINTEGERItemImport/Item/RetailStoreItem/POSIdentity@ManufacturerIDIntManufacturerUPCID_ITM_MF_UPCVARCHAR(14)ItemImport/Item/RetailStoreItem/POSIdentity@UPCString14ReturnAgentIDID_AGNT_RTNINTEGERNo mapping availableCustomerAffiliationDiscountAllowedFlagFL_DSC_AF_DSC_ALWCHAR(1)No mapping availableCouponValueCodeLU_VT_PS_CPNCHAR(2)No mapping availableCouponEndOfOfferDateDT_END_PS_CPN_OFRVARCHAR(4)No mapping availableMinimumSaleUnitCountQU_UN_BLK_MNMDECIMAL(5,2)ItemImport/Item/RetailStoreItemImport/Item/POSIdentity@MinimumSaleUnitCountDecimalMaximumSaleUnitCountQU_UN_BLK_MXMDECIMAL(5,2)ItemImport/Item/RetailStoreItemImport/Item/POSIdentity@MaximumSaleUnitCountDecimalMarketBasketDiscountAllowedFlagFL_DSC_MRK_BSK_ALWCHAR(1)No mapping availableCustomerAccountDiscountAllowedFlagFL_DSC_CT_ACNT_ALWCHAR(1)No mapping availableEmployeeDiscountAllowedFlagFL_DSC_EM_ALWCHAR(1)ItemImport/Item/RetailStoreItem/POSIdentity@EmployeeDiscountAllowedBooleantrue = "1", false= "0"AllowCouponMultiplyFlagFL_CPN_ALW_MULTYCHAR(1)ItemImport/Item/RetailStoreItemImport/Item/POSIdentity@AllowCouponMultiplyBooleantrue = "1", false= "0"AllowFoodStampFlagFL_FD_STP_ALWCHAR(1)No mapping availableElectronicCouponFlagFL_CPN_ELNTCCHAR(1)ItemImport/Item/RetailStoreItemImport/Item/POSIdentity@ElectronicCouponBooleantrue = "1", false= "0"CouponRestrictedFlagFL_CPN_RSTCHAR(1)ItemImport/Item/RetailStoreItemImport/Item/POSIdentity@CouponRestrictedBooleantrue = "1", false= "0"PriceEntryRequiredFlagFL_ENTR_PRC_RQCHAR(1)ItemImport/Item/RetailStoreItem/POSIdentity@PriceEntryRequiredBooleantrue = "1", false= "0"WeightEntryRequiredFlagFL_QR_ENR_WTCHAR(1)No mapping availableQuantityKeyProhibitFlagFL_KY_PRH_QTYCHAR(1)ItemImport/Item/RetailStoreItem/POSIdentity@QuantityModifiableEnumQuantityModifiable will have values 'Optional', 'Required' and 'Prohibited'. For Optional and Required we have to set a value of 0 which means that Quantity modification is allowed. For Prohibited we set a value of 1 which means that quantity modification is not allowed.ProhibitReturnFlagFL_RTN_PRHCHAR(1)ItemImport/Item/RetailStoreItemImport/Item/POSIdentity@ReturnableBooleantrue = "1", false= "0"GiveawayFlagFL_ITM_GWYCHAR(1)No mapping availableWICFlagFL_ITM_WICCHAR(1)No mapping availableVisualVerifyPriceFlagFL_PRC_VS_VRCHAR(1)No mapping availableProhibitRepeatKeyFlagFL_KY_PRH_RPTCHAR(1)No mapping availableSpecialOrderEligibleFlagFL_SPO_ITMCHAR(1)ItemImport/Item/RetailStoreItemImport/Item/POSIdentity@SpecialOrderEligibleBooleantrue = "1", false= "0"FrequentShopperPointsCountQU_PNT_FQ_SHPRDECIMAL(9,2)No mapping availableItemTenderRestrictionGroupCodeLU_GP_TND_RSTVARCHAR(20)No mapping availableManufacturerFamilyCodeFC_FMY_MFVARCHAR(3)No mapping availablePriceModifiableFlagFL_MDFR_RT_PRCCHAR(1)ItemImport/Item/RetailStoreItemImport/Item/POSIdentity@PriceModifiableBooleantrue = "1", false= "0"PromotionIDID_PRMINTEGERNo mapping availablePromotionComponentIDID_PRM_CMPINTEGERNo mapping availablePromotionComponentDetailIDID_PRM_CMP_DTLINTEGERNo mapping availableRecordCreationTimestampTS_CRT_RCRDTIMESTAMPNow( )RecordLastModifiedTimestampTS_MDF_RCRDTIMESTAMPNow( )SupplierItemCatalogBaseCostBreakSupplierIDID_SPRVARCHAR(20)ItemImport/Item/RetailStoreItemImport/Item/POSIdentity@SupplierIDStringNote that SupplierID will be required for deleting items.CO_BRK_SPR_ITM_BSSupplierItemIDID_ITM_SPRVARCHAR(20)ItemImport/Item@IDString14SupplierItemCostPerUnitTypeCodeTY_UN_CSTVARCHAR(3)'SLU'SupplierItemUnitBreakPointCountQU_PNT_UND_BRKDECIMAL(9,2)'0'CostPerUnitAmountCP_PNT_BRK_BS_CSTDECIMAL(13,4)ItemImport/Item@ItemCostDecimal13,2*RecordCreationTimestampTS_CRT_RCRDTIMESTAMPNow( )RecordLastModifiedTimestampTS_MDF_RCRDTIMESTAMPNow( )PermanentPriceChangeEventIDID_EVINTEGERGenerated IDTR_CHN_PRN_PRCRetailStoreIDID_STR_RTVARCHAR(5)ItemImport/Item/RetailStoreItem/RetailStoreIDThis value can be different from the bundle's metadata, i.e. the bundle file name or manifest.mf property.SaleUnitAmountMO_CHN_PRN_UN_PRCDECIMAL(10,4)ItemImport/Item/RetailStoreItem/RegularPriceDecimal13,2*SaleUnitAmountTypeCodeTY_CHN_PRN_UN_PRCVARCHAR(20)'5'RecordCreatedTimestampTS_CRT_RCRDTIMESTAMPNow( )RecordLastModifiedTimestampTS_CRT_RCRDTIMESTAMPNow( )ItemImageItemIDID_ITMVARCHAR(14)ItemImport/Item@IDString14AS_ITM_IMGImageLocationITM_IMG_LOCVARCHAR(200)ItemImport/Item@ImageLocationStringThis location should be a valid URL to retrieve the item information.DetailImageITM_DET_IMGBLOBBLOB is taken from the accompanying image file in the bundleItemImport/Item@ImageFileNameStringThis file name is specified in the XML if an image file is present in the bundle.ItemMessageAssociationItemIDID_ITMVARCHAR(14)ItemImport/Item@IDString14AS_ITM_ASCTN_MSGMessageIDID_MSGINTEGERItemImport/Item/DisplayMessage/ItemMsgAscn@IDIntUsageTransactionTypeTY_TRN_USGINTEGERItemImport/Item/DisplayMessage/ItemMsgAscn@TransactionTypeEnumAllowable values are "Sale"=21, "Return"=22DisplayLocationTypeTY_DPLY_LOCINTEGERItemImport/Item/DisplayMessage/ItemMsgAscn@MessageTypeEnumAllowable values are "Screen"=1, "Receipt"=2, "Footer"=3, "Rebate"=4.SerializedItemLabelSerializedItemLabelIDID_SRZ_ITM_LBINTEGERThis ID is generated by the systemIntAS_ITM_SRZ_LBSerializedItemLabelNameNM_SRZ_ITM_LBVARCHAR(120)ItemImport/Item/UINLabel@NameString120SerializedItemLabelI8SerializedItemLabelIDID_SRZ_ITM_LBINTEGERThis ID is generated by the systemIntLocaleLCLVARCHAR(10)ItemImport/Item/UINLabel/LocalizedName@LanguageString10AS_ITM_SRZ_LB_I8SerializedItemLabelNameNM_SRZ_ITM_LBVARCHAR(120)ItemImport/Item/UINLabel/LocalizedName@NameString120ItemListClassification codeID_LST_ITMVARCHAR(10)String10AS_ITM_LSTItemIDID_ITMVARCHAR(14)String14*Red shading indicates potential data conflicts between XML and DB.

ItemImport/Item@UINTypeItemImport/Item@UINCaptureTimeItemImport/Item@ExternalSystemCreateUIN

XSD Tag MappingXSD ElementsLogical DB MappingCommentsUPSERT and DELETE are the only operations supported for Preload data. If "DEL" is not specified as ChangeType, then "UPS" is assumed. (Possible values UPS, DEL)ItemColor.ColorCodeItemColor.DescriptionItemColor.ColorNames (Possible values UPS, DEL)ItemSize.SizeCodeItemSize.ActualSizeProportionDescriptionItemSize.ActualSizeTypeDescriptionItemSize.ActualSizeCodeItemSize.TableNameItemSize.TableCodeItemSize.TableDescription (Possible values UPS, DEL)ItemStyle.StyleCodeItemStyle.StyleNameItemStyle.Description (Possible values UPS, DEL)UnitOfMeasure.UnitOfMeasureCodeUnitOfMeasure.UnitOfMeasureTypeCode (Possible values: Standard, Metric)UnitOfMeasure.EnglishMetricFlagUnitOfMeasure.NameUnitOfMeasure.DescriptionUnitOfMeasure.DefaultUnitOfMeasureFlagUnitOfMeasure.DefaultEntryCodeUnitOfMeasure.EnabledFlagUnitOfMeasure.ListSortIndex (Possible values UPS, DEL)Manufacturer.ManufacturerIDManufacturer.Name (Possible values UPS, DEL)MerchandiseClassificationCode.MerchandiseClassificationCodeMerchandiseClassificationCode.MerchandiseClassificationCodeDescription (Possible values UPS, DEL)Supplier.SupplierSupplier.DUNSNumberSupplier.NameSupplier.SupplierIsManufacturerFlag (Possible values ADD, UPD, DEL)Item.ID, StockItem.ItemID, SupplierItemCatalogBaseCostBreak.SupplierItemID, RetailStoreItem.ItemID, POSIdentity.ItemID (Possible values: Unknown, Stock, Service, Coupon)Item.TypeItem.POSDepartmentIDSupplierItemCatalogBaseCostBreak.CostPerUnitAmountItem.KitSetCodeStockItem.StockItemSaleUnitOfMeasureCodeStockItem.PackItemWeightCountStockItem.SizeCodeStockItem.ColorCodeStockItem.StyleCodeItem.TaxGroup, RetailStoreItem.TaxGroupIDIf the tag RetailStoreItem.VatCode or RetailStoreItem.TaxGroupID is present then that value will have precedence in AS_ITM.ID_GPTAX. Else this value will be insertedItem.TaxExemptFlagItem.DiscountFlagItem.DamageDiscountFlagItem.RegistryEligibleFlagItem.AuthorisedForSaleFlagStockItem.RestockingFeeFlagStockItem.WillCallStockItem.SerializedItemValidationFlagStockItem.SerializedItemTypeStockItem.SerialIdentifierCaptureTimeStockItem.ExternalSerialNumberCreateFlagItem.ItemSizeRequiredFlagItem.ActivationRequiredFlagItem.DetailImageItem.AbbreviatedDescriptiondeprecated as 13.1Item.Descriptiondeprecated as 13.1Item.Localized Description.Item.MerchandiseHierarchyIDItem.MerchandiseHierarchyLevelCodeRetailStoreItem.TaxGroupID, Item.TaxGroupIDIf RetialaStoreItem.VatCode is mentioned that takes precedenceRetailStoreItem.TaxGroupID, Item.TaxGroupIDThe Vat Code will be the VAT Code Name. VatCode will have to be translated from some String (xs:string) to an Integer. The VatCode should match a name specified in RU_TX_GP.NM_RU_TX. The ID_GP_TX of the name will be the ID used to insert into AS_ITM_RTL_STR.ID_GP_TAX for the incoming VatCode.RetailStoreItem.SalesAgeRestrictionIdentifierRetailStoreItem.TemplateIDRetailStoreItem.PermanentSaleUnitRetailPriceAmountRetailStoreItem.CompareAtSaleUnitRetailPriceAmountPOSIdentity.POSItemIDPOSIdentity.ManufacturerUPCStockItem.SupplierID, SupplierItemCatalogBaseCostBreak.SupplierIDPOSIdentity.ManufacturerIDPOSIdentity.QuantityKeyProhibitFlagPOSIdentity.ProhibitReturnFlagPOSIdentity.PriceEntryRequiredFlagPOSIdentity.PriceModifiableFlagPOSIdentity.AllowCouponMultiplyFlagPOSIdentity.ElectronicCouponFlagPOSIdentity.CouponRestrictedFlagPOSIdentity.SpecialOrderEligibleFlagPOSIdentity.EmployeeDiscountAllowedFlagPOSIdentity.MinimumSaleUnitCountPOSIdentity.MaximumSaleUnitCountUINLabel.LocalizedNameItemList.ID

RMS MappingSOURCE - RPM Export FilesTransformation RulesTARGET - ItemImport.XSDTable, File, Message NameRecord HeaderField/Column Name/XpathField/Column Name/XpathValid Values / Functional NotesPOSDNLDFHEADFile Create DateItemImport@CreationDateYYYYMMDD' to'YYYY-MM-DD"T"HH24:MI:SS'FDETLRecord TypeItemImport/Item@Typetype="Stock"Location NumberItemImport/Item/RetailStoreItem/RetailStoreIDUpdate TypeNo direct mapping. Can be used during transform process to determine which fields are appropriate.Start DateNo item fields use this value any longer. Basically, this is a hold over from when RPM was still part of RMS.TimeNo item fields use this value any longer. Basically, this is a hold over from when RPM was still part of RMS.Transaction TypeNo direct mapping. Can be used during transform process to determine which fields are appropriate.Item Number IDItemImport/Item@IDItem field length needs to be lengthened in DB and XML Schema.Item Number TypeUnusedFormat IDUnusedPrefixUnusedReference ItemORPOS only supports transaction level items.Reference Item Number TypeUnusedReference Item Format IDUnusedReference Item PrefixUnusedItem Short DescriptionItemImport/Item/ShortNameDE_ITM_SHRT column to be expanded to support multibyte charsItem Long DescriptionItemImport/Item/DescriptionDE_ITM column to be expanded to support multibyte charsDepartment IDItemImport/Item@POSDepartmentIDClass IDItemImport/Item@Classification1Subclass IDItemImport/Item@Classification2New PriceItemImport/Item/RetailStoreItem/RegularPriceNew Selling UOMItemImport/Item@UOMCodeNew Multi UnitsNo item fields use this value any longer. Basically, this is a hold over from when RPM was still part of RMS.New Multi Selling UOMNo item fields use this value any longer. Basically, this is a hold over from when RPM was still part of RMS.StatusItemImport/Item@ChangeTypeItemImport/Item@AuthorizedForSaleIf Transaction Type = 1(new item added), ChangeType = "ADD". If Status = 'A', AuthorizedForSale = "true". If Status = 'I' or 'C', AuthorizedForSale = "false". If Status = 'D', ChangeType = "DEL", else ChangeType = "UPD" (except for Transaction Type = 1))Taxable IndicatorItemImport/Item@TaxableY' = "true", 'N' = "false"Promotion NumberNo item fields use this value any longer. Basically, this is a hold over from when RPM was still part of RMS.Mix Match NumberNo item fields use this value any longer. Basically, this is a hold over from when RPM was still part of RMS.Mix Match TypeNo item fields use this value any longer. Basically, this is a hold over from when RPM was still part of RMS.Threshold NumberNo item fields use this value any longer. Basically, this is a hold over from when RPM was still part of RMS.Launch DateUnusedQuantity Key OptionsItemImport/Item/RetailStoreItem/POSIdentity@QuantityModifiableR' = "Required", P' = "Prohibited", and O' = "Optional"Manual Price EntryItemImport/Item/RetailStoreItem/POSIdentity@PriceEntryRequiredItemImport/Item/RetailStoreItem/POSIdentity@PriceModifiablePriceEntryRequired = "true" if Manual Price Entry = 'R', else "false". PriceModifiable = "false" if Manual Price Entry = 'P', else "true".Deposit CodeUnusedFood Stamp IndicatorUnusedWIC IndicatorUnusedProportional Tare PercentUnused. ORPOS does not record tare values.Fixed Tare ValueUnused. ORPOS does not record tare values.Fixed Tare UOMUnused. ORPOS does not record tare values.Reward Eligible IndicatorUnusedElective Marketing ClubsUnusedReturn PolicyUnusedStop Sale IndicatorItemImport/Item@AuthorizedForSaleY' = "true", 'N' = "false"Returnable IndicatorItemImport/Item/RetailStoreItem/POSIdentity@ReturnableY' = "true", 'N' = "false"Refundable IndicatorUnusedBack Order IndicatorItemImport/Item/RetailStoreItem/POSIdentity@SpecialOrderEligibleY' = "true", 'N' = "false"VAT CodeItemImport/Item/RetailStoreItem@VATCodeVAT RateVAT rates will be populated through TaxImport.Class VAT IndicatorUnused. ORPOS does not support VAT rates at a class level.Promotion Item TypeNo item fields use this value any longer. Basically, this is a hold over from when RPM was still part of RMS.Catch Weight IndicatorUnusedSale TypeUnused. ORPOS does not support variable or loose weights.Container ItemUnusedPOSCDNLDFHEADFile DateItemImport@CreationDateYYYYMMDD HHMMSS' to'YYYY-MM-DD"T"HH24:MI:SS'. This is only required if POSDNLD is not processed as part of the batch.TCOUPRecord TypeItemImport/Item@Typetype="Coupon"Coupon idItemImport/Item@IdCoupon DescItemImport/Item/DescriptionCurrency CodeItemImport/Item/RetailStoreItem/RegularPrice@CurrencyCodeMax Discount AmountAmountPercent IndicatorProfit CenterTax ClassItemImport/Item@TaxGroupExport CodeEffective DateExpiration DatePrompted IndDisplay IndStatusItemImport/Item@ChangeTypeA' = "ADD", 'C' = "UPD", 'D' = "DEL"VendorItemImport/Item@ManufacturerIDVendor TypePromotionCoupon BarcodeItemImport/Item/RetailStoreItem/POSIdentity@UPCCoupon Max QtyItemImport/Item/RetailStoreItem/POSIdentity@MaximumSaleUnitCountTPRESPOS Product Restriction IDNo direct mapping.POS Product Restriction DescNo direct mapping.POS Product Restriction TypeNo direct mapping. ORPOS will support 'MNAG' Minimum Age, 'NDSC' Nondiscountable, 'RTRN' Returnable and 'QLMT' Quantity LimitEffective DateCurrency CodeProduct Restriction AmountAge MinimumItemImport/Item/RetailStoreItem@AgeRestrictionIdDate RestrictionBefore Time RestrictionAfter Time RestrictionDay RestrictionMax Qty AmountItemImport/Item/RetailStoreItem/POSIdentity@MaximumSaleUnitCountTender Type GroupStatusItemImport/Item/RetailStoreItem@ChangeTypeItemImport/Item/RetailStoreItem/POSIdentity@ChangeTypeA' = "ADD", 'C' = "UPD", 'D' = "DEL". Depending on which attribute is affected, either the RetailStoreItem@ChangeType or the POSIdentity@ChangeType will be populated here. Likely not both.TMORDRecord TypeUnusedTTTYPRecord TypeUnusedTBTTNRecord TypeUnusedTPYIORecord TypeUnusedTSPAYRecord TypeUnusedTSTORRecord TypeUnused. Additions and deletions of store Ids will be supported through the StoreHierarchy Data Import, which maps to other RMS files, rmse_store.dat and rmse_orghier.dat documents.TITEMItemItemImport/Item@IDStatusItemImport/Item@ChangeTypeA' = "ADD", 'C' = "UPD", 'D' = "DEL".Button IDUnusedTXRPOSDNFHEADFile DateItemImport@CreationDateYYYYMMDD HHMMSS' to'YYYY-MM-DD"T"HH24:MI:SS'. This is only required if POSDNLD is not processed as part of the batch.UNKNOWNItemImport/Item@TaxGroupItemImport/Item/RetailStoreItem@CreationDateNote: Please refer to the TXRPOSDN.doc for mapping this data to the listed elements.

Outstanding IssuesElements in XSDCommentPreloadData > Product @ManufacturerIDManufacturer ID is shown as optional wheres as it is mandatory in DB. Also has referential Integrity constraints. Hence chances of errors are pretty high for these recordsItem > RetailStoreItem > RegularPrice @CurrencyCodeNo support for prices in Foreign currency codes.Item > RetailStoreItem > RegularPrice @IncludesTaxWill map to a column to be introduced in future to support VATItem > RetailStoreItem @VatCodeWill map to a column to be introduced in future to support VAT. Or will need to be mapped to the TaxGroupName in TaxGroup tableItem > Description @Language & CountryWhen i81N tables are supported these values will need to be mapped to the tables. This is deprecated as 13.1Item > ShortName @Language & CountryWhen i81N tables are supported these values will need to be mapped to the tables. This is deprecated as 13.1