Versions Compared

Old Version 2

changes.mady.by.user Former user

Saved on

compared with

New Version 3

changes.mady.by.user Søren Duusgaard

Saved on

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

1
Col #Column NameData TypeField LengthNot Null?Data Def.Comments

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
AMOUNT_TO_REFUNDNUMBER14,4  Added in 9.10 - Implement partial refund in CORE

PAYMENT_TYPE_ID

NUMBER

22

Y

 Reference to ACCOUNT_PAYMENT_TYPE5

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 Payment10

SEND_IN_FILE

VARCHAR2

250

Y

 Payment filename11

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 ID14

SHORT_REFERENCE

VARCHAR2

20

Y

 Short Payment Reference15

CATEGORY_ID

NUMBER

22

Y

 Payment category ID16

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 message21

BILLING_GROUP_ID

NUMBER

22

Y

 Reference to BILLING_GROUP22

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 tries28

CHECK_DATE

DATE

7

Y

 Payment check date
29

GATEWAY_STATUS

VARCHAR2

40

Y

 Status of the Payment gateway30

PAYMENT_OPTION_ID

NUMBER

22

Y

 Reference to PAYMENT_OPTION
Column
width33%

Contains all Payments