ࡱ> LM  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKRoot Entry F82upfR@WorkbookHOle SummaryInformation(x Oh+'0Hx    ( 4@ UBL OrderhBL  UBL Library Content SubcommitteBL  v 1.0-alpha 1.User-al44r@8@ @S0@V՜.+,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_-;_-@_-                      *1* (1(1(1*1***Z1   1 1    11             1   1 (83f3ffff̙̙3f3fff3f3f33333f33333\` $Order0 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 exclusivedigitsOrderDetailsDetailsPurchase OrderABIEba document that contains information directly relating to the economic event of ordering products.poOrderBuyers Identifier Identifier0..1BBIEKa unique identification assigned to the Order in respect to the Buyer partyOrderSellers Identifier Identifier0..1BBIE3the identification given to an Order by the seller.OrderCopy Indicator0..1BBIE=Indicates whether a document is a copy (true) or not (false) OrderGlobally Unique Identifier Identifier0..1BBIEYa computer generated unique identifier for the document, which is guaranteed to be uniqueOrderIssueDateDate1..1BBIEGa date (and potentially time) stamp denoting when the Order was issued.OrderNoteText0..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. OrderAcknowledgementResponseCode0..1BBIEspecifies the type of Response for the Order that the Buyer requires from the Seller. 'OrderResponseSimple' or OrderResponseComplex'-"OrderResponseSimple", "OrderResponseComplex"resOrder TransactionCurrencyCode0..1BBIEBthe default currency of the transaction, to be used for Invoicing. "USD", "EUR"curOrderPricingCurrencyCode0..1BBIEGthe currency in which all pricing on the transaction will be specified. "USD", "EUR"curOrderEarliestDateDate0..1BBIEDthe starting date on or after which Order should be considered validOrder Cancelled ByDateDate0..1BBIEFthe date on or after which Order should be cancelled if not satisfied.OrderValidityDurationMeasure0..1BBIE(the period for which the Order is valid.OrderTaxTotalAmount0..1BBIE.the total tax amount to be paid for the Order.OrderLine ExtensionTotalAmount0..1BBIEthe total of line item extension amounts for the entire Order, but not adjusted by any payment settlement discount or taxation.OrderTotalPackagesQuantityQuantity0..1BBIEAthe count of the total number of packages contained in the Order.OrderGrossWeightMeasure0..1BBIETthe total gross weight of the order. (goods plus packaging plus transport equipment)OrderNetWeightMeasure0..1BBIE9the total net weight of the order. (goods plus packaging)OrderNet NetWeightMeasure0..1BBIE?the weight (mass) of the goods themselves without any packing. OrderGrossVolumeMeasure0..1BBIE:the total volume of the goods plus packaging on the Order.OrderNetVolumeMeasure0..1BBIE5the total volume of the Order. (goods less packaging)OrderLineItemCountQuantity0..1BBIEthe number of line itemsOrderContractContractDocument Reference0..1ASBIE7associates the Order with a previously agreed Contract.OrderQuoteQuoteDocument Reference0..1ASBIE(associates the Order with a prior quote.Order Additional AdditionalDocument Reference0..nASBIE@associates the Order with one or more other identification meansOrder Buyer Party1..1ASBIERassociates the Order with information about the buyer involved in the transaction.Order Seller Party1..1ASBIESassociates the Order with information about the seller involved in the transaction.Order Originator OriginatorParty0..1ASBIENassociates the Order with information about the originator of the transaction.OrderFreight ForwarderFreight ForwarderPartyCarrier0..1ASBIE^associates the Order with information about the freight forwarder involved in the transaction.OrderDelivery0..nASBIE5associates the Order with a delivery (or deliveries)OrderDelivery Terms0..1ASBIErassociates the Order with the delivery terms agreed between seller and buyer with regard to the delivery of goods.OrderAllowance Charge0..nASBIE\associates the Order with one or more pricing components for overall charges allowances etc.OrderSales Conditions0..1ASBIEHassociates the Order with a sales condition applying to the whole order.Order Destination DestinationCountry0..1ASBIEMassociates the Order with the country of destination (for Customs purposes). Order Order Line1..nASBIE1associates the Order with one or more Line items.ENDData Type Qualifier Data Type Zg,S`Wdt|    O\  bo  S`  <IANjwJW v !"," @ %f(5[b  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  }  }  } $  } m } $ } $  }  }  } I  }   } I } m  }   } m  }  } #m %$$7@$$$$$$$e$ $ $ $ $ $$$$$$$$$$$$$ @$$$$$$          A A                       ! " #!` JD DBPBDBP Bx'BxOrderX BD D_ BPBD . DetailsBPOrder. Details! !" !! !#! !$ !!""  !%! !& #'#  (($ !%%%%%%%!!!!!!!#&LGlobally Unique  GU ,BLLL , BLL Identifier  ID,LText  ,BBBPBP Bx'Bx BuyersID&$L. LL5LL L B$ .   B BLL(LL  .  _B BLL L. BPBLBPOrder. Buyers. Identifier' ') '*' '+' ', ''''' (- (. )/,)*(*'+++++++'''''''#&X SellersID&lOrder. Sellers. Identifier' '0 '1' '2' '3 ''''' (4 (5 ,6,)*(*'+++++++'''''''#& CopyIndicator&Order. Copy. Indicator+ -7 -- -8- -9 ----- -: -; .<,//00000000000000000#&GUID&%"Order. Globally Unique. Identifier' '= '> '?' '@ ''''' 'A 'B 'C,)*(*'+++++++'''''''#&D IssueDate&XOrder. Issue. Date' 'D' 'E 'F' 'G ''''' (H (I )J,)*(*'+++++++'''''''#&Note&Order. Note. Text' 'K '' 'L' 'M ''''' 'N 'O 'P,)*(*'+++++++'''''''#&AcknowledgementResponseCode& (%Order. Acknowledgement_Response. Code' 'Q' 'R 'S' 'T ''''' (U (V )W )X /Y((*'+++++++'''''''# &4 TransactionCurrencyCode &d $!Order. Transaction_Currency. Code ' 'Z ' '[ '\ ' '] ''''' (^ (_ )` )a /b( (*'+++++++'''''''# & PricingCurrencyCode &  Order. Pricing_Currency. Code ' 'c ' 'd 'e ' 'f ''''' (g (h )i )j /k( (*'+++++++'''''''# &   EarliestDate &( Order. Earliest. Date ' 'l ' 'm 'n ' 'o ''''' 'p (q )r, )*(*'+++++++'''''''# &T CancelledByDate &t Order. Cancelled By. Date ' 's ' 't 'u ' 'v ''''' 'w (x )y, )*(*'+++++++'''''''# & ValidityDurationMeasure &$!Order. Validity_Duration. Measure ' 'z ' '{ '| ' '} ''''' '~ ( ), )*(*'+++++++'''''''#& TaxTotalAmount&< Order. Tax_Total. Amount' '' ' '' ' ''''' ( ( ),)*(*'+++++++'''''''#&p LineExtensionTotalAmount& &#Order. Line Extension_Total. Amount' ' ' ' '' ' ''''' ( ( ),)*(*'+++++++'''''''#& TotalPackagesQuantity& "Order. Total Packages. Quantity' ' ' ' '' ' ''''' ( ( ),)*(*'+++++++'''''''#&X GrossWeightMeasure& Order. Gross Weight. Measure' ' '' '' ' ''''' ( ( ),)*(*'+++++++'''''''#& NetWeightMeasure& Order. Net Weight. Measure' ' '' '' ' ''''' ( ( ),)*(*'+++++++'''''''#& NetNetWeightMeasure&@ !Order. Net Net Weight. Measure' ' '' '' ' ''''' ( ( ),)*(*'+++++++'''''''#& GrossVolumeMeasure& Order. Gross Volume. Measure' ' '' '' ' ''''' ( ( ),)*(*'+++++++'''''''#& NetVolumeMeasure& Order. Net Volume. Measure' ' '' '' ' ''''' ( ( ),)*(*'+++++++'''''''#&@ LineItemCountQuantity&l "Order. LineItem_Count. Quantity' '' ' '' ' ''''( ( ( ) //1 T# JL  L BPBL BP Bx'BxContractDocumentReference1 t# jL L_ BPBL. L  L _ BPBL BP&#Order. Contract_ Document Reference2 2 233( # LDocument Reference43P # LDocument Reference  33  2  2 2 5 5 6,6151277777772222222#1x QuoteDocumentReference1 # Order. Quote_ Document Reference2 2 233 Document Reference43Document Reference  33  2  2 2 5 5 6,6151277777772222222#1<AdditionalDocumentReference1t(%Order. Additional_ Document Reference2 2 233Document Reference43Document Reference  33  2  2 2 5 5 6,6151277777772222222#1 BuyerParty1(Order. Buyer Party2 2 243P Buyer Party43h Buyer Party  332  2 2 5 5 8,8151277777772222222#1 SellerParty1Order. Seller Party2 2 243 Seller Party43 Seller Party  332  2 2 5 5 8,8151277777772222222#1OriginatorParty1Order. Originator_ Party2 2 243LParty43XParty  33  2  2 2 5 5 8,8151277777772222222#1dFreightForwarderParty1"Order. Freight Forwarder_ Party2 2 243Party43Party  33  2  2  2 5 5 8,8151277777772222222#1 Delivery1Order. Delivery2 2 221 Delivery210 Delivery  112  2 2 5 5 8,8151277777772222222#1D DeliveryTerms1`Order. Delivery Terms2 2 243Delivery Terms43 Delivery Terms  332  2 2 5 5 8,8151277777772222222#D71l3),+h`X18H6OH>:A>:"|q $!$"$#$$$ 1 AllowanceCharge 1 Order. Allowance Charge 2 2 24 3 Allowance Charge 4 3@!Allowance Charge 332 2 2 5 5 8, 8151277777772222222#!1d!SalesConditions!1!Order. Sales Conditions!2 !2 !24!3!Sales Conditions!4!3"Sales Conditions ! 332 ! 2! 2 !5 !5 !8,!8151277777772222222#"1"DestinationCountry"1$"Order. Destination_ Country"2 "2 "2"4"3\" Country"4"3l# Country " 33 " 2 " 2" 2 "5 "5  "8 ,"8151277777772222222##1|# OrderLine#1#Order. Order Line#2 #2 #27#3#!D#   $# B#3# Order Line#4#3# Order Line # 332 # 2 # 2 #5  #5 #8,#8151277777772222222#$$99999:99:::::;< $=.$>>>?@:9999999:::::::#6PH 0 (  x  64+\XPP? )w]44+\  <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  6/\XPP? )w]4/\ 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  6P.\XPP? )w]4P.\|  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$(\  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  6 W\XPP? %w]4 W\  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  6pW\XPP?  w]4pW\D  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  6W\XPP?  w]4W\  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  6$X\XPP?  w]4$X\t  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\  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   6X\XPP? 2zo]4 X\  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   6PY\XPP? }(o]4 PY\< 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   6Y\XPP? (o]4 Y\ 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. These may be used to 'map' BIEs to a controlled vocabulary, other vocabularies or labels for forms presentation.<]xx   6Z\XPP? ?o]4 Z\l X Z<[Occurrence: The optionality and/or cardinality of the BIE. Expressed in XML Schema syntax.<Zxx  6|Z\XPP? [o]4|Z\ 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  6Z\XPP? 7o]4Z\ X b<cUBL Definition: This is the unique semantic business meaning of that Business Information Entity. <bxx  6D[\XPP?  o]4D[\4 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  6 \\XPP? o]4 \\d 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  6p\\XPP? j)]4p\\ 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  6\\XPP? f)]4\\ 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  Order  Worksheets FMicrosoft Excel WorksheetBiff8Excel.Sheet.89q