[Home] [Help] [Dependency Information]
Object Name: | PA_BILLING_EXTENSIONS# |
---|---|
Object Type: | VIEW |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BILLING_EXTENSION_ID | NUMBER | (15) | Yes | |
NAME | VARCHAR2 | (30) | Yes | |
PROCEDURE_NAME | VARCHAR2 | (30) | Yes | |
AMOUNT_REQD_FLAG | VARCHAR2 | (1) | Yes | |
PERCENTAGE_REQD_FLAG | VARCHAR2 | (1) | Yes | |
CALLING_PROCESS | VARCHAR2 | (10) | Yes | |
PRE_PROCESSING_FLAG | VARCHAR2 | (1) | Yes | |
POST_PROCESSING_FLAG | VARCHAR2 | (1) | Yes | |
CALL_AFTER_REG_FLAG | VARCHAR2 | (1) | Yes | |
CALL_AFTER_ADJ_FLAG | VARCHAR2 | (1) | Yes | |
PROJECT_SPECIFIC_FLAG | VARCHAR2 | (1) | ||
MARK_EXP_ITEMS_FLAG | VARCHAR2 | (1) | ||
DESCRIPTION | VARCHAR2 | (250) | ||
DEFAULT_EVENT_DESCRIPTION | VARCHAR2 | (250) | Yes | |
PROCESSING_ORDER | NUMBER | (15) | Yes | |
START_DATE_ACTIVE | DATE | Yes | ||
END_DATE_ACTIVE | DATE | |||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
TRX_INDEPENDENT_FLAG | VARCHAR2 | (1) | ||
DEFAULT_EVENT_TYPE | VARCHAR2 | (30) | ||
CALL_BEFORE_DEL_FLAG | VARCHAR2 | (1) | Yes | |
DEFAULT_COST_BUDGET_TYPE_CODE | VARCHAR2 | (30) | ||
DEFAULT_REV_BUDGET_TYPE_CODE | VARCHAR2 | (30) | ||
CALL_AFTER_CANCEL_INV_FLAG | VARCHAR2 | (1) | Yes | |
CALL_AFTER_WOFF_INV_FLAG | VARCHAR2 | (1) | Yes | |
CALL_POST_REG_FLAG | VARCHAR2 | (1) | Yes | |
PREDEFINED_FLAG | VARCHAR2 | (1) | Yes | |
DEFAULT_REV_PLAN_TYPE_ID | NUMBER | (15) | ||
DEFAULT_COST_PLAN_TYPE_ID | NUMBER | (15) | ||
CALL_AFTER_CONCESSION_INV_FLAG | VARCHAR2 | (1) | ||
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#;
|
|
|