ࡱ;   !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root Entry  \pCalc Ba=@=Z?N*8X"1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial10Arial Unicode MS#,##0\ "DM";\-#,##0\ "DM"##,##0\ "DM";[Red]\-#,##0\ "DM"$#,##0.00\ "DM";\-#,##0.00\ "DM")$#,##0.00\ "DM";[Red]\-#,##0.00\ "DM">*9_-* #,##0\ "DM"_-;\-* #,##0\ "DM"_-;_-* "-"\ "DM"_-;_-@_->)9_-* #,##0\ _D_M_-;\-* #,##0\ _D_M_-;_-* "-"\ _D_M_-;_-@_-F,A_-* #,##0.00\ "DM"_-;\-* #,##0.00\ "DM"_-;_-* "-"??\ "DM"_-;_-@_-F+A_-* #,##0.00\ _D_M_-;\-* #,##0.00\ _D_M_-;_-* "-"??\ _D_M_-;_-@_- General@ 000000,'[>0]"$"#,##0.00;[<0]"$("#,##0.00);"$-"#                + )  , * * )    )    )    )     )        83f3ffff̙̙3f3fff3f3f33333f33333`normalized model110 BuiltIn_AutoFilter___1;60 BuiltIn_AutoFilter___2; ZR3  @@    Object ClassProperty QualifierPropertyType cardinalityUBL DefinitionXAL (CIQ name)Address|the particulars that identify and locate the place where someone lives or is situated, or where an organisation is situated.AddressID Identifier1..1Xa unique identifier given to a specific address within a scheme of registered addresses.AddressDetailsKeyAddressPostboxText0..1a post office box number or a numbered post box in a post office assigned to a person or organization where letters for them are kept until called for, used as part of an address. PostBoxNumberAddressBuildingText0..1Dthe identity which uniquely identifies a building within an address. BuildingNameAddressFloorText0..1Sidentification by name or number of the floor in a building, as part of an address.SubPremiseNumberAddressRoomText0..1>identifies the room, suite or apartment as part of an address.SubPremiseNumberAddressStreetText0..1.the name of the street, as part of an address. ThoroughfareAddressAdditionalStreetText0..1Hcontains additional text information within an address about the street. ThoroughfareAddress HouseNameText0..1lthe name that identifies the location of a house or building: usually within a street as part of an address. BuildingNameAddress HouseNumberText0..1ythe house number or description that identifies a house, building or site: usually within a street as part of an address. BuildingNameAddress InhouseMailText0..1;identifies an in-house mail location as part of an address.MailStopAddress DepartmentText0..1Nthe identity of the department of an organisation, used as part of an address.DepartmentNameAddressCityNameText0..1Wthe name of the city, town, village, or a built up area and used as part of an address. LocalityNameAddress PostalZoneText0..1the identifier for one or more properties according to the postal service of that country; a group of letters and/or numbers added to the postal address to assist in the sorting of mail. PostalCodeNumberAddressCountrySub-entityText0..1the name that identifies the territorial division (a chief unit of local administration) of a country, as part of an address. AdministrativeAreaNameAddressCountrySub-entityCodeCode0..1the code that identifies the territorial division (a chief unit of local administration) of a country, as part of an address. AdministrativeAreaName type=codeAddressRegionText0..1the name that identifies a non-administrative division of a country, or a commonly used name for a grouping of countries, as part of an address. LocalityNameAddressDistrictText0..1xthe name that identifies a non-administrative division of a city, country sub-entity, or country, as part of an address. LocalityNameAddressCountryCode0..1[provides the country part of an address using a code. ISO3166 alpha codes are recommended. CountryName CommunicationOinformation directly relating to the means of sending or receiving information.ContactID1..1iidentifies the department or employee by a unique identity other than their name when given as a contact. CommunicationValueText1..1Sthe number or virtual 'address' of a communication point in a communication system CommunicationChannelCode1..1Bidentifies the channel (or medium) by which communication is made.Contactuinformation that identifies a contact person or department together with information about how they can be contacted.ContactID Identifier1..1iidentifies the department or employee by a unique identity other than their name when given as a contact.ContactNameText0..1>identifies the department or employee name given as a contact.PartyID1..1oan identification of an entity doing business as assigned by an agency operating a party identification scheme.Contract\information that directly relates to a formal and legally binding agreement between parties.ContractID Identifier1..1[identifies a contract by a unique and single identifier known to all the parties concerned.ContractTypeCodeCode0..1 identifies the type of contract.Contract StartDateDateTime0..1ContractEndDateDateTime0..1ContractDurationMeasure0..1 CreditPaymentinformation that directly relates to a credit card, a small plastic card issued by a financial institution, bank or building society, allowing the holder to make purchases on credit. CreditPaymentPrimaryAccountNumber Identifier1..13the identifying number of the credit or debit card. CreditPaymentCustomerCode0..1rthe customer reference number. This is used to enable transmission of customer specific information with the card. CreditPayment ExpiryDateDateTime0..1(the date up to which the card is valid . CreditPayment BankIDNumberCode0..1!the type of card used for payment CreditPayment IssueNumberCode0..1Used for SWITCH cards CreditPaymentCV21..1SEE MJA FOR THIS *** CreditPayment ChipIndicator Indicator0..1 CreditPaymentChipApplication Identifier0..1 CreditPaymentHolderText0..1#the name of the holder of the card.DeliveryRequestEdelivery information that relates to a specific consignment of cargo.DeliveryRequestID Identifier1..1 identifies the delivery request.AddressToID1..1Xa unique identifier given to a specific address within a scheme of registered addresses.AddressFromID1..1Xa unique identifier given to a specific address within a scheme of registered addresses. DeliveryTermsID0..1Identifier of the conditions agreed upon between a seller and a buyer with regard to the delivery of goods and/or services, e.g. CIF, FOB, or EXW from the INCOTERMS Terms of Delivery.OrderID1..1lThe OrderId element is a unique number assigned to the Order in respect to the parties assigning the number. OrderItemID0..1)the identification given to a order item DeliveryRequestRequestedDeliveryDateDateTime0..1Mthe date the buyer requested delivery for a specific delivery schedule event.DeliveryRequestPromisedByDateDateTime0..1Zused mainly for confirming orders when a date was promised by the supplier over the phone.DeliverySchedulePdelivery scheduling information that relates to a specific consignment of cargo.DeliveryRequestID1..1 identifies the delivery request.DeliveryScheduleID Identifier1..1/identifies the schedule line within a delivery.DeliveryScheduleQuantity0..1Athe quantity to be shipped at a specific delivery schedule event.DeliveryScheduleMinimumQuantity0..1Ithe minimum quantity to be shipped at a specific delivery schedule event.DeliveryScheduleMaximumQuantity0..1Ithe maximum quantity to be shipped at a specific delivery schedule event. DeliveryTermsfContains information about the terms fo delivery for the set of items to which the transaction relates DeliveryTermsID Identifier1..1Identifier of the conditions agreed upon between a seller and a buyer with regard to the delivery of goods and/or services, e.g. CIF, FOB, or EXW from the INCOTERMS Terms of Delivery.ReferenceDocumentID Identifier1..1&Uniquely identifies a set of documents DeliveryTermsBasisCode1..1lidentifies whether the terms relate to delivery conditions, transport conditions, or a combination of these. DeliveryTermsRelevantLocationText0..1Zinformation directly relating to the location relevant to the terms of delivery specified. DeliveryTerms SpecialTermsText0..1Gfree text description of special conditions relating to delivery terms. DeliveryTermsTransportDescriptionText0..1Fa free text description of transport as part of the terms of delivery. DeliveryTermsRiskResponsibilityCode0..1Fidentifies the responsibility< for loss risk within the delivery terms. DeliveryTermsLossRiskText0..18text describing the loss risk related to delivery terms.DespatchAdviceOinformation that relates to athe despatching of consignments between parties.DespatchAdviceID Identifier1..1 PLACEHOLDER EquipmentSeal'information directly relating to seals. EquipmentSealID Identifier1..17identifier of a seal on a piece of transport equipment.ShipmentID0..1Identifier of a shipment.TransportEquipmentID1..1-identifier of a piece of transport equipment. EquipmentSealIssuerPartyTypeCode0..1VCode identifying which party issues and is responsible for a transport equipment seal. EquipmentSeal InformationText0..1\information relating to the condition or status of a seal on a piece of transport equipment. ExchangeRate^information that directly relates to the rate of exchange (conversion) between two currencies. ExchangeRateID Identifier1..1identifies the exchange rate ExchangeRateSourceCurrencyCode1..1sthe reference currency of the rate of exchange. The currency from which the exchange is being made (CC Definition) ExchangeRateSourceCurrencyBaseAmount0..1Wspecifies the unit base of the source currency for currencies with small denominations. ExchangeRateTargetCurrencyCode1..1vthe target currency of the rate of exchange. This is the currency to which the exchange is being made. (CC Definition) ExchangeRateTargetCurrencyBaseAmount0..1Vspecifies the unit base of the target currency for currencies with small denominations ExchangeRateExchangeMarketCode0..1Nidentifies the currency exchange market from which the exchange rate is taken. ExchangeRateCalculationRateNumeric1..1dThe factor used for conversion of an amount from one (source) currency to another (target) currency. ExchangeRateRateDateDateTime0..1!the date of the rate of exchange. ExchangeRate FXContractId Identifier0..1Tidentifies a foreign exchange contract in which a rate of exchange has been agreed. FIBranchinformation directly relating to a branch which is a division of and normally situated differently to a large main organisation.FIBranchID Identifier1..11the identification of a branch of an organisationFinancialInstitutionID1..1didentifies the financial institution by code. ISO xxxx BIC (Bank Identification Code) is recommendedFIBranchNameText0..1'the name of a branch of an organisationAddressID0..1+the address of a branch of an organisation.FinancialAccountInformation direc.tly relating to an account, which is a service through a bank or a similar organisation by which funds are held on behalf of a clientFinancialAccountID Identifier1..11the account number or identifier for the account.FIBranchID1..11the identification of a branch of an organisationFinancialInstitutionID1..1didentifies the financial institution by code. ISO xxxx BIC (Bank Identification Code) is recommendedFinancialAccount AccountNameText1..1A the identifying name of the account given by the account holder.FinancialAccount ControlID Identifier0..1Qthe control number to uniquely identify the account at the financial institution.FinancialAccountTypeCode1..1&a code qualifying the type of account.FinancialAccountCurrencyCode0..1midentifies the currency in which the account is held, using a code. ISO 4217 3-character code is recommended.FinancialInstitutionEinformation that directly relates to a bank or financial institution.FinancialInstitutionID Identifier1..1didentifies the financial institution by code. ISO xxxx BIC (Bank Identification Code) is recommendedFinancialInstitutionNameText0..1&the name of the financial institution.AddressID0..1)the address of the financial institution.GoodsClassificationinformation that directly relates to the classification of goods according to a (formalised) convention for the classification and description of the goods.GoodsClassification NatureCodeCode0..1Mthe high level nature of goods code issued by a specific maintenance agency. GoodsClassification CargoTypeCode0..1 Code specifying a type of cargo.GoodsClassification CommodityCodeCode0..1(classification of the type of commodity.ItemID1..10identifies an item, article, product or service.HazardousIdentification5identifier of the hazardous material being described.HazardousGoodsID1..1identifier of hazardous goods.HazardousIdentification ExtensionText1..1identifier of additional information regarding the hazardous substance. (Can be used to identify information such as the type of regulatory requirements that apply to a description, e.g. N.O.S. or a Waste Characteristics Code in conjunction with an EPA Waste Stream code). HazardousItem>information that provides details relating to hazardous goods. HazardousItemID Identifier1..1$identifier of a hazardous substance.ItemID1..10identifies an item, article, product or service. HazardousItemPlacardNotationText0..1the placard notation corresponding to the hazard class of the hazardous commodity. Can also be the hazard identification number of the orange placard (upper part) required on the means of transport. HazardousItemPlacardEndorsementText0..1the placard endorsement that is to be shown on the shipping papers for the hazardous commodity. Can also be used for the number of the orange placard (lower part) required on the means of transport.PartyContactPartyID1..1oan identification of an entity doing business as assigned by an agency operating a party identification scheme. HazardousItemAdditionalInformationText0..1additional information regarding the hazardous substance. (Can be used to hold information such as the type of regulatory requirements that apply to a description, e.g. N.O.S. or a Waste Characteristics Code in conjunction with an EPA Waste Stream code). HazardousItemUNDGCode0..1Oidentifier assigned to transportable hazardous goods within the United Nations. HazardousItem FlashpointMeasure0..1the lowest temperature at which the vapor of a combustible liquid can be made to ignite momentarily in air, known in hazardous goods procedures as the flashpoint. HazardousItemEmergencyTemperatureMeasure0..1rthe temperature at which emergency procedures apply during the handling of temperature-controlled hazardous goods. HazardousItemEmergencyProceduresCode0..17identifier of emergency procedures for hazardous goods. HazardousItemMedicalFirstAidGuideCode0..1Uidentifier of a medical first aid guide that is relevant to specific hazardous goods.HazardousShipmentEinformation related to the shipping and packaging of hazardous goods.HazardousGoodsID1..1identifier of hazardous goods.HazardousShipmentTransportEmergencyCardCode0..1the identification of a transport emergency card, giving advice for emergency actions. Can be used for the identity number of a specific hazardous emergency response plan assigned by the appropriate responsible authority, either national or international.HazardousShipmentPackingCriteriaCode0..1~identifier of a packaging requirement for the transportation of specific hazardous goods as assigned by IATA/IMDB/ADR/RID etc.HazardousShipmentRegulationCodeCode0..1eidentifier of a set of legal regulations which govern the transportation of specific hazardous goods.HazardousShipmentRegulationNameText0..16Full technical name of a specific hazardous substance.HazardousShipmentMaximumTransportTermperatureMeasure0..1Lthe maximum temperature at which certain products can be safely transported.HazardousShipmentInhalationToxicityZoneCode0..1widentifier of an Inhalation Toxicity Hazard Zone for hazardous goods as defined by the US De< partment of Transportation.ItemSinformation directly relating to an item (article, product, goods item or service).ItemID Identifier1..10identifies an item, article, product or service.Item DescriptionText0..1Ja free form field that can be used to give a text description of the item.Item PackQuantityQuantity0..1the unit packaging quantity.ItemPackSizeQuantity0..1the number of items in a pack.ItemFromCatalogIndicator Indicator0..1Man indicator that denotes whether or not the item was ordered from a catalog.AddressOrigin Identifier0..1Xa unique identifier given to a specific address within a scheme of registered addresses.ItemIdentification<information directly relating to the identification an item.ItemID1..10identifies an item, article, product or service.ItemIdentificationID Identifier1..1other identification of the product or service that are not explicitly stated as the content of the other elements contained elsewhereItemIdentification SubstituteID0..1information directly relating to the identification of items or services that are acceptable substitutions for the product or service required.ItemIdentification ExtensionText0..1an additional extension in free text form to 'specialise' the identification of a product or service. An example of this would be a color code for a specific product.ItemMeasurement/information directly relating to a measurement.ItemMeasurement AttributeID Identifier1..1lidentifies a physical attribute within a set of characteristics that describe something in a formalised way.ItemID1..10identifies an item, article, product or service.ItemMeasurementMeasureMeasure0..1the value of the measurementItemMeasurement DescriptionText1..1*free text describing a physical attribute.ItemMeasurementMinimumMeasureMeasure0..1the minimum value of the rangeItemMeasurementMaximumMeasureMeasure0..1the maximum value of the rangeInvoice PLACEHOLDERInvoiceID Identifier1..1 PLACEHOLDERLanguage,information directly relating to a language.LanguageID Identifier1..1$identifies the language by a code. LanguageNameText0..1 the common name of the language.LanguageLocaleCode0..1Oidentifies the locale/location where the language is spoken or used in writing.Order+information directly relating to the order.OrderID Identifier1..1lThe OrderId element is a unique number assigned to the Order in respect to the parties assigning the number.Order IssueDateDateTime1..1Ga date (and potentially time) stamp denoting when the Order was issued.OrderAcknowledgementResponseCode0..1Yspecifies the type of acknowledgment for the order requested by the buyer from the sellerOrderCurrencyCode0..1the default currency of the Order, which when used at the header level may be overwritten at the lower level within the structure. ExchangeRateID0..1identifies the exchange rateOrder EarliestDateDateTimeOrderCancelledByDateDateTime0..18is the date on or after which Order should be cancelled.OrderValidityDurationMeasure0..1;information directly relating to the validity of the order.Order LineItemCountQuantity0..1&the number of line items in the order.OrderTotalTaxAmount0..1#the total tax amount for the Order.Order TotalPriceAmount0..1%the total price for the entire Order.Order TotalPackagesQuantity0..1@the summation of total packages contained in the purchase order.OrderShipmentGrossWeightMeasure0..1'the total gross weight of the shipment.OrderShipmentNetWeightMeasure0..1%the total net weight of the shipment.OrderShipmentNetNetWeightMeasure0..1ethe weight (mass) of the goods themselves without any packing. Sometimes known as the "NetNet Weight"OrderShipmentTareWeightMeasure0..16the weight of the goods minus the transport equipment.OrderShipmentVolumeMeasure0..1!the total volume of the shipment. OrderChange PLACEHOLDER OrderChangeID Identifier1..1 PLACEHOLDER OrderIteminformation directly relating to a line item of a transaction. It identifies the item but only includes details about the item that are pertinent to one occurrence on a line item, e.g. quantity etc. OrderItemID Identifier1..1)the identification given to a order item ItemID1..10identifies an item, article, product or service. OrderItem TotalPriceAmount0..1the monetary amount that is the total for the line item, including any pricing variation (allowances, charges or discounts) but not adjusted by any payment settlement discount or taxation. OrderItemQuantityQuantity0..1+the quantity of the item on this line item. OrderItemMinimumQuantityQuantity0..1-the minimum quantity of the item on this line OrderItemMaximumQuantityQuantity0..1-the maximum quantity of the item on this line OrderItemMaximumBackorderQuantityQuantity0..1Nthe maximum quantity of an item that a customer will allow to be back ordered.Party RecipientPartyID0..1oan identification of an entity doing business as assigned by an agency operating a party identification scheme.Address DestinationID0..1Xa unique identifier given to a specific address within a scheme of registered addresses.OrderItemIdentification<information directly relating to the identification an item. OrderItemID1..1)the identification given to a order item OrderItemIdentificationID Identifier1..1Uother identification of the order item (e.g. seller's assigned line item identifier)"OrderItemIdentification ReplacementID0..1information directly relating to the identification of items or services that are acceptable substitutions for the product or service required. OrderResponse PLACEHOLDER OrderResponseID Identifier1..1 PLACEHOLDERPackage+information directly relating to packaging.ShipmentID1..1Identifier of a shipment.DeliveryRequestID0..1 identifies the delivery request.PackageID Identifier1..1Iidentifies a package that contains a quantity of an item being delivered.PackageQuantityQuantity0..1the quantity within a package.PackageCompositePackageText0..1information directly relating to the inner packaging of item(s) when nested in outer packaging. (Note that this is a re-use of Package Details within Package Details).PartyQdetails of an individual, a group or a body having a role in a business function.PartyID Identifier1..1oan identification of an entity doing business as assigned by an agency operating a party identification scheme.Party AccountIDCode0..16 The accounting identification assigned to the party. PartyAddressthe particulars that identify anthe purpose of a location where someone lives or is situated, or where an organisation is situated.PartyID1..1oan identification of an entity doing business as assigned by an agency operating a party identification scheme.Address Identifier1..1Xa unique identifier given to a specific address within a scheme of registered addresses. PartyAddressPurposeCode0..1didentifies the category or type of location distinguishing between, for example, a business or home. PartyAddressNameText0..1the name of the location PartyAddressCoordinateSystemCode0..15identifies the co-ordinate measuring system (eg. GPS) PartyAddressLatitudeText0..1Ospecifies the measurement of latitude as part of a detailed set of coordinates. PartyAddressLatitudeDirectionCode0..1 PartyAddress LongitudeText0..1Pspecifies the measurement of longitude as part of a detailed set of coordinates. PartyAddressLongitudeDirectionCode0..1 PartyAddressTimeZoneOffsetMeasureText0..1< the measure of time offset from UTC (Universal Coordinated Time) for the time zone in which the address is situated. A synonym for UTC is GMT (Greenwich Mean Time). PartyLanguageThe language used by a partyPartyID1..1oan identification of an entity doing business as assigned by an agency operating a party identification scheme.LanguageID0..1$identifies the language by a code. PartyLanguageLanguageDependency Indicator0..1cindicates whether the party is dependent on any textual information being in a particular language. PartyNameAlternative names for a partyPartyID1..1oan identification of an entity doing business as assigned by an agency operating a party identification scheme. PartyNameNameText1..1the name of a party.PartyTaxSchemeNinformation directly relating to the tax scheme that is applicable to a party.PartyID1..1oan identification of an entity doing business as assigned by an agency operating a party identification scheme.Address RegistrationID0..1Xa unique identifier given to a specific address within a scheme of registered addresses. TaxSchemeID1..1=identifies the tax scheme within which a party is registered.PartyTaxSchemeRegistrationNameText0..1the name of a party as registered with the tax authority. This must be present if a) the tax regulations require it, and b) it is different from the Name element in the Name and Address information of the party.PartyTaxScheme CompanyTaxID Identifier0..1iis the identification of a company as registered with the appropriate tax authority for a tax scheme. PartyTaxSchemeCompanyRegistrationID Identifier0..1identifies a company as registered with the relevant authority for company regulation. (Note: this is required by the regulations of some tax jurisdictions. It is NOT the same as the registration id of a company within a tax scheme.)PartyTaxScheme TaxCurrencyCode0..1Yidentifies the tax accounting currency for the Order if different than the OrderCurrency PartyTaxSchemeTaxLevelCode0..1;identifies the default level of tax deduction for the Order6 Payment4information directly relating to a specific payment.PriceComponentID1..1!Identifier of the price component PaymentMeansTypeCode1..15identifies a valid means of paying the debt incurred.PaymentID Identifier0..1identifies the payment transaction that settles the debt according to the specified payment means. For example, if the selected payment means were cheque, then this Id would be the cheque number.Payment PaymentAmountAmount0..1,an amount paid against this price componentPaymentPaymentReceivedDateDateTime0..1,the date on which the payment was received. PaymentMeans6information directly relating to the means of payment. PaymentMeansTypeCode Identifier1..15identifies a valid means of paying the debt incurred. PaymentMeans PaymentDateDateTime0..15The point in time at which the payment is to be made. PaymentMeansChannelCode0..1Xidentifies the system through which the payment is processed, using a standard codelist. CreditCardID0..13the identifying number of the credit or debit card.FinancialAccountPayerID0..1information directly relating to the bank account of the Payer (one to make payment), given as part of the means of payment information.FinancialAccountPayeeID0..1information directly relating to the bank account of the Payee (one to receive payment), given as part of the means of payment information. PaymentTermsZinformation directly relating to the terms and conditions by which payment should be made. PaymentTermsID Identifier1..1Zidentifies the set of conditions attached to an agreement or contract relating to payment.ReferenceDocumentID Identifier1..1&Uniquely identifies a set of documents PaymentTerms PaymentTermsText1..1Minformation directly relating to a note about the payment terms on the order. PaymentTermsEventCode0..1[the event from which terms are offered for a length of time, identified by a standard code.PricingComponentKdetails about the components that constitute an itemised amount for paymentPricingComponentID Identifier1..1!Identifier of the price componentOrderID0..1lThe OrderId element is a unique number assigned to the Order in respect to the parties assigning the number.PricingComponent BasisQuantityQuantity0..1Contains the quantity and unit of quantity on which the price is based. For example, if the pricing scheme were $50/500 lbs, this would contain 500 (quantity) and lbs (unit of quantity).PricingComponent BasisAmountAmount0..1dspecifies the amount on which the payment terms (i.e. the settlement discount) calculation is based.PricingComponentAccountingCurrencyAmountAmount0..1]information directly relating to the amounts in the currency of the party's accounting systemPricingComponentInvoiceCurrencyAmountAmount0..1Linformation directly relating to the amounts in the currency of the invoice.PricingComponentMinimumQuantityQuantity0..1Mspecifies the minimum quantity in a range to which a price variation applies.PricingComponentMaximumQuantityQuantity0..1Mspecifies the maximum quantity in a range to which a price variation applies.PricingComponent MinimumAmountAmount0..1Jspecifies the minimum value in a range to which a price variation applies.PricingComponent MaximumAmountAmount0..1Jspecifies the maximum value in a range to which a price variation applies.PricingComponentMultiplierReasonCode0..1contains a code giving the reason why the unit price is to be multiplied to arrive at the final price for an item. This can be used identify the kind of trade discount, such as normal discount, promotional discount etc.PricingComponentMultiplierValueNumeric0..1contains a value by which the unit price is multiplied by to arrive at the final price for an item. For example, if the unit price is to be discounted by 10%, the value of the multiplier would be 0.9 .PricingComponentPercentNumeric0..1CThe percentage for adjustment of the price (discount or allowance).PricingComponent DaysLimitQuantity0..1Xthe number of days which the amount has to be paid by in order to receive the discount. PricingComponent DateLimitDateTime0..1Vthe date before which the amount has to paid in full in order to receive the discount.PricingComponent SequenceValueNumeric0..1 identifies the sequence in which allpricing components are calculated when multiple components apply in 'piggy-back' fashion (i.e. one on top of another). If they are all applicable to the same base price, then the calculation sequence indicator will always equal one. TaxRateCategoryCode0..1the category of the tax and, by implication, the tax rate that applies. The actual percentage attributed to a category is dependent on the tax jurisdiction. OrderItemID0..1)the identification given to a order item ShipmentID0..1Identifier of a shipment. DeliveryTermsID0..1Identifier of the conditions agreed upon between a seller and a buyer with regard to the delivery of goods and/or services, e.g. CIF, FOB, or EXW from the INCOTERMS Terms of Delivery. PaymentTermsID0..1Zidentifies the set of conditions attached to an agreement or contract relating to payment.PricingUinformation directly relating to a specific price or amount on a commerical document.PricingID Identifier0..1Identifer of price detailsPricingComponentID1..1!Identifier of the price component ExchangeRateID0..1identifies the exchange ratePricing GrossPriceAmount0..1Zcontains the gross value of the unit price, i.e. the price before any discount is applied.PricingNetPriceAmount0..1contains the net value of the unit price, i.e. the price afte<r trade discount has been deducted, but before any other charges or allowances are made.Quote-information directly relating to a quotation.QuoteID Identifier1..1identifies a quote. Quote IssueDateDateTime0..1'the date on which the quote was issued. ReceiptAdvice PLACEHOLDER ReceiptAdviceID Identifier1..1 PLACEHOLDERReferenceDocumentDInformation that relates document sets within a business transactionReferenceDocumentID Identifier1..1&Uniquely identifies a set of documentsQuoteID0..1identifies a quote. ContractID0..1[identifies a contract by a unique and single identifier known to all the parties concerned.OrderID0..1lThe OrderId element is a unique number assigned to the Order in respect to the parties assigning the number.ReferenceDocumentReleaseText0..1s the element used if the purchase order is a release against the document specified in the Contract. IdentificationInvoiceID0..1Wa unique number assigned to the Invoice in respect to the parties assigning the number. OrderChangeID0..1[a unique number assigned to the OrderChange in respect to the parties assigning the number. OrderResponseID0..1^a unique number assigned to the OrderResponse in respect to the parties assigning the number.DespatchAdviceID0..1^a unique number assigned to the DespatchAdvice in respect to the parties assigning the number. ReceiptAdviceID0..1]a unique number assigned to the ReceiptAdvice in respect to the parties assigning the number.SalesConditionsJinformation directly relating to the sales conditions that are applicable.ItemID1..10identifies an item, article, product or service.SalesConditions ConditionID Identifier1..1Eidentifies a condition within the set of sales conditions that apply.SalesConditionsActionCode0..1pidentifies the action that should be undertaken in specific conditions related to the sale of goods or services.SalesConditions DescriptionText0..1rdescribes in free text what action should be undertaken in specific circumstances in relation to sales conditions.Shipment,information directly relating to a shipment.ShipmentID Identifier1..1Identifier of a shipment.ContractID0..1#identifier of a transport contract.Shipment ServiceLevelCode0..18identifies the level of service required for a shipment.Shipment InstructionsText0..11free form text for special shipping instructions.Shipment InformationText0..1Badditional information in free form text relating to the shipment.DeliveryRequestID0..1 identifies the delivery request.OrderID1..1lThe OrderId element is a unique number assigned to the Order in respect to the parties assigning the number. OrderItemID0..1)the identification given to a order item ShipmentStage,information directly relating to a shipment.ShipmentID1..1Identifier of a shipment. ShipmentStageStageID Identifier1..18identifier of a transport stage within a cargo movement.AddressFromID1..1identifies a location.AddressToID1..1identifies a location.PartyCarrierID0..1|the identifier assigned by the agency to the carrier. This identifies the carrier being used for this stage of the shipment. ShipmentStageTransportModelCode0..1bThe method of transport used for the conveyance of goods or persons, e.g. by rail, by road, by sea ShipmentStageTransportMeansCode0..1iThe particular vehicle, ship etc. used for the transport of goods or persons. BIE needs shipment removed. ShipmentStageTransitDirectionCode0..1'the transit direction for the shipment. ShipmentStage StartDateDateTime0..1Time the movement started ShipmentStageEndDateDateTime0..1Time the movement finished ShipmentStageDurationMeasure0..1Length of time for the movementTaxKinformation directly relating to tax associated by a party to a tax scheme.TaxRateCategoryCode Identifier1..1the category of the tax and, by implication, the tax rate that applies. The actual percentage attributed to a category is dependent on the tax jurisdiction.TaxTypeCode1..1identifies the type of tax.Tax RatePercentNumeric0..1the tax rate as a percentage.Tax ExemptReasonCode0..19a code that explains the reason for exemption from a tax.PartyID1..1oan identification of an entity doing business as assigned by an agency operating a party identification scheme. TaxSchemeID1..1=identifies the tax scheme within which a party is registered. TaxScheme.information directly relating to a tax scheme. TaxSchemeID Identifier1..1=identifies the tax scheme within which a party is registered.Address jurisdictionID0..1Xa unique identifier given to a specific address within a scheme of registered addresses.TradeCycleParty=Parties which play a role in the procurement business processOrderID1..1lThe OrderId element is a unique number assigned to the Order in respect to the parties assigning the number.PartyPartyID1..1oan identification of an entity doing business as assigned by an agency operating a party identification scheme.TradeCyclePartyPartyOrderNumber Identifier0..1AA number assigned to the Order in respect to the specified party.TransportEquipment7information relating to a piece of transport equipment.TransportEquipmentID Identifier1..1-identifier of a piece of transport equipment.ShipmentID1..1Identifier of a shipment.TransportEquipment ProviderTypeCode0..1<identifies the type of provider for the transport equipment.PartyOwnerID0..17identifier of an owner of piece of transport equipment.TransportEquipment SizeTypeCodeCode0..1Ecode specifying the size and type of a piece of transport equipment.TransportEquipment DispositionCode0..1=describes the current disposition of the transport equipment.TransportEquipmentFullnessIndicatorCode0..1XCode indicating whether a piece of transport equipment is full, empty or partially full.TransportEquipmentRefrigerationStatusIndicatorCode0..1Nindicates whether refrigeration is on or off for the transportation equipment.TransportEquipment InformationText0..1Madditional information in free form text relating to the transport equipment.TransportEquipmentMeasurement/information directly relating to a measurement.TransportEquipmentMeasurement AttributeID Identifier1..1lidentifies a physical attribute within a set of characteristics that describe something in a formalised way.TransportEquipmentID1..1-identifier of a piece of transport equipment.TransportEquipmentMeasurementMeasureMeasure0..1the value of the measurementTransportEquipmentMeasurement DescriptionText1..1*free text describing a physical attribute.TransportEquipmentMeasurementMinimumMeasureMeasure0..1the minimum value of the rangeTransportEquipmentMeasurementMaximumMeasureMeasure0..1the maximum value of the rangeJW 21GhXY lk4[    dMbP?*+_%&C&A &CPage &P&333333?'333333?(333333?)333333?" d,,??U } }  } X} ' } } Q<} M [     J                                   ! " # $ % & ' ( ) * + , - . / 0 1 2 3  4 5 6 7 8 9  : ; < = > ?  @ A B C D E  F G H I J K  L M N O P Q R S T U V W X Y Z [ \ ] ^ _ ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~                                              !"#$%&'()*+,-./0123456789:;<=>? !! ! ! ! ! "" "" ## # # # ## $$ $ $ $ $$ %% % % % %% && & & & && '' ' ' ' '' (( (( ( ( ( )) ) ) ) ) ** * * * * ++ + + + ++ ,, ,, -- - - - -- . . .. . .. / / // / // 00 00 0 00 11 11 1 11 22 22 2 22 33 3 3 3 33 44 4 4 4 44 55 55 66 66 6 66 77 7 7 7  7 7 8 8 8 8 8  88 99 99 9 99 :: :: : :: ;; ;; << < < < << == = =  =! ="= >#> >$ >% >& >'> ?(? ?) ?* ?+ ?,? @-@ @. @/ @0 @1@@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_ A2A A3 A4 A5 A6A B7B B8 B9 B: B;B C<C C= C> C? C@C DAD DBD ECE ED EE EF EGE FHF FIF GJG GK GL GM GNG HOH HPH HQ HRH ISI ITI IU IVI JWJ JX JY JZ J[J K\K K] K^ K_ K`K LaL LbL McM M!d Me Mf MgM NhN Ni Nj Nk NlN OmO On Oo Op OqO PrP Ps Pt Pu PvP QwQ Qx Qy Qz Q{Q R|R R} R~ R RR SS S S S SS TT T T T TT UU U U U UU VV VV WW W W W WW XX XX X XX YY Y Y Y YY ZZ ZZ Z ZZ [[ [[ \\ \ \ \ \\ ]] ]] ] ]] ^^ ^^ ^ ^^ __ _ _ _ __ `` ` ` ` ```abcdefghijklmnJopqrJsJtuJvwxyz{|}J~ aa a a a aa bb b b b bb cc cc dd d d d dd ee e e e ee ff ff f ff gg gg hh h h h hh ii i i i ii jj j j j jj kk kk k kk ll ll mm mm m mm nn n n n nn oo oo pp p p p pp qq qq q qq rr r r r rr ss s s  s  s s t  t  tt t tt uu u u u uu vv v v v vv ww w w w ww x x x! x" x# x$x y%y y& y' y( y)y z*z z+ z, z- z.z {/{ {0{ |1| |2| |3 |4| }5} }6 }7 }8 }9} ~:~ ~; ~< ~= ~>~ ? @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _ ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~                                                                                        !    !                                                                              ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ "_"""" `J a b c d e f g h #i j k l m #n o p q r #s t u v w x y z { | } ~       $                                                                            %                       JJ                                                                 ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B &C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _ ` a b c d e f g h i j k l m n o p q r s t u vJJ      w x y z { | } ~                                                                   !                                                       '                    !"#$%&'()*+,-./0123456789:;<=>? !! !! ! !! "" "" ## ## # ## $$ $ $  $  $ $ % % %  % % %% && & & & && '' '' (( ( ( ( (( ))( ))( ) ) ) *!* *)" *# *$ *%* +&+ +' +( +) +*+ ,+, ,, ,- ,. ,/, -0- -1- -2 -3- .4. .5. .6 .7. /8/ /9/ /: /;/ 0<0 0=0 1>1 1?1 1@ 1A1 2B2 2C 2D 2E 2F2 3G 3H 3I3 3J 3K3 4L 4M 4N4 4O 4P4 5Q 5R 5S5 5T 5U5 6V6 6W 6X 6Y 6Z6 7[7 7\ 7] 7^ 7_7 8`8 8a 8b 8c 8d8 9e9 9f 9g 9h 9i9 :j: :k :l :m :n: ;o; ;p ;q ;r ;s; <t< <u< =v= =w =x =y =z= >{> >| >} >~ >> ?? ? ? ? ?? @@ @ @ @ @@@ABCDEFGHIJKLMNOPQRSTUVWXYZ AA AA A AA BB BB B BB CC CC DD D D D DD E E EE E EE FF FF GG GG G GG HH( HH( H HH II I I I II JJ JJ KK K K K KK LL LL L LL MM M M M MM N N NN N NN OO O O O OO PP P P P PP QQ Q Q Q QQ RR R R R RR SS S S S SS TT TT UU U U U UU VV VV V VV WW W W W WW XX X X X XX YY Y Y Y YY ZZ Z Z Z ZZ(  x  6XPP? &x] <UBL Definition: If this is blank, then use the xCBL definition from the Structure Reference. Refer to Core Component Definition if available. <xx  6XPP? i&] Z<[Lisa: Use this column to hand craft the UBL Name, hide the name with the column when done.<Zxx  6XPP? i&] Z<[Lisa: Use this column to hand craft the UBL Name, hide the name with the column when done.<Z   >@A   FMicrosoft Excel 97-TabelleBiff8Oh+'0 h t 26@ Ϛ@uou@v@- uRoot EntryFWorkbook2;CompObjIOle _SX_DB_CURSummaryInformation((