|
Column name |
Status |
Column definition |
Technical term |
Column description |
XML Element |
EN16931-ID |
Example |
|---|---|---|---|---|---|---|---|
|
PIKEY |
required |
VARCHAR(15) |
Internal pagination number (i-effect Spalte) |
Internal invoice number |
|
|
|
|
PIREF |
required |
DECIMAL(5, 0) |
Positionnumber |
Invoice item identifier |
LineID |
BT-126 |
|
|
PILISTCO |
optional |
VARCHAR(15) |
Type of the LinePosition |
Invoice item type (code) |
LineStatusCode |
|
|
|
PILISTRECO |
optional |
VARCHAR(15) |
Under type of the Line Position |
Subtype of invoice item |
LineStatusReasonCode |
|
|
|
PIPPPGIC |
optional |
VARCHAR(35) |
Global identifier of the Product |
Global identifier of the product |
|
|
|
|
PIPPPSID |
Required if PIPPPGIC is filled. |
CHAR(5) |
Type of global article number |
Type of global item number |
|
|
|
|
PIPPPSAII |
optional |
VARCHAR(35) |
Product number of the Seller |
Seller's item number |
|
|
|
|
PIPPPBAII |
optional |
VARCHAR(35) |
Product number of the Buyer |
Buyer's item number |
|
|
|
|
PIPPPNT |
required |
VARCHAR(255) |
Product name |
item description |
|
|
|
|
PIPPPDT |
optional |
VARCHAR(255) |
Product description |
Product description |
|
|
|
|
PIPPPOTC |
required |
CHAR(2) |
Origin Trade Country |
Country of origin of the item |
ID |
BT-159 |
|
|
PIDOIIO |
optional |
VARCHAR(35) |
Order number |
order number |
IssuerAssignedID |
|
|
|
PIDOLIO |
optional |
INTEGER |
Order position |
Reference to order item |
LineID |
BT-132 |
|
|
PIDOIDTO |
optional |
DATE '0001-01-01' |
Order date |
order date |
FormattedIssueDateTime |
|
|
|
PICOIIC |
optional |
VARCHAR(35) |
Contract number |
contract number |
IssuerAssignedID |
|
|
|
PICOLIC |
optional |
INTEGER |
Contract position |
contract position |
LineID |
|
|
|
PICOIDTC |
optional |
DATE '0001-01-01' |
Contract date |
contract date |
FormattedIssueDateTime |
|
|
|
PIGPCA |
required |
DECIMAL(15, 4) |
Gross price |
Gross price of the item |
ChargeAmount |
BT-148 |
|
|
PIGPBQ |
optional |
INTEGER |
Price base amount |
Base quantity at item price |
BasisQuantity |
BT-149 |
1, 10, 100 |
|
PIGPBQU |
Required if PIGPBQ is present. |
CHAR(5) |
Type of Price base amount |
Code of the base quantity measurement unit for the item price |
unitCode |
BT-150 |
LTR = litre (1 dm3)
|
|
PINPCA |
required |
DECIMAL(15, 4) |
Net price |
Net price of the item |
|
|
|
|
PINPBQ |
optional |
INTEGER |
Price base amount |
Base quantity at item price |
|
|
1, 10, 100 |
|
PINPBQU |
Required if PINPBQ is present. |
CHAR(5) |
Type of Price base amount |
Code of the base quantity measurement unit for the item price |
|
|
LTR = litre (1 dm3)
|
|
PITAXA |
required |
DECIMAL(15, 2) |
Tax amount calculated |
Tax included for B2C |
CalculatedAmount |
|
|
|
PITAXT |
required |
CHAR(5) |
Type of Tax |
Tax included for B2C |
TypeCode |
|
|
|
PITAXFT |
optional |
VARCHAR(255) |
Reason for tax exemption |
Tax included for B2C |
ExemptionReason |
|
|
|
PITAXCAT |
required |
CHAR(2) |
Tax category |
Tax included for B2C |
CategoryCode |
|
|
|
PITAXFTC |
optional |
CHAR(5) |
Reason for tax exemption (CODE) |
Code for the reason for VAT exemption |
ExemptionReasonCode |
|
|
|
PITAXPER |
required |
DECIMAL(6, 2) |
Tax rate |
Tax included for B2C |
RateApplicablePercent |
|
|
|
PIDPTDBQ |
required |
DECIMAL(15, 4) |
Amount, calculated |
Invoiced quantity |
BilledQuantity |
BT-129 |
|
|
PIDPTDBQU |
required |
CHAR(5) |
Unit of measurement |
Code for the unit of measurement of the quantity invoiced |
unitCode |
BT-130 |
LTR = litre (1 dm3)
|
|
PIDPTDCFQ |
optional |
DECIMAL(15, 4) |
Amount, not calculated |
Quantity, free of charge |
ChargeFreeQuantity |
|
|
|
PIDPTDCFQU |
Required if PIDPTDCFQ is present. |
CHAR(5) |
Unit of measurement |
unit of measurement |
unitCode |
|
C62 |
|
PIDPTDPQ |
optional |
DECIMAL(15, 4) |
Number of packages |
Number of packages |
PackageQuantity |
|
|
|
PIDPTDPQU |
Required if PIDPTDPQ is present. |
CHAR(5) |
Unit of measurement |
unit of measurement |
unitCode |
|
BX |
|
PIWRDID |
optional |
VARCHAR(35) |
Identifier of the were recipients |
Identification of the recipient of the goods |
ID |
|
|
|
PIWRDGLN |
optional |
VARCHAR(35) |
Global identifier of the were recipients |
Globaler Identifier des Warenempfängers |
GlobalID |
|
|
|
PIWRDGLNT |
Required if PIWRDGLN is filled. |
CHAR(5) |
Type of global identifier |
Type of global identification number |
schemeID |
|
|
|
PIWRDREC |
required |
VARCHAR(255) |
Company/Name of the were recipients |
Name/company name of the recipient of the goods |
Name |
|
|
|
PIWCOMRN |
optional |
VARCHAR(35) |
Identifier of the Organization |
Company registration number |
|
|
|
|
PIWCOMRNT |
optional |
VARCHAR(10) |
Type of number |
Type of number |
|
|
|
|
PIWTRBUSIN |
optional |
VARCHAR(50) |
Trading Business name |
trade name |
|
|
|
|
PIWRDCN |
dependent |
VARCHAR(50) |
Contact Name of the were recipients |
Name of contact person |
PersonName |
|
|
|
PIWRDDN |
dependent |
VARCHAR(50) |
Department name of the were recipients |
Department of the contact person |
DepartmentName |
|
|
|
PIWRDTEL |
required |
VARCHAR(50) |
Phone number of the were recipients |
Contact person's telephone number |
TelephoneUniversalCommunication |
|
|
|
PIWRDFAX |
required |
VARCHAR(50) |
Fax number of the were recipients |
Contact person's fax number |
FaxUniversalCommunication |
|
|
|
PIWRDMAIL |
required |
VARCHAR(200) |
Mail adress of the were recipients |
Email address |
URIID |
|
|
|
PIWRDPLZ |
optional |
VARCHAR(10) |
ZIP Code of the were recipients |
postcode |
PostcodeCode |
|
|
|
PIWRDAD1 |
optional |
VARCHAR(50) |
Adress line 1 of the were recipients |
Address line 1 |
LineOne |
|
|
|
PIWRDAD2 |
optional |
VARCHAR(50) |
Adress line 2 of the were recipients |
Address line 2 |
LineTwo |
|
|
|
PIWRDAD3 |
optional |
VARCHAR(50) |
Adress line 3 of the were recipients |
Address line 3 |
LineThree |
|
|
|
PIWRDCITY |
optional |
VARCHAR(50) |
City of the were recipients |
City |
CityName |
|
|
|
PIWRDLC |
required |
CHAR(4) |
Country ISO of the were recipients |
Country (Code) |
CountryID |
|
|
|
PIWRDCSDN |
optional |
VARCHAR(25) |
Country federal state |
state |
CountrySubDivisionName |
|
|
|
PIWURIID |
required |
VARCHAR(55) |
Eletronic address |
Electronic address |
URIID |
|
|
|
PIWURIIDT |
required |
VARCHAR(10) |
Eletronic address type |
Type of electronic address |
schemeID |
|
|
|
PIWRDSNR |
optional |
VARCHAR(35) |
Taxnumber of the were recipients |
tax number |
ID |
|
|
|
PIWRDASNR |
optional |
VARCHAR(35) |
USTid of the were recipients |
VAT number |
|
|
|
|
PIFRDID |
optional |
VARCHAR(35) |
Identifier of the final recipient |
Identification of the final recipient |
ID |
|
|
|
PIFRDGLN |
optional |
VARCHAR(35) |
Global identifier of the final recipient |
Global identifier of the end recipient (GLN) |
GlobalID |
|
|
|
PIFRDGLNT |
Required if PIFRDGLN is filled. |
CHAR(5) |
Type of global identifier |
Type of global identification number |
schemeID |
|
|
|
PIFRDREC |
required |
VARCHAR(255) |
Company/Name of the final recipient |
Name/company name of the final recipient |
|
|
|
|
PIFRROID |
optional |
VARCHAR(35) |
Identifier of the Organization |
Company registration number |
|
|
|
|
PIFRROIDT |
optional |
VARCHAR(10) |
Type of number |
Type of number |
|
|
|
|
PIFRROTRBN |
optional |
VARCHAR(50) |
Trading Business name |
trade name |
|
|
|
|
PIFRDCN |
optional |
VARCHAR(50) |
Contact Name of the final recipient |
Name of contact person |
|
|
|
|
PIFRDDN |
optional |
VARCHAR(50) |
Department name of the final recipient |
Department of the contact person |
|
|
|
|
PIFRDTEL |
required |
VARCHAR(50) |
Phone number of the final recipient |
Contact person's telephone number |
CompleteNumber |
|
|
|
PIFRDFAX |
required |
VARCHAR(50) |
Fax number of the final recipient |
fax number |
CompleteNumber |
|
|
|
PIFRDMAIL |
required |
VARCHAR(200) |
Mail adress of the final recipient |
Email address |
URIID |
|
|
|
PIFRDPLZ |
optional |
VARCHAR(10) |
ZIP Code of the final recipient |
postcode |
PostcodeCode |
|
|
|
PIFRDAD1 |
optional |
VARCHAR(50) |
Adress line 1 of the final recipient |
Address line 1 |
LineOne |
|
|
|
PIFRDAD2 |
optional |
VARCHAR(50) |
Adress line 2 of the final recipient |
Address line 2 |
LineTwo |
|
|
|
PIFRDAD3 |
optional |
VARCHAR(50) |
Adress line 3 of the final recipient |
Address line 3 |
LineThree |
|
|
|
PIFRDCITY |
optional |
VARCHAR(50) |
City of the final recipient |
City |
CityName |
|
|
|
PIFRDLC |
required |
CHAR(4) |
Country ISO of the final recipient |
Country (Code) |
CountryID |
|
|
|
PIFRDCSDN |
optional |
VARCHAR(25) |
Country federal state |
state |
CountrySubDivisionName |
|
|
|
PIFRURIID |
required |
VARCHAR(55) |
Eletronic address |
Electronic address |
URIID |
|
|
|
PIFRURIIDT |
required |
VARCHAR(10) |
Eletronic address type |
Type of electronic address |
schemeID |
|
|
|
PIFRDSNR |
optional |
VARCHAR(35) |
Taxnumber of the final recipient |
tax number |
ID |
|
|
|
PIFRDASNR |
optional |
VARCHAR(35) |
USTid of the final recipient |
VAT number |
schemeID |
|
|
|
PIDELTD |
required |
DATE '0001-01-01' |
Actual Delivery Time |
Actual delivery date |
OccurrenceDateTime |
|
|
|
PIDANR |
optional |
VARCHAR(35) |
Despatch advice number |
delivery notification number |
IssuerAssignedID |
|
|
|
PIDALI |
optional |
INTEGER |
Despatch advice position |
delivery notification item |
LineID |
|
|
|
PIDALD |
optional |
DATE '0001-01-01' |
Date of Despatch advice |
delivery notification date |
FormattedIssueDateTime |
|
|
|
PIGRII |
optional |
VARCHAR(35) |
Good receipt number |
goods receipt number |
IssuerAssignedID |
|
|
|
PIGRDLI |
optional |
INTEGER |
Good receipt positon |
goods receipt item |
LineID |
|
|
|
PIGRIDC |
optional |
DATE '0001-01-01' |
Good receipt date |
date of receipt of goods |
FormattedIssueDateTime |
|
|
|
PIDNDII |
optional |
VARCHAR(35) |
Delivery Note number |
delivery note number |
IssuerAssignedID |
|
|
|
PIDNDLI |
optional |
INTEGER |
Delivery Note position |
delivery note item |
LineID |
|
|
|
PIDNIDC |
optional |
DATE '0001-01-01' |
Date of Delivery Note |
delivery note date |
FormattedIssueDateTime |
|
|
|
PIAPSDT |
optional |
VARCHAR(15) |
Beginning of the accounting period |
Start of the accounting period |
StartDateTime |
|
|
|
PIAPSDTF |
required wenn PIAPSDT gefüllt ist. |
CHAR(3) |
Date Format |
Date, Format |
DateTimeString |
|
|
|
PIAPEDT |
required |
VARCHAR(15) |
End of the accounting period |
end of the accounting period |
EndDateTime |
|
|
|
PIAPEDTF |
required wenn PIAPEDT gefüllt ist. |
CHAR(3) |
Date Format |
Date, Format |
DateTimeString |
|
|
|
PIPSTA |
required |
DECIMAL(15, 2) |
Total amount of position |
total position amount |
Nettobetrag der Rechnungsposition |
BT-131 |
|
|
PIPSTACA |
optional |
DECIMAL(15, 2) |
Total amount of position increases and reductions |
Total amount of position surcharges and discounts |
TotalAllowanceChargeAmount |
|
|
|
SUBLINELVL |
|
INTEGER |
|
|
|
|
|
|
PILFD |
|
INTEGER |
|
|
|
|
|