eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: AR.AR_CONS_BILL_CYCLES_B

Object Details

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_CONS_BILL_CYCLES_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BILLING_CYCLE_ID

Columns

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

Query Text

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
FROM AR.AR_CONS_BILL_CYCLES_B;

Dependencies

[top of page]

AR.AR_CONS_BILL_CYCLES_B does not reference any database object

AR.AR_CONS_BILL_CYCLES_B is referenced by following:

APPS: AR_CONS_BILL_CYCLES_B