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: TableJA.JAI_AR_TRX_LINES
Subobject Name:
Status: VALID


Stores information about the transaction lines.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_AR_TRX_LINES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_TRX_LINE_ID
JAI_AR_TRX_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEXCISE_INVOICE_NO
JAI_AR_TRX_LINES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_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
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield context field
GST_ASSESSABLE_VALUE NUMBER

GST Assessable Value
GST_INVOICE_NO VARCHAR2 (150)
GST Invoice Number
GST_INVOICE_DATE DATE

GST Invoice Date
INTERFACE_FLAG VARCHAR2 (1)
Identifier of data from Open interface
INTERFACE_EVENT VARCHAR2 (20)
STANDARD or EXTERNAL
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
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      GST_ASSESSABLE_VALUE
,      GST_INVOICE_NO
,      GST_INVOICE_DATE
,      INTERFACE_FLAG
,      INTERFACE_EVENT
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:

SchemaJA
ViewJAI_AR_TRX_LINES#