[Home] [Help] [Dependency Information]
Object Name: | JAI_PO_TAXES |
---|---|
Object Type: | TABLE |
Owner: | JA |
FND Design Data: | JA.JAI_PO_TAXES |
Subobject Name: | |
Status: | VALID |
Stores the information of localization tax lines at a PO line location level.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JAI_PO_TAXES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
LINE_FOCUS_ID
TAX_ID |
JAI_PO_TAXES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
LINE_LOCATION_ID
PO_HEADER_ID PO_LINE_ID |
JAI_PO_TAXES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PO_LINE_ID
PO_HEADER_ID |
JAI_PO_TAXES_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PO_HEADER_ID |
JAI_PO_TAXES_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PO_LINE_ID
LINE_LOCATION_ID TAX_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LINE_LOCATION_ID | NUMBER | (15) | PO line location identifier. | |
TAX_LINE_NO | NUMBER | (15) | Yes | The order of tax for the PO line location. |
PO_LINE_ID | NUMBER | (15) | PO line identifier. | |
PO_HEADER_ID | NUMBER | (15) | Yes | PO header identifier. |
PRECEDENCE_1 | NUMBER | Precedence 1 for the tax. | ||
PRECEDENCE_2 | NUMBER | Precedence 2 for the tax. | ||
PRECEDENCE_3 | NUMBER | Precedence 3 for the tax. | ||
PRECEDENCE_4 | NUMBER | Precedence 4 for the tax. | ||
PRECEDENCE_5 | NUMBER | Precedence 5 for the tax. | ||
TAX_ID | NUMBER | (15) | Yes | Tax identifier. |
CURRENCY | VARCHAR2 | (15) | Currency of the tax. | |
TAX_RATE | NUMBER | Percentage Rate of the tax. | ||
QTY_RATE | NUMBER | Quantity rate of the tax. | ||
UOM | VARCHAR2 | (3) | Unit of measurement. | |
TAX_AMOUNT | NUMBER | Tax amount. | ||
TAX_TYPE | VARCHAR2 | (30) | Tax type, same as defined in tax definition. | |
VENDOR_ID | NUMBER | (15) | Supplier identifier. | |
MODVAT_FLAG | VARCHAR2 | (1) | Possible values, Y or N or Null. Null is treated at par with N. The value indicates if the tax is recoverable. | |
TAX_TARGET_AMOUNT | NUMBER | Tax target amount. | ||
LINE_FOCUS_ID | NUMBER | (15) | Yes | Current line identifier |
CREATION_DATE | DATE | Standard Who column | ||
CREATED_BY | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
TAX_CATEGORY_ID | NUMBER | (15) | Populated for defaulted tax lines only. It indicates the tax category identifier that was used from the setup for defaulting. | |
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. |
Cut, paste (and edit) the following text to query this object:
SELECT LINE_LOCATION_ID
, TAX_LINE_NO
, PO_LINE_ID
, PO_HEADER_ID
, PRECEDENCE_1
, PRECEDENCE_2
, PRECEDENCE_3
, PRECEDENCE_4
, PRECEDENCE_5
, TAX_ID
, CURRENCY
, TAX_RATE
, QTY_RATE
, UOM
, TAX_AMOUNT
, TAX_TYPE
, VENDOR_ID
, MODVAT_FLAG
, TAX_TARGET_AMOUNT
, LINE_FOCUS_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, TAX_CATEGORY_ID
, OBJECT_VERSION_NUMBER
, PRECEDENCE_6
, PRECEDENCE_7
, PRECEDENCE_8
, PRECEDENCE_9
, PRECEDENCE_10
FROM JA.JAI_PO_TAXES;
JA.JAI_PO_TAXES does not reference any database object
JA.JAI_PO_TAXES is referenced by following:
|
|
|