ZF23INVPI - Gruppierung von Positionsangaben

PIKEY

required

VARCHAR(15)

Reference to ZF23INVHT.HTKEY

Unique auto generated identifier

PIREF

required

VARCHAR(100)

Invoice line identifier

A unique identifier for the individual line within the Invoice.

PIDOLIO

optional

VARCHAR (100)

Referenced purchase order line reference

An identifier for a referenced line within a purchase order, issued by the Buyer.

PILFD

optional

INTEGER

Sequence

Ascending sequence for every line item

PILISTCO

optional

VARCHAR(15)

Type of the inovice line item (Code)

Indicating whether an item includes the prices which must be taken into account when calculating the invoice amount, or whether it only contains information.

PILISTRECO

optional

VARCHAR(15)

Subtype of the invoice line item

Complements the type to clarify whether the invoice item is one of the following: - Detail (default positioning) - Subtotal - Solely information

PISUBLVL

required

INTEGER

Subline level

A number indicating the level of a line. 0 = Main level

PIPPPID

optional

VARCHAR(35)

Product identifier

This identifier can be additionally specified to be interoperable with Order-X.

PIPPPGIC

optional

VARCHAR(35)

Item standard identifier

An item identifier based on a registered scheme.

PIPPPSID

required wenn PIPPPGIC gefüllt ist.

CHAR(5)

Scheme identifier

The identification scheme identifier of the Item standard identifier

PIPPPSAII

optional

VARCHAR(35)

Item Seller's identifier

An identifier, assigned by the Seller, for the item.

PIPPPBAII

optional

VARCHAR(35)

Item Buyer's identifier

An identifier, assigned by the Buyer, for the item.

PIPPPNT

required

VARCHAR(255)

Item name

A name for an item.

PIPPPDT

optional

VARCHAR(255)

Item description

A description for an item.

PIPPPOTC

required

CHAR(2)

Item country of origin

The code identifying the country from which the item originates.

PIDOIIO

optional

VARCHAR(35)

Order Id

PIDOIDTO

optional

DATE '0001-01-01'

Order date, value

PICOIIC

optional

VARCHAR(35)

Contract number

PICOLIC

optional

INTEGER

Contract position

PICOIDTC

optional

DATE '0001-01-01'

Contract Date, value

PIGPCA

required

DECIMAL(15, 4)

Item gross price

The unit price, exclusive of VAT, before subtracting Item price discount.

PIGPBQ

optional

INTEGER

Item price base quantity

The number of item units to which the price applies.

PIGPBQU

required wenn PIGPBQ vorhanden ist.

CHAR(5)

Item price base quantity unit of measure code

The unit of measure that applies to the Item price base quantity.

PINPCA

required

DECIMAL(15, 9)

Item net price

The price of an item, exclusive of VAT, after subtracting item price discount.

PINPBQ

optional

INTEGER

Item price base quantity

The number of item units to which the price applies.

PINPBQU

required wenn PINPBQ vorhanden ist.

CHAR(5)

Item price base quantity unit of measure code

The unit of measure that applies to the Item price base quantity.

PITAXA

required

DECIMAL(15, 2)

Included tax for B2C

PITAXT

required

CHAR(5)

Type of tax (code)

PITAXFT

optional

VARCHAR(255)

VAT exemption reason text

A textual statement of the reason why the amount is exempted from VAT or why no VAT is being charged

PITAXCAT

required

CHAR(2)

VAT category code

Coded identification of a VAT category.

PITAXFTC

optional

CHAR(5)

VAT exemption reason code

A coded statement of the reason for why the amount is exempted from VAT.

PITAXPER

required

DECIMAL(6, 2)

VAT category rate

The VAT rate, represented as percentage that applies for the relevant VAT category.

PIDPTDBQ

required

DECIMAL(15, 4)

Invoiced quantity

The quantity of items (goods or services) that is charged in the Invoice line.

PIDPTDBQU

required

CHAR(5)

Invoiced quantity unit of measure

The unit of measure that applies to the invoiced quantity.

PIDPTDCFQ

optional

DECIMAL(15, 4)

Quantity, without charge

PIDPTDCFQU

required wenn, PIDPTDCFQ vorhanden ist.

CHAR(5)

Unit of measure

PIDPTDPQ

optional

DECIMAL(15, 4)

Package quantity

PIDPTDPQU

required wenn, PIDPTDPQ vorhanden ist.

CHAR(5)

Unit of measure

PIFRDID

optional

VARCHAR(35)

Identifier of the final recipient

Identifikation des Endempfängers

PIDELTD

required

DATE '0001-01-01'

Actual delivery date for this line, value

PIDANR

optional

VARCHAR(35)

Despatch advice number

PIDALI

optional

INTEGER

Despatch advice item

PIDALD

optional

DATE '0001-01-01'

Document date, value

PIGRII

optional

VARCHAR(35)

Goods receipt number

PIGRDLI

optional

INTEGER

Goods receipt item

PIGRIDC

optional

DATE '0001-01-01'

Document date, value

PIDNDII

optional

VARCHAR(35)

Delivery Note Number

PIDNDLI

optional

INTEGER

Delivery note item

PIDNIDC

optional

DATE '0001-01-01'

Document date, value

PIAPSDT

optional

VARCHAR(15)

Invoice line period start date

The date when the Invoice period for this Invoice line starts.

PIAPSDTF

required wenn PIAPSDT gefüllt ist.

CHAR(3)

Date, format

PIAPEDT

required

VARCHAR(15)

Invoice line period end date

The date when the Invoice period for this Invoice line ends.

PIAPEDTF

required wenn PIAPEDT gefüllt ist.

CHAR(3)

Date, format

PIPSTA

required

DECIMAL(15, 2)

Invoice line net amount

The total amount of the Invoice line.

PIPSTACA

optional

DECIMAL(15, 2)

Total amount of allowances / charges

PIREF

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:AssociatedDocumentLineDocument/ram:LineID

BT-126

PILISTCO

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:AssociatedDocumentLineDocument/ram:LineStatusCode

BT-X-7

Use codes from codelist UNTDID 1229. The following code should be applied per default: 39

PILISTRECO

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:AssociatedDocumentLineDocument/ram:LineStatusReasonCode

BT-X-8

If the LineStatusCode element is used, the LineStatusReasonCode must be filled in: DETAIL, GROUP, INFORMATION

PIPPPGIC

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedTradeProduct/ram:GlobalID

BT-157

PIPPPSID

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedTradeProduct/ram:GlobalID/@schemeID

BT-157-1

The identification scheme shall be identified from the entries of the list published by the ISO/IEC 6523 maintenance agency.

PIPPPSAII

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedTradeProduct/ram:SellerAssignedID

BT-155

PIPPPBAII

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedTradeProduct/ram:BuyerAssignedID

BT-156

PIPPPNT

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedTradeProduct/ram:Name

BT-153

PIPPPDT

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedTradeProduct/ram:Description

BT-154

The Item description allows for describing the item and its features in more detail than the Item name.

PIPPPOTC

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedTradeProduct/ram:OriginTradeCountry/ram:ID

BT-159

The lists of valid countries are registered with the ISO 3166-1 Maintenance agency, "Codes for the representation of names of countries and their subdivisions".

PIDOIIO

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeAgreement/ram:BuyerOrderReferencedDocument/ram:IssuerAssignedID

BT-X-21

PIDOLIO

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeAgreement/ram:BuyerOrderReferencedDocument/ram:LineID

BT-132

The purchase order identifier is referenced on document level.

PIDOIDTO

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeAgreement/ram:BuyerOrderReferencedDocument/ram:FormattedIssueDateTime/qdt:DateTimeString

BT-X-22

PICOIIC

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeAgreement/ram:ContractReferencedDocument/ram:IssuerAssignedID

BT-X-24

PICOLIC

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeAgreement/ram:ContractReferencedDocument/ram:LineID

BT-X-25

PICOIDTC

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeAgreement/ram:ContractReferencedDocument/ram:FormattedIssueDateTime/qdt:DateTimeString

BT-X-26

PIGPCA

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeAgreement/ram:GrossPriceProductTradePrice/ram:ChargeAmount

BT-148

PIGPBQ

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeAgreement/ram:NetPriceProductTradePrice/ram:BasisQuantity

BT-149

PIGPBQU

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeAgreement/ram:NetPriceProductTradePrice/ram:BasisQuantity/@unitCode

BT-150

The Item price base quantity unit of measure shall be the same as the Invoiced quantity unit of measure (BT-130).

PINPCA

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeAgreement/ram:NetPriceProductTradePrice/ram:ChargeAmount

BT-146

The Item net price has to be equal with the Item gross price less the Item price discount.

PINPBQ

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeAgreement/ram:NetPriceProductTradePrice/ram:BasisQuantity

BT-149

PINPBQU

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeAgreement/ram:NetPriceProductTradePrice/ram:BasisQuantity/@unitCode

BT-150

The Item price base quantity unit of measure shall be the same as the Invoiced quantity unit of measure (BT-130).

PITAXA

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeAgreement/ram:NetPriceProductTradePrice/ram:IncludedTradeTax/ram:CalculatedAmount

BT-X-37

PITAXT

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeAgreement/ram:NetPriceProductTradePrice/ram:IncludedTradeTax/ram:TypeCode

BT-X-38

Fixed value = "VAT"

PITAXFT

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeAgreement/ram:NetPriceProductTradePrice/ram:IncludedTradeTax/ram:ExemptionReason

BT-X-39

PITAXCAT

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeAgreement/ram:NetPriceProductTradePrice/ram:IncludedTradeTax/ram:CategoryCode

BT-X-40

The following entries of UNTDID 5305 [6] are used (further clarification between brackets): - Standard rate (Liable for VAT in a standard way) - Zero rated goods (Liable for VAT with a percentage rate of zero) - Exempt from tax (VAT/IGIC/IPSI) - VAT Reverse Charge (Reverse charge VAT/IGIC/IPSI rules apply) - VAT exempt for intra community supply of goods (VAT/IGIC/IPSI not levied due to Intra-community supply rules) - Free export item, tax not charged (VAT/IGIC/IPSI not levied due to export outside of the EU) - Services outside scope of tax (Sale is not subject to VAT/IGIC/IPSI) - Canary Islands General Indirect Tax (Liable for IGIC tax) - Liable for IPSI (Ceuta/Melilla tax)

PITAXFTC

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeAgreement/ram:NetPriceProductTradePrice/ram:IncludedTradeTax/ram:ExemptionReasonCode

BT-X-41

Code list issued and maintained by the Connecting Europe Facility.

PITAXPER

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeAgreement/ram:NetPriceProductTradePrice/ram:IncludedTradeTax/ram:RateApplicablePercent

BT-X-42

The VAT category code and the VAT category rate shall be consistent.

PIDPTDBQ

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:BilledQuantity

BT-129

PIDPTDBQU

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:BilledQuantity/@unitCode

BT-130

The unit of measure shall be chosen from the lists in UN/ECE Recommendation N°. 20 “Codes for Units of Measure Used in International Trade” [7] and UN/ECE Recommendation N° 21 “Codes for Passengers, Types of Cargo, Packages and Packaging Materials (with Complementary Codes for Package Names)” [19] applying the method described in UN/ECE Rec N° 20 Intro 2.a). Note that in most cases it is not needed for Buyers and Sellers to implement these lists fully in their software. Sellers need only to support the units needed for their goods and services; Buyers only need to verify that the units used in the Invoice are equal to the units used in other documents (such as Contract, Catalogue, Order and Despatch advice).

PIDPTDCFQ

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:ChargeFreeQuantity

BT-X-46

PIDPTDCFQU

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:ChargeFreeQuantity/@unitCode

BT-X-46-0

C62

PIDPTDPQ

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:PackageQuantity

BT-X-47

PIDPTDPQU

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:PackageQuantity/@unitCode

BT-X-47-0

PIFRDID

ID

PIDELTD

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:ActualDeliverySupplyChainEvent/ram:OccurrenceDateTime/udt:DateTimeString

BT-X-85

The VAT relevant date of delivery and achievement must be specified on the level of document.

PIDANR

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:DespatchAdviceReferencedDocument/ram:IssuerAssignedID

BT-X-86

PIDALI

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:DespatchAdviceReferencedDocument/ram:LineID

BT-X-87

PIDALD

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:DespatchAdviceReferencedDocument/ram:FormattedIssueDateTime/qdt:DateTimeString

BT-X-88

PIGRII

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:ReceivingAdviceReferencedDocument/ram:IssuerAssignedID

BT-X-89

PIGRDLI

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:ReceivingAdviceReferencedDocument/ram:LineID

BT-X-90

PIGRIDC

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:ReceivingAdviceReferencedDocument/ram:FormattedIssueDateTime/qdt:DateTimeString

BT-X-91

PIDNDII

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:DeliveryNoteReferencedDocument/ram:IssuerAssignedID

BT-X-92

PIDNDLI

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:DeliveryNoteReferencedDocument/ram:LineID

BT-X-93

PIDNIDC

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:DeliveryNoteReferencedDocument/ram:FormattedIssueDateTime/qdt:DateTimeString

BT-X-94

PIAPSDT

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeSettlement/ram:BillingSpecifiedPeriod/ram:StartDateTime/udt:DateTimeString

BT-134

The date is the first day of the period.

PIAPSDTF

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeSettlement/ram:BillingSpecifiedPeriod/ram:StartDateTime/udt:DateTimeString/@format

BT-134-0

Only value "102"

PIAPEDT

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeSettlement/ram:BillingSpecifiedPeriod/ram:EndDateTime/udt:DateTimeString

BT-135

The date is the last day of the period.

PIAPEDTF

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeSettlement/ram:BillingSpecifiedPeriod/ram:EndDateTime/udt:DateTimeString/@format

BT-135-0

Only value "102"

PIPSTA

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeSettlement/ram:SpecifiedTradeSettlementLineMonetarySummation/ram:LineTotalAmount

BT-131

The amount is “net” without VAT, i.e. inclusive of line level allowances and charges as well as other relevant taxes.

PIPSTACA

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeSettlement/ram:SpecifiedTradeSettlementLineMonetarySummation/ram:TotalAllowanceChargeAmount

BT-X-98

PIPPPID

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedTradeProduct/ram:ID

BT-X-305