Groups
BILLING_GROUP
| Col # | Column Name | Data Type | Field Length | Not 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 |
Contains all Billing Group