PJF_BILLING_CYCLES_B
PJF_BILLING_CYCLES_B stores the definition of a billing cycle that specifies the rules that will be used to determine the next billing date for a given project. This table has predefined data for some standard cycles that Oracle Projects supports. You can define your own rules if the standard cycles do not meet your requirements.
Details
-
Schema: FUSION
-
Object owner: PJF
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
PJF_BILLING_CYCLES_B_PK |
BILLING_CYCLE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BILLING_CYCLE_ID | NUMBER | 18 | Yes | The system generated identifier to uniquely identify a billing cycle ***** | |
| BILLING_CYCLE_TYPE | VARCHAR2 | 30 | Yes | The type of billing cycle. ***** | |
| START_DATE_ACTIVE | DATE | Yes | The first effective date of billing cycle. ***** | ||
| END_DATE_ACTIVE | DATE | The last effective date of billing cycle. ***** | |||
| BILLING_ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Developer descriptive flexfield structure defining column. ***** | ||
| BILLING_VALUE1 | VARCHAR2 | 150 | Developer descriptive flexfield segment. ***** | ||
| BILLING_VALUE2 | VARCHAR2 | 150 | Developer descriptive flexfield segment. ***** | ||
| BILLING_VALUE3 | VARCHAR2 | 150 | Developer descriptive flexfield segment. ***** | ||
| BILLING_VALUE4 | VARCHAR2 | 150 | Developer descriptive flexfield segment. ***** | ||
| BILLING_VALUE5 | VARCHAR2 | 150 | Developer descriptive flexfield segment. ***** | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| pjf_billing_cycles_tl | pjf_billing_cycles_b | BILLING_CYCLE_ID |
| pjb_bill_plans_b | pjf_billing_cycles_b | BILLING_CYCLE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJF_BILLING_CYCLES_U1 | Unique | Default | BILLING_CYCLE_ID, ORA_SEED_SET1 |
| PJF_BILLING_CYCLES_U11 | Unique | Default | BILLING_CYCLE_ID, ORA_SEED_SET2 |