SoftadminUtil.P27_Camt_CreditNotification_Definition

Show allHide all
Type: Table-valued function

See also

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.
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.