Re: [ubl] More missing information in UBL 2.1 PRD2 spreadsheets

["G. Ken Holman" <gkholman@CraneSoftwrights.com>]

I've updated the model checker used in production to report the empty 
or absent definitions and the resulting list matches my report from 
my schema generation environment.

I've also made note of a cosmetic issue, that being the presence of 
newline characters in definitions, typically at the end of the 
definition (we appear to two definitions that are comprised of two 
paragraphs).  While only cosmetic, there are some ramifications of 
the newlines in reports and in unnecessarily increasing the vertical 
dimension of spreadsheet rows.  I suggest we go through the model and 
clean up the use of these newline characters.

I don't know if my post of November 17 caught the attention of 
PSC/TSC members maintaining the issues list.  Please note that the 
absent definitions are, in my opinion, important enough to be 
considered issues to be fixed.

. . . . . . . . . Ken

p.s. note the serendipitous discovery of important spelling mistakes 
to be fixed ... does anyone on the list know where one can obtain an 
XML or text file of Oxford English words with which I could attempt 
to do a rudimentary spell check on the definitions?

Definitions with new lines: 22
"Bill Of Lading. Details": "The Bill of Lading is issued by the party 
who acts as an agent for the carrier or other agents to the party who 
gives instructions for the transportation services (shipper, 
consignor, etc.) stating the details of the transportation, charges, 
and terms and conditions under which the transportation service is 
provided. The party issuing this document does not necessarily 
provide the physical transportation service. It corresponds to the 
information on the Forwarding Instruction. It is used for any mode of 
transport.

A Bill of Lading can serve as a contractual document between the 
parties for the transportation service. The document evidences a 
contract of carriage by sea and the acceptance of responsibility for 
the goods by the carrier, and by which the carrier undertakes to 
deliver the goods against surrender of the document. A provision in 
the document that the goods are to be delivered to the order of a 
named person, or to order, or to bearer, constitutes such an undertaking."
"Consumption Average. Details": "The Average price included VAT.
This clas are suplementary utility Statements, that depending of type 
of Utility and scenario, needs to be present on a UtilityStatement, 
in order to meet the legal requirement and/or to give the Buyer 
proper informations. Note that these suplementary Statements are 
related to one common ConsumptionPoint as specified in 
UtilityChargeableConsumption/ConsumptionPoint above. "
"Consumption. Energy Water Supply": "An association to the total 
amount payable on the UtilityStatement including Allowances, Charges and Taxes.
This class is mandatory and sums the totals on 
UtilityChargeableConsumption level (for each ConsumptionPoint). This 
class must not be confused with the UBL MonetaryTotal class."
"Consumption. Legal_ Monetary Total. Monetary Total": "An association 
to the total amount payable on the UtilityStatement including 
Allowances, Charges and Taxes.
This class is mandatory and sums the totals on 
UtilityChargeableConsumption level (for each ConsumptionPoint). This 
class must not be confused with the UBL MonetaryTotal class."
"Consumption. Telecommunications Supply": "An association to the 
total amount payable on the UtilityStatement including Allowances, 
Charges and Taxes.
This class is mandatory and sums the totals on 
UtilityChargeableConsumption level (for each ConsumptionPoint). This 
class must not be confused with the UBL MonetaryTotal class."
"Contract. Contractual_ Delivery. Delivery": "An association to 
Delivery. Describes the delivery of the services required to book the 
services specified in the contract.
"
"Energy Water Supply. Consumption Average": "The Average price included VAT.
"
"Item Management Profile. Frozen Period Days. Numeric": "The number 
of days in the future that an Order Forecast quantity automatically
becomes a confirmed order for a product"
"Item Management Profile. Minimum_ Inventory Quantity. Quantity": "An 
indicator at which point a replenishment order should be placed to avoid
depleting the safety stock."
"Item Management Profile. Target_ Inventory Quantity. Quantity": "The 
target inventory expressed by a qualifier such as turns, total dollar value or
total quantity"
"Item Property Range. Maximum_ Value. Text": "The maximum value in a 
range of property.

"
"Item Property Range. Minimum_ Value. Text": "The minimum value in a 
range of property.
"
"Party Legal Entity. Company Legal Form Code. Code": "The company 
legal status, expressed as a code.
"
"Party Legal Entity. Company Liquidation Status Code. Code": "The 
company liquidation status, expressed as a code.
"
"Party Legal Entity. Corporate Stock_ Amount. Amount": "The Capital 
Stock (equities) of a corporate.
"
"Party Legal Entity. Fully Paid Shares Indicator. Indicator": "An 
indicator to state that all shares of the corporate stock have been 
paid by shareholders.
"
"Party Legal Entity. Sole Proprietorship Indicator. Indicator": "An 
indicator to state if the company is owned and controlled by one 
person (true) or more (false)
"
"Product Activity. Details": "Product activity represents movement of 
a product through a location in terms of the
base unit of measure for the item."
"Promotional Specification. Specification Identifier. Identifier": "A 
unique identification number to a back system that defines a set of 
item location
combinations that share a set of promotion tactics"
"Shareholder Party. Partecipation. Percent": "Percentage.
"
"Shareholder Party. Party": "An association to a shareholder.
"
"Utility Statement. Details": "The Utility Statement contains 
information on the consumption of services provided by utility 
suppliers to private and public customers. These utilities include 
electricity, gas, water and telephony services.
The Utility Statement is therefore a supplement to an Invoice or CreditNote."


Empty or absent definitions: 17
"Consumption. Details"
"Delivery Terms. Amount"
"Despatch. Guaranteed_ Despatch Date. Date"
"Despatch. Guaranteed_ Despatch Time. Time"
"Despatch. Instructions. Text"
"Document Reference. Result Of Verification"
"Energy Water Supply. Details"
"External Reference. Hash Algorithm Method. Text"
"Goods Item. Chargeable_ Quantity. Quantity"
"Goods Item. Returnable_ Quantity. Quantity"
"Monetary Total. Payable_ Alternative Amount. Amount"
"Payment Terms. Exchange Rate"
"Renewal. Details"
"Request For Quotation Line. Security Classification Code. Code"
"Service Provider Party. Service Type Code. Code"
"Service Provider Party. Service Type. Text"
"Transport Event. Location"





At 2011-11-17 11:30 -0500, I wrote:
> Hi, folks,
>
> In my NDR work today I noted the following problems with the 
> spreadsheets.  These problems were not reported in an earlier 
> version of my model checker because I didn't think to check for 
> absent definitions:
>
> UBL-CommonLibrary-2.1 Row 371 (Consumption. Details):
>  Missing the definition
> UBL-CommonLibrary-2.1 Row 591 (Delivery Terms. Amount):
>  Missing the definition
> UBL-CommonLibrary-2.1 Row 610 (Despatch. Guaranteed_ Despatch Date. Date):
>  Missing the definition
> UBL-CommonLibrary-2.1 Row 611 (Despatch. Guaranteed_ Despatch Time. Time):
>  Missing the definition
> UBL-CommonLibrary-2.1 Row 613 (Despatch. Instructions. Text):
>  Missing the definition
> UBL-CommonLibrary-2.1 Row 664 (Document Reference. Result Of Verification):
>  Missing the definition
> UBL-CommonLibrary-2.1 Row 698 (Energy Water Supply. Details):
>  Missing the definition
> UBL-CommonLibrary-2.1 Row 792 (External Reference. Hash Algorithm 
> Method. Text):
>  Missing the definition
> UBL-CommonLibrary-2.1 Row 883 (Goods Item. Chargeable_ Quantity. Quantity):
>  Missing the definition
> UBL-CommonLibrary-2.1 Row 884 (Goods Item. Returnable_ Quantity. Quantity):
>  Missing the definition
> UBL-CommonLibrary-2.1 Row 1191 (Monetary Total. Payable_ Alternative 
> Amount. Amount):
>  Missing the definition
> UBL-CommonLibrary-2.1 Row 1343 (Payment Terms. Exchange Rate):
>  Missing the definition
> UBL-CommonLibrary-2.1 Row 1554 (Renewal. Details):
>  Missing the definition
> UBL-CommonLibrary-2.1 Row 1563 (Request For Quotation Line. Security 
> Classification Code. Code):
>  Missing the definition
> UBL-CommonLibrary-2.1 Row 1628 (Service Provider Party. Service Type 
> Code. Code):
>  Missing the definition
> UBL-CommonLibrary-2.1 Row 1629 (Service Provider Party. Service Type. Text):
>  Missing the definition
> UBL-CommonLibrary-2.1 Row 2100 (Transport Event. Location):
>  Missing the definition
>
> I'm assuming the definition should be mandatory, regardless of how 
> obvious the element name might be, though I don't believe this is 
> mandated in the current UBL NDR.  I will be pushing for it to be 
> mandatory in the next NDR.
>
> I'm in the process of updating my model checker to include this 
> check, but thought it best to bring this immediately to the 
> attention of PSC and TSC members so they can include these problems 
> in their respective issues lists.
>
> I'm not nearly done my NDR work, so if I find any more problems with 
> the existing spreadsheets, I'll post them to the list.
>
> . . . . . . . . . . . Ken


--
Contact us for world-wide XML consulting and instructor-led training
Free 5-hour video lecture: XSLT/XPath 1.0 & 2.0 http://ude.my/t37DVX
Crane Softwrights Ltd.            http://www.CraneSoftwrights.com/o/
G. Ken Holman                   mailto:gkholman@CraneSoftwrights.com
Google+ profile: https://plus.google.com/116832879756988317389/about
Legal business disclaimers:    http://www.CraneSoftwrights.com/legal