ZF2INVPI - Grouping of position information (Zugferd 2.2.0 + XRechnung)
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 |