[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | JAI_PO_REQUEST_T |
|---|---|
| Object Type: | TABLE |
| Owner: | JA |
| FND Design Data: |  JA.JAI_PO_REQUEST_T
|
| Subobject Name: | |
| Status: | VALID |
Used by JAINPOCR concurrent for defaulting taxes
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LINE_LOCATION_ID | NUMBER | (15) | Foreign key to PO_LINE_LOCATIONS_ALL.line_location_id. | |
| TAX_LINE_NO | NUMBER | (15) | Indicates the line number of the tax which are attached to Scheduled Release shipment. | |
| PO_LINE_ID | NUMBER | (15) | Foreign key to PO_LINES_ALL.po_line_id. | |
| PO_HEADER_ID | NUMBER | (15) | Foreign key to PO_HEADERS_ALL.po_header_id. | |
| PRECEDENCE_1 | NUMBER | Indicates the first precedence on which this tax is based on for tax calculation. | ||
| PRECEDENCE_2 | NUMBER | Indicates the second precedence on which this tax is based on for tax calculation. | ||
| PRECEDENCE_3 | NUMBER | Indicates the third precedence on which this tax is based on for tax calculation. | ||
| PRECEDENCE_4 | NUMBER | Indicates the fourth precedence on which this tax is based on for tax calculation. | ||
| PRECEDENCE_5 | NUMBER | Indicates fifth precedence on which this tax is based on for tax calculation. | ||
| TAX_ID | NUMBER | (15) | Foreign key to JAI_CMN_TAXES_ALL.tax_id. | |
| CURRENCY | VARCHAR2 | (15) | Currency Code of the tax. | |
| TAX_RATE | NUMBER | Rate of the tax in which the tax is calculated. | ||
| QTY_RATE | NUMBER | Rate/ UOM for UOM based taxes. | ||
| UOM | VARCHAR2 | (3) | UOM Code in which the tax has to be calculated in case of UOM based taxes. | |
| TAX_AMOUNT | NUMBER | Calculated tax amount based on currency, tax_rate, uom and qty_rate, precedences and base amount. | ||
| TAX_TYPE | VARCHAR2 | (30) | Type of the tax (e.g. Excise, Sales). | |
| VENDOR_ID | NUMBER | (15) | Foreign key to PO_VENDORS.vendor_id to which this tax is attached. | |
| MODVAT_FLAG | VARCHAR2 | (1) | Indicates whether MODVAT can be claimed on the tax or not. If `Y` then tax can be claimed. | |
| LINE_FOCUS_ID | NUMBER | (15) | Foreign key to JAI_PO_LINE_LOCATIONS.line_focus_id. This field combined with tax_id form the Unique key for this table. | |
| TAX_TARGET_AMOUNT | NUMBER | Tax amount on which the tax is calculated. i.e. base amount. | ||
| 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) | Foreign key to JAI_CMN_TAX_CTGS_ALL.tax_category_id. Indicates from which tax category that this tax has been defaulted. | |
| 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
, LINE_FOCUS_ID
, TAX_TARGET_AMOUNT
, 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_REQUEST_T;
JA.JAI_PO_REQUEST_T does not reference any database object
JA.JAI_PO_REQUEST_T is referenced by following:
JA
JAI_PO_REQUEST_T#
|
|
|
|