eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: JA.JAI_CMN_RG_23D_TRXS

Object Details

Object Name:	JAI_CMN_RG_23D_TRXS
Object Type:	TABLE
Owner:	JA
FND Design Data:	JA.JAI_CMN_RG_23D_TRXS
Subobject Name:
Status:	VALID

Quantity register for Trading Organizations

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_CMN_RG_23D_TRXS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	REGISTER_ID
JAI_CMN_RG_23D_TRXS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SLNO
JAI_CMN_RG_23D_TRXS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RECEIPT_REF
JAI_CMN_RG_23D_TRXS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OTH_RECEIPT_ID_REF
JAI_CMN_RG_23D_TRXS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GOODS_ISSUE_ID
JAI_CMN_RG_23D_TRXS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMM_INVOICE_NO
JAI_CMN_RG_23D_TRXS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_TYPE INVENTORY_ITEM_ID
JAI_CMN_RG_23D_TRXS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVENTORY_ITEM_ID FIN_YEAR

Columns

Name	Datatype	Length	Mandatory	Comments
REGISTER_ID	NUMBER	(15)	Yes	Unique key for the table generated from sequence.
ORGANIZATION_ID	NUMBER	(15)	Yes	Indicates the organization in which the transaction is done.
LOCATION_ID	NUMBER	(15)	Yes	Indicates the location of the organization where the transaction is done.
SLNO	NUMBER	(15)	Yes	Indicates the sequence number of transaction based on organization, location, financial year and inventory item.
FIN_YEAR	NUMBER	(9)	Yes	Indicates the current financial year.
TRANSACTION_TYPE	VARCHAR2	(10)		Indicates the transaction type of the transaction. possible values `R`, `I`, `PI`, `RTV`, `MRTV`, `MR`.
QUANTITY_RECEIVED	NUMBER			Indicates the quantity received on the receipt.
INVENTORY_ITEM_ID	NUMBER	(15)	Yes	Foreign key to MTL_SYSTEM_ITEMS.inventory_item_id and this indicates the item for which the transaction is done.
SUBINVENTORY	VARCHAR2	(10)		The subinventory where the transaction is done.
REFERENCE_LINE_ID	NUMBER	(15)		Indicates WSH_DELIVERY_DETAILS. delivery_detail_id in case of Order Management and customer trx line identifier in case of Receivables.
PRIMARY_UOM_CODE	VARCHAR2	(3)		Primary unit of measure code of the inventory item in which the transaction is made.
TRANSACTION_UOM_CODE	VARCHAR2	(3)		Unit of Measure code of transaction for inventory item.
CUSTOMER_ID	NUMBER	(15)		Indicates the customer for which the issue transaction is made.
BILL_TO_SITE_ID	NUMBER	(15)		Indicates the bill to site identifier of Issue transaction that is, foreign key to RA_SITE_USES_ALL.site_use_id.
SHIP_TO_SITE_ID	NUMBER	(15)		Indicates the ship to site identifier. that is, foreign key to RA_SITE_USES_ALL.site_use_id.
QUANTITY_ISSUED	NUMBER			Indicates the quantity of issue transaction.
REGISTER_CODE	VARCHAR2	(30)		Indicates the register code of issue transaction. possible values 23D_DOMESTIC_EXCISE, 23D_DOM_WITHOUT_EXCISE.
RELEASED_DATE	DATE			Release date of the Issue.
COMM_INVOICE_NO	VARCHAR2	(30)		Indicates Supplier commercial invoice number for receipts and Customer Commercial Invoice for Issues
COMM_INVOICE_DATE	DATE			The date on which the invoice is created / generated whether it is receipt or issue.
RECEIPT_BOE_NUM	VARCHAR2	(150)		Indicates BOE number in case the receipt is import type.
OTH_RECEIPT_DATE	DATE			RMA receipt date.
OTH_RECEIPT_QUANTITY	NUMBER			RMA receipt quantity.
REMARKS	VARCHAR2	(100)		Indicates the remarks that have to be filled by user.
QTY_TO_ADJUST	NUMBER			Indicates the quantity that is remaining on the receipt.
RATE_PER_UNIT	NUMBER			Indicates the rate per unit of the item that is received.
EXCISE_DUTY_RATE	NUMBER			Basic excise duty rate as Percentage.
CHARGE_ACCOUNT_ID	NUMBER	(15)		Indicates the charge account for G 23 D Register.
CREATION_DATE	DATE			Standard Who column
CREATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
DUTY_AMOUNT	NUMBER			Indicates the total amount of duty.
RECEIPT_DATE	DATE			Indicates the receipt date for receipts.
GOODS_ISSUE_ID	NUMBER	(15)		Indicates the material transaction reference. foreign key to MTL_MATERIAL_TRANSACTIONS.transaction_id.
GOODS_ISSUE_DATE	DATE			The transaction date of material transaction. that is MTL_MATERIAL_TRANSACTIONS.transaction_date.
GOODS_ISSUE_QUANTITY	NUMBER			Indicates the material transaction quantity.
TRANSACTION_DATE	DATE			Indicates the transaction date.
OPENING_BALANCE_QTY	NUMBER			Indicates the opening balance when the transaction is made. that is closing balance of the previous transaction for the same organization, location, fin_year and item.
CLOSING_BALANCE_QTY	NUMBER			Indicates the closing balance after the transaction is made.
BASIC_ED	NUMBER			Amount of Basic Excise Duty.
ADDITIONAL_ED	NUMBER			Amount of Additional Excise Duty.
OTHER_ED	NUMBER			Amount of Special Excise Duty.
CVD	NUMBER			Amount of countervailing duty.
VENDOR_ID	NUMBER	(15)		Indicates the supplier identifier of the transaction.
VENDOR_SITE_ID	NUMBER	(15)		Indicates Vendor_site_id for which the transaction is made.
RECEIPT_NUM	VARCHAR2	(30)		Indicates receipt number of a PO Receipt.
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
CONSIGNEE	VARCHAR2	(2)		Indicates Consignee.
MANUFACTURER_NAME	VARCHAR2	(100)		Manufacturer name as entered by user.
MANUFACTURER_ADDRESS	VARCHAR2	(150)		Manufacturer address as entered by user.
MANUFACTURER_RATE_AMT_PER_UNIT	VARCHAR2	(50)		Rate per unit as entered by user
QTY_RECEIVED_FROM_MANUFACTURER	NUMBER			Quantity received from manufacturer as entered by user
TOT_AMT_PAID_TO_MANUFACTURER	NUMBER			Total amount paid to manufacturer as entered by user
REF_LINE_NO	NUMBER	(4)		Indicates reference line number
BOL_ID	NUMBER	(10)		Indicates bill of lading identifier in case of order fulfillment in OPM. This is no longer used
BOLLINE_NO	NUMBER	(5)		Indicates bill of lading line number in case of order fulfillment in OPM. This is no longer used.
OTHER_TAX_CREDIT	NUMBER			Tax Credit that is taken against tax types other than Excise, Addl. Excise, Other Excise and CVD
OTHER_TAX_DEBIT	NUMBER			Tax Debit that is taken against tax types other than Excise, Addl. Excise, Other Excise and CVD
RECEIPT_REF	NUMBER	(15)		Indicates the RCV_TRANSACTIONS.transaction_id in case of Receipt.
OTH_RECEIPT_ID_REF	NUMBER	(15)		RMA receipt identifier from RCV_TRANSACTIONS.
TRANSACTION_SOURCE_NUM	NUMBER	(15)		If this is a material transaction then this indicates MTL_MATERIAL_TRANSACTION.transaction_type_id. Otherwise the value is inserted with hard coding. Possible values 18 - Receipt, 33 - Sales Order Issue.
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number
ADDITIONAL_CVD	NUMBER	(38)		This column stores the Additional CVD Amount

Query Text

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


SELECT REGISTER_ID
,      ORGANIZATION_ID
,      LOCATION_ID
,      SLNO
,      FIN_YEAR
,      TRANSACTION_TYPE
,      QUANTITY_RECEIVED
,      INVENTORY_ITEM_ID
,      SUBINVENTORY
,      REFERENCE_LINE_ID
,      PRIMARY_UOM_CODE
,      TRANSACTION_UOM_CODE
,      CUSTOMER_ID
,      BILL_TO_SITE_ID
,      SHIP_TO_SITE_ID
,      QUANTITY_ISSUED
,      REGISTER_CODE
,      RELEASED_DATE
,      COMM_INVOICE_NO
,      COMM_INVOICE_DATE
,      RECEIPT_BOE_NUM
,      OTH_RECEIPT_DATE
,      OTH_RECEIPT_QUANTITY
,      REMARKS
,      QTY_TO_ADJUST
,      RATE_PER_UNIT
,      EXCISE_DUTY_RATE
,      CHARGE_ACCOUNT_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      DUTY_AMOUNT
,      RECEIPT_DATE
,      GOODS_ISSUE_ID
,      GOODS_ISSUE_DATE
,      GOODS_ISSUE_QUANTITY
,      TRANSACTION_DATE
,      OPENING_BALANCE_QTY
,      CLOSING_BALANCE_QTY
,      BASIC_ED
,      ADDITIONAL_ED
,      OTHER_ED
,      CVD
,      VENDOR_ID
,      VENDOR_SITE_ID
,      RECEIPT_NUM
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      CONSIGNEE
,      MANUFACTURER_NAME
,      MANUFACTURER_ADDRESS
,      MANUFACTURER_RATE_AMT_PER_UNIT
,      QTY_RECEIVED_FROM_MANUFACTURER
,      TOT_AMT_PAID_TO_MANUFACTURER
,      REF_LINE_NO
,      BOL_ID
,      BOLLINE_NO
,      OTHER_TAX_CREDIT
,      OTHER_TAX_DEBIT
,      RECEIPT_REF
,      OTH_RECEIPT_ID_REF
,      TRANSACTION_SOURCE_NUM
,      OBJECT_VERSION_NUMBER
,      ADDITIONAL_CVD
FROM JA.JAI_CMN_RG_23D_TRXS;

Dependencies

[top of page]

JA.JAI_CMN_RG_23D_TRXS does not reference any database object

JA.JAI_CMN_RG_23D_TRXS is referenced by following:

APPS: JAI_CMN_RG_23D_TRXS