| SERVICE_PAYMENT_DETAIL |
| EntityType | Dependent |
| Logical Entity Name | SERVICE_PAYMENT_DETAIL |
| Default Table Name | DEAL/SERVICES/SERVICE/SERVICE_PAYMENTS/SERVICE_PAYMENT/SERVICE_PAYMENT_DETAIL |
| Definition | |
| Note |
| SERVICE_PAYMENT_DETAIL Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| InternalAccountIdentifier | MISMOIdentifier | VARCHAR(0) | NO | The account number or identifier assigned by a service provider to a service requestor. The Internal Account Identifier is supplied with request transactions to allow the service provider to identify the billing account to be used. |
| ServicePaymentAccountIdentifier | MISMOIdentifier | VARCHAR(0) | NO | An alphanumeric designation assigned to the account that payment will be processed from. For credit card transactions this is the account number imprinted on the credit card. |
| ServicePaymentAmount | MISMOAmount | DECIMAL(0, 2) | NO | The total amount of payment being tendered. |
| ServicePaymentCreditAccountExpirationDate | MISMODate | DATE | NO | For credit card transactions this is the credit card expiration date imprinted on the credit card. |
| ServicePaymentCreditMethodType | ServicePaymentMethodEnum | VARCHAR(0) | YES | This enumerated attribute identifies the type of credit card or other payment method. |
| ServicePaymentCreditMethodTypeOtherDescription | MISMOString | VARCHAR(0) | NO | When Service Payment Method Type is set to Other, enter the description in this data attribute. |
| ServicePaymentMethodType | PaymentMethodEnum | VARCHAR(0) | YES | A description of the method of funds transfer to be used for the transaction. |
| ServicePaymentMethodTypeOtherDescription | MISMOString | VARCHAR(0) | NO | A description of the type of payment when Other is selected from the enumerated list. |
| ServicePaymentOnAccountIdentifier | MISMOIdentifier | VARCHAR(0) | NO | An alphanumeric designation assigned to the prepaid account to be debited for the payment. |
| ServicePaymentOnAccountMaximumDebitAmount | MISMOAmount | DECIMAL(0, 2) | NO | The maximum dollar amount that can be debited from the prepaid account on any single transaction. |
| ServicePaymentOnAccountMinimumBalanceAmount | MISMOAmount | DECIMAL(0, 2) | NO | The dollar amount at which the system should send a message that the prepaid account needs to be replenished. It may also trigger the system to discontinue processing documents until more funds are added to the account. |
| ServicePaymentReferenceIdentifier | MISMOIdentifier | VARCHAR(0) | NO | A unique identifier assigned to each payment transaction for tracking and auditing purposes. |
| ServicePaymentSecondaryCreditAccountIdentifier | MISMOIdentifier | VARCHAR(0) | NO | For credit card transactions this is an additional identifier that appears on the credit card in various locations depending on the Credit Card Type. |
| SERVICE_PAYMENT_DETAIL Keys |
| Key Name | Key Type | Keys |
| SERVICE_PAYMENT_DETAIL Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| SERVICE_PAYMENT | Identifying | One to Zero or One | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| SERVICE_PAYMENT_DETAIL Check Constraints |
| Check Constraint Name | CheckConstraint |
| SERVICE_PAYMENT_DETAIL Bound Attachments |
| Name | Current Value |
| SERVICE_PAYMENT_DETAIL User-Defined Mappings |
| Model | Name | Description |
| SERVICE_PAYMENT_DETAIL Data Movement Rules |
| Name | Type | Rule Text/Value |