Table PAYMENT

DescriptionA transfer of money between two s or between two money repositories of the same . A payment could be made either by the modelled organisation or by a third party.

Columns
PAYMENT_IDPAYMENT_ID
AMOUNTAMOUNT
ANCHOR_IDANCHOR_ID
DESCRIPTIONDESCRIPTION
EFFECTIVE_FROM_DATEEFFECTIVE_FROM_DATE
EFFECTIVE_TO_DATEEFFECTIVE_TO_DATE
EXTERNAL_REFERENCEEXTERNAL_REFERENCE
MEMOMEMO
PAYMENT_METHODPAYMENT_METHOD
POSTED_DATEPOSTED_DATE
SETTLEMENT_METHODSETTLEMENT_METHOD
STATUSSTATUS
STATUS_DATESTATUS_DATE
STATUS_REASONSTATUS_REASON
TYPETYPE
VALID_FROM_DATEVALID_FROM_DATE
VALID_TO_DATEVALID_TO_DATE

Primary Key
PAYMENT_PKPAYMENT_PK

Dependencies
AWM - TransformationAWM - Transformation

Column Details

 PAYMENT_ID
DescriptionThe unique identifier of the Payment
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 AMOUNT
DescriptionThe amount of money already paid (in the case of a payment) or to be paid (in the case of a payment due).
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ANCHOR_ID
DescriptionAny value without business meaning that uniquely distinguishes occurrences of this entity independently of its history.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DESCRIPTION
DescriptionA free-text statement used to explain the meaning of this payment or payment due. Descriptions are most important for payments because sometimes inbound payments are not recognised and their descriptions may be used to keep all information about the payments when investigating the reason for the payment or target of the payment.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_FROM_DATE
DescriptionThe effective date and time that represents the beginning of the time period during which the values of all attributes of the entity occurrence are true in the business reality.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_TO_DATE
DescriptionThe effective date and time that represents the end of the time period during which the values of all attributes of the entity occurrence are true in the business reality.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EXTERNAL_REFERENCE
DescriptionThe number or code used for identification or communication purposes.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MEMO
DescriptionFree format message that is used by the originator of the transaction to pass a message to the receiver of the transaction. The message is usually used to identify the reason of the transaction and often contains structured content.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PAYMENT_METHOD
DescriptionThe way the money has been paid by the payer to the receiver in the case of a payment or how it will be paid in the case of a payment due.

e.g. Cash
e.g. Cheque
e.g. Credit card
e.g. Direct debit
e.g. Internal transfer
e.g. Standing order
e.g. Transfer
e.g. Unit cancellation
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 POSTED_DATE
DescriptionThe date at which the payment is posted in the accounting of the insurance company.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SETTLEMENT_METHOD
DescriptionIdentifies the way a money transfer between financial organisations is settled.

e.g. ACH
e.g. BookEntry
e.g. CHAPS
e.g. CHIPS
e.g. Concentrator
e.g. Draft
e.g. Epay
e.g. FedNet
e.g. RPS
e.g. SWIFT
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 STATUS
DescriptionThe position of a payment within a life-cycle model consisting of a number of statuses.
The position of a financial transaction within a life-cycle model consisting of a number of statuses.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 STATUS_DATE
DescriptionThe date on which the financial transaction's latest status became effective.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 STATUS_REASON
DescriptionThe additional information to explain the latest status of the financial transaction.
The reason for which this payment has been rejected.
Is derivable from attribute status reason in type financial transaction for the status 'rejected'.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TYPE
DescriptionThe mutually exclusive categorisation of this Payment.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_FROM_DATE
DescriptionThe transaction time that represents the beginning of the time period during which the values of this recorded data are true in the source system.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_TO_DATE
DescriptionThe transaction time that represents the end of the time period during which the values of this recorded data are true in the source system.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 PAYMENT_PK
DescriptionThe unique identifier of the Payment
MemberPAYMENT_ID [BIGINT]

Dependency Details

 AWM - Transformation