[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_BILLING_EXTENSIONS |
|---|---|
| Object Type: | TABLE |
| Owner: | PA |
| FND Design Data: |  PA.PA_BILLING_EXTENSIONS
|
| Subobject Name: | |
| Status: | VALID |
PA_BILLING_EXTENSIONS stores the definition of a
billing extension that specifies how
the billing extension is assigned and
executed during revenue/invoice generation.
.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PA_BILLING_EXTENSIONS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 BILLING_EXTENSION_ID
ZD_EDITION_NAME
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BILLING_EXTENSION_ID | NUMBER | (15) | Yes | Primary key for the table |
| 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 | (30) | Yes | This is the exact package.procedure name that the appropriate program will execute from within the database when the Billing Extension is called |
| AMOUNT_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 | (10) | Yes | This can have the values 'Revenue', 'Invoice' or 'Both'. This field will determine which program will execute the billing extension |
| PRE_PROCESSING_FLAG | VARCHAR2 | (1) | Yes | When this flag is set the Billing Extension will be called before any processing (Revenue accrual or Invoicing) has occurred |
| POST_PROCESSING_FLAG | VARCHAR2 | (1) | Yes | When this flag is set the Billing Extension will be called after all processing (Revenue accrual or Invoicing) has taken place |
| CALL_AFTER_REG_FLAG | VARCHAR2 | (1) | Yes | When this flag is set the Billing Extension will be called after all regular transactions have been processed. Events created in this section will be attached to the regular draft revenue/invoice |
| CALL_AFTER_ADJ_FLAG | VARCHAR2 | (1) | Yes | When this flag is set the Billing Extension will be called after all crediting transactions are processed. The event created in this section will be attached to the crediting draft invoice/revenue |
| PROJECT_SPECIFIC_FLAG | VARCHAR2 | (1) | When this flag is set the Billing Extension can only be assigned at the Project/Task level and not at the Project Type level | |
| MARK_EXP_ITEMS_FLAG | VARCHAR2 | (1) | This column is there for future use. It will be used to indicate whether events created by this Billing Extension should FIFO mark expenditure items | |
| DESCRIPTION | VARCHAR2 | (250) | Description of the Billing Extension | |
| DEFAULT_EVENT_DESCRIPTION | VARCHAR2 | (250) | Yes | 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 | (15) | 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 | ||
| CREATION_DATE | DATE | Yes | Standard Who Column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who Column |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield context field | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| TRX_INDEPENDENT_FLAG | VARCHAR2 | (1) | When this flag is set the Billing Extension will be called even if there are no transactions being processed | |
| DEFAULT_EVENT_TYPE | VARCHAR2 | (30) | 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 | |
| CALL_BEFORE_DEL_FLAG | VARCHAR2 | (1) | Yes | When this flag is set the billing extension will be called before revenue or invoice transactions are deleted |
| DEFAULT_COST_BUDGET_TYPE_CODE | VARCHAR2 | (30) | If no Cost Budget Type Code is passed to the pre-defined procedure that determines the cost budget amount (Supplied by Projects),this default cost budget type code will be used when determining cost budget amounts | |
| DEFAULT_REV_BUDGET_TYPE_CODE | VARCHAR2 | (30) | If no Revenue Budget Type Code is passed to the pre-defined procedure that determines the cost budget amount (Supplied by Projects), this default revenue budget type code to be used when determining revenue budget amounts | |
| CALL_AFTER_CANCEL_INV_FLAG | VARCHAR2 | (1) | Yes | When this flag is set the billing extension will be called after cancellation invoice processing |
| CALL_AFTER_WOFF_INV_FLAG | VARCHAR2 | (1) | Yes | When this flag is set the billing extension will be called after write-off invoice processing |
| CALL_POST_REG_FLAG | VARCHAR2 | (1) | Yes | When this flag is set the billing extension will be called after regular automatic event processing. |
| PREDEFINED_FLAG | VARCHAR2 | (1) | Yes | When this flag is set it indicates that the billing extension is predefined |
| DEFAULT_REV_PLAN_TYPE_ID | NUMBER | (15) | 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 | |
| DEFAULT_COST_PLAN_TYPE_ID | NUMBER | (15) | 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 | |
| CALL_AFTER_CONCESSION_INV_FLAG | VARCHAR2 | (1) | Flag that specifies if the billing extension is to be called during concession invoice processing | |
| ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT BILLING_EXTENSION_ID
, NAME
, PROCEDURE_NAME
, AMOUNT_REQD_FLAG
, PERCENTAGE_REQD_FLAG
, CALLING_PROCESS
, PRE_PROCESSING_FLAG
, POST_PROCESSING_FLAG
, CALL_AFTER_REG_FLAG
, CALL_AFTER_ADJ_FLAG
, PROJECT_SPECIFIC_FLAG
, MARK_EXP_ITEMS_FLAG
, DESCRIPTION
, DEFAULT_EVENT_DESCRIPTION
, PROCESSING_ORDER
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, TRX_INDEPENDENT_FLAG
, DEFAULT_EVENT_TYPE
, CALL_BEFORE_DEL_FLAG
, DEFAULT_COST_BUDGET_TYPE_CODE
, DEFAULT_REV_BUDGET_TYPE_CODE
, CALL_AFTER_CANCEL_INV_FLAG
, CALL_AFTER_WOFF_INV_FLAG
, CALL_POST_REG_FLAG
, PREDEFINED_FLAG
, DEFAULT_REV_PLAN_TYPE_ID
, DEFAULT_COST_PLAN_TYPE_ID
, CALL_AFTER_CONCESSION_INV_FLAG
, ZD_EDITION_NAME
FROM PA.PA_BILLING_EXTENSIONS;
PA.PA_BILLING_EXTENSIONS does not reference any database object
PA.PA_BILLING_EXTENSIONS is referenced by following:
PA
PA_BILLING_EXTENSIONS#
|
|
|
|