Type:
Table-valued function
Resultsets
Resultset: #P27CreditNotification
Table count:
Row count:
no rows (only column metadata)
Columns
Amount mandatory decimal
.
CreditInvoiceNumberReference mandatory string
Comma separated credit invoice number references.
Currency mandatory string
Three letter currency code.
EndToEndId mandatory string
FromAccountIdentification mandatory string
FromAddressLines mandatory string
.
FromBuildingNumber mandatory string
.
FromCountry mandatory string
.
FromName mandatory string
.
FromPostCode mandatory string
.
FromStreetName mandatory string
.
FromTownName mandatory string
.
InvoiceNumberReference mandatory string
Comma separated invoice number references.
OcrNumberReference mandatory string
Comma separated OCR number references.
P27CreditNotificationId mandatory int
Identifies this row in the table. Referenced by #P27CreditNotificationDetails via the P27CreditNotificationIdParent column.
PayDate mandatory date
.
Reference mandatory string
A comma separated combination of OcrNumberReference, InvoiceNumberReference, CreditInvoiceNumberReference, and UnstructuredReference.
ToAccountIdentification mandatory string
ToAccountSchemeCode mandatory string
ToBankgiro mandatory string
.
ToBban mandatory string
.
ToClearingNumber mandatory string
.
ToIban mandatory string
.
ToName mandatory string
.
ToPlusGiro mandatory string
.
UnstructuredReference mandatory string
Comma separated unstructured references.