jagomart
digital resources
picture1_Excel Sheet Download 31203 | Specifikation For Edi Fakturaformat Peppol Bis Billing 0 Xlsx


 240x       Filetype XLSX       File size 0.18 MB       Source: www.postnord.se


File: Excel Sheet Download 31203 | Specifikation For Edi Fakturaformat Peppol Bis Billing 0 Xlsx
sheet 1 version version history the original order of lines from xml source perspective version date author version tracking of fields description 100 11192018 teodor berglund postnord aligned with postnord ...

icon picture XLSX Filetype Excel XLSX | Posted on 08 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Version
VERSION HISTORY


The original order of lines from XML source perspective. Version Date Author Version tracking of fields. Description
1.00 11/19/2018 Teodor Berglund, Postnord Aligned with Postnord internal mapping specification.
1.01 11/23/2018 Teodor Berglund, Postnord Aligned with Postnord internal mapping specification.
1.02 2/4/2019 Teodor Berglund, Postnord Aligned with Postnord internal mapping specification.
1.03 2/11/2019 Teodor Berglund, Postnord Aligned with Postnord internal mapping specification.
1.04 2/13/2019 Teodor Berglund, Postnord Aligned with Postnord internal mapping specification.
1.05 2/28/2019 Teodor Berglund, Postnord Aligned with Postnord internal mapping specification.
1.06 5/2/2019 Teodor Berglund, Postnord Aligned with Postnord internal mapping specification.

Sheet 2: Read Me First
READ ME FIRST - EXPLANATION OF THE COLUMNS IN MAPPING SPECIFICATION

Group Column Version tracking of fields. Description
INPUT DESCRIPTION Card. Cardinality:
How many times can the element occurr without attribute.
How many times can the element occurr with the specified attribute value.
INPUT DESCRIPTION Description Field description
INPUT DESCRIPTION SAP Source Description of where the data is fetched from to understand what kind of data that can affect the field.
Each type of source is classified in four categories below:
TD: Transaction Data
CD: Customizing Data
MD: Master Data (Updated Master Data will affect the value)
MD->TD: Master Data affects Transaction Data (Updated Master Data will affect the transaction data and the value)
INPUT DESCRIPTION Comment Comment on how the field is used
INPUT DESCRIPTION Example data in Example of data in the input file from SAP, not always the same as the data in the output file because logic is applied to some input data.
Sometimes the example data have multiple examples with [OR] separator in between.
Sometimes the example data is blank, then check the comment column for an explanation.
OUTPUT FILE XML Element The output file xml element full or partial path.
When Attribute is not provided, the input data is mapped directly to this XML element value.
OUTPUT FILE Attribute When attribute is specified, the input data is mapped towards the attribute value.
When no attribute is specified, the input data is mapped towards the xml element value.
OUTPUT FILE Example data Example of data in the output file after logic has been applied.
Sometimes the example data have multiple examples with [OR] separator in between.
Sometimes the example data is blank, then check the comment column for an explanation.

Sheet 3: Mapping Specification
INPUT DESCRIPTION



OUTPUT FILE (PEPPOL BIS Billing 3.0)

Card. Description SAP Source Comment Example data in XML Element Attribute Example data
1..1 Document ID Invoice number (TD)
9000001802 ID
9000001802
1..1 Issue Date Payer invoice freq (MD->TD)
2017-09-28 IssueDate
2017-09-28
1..1 Due Date Payer payment terms (MD->TD)
2017-10-28 DueDate
2017-10-28
1..1 Invoice Type Code New Print Solution (CD) Blank when credit invoice 380 [OR] 381 InvoiceTypeCode
380
1..1 Invoice Type Code New Print Solution (CD) Blank when credit invoice 380 [OR] 381 CreditNoteTypeCode
381
0..1 Invoice Header Note Invoice (TD)

Note

1..1 Document currency code Sold-to curr (MD->TD)
EUR DocumentCurrencyCode
EUR
0..1 Company code currency Company curr (CD)
SEK TaxCurrencyCode
SEK
0..1 Requisitionist document reference Invoice payer (MD) Depends on conversion Payer reference BuyerReference
Payer reference
0..1 TABLE_REFERENCE_DOCUMENT_CREDIT New Print Solution (CD) Table of credited invoices
aggregated on header level




1..n Table Reference Document Credit Line New Print Solution (CD) Line of credited invoice



1..1 Credited invoice Invoice (TD) Only for credit invoices 9000003665 BillingReference.InvoiceDocumentReference.ID
9000003665
0..1 Additional document reference IT Invoice payer (MD) Depends on conversion Payer number [OR] blank AdditionalDocumentReference.ID
Payer number [OR] blank
0..1 Additional document reference IT Invoice payer (MD)
Payer number [OR] blank AdditionalDocumentReference.ID schemeID IT
1..1 Sender EDI Endpoint id New Print Solution (CD)
7321540000019 AccountingSupplierParty.Party.EndpointID
7321540000019
1..1 Sender EDI Endpoint id schemeID ISO New Print Solution (CD)
0088 AccountingSupplierParty.Party.EndpointID schemeID 0088
1..1 Sender EDI id New Print Solution (CD)
7321540000019 AccountingSupplierParty.Party.PartyIdentification.ID
7321540000019
0..1 Sender EDI id schemeID ISO New Print Solution (CD)
0088 AccountingSupplierParty.Party.PartyIdentification.ID schemeID 0088
0..1 Sender Name 1 Invoice company (CD)
PostNord Sverige AB AccountingSupplierParty.Party.PartyName.Name
PostNord Sverige AB
0..1 Sender Name 2 Invoice company (CD)

AccountingSupplierParty.Party.PartyName.Name

0..1 Sender Name 3 Invoice company (CD)

AccountingSupplierParty.Party.PartyName.Name

0..1 Sender Name 4 Invoice company (CD)

AccountingSupplierParty.Party.PartyName.Name

0..1 Sender Name co Invoice company (CD)

AccountingSupplierParty.Party.PartyName.Name

0..1 Sender Street Invoice company (CD)
Kundservice Faktura AccountingSupplierParty.Party.PostalAddress.StreetName
Kundservice Faktura
0..1 Sender Post Box Invoice company (CD)

AccountingSupplierParty.Party.PostalAddress.AdditionalStreetName

0..1 Sender City Invoice company (CD)
Malmö AccountingSupplierParty.Party.PostalAddress.CityName
Malmö
0..1 Sender City Box Invoice company (CD)

AccountingSupplierParty.Party.PostalAddress.CityName

0..1 Sender Post Code Invoice company (CD)
20005 AccountingSupplierParty.Party.PostalAddress.PostalZone
20005
0..1 Sender Post Code Box Invoice company (CD)

AccountingSupplierParty.Party.PostalAddress.PostalZone

1..1 Sender Country Invoice company (CD)
SE AccountingSupplierParty.Party.PostalAddress.Country.IdentificationCode
SE
1..1 Sender VATNR Invoice company (CD)
SE556711569501 AccountingSupplierParty.Party.PartyTaxScheme.CompanyID
SE556711569501
0..1 Sender VATNR schemeID ISO Invoice company (CD)

AccountingSupplierParty.Party.PartyTaxScheme.CompanyID schemeID
1..1 Sender VATNR TaxSchemeID New Print Solution (CD)
VAT AccountingSupplierParty.Party.PartyTaxScheme.TaxScheme.ID
VAT
1..1 Sender ExemptionReason New Print Solution (CD)
Godkänd för F-skatt AccountingSupplierParty.Party.PartyTaxScheme.CompanyID
Godkänd för F-skatt
1..1 Sender ExemptionReason TaxSchemeID New Print Solution (CD)
TAX AccountingSupplierParty.Party.PartyTaxScheme.TaxScheme.ID
TAX
1..1 Company name New Print Solution (CD)
PostNord Sverige AB AccountingSupplierParty.Party.PartyLegalEntity.RegistrationName
PostNord Sverige AB
1..1 Sender ORGNR Invoice company (CD)
5567115695 AccountingSupplierParty.Party.PartyLegalEntity.CompanyID
5567115695
0..1 Sender ORGNR schemeID ISO New Print Solution (CD)
0007 AccountingSupplierParty.Party.PartyLegalEntity.CompanyID schemeID 0007
1..1 Our reference (name of contact) New Print Solution (CD)
PostNord Customer Service AccountingSupplierParty.Party.Contact.Name
PostNord Customer Service
1..1 Sender Phone New Print Solution (CD)
0771333310 AccountingSupplierParty.Party.Contact.Telephone
0771333310
1..1 Sender Email New Print Solution (CD)
faktura.se@postnord.com AccountingSupplierParty.Party.Contact.ElectronicMail
faktura.se@postnord.com
1..1 Recipient EDI Endpoint id Invoice payer (MD)
5562754977 AccountingCustomerParty.Party.EndpointID
5562754977
1..1 Recipient EDI Endpoint id schemeID ISO Invoice payer (MD)
0007 AccountingCustomerParty.Party.EndpointID schemeID 0007
1..1 Recipient EDI id Invoice payer (MD)
5567115695 AccountingCustomerParty.Party.PartyIdentification.ID
5567115695
0..1 Recipient EDI schemeID ISO Invoice payer (MD)
0007 AccountingCustomerParty.Party.PartyIdentification.ID schemeID 0007
0..1 Recipient Name 1 Invoice bill-to (MD)
Customer name 1 AccountingCustomerParty.Party.PartyName.Name
Customer name 1
0..1 Recipient Name 2 Invoice bill-to (MD)
Customer name 2 AccountingCustomerParty.Party.PartyName.Name
Customer name 2
0..1 Recipient Name 3 Invoice bill-to (MD)
Customer name 3 AccountingCustomerParty.Party.PartyName.Name
Customer name 3
0..1 Recipient Name 4 Invoice bill-to (MD)
Customer name 4 AccountingCustomerParty.Party.PartyName.Name
Customer name 4
0..1 Recipient Name co Invoice bill-to (MD)
Customer name co AccountingCustomerParty.Party.PartyName.Name
Customer name co
0..1 Recipient Street 2 Invoice bill-to (MD)
Customer street 2 AccountingCustomerParty.Party.PartyName.Name
Customer street 2
0..1 Recipient Street 3 Invoice bill-to (MD)
Customer street 3 AccountingCustomerParty.Party.PartyName.Name
Customer street 3
0..1 Recipient Street 4 Invoice bill-to (MD)
Customer street 4 AccountingCustomerParty.Party.PartyName.Name
Customer street 4
0..1 Recipient Street 5 Invoice bill-to (MD)
Customer street 5 AccountingCustomerParty.Party.PartyName.Name
Customer street 5
0..1 Recipient Street Invoice bill-to (MD)
Customer street 1 AccountingCustomerParty.Party.PostalAddress.StreetName
Customer street 1
0..1 Recipient Post Box Invoice bill-to (MD)
123 AccountingCustomerParty.Party.PostalAddress.AdditionalStreetName
Box 123
0..1 Recipient City Invoice bill-to (MD)
Stockholm AccountingCustomerParty.Party.PostalAddress.CityName

0..1 Recipient City Box Invoice bill-to (MD)
Stockholm AccountingCustomerParty.Party.PostalAddress.CityName
Stockholm
0..1 Recipient Post Code Invoice bill-to (MD)
11218 AccountingCustomerParty.Party.PostalAddress.PostalZone

0..1 Recipient Post Code Box Invoice bill-to (MD)
10500 AccountingCustomerParty.Party.PostalAddress.PostalZone
10500
1..1 Recipient Country Code Invoice bill-to (MD)
SE AccountingCustomerParty.Party.PostalAddress.Country.IdentificationCode
SE
0..1 Recipient VATNR Invoice payer (MD)
SE556711569501 AccountingCustomerParty.Party.PartyTaxScheme.CompanyID
SE556711569501
0..1 Recipient VATNR schemeID ISO Invoice payer (MD)

AccountingCustomerParty.Party.PartyTaxScheme.CompanyID schemeID
0..1 Recipient VATNR TaxSchemeID Invoice payer (MD)
VAT AccountingCustomerParty.Party.PartyTaxScheme.TaxScheme.ID
VAT
1..1 Recipient payer registration name Invoice payer (MD)
Customer name 1 AccountingCustomerParty.Party.PartyLegalEntity.RegistrationName
Customer name 1
1..1 Recipient ORGNR Invoice payer (MD)
5567115695 AccountingCustomerParty.Party.PartyLegalEntity.CompanyID
5567115695
0..1 Recipient ORGNR schemeID ISO Invoice payer (MD)
0007 AccountingCustomerParty.Party.PartyLegalEntity.CompanyID schemeID 0007
0..1 Payment means code New Print Solution + SAP-FI (CD)
30 PaymentMeans.PaymentMeansCode
30
1..1 Payment Reference Invoice (TD)
900000180225 PaymentMeans.PaymentID
900000180225
0..1 Account New Print Solution + SAP-FI (CD) If SEK and SE customer,
for example 52494309

PaymentMeans.PayeeFinancialAccount.ID

0..1 IBAN New Print Solution + SAP-FI (CD) IF not SEK or not SE customer DE64514206000011928009 PaymentMeans.PayeeFinancialAccount.ID
DE64514206000011928009
0..1 Account Swift New Print Solution + SAP-FI (CD) If SEK and SE customer
for example SE:BANKGIRO

PaymentMeans.PayeeFinancialAccount.FinancialInstitutionBranch.ID

0..1 IBAN Swift New Print Solution + SAP-FI (CD) IF not SEK or not SE customer HANDDEFFXXX PaymentMeans.PayeeFinancialAccount.FinancialInstitutionBranch.ID
HANDDEFFXXX
0..1 Direct debit payment instruction Invoice payer (MD) Only if direct debit is used
PaymentTerms.Note

1..1 TABLE_ALLOWANCE_CHARGE New Print Solution (CD) Table of allowance charges
aggregated on header level




1..n Table Allowance Charge Line New Print Solution (CD) Line of allowance charge



1..1 Surcharge Indicator New Print Solution (CD)
true AllowanceCharge.ChargeIndicator
true
1..1 Surcharge Description New Print Solution (CD)
Credit surcharge (VAT rate applied 25%) AllowanceCharge.AllowanceChargeReason
Credit surcharge (VAT rate applied 25%)
1..1 Surcharge Amount Invoice (TD)
20.00 AllowanceCharge.Amount
20.00
1..1 Document currency code Sold-to curr (MD->TD)
EUR AllowanceCharge.Amount currencyID EUR
1..1 VAT Id New Print Solution (CD) E if vat rate = 0
AE if vat rate = 0 + reverse
S [OR] E [OR] AE AllowanceCharge.TaxCategory.ID
S [OR] E [OR] AE
1..1 VAT Rate Invoice (TD) + payer (MD)
25 [OR] 0 [OR] 6 [OR] 12 AllowanceCharge.TaxCategory.Percent
25 [OR] 0 [OR] 6 [OR] 12
1..1 VAT Scheme Id New Print Solution (CD)
VAT AllowanceCharge.TaxCategory.TaxScheme.ID
VAT
1..1 VAT amount in document currency Invoice items (TD)
250.00 TaxTotal.TaxAmount
250.00
1..1 Document currency code Sold-to curr (MD->TD)
EUR TaxTotal.TaxAmount currencyID EUR
1..1 TABLE_VAT New Print Solution (CD) Table of aggregated VAT
aggregated on header level




1..n Table VAT Line New Print Solution (CD) Line of aggregated VAT



1..1 VAT Base Amount Invoice (TD)
1000.00 TaxTotal.TaxSubTotal.TaxableAmount
1000.00
1..1 Document currency code Sold-to curr (MD->TD)
EUR TaxTotal.TaxSubTotal.TaxableAmount currencyID EUR
1..1 VAT Amount Invoice (TD)
250.00 TaxTotal.TaxSubTotal.TaxAmount
250.00
1..1 Document currency code Sold-to curr (MD->TD)
EUR TaxTotal.TaxSubTotal.TaxAmount currencyID EUR
1..1 VAT Id New Print Solution (CD) E if vat rate = 0
AE if vat rate = 0 + reverse
S [OR] E [OR] AE TaxTotal.TaxSubTotal.TaxCategory.ID
S [OR] E [OR] AE
1..1 VAT Rate Invoice (TD) + payer (MD)
25 [OR] 0 [OR] 6 [OR] 12 TaxTotal.TaxSubTotal.TaxCategory.Percent
25 [OR] 0 [OR] 6 [OR] 12
0..1 VAT Exemption Reason New Print Solution (CD) Only when VAT rate = 0 No VAT applied
[OR]
Reverse Charge - Art. 196 VAT Directive
TaxTotal.TaxSubTotal.TaxCategory.TaxExemptionReason
No VAT applied
[OR]
Reverse Charge - Art. 196 VAT Directive
1..1 VAT Scheme Id New Print Solution (CD)
VAT TaxTotal.TaxSubTotal.TaxCategory.TaxScheme.ID
VAT
0..1 VAT Amount Local Invoice (TD) IF Doc curr <> VAT curr (TD) 2500.00 TaxTotal.TaxAmount
2500.00
0..1 Company code currency Company curr (CD) IF Doc curr <> VAT curr (TD) SEK TaxTotal.TaxAmount currencyID SEK
1..1 Total amount of line items Invoice items (TD)
980.00 LegalMonetaryTotal.LineExtensionAmount
980.00
1..1 Document currency code Sold-to curr (MD->TD)
EUR LegalMonetaryTotal.LineExtensionAmount currencyID EUR
1..1 Total amount excluding VAT Invoice items (TD)
1000.00 LegalMonetaryTotal.TaxExclusiveTotalAmount
1000.00
1..1 Document currency code Sold-to curr (MD->TD)
EUR LegalMonetaryTotal.TaxExclusiveTotalAmount currencyID EUR
1..1 Total amount including VAT Invoice items (TD)
1250.00 LegalMonetaryTotal.TaxInclusiveTotalAmount
1250.00
1..1 Document currency code Sold-to curr (MD->TD)
EUR LegalMonetaryTotal.TaxInclusiveTotalAmount currencyID EUR
1..1 Total amount of allowances Invoice items (TD)
0.00 LegalMonetaryTotal.AllowanceTotalAmount
0.00
1..1 Document currency code Sold-to curr (MD->TD)
EUR LegalMonetaryTotal.AllowanceTotalAmount currencyID EUR
1..1 Total amount of charges Invoice items (TD)
20.00 LegalMonetaryTotal.ChargeTotalAmount
20.00
1..1 Document currency code Sold-to curr (MD->TD)
EUR LegalMonetaryTotal.ChargeTotalAmount currencyID EUR
1..1 Total amount including VAT Invoice items (TD)
1250.00 LegalMonetaryTotal.PayableAmount
1250.00
1..1 Document currency code Sold-to curr (MD->TD)
EUR LegalMonetaryTotal.PayableAmount currencyID EUR
1..1 TABLE_DETAIL New Print Solution (CD) Table of invoice items



1..n Table Detail Line New Print Solution (CD) Line of invoice item



1..1 Invoice item counter (1..n) Invoice (TD)
1 InvoiceLine/CreditNoteLine.ID
1
1..1 Price Parameter Quantity Invoice (TD)
1 InvoiceLine/CreditNoteLine.InvoicedQuantity/CreditedQuantity
1
0..1 Price Parameter Quantity UOM ISO New Print Solution (CD)
EA InvoiceLine/CreditNoteLine.InvoicedQuantity/CreditedQuantity unitCode EA
1..1 Amount after discount excl surcharges Invoice (TD)
980.00 InvoiceLine/CreditNoteLine.LineExtensionAmount
980.00
1..1 Document currency code Sold-to curr (MD->TD)
EUR InvoiceLine/CreditNoteLine.LineExtensionAmount currencyID EUR
0..1 Information Period Start Date for FPA/BOX Invoice (TD)
9/13/2016 InvoiceLine/CreditNoteLine.InvoicePeriod.StartDate
9/13/2016
0..1 Information Period End Date for FPA/BOX Invoice (TD)
9/12/2017 InvoiceLine/CreditNoteLine.InvoicePeriod.EndDate
9/12/2017
1..1 Price Parameter Material description Invoice (TD)
MyPack InvoiceLine/CreditNoteLine.Item.Name
MyPack
1..1 Price Parameter Material number Invoice (TD)
2001290 InvoiceLine/CreditNoteLine.Item.SellersItemIdentification.ID
2001290
1..1 VAT Id New Print Solution (CD) E if vat rate = 0
AE if vat rate = 0 + reverse
S [OR] E [OR] AE InvoiceLine/CreditNoteLine.Item.ClassifiedTaxCategory.ID
S [OR] E [OR] AE
1..1 VAT Rate Invoice (TD) + payer (MD)
25 [OR] 0 [OR] 6 [OR] 12 InvoiceLine/CreditNoteLine.Item.ClassifiedTaxCategory.Percent
25 [OR] 0 [OR] 6 [OR] 12
1..1 VAT Scheme Id New Print Solution (CD)
VAT InvoiceLine/CreditNoteLine.Item.ClassifiedTaxCategory.TaxScheme.ID
VAT
1..1 Amount per piece Invoice (TD)
980.00 InvoiceLine/CreditNoteLine.Price.PriceAmount
980.00
1..1 Document currency code Sold-to curr (MD->TD)
EUR InvoiceLine/CreditNoteLine.Price.PriceAmount currencyID EUR
0..1 Amount per piece base quantity Invoice (TD) If amount per piece decimals are not sufficient
InvoiceLine/CreditNoteLine.Price.BaseQuantity

1..1 Note Depends on parameter JSON is used to define parameter and value pairs.
The Note element is specified last in both the input and output file, but actually occurrs after the ID element.
"Parameter1_Name":"Parameter1_Value"
, "Parameter2_Name":"Parameter2_Value"
etc.
InvoiceLine/CreditNoteLine.Note
"Parameter1_Name":"Parameter1_Value"
, "Parameter2_Name":"Parameter2_Value"
etc.
0..1 Reference SAP Specification Number Invoice (TD) Part of InvoiceLine.Note "Reference_Spec_Number":"8000005834"

"Reference_Spec_Number":"8000005834"
0..1 Reference Customer Number Invoice sold-to (MD) Part of InvoiceLine.Note "Reference_Customer_Number":"20735710"

"Reference_Customer_Number":"20735710"
0..1 Reference Customer Name Invoice sold-to (MD) Part of InvoiceLine.Note "Reference_Customer_Name":"Cust name"

"Reference_Customer_Name":"Cust name"
0..1 Reference Customer Invoice Reference Invoice sold-to (MD) Part of InvoiceLine.Note "Reference_Customer_Invoice_Reference":"Ref"

"Reference_Customer_Invoice_Reference":"Ref"
0..1 Reference SAP Billing Plan Number Invoice (TD) Part of InvoiceLine.Note "Reference_Billing_Plan":"7500012345"

"Reference_Billing_Plan":"7500012345"
0..1 Reference SAP Order Number Invoice (TD) Part of InvoiceLine.Note "Reference_Order_Number":"1234567890"

"Reference_Order_Number":"1234567890"
0..1 Reference SAP Contract Number Invoice (TD) Part of InvoiceLine.Note "Reference_Contract_Number":"7500123456"

"Reference_Contract_Number":"7500123456"
0..1 Reference SAP Credited Invoice Invoice (TD) Part of InvoiceLine.Note "Reference_Credited_Invoice":"9000003665"

"Reference_Credited_Invoice":"9000003665"
0..1 Reference Customer Invoice (TD) Part of InvoiceLine.Note "Reference_Customer":"Customer order ref"

"Reference_Customer":"Customer order ref"
0..1 Information Cash on Delivery Value Invoice (TD) Part of InvoiceLine.Note "Value_Cash_On_Delivery":"100 SEK"

"Value_Cash_On_Delivery":"100 SEK"
0..1 Information Import VAT value Invoice (TD) Part of InvoiceLine.Note "Value_Import_Vat":"100 SEK"

"Value_Import_Vat":"100 SEK"
0..1 Information Customs Id Invoice (TD) Part of InvoiceLine.Note "Customs_Id":"NOD8925767"

"Customs_Id":"NOD8925767"
0..1 Information Parcel ID Invoice (TD) Part of InvoiceLine.Note "Parcel_Id":"SE123456789012349"

"Parcel_Id":"SE123456789012349"
0..1 Information Shipment Id Invoice (TD) Part of InvoiceLine.Note "Shipment_Id":"70726203781069158"

"Shipment_Id":"70726203781069158"
0..1 Partner Consignor id (ZC) Invoice (TD) Part of InvoiceLine.Note "Consignor_Id":"20001234"

"Consignor_Id":"20001234"
0..1 Partner Consignor name (ZC) Invoice (TD) Part of InvoiceLine.Note "Consignor_Name":"Sender name"

"Consignor_Name":"Sender name"
0..1 Partner Drop point id (ZI) Invoice (TD) Part of InvoiceLine.Note "Drop_Point_Id":"P123456"

"Drop_Point_Id":"P123456"
0..1 Partner Drop point name (ZI) Invoice (TD) Part of InvoiceLine.Note "Drop_Point_Name":"Årsta brevterminal"

"Drop_Point_Name":"Årsta brevterminal"
0..1 Period Start FPA/BOX - Note Invoice (TD) Part of InvoiceLine.Note "Period_Start":"2016-09-13"

"Period_Start":"2016-09-13"
0..1 Period End FPA/BOX - Note Invoice (TD) Part of InvoiceLine.Note "Period_End":"2017-09-12"

"Period_End":"2017-09-12"
0..1 Price 1 currencies Invoice (TD) Part of InvoiceLine.Note "Price_1_Currency_From_To":"SEK-EUR"

"Price_1_Currency_From_To":"SEK-EUR"
0..1 Price 1 exchange rate Invoice (TD) Part of InvoiceLine.Note "Price_1_Exchange_Rate":"0.10000"

"Price_1_Exchange_Rate":"0.10000"
0..1 Price 2 currencies Invoice (TD) Part of InvoiceLine.Note "Price_2_Currency_From_To":"SEK-USD"

"Price_2_Currency_From_To":"SEK-USD"
0..1 Price 2 exchange rate Invoice (TD) Part of InvoiceLine.Note "Price_2_Exchange_Rate":"0.12000"

"Price_2_Exchange_Rate":"0.12000"
0..1 VAT currencies Invoice (TD) Part of InvoiceLine.Note "VAT_Currency_From_To":"SEK-EUR"

"VAT_Currency_From_To":"SEK-EUR"
0..1 VAT exchange rate Invoice (TD) Part of InvoiceLine.Note "VAT_Exchange_Rate":"0.10000"

"VAT_Exchange_Rate":"0.10000"
0..1 Price Parameter Collective Invoice (TD) Part of InvoiceLine.Note "Collective_Price":"true"

"Collective_Price":"true"
0..1 Price Parameter Distance Invoice (TD) Part of InvoiceLine.Note "Distance":"123"

"Distance":"123"
0..1 Price Parameter Freight weight Invoice (TD) Part of InvoiceLine.Note "Freight_Weight":"10.00"

"Freight_Weight":"10.00"
0..1 Price Parameter Freight weight customer Invoice (TD) Part of InvoiceLine.Note "Freight_Weight_Customer":"5.00"

"Freight_Weight_Customer":"5.00"
0..1 Price Parameter Gross weight Invoice (TD) Part of InvoiceLine.Note "Weight":"10.00"

"Weight":"10.00"
0..1 Price Parameter Length Invoice (TD) Part of InvoiceLine.Note "Length":"0.1"

"Length":"0.1"
0..1 Price Parameter Width Invoice (TD) Part of InvoiceLine.Note "Width":"0.1"

"Width":"0.1"
0..1 Price Parameter Height Invoice (TD) Part of InvoiceLine.Note "Height":"0.1"

"Height":"0.1"
0..1 Price Parameter Item Type Invoice (TD) Part of InvoiceLine.Note "Item_Type_Code":"PC"

"Item_Type_Code":"PC"
0..1 Price Parameter Item Type Description Invoice (TD) Part of InvoiceLine.Note "Item_Type_Description":"Parcel"

"Item_Type_Description":"Parcel"
0..1 Price Parameter Item weight Invoice (TD) Part of InvoiceLine.Note "Item_Weight":"100"

"Item_Weight":"100"
0..1 Price Parameter Item weight unit New Print Solution (CD) Part of InvoiceLine.Note "Item_Weight_Uom":"g"

"Item_Weight_Uom":"g"
0..1 Price Parameter Volume Invoice (TD) Part of InvoiceLine.Note "Volume":"0.001"

"Volume":"0.001"
0..1 Price Parameter Sending country Invoice (TD) Part of InvoiceLine.Note "Sending_Country":"SE"

"Sending_Country":"SE"
0..1 Price Parameter Sending post code Invoice (TD) Part of InvoiceLine.Note "Sending_Postcode":"10500"

"Sending_Postcode":"10500"
0..1 Price Parameter Receiving country Invoice (TD) Part of InvoiceLine.Note "Receiving_Country":"SE"

"Receiving_Country":"SE"
0..1 Price Parameter Receiving post code Invoice (TD) Part of InvoiceLine.Note "Receiving_Postcode":"11218"

"Receiving_Postcode":"11218"
0..1 Price Parameter Receiving city Invoice (TD) Part of InvoiceLine.Note "Receiving_City":"Stockholm"

"Receiving_City":"Stockholm"
0..1 Surcharge Advertising tax amount Invoice (TD) Part of InvoiceLine.Note "Advertising_Tax":"9.80"

"Advertising_Tax":"9.80"
0..1 Surcharge Advertising tax rate Invoice (TD) Part of InvoiceLine.Note "Advertising_Tax_Rate":"1.00"

"Advertising_Tax_Rate":"1.00"
0..1 Surcharge Fuel Invoice (TD) Part of InvoiceLine.Note "Fuel_Surcharge":"10.00"

"Fuel_Surcharge":"10.00"
0..1 Surcharge Sulfur Invoice (TD) Part of InvoiceLine.Note "Sulfur_Surcharge":"10.00"

"Sulfur_Surcharge":"10.00"
0..1 Surcharge Minimum amount fee Invoice (TD) Part of InvoiceLine.Note "Minimum_Amount_Fee":"60.00"

"Minimum_Amount_Fee":"60.00"
0..1 Surcharge multi item Invoice (TD) Part of InvoiceLine.Note "Multi_Item_Surcharge":"9.80"

"Multi_Item_Surcharge":"9.80"
0..1 Price per piece Invoice (TD) Part of InvoiceLine.Note "Price_Per_Piece":"980.00"

"Price_Per_Piece":"980.00"
0..1 Price per weight Invoice (TD) Part of InvoiceLine.Note "Price_Per_Weight":"10.00"

"Price_Per_Weight":"10.00"
0..1 Price low apply Invoice (TD) Part of InvoiceLine.Note "Price_Low_Apply":"980.00"

"Price_Low_Apply":"980.00"
0..1 Discount rate Invoice (TD) Part of InvoiceLine.Note "Discount_Rate":"10.00"

"Discount_Rate":"10.00"
0..1 Text 1 Item Invoice (TD) Part of InvoiceLine.Note "Item_Text_1":"item text 1"

"Item_Text_1":"item text 1"
0..1 Text 2 Item Invoice (TD) Part of InvoiceLine.Note "Item_Text_2":"item text 2"

"Item_Text_2":"item text 2"
0..1 Text 3 Item Invoice (TD) Part of InvoiceLine.Note "Item_Text_3":"item text 3"

"Item_Text_3":"item text 3"
0..1 Text 4 Item Invoice (TD) Part of InvoiceLine.Note "Item_Text_4":"item text 4"

"Item_Text_4":"item text 4"
0..1 Text 1 Order Invoice (TD) Part of InvoiceLine.Note "Text_1":"header text 1"

"Text_1":"header text 1"
0..1 Text 2 Order Invoice (TD) Part of InvoiceLine.Note "Text_2":"new customer 20001235"

"Text_2":"new customer 20001235"
1..1 DOCUMENTS New Print Solution (CD)




1..1 Documents Global Unique ID Generated (TD)
005056AC3F361ED8AEE8753A58F69DC4










1..1 DOCUMENT New Print Solution (CD)




1..1 Document Global Unique ID Generated (TD)
005056AC3F361ED8AEE8753A58F6BDC4










1..1 CONTROL RECORD New Print Solution (CD)




1..1 Document type New Print Solution (CD)
OTI_INV_DEBIT [OR] OTI_INV_CREDIT


1..1 Assignment New Print Solution (CD) Postnord internal use PNOT01 [OR] PNOT02 etc.


1..1 Test New Print Solution (CD) Test flag true [OR] false


1..1 Distribution method name New Print Solution (CD)
EDI










1..1 RECIPIENT New Print Solution (CD)




0..1 Recipient Mail Back Invoice bill-to (MD)
firstname.lastname

Email sent to firstname.lastname@postnord.com








1..1 RECIPIENT Generics New Print Solution (CD)




1..1 Recipient EDI Format Invoice payer (MD)
PEPPOL_BIS_BILLING_3.0


0..1 Recipient EDI Peppol id including prefix Invoice payer (MD)
0007:5567115695


1..1 Recipient EDI Routing id Invoice payer (MD)
3000001










1..1 SENDER New Print Solution (CD)












1..1 SENDER Generics New Print Solution (CD)




0..1 Sender EDI Peppol id including prefix New Print Solution (CD)
0088:7321540000019










1..1 HEADER New Print Solution (CD)












1..1 FOOTER New Print Solution (CD)












1..1 BODY New Print Solution (CD)





































The words contained in this file might help you see if this file matches what you are looking for:

...Sheet version history the original order of lines from xml source perspective date author tracking fields description teodor berglund postnord aligned with internal mapping specification read me first explanation columns in group column input card cardinalityhow many times can element occurr without attributehow specified attribute value field sap where data is fetched to understand what kind that affect fieldeach type classified four categories belowtd transaction datacd customizing datamd master updated will md gt td affects and comment on how used example file not always same as output because logic applied some datasometimes have multiple examples separator betweensometimes blank then check for an full or partial pathwhen provided mapped directly this when towards valuewhen no after has been appliedsometimes peppol bis billing document id invoice number issue payer freq issuedate due payment terms duedate code new print solution cd credit invoicetypecode creditnotetypecode header n...

no reviews yet
Please Login to review.