version

SoftadminUtil.P27_Camt_CreditNotification_Definition

Type: Table-valued function

Resultsets

Table count:

Row count: no rows (only column metadata)

Amount mandatory decimal

CreditInvoiceNumberReference mandatory string

Comma separated credit invoice number references.

Currency mandatory string

Three letter currency code.

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.

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.