Groups
ACCOUNT_PAYMENT
| Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | N | Primary key | |
| 2 | ACCOUNT_ID | NUMBER | 22 | Y | Reference to ACCOUNT (redundant information given BILLING_GROUP_ID) | |
| 3 | AMOUNT | NUMBER | 22 | Y | Amount paid | |
| 4 | PAYMENT_TYPE_ID | NUMBER | 22 | Y | Reference to ACCOUNT_PAYMENT_TYPE | |
| 5 | CHARGE_ITEM_ID | NUMBER | 22 | Y | Reference to CHARGE_ITEM | |
| 6 | PAYMENT_ORIGIN_ID | NUMBER | 22 | Y | The ID of the origin for the payment | |
| 7 | PAYMENT_DATE | DATE | 7 | Y | Payment Date | |
| 8 | REFERENCE | VARCHAR2 | 50 | Y | Payment reference | |
| 9 | INVOICE_NUMBER | VARCHAR2 | 25 | Y | Invoice number for the Payment | |
| 10 | SEND_IN_FILE | VARCHAR2 | 250 | Y | Payment filename | |
| 11 | AMOUNT_RESERVED | NUMBER | 22 | Y | Amount reserved in the payment gateway | |
| 12 | SUBSCRIPTION_ID | NUMBER | 22 | Y | Reference to SUBSCRIPTION (deprecated) | |
| 13 | TRANSACTION_ID | NUMBER | 22 | Y | Payment Transaction ID | |
| 14 | SHORT_REFERENCE | VARCHAR2 | 20 | Y | Short Payment Reference | |
| 15 | CATEGORY_ID | NUMBER | 22 | Y | Payment category ID | |
| 16 | BALANCING_DATE | DATE | 7 | Y | Payment posting date | |
| 17 | CAPTURE_DATE | DATE | 7 | Y | Payment capture date | |
| 18 | TRANSACTION_NUMBER | VARCHAR2 | 50 | Y | Payment transaction number | |
| 19 | CAPTURE_STATUS_ID | NUMBER | 22 | Y | ID for the Payment capture | |
| 20 | CAPTURE_MESSAGE | VARCHAR2 | 250 | Y | Payment capture message | |
| 21 | BILLING_GROUP_ID | NUMBER | 22 | Y | Reference to BILLING_GROUP | |
| 22 | CONFIRMATION_ID | VARCHAR2 | 128 | Y | Payment Confirmation ID | |
| 23 | RECHARGE_TICKET_ID | NUMBER | 22 | Y | Reference to RECHARGE_TICKET | |
| 24 | PAYMENT_GATEWAY_KEY | VARCHAR2 | 100 | Y | Payment gateway KEY | |
| 25 | PAYMENT_CHANNEL | VARCHAR2 | 250 | Y | Payment Channel | |
| 26 | FEE_AMOUNT | NUMBER | 22 | Y | Payment fee amount | |
| 27 | TRIES | NUMBER | 22 | Y | Number of tries | |
| 28 | CHECK_DATE | DATE | 7 | Y | Payment check date | |
| 29 | GATEWAY_STATUS | VARCHAR2 | 40 | Y | Status of the Payment gateway | |
| 30 | PAYMENT_OPTION_ID | NUMBER | 22 | Y | Reference to PAYMENT_OPTION |
Contains all Payments