[Home] [Help] [Dependency Information]
Object Name: | CSI_FA_TRANSACTIONS# |
---|---|
Object Type: | VIEW |
Owner: | CSI |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERFACE_HEADER_ID | NUMBER | Yes | ||
INTERFACE_LINE_ID | NUMBER | Yes | ||
TRANSACTION_SOURCE_TYPE | VARCHAR2 | (30) | Yes | |
DISTRIBUTION_ID | NUMBER | Yes | ||
TRANSACTION_DATE | DATE | Yes | ||
TRANSACTION_UNITS | NUMBER | Yes | ||
TRANSACTION_COST | NUMBER | |||
PARENT_MASS_ADDITION_ID | NUMBER | |||
PA_ASSET_LINE_ID | NUMBER | |||
TRANSFER_DISTRIBUTION_ID | NUMBER | |||
RETIREMENT_ID | NUMBER | |||
STATUS_CODE | VARCHAR2 | (15) | Yes | |
DATE_PROCESSED | DATE | |||
DATE_NOTIFIED | DATE | |||
ERROR_FLAG | VARCHAR2 | (1) | Yes | |
ERROR_TEXT | VARCHAR2 | (2000) | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT INTERFACE_HEADER_ID
, INTERFACE_LINE_ID
, TRANSACTION_SOURCE_TYPE
, DISTRIBUTION_ID
, TRANSACTION_DATE
, TRANSACTION_UNITS
, TRANSACTION_COST
, PARENT_MASS_ADDITION_ID
, PA_ASSET_LINE_ID
, TRANSFER_DISTRIBUTION_ID
, RETIREMENT_ID
, STATUS_CODE
, DATE_PROCESSED
, DATE_NOTIFIED
, ERROR_FLAG
, ERROR_TEXT
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM CSI.CSI_FA_TRANSACTIONS#;
|
|
|