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