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

 


Help: OASIS Mailing Lists Help | MarkMail Help

ubl-lcsc message

[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 93352142 


Title: Formatting specifications for UBL Order instances

Formatting specifications for UBL Order instances

2: Party information

Header information is associated with the form as a whole, not to the individual items of goods.

2.1: Seller

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.

2.2: Purchase order number

Path
/?po:Order/?cat:ID

The reference number is a number or designation preferably common throughout each set of documents.

2.3: Date

Path
/?po:Order/?cat:OrderIssueDate

If not otherwise specified, "date" means the date of issue of the document in which it appears.

2.4: Seller's reference

Path
/?po:Order/?cat:Quote/?cat:ID

May reference any quote for the ordered goods

2.5: Buyer's reference

Path
/?po:Order/?cat:Contract/?cat:ID

May reference any contract that covers this order

2.6: Other reference

At this time this field is not being filled in for the Order.

2.7: Consignee

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.

2.8: Buyer

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).

2.9: Buyer's bank

Path
/?po:Order/?cat:AllowanceCharge/?cat:PaymentMeans/?cat:PayerFinancialAccount/?cat:FiBranch/?cat:FinancialInstitution/?cat:Name

2.10: Country of origin

Path
/?po:Order/?cat:OrderLine/?cat:Item/?cat:OriginCountry/?cat:Code
NB there may be mroe than one of these

2.11: Country of destination

Path
/?po:Order/?cat:DestinationCountry/?cat:Code

3: Delivery and transport

Transportation fields that are header-like and applicable to the entire order.

3.1: Mode of transport

At this time this field is not being used for the Order.

3.2: Date of despatch

At this time this field is not being used for the Order.

3.3: Means of transport

At this time this field is not being used for the Order.

3.4: Place of despatch

At this time this field is not being used for the Order.

3.5: Place of loading

At this time this field is not being used for the Order.

3.6: Place of discharge

At this time this field is not being used for the Order.

3.7: Place of delivery

At this time this field is not being used for the Order.

3.8: Terms of delivery

Path
/?po:Order/?cat:DeliveryTerms/?cat:ID

3.9: Location

Path
/?po:Order/?cat:DeliveryTerms/?cat:RelevantLocation

3.10: Time of delivery

At this time this field is not being used for the Order.

3.11: Transport Charges

Path
/?po:Order/?cat:DeliveryTerms/?cat:AllowanceCharge/?cat:ID

NB may be more than one of these

3.12: Terms of payment

Path
/?po:Order/?cat:AllowanceCharge/?cat:TypeCodeID

NB may be more than one of these

3.13: Currency of payment

Path
/?po:Order/?cat:AllowanceCharge/?cat:CurrencyCode

NB may be more than one of these

4: Line item information

Line item information is associated with the individual items of the goods in the order.

4.1: Shipping marks

At this time this field is not being used in the Order.

4.2: Container Nr.

At this time this field is not being used in the Order.

4.3: Number and kind of packages; description of goods

At this time this field is not being used in the Order.

4.4: Total gross weight (Kg)

Path
/?po:Order/?cat:OrderGrossWeightMeasure

The gross weight of the order (not the shipment as we don't know it yet)

4.5: Cube m3

Path
/?po:Order/?cat:OrderGrossVolumeMeasure

The gross volume of the order (not the shipment as we don't know it yet)

4.6: Item

Path
/?po:Order/?cat:OrderLine/?cat:BuyersID

This is the reference to the Order line.

4.7: Description

Path
/?po:Order/?cat:OrderLine/?cat:Item/?cat:Description

One of these exists for each Line item.

4.8: Quantity U/M

Path
/?po:Order/?cat:OrderLine/?cat:Quantity

One of these exists for each line item.

4.9: Unit price

Path
/?po:Order/?cat:OrderLine/?cat:Item/?cat:BasePrice/?cat:PriceAmount

One of these exists for each line item.

4.10: Amount

Path
/?po:Order/?cat:OrderLine/?cat:LineExtensionAmount

This is not calculated - it is transmitted

5: Summary information

Summary information is associated with the form as a whole, not to the individual items of goods.

5.1: Invoice clauses

At this time this field is not being used in the Order

5.2: Total amount

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

5.3: Name of signatory

At this time this field is not being filled in.

5.4: Place of issue

At this time this field is not being filled in.

5.5: Signature

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)
Title: Formatting specifications for UBL Despatch Advice instances

Formatting specifications for UBL Despatch Advice instances

2: Party information

Header information is associated with the form as a whole, not to the individual items of goods.

2.1: Seller

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.

2.4: Seller's/consignor's reference

Path
/?da:DespatchAdvice/?cat:ReferencedOrder/?cat:SellersOrderID

reference for the goods

2.5: Buyer's reference

Path
/?da:DespatchAdvice/?cat:ReferencedOrder/?cat:BuyersOrderID

reference for the goods

2.7: Consignee

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.

2.8: Buyer

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).

3: Delivery and transport

Transportation fields that are header-like and applicable to the entire order.

3.1: Mode of transport

Path
/?da:DespatchAdvice/?cat:ActualShipment/?cat:ShipmentStage/?cat:TransportModeCode

NB may be more than one

3.2: Date of despatch

Path
/?da:DespatchAdvice/?cat:ActualShipment/?cat:ShipmentStage/?cat:TransitPeriod/?cat:StartDateTimeDate

Use the earliest date (if more than one)

3.3: Means of transport

Path
/?da:DespatchAdvice/?cat:ActualShipment/?cat:ShipmentStage/?cat:TransportMeansTypeCode

NB may be more than one

3.4: Place of despatch

Path
/?da:DespatchAdvice/?cat:DeliveryRequirement/?cat:SendFromAddress/?cat:CityName
/?da:DespatchAdvice/?cat:DeliveryRequirement/?cat:SendFromAddress/?cat:Country/?cat:Code

Despatch is the required place

3.5: Vessel/flight No.

Currently ommitted from library (to be resolved)

3.6: Place of loading

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

3.6: Place of discharge

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

3.7: Place of delivery

Path
/?da:DespatchAdvice/?cat:DeliveryRequirement/?cat:DeliverToAddress/?cat:CityName
/?da:DespatchAdvice/?cat:DeliveryRequirement/?cat:DeliverToAddress/?cat:Country/?cat:Code

Delivery is the required place

4: goods information

Goods information is associated with the individual items of the goods in the shipment

4.1: Shipping marks

Path
/?da:DespatchAdvice/?cat:DespatchedTransportHandlingUnit/?cat:ID

This field is not clearly defined in the message

4.2: Container Nr.

Path
/?da:DespatchAdvice/?cat:ActualShipment/?cat:TransportEquipment/?cat:ID

NB may be many of these

4.3: Number and kind of packages; description of goods

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

4.4: Total gross weight (Kg)

Path
/?da:DespatchAdvice/?cat:ActualShipment/?cat:GrossWeightMeasure

The gross weight of the shipment

5: Summary information

Summary information is associated with the form as a whole, not to the individual items of goods.

5.1: Documentary instructions

Path
/?da:DespatchAdvice/?cat:Notes

5.2: Additional distribution

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

5.3: Name of contact

Path
/?da:DespatchAdvice/?cat:FreightForwarderParty/?cat:Contact/?cat:Name


Formatting specifications for UBL Order instances
G. Ken Holman
Copyright © 2003 OASIS
$Date: 2003/01/26 22:22:16 $(UTC)
Title: Formatting specifications for UBL Invoice instances

Formatting specifications for UBL Invoice instances

2: Party information

Header information is associated with the form as a whole, not to the individual items of goods.

2.1: Seller

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.

2.2: Invoice number

Path
/?in:Invoice/?cat:ID

The reference number is a number or designation preferably common throughout each set of documents.

2.3: Invoice date

Path
/?in:Invoice/?cat:IssueDate

If not otherwise specified, "date" means the date of issue of the document in which it appears.

2.4: Seller's reference

Path
/?in:Invoice/?cat:ReferencedOrder/?cat:SellersOrderID

2.5: Buyer's reference

Path
/?in:Invoice/?cat:ReferencedOrder/?cat:BuyersOrderID

May reference any contract that covers this order

2.6: Other reference

Path
/?in:Invoice/?cat:Quote/?cat:ID
/?in:Invoice/?cat:Contract/?cat:ID

May reference any contract or quote that covers this invoice

2.7: Consignee

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.

2.8: Buyer

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).

2.9: Buyer's bank

Path
/?in:Invoice/?cat:PaymentMeans/?cat:PayerFinancialAccount/?cat:FiBranch/?cat:FinancialInstitution/?cat:Name

2.10: Country of origin

Path
/?in:Invoice/?cat:InvoiceLine/?cat:Item/?cat:OriginCountry/?cat:Code
NB there may be more than one of these

2.11: Country of destination

Not used in the Invoice

3: Delivery and transport

Transportation fields that are header-like and not generally applicable to the invoice.

3.1: Mode of transport

At this time this field is not being used for the Invoice.

3.2: Date of despatch

At this time this field is not being used for the Invoice.

3.3: Means of transport

At this time this field is not being used for the Invoice.

3.4: Place of despatch

At this time this field is not being used for the Invoice.

3.5: Place of loading

At this time this field is not being used for the Invoice.

3.6: Place of discharge

At this time this field is not being used for the Invoice.

3.7: Place of delivery

At this time this field is not being used for the Invoice.

3.8: Terms of delivery

At this time this field is not being used for the Invoice.

3.9: Location

At this time this field is not being used for the Invoice.

3.10: Time of delivery

At this time this field is not being used for the Invoice.

3.11: Transport Charges

At this time this field is not being used for the Invoice.

3.12: Terms of payment

Path
/?in:Invoice/?cat:PaymentTerms/?cat:ID

3.13: Currency of payment

Path
/?in:Invoice/?cat:InvoiceCurrencyCode

4: Line item information

Line item information is associated with the individual items of the goods in the invoice

4.1: Shipping marks

At this time this field is not being used in the Invoice.

4.2: Container Nr.

At this time this field is not being used in the Invoice.

4.3: Number and kind of packages; description of goods

At this time this field is not being used in the Invoice.

4.4: Total gross weight (Kg)

At this time this field is not being used in the Invoice.

4.5: Cube m3

At this time this field is not being used in the Invoice.

4.6: Item

Path
/?in:Invoice/?cat:InvoiceLine/?cat:ID

This is the reference to the Invoice line.

4.7: Description

Path
/?in:Invoice/?cat:invoiceLine/?cat:Item/?cat:Description

One of these exists for each Line item.

4.8: Quantity U/M

Path
/?in:Invoice/?cat:InvoiceLine/?cat:InvoicedQuantity

One of these exists for each line item.

4.9: Unit price

Path
/?in:Invoice/?cat:InvoiceLine/?cat:BasePrice/?cat:PriceAmount

One of these exists for each line item.

4.10: Amount

Path
/?in:Invoice/?cat:InvoiceLine/?cat:LineExtensionAmount

This is not calculated - it is transmitted

5: Summary information

Summary information is associated with the form as a whole, not to the individual items of goods.

5.1: Invoice clauses

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

5.2: Total amount

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

5.3: Name of signatory

At this time this field is not being filled in.

5.4: Place of issue

At this time this field is not being filled in.

5.5: Signature

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