Versions Compared

Old Version 2

changes.mady.by.user Former user

Saved on

compared with

New Version Current

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

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%

BILLING_GROUP

Col #Column NameData TypeField LengthNot Null?Data Def.Comment

1

ID

NUMBER

22

N

 Primary key

2

CODE

VARCHAR2

20

80

Y

  

3

OWNER_USER_ID

NUMBER

22

Y

 Reference to USERS (owner)

4

NAME

VARCHAR2

100

400

Y

  

5

BALANCE

NUMBER

22

Y

N

  

6

PAYMENT_MODEL_TYPE_ID

NUMBER

22

Y

 Unknown - not used in application

7

PAYMENT_MODEL_ID

NUMBER

22

Y

 Unknown - not used in application

8

BILLING_ADDRESS_ID

NUMBER

22

Y

 Reference to USERS (optional billing address)

9

ACCOUNT_ID

NUMBER

22

Y

 Reference to ACCOUNT

10

SUBSCRIPTION_ID

NUMBER

22

Y

 Deprecated

11

ALERT_GROUP_ID

NUMBER

22

Y

 Reference to ALERT_GROUP

12

ALERT_USER_ID

NUMBER

22

Y

 Reference to SUBSCRIPTION (for alerts)

13

PAYMENT_METHOD_ID

NUMBER

22

Y

  

14

INVOICE_LAYOUT_STYLE_ID

NUMBER

22

Y

  

15

INVOICE_TYPE_ID

NUMBER

22

Y

  

16

MIN_INVOICE_AMOUNT

NUMBER

22

Y

  

17

BILLING_CYCLE_ID

NUMBER

22

Y

 Reference to BILLING_CYCLE

18

TYPE_ID

NUMBER

22

Y

  

19

PAYMENT_REFERENCE_NUMBER

VARCHAR2

25

100

Y

  

20

AUTO_PAYMENT_START_DATE

DATE

7

Y

  

21

AUTO_PAYMENT_END_DATE

DATE

7

Y

  

22

CREDIT_DAYS

NUMBER

22

Y

  

23

ADD_BILLING_FEE

CHAR

VARCHAR2

1

4

Y

  

24

BANK_ACCOUNT_NUMBER

VARCHAR2

50

200

Y

  

25

AUTO_PAYMENT_MAX_AMOUNT

NUMBER

22

Y

  

26

CREDIT_CARD_PAYMENT

CHAR

VARCHAR2

1

4

Y

  

27

INV_ROW_ID

VARCHAR2

40

160

Y

  

28

DETAIL_SPECIFICATION

CHAR

VARCHAR2

1

4

Y

  

29

NEGATIVE_BALANCE_DATE

DATE

7

Y

  

30

NEGATIVE_BALANCE_ID

NUMBER

22

Y

  

31

BANK_NAME

VARCHAR2

50

200

Y

  31

32

BANK_REG_NUMBER

VARCHAR2

50

200

Y

  32

33

BANK_CITY

VARCHAR2

50

200

Y

  33

34

INVOICE

ACCOUNT_

STORAGE

NUMBER

VARCHAR2

1

200

Y

  

35

MAX_USAGE

NUMBER

22

Y

  34

36

ALERT_EMAIL

VARCHAR2

1

4

Y

  35

37

ALERT_SMS

VARCHAR2

1

4

Y

  36

38

MASK_DETAIL_LINE_NUMBERS

VARCHAR2

4

Y

  

39

INVOICE_STORAGE

VARCHAR2

1

4

Y

  37

40

FAILED_PAYMENT

NUMBER

22

Y

  38

41

FAILED_PAYMENT_DATE

DATE

7

Y

  39

42

PIN_CODE

VARCHAR2

20

80

Y

  40

43

IVR_AMOUNT

NUMBER

22

Y

  41

44

BRAND_ID

NUMBER

22

Y

 Reference to BRAND (redundant, from ACCOUNT)42

45

PAYMENT_GATEWAY_KEY

VARCHAR2

100

400

Y

  43

46

CHARGE_DAY

_CHANGED_DATE

DATE

VARCHAR2

7

8

Y

  44

47

CHARGE

LAST_CHARGED_

DAY

PERIOD

VARCHAR2

2

40

Y

  45

48

LAST

CHARGE_DAY_

CHARGED

CHANGED_

PERIOD

DATE

VARCHAR2

DATE

10

7

Y

  46

49

PARENT_ID

NUMBER

22

Y

 Reference to BILLING_GROUP47

50

ALIAS

VARCHAR2

400

Y

  

51

INVOICE_FLOW_DEF_KEY

VARCHAR2

250

1000

Y

  48

52

PBS_NUMBER

VARCHAR2

80

Y

  49

53

EAN_NUMBER

VARCHAR2

200

Y

  
50

CONCURRENCY_KEY

NUMBER

22

Y

  
51

54

IBAN_NUMBER

VARCHAR2

400

Y

  52

55

BANK_IDENTIFIER_CODE

VARCHAR2

400

Y

  53

56

DUNNING_BALANCE

NUMBER

22

Y

  54

57

DUNNING_DATE

DATE

7

Y

  55

58

DUNNING_STEP_ID

NUMBER

22

Y

  56

59

DUNNING_IDL_ID

NUMBER

22

Y

  57

60

DUNNING_SUSPEND

VARCHAR2

4

Y

  58

61

DUNNING_SUSPEND_DATE

DATE

7

Y

  59

62

CURRENCY_CODE

VARCHAR2

12

Y

  60

CA_CREDIT_LIMIT

CONCURRENCY_KEY

NUMBER

22

Y

  
61

CA_BANK_ACCOUNT_COMPANY_ID

VARCHAR2

400

Y

  
62CA_BANK_ACCOUNT_PRODUCT_

63

CURRENCY_CODE

VARCHAR2

400

12

Y

  
Column
width33%

Contains all Billing Group