[Home] [Help] [Dependency Information]
Object Name: | INL_CHARGE_LINES# |
---|---|
Object Type: | VIEW |
Owner: | INL |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CHARGE_LINE_ID | NUMBER | Yes | ||
CHARGE_LINE_NUM | NUMBER | Yes | ||
CHARGE_LINE_TYPE_ID | NUMBER | Yes | ||
LANDED_COST_FLAG | VARCHAR2 | (1) | Yes | |
UPDATE_ALLOWED | VARCHAR2 | (1) | ||
SOURCE_CODE | VARCHAR2 | (25) | ||
PARENT_CHARGE_LINE_ID | NUMBER | |||
ADJUSTMENT_NUM | NUMBER | Yes | ||
MATCH_ID | NUMBER | |||
MATCH_AMOUNT_ID | NUMBER | |||
CHARGE_AMT | NUMBER | Yes | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_DATE | DATE | |||
CURRENCY_CONVERSION_RATE | NUMBER | |||
PARTY_ID | NUMBER | |||
PARTY_SITE_ID | NUMBER | |||
TRX_BUSINESS_CATEGORY | VARCHAR2 | (240) | ||
INTENDED_USE | VARCHAR2 | (30) | ||
PRODUCT_FISCAL_CLASS | VARCHAR2 | (240) | ||
PRODUCT_CATEGORY | VARCHAR2 | (240) | ||
PRODUCT_TYPE | VARCHAR2 | (240) | ||
USER_DEF_FISCAL_CLASS | VARCHAR2 | (240) | ||
TAX_CLASSIFICATION_CODE | VARCHAR2 | (30) | ||
ASSESSABLE_VALUE | NUMBER | |||
TAX_ALREADY_CALCULATED_FLAG | VARCHAR2 | (1) | ||
SHIP_FROM_PARTY_ID | NUMBER | |||
SHIP_FROM_PARTY_SITE_ID | NUMBER | |||
SHIP_TO_ORGANIZATION_ID | NUMBER | |||
SHIP_TO_LOCATION_ID | NUMBER | |||
BILL_FROM_PARTY_ID | NUMBER | |||
BILL_FROM_PARTY_SITE_ID | NUMBER | |||
BILL_TO_ORGANIZATION_ID | NUMBER | |||
BILL_TO_LOCATION_ID | NUMBER | |||
POA_PARTY_ID | NUMBER | |||
POA_PARTY_SITE_ID | NUMBER | |||
POO_ORGANIZATION_ID | NUMBER | |||
POO_LOCATION_ID | NUMBER | |||
CREATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
NEW_CHARGE_AMT | NUMBER | |||
NEW_CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
NEW_CURRENCY_CONVERSION_DATE | DATE | |||
NEW_CURRENCY_CONVERSION_RATE | NUMBER | |||
ADJUSTMENT_TYPE_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT CHARGE_LINE_ID
, CHARGE_LINE_NUM
, CHARGE_LINE_TYPE_ID
, LANDED_COST_FLAG
, UPDATE_ALLOWED
, SOURCE_CODE
, PARENT_CHARGE_LINE_ID
, ADJUSTMENT_NUM
, MATCH_ID
, MATCH_AMOUNT_ID
, CHARGE_AMT
, CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE
, PARTY_ID
, PARTY_SITE_ID
, TRX_BUSINESS_CATEGORY
, INTENDED_USE
, PRODUCT_FISCAL_CLASS
, PRODUCT_CATEGORY
, PRODUCT_TYPE
, USER_DEF_FISCAL_CLASS
, TAX_CLASSIFICATION_CODE
, ASSESSABLE_VALUE
, TAX_ALREADY_CALCULATED_FLAG
, SHIP_FROM_PARTY_ID
, SHIP_FROM_PARTY_SITE_ID
, SHIP_TO_ORGANIZATION_ID
, SHIP_TO_LOCATION_ID
, BILL_FROM_PARTY_ID
, BILL_FROM_PARTY_SITE_ID
, BILL_TO_ORGANIZATION_ID
, BILL_TO_LOCATION_ID
, POA_PARTY_ID
, POA_PARTY_SITE_ID
, POO_ORGANIZATION_ID
, POO_LOCATION_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, NEW_CHARGE_AMT
, NEW_CURRENCY_CONVERSION_TYPE
, NEW_CURRENCY_CONVERSION_DATE
, NEW_CURRENCY_CONVERSION_RATE
, ADJUSTMENT_TYPE_FLAG
FROM INL.INL_CHARGE_LINES#;
|
|
|