[Home] [Help] [Dependency Information]
Object Name: | JAI_AP_MATCH_INV_TAX_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | JA.JAI_AP_MATCH_INV_TAX_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MATCH_TYPE | VARCHAR2 | (15) | Indicates whether the invoice is PO Matched of Receipt Matched | |
INVOICE_ID | NUMBER | Indicates the invoice identifier | ||
PARENT_INVOICE_LINE_NUMBER | NUMBER | (15) | Indicates the line number of the invoice line for the current miscellaneous line | |
TRANSACTION_ID | NUMBER | Indicates the transaction Identifier of the receipt | ||
TAX_LINE_NO | NUMBER | (15) | Indicates the tax line number | |
TAX_ID | NUMBER | (15) | Indicates the tax identifier | |
TAX_TYPE | VARCHAR2 | (30) | Indicates the tax type | |
PRECEDENCE_1 | NUMBER | Indicates precedence 1 | ||
PRECEDENCE_2 | NUMBER | Indicates precedence 2 | ||
PRECEDENCE_3 | NUMBER | Indicates precedence 3 | ||
PRECEDENCE_4 | NUMBER | Indicates precedence 4 | ||
PRECEDENCE_5 | NUMBER | Indicates precedence 5 | ||
PRECEDENCE_6 | NUMBER | Indicates precedence 6 | ||
PRECEDENCE_7 | NUMBER | Indicates precedence 7 | ||
PRECEDENCE_8 | NUMBER | Indicates precedence 8 | ||
PRECEDENCE_9 | NUMBER | Indicates precedence 9 | ||
PRECEDENCE_10 | NUMBER | Indicates precedence 10 | ||
CURRENCY | VARCHAR2 | (15) | Indicates the currency of the tax | |
TAX_RATE | NUMBER | Indicates the tax rate of the tax | ||
QTY_RATE | NUMBER | Indicates the rate per unit of the tax | ||
UOM | VARCHAR2 | (15) | Indicates the unit of measurement of the tax | |
TAX_AMOUNT | NUMBER | Indicates the tax amount | ||
VENDOR_ID | NUMBER | (15) | Indicates the vendor identifier for the tax in case of a third party tax | |
VENDOR_SITE_ID | NUMBER | Indicates the vendor site identifier for the tax in case of a third party tax | ||
MODVAT_FLAG | VARCHAR2 | (1) | Indicates whether the tax is recoverable |
Cut, paste (and edit) the following text to query this object:
SELECT MATCH_TYPE
, INVOICE_ID
, PARENT_INVOICE_LINE_NUMBER
, TRANSACTION_ID
, TAX_LINE_NO
, TAX_ID
, TAX_TYPE
, PRECEDENCE_1
, PRECEDENCE_2
, PRECEDENCE_3
, PRECEDENCE_4
, PRECEDENCE_5
, PRECEDENCE_6
, PRECEDENCE_7
, PRECEDENCE_8
, PRECEDENCE_9
, PRECEDENCE_10
, CURRENCY
, TAX_RATE
, QTY_RATE
, UOM
, TAX_AMOUNT
, VENDOR_ID
, VENDOR_SITE_ID
, MODVAT_FLAG
FROM APPS.JAI_AP_MATCH_INV_TAX_V;
|
|
|