[Home] [Help] [Dependency Information]
Object Name: | FUN_TRANSFERS# |
---|---|
Object Type: | VIEW |
Owner: | FUN |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CURRENCY | VARCHAR2 | (15) | ||
BATCH_NUMBER | VARCHAR2 | (20) | ||
INITIATOR_NAME | VARCHAR2 | (360) | ||
RECIPIENT_NAME | VARCHAR2 | (360) | ||
TRX_TYPE_NAME | VARCHAR2 | (25) | ||
TRX_TYPE_CODE | VARCHAR2 | (15) | ||
PERIOD_NAME | VARCHAR2 | (15) | ||
LEDGER_NAME | VARCHAR2 | (30) | ||
TRX_STATUS | VARCHAR2 | (30) | ||
AMOUNT_CR | NUMBER | |||
AMOUNT_DR | NUMBER | |||
DESCRIPTION | VARCHAR2 | (240) | ||
PARTY_TYPE_FLAG | VARCHAR2 | (1) | ||
ERROR_MSG | VARCHAR2 | (2000) | ||
APPROVER | VARCHAR2 | (2000) | ||
GL_DATE | DATE | |||
BATCH_DATE | DATE | |||
CUSTOMER | VARCHAR2 | (50) | ||
SUPPLIER | VARCHAR2 | (80) | ||
INVOICE_NUMBER | VARCHAR2 | (50) | ||
ORG_ID | NUMBER | (15) | ||
ORG_NAME | VARCHAR2 | (360) | ||
REQUEST_ID | NUMBER | (15) | ||
TRX_ID | NUMBER | (15) | ||
INITIATOR_ID | NUMBER | (15) | ||
RECIPIENT_ID | NUMBER | (15) | ||
LEDGER_ID | NUMBER | (15) | ||
ERROR_CODE | VARCHAR2 | (30) | ||
PAYABLES_CCID | NUMBER | (15) | ||
BATCH_ID | NUMBER | (15) | ||
LE_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT CURRENCY
, BATCH_NUMBER
, INITIATOR_NAME
, RECIPIENT_NAME
, TRX_TYPE_NAME
, TRX_TYPE_CODE
, PERIOD_NAME
, LEDGER_NAME
, TRX_STATUS
, AMOUNT_CR
, AMOUNT_DR
, DESCRIPTION
, PARTY_TYPE_FLAG
, ERROR_MSG
, APPROVER
, GL_DATE
, BATCH_DATE
, CUSTOMER
, SUPPLIER
, INVOICE_NUMBER
, ORG_ID
, ORG_NAME
, REQUEST_ID
, TRX_ID
, INITIATOR_ID
, RECIPIENT_ID
, LEDGER_ID
, ERROR_CODE
, PAYABLES_CCID
, BATCH_ID
, LE_ID
FROM FUN.FUN_TRANSFERS#;
|
|
|