Page Comparison

...

Section

Column

width	33%

Column

width	33%

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

				Vs 10
PAYMENT_TEXT	VARCHAR2	100	Y		Since 10.7 - Free text payment note/comment

Versions Compared