[Home] [Help] [Dependency Information]
Object Name: | FV_TREASURY_EXTRACT_DETAILS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view is used as line level transaction object(SLA) for TREASURY_ACCOMPLISHMENT event class
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EVENT_ID | NUMBER | (15) | BC Event Id | |
LINE_NUMBER | NUMBER | (15) | BC Event Line Number | |
FV_PAY_ACCOUNTING_EVENT_ID | NUMBER | (15) | Federal Payment Accounting Event ID | |
FV_TREASURY_CONFIRMATION_ID | NUMBER | (15) | Federal Treasury Confirmation Id | |
FV_PAY_CHECK_ID | NUMBER | (15) | Federal Payment Check Id | |
FV_INV_CURRENCY_CODE | VARCHAR2 | (15) | Federal Invoice Currency Code | |
FV_PAY_DIST_AMOUNT | NUMBER | Federal Payment distribution amount | ||
FV_PAY_HIST_DIST_ID | NUMBER | (15) | Federal Payment history distribution Id | |
FV_PAYMENT_HISTORY_ID | NUMBER | (15) | Federal Payment history Id | |
FV_INV_DISTRIBUTION_ID | NUMBER | (15) | Federal Invoice Distribution Id | |
FV_INVOICE_PAYMENT_ID | NUMBER | (15) | Federal Invoice Payment Id | |
FV_REV_PAY_HIST_DIST_ID | NUMBER | (15) | Applied to Distribution Identifier for Void Payments | |
FV_REV_PMT_HIST_ID | NUMBER | (15) | AP Payment History ID which is reversed | |
FV_AP_CASH_CLEARING_CCID | NUMBER | (15) | Cash Clearing Account | |
DIT_CONFIRM_CASH_ACCOUNT | VARCHAR2 | (25) | DIT Confirm Cash Account | |
FV_INV_DIST_CCID | NUMBER | (15) | Invoice Distribution Code combination Id | |
FV_INV_DIST_AMOUNT | NUMBER | Invoice Distribution Amount | ||
FV_INV_DIST_LINE_NUMBER | NUMBER | (15) | Invoice Distribution Line number | |
FV_INV_LINE_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Invoice distribution line type code | |
FV_INVOICE_AMOUNT | NUMBER | Invoice Amount | ||
FV_INV_ACCTS_PAY_CCID | NUMBER | (15) | Invoice Accountts Pay code combination Id | |
FV_PO_DISTRIBUTION_ID | NUMBER | (15) | PO Distribution Id | |
FV_INV_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Invoice type lookup code | |
FV_INVOICE_DATE | DATE | Invoice Date | ||
FV_INV_EXCHANGE_DATE | DATE | Invoice Exchange Date | ||
FV_INV_EXCHANGE_RATE | NUMBER | Invoice Exchange Rate | ||
FV_INV_EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Invoice Exchange Rate Type | |
FV_APHD_INV_DIST_AMOUNT | NUMBER | APHD Invoice distribution amount | ||
FV_BUS_FLOW_AP_APP_ID | NUMBER | Applied to AP Application ID | ||
FV_BUS_FLOW_FV_APP_ID | NUMBER | Applied to FV Application ID | ||
FV_BUS_FLOW_INV_DIST_TYPE | CHAR | (11) | Applied to Invoice Distribution Link Type | |
FV_BUS_FLOW_INV_ENTITY_CODE | CHAR | (11) | Applied to Invoice Entity Code | |
FV_BUS_FLOW_INV_DIST_ID | NUMBER | (15) | Applied to Invoice Distribution Identifier | |
FV_BUS_FLOW_INV_ID | NUMBER | (15) | Applied to Invoice Id | |
FV_BUS_FLOW_PO_APP_ID | NUMBER | Applied to PO Application Id | ||
FV_BUS_FLOW_PO_DIST_TYPE | CHAR | (20) | Applied to PO Distribution Link Type | |
FV_BUS_FLOW_PO_ENTITY_CODE | CHAR | (14) | Applied to PO Entity Code | |
FV_BUS_FLOW_PMT_DIST_TYPE | CHAR | (11) | Applied to Payment Distribution Link Type | |
FV_BUS_FLOW_PMT_ENTITY_CODE | CHAR | (11) | Applied to Payment Entity Code | |
FV_BUS_FLOW_TREASURY_DIST_TYPE | CHAR | (29) | Applied to Treasury Confirmation Distribution Link Type | |
FV_BUS_FLOW_TREAS_ENTITY_CODE | CHAR | (21) | Applied to Treasury Confirmation Entity Code | |
FV_AP_CASH_ACCOUNT | NUMBER | (15) | Accounting flexfield identifier for the AP cash account | |
FV_AP_LIABILITY_ACCOUNT | NUMBER | (15) | Accounting Flexfield identifier for accounts payable liability account | |
FV_CHECK_DATE | DATE | Payment date | ||
FV_CHECK_NUMBER | NUMBER | (15) | Payment Number | |
FV_TREASURY_PAY_NUMBER | NUMBER | (15) | Number assigned to payment processed through internal clearing organization |
Cut, paste (and edit) the following text to query this object:
SELECT EVENT_ID
, LINE_NUMBER
, FV_PAY_ACCOUNTING_EVENT_ID
, FV_TREASURY_CONFIRMATION_ID
, FV_PAY_CHECK_ID
, FV_INV_CURRENCY_CODE
, FV_PAY_DIST_AMOUNT
, FV_PAY_HIST_DIST_ID
, FV_PAYMENT_HISTORY_ID
, FV_INV_DISTRIBUTION_ID
, FV_INVOICE_PAYMENT_ID
, FV_REV_PAY_HIST_DIST_ID
, FV_REV_PMT_HIST_ID
, FV_AP_CASH_CLEARING_CCID
, DIT_CONFIRM_CASH_ACCOUNT
, FV_INV_DIST_CCID
, FV_INV_DIST_AMOUNT
, FV_INV_DIST_LINE_NUMBER
, FV_INV_LINE_TYPE_LOOKUP_CODE
, FV_INVOICE_AMOUNT
, FV_INV_ACCTS_PAY_CCID
, FV_PO_DISTRIBUTION_ID
, FV_INV_TYPE_LOOKUP_CODE
, FV_INVOICE_DATE
, FV_INV_EXCHANGE_DATE
, FV_INV_EXCHANGE_RATE
, FV_INV_EXCHANGE_RATE_TYPE
, FV_APHD_INV_DIST_AMOUNT
, FV_BUS_FLOW_AP_APP_ID
, FV_BUS_FLOW_FV_APP_ID
, FV_BUS_FLOW_INV_DIST_TYPE
, FV_BUS_FLOW_INV_ENTITY_CODE
, FV_BUS_FLOW_INV_DIST_ID
, FV_BUS_FLOW_INV_ID
, FV_BUS_FLOW_PO_APP_ID
, FV_BUS_FLOW_PO_DIST_TYPE
, FV_BUS_FLOW_PO_ENTITY_CODE
, FV_BUS_FLOW_PMT_DIST_TYPE
, FV_BUS_FLOW_PMT_ENTITY_CODE
, FV_BUS_FLOW_TREASURY_DIST_TYPE
, FV_BUS_FLOW_TREAS_ENTITY_CODE
, FV_AP_CASH_ACCOUNT
, FV_AP_LIABILITY_ACCOUNT
, FV_CHECK_DATE
, FV_CHECK_NUMBER
, FV_TREASURY_PAY_NUMBER
FROM APPS.FV_TREASURY_EXTRACT_DETAILS_V;
|
|
|