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_AR_TRX_LINES

Object Details

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

Stores information about the transaction lines.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_AR_TRX_LINES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CUSTOMER_TRX_LINE_ID
JAI_AR_TRX_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXCISE_INVOICE_NO
JAI_AR_TRX_LINES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_TRX_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CUSTOMER_TRX_LINE_ID	NUMBER	(15)	Yes	Customer Transaction line identifier.
CUSTOMER_TRX_ID	NUMBER		Yes	Customer Transaction identifier . Uniquely relates a record in this table to that of the ja_in_ra_customer_trx.
LINE_NUMBER	NUMBER			Line Number.
INVENTORY_ITEM_ID	NUMBER	(15)		Inventory item identifier.
DESCRIPTION	VARCHAR2	(240)		Description.
UNIT_CODE	VARCHAR2	(3)		Unit Code.
QUANTITY	NUMBER			Quantity of Inventory items taken.
UNIT_SELLING_PRICE	NUMBER			Unit Selling price of the Inventory item.
TAX_CATEGORY_ID	NUMBER	(15)		Tax category Identifier.
LINE_AMOUNT	NUMBER			Total Amount for the quantity taken for a line.
TAX_AMOUNT	NUMBER			Tax amount associated with the inventory item.
TOTAL_AMOUNT	NUMBER			Sum of amount for the tax amount and the line amount.
GL_DATE	DATE			GL Date for Invoice.
AUTO_INVOICE_FLAG	VARCHAR2	(1)		Auto Invoice Flag.
ASSESSABLE_VALUE	NUMBER			Value for calculating excise.
PAYMENT_REGISTER	VARCHAR2	(30)		Payment register used.
EXCISE_INVOICE_NO	VARCHAR2	(200)		Excise Invoice Number, to identify the excise records related to this record from the table ja_in_excise_invoice.
EXCISE_INVOICE_DATE	DATE			Date when the excise Invoice for this line was created.
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
PREPRINTED_EXCISE_INV_NO	VARCHAR2	(50)		Preprinted Excise Invoice Number.
EXCISE_EXEMPT_TYPE	VARCHAR2	(60)		Identifies Excise Exempted type like CT2, CT3 etc.,.
EXCISE_EXEMPT_REFNO	VARCHAR2	(30)		Excise Exempt reference no.
EXCISE_EXEMPT_DATE	DATE			Excise Exempt reference date.
AR3_FORM_NO	VARCHAR2	(30)		AR3 form number.
AR3_FORM_DATE	DATE			AR3 form date.
VAT_EXEMPTION_FLAG	VARCHAR2	(1)		Flag to indicate if the line is exempted from VAT type of taxes.
VAT_EXEMPTION_TYPE	VARCHAR2	(30)		VAT exemption type.
VAT_EXEMPTION_DATE	DATE			VAT exemption Date.
VAT_EXEMPTION_REFNO	VARCHAR2	(100)		VAT exemption refund.
VAT_ASSESSABLE_VALUE	NUMBER			Assessable value to be used for calulating VAT taxes.
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number
SERVICE_TYPE_CODE	VARCHAR2	(30)		Indicates the service type for the AR transaction Line
VAT_REVERSAL_PRICE	NUMBER			Indicates the price to be used for calculation of VAT Reversal Tax

Query Text

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


SELECT CUSTOMER_TRX_LINE_ID
,      CUSTOMER_TRX_ID
,      LINE_NUMBER
,      INVENTORY_ITEM_ID
,      DESCRIPTION
,      UNIT_CODE
,      QUANTITY
,      UNIT_SELLING_PRICE
,      TAX_CATEGORY_ID
,      LINE_AMOUNT
,      TAX_AMOUNT
,      TOTAL_AMOUNT
,      GL_DATE
,      AUTO_INVOICE_FLAG
,      ASSESSABLE_VALUE
,      PAYMENT_REGISTER
,      EXCISE_INVOICE_NO
,      EXCISE_INVOICE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PREPRINTED_EXCISE_INV_NO
,      EXCISE_EXEMPT_TYPE
,      EXCISE_EXEMPT_REFNO
,      EXCISE_EXEMPT_DATE
,      AR3_FORM_NO
,      AR3_FORM_DATE
,      VAT_EXEMPTION_FLAG
,      VAT_EXEMPTION_TYPE
,      VAT_EXEMPTION_DATE
,      VAT_EXEMPTION_REFNO
,      VAT_ASSESSABLE_VALUE
,      OBJECT_VERSION_NUMBER
,      SERVICE_TYPE_CODE
,      VAT_REVERSAL_PRICE
FROM JA.JAI_AR_TRX_LINES;

Dependencies

[top of page]

JA.JAI_AR_TRX_LINES does not reference any database object

JA.JAI_AR_TRX_LINES is referenced by following:

APPS: JAI_AR_TRX_LINES; JAI_JAR_TL_ARIUD_T1