ࡱ> CD  !"#$%&'()*+,-./0123456789:;<=>?@ABRoot Entry Fu0Q@Workbook|Ole SummaryInformation(x Oh+'0Hx    ( 4@ UBL InvoiceBL  UBL Library Content SubcommitteBL  v 1.0-alpha 1.User-al40r@xu@I2@S0@՜.+,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   1  1          1   1 (83f3ffff̙̙3f3fff3f3f33333f33333\`=Invoice0 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 exclusivedigitsInvoiceDetailsDetailsABIEAthe document that describes the finanical commitment of the OrderinInvoice Identifier Identifier1..1BBIECthe unique number assigned to the invoice by the seller (invoicer) InvoiceCopy Indicator0..1BBIE=Indicates whether a document is a copy (true) or not (false) InvoiceGlobally Unique Identifier Identifier0..1BBIEYa computer generated unique identifier for the document, which is guaranteed to be uniqueInvoiceIssueDateDate1..1BBIE$the date when the invoice was issuedInvoiceInvoiceTypeCode0..1BBIE-identifies the type of the Invoice by a code. "Commercial","Credit","Proforma"intypInvoiceNoteText0..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. Invoice Tax PointDateDate1..1BBIE[the date of the invoice for tax purposes, in accordance with the applicable tax regulation.InvoiceInvoiceCurrencyCode0..1BBIEkthe currency in which the Invoice is presented. This may be the same currency as the pricing or as the tax.curInvoiceTaxCurrencyCode0..1BBIEthe currency in which the tax on the Invoice is presented. This may be the same currency as the pricing or as the Invoice itself.curInvoicePricingCurrencyCode0..1BBIErthe currency in which the prices are specified. This may be the same currency as the Invoice itself or as the tax.curInvoiceLineItemCountQuantity0..1BBIEthe number of line itemsInvoiceOrder Reference0..nASBIEBProvides a means of associating an Invoice with one or more OrdersInvoiceDespatch AdviceDespatchDocument Reference0..nASBIELProvides a means of associating an Invoice with one or more Despatch AdvicesInvoiceReceipt AdviceReceiptDocument Reference0..nASBIEKProvides a means of associating an Invoice with one or more Receipt AdvicesInvoice Additional AdditionalDocument Reference0..nASBIE/Provides other means of identifying an Invoice Invoice Buyer Party1..1ASBIERassociates the Order with information about the buyer involved in the transaction.Invoice Seller Party1..1ASBIESassociates the Order with information about the seller involved in the transaction.InvoiceDelivery0..nASBIEMassociates the overall invoice with the details of a delivery (or deliveries)Invoice Payment Means0..1ASBIE:associates the invoice with the expected means of payment.Invoice Payment Terms0..nASBIEAassociates the invoice with the payment terms applicable/offered.InvoiceAllowance Charge0..nASBIE;associates the invoice with an overall charge or allowance.Invoice Exchange Rate0..1ASBIEassociates the invoice with an exchange rate. In any one invoice there is only one exchange rate needed, either between invoicing at tax currency, or between pricing and invoice totalling.Invoice Tax Total0..nASBIEEassociates the invoice with summary information for a particular tax.Invoice Legal Total1..1ASBIE\associates the invoice with a set of totals required for the invoice to be a legal document.Invoice Invoice Line1..nASBIE(an invoice has one or more invoice linesENDData Type Qualifier Data Type ,g,w5N=(O9 Y 6  8s :  _ Z"] D @ s#+Q  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 } $  } m } $ } $  }  } $ }   } m  }   } m  }  } #m $$$$$$$$$e$ $ $ $ $ $$$$$$$$$$$e$$$$          ? ?                       ! " #!`JD DBPBDBP Bx'Bx InvoiceXBD D_ BPBD . DetailsBPInvoice. Details  "    #  $  !% "&# '(! $$$$$$$ #%< LGlobally Unique  GU ,BLLL , BLL Identifier  ID,LText  ,BBBPBP Bx'BxID%D  L. LL5LL L B$ .   B BLL(LL  .  _B BLL L. BPBLBPInvoice. Identifier& &( && &)& &* &&'&& (+ (, )-,)*(*&+++++++&&&&&&&#%l CopyIndicator%Invoice. Copy. Indicator+ ,. ,, ,/, ,0 ,,,,, ,1 ,2 -3,..'''''''''''''''''#%GUID%'$Invoice. Globally Unique. Identifier& &4 &5 &6& &7 &&&&& &8 &9 &:,)*(*&+++++++&&&&&&&#% IssueDate%(Invoice. Issue. Date& &;& &< &=& &> &&&&& (? (@ )A,)*(*&+++++++&&&&&&&#%TInvoiceTypeCode%tInvoice. Invoice_Type. Code& &B& &C &D& &E &&&&& (F (G &H )I /J((*&+++++++&&&&&&&#%Note%Invoice. Note. Text& &K && &L& &M &&&&& &N &O &P,)*(*&+++++++&&&&&&&#% TaxPointDate% Invoice. Tax Point. Date& &Q& &R &S& &T &&&&& (U (V )W,)*(*&+++++++&&&&&&&# %0 InvoiceCurrencyCode %X "Invoice. Invoice_Currency. Code & &X & &Y &Z & &[ &&&&& (\ (] &^ ) *_( (*&+++++++&&&&&&&# % TaxCurrencyCode % Invoice. Tax_Currency. Code & &` & &a &b & &c &&&&& (d (e &f ) *g( (*&+++++++&&&&&&&# % PricingCurrencyCode % "Invoice. Pricing_Currency. Code & &h & &i &j & &k &&&&& (l (m &n ) *o( (*&+++++++&&&&&&&# %X LineItemCountQuantity % $!Invoice. LineItem_Count. Quantity & &p & &q &r & &s &&&&( (t (u )v, )*(*&+++++++&&&&&&&# 0  T JL  L BPBL BP Bx'BxOrderReference 0  t jL L_ BPBL. L  L _ BPBL BPInvoice. Order Reference 1 1w 11 0   LOrder Reference 1 0<  LOrder Reference 001 1x 1 1y 1z 2{, 2030144444441111111#0\ DespatchDocumentReference0 (%Invoice. Despatch_ Document Reference1 1| 1}10 Document Reference10 Document Reference  00  1~  1 1 1 1 2,2030144444441111111#0, ReceiptDocumentReference0` '$Invoice. Receipt_ Document Reference1 1 110 Document Reference10 Document Reference  00  1  1 1 1 1 2,2030144444441111111#0 AdditionalDocumentReference04  *'Invoice. Additional_ Document Reference1 1 110  Document Reference10  Document Reference  00  1  1 1 1 1 2,2030144444441111111#0   BuyerParty0  Invoice. Buyer Party1 1 156   Buyer Party560   Buyer Party  661  1 1 3 3 2,2030144444441111111#0H   SellerParty0`  Invoice. Seller Party1 1 156   Seller Party56   Seller Party  661  1 1 3 3 2,2030144444441111111#0   Delivery0  Invoice. Delivery1 1 110   Delivery10   Delivery  001  1 1 3 3 2,2030144444441111111#0$   PaymentMeans0@  Invoice. Payment Means1 1 110p   Payment Means10   Payment Means  001  1 1 1 1 2,2030144444441111111#0   PaymentTerms0  Invoice. Payment Terms1 1 110   Payment Terms10   Payment Terms  001  1 1 1 1 2,2030144444441111111#0,  AllowanceCharge0L  Invoice. Allowance Charge1 1 110  Allowance Charge10  Allowance Charge  001  1 1 1 1 2,2030144444441111111#0   ExchangeRate0  Invoice. Exchange Rate1 1 110   Exchange Rate100   Exchange Rate  001  1 1 1 1 2,2030144444441111111#0L   TaxTotal0`  Invoice. Tax Total1 1 110   Tax Total10   Tax Total  001  1 1 1 1 2,2030144444441111111#0   LegalTotal0  Invoice. Legal Total1 1 110   Legal Total10   Legal Total  001  1 1 1 1 2,2030144444441111111#0$  InvoiceLine0< Invoice. Invoice Line1 1 110h  Invoice Line10  Invoice Line  001  1 1 1 1 2,2030144444441111111#$77777877888889: ;.<<<=>877777778888888#<P,+.-R4VNVF~sv~H 0 (  x  6M\XPP? )J]4M\`  <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  6DN\XPP? )J]4DN\ 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  6N\XPP? )J]4N\H 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  6N\XPP? #J]4N\ 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\O\XPP?  J]4\O\x  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  6O\XPP?  J]4O\  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$P\XPP?  J]4$P\  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  6P\XPP?  J]4P\@  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   6P\XPP?   &J]4 P\  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   6PQ\XPP? J]4 PQ\p  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   6Q\XPP? }(J]4 Q\  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   6R\XPP? (J]4 R\  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   6|R\XPP? $J]4 |R\8 X Z<[Occurrence: The optionality and/or cardinality of the BIE. Expressed in XML Schema syntax.<Zxx  6R\XPP? J]4R\ 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  6DS\XPP? J]4DS\h X b<cUBL Definition: This is the unique semantic business meaning of that Business Information Entity. <bxx  6S\XPP? J]4S\ X <Documentary Namespace Prefix: This contains reference information suitable for the integration of the NDR Code Lists architecture.<xx  6 T\XPP? J]4 T\ 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  6pT\XPP? JJ]4pT\0 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  6T\XPP? _)]4T\ 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  68U\XPP?  f)]48U\` 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 TTMTMTM TM>@d  7 DocumentSummaryInformation8CompObj fP X`hp x  Invoice  Worksheets FMicrosoft Excel WorksheetBiff8Excel.Sheet.89q