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

TABLE: JA.JAI_AR_SUP_LINES

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


This table stores the Supplementary Transaction details of the individual items along with the Original Invoice details.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_AR_SUP_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_TRX_ID
ColumnCUSTOMER_TRX_LINE_ID
JAI_AR_SUP_LINES_PK NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_TRX_LINE_ID
Columns
Name Datatype Length Mandatory Comments
CUSTOMER_TRX_ID NUMBER (15) Yes Indicates the Customer transaction identifier of the Invoice.
CUSTOMER_TRX_LINE_ID NUMBER (15) Yes Indicates the customer transaction line identifier of the invoice line.
LINE_NUMBER NUMBER

Indicates the Line number of the current line in the invoice.
SUP_INV_TYPE VARCHAR2 (3) Yes Indicates the Supplementary Invoice Type.
INVENTORY_ITEM_ID NUMBER (15)
Indicates the Inventory Item Identifier.
DESCRIPTION VARCHAR2 (240)
Indicates description of the Line.
QUANTITY NUMBER

Indicates the number of items in the current line.
UNIT_CODE VARCHAR2 (3)
Indicates the UOM code of the Item of the current line.
TAX_CATEGORY_ID NUMBER

Indicates the tax category identifier of the current line.
OLD_SELLING_PRICE NUMBER

Indicates the old selling price.
NEW_SELLING_PRICE NUMBER

Indicates the new selling price.
EXIST_LINE_AMT NUMBER

Indicates the old-line amount.
EXIST_EXCISE_AMT NUMBER

Indicates the old excise amount.
EXIST_OTHER_AMT NUMBER

Indicates the old other amount.
NEW_LINE_AMT NUMBER

Indicates the new line amount.
NEW_EXCISE_AMT NUMBER

Indicates the new excise amount.
NEW_OTHER_AMT NUMBER

Indicates the old other amount.
OLD_ASSESSABLE_VALUE NUMBER

Indicates the old assessable value.
NEW_ASSESSABLE_VALUE NUMBER

Indicates the new assessable value.
PL_MAPPING_ID NUMBER (15)
Indicates the price list-mapping identifier.
AL_MAPPING_ID NUMBER (15)
Indicates the assessable price list-mapping identifier.
LINE_DIFF_AMT NUMBER

Indicates the difference between the old-line amount and the new line amount.
EXCISE_DIFF_AMT NUMBER

Indicates the difference between the old excise amount and the new excise amount.
OTHER_DIFF_AMT NUMBER

Indicates the difference between the old Other amount and the new Other amount.
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
INTERFACE_LINE_ATTRIBUTE2 VARCHAR2 (22)
Unique identifier for line transaction flexfield
OBJECT_VERSION_NUMBER NUMBER

Object version Number
Query Text

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


SELECT CUSTOMER_TRX_ID
,      CUSTOMER_TRX_LINE_ID
,      LINE_NUMBER
,      SUP_INV_TYPE
,      INVENTORY_ITEM_ID
,      DESCRIPTION
,      QUANTITY
,      UNIT_CODE
,      TAX_CATEGORY_ID
,      OLD_SELLING_PRICE
,      NEW_SELLING_PRICE
,      EXIST_LINE_AMT
,      EXIST_EXCISE_AMT
,      EXIST_OTHER_AMT
,      NEW_LINE_AMT
,      NEW_EXCISE_AMT
,      NEW_OTHER_AMT
,      OLD_ASSESSABLE_VALUE
,      NEW_ASSESSABLE_VALUE
,      PL_MAPPING_ID
,      AL_MAPPING_ID
,      LINE_DIFF_AMT
,      EXCISE_DIFF_AMT
,      OTHER_DIFF_AMT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      INTERFACE_LINE_ATTRIBUTE2
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_AR_SUP_LINES;

Dependencies

[top of page]

JA.JAI_AR_SUP_LINES does not reference any database object

JA.JAI_AR_SUP_LINES is referenced by following:

SchemaJA
ViewJAI_AR_SUP_LINES#