Groups
ACCOUNT_PAYMENT
| Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|
ID | NUMBER | 22 | N | Primary key | |
ACCOUNT_ID | NUMBER | 22 | Y | Reference to ACCOUNT (redundant information given BILLING_GROUP_ID) | |
AMOUNT | NUMBER | 22 | Y | Amount paid | |
| AMOUNT_TO_REFUND | NUMBER | 14,4 | Added in 9.10 - Implement partial refund in CORE | ||
PAYMENT_TYPE_ID | NUMBER | 22 | Y | Reference to ACCOUNT_PAYMENT_TYPE | |
CHARGE_ITEM_ID | NUMBER | 22 | Y | Reference to CHARGE_ITEM | |
PAYMENT_ORIGIN_ID | NUMBER | 22 | Y | The ID of the origin for the payment | |
PAYMENT_DATE | DATE | 7 | Y | Payment Date | |
REFERENCE | VARCHAR2 | 50 | Y | Payment reference | |
INVOICE_NUMBER | VARCHAR2 | 25 | Y | Invoice number for the Payment | |
SEND_IN_FILE | VARCHAR2 | 250 | Y | Payment filename | |
AMOUNT_RESERVED | NUMBER | 22 | Y | Amount reserved in the payment gateway | |
SUBSCRIPTION_ID | NUMBER | 22 | Y | Reference to SUBSCRIPTION (deprecated) | |
TRANSACTION_ID | NUMBER | 22 | Y | Payment Transaction ID | |
SHORT_REFERENCE | VARCHAR2 | 20 | Y | Short Payment Reference | |
CATEGORY_ID | NUMBER | 22 | Y | Payment category ID | |
BALANCING_DATE | DATE | 7 | Y | Payment posting date | |
CAPTURE_DATE | DATE | 7 | Y | Payment capture date | |
TRANSACTION_NUMBER | VARCHAR2 | 50 | Y | Payment transaction number | |
CAPTURE_STATUS_ID | NUMBER | 22 | Y | ID for the Payment capture | |
CAPTURE_MESSAGE | VARCHAR2 | 250 | Y | Payment capture message | |
BILLING_GROUP_ID | NUMBER | 22 | Y | Reference to BILLING_GROUP | |
CONFIRMATION_ID | VARCHAR2 | 128 | Y | Payment Confirmation ID | |
RECHARGE_TICKET_ID | NUMBER | 22 | Y | Reference to RECHARGE_TICKET | |
PAYMENT_GATEWAY_KEY | VARCHAR2 | 100 | Y | Payment gateway KEY | |
PAYMENT_CHANNEL | VARCHAR2 | 250 | Y | Payment Channel | |
FEE_AMOUNT | NUMBER | 22 | Y | Payment fee amount | |
TRIES | NUMBER | 22 | Y | Number of tries | |
CHECK_DATE | DATE | 7 | Y | Payment check date | |
GATEWAY_STATUS | VARCHAR2 | 40 | Y | Status of the Payment gateway | |
PAYMENT_OPTION_ID | NUMBER | 22 | Y | Reference to PAYMENT_OPTION | |
| CREATE_DATE | DATE | Vs 10 |
Contains all Payments