PJB_BILLING_EXTENSIONS
PJB_BILLING_EXTENSIONS stores the definition of a billing extension that specifies how the billing extension is assigned and executed during revenue/invoice generation. .
Details
-
Schema: FUSION
-
Object owner: PJB
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
PJB_BILLING_EXTENSIONS_PK |
BILLING_EXTENSION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| BILLING_EXTENSION_ID | NUMBER | 18 | Yes | Primary key for the table | ||
| BILLING_EXTENSION_NAME | VARCHAR2 | 30 | Yes | This is the name of the Billing Extension which will show up in quickpicks when the Billing Extension has to be assigned ***** | ||
| PROCEDURE_NAME | VARCHAR2 | 80 | Yes | This is the exact package.procedure name that the appropriate program will execute from within the database when the Billing Extension is called | ||
| AMT_REQD_FLAG | VARCHAR2 | 1 | Yes | When set to 'Yes' users will be forced to enter an amount when assigning the Billing Extension ***** | ||
| PERCENTAGE_REQD_FLAG | VARCHAR2 | 1 | Yes | When set to 'Yes' users would be forced to enter a percentage when assigning a Billing Extension | ||
| CALLING_PROCESS | VARCHAR2 | 1 | Yes | This can have the values 'Revenue', 'Invoice' or 'Both'. This field will determine which program will execute the billing extension | ||
| EXTENSION_DESC | VARCHAR2 | 240 | Description of the Billing Extension ***** | |||
| DEFAULT_EVENT_DESCRIPTION | VARCHAR2 | 240 | If no description is passed to the pre-defined procedure that inserts the events (supplied by PA), this default event description will be used as the event description | |||
| PROCESSING_ORDER | NUMBER | 18 | Yes | Billing Extensions will be executed in the order specified here. A Billing Extension with a processing_order of 10 will execute before a Billing Extension with a processing_order of 20 | ||
| START_DATE_ACTIVE | DATE | Yes | When assigning Billing Extensions only Billing Extensions with a start date before sysdate will show up in the quickpick | |||
| END_DATE_ACTIVE | DATE | When assigning Billing Extensions only Billing Extensions with an end date after sysdate will show up in the quickpick | ||||
| TRX_INDEPENDENT_FLAG | VARCHAR2 | 1 | When this flag is set the Billing Extension will be called even if there are no transactions being processed | |||
| BEFORE_PRE_PROCESS_FLAG | VARCHAR2 | 1 | Extension will be called before pre process run ***** | |||
| BEFORE_DELETION_FLAG | VARCHAR2 | 1 | Extension will be called before deletion ***** | |||
| AFTER_DRAFT_CREATION_FLAG | VARCHAR2 | 1 | Extension will be called after draft creation ***** | |||
| DEFAULT_EVENT_TYPE_ID | NUMBER | 18 | If no description is passed to the pre-defined procedure that inserts the events (supplied by PA), this default event type be used when inserting the event ***** | |||
| PREDEFINED_FLAG | VARCHAR2 | 1 | Yes | When this flag is set it indicates that the billing extension is predefined | ||
| DEFAULT_COST_PLAN_TYPE_ID | NUMBER | 18 | If no Revenue Fin plan Type id is passed to the predefined procedure that determines the Fin plan budget amount (Supplied by Projects), this default revenue fin plan type id to be used when determining revenue fin plan amounts | |||
| 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. | Billing Extensions (PJB_BILL_EXTN_DESC_FLEX) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Extensions (PJB_BILL_EXTN_DESC_FLEX) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Extensions (PJB_BILL_EXTN_DESC_FLEX) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Extensions (PJB_BILL_EXTN_DESC_FLEX) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Extensions (PJB_BILL_EXTN_DESC_FLEX) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Extensions (PJB_BILL_EXTN_DESC_FLEX) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Extensions (PJB_BILL_EXTN_DESC_FLEX) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Extensions (PJB_BILL_EXTN_DESC_FLEX) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Extensions (PJB_BILL_EXTN_DESC_FLEX) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Extensions (PJB_BILL_EXTN_DESC_FLEX) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Extensions (PJB_BILL_EXTN_DESC_FLEX) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Extensions (PJB_BILL_EXTN_DESC_FLEX) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Extensions (PJB_BILL_EXTN_DESC_FLEX) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Extensions (PJB_BILL_EXTN_DESC_FLEX) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Extensions (PJB_BILL_EXTN_DESC_FLEX) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Extensions (PJB_BILL_EXTN_DESC_FLEX) | ||
| 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 |
|---|---|---|
| pjb_billing_assignments | pjb_billing_extensions | BILLING_EXTENSION_ID |
| pjb_assignment_details | pjb_billing_extensions | BILLING_EXTENSION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJB_BILLING_EXTENSIONS_U1 | Unique | Default | BILLING_EXTENSION_ID, ORA_SEED_SET1 |
| PJB_BILLING_EXTENSIONS_U11 | Unique | Default | BILLING_EXTENSION_ID, ORA_SEED_SET2 |
| PJB_BILLING_EXTENSIONS_U2 | Unique | Default | BILLING_EXTENSION_NAME, ORA_SEED_SET1 |
| PJB_BILLING_EXTENSIONS_U21 | Unique | Default | BILLING_EXTENSION_NAME, ORA_SEED_SET2 |