[Home] [Help] [Dependency Information]
Object Name: | JAI_AR_SUP_LINES |
---|---|
Object Type: | TABLE |
Owner: | JA |
FND Design Data: | JA.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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JAI_AR_SUP_LINES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CUSTOMER_TRX_ID
CUSTOMER_TRX_LINE_ID |
JAI_AR_SUP_LINES_PK | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CUSTOMER_TRX_LINE_ID |
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 |
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;
JA.JAI_AR_SUP_LINES does not reference any database object
JA.JAI_AR_SUP_LINES is referenced by following:
|
|
|