[Home] [Help] [Dependency Information]
Object Name: | JAI_AR_SUP_LINES# |
---|---|
Object Type: | VIEW |
Owner: | JA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOMER_TRX_ID | NUMBER | (15) | Yes | |
CUSTOMER_TRX_LINE_ID | NUMBER | (15) | Yes | |
LINE_NUMBER | NUMBER | |||
SUP_INV_TYPE | VARCHAR2 | (3) | Yes | |
INVENTORY_ITEM_ID | NUMBER | (15) | ||
DESCRIPTION | VARCHAR2 | (240) | ||
QUANTITY | NUMBER | |||
UNIT_CODE | VARCHAR2 | (3) | ||
TAX_CATEGORY_ID | NUMBER | |||
OLD_SELLING_PRICE | NUMBER | |||
NEW_SELLING_PRICE | NUMBER | |||
EXIST_LINE_AMT | NUMBER | |||
EXIST_EXCISE_AMT | NUMBER | |||
EXIST_OTHER_AMT | NUMBER | |||
NEW_LINE_AMT | NUMBER | |||
NEW_EXCISE_AMT | NUMBER | |||
NEW_OTHER_AMT | NUMBER | |||
OLD_ASSESSABLE_VALUE | NUMBER | |||
NEW_ASSESSABLE_VALUE | NUMBER | |||
PL_MAPPING_ID | NUMBER | (15) | ||
AL_MAPPING_ID | NUMBER | (15) | ||
LINE_DIFF_AMT | NUMBER | |||
EXCISE_DIFF_AMT | NUMBER | |||
OTHER_DIFF_AMT | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
INTERFACE_LINE_ATTRIBUTE2 | VARCHAR2 | (22) | ||
OBJECT_VERSION_NUMBER | 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#;
|
|
|