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


TABLE: JA.JAI_RCV_LINE_TAXES

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


This Table holds the Information of the Receipt Taxes.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_RCV_LINE_TAXES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTAX_ID
ColumnSHIPMENT_LINE_ID
JAI_RCV_LINE_TAXES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTAX_ID
ColumnSHIPMENT_LINE_ID
ColumnTRANSACTION_ID
JAI_RCV_LINE_TAXES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSHIPMENT_LINE_ID
JAI_RCV_LINE_TAXES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSHIPMENT_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
SHIPMENT_LINE_ID NUMBER (15) Yes Indicates the shipment line identifier.
TAX_LINE_NO NUMBER (15) Yes Indicates the Tax Line no.
SHIPMENT_HEADER_ID NUMBER (15)
Indicates the shipment header identifier.
TAX_ID NUMBER (15) Yes Indicates the Tax Identifier.
TAX_NAME VARCHAR2 (50)
Indicates the Tax Name.
CURRENCY VARCHAR2 (15) Yes Indicates the Currency.
TAX_RATE NUMBER

Indicates the Tax Rate.
QTY_RATE NUMBER

Indicates the Quantity Rate.
UOM VARCHAR2 (15)
Indicates the Unit of Measure.
TAX_AMOUNT NUMBER

Indicates Tax Amount.
TAX_TYPE VARCHAR2 (30)
Indicates Tax Type.
MODVAT_FLAG VARCHAR2 (1)
Indicates whether a Tax is Modvatable or not.
VENDOR_ID NUMBER (15)
Indicates the supplier 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
CLAIMABLE_AMOUNT NUMBER

Indicates the Recoverable Amount.
CLAIMED_AMOUNT NUMBER

Indicates the Recovered Amount.
MODVAT_CLAIMED_AMOUNT NUMBER

Indicates the Modvat Claimed amount.
TRANSACTION_ID NUMBER

Transaction unique identifier
VENDOR_SITE_ID NUMBER

Indicates Supplier Site Identifier for Third Party Taxes
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_TARGET_AMOUNT NUMBER

Not currently used
ASSESSABLE_VALUE NUMBER

Assessable value
THIRD_PARTY_FLAG VARCHAR2 (1)
Indicates if the Tax is a Third Party Tax
ATTRIBUTE_DESC VARCHAR2 (150)
Not currently used
ATTRIBUTE1 VARCHAR2 (150)
Not currently used
ATTRIBUTE2 VARCHAR2 (150)
Not currently used
ATTRIBUTE3 VARCHAR2 (150)
Not currently used
ATTRIBUTE4 VARCHAR2 (150)
Not currently used
ATTRIBUTE5 VARCHAR2 (150)
Not currently used
TAX_MODIFIED_MANUALLY VARCHAR2 (2)
Not currently used
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.
BOE_COPIED_FLAG VARCHAR2 (1)
'Y' indicates that the tax line coped from BOE
Query Text

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


SELECT SHIPMENT_LINE_ID
,      TAX_LINE_NO
,      SHIPMENT_HEADER_ID
,      TAX_ID
,      TAX_NAME
,      CURRENCY
,      TAX_RATE
,      QTY_RATE
,      UOM
,      TAX_AMOUNT
,      TAX_TYPE
,      MODVAT_FLAG
,      VENDOR_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CLAIMABLE_AMOUNT
,      CLAIMED_AMOUNT
,      MODVAT_CLAIMED_AMOUNT
,      TRANSACTION_ID
,      VENDOR_SITE_ID
,      PRECEDENCE_1
,      PRECEDENCE_2
,      PRECEDENCE_3
,      PRECEDENCE_4
,      PRECEDENCE_5
,      TAX_TARGET_AMOUNT
,      ASSESSABLE_VALUE
,      THIRD_PARTY_FLAG
,      ATTRIBUTE_DESC
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      TAX_MODIFIED_MANUALLY
,      OBJECT_VERSION_NUMBER
,      PRECEDENCE_6
,      PRECEDENCE_7
,      PRECEDENCE_8
,      PRECEDENCE_9
,      PRECEDENCE_10
,      BOE_COPIED_FLAG
FROM JA.JAI_RCV_LINE_TAXES;

Dependencies

[top of page]

JA.JAI_RCV_LINE_TAXES does not reference any database object

JA.JAI_RCV_LINE_TAXES is referenced by following:

SchemaJA
ViewJAI_RCV_LINE_TAXES#