SoftadminUtil.P27_Camt_CreditNotification_Definition

 Show all Hide all

See also

Type: Table-valued function
Area of use: General use

Resultsets:

Resultset: #P27CreditNotification

Repeat mode:
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.
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.