VIEW: INL.INL_CHARGE_LINES#

Source

View Text - Preformatted

select CHARGE_LINE_ID CHARGE_LINE_ID, CHARGE_LINE_NUM CHARGE_LINE_NUM, CHARGE_LINE_TYPE_ID CHARGE_LINE_TYPE_ID, LANDED_COST_FLAG LANDED_COST_FLAG, UPDATE_ALLOWED UPDATE_ALLOWED, SOURCE_CODE SOURCE_CODE, PARENT_CHARGE_LINE_ID PARENT_CHARGE_LINE_ID, ADJUSTMENT_NUM ADJUSTMENT_NUM, MATCH_ID MATCH_ID, MATCH_AMOUNT_ID MATCH_AMOUNT_ID, CHARGE_AMT CHARGE_AMT, CURRENCY_CODE CURRENCY_CODE, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, PARTY_ID PARTY_ID, PARTY_SITE_ID PARTY_SITE_ID, TRX_BUSINESS_CATEGORY TRX_BUSINESS_CATEGORY, INTENDED_USE INTENDED_USE, PRODUCT_FISCAL_CLASS PRODUCT_FISCAL_CLASS, PRODUCT_CATEGORY PRODUCT_CATEGORY, PRODUCT_TYPE PRODUCT_TYPE, USER_DEF_FISCAL_CLASS USER_DEF_FISCAL_CLASS, TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE, ASSESSABLE_VALUE ASSESSABLE_VALUE, TAX_ALREADY_CALCULATED_FLAG TAX_ALREADY_CALCULATED_FLAG, SHIP_FROM_PARTY_ID SHIP_FROM_PARTY_ID, SHIP_FROM_PARTY_SITE_ID SHIP_FROM_PARTY_SITE_ID, SHIP_TO_ORGANIZATION_ID SHIP_TO_ORGANIZATION_ID, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, BILL_FROM_PARTY_ID BILL_FROM_PARTY_ID, BILL_FROM_PARTY_SITE_ID BILL_FROM_PARTY_SITE_ID, BILL_TO_ORGANIZATION_ID BILL_TO_ORGANIZATION_ID, BILL_TO_LOCATION_ID BILL_TO_LOCATION_ID, POA_PARTY_ID POA_PARTY_ID, POA_PARTY_SITE_ID POA_PARTY_SITE_ID, POO_ORGANIZATION_ID POO_ORGANIZATION_ID, POO_LOCATION_ID POO_LOCATION_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, NEW_CHARGE_AMT NEW_CHARGE_AMT, NEW_CURRENCY_CONVERSION_TYPE NEW_CURRENCY_CONVERSION_TYPE, NEW_CURRENCY_CONVERSION_DATE NEW_CURRENCY_CONVERSION_DATE, NEW_CURRENCY_CONVERSION_RATE NEW_CURRENCY_CONVERSION_RATE, ADJUSTMENT_TYPE_FLAG ADJUSTMENT_TYPE_FLAG from "INL"."INL_CHARGE_LINES"

View Text - HTML Formatted

SELECT CHARGE_LINE_ID CHARGE_LINE_ID
, CHARGE_LINE_NUM CHARGE_LINE_NUM
, CHARGE_LINE_TYPE_ID CHARGE_LINE_TYPE_ID
, LANDED_COST_FLAG LANDED_COST_FLAG
, UPDATE_ALLOWED UPDATE_ALLOWED
, SOURCE_CODE SOURCE_CODE
, PARENT_CHARGE_LINE_ID PARENT_CHARGE_LINE_ID
, ADJUSTMENT_NUM ADJUSTMENT_NUM
, MATCH_ID MATCH_ID
, MATCH_AMOUNT_ID MATCH_AMOUNT_ID
, CHARGE_AMT CHARGE_AMT
, CURRENCY_CODE CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, PARTY_ID PARTY_ID
, PARTY_SITE_ID PARTY_SITE_ID
, TRX_BUSINESS_CATEGORY TRX_BUSINESS_CATEGORY
, INTENDED_USE INTENDED_USE
, PRODUCT_FISCAL_CLASS PRODUCT_FISCAL_CLASS
, PRODUCT_CATEGORY PRODUCT_CATEGORY
, PRODUCT_TYPE PRODUCT_TYPE
, USER_DEF_FISCAL_CLASS USER_DEF_FISCAL_CLASS
, TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE
, ASSESSABLE_VALUE ASSESSABLE_VALUE
, TAX_ALREADY_CALCULATED_FLAG TAX_ALREADY_CALCULATED_FLAG
, SHIP_FROM_PARTY_ID SHIP_FROM_PARTY_ID
, SHIP_FROM_PARTY_SITE_ID SHIP_FROM_PARTY_SITE_ID
, SHIP_TO_ORGANIZATION_ID SHIP_TO_ORGANIZATION_ID
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, BILL_FROM_PARTY_ID BILL_FROM_PARTY_ID
, BILL_FROM_PARTY_SITE_ID BILL_FROM_PARTY_SITE_ID
, BILL_TO_ORGANIZATION_ID BILL_TO_ORGANIZATION_ID
, BILL_TO_LOCATION_ID BILL_TO_LOCATION_ID
, POA_PARTY_ID POA_PARTY_ID
, POA_PARTY_SITE_ID POA_PARTY_SITE_ID
, POO_ORGANIZATION_ID POO_ORGANIZATION_ID
, POO_LOCATION_ID POO_LOCATION_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, NEW_CHARGE_AMT NEW_CHARGE_AMT
, NEW_CURRENCY_CONVERSION_TYPE NEW_CURRENCY_CONVERSION_TYPE
, NEW_CURRENCY_CONVERSION_DATE NEW_CURRENCY_CONVERSION_DATE
, NEW_CURRENCY_CONVERSION_RATE NEW_CURRENCY_CONVERSION_RATE
, ADJUSTMENT_TYPE_FLAG ADJUSTMENT_TYPE_FLAG
FROM "INL"."INL_CHARGE_LINES"