[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [Elist Home]
Subject: [ubl-lcsc] Draft mapping for stylesheets
ken, As discussed I have attempted to map the 0p70 elements to your layout forms. Please find attached the initial results. Rather than fax the handwritten forms, I updated your HTML notes - i hope that is OK for you. some significant points are: 1. In building the Invoice and Despatch Advice, I revisited the Order form and updated some fields there as well. I also suspect that the documentation needs updated since the last 'booger' release :-[ 2. We appear to be missing (or at least ambiguosuly defined) some components of the Despatch Advice. In particular the Vessel/flight No - for which i could find not meaningful equivalent. [[NB This should be logged somewhere in the 'issues' list ]] 3. w.r.t. the Invoice. - the form has no places for allowances/charges and tax details. I suspect we should adopt common business practice and put these under the list of Items, using the Description and Amount columns. However this makes the mapping rules quite tricky - so i have ignored them in this first draft. Let me know if this is suitable and i will carry on with the other forms. -- regards tim mcgrath fremantle western australia 6160 phone: +618 93352228 fax: +618 93352142Title: Formatting specifications for UBL Order instances
Header information is associated with the form as a whole, not to the individual items of goods.
Path |
/?po:Order/?cat:SellerParty/?cat:PartyName/?cat:Name |
/?po:Order/?cat:SellerParty/?cat:Address/?cat:Street |
/?po:Order/?cat:SellerParty/?cat:Address/?cat:CityName |
/?po:Order/?cat:SellerParty/?cat:Address/?cat:CountrySub-EntityCode |
/?po:Order/?cat:SellerParty/?cat:Address/?cat:Country/?cat:Code |
This field is intended to show the name and address of the sender of goods or the originator of the documents, as the case may be.
Path |
/?po:Order/?cat:ID |
The reference number is a number or designation preferably common throughout each set of documents.
Path |
/?po:Order/?cat:OrderIssueDate |
If not otherwise specified, "date" means the date of issue of the document in which it appears.
Path |
/?po:Order/?cat:Quote/?cat:ID |
May reference any quote for the ordered goods
Path |
/?po:Order/?cat:Contract/?cat:ID |
May reference any contract that covers this order
At this time this field is not being filled in for the Order.
The field for the name and address of the consignee has been located in conformity with international postal specifications so as to allow the use of window envelopes.
The contents of this field is the same as the 2.8 Buyer field.
Path |
/?po:Order/?cat:BuyerParty/?cat:PartyName/?cat:Name |
/?po:Order/?cat:BuyerParty/?cat:Address/?cat:Street |
/?po:Order/?cat:BuyerParty/?cat:Address/?cat:CityName |
/?po:Order/?cat:BuyerParty/?cat:Address/?cat:CountrySub-EntityCode |
/?po:Order/?cat:BuyerParty/?cat:Address/?cat:Country/?cat:Code |
The field for the name and address to which documents are sent (buyer).
Path |
/?po:Order/?cat:AllowanceCharge/?cat:PaymentMeans/?cat:PayerFinancialAccount/?cat:FiBranch/?cat:FinancialInstitution/?cat:Name |
Path |
/?po:Order/?cat:OrderLine/?cat:Item/?cat:OriginCountry/?cat:Code |
Path |
/?po:Order/?cat:DestinationCountry/?cat:Code |
Transportation fields that are header-like and applicable to the entire order.
At this time this field is not being used for the Order.
At this time this field is not being used for the Order.
At this time this field is not being used for the Order.
At this time this field is not being used for the Order.
At this time this field is not being used for the Order.
At this time this field is not being used for the Order.
At this time this field is not being used for the Order.
Path |
/?po:Order/?cat:DeliveryTerms/?cat:ID |
Path |
/?po:Order/?cat:DeliveryTerms/?cat:RelevantLocation |
At this time this field is not being used for the Order.
Path |
/?po:Order/?cat:DeliveryTerms/?cat:AllowanceCharge/?cat:ID |
NB may be more than one of these
Path |
/?po:Order/?cat:AllowanceCharge/?cat:TypeCodeID |
NB may be more than one of these
Path |
/?po:Order/?cat:AllowanceCharge/?cat:CurrencyCode |
NB may be more than one of these
Line item information is associated with the individual items of the goods in the order.
At this time this field is not being used in the Order.
At this time this field is not being used in the Order.
At this time this field is not being used in the Order.
Path |
/?po:Order/?cat:OrderGrossWeightMeasure |
The gross weight of the order (not the shipment as we don't know it yet)
Path |
/?po:Order/?cat:OrderGrossVolumeMeasure |
The gross volume of the order (not the shipment as we don't know it yet)
Path |
/?po:Order/?cat:OrderLine/?cat:BuyersID |
This is the reference to the Order line.
Path |
/?po:Order/?cat:OrderLine/?cat:Item/?cat:Description |
One of these exists for each Line item.
Path |
/?po:Order/?cat:OrderLine/?cat:Quantity |
One of these exists for each line item.
Path |
/?po:Order/?cat:OrderLine/?cat:Item/?cat:BasePrice/?cat:PriceAmount |
One of these exists for each line item.
Path |
/?po:Order/?cat:OrderLine/?cat:LineExtensionAmount |
This is not calculated - it is transmitted
Summary information is associated with the form as a whole, not to the individual items of goods.
At this time this field is not being used in the Order
Path |
/?po:Order/?po:TransactionCurrencyCode |
Path |
/?po:Order/?po:LineExtensionTotalAmount |
Two data fields populate this one form field: the currency and the total amount.
The total amount is the sum of all of the 4.10 Amount fields. NB should not be calculated it is transmitted
At this time this field is not being filled in.
At this time this field is not being filled in.
This is not being filled in by the stylesheet and is left for a human to sign.
Formatting specifications for UBL Order instancesTitle: Formatting specifications for UBL Despatch Advice instances
G. Ken Holman
Copyright © 2003 OASIS
$Date: 2003/01/26 22:22:16 $(UTC)
Header information is associated with the form as a whole, not to the individual items of goods.
Path |
/?da:DespatchAdvice/?cat:SellerParty/?cat:PartyName/?cat:Name |
/?da:DespatchAdvice/?cat:SellerParty/?cat:Address/?cat:Street |
/?da:DespatchAdvice/?cat:SellerParty/?cat:Address/?cat:CityName |
/?da:DespatchAdvice/?cat:SellerParty/?cat:Address/?cat:CountrySub-EntityCode |
/?da:DespatchAdvice/?cat:SellerParty/?cat:Address/?cat:Country/?cat:Code |
This field is intended to show the name and address of the sender of goods or the originator of the documents, as the case may be.
Path |
/?da:DespatchAdvice/?cat:ReferencedOrder/?cat:SellersOrderID |
reference for the goods
Path |
/?da:DespatchAdvice/?cat:ReferencedOrder/?cat:BuyersOrderID |
reference for the goods
The field for the name and address of the consignee has been located in conformity with international postal specifications so as to allow the use of window envelopes.
The contents of this field is the same as the 2.8 Buyer field.
Path |
/?da:DespatchAdvice/?cat:BuyerParty/?cat:PartyName/?cat:Name |
/?da:DespatchAdvice/?cat:BuyerParty/?cat:Address/?cat:Street |
/?da:DespatchAdvice/?cat:BuyerParty/?cat:Address/?cat:CityName |
/?da:DespatchAdvice/?cat:BuyerParty/?cat:Address/?cat:CountrySub-EntityCode |
/?da:DespatchAdvice/?cat:BuyerParty/?cat:Address/?cat:Country/?cat:Code |
The field for the name and address to which documents are sent (buyer).
Transportation fields that are header-like and applicable to the entire order.
Path |
/?da:DespatchAdvice/?cat:ActualShipment/?cat:ShipmentStage/?cat:TransportModeCode |
NB may be more than one
Path |
/?da:DespatchAdvice/?cat:ActualShipment/?cat:ShipmentStage/?cat:TransitPeriod/?cat:StartDateTimeDate |
Use the earliest date (if more than one)
Path |
/?da:DespatchAdvice/?cat:ActualShipment/?cat:ShipmentStage/?cat:TransportMeansTypeCode |
NB may be more than one
Path |
/?da:DespatchAdvice/?cat:DeliveryRequirement/?cat:SendFromAddress/?cat:CityName |
/?da:DespatchAdvice/?cat:DeliveryRequirement/?cat:SendFromAddress/?cat:Country/?cat:Code |
Despatch is the required place
Currently ommitted from library (to be resolved)
Path |
/?da:DespatchAdvice/?cat:ActualShipment/?cat:DeliveryRequirement/?cat:SendFromAddress/?cat:CityName |
/?da:DespatchAdvice/?cat:ActualShipment/?cat:DeliveryRequirement/?cat:SendFromToAddress/?cat:Country/?cat:Code |
Loading is the actual place
Path |
/?da:DespatchAdvice/?cat:ActualShipment/?cat:DeliveryRequirement/?cat:DeliverToAddress/?cat:CityName |
/?da:DespatchAdvice/?cat:ActualShipment/?cat:DeliveryRequirement/?cat:DeliverToAddress/?cat:Country/?cat:Code |
Discharge is the actual place
Path |
/?da:DespatchAdvice/?cat:DeliveryRequirement/?cat:DeliverToAddress/?cat:CityName |
/?da:DespatchAdvice/?cat:DeliveryRequirement/?cat:DeliverToAddress/?cat:Country/?cat:Code |
Delivery is the required place
Goods information is associated with the individual items of the goods in the shipment
Path |
/?da:DespatchAdvice/?cat:DespatchedTransportHandlingUnit/?cat:ID |
This field is not clearly defined in the message
Path |
/?da:DespatchAdvice/?cat:ActualShipment/?cat:TransportEquipment/?cat:ID |
NB may be many of these
Path |
/?da:DespatchAdvice/?cat:DespatchedTransportHandlingUnit/?cat:TypeCode |
/?da:DespatchAdvice/?cat:ActualShipment/?cat:DeliveryRequirement/?cat:OrderLine/?cat:Quantity |
/?da:DespatchAdvice/?cat:ActualShipment/?cat:DeliveryRequirement/?cat:OrderLine/?cat:Item/?cat:Description |
Path |
/?da:DespatchAdvice/?cat:ActualShipment/?cat:GrossWeightMeasure |
The gross weight of the shipment
Summary information is associated with the form as a whole, not to the individual items of goods.
Path |
/?da:DespatchAdvice/?cat:Notes |
Path |
/?da:DespatchAdvice/?cat:FreightForwarderParty/?cat:PartyName/?cat:Name |
/?da:DespatchAdvice/?cat:FreightForwarderParty/?cat:Address/?cat:Street |
/?da:DespatchAdvice/?cat:FreightForwarderParty/?cat:Address/?cat:CityName |
/?da:DespatchAdvice/?cat:FreightForwarderParty/?cat:Address/?cat:CountrySub-EntityCode |
/?da:DespatchAdvice/?cat:FreightForwarderParty/?cat:Address/?cat:Country/?cat:Code |
Path |
/?da:DespatchAdvice/?cat:FreightForwarderParty/?cat:Contact/?cat:Name |
Formatting specifications for UBL Order instancesTitle: Formatting specifications for UBL Invoice instances
G. Ken Holman
Copyright © 2003 OASIS
$Date: 2003/01/26 22:22:16 $(UTC)
Header information is associated with the form as a whole, not to the individual items of goods.
Path |
/?po:Invoice/?cat:SellerParty/?cat:PartyName/?cat:Name |
/?po:Invoice/?cat:SellerParty/?cat:Address/?cat:Street |
/?po:Invoice/?cat:SellerParty/?cat:Address/?cat:CityName |
/?po:Invoice/?cat:SellerParty/?cat:Address/?cat:CountrySub-EntityCode |
/?po:Invoice/?cat:SellerParty/?cat:Address/?cat:Country/?cat:Code |
This field is intended to show the name and address of the sender of goods or the originator of the documents, as the case may be.
Path |
/?in:Invoice/?cat:ID |
The reference number is a number or designation preferably common throughout each set of documents.
Path |
/?in:Invoice/?cat:IssueDate |
If not otherwise specified, "date" means the date of issue of the document in which it appears.
Path |
/?in:Invoice/?cat:ReferencedOrder/?cat:SellersOrderID |
Path |
/?in:Invoice/?cat:ReferencedOrder/?cat:BuyersOrderID |
May reference any contract that covers this order
Path |
/?in:Invoice/?cat:Quote/?cat:ID |
/?in:Invoice/?cat:Contract/?cat:ID |
May reference any contract or quote that covers this invoice
The field for the name and address of the consignee has been located in conformity with international postal specifications so as to allow the use of window envelopes.
The contents of this field is the same as the 2.8 Buyer field.
Path |
/?in:Invoice/?cat:BuyerParty/?cat:PartyName/?cat:Name |
/?in:Invoice/?cat:BuyerParty/?cat:Address/?cat:Street |
/?in:Invoice/?cat:BuyerParty/?cat:Address/?cat:CityName |
/?in:Invoice/?cat:BuyerParty/?cat:Address/?cat:CountrySub-EntityCode |
/?in:Invoice/?cat:BuyerParty/?cat:Address/?cat:Country/?cat:Code |
The field for the name and address to which documents are sent (buyer).
Path |
/?in:Invoice/?cat:PaymentMeans/?cat:PayerFinancialAccount/?cat:FiBranch/?cat:FinancialInstitution/?cat:Name |
Path |
/?in:Invoice/?cat:InvoiceLine/?cat:Item/?cat:OriginCountry/?cat:Code |
Not used in the Invoice
Transportation fields that are header-like and not generally applicable to the invoice.
At this time this field is not being used for the Invoice.
At this time this field is not being used for the Invoice.
At this time this field is not being used for the Invoice.
At this time this field is not being used for the Invoice.
At this time this field is not being used for the Invoice.
At this time this field is not being used for the Invoice.
At this time this field is not being used for the Invoice.
At this time this field is not being used for the Invoice.
At this time this field is not being used for the Invoice.
At this time this field is not being used for the Invoice.
At this time this field is not being used for the Invoice.
Path |
/?in:Invoice/?cat:PaymentTerms/?cat:ID |
Path |
/?in:Invoice/?cat:InvoiceCurrencyCode |
Line item information is associated with the individual items of the goods in the invoice
At this time this field is not being used in the Invoice.
At this time this field is not being used in the Invoice.
At this time this field is not being used in the Invoice.
At this time this field is not being used in the Invoice.
At this time this field is not being used in the Invoice.
Path |
/?in:Invoice/?cat:InvoiceLine/?cat:ID |
This is the reference to the Invoice line.
Path |
/?in:Invoice/?cat:invoiceLine/?cat:Item/?cat:Description |
One of these exists for each Line item.
Path |
/?in:Invoice/?cat:InvoiceLine/?cat:InvoicedQuantity |
One of these exists for each line item.
Path |
/?in:Invoice/?cat:InvoiceLine/?cat:BasePrice/?cat:PriceAmount |
One of these exists for each line item.
Path |
/?in:Invoice/?cat:InvoiceLine/?cat:LineExtensionAmount |
This is not calculated - it is transmitted
Summary information is associated with the form as a whole, not to the individual items of goods.
Path |
/?in:Invoice/?cat:PaymentTerms/?cat:ID |
/?in:Invoice/?cat:PaymentTerms/?cat:Note |
/?in:Invoice/?cat:PaymentTerms/?cat:FromEventCode |
/?in:Invoice/?cat:PaymentTerms/?cat:SettlementDiscountRateNumeric |
/?in:Invoice/?cat:PaymentTerms/?cat:PenaltySurchargeRateNumeric |
/?in:Invoice/?cat:PaymentTerms/?cat:SettlementPeriod/?cat:StartDateTimeDate |
/?in:Invoice/?cat:PaymentTerms/?cat:SettlementPeriod/?cat:EndDateTimeDate |
/?in:Invoice/?cat:PaymentTerms/?cat:SettlementPeriod/?cat:DurationMeasure |
/?in:Invoice/?cat:PaymentTerms/?cat:SettlementPeriod/?cat:DescriptionCode |
/?in:Invoice/?cat:PaymentTerms/?cat:PenaltyPeriod/?cat:StartDateTimeDate |
/?in:Invoice/?cat:PaymentTerms/?cat:PenaltyPeriod/?cat:EndDateTimeDate |
/?in:Invoice/?cat:PaymentTerms/?cat:PenaltyPeriod/?cat:DurationMeasure |
/?in:Invoice/?cat:PaymentTerms/?cat:PenaltyPeriod/?cat:DescriptionCode |
Path |
/?in:Invoice/?in:InvoiceCurrencyCode |
Path |
/?in:Invoice/?cat:LegalTotals/?cat:ToBePaidTotalAmount |
Two data fields populate this one form field: the currency and the total amount.
NB should not be calculated it is transmitted
At this time this field is not being filled in.
At this time this field is not being filled in.
This is not being filled in by the stylesheet and is left for a human to sign.
Formatting specifications for UBL Order instances
G. Ken Holman
Copyright © 2003 OASIS
$Date: 2003/01/26 22:22:16 $(UTC)
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [Elist Home]
Powered by eList eXpress LLC