Versions Compared

Old Version 3

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

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

80

Y

  

3

OWNER_USER_ID

NUMBER

22

Y

 Reference to USERS (owner)

4

NAME

VARCHAR2

400

Y

  

5

BALANCE

NUMBER

22

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

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

VARCHAR2

4

Y

  

24

BANK_ACCOUNT_NUMBER

VARCHAR2

200

Y

  

25

AUTO_PAYMENT_MAX_AMOUNT

NUMBER

22

Y

  

26

CREDIT_CARD_PAYMENT

VARCHAR2

4

Y

  

27

INV_ROW_ID

VARCHAR2

160

Y

  

28

DETAIL_SPECIFICATION

VARCHAR2

4

Y

  

29

NEGATIVE_BALANCE_DATE

DATE

7

Y

  

30

NEGATIVE_BALANCE_ID

NUMBER

22

Y

  

31

BANK_NAME

VARCHAR2

200

Y

  

32

BANK_REG_NUMBER

VARCHAR2

200

Y

  

33

BANK_CITY

VARCHAR2

200

Y

  

34

ACCOUNT_NUMBER

VARCHAR2

200

Y

  

35

MAX_USAGE

NUMBER

22

Y

  

36

ALERT_EMAIL

VARCHAR2

4

Y

  

37

ALERT_SMS

VARCHAR2

4

Y

  

38

MASK_DETAIL_LINE_NUMBERS

VARCHAR2

4

Y

  

39

INVOICE_STORAGE

VARCHAR2

4

Y

  

40

FAILED_PAYMENT

NUMBER

22

Y

  

41

FAILED_PAYMENT_DATE

DATE

7

Y

  

42

PIN_CODE

VARCHAR2

80

Y

  

43

IVR_AMOUNT

NUMBER

22

Y

  

44

BRAND_ID

NUMBER

22

Y

 Reference to BRAND (redundant, from ACCOUNT)

45

PAYMENT_GATEWAY_KEY

VARCHAR2

400

Y

  

46

CHARGE_DAY

VARCHAR2

8

Y

  

47

LAST_CHARGED_PERIOD

VARCHAR2

40

Y

  

48

CHARGE_DAY_CHANGED_DATE

DATE

7

Y

  

49

PARENT_ID

NUMBER

22

Y

 Reference to BILLING_GROUP

50

ALIAS

VARCHAR2

400

Y

  

51

INVOICE_FLOW_DEF_KEY

VARCHAR2

1000

Y

  

52

PBS_NUMBER

VARCHAR2

80

Y

  

53

EAN_NUMBER

VARCHAR2

200

Y

  

54

IBAN_NUMBER

VARCHAR2

400

Y

  

55

BANK_IDENTIFIER_CODE

VARCHAR2

400

Y

  

56

DUNNING_BALANCE

NUMBER

22

Y

  

57

DUNNING_DATE

DATE

7

Y

  

58

DUNNING_STEP_ID

NUMBER

22

Y

  

59

DUNNING_IDL_ID

NUMBER

22

Y

  

60

DUNNING_SUSPEND

VARCHAR2

4

Y

  

61

DUNNING_SUSPEND_DATE

DATE

7

Y

  

62

CONCURRENCY_KEY

NUMBER

22

Y

  

63

CURRENCY_CODE

VARCHAR2

12

Y

  
Column
width33%

Contains all Billing Group