[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: 2.0 Update Package work list (14 January)
Here's the latest Update Package work list. Note that a number of items starting at 6.01 are still being resolved (search on square brackets). Jon ################################################################## 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.01 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.02 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.03 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.04 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.05 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.06 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.07 UBL 2.0 Common Library cell B423 has a DEN "Goods Item. Quantity. Quantity" that should be "Goods Item. Quantity" 1.08 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.09 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.01 mod/maindoc/UBL-Waybill-2.0.xls: cell A4 has the UBLName "FALSE"; this should be the word "CustomizationID" 2.02 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.01 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.02 UBL-PackingList-2.0.xls: Same comment as above ================================================================== CATEGORY 4: CODE LIST CHANGES 4.01 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.02 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.03 cl/gc/UnitOfMeasureCode-2.0.gc needs to be replaced by later version from UNECE 4.04 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. ================================================================== CATEGORY 6: CHANGES RESULTING FROM JPLSC REVIEW See http://lists.oasis-open.org/archives/ubl/200710/msg00021.html http://lists.oasis-open.org/archives/ubl/200711/msg00020.html http://lists.oasis-open.org/archives/ubl/200711/msg00028.html The numbering used here follows numbering of the JPLSC comments. 6.01 [Not backward-compatible; to be considered in next major release] 6.02 [Waiting for specific examples] 6.03 [Waiting for input from PSC] 6.04 [To be considered in next major release] 6.05 [Waiting for input from PSC] 6.06 [TM to provide answer] 6.07 [TM to provide answer] 6.08 Order / AccountingCost (BBIE): Change "code" in definition to "cost centre". 6.09 [No change] 6.10 [Possible optional constructs to be considered for UBL 2.1] 6.11 [TM to provide answer] 6.12 [No change] 6.13 [No change] 6.14 DespatchAdvice / DeliveryCustomerParty (ASBIE): Change definition 'An association to the Delivery Party' to 'An association to the Delivery Customer Party'. 6.15 Invoice / AccountingCost (BBIE): Change "code" in definition to "cost centre". 6.16 [No change] 6.17 Change "total amount payable" in definition to "legally binding total amount payable." 6.18 [Waiting for input from PSC list] 6.19 [No change] 6.20 ForwardingInstructions / ID (BBIE): In definition, remove second sentence; in Business Terms, add "shipping instruction". 6.21 [No change] 6.22 [No change] 6.23 [Waiting for correction from TM] 6.24 BillOfLading / DocumentDistribution (ASBIE): In definition, change "Bill" to "Bill of Lading". 6.25 [Waiting for input from TSC] 6.26 PackingList / DocumentDistribution (ASBIE): In definition, change 'Contain information on the distribution list of the documents.' to 'The distribution of the Packing List to interested parties.' (Cf. DocumentDistribution in Waybill.) 6.27 FreightInvoice / some BIEs: Change all "Invoice" in definitions to "Freight Invoice". 6.28 Common / AllowanceCharge (ABIE) / AccountingCost (BBIE): Change "code" in definition to "cost centre". 6.29 Common / BillingReferenceLine (ABIE) / BillingReferenceLine (ABIE): Change definition to "Information about the reference to a Billing line". 6.30 [No change] 6.31 Common / LineItem (ABIE) / AccountingCost (BBIE): Change "code" in definition to "cost centre". 6.32 [No change] 6.33 Common / Dimension (ABIE) / Description (BBIE): Change definition to "A description of the measurement attribute." 6.34 Common / PaymentTerms (ABIE) / PrepaidPaymentReferenceID (BBIE): Change definition to "Identifies a reference to a prepaid payment." 6.35 Common / InvoiceLine (ABIE), CreditNoteLine (ABIE), DebitNoteLine (ABIE), ReminderLine (ABIE) / AccountingCost (BBIE): Change "code" in definition to "cost centre". 6.36 Common / CatalogueReference (ABIE) / ID (BBIE): Change definition to "Identifies a reference to a catalogue document." 6.37 Common / CertificateOfOriginApplication (ABIE) / CertificateOfOriginApplication (ABIE): Change definition to "Information about a Certificate of Origin application." 6.38 Common / QuotationLine (ABIE) / ID (BBIE): Change definition from 'Identifies the Quotation Line Item.' to 'Identifies the Quotation Line.' 6.39 Common / TradingTerms (ABIE) / ApplicableAddress (ASBIE): Change definition to "An association to the address at which the trading terms apply." 6.40 Common / SupplierParty (ABIE) / SellerContact (ASBIE): Change definition from 'An association to Seller.' to 'An association to Seller Contact.' 6.41 Common / Consignment (ABIE) / TransportContract (ASBIE): Change definition from 'An association to Transport Contact.' to 'An association to Transport Contract.' 6.42 Common / TransportEquipment (ABIE) / TransportEquipmentTypeCode: (BBIE) Change definition from 'Identifies the type of provider of the transport equipment.' to 'Identifies the type of the transport equipment.' 6.43 Common / (column W, rows 463-464): Remove the text "Transportation", leaving the cells blank. 6.44 Common / (column W, rows 865-866): Enter the text "Transporation". ================================================================== CATEGORY 7: MISCELLANEOUS 7.01 From Roberto Cisternino (ITLSC), private communication 2007.04.18: Module: Common (cell Q794) DictionaryEntryName: Receipt Line. Oversupply Quantity. Quantity Error: "Quanitity" should be "quantity" 7.02 From Roberto Cisternino (ITLSC), private communication 2007.04.18: Module: QualifiedDatatypes (cell Q189) DictionaryEntryName: Container Size Type_ Code. Type Error: "assoziated" should be "associated"
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]