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%

Image Modified

ACCOUNT_PAYMENT_TYPE

1
Col #Column NameColumn NameData TypeField lengthNot Data TypeField lengthNull?Data DefData Def.Comments

ID

NUMBER

22

N

 Primary key
2

NAME                               

VARCHAR2

320

Y

  3

DESCRIPTION                        

VARCHAR2

4000

Y

  4

PRICE_CODE                         

VARCHAR2

400

Y

  
5

INITIAL_CAPTURE_STATUS_ID

NUMBER

22

Y

  6

HOOK_POINT_KEY

VARCHAR2

4000

Y

  
7

PAYMENT_GATEWAY_KEY

VARCHAR2

320

Y

  8

TYPE_ID

NUMBER

22

Y

  9

ACTIVE

NUMBER

22

Y

  
10

STAT    

VARCHAR2

1000

Y

  11

CHARGE_ITEM_ID

NUMBER

22

Y

 Reference to CHARGE_ITEM
12

PAYMENT_GATEWAY_DEF_ID

NUMBER

22

Y

 Reference to PAYMENT_GATEWAY_DEF13

FEE_CHARGE_ITEM_ID

NUMBER

22

Y

 Reference to CHARGE_ITEM14

GROUP_CODE

VARCHAR2

80

Y

  
15

ACCOUNT_PAYMENT_TYPE_KEY

VARCHAR2

100  With

Support for AccountPaymentTypeKey (a "human readable" identifyer string) - with 9.9

Column
width33%

Definition of Payment Types used in CC when Registering a payment (see /wiki/spaces/NWRARSDEPRECATED/pages/113422577). Payment types must be defined in each invididual case.