Versions Compared

Old Version 1

changes.mady.by.user Søren Duusgaard (Deactivated)

Saved on

compared with

New Version Current

changes.mady.by.user Jason Reast-Jones

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Add PAYMENT_TEXT (Source CDRP-10486)

...

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

Col #
Column NameData TypeField LengthNot 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
AMOUNT_TO_REFUNDNUMBER14,4

Added in 9.10 - Implement partial refund in CORE

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
CREATE_DATEDATE


Vs 10
PAYMENT_TEXTVARCHAR2100Y
Since 10.7 - Free text payment note/comment



Column
width33%

Contains all Payments


...