Adjustment of fields to the new xChange format (5.13 API; 1.11 API Gateway)


products
--------

productId - up to 35 characters

overallInformation:
supplierPid - up to 35 characters
altPid - up to 35 characters
supplierAltPid - up to 35 characters
manufacturerPid - up to 35 characters
gtin - pattern: [0-9]{8,14}
upc - field removed
manufacturerName - up to 80 characters
manufacturerAcronym - up to 15 characters
descriptionShort - up to 255 characters
supplierDescriptionShort - up to 255 characters
descriptionVeryShort - up to 80 characters
descriptionLong - up to 10000 characters
tenderText - up to 10000 characters
remark - up to 10000 characters
warrantyBusiness - number in the range: [0, 999]
warrantyConsumer - number in the range: [0, 999]
shelfLifePeriod - number in the range: [0, 999]
transportCategory - select from values: 0, 1, 2, 3, 4
netWeightOfHazardousSubstance - pattern: [0-9]{1,12}[.]{0,1}[0-9]{0,4}
volumeOfHazardousSubstances - pattern: [0-9]{1,12}[.]{0,1}[0-9]{0,4}
lithiumAmount - pattern: [0-9]{1,12}[.]{0,1}[0-9]{0,4}
batteryEnergy - pattern: [0-9]{1,12}[.]{0,1}[0-9]{0,4}
netLength - pattern: [0-9]{1,12}[.]{0,1}[0-9]{0,4}
netWidth - pattern: [0-9]{1,12}[.]{0,1}[0-9]{0,4}
netDepth - change of key name to "netHeight"; pattern: [0-9]{1,12}[.]{0,1}[0-9]{0,4}
netDiameter - pattern: [0-9]{1,12}[.]{0,1}[0-9]{0,4}
netWeight - pattern: [0-9]{1,12}[.]{0,1}[0-9]{0,4}
netVolume - pattern: [0-9]{1,12}[.]{0,1}[0-9]{0,4}
netDimensionUnit - new field; select from values: CMT, DMT, KMT, MMT, MTR
netVolumeUnit - new field; select from values: LTR, MLT, MMQ, MTQ
netWeightUnit - new field; select from values: GRM, KGM, MGM, TNE
specialProvisionId - multiselect from values according to pattern: SP[0-9]{2,3}
hazardLabel - multiselect from values: 1, 1.4, 1.5, 1.6, 2.1, 2.2, 2.3, 3, 4.1, 4.2, 4.3, 5.1, 5.2, 6.1, 6.2, 7A, 7B, 7C, 7E, 8, 9, 9A
hazardStatement - multiselect from values: https://en.wikipedia.org/wiki/GHS_hazard_statements
precautionaryStatement - multiselect from values: https://en.wikipedia.org/wiki/GHS_precautionary_statements
productStatus - field removed; replaced by new fields:
  - productStatus - select from values: PRE-LAUNCH, ACTIVE, ON HOLD, PLANNED WITHDRAWAL, OBSOLETE
  - productCondition - select from values: NEW, USED, REFURBISHED
customsNumber - from 8 to 10 characters
specialTreatmentClass - field removed; replaced by new field "sdsIndicator"
predecessorPid - field removed; values migrated to related products of the type: PREDECESSOR
countryBranchNumber - field removed
deliveryTime - non-negative integer; field moved to "orderInformation"
manufacturerTypeDesc - field removed
manufacturerAltPid - field removed
discountGroupManufacturer - field removed
regionOfOrigin - field removed
multiplicationFactor - field removed
additionalPriceFactor - field removed
additionalFactorInfo - field removed
surchargePriceAmount - field removed
reverseChargeInfo - field removed

orderInformation:
quantityMin - pattern: [0-9]{1,12}[.]{0,1}[0-9]{0,4}
quantityInterval - pattern: [0-9]{1,12}[.]{0,1}[0-9]{0,4}
noCuPerOu - change of key name to "contentUnitQuantity"; pattern: [0-9]{1,12}[.]{0,1}[0-9]{0,4}
priceQuantity - pattern: [0-9]{1,5}[.]{0,1}[0-9]{0,4}; field moved to "priceInformation"

priceInformation:
priceType + priceAmount - fields removed; replaced by new fields:
  - listPrice - pattern: [0-9]{1,11}[.]{0,1}[0-9]{0,4}
  - customerSpecificPrice - pattern: [0-9]{1,11}[.]{0,1}[0-9]{0,4}
  - recommendedRetailPrice - pattern: [0-9]{1,11}[.]{0,1}[0-9]{0,4}
tax - change of key name to "vat"; pattern: [0-9]{1,2}[.]{0,1}[0-9]{0,2}
priceOnRequest - new field; select from values: true, false
priceFactor - field removed
lowerBound - field removed
priceUnitFactor - pattern: [0-9]{1,11}[.]{0,1}[0-9]{0,4}

packingInformation:
quantityMin + quantityMax - fields removed; replaced by new field "quantity" - pattern: [0-9]{1,12}[.]{0,1}[0-9]{0,4}
gtin - pattern: [0-9]{8,14}
length - pattern: [0-9]{1,12}[.]{0,1}[0-9]{0,4}
width - pattern: [0-9]{1,12}[.]{0,1}[0-9]{0,4}
depth - change of key name to "height"; pattern: [0-9]{1,12}[.]{0,1}[0-9]{0,4}
diameter - pattern: [0-9]{1,12}[.]{0,1}[0-9]{0,4}
weight - pattern: [0-9]{1,12}[.]{0,1}[0-9]{0,4}
volume - field removed
packingUnitName - field removed
packingProductId - field removed
dimensionUnit - new field; select from values: CMT, DMT, KMT, MMT, MTR
weightUnit - new field; select from values: GRM, KGM, MGM, TNE

mime:
Code - reduction of available codes; code mapping:
MD02, MD20, MD23-MD30, MD46-MD48, MD59, MD65 -> MD01
MD08, MD31, MD33, MD42, MD50 -> MD09
MD15, MD16, MD34, MD61 -> MD10
MD60, MD64 -> MD12
MD11, MD19, MD21, MD32, MD38, MD62, MD63 -> MD14
MD17 -> MD18
MD07 -> MD22
MD52, MD53, MD55 -> MD35
MD39, MD57, MD58 -> MD45
MD04, MD40, MD43, MD44 -> MD99

relatedProducts:
relationType - select from values: ACCESSORY, MAIN_PRODUCT, CONSISTS_OF, CROSS_SELLING, MANDATORY, SELECT, SIMILAR, SPAREPART, UPSELLING, SUCCESSOR, PREDECESSOR, OTHER
description - field removed


buyers
---------

gln - pattern: [0-9]{13}
duns - new field; pattern: [0-9]{9}


suppliers
---------

name - up to 80 characters
gln - pattern: [0-9]{13}
duns - pattern: [0-9]{9}
vatId - up to 18 characters
description - new field; up to 255 characters