This database table consists of the following fields
|
Column Name |
Status |
Column definition |
Technical term |
Description |
|---|---|---|---|---|
|
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. |
|
PIPARENTID |
optional |
VARCHAR(100) |
Parent line identifier |
A hierarchical parent-child relationship between invoice items. It specifies which parent item (LineID=PIREF) a child item belongs to. |
|
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(4) |
Sequence |
Ascending sequence for every line item (1, 2, 3…..) Used to link this line to the underlaying tables |
|
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(4) |
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(1000) |
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(4) |
Contract position |
|
|
PICOIDTC |
optional |
DATE '0001-01-01' |
Contract Date, value |
|
|
PIGPCA |
required |
DECIMAL(15) |
Item gross price |
The unit price, exclusive of VAT, before subtracting Item price discount. |
|
PIGPBQ |
optional |
INTEGER(4) |
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(20) |
Item net price |
The price of an item, exclusive of VAT, after subtracting item price discount. |
|
PINPBQ |
optional |
INTEGER(4) |
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) |
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) |
VAT category rate |
The VAT rate, represented as percentage that applies for the relevant VAT category. |
|
PIDPTDBQ |
required |
DECIMAL(15) |
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) |
Quantity, without charge |
|
|
PIDPTDCFQU |
required wenn, PIDPTDCFQ vorhanden ist. |
CHAR(5) |
Unit of measure |
|
|
PIDPTDPQ |
optional |
DECIMAL(15) |
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(4) |
Despatch advice item |
|
|
PIDALD |
optional |
DATE '0001-01-01' |
Document date, value |
|
|
PIGRII |
optional |
VARCHAR(35) |
Goods receipt number |
|
|
PIGRDLI |
optional |
INTEGER(4) |
Goods receipt item |
|
|
PIGRIDC |
optional |
DATE '0001-01-01' |
Document date, value |
|
|
PIDNDII |
optional |
VARCHAR(35) |
Delivery Note Number |
|
|
PIDNDLI |
optional |
INTEGER(4) |
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) |
Invoice line net amount |
The total amount of the Invoice line. |
|
PIPSTACA |
optional |
DECIMAL(15) |
Total amount of allowances / charges |
|
|
PIWRDID |
|
VARCHAR(35) |
Goods recipient identifier |
|
|
PIWRDGLN |
|
VARCHAR(35) |
Goods recipient global identifier |
|
|
PIWRDGLNT |
|
CHAR(5) |
Scheme identifier |
|
|
PIWRDREC |
|
VARCHAR(255) |
ShipTo name |
|
|
PIWCOMRN |
|
VARCHAR(35) |
ShipTo Legal ID |
An identifier issued by an official registrar that identifies the party as a legal entity or person. |
|
PIWCOMRNT |
|
VARCHAR(10) |
Scheme identifier |
The identification scheme identifier of the Buyer legal registration identifier. |
|
PIWTRBUSIN |
|
VARCHAR(50) |
Trading Business Name |
A name by which the party is known, other than party name (also known as business name). |
|
PIWRDCN |
|
VARCHAR(50) |
Name of the contact |
|
|
PIWRDDN |
|
VARCHAR(50) |
Department name |
|
|
PIWRDTEL |
|
VARCHAR(50) |
Contact telephone number, value |
A phone number for the contact point. |
|
PIWRDFAX |
|
VARCHAR(50) |
Contact point fax number, value |
|
|
PIWRDMAIL |
|
VARCHAR(200) |
Contact email address, value |
An e-mail address for the contact point. |
|
PIWRDPLZ |
|
VARCHAR(10) |
Post code |
The identifier for an addressable group of properties according to the relevant postal service. |
|
PIWRDAD1 |
|
VARCHAR(50) |
Address line 1 |
The main address line in an address. |
|
PIWRDAD2 |
|
VARCHAR(50) |
Address line 2 |
An additional address line in an address that can be used to give further details supplementing the main line. |
|
PIWRDAD3 |
|
VARCHAR(50) |
Address line 3 |
An additional address line in an address that can be used to give further details supplementing the main line. |
|
PIWRDCITY |
|
VARCHAR(50) |
City |
The common name of the city, town or village. |
|
PIWRDLC |
|
CHAR(4) |
Country code |
A code that identifies the country. |
|
PIWRDCSDN |
|
VARCHAR(25) |
Country subdivision |
The subdivision of a country. |
|
PIWURIID |
|
VARCHAR(55) |
Electronic address |
|
|
PIWURIIDT |
|
VARCHAR(10) |
Scheme identifier |
|
|
PIWRDSNR |
|
VARCHAR(35) |
VAT ID |
|
|
|
|
|
Tax Scheme identifier |
|
|
PIWRDASNR |
|
VARCHAR(35) |
VAT ID |
|
|
|
|
|
Tax Scheme identifier |
|
|
PIFRDGLN |
|
VARCHAR(35) |
Final recipient global identifier |
|
|
PIFRDGLNT |
|
CHAR(5) |
Scheme identifier |
|
|
PIFRDREC |
|
VARCHAR(255) |
Final Recipient Name / Company Name |
|
|
PIFRROID |
|
VARCHAR(35) |
Company Registration Number |
An identifier issued by an official registrar that identifies the party as a legal entity or person. |
|
PIFRROIDT |
|
VARCHAR(10) |
Scheme identifier |
The identification scheme identifier of the Buyer legal registration identifier. |
|
PIFRROTRBN |
|
VARCHAR(50) |
Trading Business Name |
A name by which the party is known, other than party name (also known as business name). |
|
PIFRDCN |
|
VARCHAR(50) |
Name of the contact |
|
|
PIFRDDN |
|
VARCHAR(50) |
Department name |
|
|
PIFRDTEL |
|
VARCHAR(50) |
Contact telephone number, value |
A phone number for the contact point. |
|
PIFRDFAX |
|
VARCHAR(50) |
Contact point fax number, value |
|
|
PIFRDMAIL |
|
VARCHAR(200) |
Contact email address, value |
An e-mail address for the contact point. |
|
PIFRDPLZ |
|
VARCHAR(10) |
Post code |
The identifier for an addressable group of properties according to the relevant postal service. |
|
PIFRDAD1 |
|
VARCHAR(50) |
Address line 1 |
The main address line in an address. |
|
PIFRDAD2 |
|
VARCHAR(50) |
Address line 2 |
An additional address line in an address that can be used to give further details supplementing the main line. |
|
PIFRDAD3 |
|
VARCHAR(50) |
Address line 3 |
An additional address line in an address that can be used to give further details supplementing the main line. |
|
PIFRDCITY |
|
VARCHAR(50) |
City |
The common name of the city, town or village. |
|
PIFRDLC |
|
CHAR(4) |
Country code |
A code that identifies the country. |
|
PIFRDCSDN |
|
VARCHAR(25) |
Country subdivision |
The subdivision of a country. |
|
PIFRURIID |
|
VARCHAR(55) |
Electronic address |
|
|
PIFRURIIDT |
|
VARCHAR(10) |
Scheme identifier |
|
|
PIFRDSNR |
|
VARCHAR(35) |
VAT ID |
|
|
|
|
|
Tax Scheme identifier |
|
|
PIFRDASNR |
|
VARCHAR(35) |
VAT ID |
|
|
|
|
|
Tax Scheme identifier |
|
The following list contains the business rule numbers corresponding to the fields, the XML target elements and further explanations.
|
Column name |
XML Element |
EN16931-ID |
Example |
Info |
|---|---|---|---|---|
|
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 |
|
|
|
PIWRDID |
rsm:CrossIndustryInvoice;rsm:SupplyChainTradeTransaction;ram:IncludedSupplyChainTradeLineItem;ram:SpecifiedLineTradeDelivery;ram:ShipToTradeParty;ram:ID |
BT-X-48 |
A previously exchanged assigned identifier of the business partner. |
|
|
PIWRDGLN |
rsm:CrossIndustryInvoice;rsm:SupplyChainTradeTransaction;ram:IncludedSupplyChainTradeLineItem;ram:SpecifiedLineTradeDelivery;ram:ShipToTradeParty;ram:GlobalID |
BT-X-49 |
GlobalID, if a global identifier exists and can be determined in the @schemeID, otherwise use ID |
|
|
PIWRDGLNT |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:ShipToTradeParty/ram:GlobalID/@schemeID |
BT-X-49-0 |
If used, the identification scheme shall be chosen from the entries of the list published by the ISO/IEC 6523 maintenance agency. |
|
|
PIWRDREC |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:ShipToTradeParty/ram:Name |
BT-X-50 |
|
|
|
PIWCOMRN |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:ShipToTradeParty/ram:SpecifiedLegalOrganization/ram:ID |
BT-X-51 |
|
|
|
PIWCOMRNT |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:ShipToTradeParty/ram:SpecifiedLegalOrganization/ram:ID/@schemeID |
BT-X-51-0 |
If used, the identification scheme shall be chosen from the entries of the list published by the ISO 6523 maintenance agency. |
|
|
PIWTRBUSIN |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:ShipToTradeParty/ram:SpecifiedLegalOrganization/ram:TradingBusinessName |
BT-X-52 |
This may be used if different from the party name. |
|
|
PIWRDCN |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:ShipToTradeParty/ram:DefinedTradeContact/ram:PersonName |
BT-X-54 |
If a contact person is indicated, either the name or the department is to be transmitted. |
|
|
PIWRDDN |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:ShipToTradeParty/ram:DefinedTradeContact/ram:DepartmentName |
BT-X-54-1 |
If a contact person is indicated, either the name or the department is to be transmitted. |
|
|
PIWRDTEL |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:ShipToTradeParty/ram:DefinedTradeContact/ram:TelephoneUniversalCommunication/ram:CompleteNumber |
BT-X-55 |
|
|
|
PIWRDFAX |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:ShipToTradeParty/ram:DefinedTradeContact/ram:FaxUniversalCommunication/ram:CompleteNumber |
BT-X-56 |
|
|
|
PIWRDMAIL |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:ShipToTradeParty/ram:DefinedTradeContact/ram:EmailURIUniversalCommunication/ram:URIID |
BT-X-57 |
|
|
|
PIWRDPLZ |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:ShipToTradeParty/ram:PostalTradeAddress/ram:PostcodeCode |
BT-X-58 |
Such as a ZIP code or a post code. |
|
|
PIWRDAD1 |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:ShipToTradeParty/ram:PostalTradeAddress/ram:LineOne |
BT-X-59 |
|
|
|
PIWRDAD2 |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:ShipToTradeParty/ram:PostalTradeAddress/ram:LineTwo |
BT-X-60 |
|
|
|
PIWRDAD3 |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:ShipToTradeParty/ram:PostalTradeAddress/ram:LineThree |
BT-X-61 |
|
|
|
PIWRDCITY |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:ShipToTradeParty/ram:PostalTradeAddress/ram:CityName |
BT-X-62 |
|
|
|
PIWRDLC |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:ShipToTradeParty/ram:PostalTradeAddress/ram:CountryID |
BT-X-63 |
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". |
|
|
PIWRDCSDN |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:ShipToTradeParty/ram:PostalTradeAddress/ram:CountrySubDivisionName |
BT-X-64 |
Such as a region, a county, a state, a province, etc. |
|
|
PIWURIID |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:ShipToTradeParty/ram:URIUniversalCommunication/ram:URIID |
BT-X-65 |
|
|
|
PIWURIIDT |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:ShipToTradeParty/ram:URIUniversalCommunication/ram:URIID/@schemeID |
BT-X-65-0 |
|
|
|
PIWRDSNR |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:ShipToTradeParty/ram:SpecifiedTaxRegistration/ram:ID |
BT-X-66 |
|
|
|
|
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:ShipToTradeParty/ram:SpecifiedTaxRegistration/ram:ID/@schemeID |
BT-X-66-0 |
VA = VAT ID |
|
|
PIWRDASNR |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:ShipToTradeParty/ram:SpecifiedTaxRegistration/ram:ID |
BT-X-66 |
|
|
|
|
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:ShipToTradeParty/ram:SpecifiedTaxRegistration/ram:ID/@schemeID |
BT-X-66-0 |
VA = VAT ID |
|
|
PIFRDGLN |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:UltimateShipToTradeParty/ram:GlobalID |
BT-X-68 |
GlobalID, if a global identifier exists and can be determined in the @schemeID, otherwise use ID |
|
|
PIFRDGLNT |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:UltimateShipToTradeParty/ram:GlobalID/@schemeID |
BT-X-68-0 |
If used, the identification scheme shall be chosen from the entries of the list published by the ISO/IEC 6523 maintenance agency. |
|
|
PIFRDREC |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:UltimateShipToTradeParty/ram:Name |
BT-X-69 |
|
|
|
PIFRROID |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:UltimateShipToTradeParty/ram:SpecifiedLegalOrganization/ram:ID |
BT-X-70 |
|
|
|
PIFRROIDT |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:UltimateShipToTradeParty/ram:SpecifiedLegalOrganization/ram:ID/@schemeID |
BT-X-70-0 |
If used, the identification scheme shall be chosen from the entries of the list published by the ISO 6523 maintenance agency. |
|
|
PIFRROTRBN |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:UltimateShipToTradeParty/ram:SpecifiedLegalOrganization/ram:TradingBusinessName |
BT-X-71 |
This may be used if different from the party name. |
|
|
PIFRDCN |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:UltimateShipToTradeParty/ram:DefinedTradeContact/ram:PersonName |
BT-X-72 |
If a contact person is indicated, either the name or the department is to be transmitted. |
|
|
PIFRDDN |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:UltimateShipToTradeParty/ram:DefinedTradeContact/ram:DepartmentName |
BT-X-72-1 |
If a contact person is indicated, either the name or the department is to be transmitted. |
|
|
PIFRDTEL |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:UltimateShipToTradeParty/ram:DefinedTradeContact/ram:TelephoneUniversalCommunication/ram:CompleteNumber |
BT-X-73 |
|
|
|
PIFRDFAX |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:UltimateShipToTradeParty/ram:DefinedTradeContact/ram:FaxUniversalCommunication/ram:CompleteNumber |
BT-X-74 |
|
|
|
PIFRDMAIL |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:UltimateShipToTradeParty/ram:DefinedTradeContact/ram:EmailURIUniversalCommunication/ram:URIID |
BT-X-75 |
|
|
|
PIFRDPLZ |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:UltimateShipToTradeParty/ram:PostalTradeAddress/ram:PostcodeCode |
BT-X-76 |
Such as a ZIP code or a post code. |
|
|
PIFRDAD1 |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:UltimateShipToTradeParty/ram:PostalTradeAddress/ram:LineOne |
BT-X-77 |
Usually the street name and number or post office box. |
|
|
PIFRDAD2 |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:UltimateShipToTradeParty/ram:PostalTradeAddress/ram:LineTwo |
BT-X-78 |
|
|
|
PIFRDAD3 |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:UltimateShipToTradeParty/ram:PostalTradeAddress/ram:LineThree |
BT-X-79 |
|
|
|
PIFRDCITY |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:UltimateShipToTradeParty/ram:PostalTradeAddress/ram:CityName |
BT-X-80 |
|
|
|
PIFRDLC |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:UltimateShipToTradeParty/ram:PostalTradeAddress/ram:CountryID |
BT-X-81 |
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". |
|
|
PIFRDCSDN |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:UltimateShipToTradeParty/ram:PostalTradeAddress/ram:CountrySubDivisionName |
BT-X-82 |
Such as a region, a county, a state, a province, etc. |
|
|
PIFRURIID |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:UltimateShipToTradeParty/ram:URIUniversalCommunication/ram:URIID |
BT-X-83 |
|
|
|
PIFRURIIDT |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:UltimateShipToTradeParty/ram:URIUniversalCommunication/ram:URIID/@schemeID |
BT-X-83-0 |
|
|
|
PIFRDSNR |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:UltimateShipToTradeParty/ram:SpecifiedTaxRegistration/ram:ID |
BT-X-84 |
|
|
|
|
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:UltimateShipToTradeParty/ram:SpecifiedTaxRegistration/ram:ID/@schemeID |
BT-X-84-0 |
VA = VAT ID |
|
|
PIFRDASNR |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:UltimateShipToTradeParty/ram:SpecifiedTaxRegistration/ram:ID |
BT-X-84 |
|
|
|
|
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:UltimateShipToTradeParty/ram:SpecifiedTaxRegistration/ram:ID/@schemeID |
BT-X-84-0 |
VA = VAT ID |