[Home] [Help] [Dependency Information]
Object Name: | INL_TAX_LINES# |
---|---|
Object Type: | VIEW |
Owner: | INL |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TAX_LINE_ID | NUMBER | Yes | ||
TAX_LINE_NUM | NUMBER | Yes | ||
TAX_CODE | VARCHAR2 | (30) | Yes | |
SHIP_HEADER_ID | NUMBER | |||
PARENT_TAX_LINE_ID | NUMBER | |||
ADJUSTMENT_NUM | NUMBER | Yes | ||
MATCH_ID | NUMBER | |||
MATCH_AMOUNT_ID | NUMBER | |||
SOURCE_PARENT_TABLE_NAME | VARCHAR2 | (30) | Yes | |
SOURCE_PARENT_TABLE_ID | NUMBER | Yes | ||
TAX_AMT | NUMBER | Yes | ||
NREC_TAX_AMT | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (15) | ||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_DATE | DATE | |||
CURRENCY_CONVERSION_RATE | NUMBER | |||
TAX_AMT_INCLUDED_FLAG | VARCHAR2 | (1) | ||
CREATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT TAX_LINE_ID
, TAX_LINE_NUM
, TAX_CODE
, SHIP_HEADER_ID
, PARENT_TAX_LINE_ID
, ADJUSTMENT_NUM
, MATCH_ID
, MATCH_AMOUNT_ID
, SOURCE_PARENT_TABLE_NAME
, SOURCE_PARENT_TABLE_ID
, TAX_AMT
, NREC_TAX_AMT
, CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE
, TAX_AMT_INCLUDED_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM INL.INL_TAX_LINES#;
|
|
|