Hello UBL TC,
Here's what I've got so far for the changes we need to make to
produce the Update Package for UBL 2.0. I'm sure that I've missed
something. Please review.
Jon
##################################################################
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:
[...]
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.