[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AR_CONS_BILL_CYCLES_B |
|---|---|
| Object Type: | TABLE |
| Owner: | AR |
| FND Design Data: |  AR.AR_CONS_BILL_CYCLES_B
|
| Subobject Name: | |
| Status: | VALID |
The AR_CONS_BILL_CYCLES_B table stores information on defined cycles. Receivables creates one row for each billing cycle that you define. This information iis used to distinguish which activity to include on a bill.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AR_CONS_BILL_CYCLES_B_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 BILLING_CYCLE_ID
ZD_EDITION_NAME
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BILLING_CYCLE_ID | NUMBER | (15) | Yes | Billing cycle identifier |
| BILL_CYCLE_TYPE | VARCHAR2 | (30) | Type of billing cycle, either RECURRING or EVENT | |
| START_DATE | DATE | Date when billing cycle becomes effective | ||
| CYCLE_FREQUENCY | VARCHAR2 | (30) | Frequency of billing, either DAILY, WEEKLY, or MONTHLY | |
| LAST_DAY | VARCHAR2 | (1) | Indicates if billing should be run on last day of month | |
| DAY_1 | VARCHAR2 | (1) | Indicates if billing should be run on first day of month | |
| DAY_2 | VARCHAR2 | (1) | Indicates if billing should be run on second day of month | |
| DAY_3 | VARCHAR2 | (1) | Indicates if billing should be run on third day of month | |
| DAY_4 | VARCHAR2 | (1) | Indicates if billing should be run on fourth day of month | |
| DAY_5 | VARCHAR2 | (1) | Indicates if billing should be run on fifth day of month | |
| DAY_6 | VARCHAR2 | (1) | Indicates if billing should be run on sixth day of month | |
| DAY_7 | VARCHAR2 | (1) | Indicates if billing should be run on seventh day of month | |
| DAY_8 | VARCHAR2 | (1) | Indicates if billing should be run on eighth day of month | |
| DAY_9 | VARCHAR2 | (1) | Indicates if billing should be run on ninth day of month | |
| DAY_10 | VARCHAR2 | (1) | Indicates if billing should be run on tenth day of month | |
| DAY_11 | VARCHAR2 | (1) | Indicates if billing should be run on eleventh day of month | |
| DAY_12 | VARCHAR2 | (1) | Indicates if billing should be run on twelfth day of month | |
| DAY_13 | VARCHAR2 | (1) | Indicates if billing should be run on thirteenth day of month | |
| DAY_14 | VARCHAR2 | (1) | Indicates if billing should be run on fourteenth day of month | |
| DAY_15 | VARCHAR2 | (1) | Indicates if billing should be run on fifteenth day of month | |
| DAY_16 | VARCHAR2 | (1) | Indicates if billing should be run on sixteenth day of month | |
| DAY_17 | VARCHAR2 | (1) | Indicates if billing should be run on seventeenth day of month | |
| DAY_18 | VARCHAR2 | (1) | Indicates if billing should be run on eighteenth day of month | |
| DAY_19 | VARCHAR2 | (1) | Indicates if billing should be run on nineteenth day of month | |
| DAY_20 | VARCHAR2 | (1) | Indicates if billing should be run on twentieth day of month | |
| DAY_21 | VARCHAR2 | (1) | Indicates if billing should be run on twenty-first day of month | |
| DAY_22 | VARCHAR2 | (1) | Indicates if billing should be run on twenty-second day of month | |
| DAY_23 | VARCHAR2 | (1) | Indicates if billing should be run on twenty-third day of month | |
| DAY_24 | VARCHAR2 | (1) | Indicates if billing should be run on twenty-fourth day of month | |
| DAY_25 | VARCHAR2 | (1) | Indicates if billing should be run on twenty-fifth day of month | |
| DAY_26 | VARCHAR2 | (1) | Indicates if billing should be run on twenty-sixth day of month | |
| DAY_27 | VARCHAR2 | (1) | Indicates if billing should be run on twenty-seventh day of month | |
| DAY_28 | VARCHAR2 | (1) | Indicates if billing should be run on twenty-eighth day of month | |
| DAY_29 | VARCHAR2 | (1) | Indicates if billing should be run on twenty-ninth day of month | |
| DAY_30 | VARCHAR2 | (1) | Indicates if billing should be run on thirtieth day of month | |
| DAY_31 | VARCHAR2 | (1) | Indicates if billing should be run on thirty-first day of month | |
| DAY_MONDAY | VARCHAR2 | (1) | Indicates if billing should be run on Monday | |
| DAY_TUESDAY | VARCHAR2 | (1) | Indicates if billing should be run on Tuesday | |
| DAY_WEDNESDAY | VARCHAR2 | (1) | Indicates if billing should be run on Wednesday | |
| DAY_THURSDAY | VARCHAR2 | (1) | Indicates if billing should be run on Thursday | |
| DAY_FRIDAY | VARCHAR2 | (1) | Indicates if billing should be run on Friday | |
| SKIP_WEEKENDS | VARCHAR2 | (1) | Indicates if billing should be skipped on weekends | |
| SKIP_HOLIDAYS | VARCHAR2 | (1) | Indicates if billing should be skipped on holidays | |
| REPEAT_DAILY | NUMBER | (15) | Number of days after which the daily billing cycle should repeat | |
| REPEAT_WEEKLY | NUMBER | (15) | Number of weeks after which the weekly billing cycle should repeat | |
| REPEAT_MONTHLY | NUMBER | (15) | Number of months after which the monthly billing cycle should repeat | |
| DAY_TYPE | VARCHAR2 | (1) | Type of day, either CALENDAR or WORKDAY | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| OBJECT_VERSION_NUMBER | NUMBER | (15) | Used for locking | |
| DAY_SATURDAY | VARCHAR2 | (1) | Indicates if billing should be run on Saturday | |
| DAY_SUNDAY | VARCHAR2 | (1) | Indicates if billing should be run on Sunday | |
| ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT BILLING_CYCLE_ID
, BILL_CYCLE_TYPE
, START_DATE
, CYCLE_FREQUENCY
, LAST_DAY
, DAY_1
, DAY_2
, DAY_3
, DAY_4
, DAY_5
, DAY_6
, DAY_7
, DAY_8
, DAY_9
, DAY_10
, DAY_11
, DAY_12
, DAY_13
, DAY_14
, DAY_15
, DAY_16
, DAY_17
, DAY_18
, DAY_19
, DAY_20
, DAY_21
, DAY_22
, DAY_23
, DAY_24
, DAY_25
, DAY_26
, DAY_27
, DAY_28
, DAY_29
, DAY_30
, DAY_31
, DAY_MONDAY
, DAY_TUESDAY
, DAY_WEDNESDAY
, DAY_THURSDAY
, DAY_FRIDAY
, SKIP_WEEKENDS
, SKIP_HOLIDAYS
, REPEAT_DAILY
, REPEAT_WEEKLY
, REPEAT_MONTHLY
, DAY_TYPE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, OBJECT_VERSION_NUMBER
, DAY_SATURDAY
, DAY_SUNDAY
, ZD_EDITION_NAME
FROM AR.AR_CONS_BILL_CYCLES_B;
AR.AR_CONS_BILL_CYCLES_B does not reference any database object
AR.AR_CONS_BILL_CYCLES_B is referenced by following:
AR
AR_CONS_BILL_CYCLES_B#
|
|
|
|