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 | 20 | Y | ||
| 3 | OWNER_USER_ID | NUMBER | 22 | Y | Reference to USERS (owner) | |
| 4 | NAME | VARCHAR2 | 100 | Y | ||
| 5 | BALANCE | NUMBER | 22 | Y | ||
| 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 | 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 | BANK_NAME | VARCHAR2 | 50 | Y | ||
| 31 | BANK_REG_NUMBER | VARCHAR2 | 50 | Y | ||
| 32 | BANK_CITY | VARCHAR2 | 50 | Y | ||
| 33 | INVOICE_STORAGE | VARCHAR2 | 1 | Y | ||
| 34 | ALERT_EMAIL | VARCHAR2 | 1 | Y | ||
| 35 | ALERT_SMS | VARCHAR2 | 1 | Y | ||
| 36 | MASK_DETAIL_LINE_NUMBERS | VARCHAR2 | 1 | Y | ||
| 37 | FAILED_PAYMENT | NUMBER | 22 | Y | ||
| 38 | FAILED_PAYMENT_DATE | DATE | 7 | Y | ||
| 39 | PIN_CODE | VARCHAR2 | 20 | Y | ||
| 40 | IVR_AMOUNT | NUMBER | 22 | Y | ||
| 41 | BRAND_ID | NUMBER | 22 | Y | Reference to BRAND (redundant, from ACCOUNT) | |
| 42 | PAYMENT_GATEWAY_KEY | VARCHAR2 | 100 | Y | ||
| 43 | CHARGE_DAY_CHANGED_DATE | DATE | 7 | Y | ||
| 44 | CHARGE_DAY | VARCHAR2 | 2 | Y | ||
| 45 | LAST_CHARGED_PERIOD | VARCHAR2 | 10 | Y | ||
| 46 | PARENT_ID | NUMBER | 22 | Y | Reference to BILLING_GROUP | |
| 47 | INVOICE_FLOW_DEF_KEY | VARCHAR2 | 250 | Y | ||
| 48 | PBS_NUMBER | VARCHAR2 | 80 | Y | ||
| 49 | EAN_NUMBER | VARCHAR2 | 200 | Y | ||
| 50 | CONCURRENCY_KEY | NUMBER | 22 | Y | ||
| 51 | IBAN_NUMBER | VARCHAR2 | 400 | Y | ||
| 52 | BANK_IDENTIFIER_CODE | VARCHAR2 | 400 | Y | ||
| 53 | DUNNING_BALANCE | NUMBER | 22 | Y | ||
| 54 | DUNNING_DATE | DATE | 7 | Y | ||
| 55 | DUNNING_STEP_ID | NUMBER | 22 | Y | ||
| 56 | DUNNING_IDL_ID | NUMBER | 22 | Y | ||
| 57 | DUNNING_SUSPEND | VARCHAR2 | 4 | Y | ||
| 58 | DUNNING_SUSPEND_DATE | DATE | 7 | Y | ||
| 59 | CURRENCY_CODE | VARCHAR2 | 12 | Y | ||
| 60 | CA_CREDIT_LIMIT | NUMBER | 22 | Y | ||
| 61 | CA_BANK_ACCOUNT_COMPANY_ID | VARCHAR2 | 400 | Y | ||
| 62 | CA_BANK_ACCOUNT_PRODUCT_CODE | VARCHAR2 | 400 | Y |
Contains all Billing Group