SoftadminUtil.P27_Pain_Payment_Definition

 Show all Hide all

Provides column metadata for P27 payments.

See also

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

Resultsets:

Resultset: #P27Payment

Repeat mode:
Row count: no rows (only column metadata)

Columns:

Amount mandatory decimal
.
CategoryPurpose mandatory string
.
ChargeBearer mandatory string
.
Currency mandatory string
.
EndToEndId mandatory string
.
FromBankgiro mandatory string
.
FromBban mandatory string
.
FromBic mandatory string
.
FromClearingNumber mandatory string
.
FromIban mandatory string
.
FromId mandatory string
.
FromIdSchemeCode mandatory string
.
FromName mandatory string
.
InstructionId mandatory string
.
InvoiceReference mandatory string
.
IsSalary mandatory bit
.
OcrReference mandatory string
.
PayDate mandatory date
.
ServiceLevelCode mandatory string
.
ServiceLevelProprietary mandatory string
.
ToBankgiro mandatory string
.
ToBban mandatory string
.
ToClearingNumber mandatory string
.
ToIban mandatory string
.
ToName mandatory string
.
ToPlusGiro mandatory string
.
UnstructuredReference mandatory string
.