OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

ubl message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]


Subject: 2.0 Update Package work list (16 November)


Here is the current list of update package tasks.

Unless I hear an objection in the interim, I intend to begin
making the spreadsheet and schema changes listed under Category 1
and Category 2 of "Specific Update Tasks" starting Monday morning.
Any changes resulting from our processing of the JPLSC comments
will, of course, be added to the list.

Jon

##################################################################

UNPROCESSED INPUT

Comments from the UBL Japanese Localizaton Subcommittee:

   http://lists.oasis-open.org/archives/ubl/200710/msg00021.html

##################################################################

UPDATE PACKAGE MECHANICS

See

   http://lists.oasis-open.org/archives/ubl/200710/msg00027.html
   http://lists.oasis-open.org/archives/ubl/200711/msg00006.html

##################################################################

SPECIFIC UPDATE TASKS

All references to the .xls versions of the spreadsheets apply to
the .ods versions as well, and vice-versa.

==================================================================

CATEGORY 1: SPREADSHEET DICTIONARY ENTRY NAME (DEN) ERRORS AND
CORRESPONDING SCHEMA DOCUMENTATION ERRORS

Note that these are also errors in the localization spreadsheets
and that cell references change in the versions being used for
localization.  Our strategy will be to correct the original 2.0
spreadsheets and then correct the localization spreadsheets
programmatically.

Neither the spreadsheet errors nor the few corresponding schema
documentation errors are substantive per OASIS definition.

1.1 In both UBL 2.0 Common Library spreadsheets, cell B455 reads
    "Hazardous Item. Medical First Aid Guide Code Code" and should
    read "Hazardous Item. Medical First Aid Guide Code. Code"

1.2 In both UBL 2.0 Catalogue Request spreadsheets, cell B28 reads
    "Catalogue Request. Catalogue Request B28Line" and should read
    "Catalogue Request. Catalogue Request Line"

1.3 DENs in UBL 2.0 Common Library cells B117, B118, B119, B252,
    B279, B895, B896 and B897 should be corrected as follows:

    B117: Catalogue Pricing Update Line. Contractor_ Customer Party. Customer Party
    B118: Catalogue Pricing Update Line. Seller_ Supplier Party. Supplier Party
    B119: Catalogue Pricing Update Line. Required_ Item Location  Quantity. Item Location Quantity
    B252: Credit Note Line. Discrepancy_ Response. Response
    B279: Debit Note Line. Discrepancy_ Response. Response
    B895: Shipment Stage. Loading Port_ Location. Location
    B896: Shipment Stage. Unloading Port_ Location. Location
    B897: Shipment Stage. Transship Port_ Location. Location

1.4 UBL 2.0 Common Library cell B38 has an invalid value
    "Allowance Charge. Reason. Text"; this should be "Allowance
    Charge. Allowance Charge_ Reason. Text"

1.5 UBL 2.0 Common Library cells B253 and B254 have a DEN starting
    with "Credit Note" when the DEN should start with "Credit Note
    Line"

1.6 UBL 2.0 Common Library cells B280 and B281 have a DEN starting
     with "Debit Note" when the DEN should start with "Debit Note
     Line"

1.7 UBL 2.0 Common Library cell B423 has a DEN "Goods Item.
    Quantity. Quantity" that should be "Goods Item. Quantity"

1.8 UBL 2.0 Common Library cell G424 reads "Criterion" and should
    read "Code" because the representation term is "Code", which
    then changes F424 from "Preference" to "Preference Criterion"

    Schema documentation: change "Goods Item. Preference
    Criterion. Code" to "Goods Item. Preference Criterion
    Code. Code"

1.9 UBL 2.0 Common Library cell G577 reads "Method" and should
    read "Code" because the representation term is "Code", which
    then changes F577 from "Inspection" to "Inspection Method"

    Schema documentation: change "Line Item. Inspection
    Method. Code" to "Line Item. Inspection Method Code. Code"

1.10 UBL 2.0 Common Library cell B653 reads "Order Reference.
     Customer_Reference. Text" and should read "Order
     Reference. Customer_ Reference. Text"

1.11 UBL 2.0 Common Library cell I779 is empty and should be "Line
     Item"

1.12 UBL 2.0 Common Library cell B796 reads "Receipt Line. Timing
     Complaint. Code" and should read "Receipt Line. Timing
     Complaint Code. Code" because of the property term

1.13 UBL 2.0 Common Library cell G856 reads "Level" and should
     read "Code" because the representation term is "Code", which
     then changes F856 from "Shipping Priority" to "Shipping
     Priority Level"

     Schema documentation: change "Shipment. Shipping Priority
     Level. Code" to "Shipment. Shipping Priority Level Code. Code"

1.14 UBL 2.0 Common Library cell E881 reads "First Arrival Port "
     and the trailing space should be removed to read "First Arrival
     Port"

1.15 UBL 2.0 Common Library cell E882 reads "Last Arrival Port "
     and the trailing space should be removed to read "Last Arrival
     Port"

1.16 UBL 2.0 Common Library cell B939 has a DEN "Status. Percent.
     Percent" that should be "Status. Percent"

1.17 UBL 2.0 Common Library cell B1027 reads "Transport Event.
     Transport Event Type. Code" and should read "Transport Event.
     Transport Event Type Code. Code" because of the property term

1.18 In the following spreadsheets, cells H4 and H5 are wrong 
     because they are the fixed string "Identifier" rather than
     the formula found in H3 which produces the correct value.
     Copying the formula from H3 to H4 and H5 repairs these cells
     (turns out to be every one *except*
     UBL-TransportationStatus-2.0.ods which is already correct in
     UBL 2.0):

     UBL-ApplicationResponse-2.0.ods
     UBL-AttachedDocument-2.0.ods
     UBL-BillOfLading-2.0.ods
     UBL-Catalogue-2.0.ods
     UBL-CatalogueDeletion-2.0.ods
     UBL-CatalogueItemSpecificationUpdate-2.0.ods
     UBL-CataloguePricingUpdate-2.0.ods
     UBL-CatalogueRequest-2.0.ods
     UBL-CertificateOfOrigin-2.0.ods
     UBL-CreditNote-2.0.ods
     UBL-DebitNote-2.0.ods
     UBL-DespatchAdvice-2.0.ods
     UBL-ForwardingInstructions-2.0.ods
     UBL-FreightInvoice-2.0.ods
     UBL-Invoice-2.0.ods
     UBL-Order-2.0.ods
     UBL-OrderCancellation-2.0.ods
     UBL-OrderChange-2.0.ods
     UBL-OrderResponse-2.0.ods
     UBL-OrderResponseSimple-2.0.ods
     UBL-PackingList-2.0.ods
     UBL-Quotation-2.0.ods
     UBL-ReceiptAdvice-2.0.ods
     UBL-Reminder-2.0.ods
     UBL-RemittanceAdvice-2.0.ods
     UBL-RequestForQuotation-2.0.ods
     UBL-SelfBilledCreditNote-2.0.ods
     UBL-SelfBilledInvoice-2.0.ods
     UBL-Statement-2.0.ods
     UBL-Waybill-2.0.ods

1.19 in UBL-CreditNote-2.0.ods cell B3 reads "Credit Note. UBL
     Version. Identifier" and should read "Credit Note. UBL Version
     Identifier. Identifier"

1.20 in UBL-DespatchAdvice-2.0.ods cell J1 is empty and should
     read "Data Type Qualifier"

1.21 in UBL-DespatchAdvice-2.0.ods cell F11 should change from
     "Document" to "Document Status" and G11 from "Status" to
     "Code" (specifically leaving J11 as is)

      Schema documentation: change "Despatch Advice. Document
      Status. Code" to "Despatch Advice. Document Status
      Code. Code".

1.22 in UBL-Invoice-2.0.ods cell B36 has "Invoice. Tax_
     Representative_ Party. Party" and should be "Invoice. Tax
     Representative_ Party. Party"

1.23 The values in UBL-Reminder-2.0.ods row 12 are correct as they
     stand, but the literal "Reminder Sequence" in H12 "should be
     the formula in every other row of column 12"

1.24 in UBL-CatalogueRequest-2.0.xls cell B30 (row 27) must be
     "Catalogue Request. Catalogue Request Line" [reference is to
     IDD versions; need cell number for 2.0 versions]

1.25 in UBL-SelfBilledCreditNote-2.0.xls cell B38 must be "Self
     Billed Credit Note. Legal_ Monetary Total. Monetary Total"
     [reference is to IDD versions; need cell number for 2.0
     versions]

==================================================================

CATEGORY 2: OTHER SPREADSHEET ERRORS

Note that these are also errors in the localization spreadsheets
and that cell references change in the versions being used for
localization.  As before, we plan to fix the originals and then
update the localization spreadsheets programmatically.

2.1 mod/maindoc/UBL-Waybill-2.0.xls: cell A4 has the UBLName
    "FALSE"; this should be the word "CustomizationID"

2.2 mod/common/UBL-CommonLibrary-2.0.xls: cell Q99 has
    "assiciation" for "association" (this also appears in
    xsd/common/UBL-CommonAggregateComponents-2.0.xsd, though not a
    substantive error)

==================================================================

CATEGORY 3: ERRORS IN THE LOCALIZATION SPREADSHEETS THAT ARE NOT
ALSO ERRORS IN THE ORIGINAL SPREADSHEETS

ACTION: Need to check the latest versions of the finished
translations to see whether these problems have already been
corrected.

3.1 UBL-FreightInvoice-2.0.xls: Recorded as follows: Title in first
    row should be "UBL FreightInvoice 2.0" instead of "UBL Freight
    Invoice 2.0" (but in fact all the titles should have exactly
    the name used for the file except for the extension, e.g.,
    "UBL-FreightInvoice-2.0," or they should be written as if they
    were English, that is, with spaces)

3.2 UBL-PackingList-2.0.xls: Same comment as above

==================================================================

CATEGORY 4: CODE LIST CHANGES

4.1 cl/gc/default/CountryIdentificationCode-2.0.gc has two broken
    entries for Bosnia and Herzegovina when there should be just
    one correct entry:

      <Row>
         <Value ColumnRef="code">
            <SimpleValue>BOSNIA</SimpleValue>
         </Value>
         <Value ColumnRef="name">
            <SimpleValue/>
         </Value>
         <Value ColumnRef="numericcode">
            <SimpleValue>AND</SimpleValue>
         </Value>
      </Row>
      [...]
      <Row>
         <Value ColumnRef="code">
            <SimpleValue>BA</SimpleValue>
         </Value>
         <Value ColumnRef="name">
            <SimpleValue>HERZEGOVINA</SimpleValue>
         </Value>
         <Value ColumnRef="numericcode">
            <SimpleValue>070</SimpleValue>
         </Value>
      </Row>

4.2 cl/gc/special-purpose/PortCode-2.0.gc is missing a country
    subdivision column, resulting (for example) in 11 different
    locations named "Columbus" with no way of disambiguating them

4.3 cl/gc/UnitOfMeasureCode-2.0.gc needs to be replaced by later
    version from UNECE

4.4 cl/gc/TransportationStatusCode-2.0.gc needs to be replaced by
    later version from UNECE

==================================================================

CATEGORY 5: CODE LIST UPDATE

All the genericode files need to be updated to genericode 1.0.


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]