[Home] [Help] [Dependency Information]
Object Name: | OZF_QUOTA_HEADER |
---|---|
Object Type: | TYPE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Type Code: | OBJECT |
---|---|
Predefined: | NO |
Incomplete: | NO |
Name | Datatype | Length | Prcn |
---|---|---|---|
FUND_ID | NUMBER |
|
|
LAST_UPDATE_DATE | DATE |
|
|
LAST_UPDATED_BY | NUMBER |
|
15 |
CREATION_DATE | DATE |
|
|
CREATED_BY | NUMBER |
|
15 |
LAST_UPDATE_LOGIN | NUMBER |
|
15 |
OBJECT_VERSION_NUMBER | NUMBER |
|
|
CREATED_FROM | VARCHAR2 | (30) | |
REQUEST_ID | NUMBER |
|
15 |
PROGRAM_APPLICATION_ID | NUMBER |
|
15 |
PROGRAM_ID | NUMBER |
|
15 |
PROGRAM_UPDATE_DATE | DATE |
|
|
FUND_NUMBER | VARCHAR2 | (30) | |
PARENT_FUND_ID | NUMBER |
|
|
CATEGORY_ID | NUMBER |
|
|
FUND_TYPE | VARCHAR2 | (30) | |
FUND_USAGE | VARCHAR2 | (30) | |
STATUS_CODE | VARCHAR2 | (30) | |
STATUS_DATE | DATE |
|
|
USER_STATUS_ID | NUMBER |
|
|
ACCRUED_LIABLE_ACCOUNT | NUMBER |
|
15 |
DED_ADJUSTMENT_ACCOUNT | NUMBER |
|
15 |
LIABILITY_FLAG | VARCHAR2 | (1) | |
SET_OF_BOOKS_ID | NUMBER |
|
|
START_PERIOD_ID | NUMBER |
|
|
END_PERIOD_ID | NUMBER |
|
|
START_DATE_ACTIVE | DATE |
|
|
END_DATE_ACTIVE | DATE |
|
|
BUDGET_AMOUNT_TC | NUMBER |
|
|
BUDGET_AMOUNT_FC | NUMBER |
|
|
AVAILABLE_AMOUNT | NUMBER |
|
|
DISTRIBUTED_AMOUNT | NUMBER |
|
|
CURRENCY_CODE_TC | VARCHAR2 | (15) | |
CURRENCY_CODE_FC | VARCHAR2 | (15) | |
EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | |
EXCHANGE_RATE_DATE | DATE |
|
|
EXCHANGE_RATE | NUMBER |
|
|
DEPARTMENT_ID | NUMBER |
|
|
COSTCENTRE_ID | NUMBER |
|
|
OWNER | NUMBER |
|
|
ACCRUAL_METHOD | VARCHAR2 | (30) | |
ACCRUAL_OPERAND | VARCHAR2 | (30) | |
ACCRUAL_RATE | NUMBER |
|
|
ACCRUAL_BASIS | VARCHAR2 | (30) | |
HIERARCHY | VARCHAR2 | (30) | |
HIERARCHY_ID | NUMBER |
|
|
HIERARCHY_LEVEL | VARCHAR2 | (30) | |
PARENT_NODE_ID | NUMBER |
|
|
NODE_ID | NUMBER |
|
|
BUDGET_FLAG | VARCHAR2 | (1) | |
EARNED_FLAG | VARCHAR2 | (1) | |
APPLY_ACCRUAL_ON | VARCHAR2 | (30) | |
ACCRUAL_PHASE | VARCHAR2 | (30) | |
ACCRUAL_CAP | NUMBER |
|
|
ACCRUAL_UOM | VARCHAR2 | (30) | |
ORIGINAL_BUDGET | NUMBER |
|
|
TRANSFERED_IN_AMT | NUMBER |
|
|
TRANSFERED_OUT_AMT | NUMBER |
|
|
HOLDBACK_AMT | NUMBER |
|
|
PLANNED_AMT | NUMBER |
|
|
COMMITTED_AMT | NUMBER |
|
|
EARNED_AMT | NUMBER |
|
|
PAID_AMT | NUMBER |
|
|
PLAN_TYPE | VARCHAR2 | (30) | |
PLAN_ID | NUMBER |
|
|
LIABLE_ACCNT_SEGMENTS | VARCHAR2 | (155) | |
ADJUSTMENT_ACCNT_SEGMENTS | VARCHAR2 | (155) | |
COUNTRY_ID | NUMBER |
|
|
TASK_ID | NUMBER |
|
|
CUSTOM_SETUP_ID | NUMBER |
|
|
THRESHOLD_ID | NUMBER |
|
|
FUND_CALENDAR | VARCHAR2 | (30) | |
START_PERIOD_NAME | VARCHAR2 | (30) | |
END_PERIOD_NAME | VARCHAR2 | (30) | |
ACCRUE_TO_LEVEL_ID | NUMBER |
|
|
ACCRUAL_QUANTITY | NUMBER |
|
|
ACCRUAL_DISCOUNT_LEVEL | VARCHAR2 | (30) | |
BUSINESS_UNIT_ID | NUMBER |
|
|
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) | |
ORG_ID | NUMBER |
|
32 |
RECAL_COMMITTED | NUMBER |
|
|
ROLLUP_ORIGINAL_BUDGET | NUMBER |
|
|
ROLLUP_TRANSFERED_IN_AMT | NUMBER |
|
|
ROLLUP_TRANSFERED_OUT_AMT | NUMBER |
|
|
ROLLUP_HOLDBACK_AMT | NUMBER |
|
|
ROLLUP_PLANNED_AMT | NUMBER |
|
|
ROLLUP_COMMITTED_AMT | NUMBER |
|
|
ROLLUP_RECAL_COMMITTED | NUMBER |
|
|
ROLLUP_EARNED_AMT | NUMBER |
|
|
ROLLUP_PAID_AMT | NUMBER |
|
|
FUND_NAME | VARCHAR2 | (240) | |
DESCRIPTION | VARCHAR2 | (4000) | |
RETROACTIVE_FLAG | VARCHAR2 | (1) | |
QUALIFIER_ID | NUMBER |
|
|
PREV_FUND_ID | NUMBER |
|
|
TRANSFERED_FLAG | VARCHAR2 | (1) | |
UTILIZED_AMT | NUMBER |
|
|
ROLLUP_UTILIZED_AMT | NUMBER |
|
|
PRODUCT_SPREAD_TIME_ID | NUMBER |
|
|
TERRITORY_ID | NUMBER |
|
|
TERRITORY_NAME | VARCHAR2 | (4000) | |
PRODUCT_SPREAD | OZF_TIME_PRODUCT_TYPE |
|
|
|
|