i-effect Manual

ZF23INVPIR - Information about previous invoices

This database table consists of the following fields

Column Name

Status

Column definition

Technical term

Description

PIRKEY

required

VARCHAR(15)

Reference to ZF23INVHT.HTKEY

Unique auto generated identifier

PIRLFD

erforderlich

INTEGER

Sequence


PIRREF

optional

VARCHAR(50)

Preceding Invoice reference

The identification of an Invoice that was previously sent by the Seller.

PIRDATE

optional

DATE '0001-01-01'

Preceding Invoice issue date

The date when the Preceding Invoice was issued.

PIRDATET

optional

CHAR(3)

Date, format


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

PIRREF

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:InvoiceReferencedDocument/ram:IssuerAssignedID

BT-25



PIRDATE

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:InvoiceReferencedDocument/ram:FormattedIssueDateTime/qdt:DateTimeString

BT-26

The Preceding Invoice issue date shall be provided in case the Preceding Invoice identifier is not unique.


PIRDATET

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:InvoiceReferencedDocument/ram:FormattedIssueDateTime/qdt:DateTimeString/@format

BT-26-0

102

Code lists