Het opstellen van transformatieregels voor de transformatie van berichten tussen verschillende standaarden mag niet worden onderschat. Het vereist grondige kennis van berichtstandaarden en van de betekenis van gegevens binnen een bedrijfsdomein. De Core Components Technical Specification (CCTS) en de Universal Data Element Framework (UDEF) streven naar een semantisch referentiekader voor de realisatie van informatieinteroperabiliteit. Wanneer beide concepten algemeen geaccepteerd en doorgevoerd worden dan zal transformatie veel eenvoudiger worden.
De Core Components Technical Specification kent aan elke Business Information Entity een unieke identificatie en Dictionary Entry Name (DEN) toe, net als de Universal Data Element Framework. Voorbeeld: De Invoice Issuer, de persoon of organisatie die de factuur uitgeeft, heeft als CCTS Unique ID de waarde UN01001476 en als DEN Invoice Issuer_ Party. Primary_ Identification. Identifier gekregen. De Universal Data Element Framework UDEF ID die daarmee overeenkomt is y.3_2.35.8 en de UDEF Name is Supplier.Enterprise_Purchaser.Assigned.Identifier.
Voor het verkrijgen van een beter beeld van de complexiteit van het transformeren van berichten en ter voorbereiding van het gebruik van transformatiegereedschappen ga ik de transformatieregels van de factuur uitwerken.
Het factuurproces richt zich op de uitwisseling van de factuur tussen leverancier en klanten voor geleverde goederen of diensten. Ter vereenvoudiging van het proces worden andere deelnemers buiten beschouwing gelaten. Zowel de klant als de leverancier kan in het proces meerdere rollen vervullen. Zo kan de klant acteren als klant (customer), besteller (buyer), ontvanger (consignee), invoicee en payer (betaler). De leverancier als leverancier (supplier), verkoper (seller), afzender (consignor), invoice issuer en payee.
Er zijn twee soorten factuurprocessen:
- de traditionele of door de leverancier geïnitieerde factuur waarbij de factuur door de leverancier wordt gegenereerd naar de klant
- de self-billing invoicing waarbij de factuur door de klant wordt gegenereerd naar de leverancier
Ik ga de mappingdefinitie uitwerken voor de traditionele factuur voor volgende internationale berichtstandaarden.
- Universal Business Language (UBL) Release 2.0
- Open Applications Group (OAGIS) Release 9.1
- UN/CEFACT Cross Industry Invoice (CII) Release 1.0
- EDIFACT Release 0.7B
- SAP IDOC Invoice02
Voor de berichtdefinitie ga ik uit van de UN/CEFACT Cross Industry Invoice (CII) specificatie die is opgesteld door de UN/CEFACT in samenwerking met verschillende industriesectoren.
Verder heb ik de UDEF ID en Name evenals de CCTS Unique ID en Name toegekend aan de elementen.
- UDEF ID
- UDEF Name
- CCTS ID
Invoice Number
Description = The unique number assigned by the issuer to identify an invoice.
CII = Billing_ Document. Issuer Assigned_ Identification. Identifier
UBL NAME = ID
UBL DEN = Invoice. Identifier
Svefaktura = likewise
OAGIS = Invoice.InvoiceHeader.DocumentID.ID
EDIFACT =
- BGM.C106.1004
IDOC =
- E2EDK02.E1EDK02.QUALF [Qualifier: 009 Invoice Number]
- E2EDK02.E1EDK02.BELNR
UDEF ID = bd.2_17.35.8 (proposed)
UDEF Name = Invoice.Document_Creditor.Assigned.Identifier (proposed)
CCTS ID = UN01001356
Copy Indicator
Description = The indicator that identifies whether or not the invoice is a copy of the original invoice.
CII = Billing_ Document. Copy. Indicator
UBL NAME = CopyIndicator
UBL DEN = Invoice. Copy_ Indicator. Indicator
Svefaktura = not included
OAGIS = ?
EDIFACT =
- BGM.1225 [Code: 9 Original]
IDOC = not available
UDEF ID = bd.2_49.7 (proposed)
UDEF NAME = Invoice.Document_Copy.Indicator (proposed)
CCTS ID = UN01001359
Invoice Global Unique Identifier
Description = The Global Unique Identifier (GUID) of the invoice.
CII = ?
UBL NAME = UUID
UBL DEN = Invoice. UUID. Identifier
Svefaktura = not included
OAGIS = ?
EDIFACT = ?
IDOC = ?
UDEF ID = bd.2_50.4
UDEF NAME = Invoice.Document_Language.Code
CCTS ID = ?
Invoice Issue Date
Description = The date when the invoice was issued.
CII = Billing_ Document. Issue. Date Time
UBL NAME = IssueDate
UBL DEN = Invoice. Issue Date. Date
Svefaktura = likewise
OAGIS = Invoice.InvoiceHeader.DocumentDateTime
EDIFACT =
- DTM.C507.2005 [Qualifier: 3 Invoice Document Issue Date Time]
- DTM.C507.2380
- DTM.C507.2379 [Qualifier: 102 CCYYMMDD]
IDOC =
- E2EDK03.E1EDK03.IDDAT [Code: 016 Invoice Date]
- E2EDK03.E1EDK03.DATUM
UDEF ID = bd.2_9.6
UDEF Name = Invoice.Document_Issued.Date
CCTS ID = UN01001357
Invoice Type Code
Description = The code specifying the invoice type (e.g. invoice, debit note, credit note).
CII = Billing_ Document. Type. Code
UBL NAME = InvoiceTypeCode
UBL DEN = Invoice. Invoice Type Code. Code
Svefaktura = likewise
OAGIS = ?
EDIFACT =
- BGM.C002.1001 [Code: 380 Commercial Invoice]
IDOC =
- E2EDK01005.E1EDK01.BSART [Value: INVO = debit, CRME = credit]
UDEF ID = bd.2_33.4
UDEF NAME = Invoice.Document_Type.Code
CCTS ID = UN01001358
Note
Description = Free-form text applying to the Invoice not contained in another structure.
CII = ?
UBL NAME = Note
UBL DEN = Invoice. Note. Text
Svefaktura = likewise
OAGIS = ?
EDIFACT = ?
IDOC = ?
UDEF ID = ?
UDEF NAME = ?
CCTS ID = ?
Tax Point Date
Description = The date of the Invoice, used to indicate the point at which tax becomes applicable.
CII = ?
UBL NAME = TaxPointDate
UBL DEN = Invoice. Tax Point Date. Date
Svefaktura = likewise
OAGIS = ?
EDIFACT = ?
IDOC = ?
UDEF ID = ?
UDEF NAME = ?
CCTS ID = ?
[Remarks = Validate whether this remains valid with the new proposed VAT directives !]
Invoice Language
Description = The code specifying the language of the free text of the invoice.
CII = Billing_ Document. Language. Identifier
UBL NAME = not included
UBL DEN = not included
Svefaktura = not included
OAGIS = ?
EDIFACT = ?
IDOC = ?
UDEF ID = bd.2_50.4
UDEF NAME = Invoice.Document_Language.Code
CCTS ID = UN01001360
Invoicing Currency
Description = The code identifier of the monetary unit used for amounts.
CII = Billing_ Document. Billing_ Currency. Code
UBL NAME = InvoiceCurrency
UBL DEN = Invoice. Document_ Currency Code. Code
Svefaktura = Invoice. Invoice Currency. Code
OAGIS = not available for complete document
EDIFACT =
- GRP07.CUX.C504.6347 [Qualifier: 2 Reference Currency]
- GRP07.CUX.C504.6345 [Use ISO 4217 three alpha code]
- GRP07.CUX.C504.6343 [Qaulifier: 4 Invoicing Currency]
IDOC =
- E2EDK01005.E1EDK01.CURCY
UDEF ID = not available for complete document
UDEF NAME = not available for complete document
CCTS ID = UN01001361
Price Currency
Description = The code identifier of the monetary unit used for the price.
CII = Billing_ Document. Price_ Currency. Code
UBL = Invoice. Pricing_ Currency Code. Code
OAGIS = not available for complete document
EDIFACT =
- GRP07.CUX.C504.6347 [Qualifier: 2 Reference Currency]
- GRP07.CUX.C504.6345 [Use ISO 4217 three alpha code]
- GRP07.CUX.C504.6343 [Qaulifier: 10 Pricing Currency]
IDOC = not available
UDEF ID = not available for complete document
UDEF NAME = not available for complete document
CCTS ID = UN01001362
Payment Currency
Description = The code identifier of the monetary unit used for the payment of the invoice.
CII = Billing_ Document. Payment_ Currency. Code
UBL = Invoice. Payment_ Currency Code. Code
OAGIS = not available for complete document
EDIFACT =
- GRP07.CUX.C504.6347 [Qualifier: 3 Target Currency]
- GRP07.CUX.C504.6345 [Use ISO 4217 three alpha code]
- GRP07.CUX.C504.6343 [Qaulifier: 11 Payment Currency]
IDOC = not available
UDEF ID = not available for complete document
UDEF NAME = not available for complete document
CCTS ID = UN01001363
Alternative Payment Currency
Description = The code identifier of the monetary unit used as an alternate currency for the payment of the invoice.
CII = Billing_ Document. Alternative Payment_ Currency. Code
UBL = Invoice. Payment Alternative_ Currency Code. Code
OAGIS = not available for complete document
EDIFACT = not available
IDOC = not available
UDEF ID = not available for complete document
UDEF NAME = not available for complete document
CCTS ID = UN01001364
Number of Invoice Lines
Description = The number of invoice lines.
CII = Billing_ Document. Line Count. Numeric
UBL = Invoice. Line Count. Numeric
OAGIS = not available
EDIFACT =
- GRP51.CNT.C270.6069 [Qualifier: 2 Number of lines]
- GRP51.CNT.C270.6066
IDOC =
- E2EDS01.E1EDS01.SUMID [Qualifier: 001 Number of items]
- E2EDS01.E1EDS01.SUMME
UDEF ID = to be determined
UDEF NAME = to be determined
CCTS ID = UN01001365
Total Invoice Additional Charge Amount
Description = The sum of all charges at the invoice header level before tax or fee.
CII =
UBL =
OAGIS =
EDIFACT =
IDOC =
UDEF ID = to be determined
UDEF NAME = to be determined
CCTS ID =
Total Invoice Line Amount
Description = The sum of all invoice lines amounts, including all allowances and charges related to the invoice line before tax or fee.
CII = Billing_ Monetary Summation. Line Total. Amount
UBL = Invoice. Legal_ Monetary Monetary Total. Line Extension Amount. Amount
OAGIS = Invoice. InvoiceHeader. ExtendedAmount
EDIFACT =
- GRP52.MOA.C516.5025 [Qualifier: 340 Original Total Net Invoice Value]
- GRP52.MOA.C516.5004
IDOC =
UDEF ID = to be determined
UDEF NAME = to be determined
CCTS ID = UN01001367
Invoicing Period Start Date
Description = The date, time, date time or other date time value for the start of this billing period.
CII = Billing_ Period. Start. Date Time
UBL =
* Invoice. Invoice_ Period. Start Date. Date
* Invoice. Invoice_ Period. Start Date. Time
OAGIS = not available
EDIFACT =
- DTM.C507.2005 [Qualifier: 194 Start Date / Time Period]
- DTM.C507.2380
- DTM.C507.2379 [Qualifier: 102 CCYYMMDD]
IDOC =
- E2EDK03.E1EDK03.IDDAT [Code: 019 Start of validity]
- E2EDK03.E1EDK03.DATUM
UDEF ID =
* bd.2_18.6
* bd.2_1.15
UDEF NAME =
* Invoice.Document_Start.Date
* Invoice.Document_Start.Time
CCTS ID = UN01001386
Invoicing Period End Date
Description = The date, time, date time or other date time value for the end of this billing period.
CII = Billing_ Period. End. Date Time
UBL =
* Invoice. Invoice_ Period. End Date. Date
* Invoice. Invoice_ Period. End Date. Time
OAGIS = not available
EDIFACT =
- DTM.C507.2005 [Qualifier: 206 End Date / Time Period]
- DTM.C507.2380
- DTM.C507.2379 [Qualifier: 102 CCYYMMDD]
IDOC =
- E2EDK03.E1EDK03.IDDAT [Code: 020 End of validity]
- E2EDK03.E1EDK03.DATUM
UDEF ID =
* to be determined
* bd.2_2.15
UDEF NAME =
* to be determined
* Invoice.Document_End.Time
CCTS ID = UN01001387
Invoice Issuer Identification Code
Description = The invoice issuer is the person or organization making the invoice, claiming payment for the goods or services rendered.
CII = Invoice Issuer_ Party. Primary_ Identification. Identifier
UBL = Invoice. Accounting_ Supplier Party. Customer Assigned_ Account Identifier. Identifier
OAGIS = Invoice. InvoiceHeader.SupplierParty.PartyIDs.ID
<em>[Remark: OAGIS InvoicerParty is a better match but not provided]</em>
EDIFACT =
- GRP02.NAD.3035 [Qualifier: II Invoice Issuer]
- GRP02.NAD.C082.3039
IDOC =
- E2EDKA1003.E1EDKA1.PARVW [Qualifier: RS Invoicing Party - Invoice From]
- E2EDKA1003.E1EDKA1.PARTN
UDEF ID = y.3_2.35.8
UDEF NAME = Supplier.Enterprise_Purchaser.Assigned.Identifier
CCTS ID = UN01001476
Invoice Issuer Name
Description = The name, expressed as text, for this invoice issuer party.
CII = Invoice Issuer_ Party. Name. Text
UBL = Invoice. Accounting_ Supplier Party. Party Name
EDIFACT =
- GRP02.NAD.3035 [Qualifier: II Invoice Issuer]
- GRP02.NAD.C080.3036
IDOC =
- E2EDKA1003.E1EDKA1.PARVW [Qualifier: RS Invoicing Party - Invoice From]
- E2EDKA1003.E1EDKA1.NAME1
UDEF ID =
UDEF NAME =
CCTS ID = UN01001479
Invoice Issuer VAT ID
Description = vat-nbr / registrationnbr selling company
CII = Invoice Issuer_ Party. Tax_ Identification. Identifier
UBL = Invoice. Accounting_ Supplier Party. Party Tax Scheme. Company Identifier. Identifier
EDIFACT =
- GRP03.RFF.C506.1153 [Reference Qualifier: VA VAT Registration Number]
- GRP03.RFF.C506.1154
IDOC =
- E2EDK01005.E1EDK01.EIGENUINR
UDEF ID =
UDEF NAME =
CCTS ID = UN01001478
Chamber of Commerce Number
Description = Identifies a company as registered with the company registration scheme.
CII =
UBL = Invoice. Accounting_ Supplier Party. Party Legal Entity. Company Identifier. Identifier
EDIFACT =
- GRP03.RFF.C506.1153 [Reference CodeQualifier AHO Chamber of Commerce registration number]
- GRP03.RFF.C506.1154
IDOC =
- E2EDKA1003.E1EDKA1.PARVW [Qualifier: RS Invoicing Party - Invoice From]
- E2EDKA1003.E1EDKA1.NAME4
UDEF ID =
UDEF NAME =
CCTS ID =
Invoicee Identification Code
Description = The primary identifier of this invoicee party.
CII = Invoicee_ Party. Primary_ Identification. Identifier
UBL = Invoice. Accounting_ Customer Party. Customer Assigned_ Account Identifier. Identifier
EDIFACT =
- GRP02.NAD.3035 [Qualifier: IV Invoicee]
- GRP02.NAD.C082.3039
IDOC =
- E2EDKA1003.E1EDKA1.PARVW [Qualifier: RE Bill To]
- E2EDKA1003.E1EDKA1.PARTN
UDEF ID =
UDEF NAME =
CCTS ID =
Invoicee Name
Description = An association to Party Name.
CII = Invoicee_ Party. Name. Text
UBL = Invoice. Accounting_ Customer Party. Party. Party Name
EDIFACT =
- GRP02.NAD.3035 [Qualifier: IV Invoicee]
- GRP02.NAD.C080.3036
IDOC =
- E2EDKA1003.E1EDKA1.PARVW [Qualifier: RE Bill To]
- E2EDKA1003.E1EDKA1.NAME1
UDEF ID =
UDEF NAME =
CCTS ID =
Tags: CCTS, EDIFACT, electronic data interchange, HR-XML, UBL, UDEF
[Last update: 26-11-2011]