ࡱ> OP  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNRoot Entry F82uЉ@WorkbookOle SummaryInformation( Oh+'0Px   $ 0 <HUBL Order Change 1.BL  UBL Library Content SubcommitteBL  v 1.0-alpha 1.User-al47r@+6@@!&)@r՜.+,0H @\pUser Ba==Z?N*8X@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)#,##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_-;_-@_-FA_-* #,##0.00\ "DM"_-;\-* #,##0.00\ "DM"_-;_-* "-"??\ "DM"_-;_-@_-FA_-* #,##0.00\ _D_M_-;\-* #,##0.00\ _D_M_-;_-* "-"??\ _D_M_-;_-@_- mm/dd/yy                      *1* (1(1(1*1***Z1   1 1     11             1   1 (83f3ffff̙̙3f3fff3f3f33333f33333\`M' OrderChange0 BuiltIn_AutoFilter___1;   ;&#  ;`iZR3  @@  ""UBL NameBIE Dictionary Entry NameObject Class Qualifier Object ClassProperty QualifierProperty Term Possessive(s)Property Term NounRepresentation Term QualifierRepresentation Term!Associated Object Class QualifierAssociated Object ClassBusiness Terms (Synonyms) OccurrenceBIE TypeUBL DefinitionExamplesDocumentary Namespace Prefix Analyst NotesCandidate CC IDContext: Business ProcessContext: Region (Geopolitical)Context: Official ConstraintsContext: ProductContext: Industry Context: RoleContext: Supporting RoleContext: System ConstraintEditor's Noteslengthpattern enumeration inclusive exclusivedigits Order ChangeDetailsDetailsPurchase Order ChangeABIEaa document that contains information directly relating to the economic event of changing an orderco Order ChangeBuyers Identifier Identifier0..1BBIEQa unique identification assigned to the OrderChange in respect to the Buyer party Order ChangeSellers Identifier Identifier0..1BBIE9the identification given to an OrderChange by the seller. Order ChangeCopy Indicator0..1BBIE=Indicates whether a document is a copy (true) or not (false) Order ChangeGlobally Unique Identifier Identifier0..1BBIEYa computer generated unique identifier for the document, which is guaranteed to be unique Order ChangeIssueDateDate1..1BBIENa date (and potentially time) stamp denoting when the Order Change was issued. Order ChangeDocumentStatusCode0..1BBIEHIdentifies the status of the document with regard to its original state.% Unchanged  Revision  Cancellation stat Order ChangeSequenceNumber Identifier1..1BBIEpThe Order Change Sequence Number is a unique number assigned to ensure the proper sequencing of Change requests. Order ChangeNoteText0..1BBIEcontains any free form text pertinent to the entire document or to the document message itself. This element may contain notes or any other similar information that is not contained explicitly in another structure. Order ChangeAcknowledgementCodeCode0..1BBIEspecifies the type of Response for the Order Change that the Buyer requires from the Seller. 'OrderResponseSimple' or 'OrderResponseComplex'-"OrderResponseSimple", "OrderResponseComplex"res Order Change TransactionCurrencyCode0..1BBIEBthe default currency of the transaction, to be used for Invoicing. "USD", "EUR"cur Order ChangePricingCurrencyCode0..1BBIEGthe currency in which all pricing on the transaction will be specified. "USD", "EUR"cur Order ChangeEarliestDateDate0..1BBIEDthe starting date on or after which Order should be considered valid Order Change Cancelled ByDateDate0..1BBIEFthe date on or after which Order should be cancelled if not satisfied. Order ChangeValidityDurationMeasure0..1BBIE(the period for which the Order is valid. Order ChangeTaxTotalAmount0..1BBIE.the total tax amount to be paid for the Order. Order ChangeLine ExtensionTotalAmount0..1BBIEthe total of line item extension amounts for the entire Order, but not adjusted by any payment settlement discount or taxation. Order ChangeTotalPackagesCountQuantity0..1BBIEAthe count of the total number of packages contained in the Order. Order ChangeGrossWeightMeasure0..1BBIETthe total gross weight of the order. (goods plus packaging plus transport equipment) Order ChangeNetWeightMeasure0..1BBIE9the total net weight of the order. (goods plus packaging) Order ChangeNet NetWeightMeasure0..1BBIE?the weight (mass) of the goods themselves without any packing. Order ChangeGrossVolumeMeasure0..1BBIE:the total volume of the goods plus packaging on the Order. Order ChangeNetVolumeMeasure0..1BBIE5the total volume of the Order. (goods less packaging) Order ChangeLineItemCountQuantity0..1BBIEthe number of line items Order ChangeOrderOrder Reference0..nASBIE3associates the Order Change with one or more Orders Order ChangeContractContractDocument Reference0..1ASBIEGassociates the changed changed Order with a previously agreed Contract. Order ChangeQuoteQuoteDocument Reference0..1ASBIE8associates the changed changed Order with a prior quote. Order Change Buyer Party1..1ASBIEZassociates the changed Order with information about the buyer involved in the transaction. Order Change Seller Party1..1ASBIE[associates the changed Order with information about the seller involved in the transaction. Order Change Originator OriginatorParty0..1ASBIEVassociates the changed Order with information about the originator of the transaction. Order ChangeFreight ForwarderFreight ForwarderPartyCarrier0..1ASBIEfassociates the changed Order with information about the freight forwarder involved in the transaction. Order ChangeDelivery0..nASBIE=associates the changed Order with a delivery (or deliveries) Order ChangeDelivery Terms0..1ASBIEzassociates the changed Order with the delivery terms agreed between seller and buyer with regard to the delivery of goods. Order ChangeAllowance Charge0..nASBIEdassociates the changed Order with one or more pricing components for overall charges allowances etc. Order ChangeSales Conditions0..1ASBIEXassociates the changed Order with a sales condition applying to the whole changed Order. Order Change Destination DestinationCountry0..1ASBIEUassociates the changed Order with the country of destination (for Customs purposes). Order Change Order Line1..nASBIE:associates the changed Order with one or more Line items.ENDData Type Qualifier Data Type*. gN,m(C!oME#u  t $  9  j  - - 7e C\!:""N#,$c+% % @ '+^ui  dMbP?_*+%&L&F&C&P (&N)&R&D GMT &T&333333?'333333?(?)?M*Canon Bubble-Jet BJC-210SPLC od,,LetterDINU"44NUJB8" 7 ,,??U} $ } I }   } m  } $  } $  }   }   } m } I } I  } $ }  }  } I }  } m  }   }  } $  }   }   }  } # '$$@$$$$$$$@$ $F $ $ $ $$$$$$$$$$$$$$$$$$$          B  B!                       ! " #!` (JD DBPBDBP Bx'Bx OrderChangeX @BD D_ BPBD . DetailsBPOrder Change. Details! !" !! !#! !$ !!""  !%! !& #'#  (($ !%%%%%%%!!!!!!!#&lLGlobally Unique  GU ,BLLL , BLL Identifier  ID,LText  ,BBBPBP Bx'Bx BuyersID&L. LL5LL L B$ .   B BLL(LL  .  _B BLL L. BPBLBP# Order Change. Buyers. Identifier' ') '*' '+' ', ''''' (- (. )/,)*(*'+++++++'''''''#& SellersID&$!Order Change. Sellers. Identifier' '0 '1' '2' '3 ''''' (4 (5 ,6,)*(*'+++++++'''''''#& CopyIndicator&8 Order Change. Copy. Indicator+ -7 -- -8- -9 ----- -: -; .<,//00000000000000000#&tGUID&,)Order Change. Globally Unique. Identifier' '= '> '?' '@ ''''' 'A 'B 'C,)*(*'+++++++'''''''#& IssueDate&Order Change. Issue. Date' 'D' 'E 'F' 'G ''''' (H (I )J,)*(*'+++++++'''''''#&DocumentStatusCode&D&#Order Change. Document_Status. Code+ -K- -L -M- -N ----- -O -P .Q /R /S(00000000000000000#&SequenceNumberID& ,)Order Change. Sequence_Number. Identifier' 'T' 'U 'V' 'W ''''' 1X (Y )Z,)*(*'+++++++'''''''# & Note & Order Change. Note. Text ' '[ '' '\ ' '] ''''' '^ '_ '`, )*(*'+++++++'''''''# &D AcknowledgementCode &l &#Order Change. Acknowledgement. Code ' 'a ' 'b 'c ' 'd ''''' (e (f )g )h /i( (*'+++++++'''''''# & TransactionCurrencyCode & +(Order Change. Transaction_Currency. Code ' 'j ' 'k 'l ' 'm ''''' (n (o )p )q /r( (*'+++++++'''''''# &8  PricingCurrencyCode &`  '$Order Change. Pricing_Currency. Code ' 's ' 't 'u ' 'v ''''' (w (x )y )z /{( (*'+++++++'''''''# &   EarliestDate & Order Change. Earliest. Date ' '| ' '} '~ ' ' ''''' ' ( ), )*(*'+++++++'''''''#& CancelledByDate&$ # Order Change. Cancelled By. Date' '' ' '' ' ''''' ' ( ),)*(*'+++++++'''''''#&h ValidityDurationMeasure& +(Order Change. Validity_Duration. Measure' '' ' '' ' ''''' ' ( ),)*(*'+++++++'''''''#& TaxTotalAmount& "Order Change. Tax_Total. Amount' '' ' '' ' ''''' ( ( ),)*(*'+++++++'''''''#&L LineExtensionTotalAmount& -*Order Change. Line Extension_Total. Amount' ' ' ' '' ' ''''' ( ( ),)*(*'+++++++'''''''#& TotalPackagesCountQuantity& /,Order Change. Total Packages_Count. Quantity' ' ' ' '' ' ''''' ( ( ),)*(*'+++++++'''''''#&l GrossWeightMeasure& &#Order Change. Gross Weight. Measure' ' '' '' ' ''''' ( ( ),)*(*'+++++++'''''''#& NetWeightMeasure& $!Order Change. Net Weight. Measure' ' '' '' ' ''''' ( ( ),)*(*'+++++++'''''''#&D NetNetWeightMeasure&l (%Order Change. Net Net Weight. Measure' ' '' '' ' ''''' ( ( ),)*(*'+++++++'''''''#& GrossVolumeMeasure& &#Order Change. Gross Volume. Measure' ' '' '' ' ''''' ( ( ),)*(*'+++++++'''''''#&(NetVolumeMeasure&L$!Order Change. Net Volume. Measure' ' '' '' ' ''''' ( ( ),)*(*'+++++++'''''''#&LineItemCountQuantity&)&Order Change. LineItem_Count. Quantity' '' ' '' ' ''''( ( ( ) //2 T% JL  L BPBL BP Bx'BxOrderReference2,t% jL L_ BPBL. L  L _ BPBL BP Order Change. Order Reference3 3 344h% LOrder Reference54% LOrder Reference  443  3 3 6 6 7,7262388888883333333#2ContractDocumentReference2-*Order Change. Contract_ Document Reference3 3 3444Document Reference54\Document Reference  44  3  3 3 6 6 7,7262388888883333333#2QuoteDocumentReference2*'Order Change. Quote_ Document Reference3 3 344Document Reference54,Document Reference  44  3  3 3 6 6 7,7262388888883333333#2T BuyerParty2lOrder Change. Buyer Party3 3 354 Buyer Party54 Buyer Party  443  3 3 6 6 9,9262388888883333333#2 SellerParty2Order Change. Seller Party3 3 354  Seller Party54< Seller Party  443  3 3 6 6 9,9262388888883333333#2XOriginatorParty2x"Order Change. Originator_ Party3 3 354Party54Party  44  3  3 3 6 6 9,9262388888883333333#2FreightForwarderParty2)&Order Change. Freight Forwarder_ Party3 3 354LParty54X Party  44  3  3  3 6 6 9,9262388888883333333#D1l:032]I"^g_8?O=VZEAHEA) $!$"$#$$$%$&$ 2d  Delivery 2x Order Change. Delivery 3 3 33 2  Delivery 3 2! Delivery 223 3 3 6 6 9, 9262388888883333333#!2! DeliveryTerms!2!Order Change. Delivery Terms!3 !3 !35!4(!Delivery Terms!5!4H"Delivery Terms ! 443 ! 3! 3 !6 !6 !9,!9262388888883333333#"2h"AllowanceCharge"2"!Order Change. Allowance Charge"3 "3  "35"4"Allowance Charge"5"4#Allowance Charge " 443 " 3 " 3 "6  "6  "9 ,"9262388888883333333##2#SalesConditions#20#!Order Change. Sales Conditions#3 #3 #35#4p#Sales Conditions#5#4$Sales Conditions # 443 # 3# 3 #6 #6 #9,#9262388888883333333#$2$DestinationCountry$2$%"Order Change. Destination_ Country$3 $3 $3$5$4($ Country$5$48% Country $ 44 $ 3 $ 3$ 3 $6 $6 $9,$9262388888883333333#%2H% OrderLine%2\%Order Change. Order Line%3 %3%37%4%!D%   $% B%4% Order Line%5%4% Order Line % 443 % 3% 3 %6 %6 %9,%9262388888883333333#$&:::::;::;;;;;<= &>.&???@A;:::::::;;;;;;;# xxH 0 (  x  6l+\XPP? "w]4l+\  <UBL Name: These are derived from the rules of the UBL Naming and Design Rules subcommittee. The formula used here is not the definitive version. The definitive UBL Name is generated automatically when the schemas are created. This value is provided here for guidance only. If any disparity exists between the UBL Name here and those in the schemas, the schema should be considered the correct UBL Name. (NB columns with grey headings are not part of the normative schemas)<xx  60\XPP? &w]40\  X <BIE Dictionary Entry Name: These are built following the rules of the ebXML Core Component Technical Specification. This is the unique official name of the Business Information Entity in the dictionary. <xx  6l0\XPP? &w]4l0\  X <Object Class Qualifier: A qualifier is a word or words which help define and differentiate a Business Information Entity fromother Business Information Entities. For example, when the BIE is used in another context.<xx  6.\XPP? 'w]4.\P  X  < Object Class: The use of this metadata is specified by the ebXML CCTS which in turn extends the ISO 11179 naming rules. An Object Class represents the logical data grouping or aggregation (in a logical data model) to which a Property belongs. Object Classes have explicit boundaries and meaning and their Properties and behaviour follow the same rules. Each Object Class is an ABIE. We also refer to these things Re-usable Types, and they are also known as Classes (to the UML) or Tables/Entities (to database designers). < xx  6H(\XPP? !w]4H(\  X < Property Qualifier: A qualifier is a word or words which help define and differentiate a Business Information Entity fromother Business Information Entities. Qualifiers specialise or modify the Property Term. For example, when the BIE is used in another context.<xx  6W\XPP? -w]4W\  X ~<Property Term Adjective(s). The use of this metadata is specified by the ebXML CCTS which in turn extends the ISO 11179 naming rules. Property Term represents the distinguishing characteristic or Property of the Object Class and shall occur naturally in the definition. Also known as an attribute (to database designers). The combination of Object Class and its Property Term, should give the basic semantic meaning of the item. The Property Term may consist of one or more possessive nouns preceeding the mandatory noun. This ownership creates a meaninginful refinement of the noun to make a meaningful and recognisable business name.<~xx  6$X\XPP? )w]4$X\  X <Property Term Noun. The use of this metadata is specified by the ebXML CCTS which in turn extends the ISO 11179 naming rules. Property Term represents the distinguishing characteristic or Property of the Object Class and shall occur naturally in the definition. Also known as an attribute (to database designers). The combination of Object Class and its Property Term, should give the basic semantic meaning of the item. The Property Term must contain at least a noun. It may also have one or more adjectives preceeding the noun to make a meaningful and recognisable business name. In generating BIE dictionary entry and UBL default names, the Representation Term may be dropped if the Noun and RT are effectively identical.<xx  6X\XPP?  w]4X\  X <A qualifier is a word or words which help define and differentiate a Business Information Entity fromother Business Information Entities. For example, when the BIE is used in another context.<xx   6X\XPP?   )w]4 X\H  X <Representation Term: The use of this metadata is specified by the ebXML CCTS which in turn extends the ISO 11179 naming rules. A Representation Term is an element of the name which describes the form in which the property is represented. <xx   6PY\XPP? o]4 PY\  X <Associated Object Class Qualifier: A qualifier is a word or words which help define and differentiate a Business Information Entity fromother Business Information Entities. For example, when the BIE is used in another context. Associated Object Class Qualifiers describe the 'context' of the relationship with another ABIE. That is, it is the role this Object Class plays within its association with another Object Class. In such cases, they then duplicate the Property Class Qualifier.<xx   6Y\XPP? 0o]4 Y\x X <Associated Object Class: Associated Object Class is the Object Class at the other end of this association. It will refer to another ABIE in this model.<xx   6Z\XPP? &o]4 Z\ X <Business Term: (Optional). This is a synonym term under which the Business Information Entity is commonly known and used in the business for a specific Context. A Business Information Entity may have several Business Terms or synonyms. <xx   6|Z\XPP? Do]4 |Z\ X Z<[Occurrence: The optionality and/or cardinality of the BIE. Expressed in XML Schema syntax.<Zxx  6Z\XPP? Xwo]4Z\@ X <BIE Type: There are three choices here: Basic (BBIE  white rows), Associate(ASBIE- green rows) or Aggregate BIE (ABIE -pink rows). This column is used to automatically generate the XSD schemas. (the program cannot read colours!)<xx  6D[\XPP? C'o]4D[\ X b<cUBL Definition: This is the unique semantic business meaning of that Business Information Entity. <bxx  6[\XPP? o]4[\p X <Documentary Namespace Prefix: This contains reference information suitable for the integration of the NDR Code Lists architecture.<xx  6 \\XPP? o]4 \\ X ~<Analyst Notes: This is a list of comments, queries and notes made as the work is done. It is not part of the normative schemas<~xx  6p\\XPP? o]4p\\ X <Core Component UID: This is the UID of the correlated core component, in those cases where a direct correlation exists. This information is found in the current Core Component Catalog.<xx  6\\XPP? h"]4\\8 X <Line colour: This colour denotes an ABIE - Aggregate Business Information Entity - line. This is also denoted by "ABIE" in the "BIE Type" column.<xx  68]\XPP? f"]48]\ X <Line colour: This colour denotes an ASBIE - Associated Business Information Entity - line. This is also denoted by "ASBIE" in the "BIE Type" column. <TMTMTMTMTMTMTMTM TM TM TM TM TMTMTM TTMTMTMTM>@d  7 DocumentSummaryInformation8CompObj fP X`hp x   OrderChange  Worksheets FMicrosoft Excel WorksheetBiff8Excel.Sheet.89q