[Home] [Help] [Dependency Information]
Object Name: | JAI_MTL_TRXS |
---|---|
Object Type: | TABLE |
Owner: | JA |
FND Design Data: | JA.JAI_MTL_TRXS |
Subobject Name: | |
Status: | VALID |
This table holds India tax related data pertaining to inter organization transfers done
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JAI_MTL_TRXS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | TRANSACTION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | (15) | Yes | Unique Transaction Identifier |
TRANSACTION_HEADER_ID | NUMBER | (15) | Yes | Transaction Header Identifier |
TRANSACTION_TEMP_ID | NUMBER | (15) | Indicates the transaction identifier for each line entered | |
TRANSACTION_TYPE_ID | NUMBER | (15) | Indicates the type of transaction .possible values are 3,21 .3 is for Direct Org Transfer,21 is for Intransit Shipment | |
FROM_ORGANIZATION | NUMBER | Yes | Indicates shipping organization Identifier | |
TO_ORGANIZATION | NUMBER | Destination Organization identifier | ||
INVENTORY_ITEM_ID | NUMBER | (15) | Yes | Inventory item Identifier |
FROM_SUBINVENTORY | VARCHAR2 | (10) | Indicates the subinventory from where the shipping of goods is done | |
TO_SUBINVENTORY | VARCHAR2 | (10) | Indicates the subinventory to which the goods are being shipped | |
LOCATION_ID | NUMBER | (15) | Yes | Location Identifier. |
QUANTITY | NUMBER | Indicates Quantity | ||
TAXCATEGORY_ID | NUMBER | (15) | Indicates Tax Category Identifier. | |
TAX_AMOUNT | NUMBER | Indicates Tax amount in the document currency | ||
QTY_REGISTER | VARCHAR2 | (30) | Indicates the Quantity register | |
AMT_REGISTER | VARCHAR2 | (30) | Indicates the Payment Register. | |
EXCISE_INVOICE_NO | VARCHAR2 | (200) | Indicates the excise invoice number generated. | |
SELLING_PRICE | NUMBER | Selling price of the inventory item. | ||
VAT_INVOICE_NO | VARCHAR2 | (200) | Indicates the vat invoice no generated | |
ASSESSABLE_VALUE | NUMBER | Value on which excise is calclulated | ||
VAT_ASSESSABLE_VALUE | NUMBER | Assessable value to be used for calulating VAT taxes. | ||
TRANSACTION_DATE | DATE | Date of Transaction | ||
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
TRANSACTION_UOM | VARCHAR2 | (3) | Unit of measurement for the transaction | |
TRANSACTION_COMMIT_DATE | DATE | Commit date of the transaction |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_ID
, TRANSACTION_HEADER_ID
, TRANSACTION_TEMP_ID
, TRANSACTION_TYPE_ID
, FROM_ORGANIZATION
, TO_ORGANIZATION
, INVENTORY_ITEM_ID
, FROM_SUBINVENTORY
, TO_SUBINVENTORY
, LOCATION_ID
, QUANTITY
, TAXCATEGORY_ID
, TAX_AMOUNT
, QTY_REGISTER
, AMT_REGISTER
, EXCISE_INVOICE_NO
, SELLING_PRICE
, VAT_INVOICE_NO
, ASSESSABLE_VALUE
, VAT_ASSESSABLE_VALUE
, TRANSACTION_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, TRANSACTION_UOM
, TRANSACTION_COMMIT_DATE
FROM JA.JAI_MTL_TRXS;
JA.JAI_MTL_TRXS does not reference any database object
JA.JAI_MTL_TRXS is referenced by following:
|
|
|