DBA Data[Home] [Help] [Dependency Information]

TABLE: JA.JAI_CMN_MATCH_TAXES

Object Details
Object Name: JAI_CMN_MATCH_TAXES
Object Type: TABLE
Owner: JA
FND Design Data: TableJA.JAI_CMN_MATCH_TAXES
Subobject Name:
Status: VALID


Stores the recomputed tax values based on the receipt line excise taxes and CVD for every issue of JA_IN_RG23_D applied to a receipt


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_CMN_MATCH_TAXES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnMATCH_TAX_ID
JAI_CMN_MATCH_TAXES_UK1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREF_LINE_ID
ColumnORDER_INVOICE
ColumnRECEIPT_ID
ColumnTAX_LINE_NO
Columns
Name Datatype Length Mandatory Comments
RECEIPT_ID NUMBER

Indicates JA_IN_RG23_d.register_id of the receipt against which the matching is done.
SUBINVENTORY VARCHAR2 (10)
Indicates the subinventory if ORDER_INVOICE is `O`.
REF_LINE_ID NUMBER

Foreign key to JA_IN_RECEIPTS_MATCH.ref_line_id.
TAX_LINE_NO NUMBER

Indicates the serial number for taxes.
PRECEDENCE_1 NUMBER

Indicates first precedence upon which the tax should be calculated.
PRECEDENCE_2 NUMBER

Indicates second precedence upon which the tax should be calculated.
PRECEDENCE_3 NUMBER

Indicates third precedence upon which the tax should be calculated.
PRECEDENCE_4 NUMBER

Indicates fourth precedence upon which the tax should be calculated.
PRECEDENCE_5 NUMBER

Indicates fifth precedence upon which the tax should be calculated.
TAX_ID NUMBER (15) Yes Indicates Tax identifier of the tax ; It is foreign key to JA_IN_TAX_CODES.tax_id.
TAX_RATE NUMBER

Indicates the TAX RATE ; It is foreign key to JA_IN_TAX_CODES.tax_rate.
QTY_RATE NUMBER

Indicates Quantity per rate ; It is foreign key to JA_IN_TAX_CODES.qty_rate.
UOM VARCHAR2 (3)
Indicates the Unit of Measurement of the tax ; It is foreign key to JA_IN_TAX_CODES.UOM_CODE.
TAX_AMOUNT NUMBER

Indicates tax amount for the matched quaniity.
BASE_TAX_AMOUNT NUMBER

Indicates the base amount on which the tax amount is calculated.
FUNC_TAX_AMOUNT NUMBER

Indicates the tax amount in functional currency.
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
TOTAL_TAX_AMOUNT NUMBER

Indicates total tax amount.
ORDER_INVOICE VARCHAR2 (2)
Indicates whether the matching is done for Order(`O`) or Invoice(`I`).
MATCH_TAX_ID NUMBER (15) Yes Match tax identifier
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
PRECEDENCE_6 NUMBER

Sixth precedence on which this tax is dependent.
PRECEDENCE_7 NUMBER

Seventh precedence on which this tax is dependent.
PRECEDENCE_8 NUMBER

Eighth precedence on which this tax is dependent.
PRECEDENCE_9 NUMBER

Nineth precedence on which this tax is dependent.
PRECEDENCE_10 NUMBER

Tenth precedence on which this tax is dependent.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RECEIPT_ID
,      SUBINVENTORY
,      REF_LINE_ID
,      TAX_LINE_NO
,      PRECEDENCE_1
,      PRECEDENCE_2
,      PRECEDENCE_3
,      PRECEDENCE_4
,      PRECEDENCE_5
,      TAX_ID
,      TAX_RATE
,      QTY_RATE
,      UOM
,      TAX_AMOUNT
,      BASE_TAX_AMOUNT
,      FUNC_TAX_AMOUNT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      TOTAL_TAX_AMOUNT
,      ORDER_INVOICE
,      MATCH_TAX_ID
,      OBJECT_VERSION_NUMBER
,      PRECEDENCE_6
,      PRECEDENCE_7
,      PRECEDENCE_8
,      PRECEDENCE_9
,      PRECEDENCE_10
FROM JA.JAI_CMN_MATCH_TAXES;

Dependencies

[top of page]

JA.JAI_CMN_MATCH_TAXES does not reference any database object

JA.JAI_CMN_MATCH_TAXES is referenced by following:

SchemaAPPS
SynonymJAI_CMN_MATCH_TAXES