Page Comparison

...

Section

Column

width	33%

Wiki Markup
{float:left\|width=200px\|background=lightgrey\|border=solid blue 2px\|margin=1px\|padding=0px} {children:page=Rator DB ER Diagram Navigator\|depth=1\|excerpt=trueindent=1px} {float}

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
PAYMENT_TEXT	VARCHAR2	100	Y	Since 10.7 - Free text payment note/comment

Versions Compared