BILLING_GROUP_MAIN

Owned by Søren Duusgaard (Deactivated)
Last updated: 26.08.2014

Groups

BILLING_GROUP_MAIN

Col #Column NameData TypeField LengthNot Null?Data Def.Comments
1

ID

NUMBER

22

N

  
2

CODE

VARCHAR2

20

Y

  
3

OWNER_USER_ID

NUMBER

22

Y

  
4

NAME

VARCHAR2

100

Y

  
5

BALANCE

NUMBER

22

N

  
6

PAYMENT_MODEL_TYPE_ID

NUMBER

22

Y

  
7

PAYMENT_MODEL_ID

NUMBER

22

Y

  
8

BILLING_ADDRESS_ID

NUMBER

22

Y

  
9

ACCOUNT_ID

NUMBER

22

Y

  
10

SUBSCRIPTION_ID

NUMBER

22

Y

  
11

ALERT_GROUP_ID

NUMBER

22

Y

  
12

ALERT_USER_ID

NUMBER

22

Y

  
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

  
18

TYPE_ID

NUMBER

22

Y

  
19

PAYMENT_REFERENCE_NUMBER

VARCHAR2

25

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

1

Y

  
24

BANK_ACCOUNT_NUMBER

VARCHAR2

50

Y

  
25

AUTO_PAYMENT_MAX_AMOUNT

NUMBER

22

Y

  
26

CREDIT_CARD_PAYMENT

CHAR

1

Y

  
27

INV_ROW_ID

VARCHAR2

40

Y

  
28

DETAIL_SPECIFICATION

CHAR

1

Y

  
29

NEGATIVE_BALANCE_DATE

DATE

7

Y

  
30

NEGATIVE_BALANCE_ID

NUMBER

22

Y

  
31

BANK_NAME

VARCHAR2

50

Y

  
32

BANK_REG_NUMBER

VARCHAR2

50

Y

  
33

BANK_CITY

VARCHAR2

50

Y

  
34

ACCOUNT_NUMBER

VARCHAR2

50

Y

  
35

MAX_USAGE

NUMBER

22

Y

  
36

ALERT_EMAIL

VARCHAR2

1

Y

  
37

ALERT_SMS

VARCHAR2

1

Y

  
38

MASK_DETAIL_LINE_NUMBERS

VARCHAR2

1

Y

  
39

INVOICE_STORAGE

VARCHAR2

1

Y

  
40

FAILED_PAYMENT

NUMBER

22

Y

  
41

FAILED_PAYMENT_DATE

DATE

7

Y

  
42

PIN_CODE

VARCHAR2

20

Y

  
43

IVR_AMOUNT

NUMBER

22

Y

  
44

BRAND_ID

NUMBER

22

Y

  
45

PAYMENT_GATEWAY_KEY

VARCHAR2

100

Y

  
46

CHARGE_DAY

VARCHAR2

2

Y

  
47

LAST_CHARGED_PERIOD

VARCHAR2

10

Y

  
48

CHARGE_DAY_CHANGED_DATE

DATE

7

Y

  
49

PARENT_ID

NUMBER

22

Y

  
50

ALIAS

VARCHAR2

100

Y

  
51

INVOICE_FLOW_DEF_KEY

VARCHAR2

250

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

  
64

CA_CREDIT_LIMIT

NUMBER

22

Y

  
65

CA_BANK_ACCOUNT_COMPANY_ID

VARCHAR2

400

Y

  
66

CA_BANK_ACCOUNT_PRODUCT_CODE

VARCHAR2

400

Y

 Â