Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column
width33%

Groups

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
width33%

ACCOUNT_PAYMENT

Column NameData TypeField LengthNot 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_REFUNDNUMBER14,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_DATEDATE   Vs 10
Column
width33%

Contains all Payments