[Home] [Help] [Dependency Information]
Object Name: | FV_SF1080_DETAIL_TEMP |
---|---|
Object Type: | TABLE |
Owner: | FV |
FND Design Data: | FV.FV_SF1080_DETAIL_TEMP |
Subobject Name: | |
Status: | VALID |
FV_SF1080_DETAIL_TEMP stores line information from RA_CUSTOMER_TRX_LINES that has been selected based on the parameters passed for generation of the SF 1080 Voucher for Transfers between Appropriations or Funds document.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOMER_TRX_ID | NUMBER | (15) | Yes | Invoice identifier |
LINE_NUMBER | NUMBER | Yes | Line number of invoice | |
EXTENDED_AMOUNT | NUMBER | Yes | Transaction line amount | |
SALES_ORDER | VARCHAR2 | (50) | Sales order | |
DESCRIPTION | VARCHAR2 | (240) | Line description | |
QUANTITY_INVOICED | NUMBER | Quantity of invoice line | ||
UNIT_SELLING_PRICE | NUMBER | Selling price per unit for transaction line | ||
UOM_CODE | VARCHAR2 | (3) | Unit of measure code | |
ACCT_OFC_RECV_FND | VARCHAR2 | (800) | Full accounting classification segment information for office receiving fund |
Cut, paste (and edit) the following text to query this object:
SELECT CUSTOMER_TRX_ID
, LINE_NUMBER
, EXTENDED_AMOUNT
, SALES_ORDER
, DESCRIPTION
, QUANTITY_INVOICED
, UNIT_SELLING_PRICE
, UOM_CODE
, ACCT_OFC_RECV_FND
FROM FV.FV_SF1080_DETAIL_TEMP;
FV.FV_SF1080_DETAIL_TEMP does not reference any database object
FV.FV_SF1080_DETAIL_TEMP is referenced by following:
|
|
|