Versions Compared

Old Version 4

changes.mady.by.user Søren Duusgaard

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

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

 Vs 10


Reference to PAYMENT_OPTION
CREATE_DATEDATE
   



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



Column
width33%

Contains all Payments


...