[Home] [Help] [Dependency Information]
Object Name: | ZX_SIM_TRX_DISTS# |
---|---|
Object Type: | VIEW |
Owner: | ZX |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | Yes | ||
ENTITY_CODE | VARCHAR2 | (30) | Yes | |
EVENT_CLASS_CODE | VARCHAR2 | (30) | Yes | |
TRX_ID | NUMBER | |||
HDR_TRX_USER_KEY1 | VARCHAR2 | (150) | ||
HDR_TRX_USER_KEY2 | VARCHAR2 | (150) | ||
HDR_TRX_USER_KEY3 | VARCHAR2 | (150) | ||
HDR_TRX_USER_KEY4 | VARCHAR2 | (150) | ||
HDR_TRX_USER_KEY5 | VARCHAR2 | (150) | ||
HDR_TRX_USER_KEY6 | VARCHAR2 | (150) | ||
TRX_LINE_ID | NUMBER | |||
LINE_TRX_USER_KEY1 | VARCHAR2 | (150) | ||
LINE_TRX_USER_KEY2 | VARCHAR2 | (150) | ||
LINE_TRX_USER_KEY3 | VARCHAR2 | (150) | ||
LINE_TRX_USER_KEY4 | VARCHAR2 | (150) | ||
LINE_TRX_USER_KEY5 | VARCHAR2 | (150) | ||
LINE_TRX_USER_KEY6 | VARCHAR2 | (150) | ||
TRX_LEVEL_TYPE | VARCHAR2 | (30) | Yes | |
TRX_LINE_DIST_ID | NUMBER | |||
DIST_TRX_USER_KEY1 | VARCHAR2 | (150) | ||
DIST_TRX_USER_KEY2 | VARCHAR2 | (150) | ||
DIST_TRX_USER_KEY3 | VARCHAR2 | (150) | ||
DIST_TRX_USER_KEY4 | VARCHAR2 | (150) | ||
DIST_TRX_USER_KEY5 | VARCHAR2 | (150) | ||
DIST_TRX_USER_KEY6 | VARCHAR2 | (150) | ||
DIST_LEVEL_ACTION | VARCHAR2 | (30) | Yes | |
TRX_LINE_DIST_DATE | DATE | Yes | ||
ITEM_DIST_NUMBER | NUMBER | |||
DIST_INTENDED_USE | VARCHAR2 | (240) | ||
TAX_INCLUSION_FLAG | VARCHAR2 | (1) | ||
TAX_CODE | VARCHAR2 | (30) | ||
APPLIED_FROM_TAX_DIST_ID | NUMBER | |||
ADJUSTED_DOC_TAX_DIST_ID | NUMBER | |||
TASK_ID | NUMBER | |||
AWARD_ID | NUMBER | |||
PROJECT_ID | NUMBER | |||
EXPENDITURE_TYPE | VARCHAR2 | (30) | ||
EXPENDITURE_ORGANIZATION_ID | NUMBER | |||
EXPENDITURE_ITEM_DATE | DATE | |||
TRX_LINE_DIST_AMT | NUMBER | Yes | ||
TRX_LINE_DIST_QTY | NUMBER | |||
TRX_LINE_QUANTITY | NUMBER | Yes | ||
ACCOUNT_CCID | NUMBER | |||
ACCOUNT_STRING | VARCHAR2 | (2000) | ||
REF_DOC_APPLICATION_ID | NUMBER | |||
REF_DOC_ENTITY_CODE | VARCHAR2 | (30) | ||
REF_DOC_EVENT_CLASS_CODE | VARCHAR2 | (30) | ||
REF_DOC_TRX_ID | NUMBER | |||
REF_DOC_HDR_TRX_USER_KEY1 | VARCHAR2 | (150) | ||
REF_DOC_HDR_TRX_USER_KEY2 | VARCHAR2 | (150) | ||
REF_DOC_HDR_TRX_USER_KEY3 | VARCHAR2 | (150) | ||
REF_DOC_HDR_TRX_USER_KEY4 | VARCHAR2 | (150) | ||
REF_DOC_HDR_TRX_USER_KEY5 | VARCHAR2 | (150) | ||
REF_DOC_HDR_TRX_USER_KEY6 | VARCHAR2 | (150) | ||
REF_DOC_LINE_ID | NUMBER | |||
REF_DOC_LIN_TRX_USER_KEY1 | VARCHAR2 | (150) | ||
REF_DOC_LIN_TRX_USER_KEY2 | VARCHAR2 | (150) | ||
REF_DOC_LIN_TRX_USER_KEY3 | VARCHAR2 | (150) | ||
REF_DOC_LIN_TRX_USER_KEY4 | VARCHAR2 | (150) | ||
REF_DOC_LIN_TRX_USER_KEY5 | VARCHAR2 | (150) | ||
REF_DOC_LIN_TRX_USER_KEY6 | VARCHAR2 | (150) | ||
REF_DOC_DIST_ID | NUMBER | |||
REF_DOC_DIST_TRX_USER_KEY1 | VARCHAR2 | (150) | ||
REF_DOC_DIST_TRX_USER_KEY2 | VARCHAR2 | (150) | ||
REF_DOC_DIST_TRX_USER_KEY3 | VARCHAR2 | (150) | ||
REF_DOC_DIST_TRX_USER_KEY4 | VARCHAR2 | (150) | ||
REF_DOC_DIST_TRX_USER_KEY5 | VARCHAR2 | (150) | ||
REF_DOC_DIST_TRX_USER_KEY6 | VARCHAR2 | (150) | ||
REF_DOC_CURR_CONV_RATE | NUMBER | |||
NUMERIC1 | NUMBER | |||
NUMERIC2 | NUMBER | |||
NUMERIC3 | NUMBER | |||
NUMERIC4 | NUMBER | |||
NUMERIC5 | NUMBER | |||
CHAR1 | VARCHAR2 | (150) | ||
CHAR2 | VARCHAR2 | (150) | ||
CHAR3 | VARCHAR2 | (150) | ||
CHAR4 | VARCHAR2 | (150) | ||
CHAR5 | VARCHAR2 | (150) | ||
DATE1 | DATE | |||
DATE2 | DATE | |||
DATE3 | DATE | |||
DATE4 | DATE | |||
DATE5 | DATE | |||
TRX_LINE_DIST_TAX_AMT | NUMBER | |||
HISTORICAL_FLAG | VARCHAR2 | (1) | ||
APPLIED_FROM_APPLICATION_ID | NUMBER | |||
APPLIED_FROM_EVENT_CLASS_CODE | VARCHAR2 | (30) | ||
APPLIED_FROM_ENTITY_CODE | VARCHAR2 | (30) | ||
APPLIED_FROM_TRX_ID | NUMBER | |||
APP_FROM_HDR_TRX_USER_KEY1 | VARCHAR2 | (150) | ||
APP_FROM_HDR_TRX_USER_KEY2 | VARCHAR2 | (150) | ||
APP_FROM_HDR_TRX_USER_KEY3 | VARCHAR2 | (150) | ||
APP_FROM_HDR_TRX_USER_KEY4 | VARCHAR2 | (150) | ||
APP_FROM_HDR_TRX_USER_KEY5 | VARCHAR2 | (150) | ||
APP_FROM_HDR_TRX_USER_KEY6 | VARCHAR2 | (150) | ||
APPLIED_FROM_LINE_ID | NUMBER | |||
APP_FROM_LIN_TRX_USER_KEY1 | VARCHAR2 | (150) | ||
APP_FROM_LIN_TRX_USER_KEY2 | VARCHAR2 | (150) | ||
APP_FROM_LIN_TRX_USER_KEY3 | VARCHAR2 | (150) | ||
APP_FROM_LIN_TRX_USER_KEY4 | VARCHAR2 | (150) | ||
APP_FROM_LIN_TRX_USER_KEY5 | VARCHAR2 | (150) | ||
APP_FROM_LIN_TRX_USER_KEY6 | VARCHAR2 | (150) | ||
APPLIED_FROM_DIST_ID | NUMBER | |||
APP_FROM_DST_TRX_USER_KEY1 | VARCHAR2 | (150) | ||
APP_FROM_DST_TRX_USER_KEY2 | VARCHAR2 | (150) | ||
APP_FROM_DST_TRX_USER_KEY3 | VARCHAR2 | (150) | ||
APP_FROM_DST_TRX_USER_KEY4 | VARCHAR2 | (150) | ||
APP_FROM_DST_TRX_USER_KEY5 | VARCHAR2 | (150) | ||
APP_FROM_DST_TRX_USER_KEY6 | VARCHAR2 | (150) | ||
ADJUSTED_DOC_APPLICATION_ID | NUMBER | |||
ADJUSTED_DOC_EVENT_CLASS_CODE | VARCHAR2 | (30) | ||
ADJUSTED_DOC_ENTITY_CODE | VARCHAR2 | (30) | ||
ADJUSTED_DOC_TRX_ID | NUMBER | |||
ADJ_DOC_HDR_TRX_USER_KEY1 | VARCHAR2 | (150) | ||
ADJ_DOC_HDR_TRX_USER_KEY2 | VARCHAR2 | (150) | ||
ADJ_DOC_HDR_TRX_USER_KEY3 | VARCHAR2 | (150) | ||
ADJ_DOC_HDR_TRX_USER_KEY4 | VARCHAR2 | (150) | ||
ADJ_DOC_HDR_TRX_USER_KEY5 | VARCHAR2 | (150) | ||
ADJ_DOC_HDR_TRX_USER_KEY6 | VARCHAR2 | (150) | ||
ADJUSTED_DOC_LINE_ID | NUMBER | |||
ADJ_DOC_LIN_TRX_USER_KEY1 | VARCHAR2 | (150) | ||
ADJ_DOC_LIN_TRX_USER_KEY2 | VARCHAR2 | (150) | ||
ADJ_DOC_LIN_TRX_USER_KEY3 | VARCHAR2 | (150) | ||
ADJ_DOC_LIN_TRX_USER_KEY4 | VARCHAR2 | (150) | ||
ADJ_DOC_LIN_TRX_USER_KEY5 | VARCHAR2 | (150) | ||
ADJ_DOC_LIN_TRX_USER_KEY6 | VARCHAR2 | (150) | ||
ADJUSTED_DOC_DIST_ID | NUMBER | |||
ADJ_DOC_DST_TRX_USER_KEY1 | VARCHAR2 | (150) | ||
ADJ_DOC_DST_TRX_USER_KEY2 | VARCHAR2 | (150) | ||
ADJ_DOC_DST_TRX_USER_KEY3 | VARCHAR2 | (150) | ||
ADJ_DOC_DST_TRX_USER_KEY4 | VARCHAR2 | (150) | ||
ADJ_DOC_DST_TRX_USER_KEY5 | VARCHAR2 | (150) | ||
ADJ_DOC_DST_TRX_USER_KEY6 | VARCHAR2 | (150) | ||
APPLIED_TO_DOC_CURR_CONV_RATE | NUMBER | |||
TAX_VARIANCE_CALC_FLAG | VARCHAR2 | (1) | ||
REF_DOC_TRX_LINE_DIST_QTY | NUMBER | |||
PRICE_DIFF | NUMBER | |||
UNIT_PRICE | NUMBER | |||
CURRENCY_EXCHANGE_RATE | NUMBER | |||
REF_DOC_TRX_LEVEL_TYPE | VARCHAR2 | (30) | ||
APPLIED_FROM_TRX_LEVEL_TYPE | VARCHAR2 | (30) | ||
ADJUSTED_DOC_TRX_LEVEL_TYPE | VARCHAR2 | (30) | ||
OVERRIDING_RECOVERY_RATE | NUMBER | |||
OBJECT_VERSION_NUMBER | NUMBER | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, ENTITY_CODE
, EVENT_CLASS_CODE
, TRX_ID
, HDR_TRX_USER_KEY1
, HDR_TRX_USER_KEY2
, HDR_TRX_USER_KEY3
, HDR_TRX_USER_KEY4
, HDR_TRX_USER_KEY5
, HDR_TRX_USER_KEY6
, TRX_LINE_ID
, LINE_TRX_USER_KEY1
, LINE_TRX_USER_KEY2
, LINE_TRX_USER_KEY3
, LINE_TRX_USER_KEY4
, LINE_TRX_USER_KEY5
, LINE_TRX_USER_KEY6
, TRX_LEVEL_TYPE
, TRX_LINE_DIST_ID
, DIST_TRX_USER_KEY1
, DIST_TRX_USER_KEY2
, DIST_TRX_USER_KEY3
, DIST_TRX_USER_KEY4
, DIST_TRX_USER_KEY5
, DIST_TRX_USER_KEY6
, DIST_LEVEL_ACTION
, TRX_LINE_DIST_DATE
, ITEM_DIST_NUMBER
, DIST_INTENDED_USE
, TAX_INCLUSION_FLAG
, TAX_CODE
, APPLIED_FROM_TAX_DIST_ID
, ADJUSTED_DOC_TAX_DIST_ID
, TASK_ID
, AWARD_ID
, PROJECT_ID
, EXPENDITURE_TYPE
, EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_ITEM_DATE
, TRX_LINE_DIST_AMT
, TRX_LINE_DIST_QTY
, TRX_LINE_QUANTITY
, ACCOUNT_CCID
, ACCOUNT_STRING
, REF_DOC_APPLICATION_ID
, REF_DOC_ENTITY_CODE
, REF_DOC_EVENT_CLASS_CODE
, REF_DOC_TRX_ID
, REF_DOC_HDR_TRX_USER_KEY1
, REF_DOC_HDR_TRX_USER_KEY2
, REF_DOC_HDR_TRX_USER_KEY3
, REF_DOC_HDR_TRX_USER_KEY4
, REF_DOC_HDR_TRX_USER_KEY5
, REF_DOC_HDR_TRX_USER_KEY6
, REF_DOC_LINE_ID
, REF_DOC_LIN_TRX_USER_KEY1
, REF_DOC_LIN_TRX_USER_KEY2
, REF_DOC_LIN_TRX_USER_KEY3
, REF_DOC_LIN_TRX_USER_KEY4
, REF_DOC_LIN_TRX_USER_KEY5
, REF_DOC_LIN_TRX_USER_KEY6
, REF_DOC_DIST_ID
, REF_DOC_DIST_TRX_USER_KEY1
, REF_DOC_DIST_TRX_USER_KEY2
, REF_DOC_DIST_TRX_USER_KEY3
, REF_DOC_DIST_TRX_USER_KEY4
, REF_DOC_DIST_TRX_USER_KEY5
, REF_DOC_DIST_TRX_USER_KEY6
, REF_DOC_CURR_CONV_RATE
, NUMERIC1
, NUMERIC2
, NUMERIC3
, NUMERIC4
, NUMERIC5
, CHAR1
, CHAR2
, CHAR3
, CHAR4
, CHAR5
, DATE1
, DATE2
, DATE3
, DATE4
, DATE5
, TRX_LINE_DIST_TAX_AMT
, HISTORICAL_FLAG
, APPLIED_FROM_APPLICATION_ID
, APPLIED_FROM_EVENT_CLASS_CODE
, APPLIED_FROM_ENTITY_CODE
, APPLIED_FROM_TRX_ID
, APP_FROM_HDR_TRX_USER_KEY1
, APP_FROM_HDR_TRX_USER_KEY2
, APP_FROM_HDR_TRX_USER_KEY3
, APP_FROM_HDR_TRX_USER_KEY4
, APP_FROM_HDR_TRX_USER_KEY5
, APP_FROM_HDR_TRX_USER_KEY6
, APPLIED_FROM_LINE_ID
, APP_FROM_LIN_TRX_USER_KEY1
, APP_FROM_LIN_TRX_USER_KEY2
, APP_FROM_LIN_TRX_USER_KEY3
, APP_FROM_LIN_TRX_USER_KEY4
, APP_FROM_LIN_TRX_USER_KEY5
, APP_FROM_LIN_TRX_USER_KEY6
, APPLIED_FROM_DIST_ID
, APP_FROM_DST_TRX_USER_KEY1
, APP_FROM_DST_TRX_USER_KEY2
, APP_FROM_DST_TRX_USER_KEY3
, APP_FROM_DST_TRX_USER_KEY4
, APP_FROM_DST_TRX_USER_KEY5
, APP_FROM_DST_TRX_USER_KEY6
, ADJUSTED_DOC_APPLICATION_ID
, ADJUSTED_DOC_EVENT_CLASS_CODE
, ADJUSTED_DOC_ENTITY_CODE
, ADJUSTED_DOC_TRX_ID
, ADJ_DOC_HDR_TRX_USER_KEY1
, ADJ_DOC_HDR_TRX_USER_KEY2
, ADJ_DOC_HDR_TRX_USER_KEY3
, ADJ_DOC_HDR_TRX_USER_KEY4
, ADJ_DOC_HDR_TRX_USER_KEY5
, ADJ_DOC_HDR_TRX_USER_KEY6
, ADJUSTED_DOC_LINE_ID
, ADJ_DOC_LIN_TRX_USER_KEY1
, ADJ_DOC_LIN_TRX_USER_KEY2
, ADJ_DOC_LIN_TRX_USER_KEY3
, ADJ_DOC_LIN_TRX_USER_KEY4
, ADJ_DOC_LIN_TRX_USER_KEY5
, ADJ_DOC_LIN_TRX_USER_KEY6
, ADJUSTED_DOC_DIST_ID
, ADJ_DOC_DST_TRX_USER_KEY1
, ADJ_DOC_DST_TRX_USER_KEY2
, ADJ_DOC_DST_TRX_USER_KEY3
, ADJ_DOC_DST_TRX_USER_KEY4
, ADJ_DOC_DST_TRX_USER_KEY5
, ADJ_DOC_DST_TRX_USER_KEY6
, APPLIED_TO_DOC_CURR_CONV_RATE
, TAX_VARIANCE_CALC_FLAG
, REF_DOC_TRX_LINE_DIST_QTY
, PRICE_DIFF
, UNIT_PRICE
, CURRENCY_EXCHANGE_RATE
, REF_DOC_TRX_LEVEL_TYPE
, APPLIED_FROM_TRX_LEVEL_TYPE
, ADJUSTED_DOC_TRX_LEVEL_TYPE
, OVERRIDING_RECOVERY_RATE
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM ZX.ZX_SIM_TRX_DISTS#;
|
|
|