Payment Item Data Element
Payment Items are a core data construct that tracks and manages individual payment transactions. It consists of a PAYMENT_ITEM table that describes the payment details, including its status, associated deal, client, and amounts. The PAYMENT_ITEM table also links to PARTICIPANT_SETTLEMENT_ITEM to track how payments are allocated to various participants.
The PAYMENT_ITEM table serves as the central record for each payment, capturing its financial attributes and operational status. It supports the comprehensive management of payment workflows, from initial creation through to clearing, and ensures accurate tracking of funds for both internal and external stakeholders.
PAYMENT_ITEM
| Field | Type | Comment |
|---|---|---|
| PAYMENT_ITEM_ID | Number | Unique identifier for the Payment Item |
| PAYMENT_ITEM_TYPE_CD | String | Code Master for Payment_Item_Type_Cd (S, P, L, R) |
| UTA_ENTITY_ID | Number | FK for UTA_ENTITY |
| DEPARTMENT_ID | Number | FK for UTA_Department |
| AGENT_GROUP_ID | Number | FK for Agent Group |
| PAYMENT_ITEM_NAME | String | Description for the Payment Item |
| DEAL_ID | Number | FK for Deal |
| CLIENT_ID | Number | FK for PARTY of type Client |
| CONTRACTED_PARTY_ID | Number | FK for PARTY of type Contracted |
| BUYER_ID | Number | FK for PARTY of type Buyer |
| PROJECT_ID | Number | FK for Project |
| PAYMENT_PARTY_ID | Number | FK for the Party |
| PAYMENT_PARTY_BANK_ID | Number | FK for party bank account |
| PARTICIPANT_SETTLEMENT_ITEM_ID | Number | FK for the Settlement |
| PAYMENT_ITEM_AMT | Number | The amount to be paid |
| PAYMENT_ITEM_CURRENCY_CD | String | Currency code (USD, EUR, etc.) |
| PAYMENT_ITEM_COMMENT | String | Comment for the payment item |
| PAYMENT_ITEM_POSTING_STATUS_CD | String | Code Master for Posting_Status_Cd |
| POSTING_DT | Date | Date payment was posted |
| PAYMENT_CLEARING_STATUS_IND | Boolean | Indicator to tell if this payment is cleared or not |
| CREATED_BY | String | User who created the record |
| CREATED_DT | Timestamp | Timestamp when the record was created |
| UPDATED_BY | String | User who last updated the record |
| UPDATED_DT | Timestamp | Timestamp when the record was last updated |
PAYMENT_ITEM CODE MASTER
| Code_Master_Cd | Code_Master_Desc | Code_Master_Type |
|---|---|---|
| S | Settled | PAYMENT_ITEM_TYPE_CD |
| P | Passthrough | PAYMENT_ITEM_TYPE_CD |
| L | Loan | PAYMENT_ITEM_TYPE_CD |
| R | Refund | PAYMENT_ITEM_TYPE_CD |
| Code Master Type | Code | Attribute | Value | Description |
|---|---|---|---|---|