ERPEL Schema version: 1p0 last update: 2024-01-15 last update by: pw documentation: https://docs.ecosio.com (ask contact (at) ecosio.com for access credentials) The ERPEL document is the payload of an ERPEL message. Pharmazentralnummer - German for "central pharamaceutical number" - a unique identifier for pharmaceutical products GS1 Global Trade Identification Number Article number used by the supplier Article number used by the customer The product number of the final (ultimate) customer. Article number used by the manufacturer. The Universal Product Code - typcially the coded printed below the bar code. Indicates the calculation net price. The calculation net price is the price including allowances/ charges and excluding taxes. Indicates the calculation gross price. The calculation gross price is the price excluding all allowances, charges and taxes. Name of the bank institute. The bank code. Bank identification code. Bank account number. International Bank Account Number. Name of the bank account holder. Revision number of the underlying drawing of the product Date when the underlying drawing of the product has been change A control number indicating the engineering change A control number which is assigned to the forecasted product A production number to which the forecasted product is assigned to And indicator for the model year to which the forecasted product belongs to An internal code of the buyer, identifying the product group to which the forecasted product belongs to Identifies what the requested product is used for - e.g. pilot, additional request, specimem, etc. Contains a coded value. Has been introduced due to a requirements from the VDA 4905 document Indicator showing whether this is an article with special conditions, which is requested here. If no BLANK is provided here, the article is an article with special coniditions Difference between the continuous entry number and the continuous demand number A set of kanban IDs, issued by the customer. These Kanban IDs can be taken over to the dispatch advice as well. The classification of the product/service in free-text form. The serial number of the list line item product. The number of the batch/lot. The classification of the product/service in free-text of coded form. Please use ClassificationSchema to define the classification type Used to specify an alternative quantity in addition to ListLineItem/Quantity. Used to describe a quantity for which the customer is actually charged. May be provided in case this number deviates from ListLinteItem/Quantity. Used to describe a quantity which is provided to the customer free-of-charge. If all items are delivered for free then ListLinteItem/Quantity == 0. An external batch/lot number. The expiration date is the last day in which a product is safe to consume. The best before date is the last day where the product is still in perfect condition. The manufacturing date of a certain batch/lot. A control number/level indicating the engineering change. Revision number of the underlying drawing of the product. In case a deduction took place, the deducted quantity is provided here. The stock location where the goods item was taken from. The stock ground the goods item was taken from. The destination stock location where the goods item will be shipped to. The destination stock ground where the goods item will be shipped to. The size of the product. The net weight of the product. The number of boxes where the products of the given list line item are stored in. The color of the product of the given list line item. Country in which the product was produced or could be produced. The confirmed country of origin, provided by the supplier. Even if a product can potentially be produced in multiple countries, it has only one confirmed country of origin. Salutation, e.g., Mr., Mrs., Company, etc. The name. Either first name + last name or the company name. Street information. Post-office box. City information. ZIP code. Country information. Any further elements or attributes which are necessary for an address may be provided here. Note that extensions should be used with care and only those extensions shall be used, which are officially provided by ERPEL. Attribute defining the type of article number. If a file needs to be attached to a document FileAttachment can be used. At least a file content has to be provided. Name/ID of the file MimeType of the attached file Encoding used for the file Encoded file If a link to an external attachment needs to be added to a document, LinkAttachment can be used. A name or description of the link. The actual link. Defines the type of bank code by providing the country from which the bank code is. In order to specify the country in this attribute, a code according to ISO 3166-1 must be used. The VAT identification number. Additional identification used to uniquely identify the party. References to documents from the given party. Deprecated. Please supply the phone number in Contact/Phone Deprecated. Please supply the email address in Contact/Email. Deprecated. Global Location Number of the party. Please use FurtherIdentification@GLN Further contact details. Address details of the party. A feature of the given classification. In most of the cases ClassificationSchema is enough to describe some additional classification. The Feature element should only be used for exceptional cases The schema of the classification - e.g. eCl@ss. The hierarchical ID of the current consignment packaging item. A sequential numbering is recommended. The hierarchical ID of the parent consignment item (if exists). The current packaging level. The use of one of the EDIFACT prescribed codes is recommended here (VDA4987 CPS 7075): 1 = Inner Level of packing, if it exists, that is immediately subordinate to the intermediate packaging level. 2 = Intermediate Level of packaging, if it exists, that is immediately subordinate to the outer packaging level. 3 = Outer For packed merchandise, outermost level of packaging for a shipment. 1E = Highest (EAN Code) Level of packaging, if it exists, which is highest in the packaging hierarchy. Further information about the specific consignment item. DEPRICATED - Please use ContainedPackagingItems/@Unit; The type of packaging which is being used. The amount of packaging levels used. Usually used for sandwich pallet cases to indicate the number of included pallets on the main pallet. The serial shipping container code (SSCC) (NVE = German for: Nummer der Verpackungseinheit). The serial shipping container code (SSCC) for the parent shipping container if a structured DESADV is requested. Mainly used in automotive or industry DESADV messages. The gross volume of the consignment item. The net weight of the consignment item. The gross weight of the consignment item. The tare weight of the consignment item's packaging. Gross weight - tare weight = net weight. The delivered amount. The packaging items contained in the given consignment item. Packaging unit type of the contained packages. If customer's and supplier's packaging unit type is different this should be used for customer's packaging unit type. Packaging unit type used by the supplier. If customer's and supplier's packaging unit type is different this should be used for suppliers's packaging unit type. GTIN/EAN number of the specific consignment item. Packaging related description code. Please use EDIFACT code list values. (PAC 7233) Packaging terms and conditions code (Who is the owner, is it returnable..). Please use EDIFACT code list values. (PAC 7073) Marking type code. Please use EDIFACT code list values or VDA codes. e.g. 33E=Marked with packaging label number (GS1 PCI 7511), G/M/S (VDA4913 715/13) Quantity per packaging item with optional unit. A list line item describing a certain product/service in a consignment item in further detail. Note, that this element's structure is identical to ItemList/LiteLineItem. Name of the contact. First name of the contact. Email address of the contact. Phone number of the contact. Fax number of the contact. Code for the country. Must be provided using an ISO 3166-1 code. A unique ID assigned to the payment. The primary account number identification. Usually the last 4 to 6 digits of the payment card number. Used to identify the financial service network provider of the card. Examples are VISA, MasterCard or American Express. The full name of the card holder. The customer ID issued by the supplier. The accounting area at the document recipient's side. Used to associate a given document to a certain accounting area. The ID of an internal sub organization to which the document shall be associated to at the document recipient's side. The ID of the delivery. Note that either Date or Period may be specified, but not both. Depending on the message type, the meaning of Date varies. Order: requested delivery date. OrderConfirmation: confirmed delivery date. DispatchAdvice: actual delivery date; Invoice: actual delivery date; Note that either Date or Period may be specified, but not both. Depending on the message type, the meaning of Period varies. Order: requested delivery period. OrderConfirmation: confirmed delivery period. DispatchAdvice: use Date; Invoice: use Date in case if actual goods are delivered; use Period to specifiy the timeframe for the provided services Not commonly used. Use this element in DispatchAdvices when both the actual and the confirmed delivery dates must be supplied. The date when shipping of goods takes place. The delivery date is the date when the goods/serivces arrive at the premises of the customer. The shipping date is the date when the goods/services leave the suppliers premises/warehouse. Free-text description of the delivery. The net weight of the delivery. The gross weight of the delivery. The tare weight. Tare weight is the weight of the containment (e.g. container, ), where the actual goods are stored in. Gross weight - tare weight = net weight. Further details about the incoterms. Further details about the transport. The tour number of a certain delivery, e.g., the tour number of a delivery truck. A unique identifier used for the shipment according to the SSCC specification of GS1. The mode of despatch in free-text. E.g., "standard international shipping", "express international shipping", etc. The number of packages in the given delivery. The name of the driver performing the delivery. The license plate number of the vehicle performing the delivery. Used to identify the sequence in which physical packing is presented in the consignment, and optionally to identify the hierarchical relationship between packing layers. Note: This element is used in order to allow for compliance to EDIFACT DESADVs. Details about the recipient of the delivery of goods or services. Details about the delivery of good or services specified in this document. A code for a unique identification of the language used for the free-text description. Codes according to ISO 639-2 must be used. A free-text header description with precedes the details section. A list of different line items. Used to group line items of a certain kind together. A free-text footer description with suceeds the details section. Date until the discount may be applied. Duration in which the discount may be applied. The base amount for the discount. The discount rate. The discount amount. The discount amount is calculated by: Base amount x percentage = discount amount. In case both, percentage and discount amount, are provided, discount amount is normative. Free text comment field for the given discount. Several documents such as order, despatch advice and invoice may belong to a common business process. This element may be used to correlate different business documents to a common business process. The document number. May be used to identify the document. The date when the document was issued. Recuring details of a DocumentListLineItem. Represent a certain list line item. The ERPEL core document is defined as a single XML Schema file and comprises all elements, which are used by the different ERPEL sub document types. Several documents such as order, despatch advice and invoice may belong to a common business process. This element may be used to correlate different business documents to a common business process. The document number. May be used to identify the document. The date when the document was issued. Used to store information about the delivery itself (such as delivery date, delivery times, etc.) and the delivery party. Details about the supplier of goods/services. Details about the receiver of goods or services. Details about the party ordering the goods/services. Customer and ordering party do not necessarily have to be the same. Details about the company (carrier) shipping the product/services. Details about the party receiving the invoice. Details about the document itself are provided in this element, i.e., the different line items. The total line item ammount of the invoice. Equals the sum of all line item amounts bafore any further calculations were done. Details about reductions and surcharges applying to the products/services defined in the document. Note that both, reductions and surcharges, are always provided as positive values. The total net amount of the invoice. Equals the sum of all line item net amounts minus reductions and plus surcharges. Used to specify the relevant tax information for this document. The total gross amount of the invoice. Equals the total net amount plus taxes. The payment method applicable to this document. May be either of type UniversalBankTransaction, DirectDebit, or NoPayment. Information in regard to the payment conditions of this document. Used to provide presentation details for the document. Attachmens included in the message. Any further elements or attributes which are necessary for the ERPEL document may be provided here. Note that extensions should be used with care and only those extensions shall be used, which are officially provided by ERPEL. The name of the system which has been used to generate the document. In case a previously sent ERPEL document shall be cancelled, this attribute may be used. In this case the document number of the document to cancel must be provided in this attribute. The document type of the current document. The currency in which the monetary values of the document are provided. Codes according to ISO 4217 must be used. If this attribute is set to true, the issuer of the document signalizes the recipient of the document that the document shall be checked manual upon receipt before any automated processing takes place. This might for instance occur if previously untested fields are set or tests shall be conducted. The free-text title of the document. The language used throughout the document. Codes according to ISO 639-2 must be used. @Deprecated. Indicates whether prices in this document are provided in gross or in net. The document number of the referenced document. The type of the referenced document. E.g., order, despatch advice, etc. In case a certain position in a document shall be referenced, this element may be used. Reference date of the document. Typcially this element refers to the document date of the preceding document. An optional description in free-text or a specification of the reference type for the DocumentType 'DocumentReference'. The quantity for this period. The start date of the periode. The end date of the periode. Last ASN number. Last ASN date (= the date when the goods have been shipped on the supplier's side). The date when the goods of the last delivery have been received at the customer's side. The quantity received at the customer's side with the last delivery. The date when the goods of the last delivery have been dispached at the supplier's side. The quantity dispached at the supplier's side with the last delivery. Indicator about the purpose of the forecast message - taken from the GIS segment A coded request action for the line item Position number of the entry A detailled description of a certain entry in free-text form. A number uniquely identifying a certain article in the context of the document. The type of the article number is determined by the accompanying attribute. The price of a single unit. Information about the delivery location Referenced documents and date Additional information about the forecasted item Packaging details, related to the forecasted item Packaging identification information requested by the customer - details about the packaging items Planning Quantity Used to identify the type of further information. Currently, the following identification types are used: AdditionalInternalDestination ... Additional destination, mostly provided in a LOC+159 segment DUNS ... DUNS-number FiscalNumber ... fiscal number of party GLN ... Global Location Number/ILN IssuedBySupplier ... ID given by supplier IssuedByCustomer ... ID given by customer Location ... physical location Odette ... ID assigned by ODETTE PlantCode ... plant code StorageLocation ... storage within location StorageCell ... most fine-grained location id (actual shelf / storage bin) TribunalPlaceRegistrationNumber ... Tribunal place registration number (GS1 Code) UnloadingPoint ... unloading point ZZZ ... mutually defined ID by both parties A code, identifying the feature. A description of the feature. The unit of the feature. Incoterm Terms of delivery/transport coded. Please use Edifact code lists, i.e. 1="Price condition", 2="Despatch condition", ... Incoterm coded. Please use INCOTERMS code lists, i.e. CFR="Cost and Freight", EXW="Ex Works", ... Incoterm in clear text. Place relevant to the incoterms. Loading Point relevant to the incoterms. Provides coded information about the forecast item E.g. 36 Changed information (used for Ship Direct suppliers) 37 Complete information or in case of Plastic Omnium 1 = Firm 4 = Planning/forecast Identifies an item with a critical stock amount. These items must be treated with high priority. ID of the invoice recipient issued by the supplier. Free-text description preceding a list line item group. Represent a certain list line item. Represents a list line item used in a despatch advice. Represents a list line item used in a forecast or JIT schedule. Represents a list line item used document based messages. A free-text description suceeding a list line item group. The base amount for the tax (= the amount the tax must be applied to). The tax rate. The tax amount. Calculated using: taxed amount x tax rate = tax amount. The tax amount in the domestic currency. The domestic currency != invoice currency. Free text description of the tax type. Position number, identifing a certain entry. A short description of the item in free-text form. A detailled description of a certain entry in free-text form. Further contact details. A number uniquely identifying a certain article in the context of the document. The type of the article number is determined by the accompanying attribute. The quantity of the given product. The price of a single unit. The VAT tax rate applicable to the given list line item. Used to provide information about other tax on line item level. Indicates, whether a discount may be applied to this line item or not. Used to specify reductions and surcharges on the list line item. Note that both, reductions and surcharges, are always provided as positive values. Used to store information about the delivery itself (such as delivery date, delivery times, etc.) and the delivery party. Supplier's reference to a previously exchanged document (e.g. an order which was preceding a despatch advice). Customer's reference to a previously exchanged document (e.g. an order which was preceding a despatch advice). Used to provide additional information about the line item. The sales value of the given list line item. Extra charge for the given list line item. The tax amount for this line item (gross - net = tax amount) The overall amount for this line item (net value). The ID of the document. The date of the referenced document. A description in free-text form of the referenced document. ID of the ordering party issued by the supplier. DEPRECATED - Please use TaxTypeCode + Item. The type of "other tax" using free-text. DEPRECATED - Please use TaxTypeCode + Item. The amount of "other tax". Code specifying a type of duty, tax or fee. Code list: https://service.unece.org/trade/untdid/d00a/tred/tred5153.htm Storage location of the packaging item at the plant Plant code, where the packaging item is located Storage bin of the packaging item Name of the plan City of the plant The delivery location of the packaging item A plain text description of the product in the packaging item Start of the Kanban number range 1 - Delphi only End of the Kanban number range 1 - Delphi only Date when the payment is due. The duration starting with the document date when the payment is due. Details about discounts. The sum of amounts which have been paid in advance. The outstanding amount that is requested to be paid. The minimum payment which must be paid at the payment due date. A free-text comment for the payment conditions. Free-text comment which may be specified for a payment method. Used to denote details about a bank transaction, via which this invoice has to be paid. Indicates that no payment takes place as a result of this invoice. Indicates that a direct debit will take place as a result of this invoice. Used to denote details about a SEPA direct debit, via which this invoice has to be paid. Used to denote details about a credit card payment, via which this invoice has been settled. Delivery period - from date. Delivery period - to date. The actual quantity, which is forecasted A negative or positive amount indicating whether at the current moment too many or too little components have been delivered An immediate amount which shall be delivered promptly and which as not been communicated earlier The date, when the shipment shall take place The date, when the shipment may take place the earliest The date, when the shipment may take place the latest The end date of the requested weekly delivery amounts Status code, indicating whether the forecast is firm (i.e., items must be delivered) or a foreast Identifier, which indicates the frequency - discrete, flexible intervall (from, to), or weekly A status code, indicating the delivery requirements. E.g. deliver on date or ship complete order Encoded representation of the desired dispatch pattern. E.g. 1 = first week of month, 2 = second week of month, etc. The cumulative requested quantity to the given date. A link to the website of the issuer of the document. A URL to the logo of the issuer of the document. A certain layout id. Indicates whether an amount of 0 shall be shown or not. Used to denote details about the reduction amount. Must be a positive value. Used to denote details about the reduction rate. Number of packages An identification number for the packaging item, assigned by the customer An identification number for the packaging item, assigned by the supplier Capacity of packaging item Used to specify detailled information about a reduction on a list line item. Note that both, reductions and surcharges, are always provided as positive values. Used to specify detailled information about a surcharge on a list line item. Note that both, reductions and surcharges, are always provided as positive values. The base amount to which the reduction/surcharge refers to. The percentage of the reduction/surcharge. The amount of reduction/surcharge. The amount of reduction is calculated by: base amount x percentage = amount. In case amount is specified, it is not necessary to provide percentage (it may, however, be specified). If both, amount and percentage, are present amount is normative. Note that both, reductions and surcharges, are always provided as positive values. Free text for the reudction/surcharge. The type of surcharge or reduction. May be used to aggregate surcharges and reductions into different categories. The VAT rate of the underlying products/services. Details about reductions. Note that both, reductions and surcharges, are always provided as positive values. Details about surcharges. Note that both, reductions and surcharges, are always provided as positive values. Partner's reference to any document (e.g. CallOff, PreviousCallOff, Order, Contract, Release, Agreement). Information regarding the last delivery like ASN number, ASN date, delivery date and quantities. Cumulative Scheduled Quantity. This amount is based on plan data and not on data based on shipped or received amounts. For the last planning period: cumulative received quantity (CRQ) and CRQ start and end date. For the current planning period: cumulative received quantity (CRQ) and CRQ start and end date. Planning horizon start and end date. Details about the material authorization. Details about the production authorization. The type of SEPA direct debit. Bank identifier code International bank account number Owner of the bank account. The creditor ID of the SEPA direct debit. The mandate reference of the SEPA direct debit. The debit collection date. ID of the supplier at the consolidator's side. The ID of the supplier issued by the customer. The VAT code for the used tax rate. Used to provide information about the VAT or a potential tax exemptation (if applicable). Used to provide information about other tax. Transport transit information. Transport stage coded. Please use codes from the Edifact code list, i.e. 1="Inland transport", 12="At departure", ... Transport mode coded. Please use codes from the Edifact code list, UN/ECE Recommendation No 19. Transport means coded. Please use codes from the Edifact code list, i.e. 25="Rail express", 31="Truck", ... Depending on the means of transport (TransportMeansCode), use the registration number (license plate number) of the truck and carriage or swap body number, the ship name or flight number. Identifier of the carrierr. Base quantity to which the unit price is related, i.e. 1, 100, etc. Indicates whether the price is the CalculationNet (including allowances/charges, excluding taxes) or the CalculationGross price (excluding allowances/charges/taxes) . If this attribute is not specified the UnitPrice is considered as CalculationNet price. The type of unit. ERPEL recommends the use of code list UN/ECE recommendation 20. Note, that ERPEL supports both representations for piece: PCE and C62. A list of valid codes may be found under https://docs.ecosio.com/files/Measure_Unit_Qualifiers_6411.pdf The type of unit. ERPEL recommends the use of code list UN/ECE recommendation 20. Note, that ERPEL supports both representations for piece: PCE and C62. A list of valid codes may be found under https://docs.ecosio.com/files/Measure_Unit_Qualifiers_6411.pdf The account of the beneficiary. A payment reference which may be provided in order to allow for an automated processing of the payment. Indicates whether the payment is payable on a consolidator platform. In this case the attribute must be set to true. Reason for the tax exemption. Element used to aggregate certain tax information.