[Home] [Help] [Dependency Information]
Object Name: | AR_INVOICE_TOTALS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AR.AR_INVOICE_TOTALS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
The AR_INVOICE_TOTALS_V view, which is one of eight transaction printing views that Oracle Receivables provides, collects the total amount for all lines, tax, and freight charges that are associated with a transaction. A system administrator or Oracle consultant can use transaction printing views to extract transaction information from Receivables and then print the data in a custom format using Oracle Reports or a similar, SQL-based report generator.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TOTAL_TAX_AMOUNT | NUMBER | Total Tax Amount | ||
TOTAL_FREIGHT_AMOUNT | NUMBER | Total Freight Amount | ||
TOTAL_LINE_AMOUNT | NUMBER | Total Line Amount | ||
TOTAL_AMOUNT | NUMBER | Total Amount | ||
CUSTOMER_TRX_ID | NUMBER | (15) | Yes | Invoice Indentifier |
Cut, paste (and edit) the following text to query this object:
SELECT TOTAL_TAX_AMOUNT
, TOTAL_FREIGHT_AMOUNT
, TOTAL_LINE_AMOUNT
, TOTAL_AMOUNT
, CUSTOMER_TRX_ID
FROM APPS.AR_INVOICE_TOTALS_V;
APPS.AR_INVOICE_TOTALS_V is not referenced by any database object
|
|
|