ZF2INVPI - Gruppierung von Positionsangaben (Zugferd 2.2.0 + XRechnung)
Spaltenname | Status | Spaltendefinition | Fachbegriff | Spaltenbeschreibung | XML Element | EN16931-ID | Beispiel |
|---|---|---|---|---|---|---|---|
PIKEY | required | VARCHAR(15) | Internal pagination number (i-effect Spalte) | Interne Rechnungsnummer | |||
PIREF | required | DECIMAL(5, 0) | Positionnumber | Kennung der Rechnungsposition | LineID | BT-126 | |
PILISTCO | optional | VARCHAR(15) | Type of the LinePosition | Typ der Rechnungsposition (Code) | LineStatusCode | ||
PILISTRECO | optional | VARCHAR(15) | Under type of the Line Position | Untertyp der Rechnungsposition | LineStatusReasonCode | ||
PIPPPGIC | optional | VARCHAR(35) | Global identifier of the Product | Globaler Identifier des Produktes | |||
PIPPPSID | required wenn PIPPPGIC gefüllt ist. | CHAR(5) | Type of global article number | Art der globalen Artikelnummer | |||
PIPPPSAII | optional | VARCHAR(35) | Product number of the Seller | Artikelnummer des Verkäufers | |||
PIPPPBAII | optional | VARCHAR(35) | Product number of the Buyer | Artikelnummer des Käufers | |||
PIPPPNT | required | VARCHAR(255) | Product name | Artikelbezeichnung | |||
PIPPPDT | optional | VARCHAR(255) | Product description | Artikelbeschreibung | |||
PIPPPOTC | required | CHAR(2) | Origin Trade Country | Artikelherkunftsland | ID | BT-159 | |
PIDOIIO | optional | VARCHAR(35) | Order number | Bestellnummer | IssuerAssignedID | ||
PIDOLIO | optional | INTEGER | Order position | Referenz zur Bestellposition | LineID | BT-132 | |
PIDOIDTO | optional | DATE '0001-01-01' | Order date | Bestelldatum | FormattedIssueDateTime | ||
PICOIIC | optional | VARCHAR(35) | Contract number | Vertragsnummer | IssuerAssignedID | ||
PICOLIC | optional | INTEGER | Contract position | Vertragsposition | LineID | ||
PICOIDTC | optional | DATE '0001-01-01' | Contract date | Vertragsdatum | FormattedIssueDateTime | ||
PIGPCA | required | DECIMAL(15, 4) | Gross price | Bruttopreis des Artikels | ChargeAmount | BT-148 | |
PIGPBQ | optional | INTEGER | Price base amount | Basismenge zum Artikelpreis | BasisQuantity | BT-149 | 1, 10, 100 |
PIGPBQU | required wenn PIGPBQ vorhanden ist. | CHAR(5) | Type of Price base amount | Code der Maßeinheit der Basismenge zum Artikelpreis | unitCode | BT-150 | LTR = Liter (1 dm3) |
PINPCA | required | DECIMAL(15, 4) | Net price | Nettopreis des Artikels | |||
PINPBQ | optional | INTEGER | Price base amount | Basismenge zum Artikelpreis | 1, 10, 100 | ||
PINPBQU | required wenn PINPBQ vorhanden ist. | CHAR(5) | Type of Price base amount | Code der Maßeinheit der Basismenge zum Artikelpreis | LTR = Liter (1 dm3) | ||
PITAXA | required | DECIMAL(15, 2) | Tax amount calculated | Enthaltene Steuer für B2C | CalculatedAmount | ||
PITAXT | required | CHAR(5) | Type of Tax | Enthaltene Steuer für B2C | TypeCode | ||
PITAXFT | optional | VARCHAR(255) | Reason for tax exemption | Enthaltene Steuer für B2C | ExemptionReason | ||
PITAXCAT | required | CHAR(2) | Tax category | Enthaltene Steuer für B2C | CategoryCode | ||
PITAXFTC | optional | CHAR(5) | Reason for tax exemption (CODE) | Code für den Umsatzsteuerbefreiungsgrund | ExemptionReasonCode | ||
PITAXPER | required | DECIMAL(6, 2) | Tax rate | Enthaltene Steuer für B2C | RateApplicablePercent | ||
PIDPTDBQ | required | DECIMAL(15, 4) | Amount, calculated | In Rechnung gestellte Menge | BilledQuantity | BT-129 | |
PIDPTDBQU | required | CHAR(5) | Unit of measurement | Code der Maßeinheit der in Rechnung gestellten Menge | unitCode | BT-130 | LTR = Liter (1 dm3) |
PIDPTDCFQ | optional | DECIMAL(15, 4) | Amount, not calculated | Menge, ohne Berechnung | ChargeFreeQuantity | ||
PIDPTDCFQU | required wenn, PIDPTDCFQ vorhanden ist. | CHAR(5) | Unit of measurement | Maßeinheit | unitCode | C62 | |
PIDPTDPQ | optional | DECIMAL(15, 4) | Number of packages | Anzahl Packstücke | PackageQuantity | ||
PIDPTDPQU | required wenn, PIDPTDPQ vorhanden ist. | CHAR(5) | Unit of measurement | Maßeinheit | unitCode | BX | |
PIWRDID | optional | VARCHAR(35) | Identifier of the were recipients | Identifikation des Warenempfängers | ID | ||
PIWRDGLN | optional | VARCHAR(35) | Global identifier of the were recipients | Globaler Identifier des Warenempfängers | GlobalID | ||
PIWRDGLNT | required wenn PIWRDGLN gefüllt ist. | CHAR(5) | Type of global identifier | Art der globalen Identifikationsnummer | schemeID | ||
PIWRDREC | required | VARCHAR(255) | Company/Name of the were recipients | Name/Firmierung des Warenempfängers | Name | ||
PIWCOMRN | optional | VARCHAR(35) | Identifier of the Organization | Handelsregisternummer | |||
PIWCOMRNT | optional | VARCHAR(10) | Type of number | Art der Nummer | |||
PIWTRBUSIN | optional | VARCHAR(50) | Trading Business name | Handelsname | |||
PIWRDCN | abhängig | VARCHAR(50) | Contact Name of the were recipients | Name des Ansprechpartners | PersonName | ||
PIWRDDN | abhängig | VARCHAR(50) | Department name of the were recipients | Abteilung des Ansprechpartners | DepartmentName | ||
PIWRDTEL | required | VARCHAR(50) | Phone number of the were recipients | Telefonnummer des Ansprechpartners | TelephoneUniversalCommunication | ||
PIWRDFAX | required | VARCHAR(50) | Fax number of the were recipients | Faxnummer des Ansprechpartners | FaxUniversalCommunication | ||
PIWRDMAIL | required | VARCHAR(200) | Mail adress of the were recipients | Emailadresse | URIID | ||
PIWRDPLZ | optional | VARCHAR(10) | ZIP Code of the were recipients | Postleitzahl | PostcodeCode | ||
PIWRDAD1 | optional | VARCHAR(50) | Adress line 1 of the were recipients | Adresszeile 1 | LineOne | ||
PIWRDAD2 | optional | VARCHAR(50) | Adress line 2 of the were recipients | Adresszeile 2 | LineTwo | ||
PIWRDAD3 | optional | VARCHAR(50) | Adress line 3 of the were recipients | Adresszeile 3 | LineThree | ||
PIWRDCITY | optional | VARCHAR(50) | City of the were recipients | Ort | CityName | ||
PIWRDLC | required | CHAR(4) | Country ISO of the were recipients | Land (Code) | CountryID | ||
PIWRDCSDN | optional | VARCHAR(25) | Country federal state | Bundesland | CountrySubDivisionName | ||
PIWURIID | required | VARCHAR(55) | Eletronic address | Elektronischen Adresse | URIID | ||
PIWURIIDT | required | VARCHAR(10) | Eletronic address type | Art der elektronischen Adresse | schemeID | ||
PIWRDSNR | optional | VARCHAR(35) | Taxnumber of the were recipients | Steuernummer | ID | ||
PIWRDASNR | optional | VARCHAR(35) | USTid of the were recipients | Umsatzsteueridentnummer | |||
PIFRDID | optional | VARCHAR(35) | Identifier of the final recipient | Identifikation des Endempfängers | ID | ||
PIFRDGLN | optional | VARCHAR(35) | Global identifier of the final recipient | Globaler Identifier des Endempfängers (GLN) | GlobalID | ||
PIFRDGLNT | required wenn PIFRDGLN gefüllt ist. | CHAR(5) | Type of global identifier | Art der globalen Identifikationsnummer | schemeID | ||
PIFRDREC | required | VARCHAR(255) | Company/Name of the final recipient | Name/Firmierung des Endempfängers | |||
PIFRROID | optional | VARCHAR(35) | Identifier of the Organization | Handelsregisternummer | |||
PIFRROIDT | optional | VARCHAR(10) | Type of number | Art der Nummer | |||
PIFRROTRBN | optional | VARCHAR(50) | Trading Business name | Handelsname | |||
PIFRDCN | optional | VARCHAR(50) | Contact Name of the final recipient | Name des Ansprechpartners | |||
PIFRDDN | optional | VARCHAR(50) | Department name of the final recipient | Abteilung des Ansprechpartners | |||
PIFRDTEL | required | VARCHAR(50) | Phone number of the final recipient | Telefonnummer des Ansprechpartners | CompleteNumber | ||
PIFRDFAX | required | VARCHAR(50) | Fax number of the final recipient | Faxnummer | CompleteNumber | ||
PIFRDMAIL | required | VARCHAR(200) | Mail adress of the final recipient | Emailadresse | URIID | ||
PIFRDPLZ | optional | VARCHAR(10) | ZIP Code of the final recipient | Postleitzahl | PostcodeCode | ||
PIFRDAD1 | optional | VARCHAR(50) | Adress line 1 of the final recipient | Adresszeile 1 | LineOne | ||
PIFRDAD2 | optional | VARCHAR(50) | Adress line 2 of the final recipient | Adresszeile 2 | LineTwo | ||
PIFRDAD3 | optional | VARCHAR(50) | Adress line 3 of the final recipient | Adresszeile 3 | LineThree | ||
PIFRDCITY | optional | VARCHAR(50) | City of the final recipient | Ort | CityName | ||
PIFRDLC | required | CHAR(4) | Country ISO of the final recipient | Land (Code) | CountryID | ||
PIFRDCSDN | optional | VARCHAR(25) | Country federal state | Bundesland | CountrySubDivisionName | ||
PIFRURIID | required | VARCHAR(55) | Eletronic address | Elektronischen Adresse | URIID | ||
PIFRURIIDT | required | VARCHAR(10) | Eletronic address type | Art der elektronischen Adresse | schemeID | ||
PIFRDSNR | optional | VARCHAR(35) | Taxnumber of the final recipient | Steuernummer | ID | ||
PIFRDASNR | optional | VARCHAR(35) | USTid of the final recipient | Umsatzsteueridentnummer | schemeID | ||
PIDELTD | required | DATE '0001-01-01' | Actual Delivery Time | Tatsächlicher Lieferzeitpunkt | OccurrenceDateTime | ||
PIDANR | optional | VARCHAR(35) | Despatch advice number | Lieferavisnummer | IssuerAssignedID | ||
PIDALI | optional | INTEGER | Despatch advice position | Lieferavisposition | LineID | ||
PIDALD | optional | DATE '0001-01-01' | Date of Despatch advice | Lieferavisdatum | FormattedIssueDateTime | ||
PIGRII | optional | VARCHAR(35) | Good receipt number | Wareneingangsnummer | IssuerAssignedID | ||
PIGRDLI | optional | INTEGER | Good receipt positon | Wareneingangsposition | LineID | ||
PIGRIDC | optional | DATE '0001-01-01' | Good receipt date | Wareneingangsdatum | FormattedIssueDateTime | ||
PIDNDII | optional | VARCHAR(35) | Delivery Note number | Lieferscheinnummer | IssuerAssignedID | ||
PIDNDLI | optional | INTEGER | Delivery Note position | Lieferscheinposition | LineID | ||
PIDNIDC | optional | DATE '0001-01-01' | Date of Delivery Note | Lieferscheindatum | FormattedIssueDateTime | ||
PIAPSDT | optional | VARCHAR(15) | Beginning of the accounting period | Beginn der Rechnungsperiode | StartDateTime | ||
PIAPSDTF | required wenn PIAPSDT gefüllt ist. | CHAR(3) | Date Format | Datum, Format | DateTimeString | ||
PIAPEDT | required | VARCHAR(15) | End of the accounting period | Ende der Rechnungsperiode | EndDateTime | ||
PIAPEDTF | required wenn PIAPEDT gefüllt ist. | CHAR(3) | Date Format | Datum, Format | DateTimeString | ||
PIPSTA | required | DECIMAL(15, 2) | Total amount of position | Gesamtpositionsbetrag | Nettobetrag der Rechnungsposition | BT-131 | |
PIPSTACA | optional | DECIMAL(15, 2) | Total amount of position increases and reductions | Gesamtbetrag der Positionszu- und Abschläge | TotalAllowanceChargeAmount | ||
SUBLINELVL | INTEGER | ||||||
PILFD | INTEGER |